TPS
Tables (4)
dbo.FTF_CMM_BANK
- SEQ — numeric(16,0) — Primary key — NOT NULL
- STAT_CD — nvarchar(2) — NOT NULL
- CREA_BRAN — nvarchar(4) — NOT NULL
- CREA_DATE — nvarchar(10) — NOT NULL
- CREA_USER — nvarchar(10) — NOT NULL
- DELE_BRAN — nvarchar(4)
- DELE_DATE — nvarchar(10)
- DELE_USER — nvarchar(10)
- UPDA_BRAN — nvarchar(4) — NOT NULL
- UPDA_USER — nvarchar(10) — NOT NULL
- UPDA_TIME — datetime — NOT NULL
- REMS — nvarchar(250)
- BANK_NO — nvarchar(20) — NOT NULL
- BIC — nvarchar(11) — NOT NULL
- BANK_NAME — nvarchar(70) — NOT NULL
- BANK_SHRT_NAME — nvarchar(70)
- BRAN_NAME — nvarchar(70)
- BANK_ADDR1 — nvarchar(70)
- BANK_ADDR2 — nvarchar(70)
- BANK_ADDR3 — nvarchar(70)
- BANK_TYPE_CD — nvarchar(3)
- HEAD_CTRY_CD — nvarchar(2)
- CTRY_CD — nvarchar(2)
- OLD_REFN_NO — nvarchar(20)
- MIG_USER — nvarchar(20)
- GRID_NO — nvarchar(20)
dbo.FTF_CMM_BANK_CORR
- SEQ — numeric(16,0) — Primary key — NOT NULL
- SEQ_BANK — numeric(16,0) — NOT NULL
- SEQ_CUST — numeric(16,0) — NOT NULL
- STAT_CD — nvarchar(2) — NOT NULL
- CREA_BRAN — nvarchar(4) — NOT NULL
- CREA_DATE — nvarchar(10) — NOT NULL
- CREA_USER — nvarchar(10) — NOT NULL
- DELE_BRAN — nvarchar(4)
- DELE_DATE — nvarchar(10)
- DELE_USER — nvarchar(10)
- UPDA_BRAN — nvarchar(4) — NOT NULL
- UPDA_USER — nvarchar(10) — NOT NULL
- UPDA_TIME — datetime — NOT NULL
- REMS — nvarchar(250)
- BIC — nvarchar(11) — NOT NULL
- CUST_NO — nvarchar(11) — NOT NULL
- CORR_BGN_DATE — nvarchar(10) — NOT NULL
- CORR_END_DATE — nvarchar(10) — NOT NULL
dbo.FTF_EXP_NEGO_APP
- YYYY — nvarchar(4) — Primary key — NOT NULL
- SEQ — numeric(16,0) — Primary key — NOT NULL
- NEGO_APP_SEQ — nvarchar(20) — NOT NULL
- STAT_CD — nvarchar(2) — NOT NULL
- CREA_BRAN — nvarchar(4) — NOT NULL
- CREA_DATE — nvarchar(10) — NOT NULL
- CREA_USER — nvarchar(10) — NOT NULL
- DELE_BRAN — nvarchar(4)
- DELE_DATE — nvarchar(10)
- DELE_USER — nvarchar(10)
- UPDA_BRAN — nvarchar(4)
- UPDA_USER — nvarchar(10) — NOT NULL
- UPDA_TIME — datetime — NOT NULL
- GUBUN — nvarchar(1) — NOT NULL
- APP_DATE — nvarchar(10)
- OURREF — nvarchar(30)
- APPNEG_SEQ — numeric(16,0)
- MAINT_NO — nvarchar(30)
- AMT2C — nvarchar(3)
- AMT2 — numeric(21,3)
- NET_AMT — numeric(21,3)
- RATEMENT — numeric(21,3)
- RATE — numeric(14,9)
- DAYS — numeric(5,0)
- MATU_DATE — nvarchar(10)
- MS_NAME1 — nvarchar(140) — NOT NULL
- TRM_PAY — nvarchar(200)
- TOD_G — nvarchar(30)
- EXP_NO — nvarchar(30)
- HS_NO — nvarchar(30)
- DEST_CD — nvarchar(2)
- SN — nvarchar(30)
- BEFORE_AMT2C — nvarchar(3)
- BEFORE_AMT2 — numeric(21,3)
- CURR — numeric(14,9)
- LOAD_D — nvarchar(100)
- DEST_D — nvarchar(100)
- SH_DATE — nvarchar(10)
- LC_G — nvarchar(3)
- LC_NO — nvarchar(80)
- TRM_PAYC — nvarchar(3)
- BR_CD — nvarchar(3)
- REMARK1 — nvarchar(250)
- PAYORD3 — numeric(21,3)
- PAYORD3C — nvarchar(10)
- RATE3 — numeric(14,9)
- PAYORD31 — numeric(21,3)
- PRDT_TYPE — nvarchar(2)
- CONV_YN — nvarchar(1)
- DRWR_NO — nvarchar(11)
- DRWE_NO — nvarchar(11)
- COLL_FG — nvarchar(1)
- REPR_YN — nvarchar(1)
- ACCT_EVNT_CD — nvarchar(20)
- NEGO_KIND_CD — nvarchar(2)
- COLL_BANK_CD — nvarchar(11)
- FRST_NEGO_BANK_CD — nvarchar(11)
- COLL_BANK_INFO — nvarchar(140)
- FRST_NEGO_BANK_INFO — nvarchar(140)
- DEAL_DATE — nvarchar(10)
- … +15
dbo.FTF_EXP_NLC_MAST
- YYYY — nvarchar(4) — Primary key — NOT NULL
- SEQ — numeric(16,0) — Primary key — NOT NULL
- NLC_SEQ — nvarchar(20) — NOT NULL — key
- STAT_CD — nvarchar(2) — NOT NULL
- CREA_BRAN — nvarchar(4) — NOT NULL
- CREA_DATE — nvarchar(10) — NOT NULL
- CREA_USER — nvarchar(10) — NOT NULL
- DELE_BRAN — nvarchar(4)
- DELE_DATE — nvarchar(10)
- DELE_USER — nvarchar(10)
- VERI_BRAN — nvarchar(4)
- VERI_DATE — nvarchar(10)
- VERI_USER — nvarchar(10)
- CNCL_BRAN — nvarchar(4)
- CNCL_DATE — nvarchar(10)
- CNCL_USER — nvarchar(10)
- UPDA_BRAN — nvarchar(4)
- UPDA_USER — nvarchar(10) — NOT NULL
- UPDA_TIME — datetime — NOT NULL
- VERI_TRXN_YN — nvarchar(1) — NOT NULL
- VERI_YN — nvarchar(1) — NOT NULL
- REMS — nvarchar(250)
- ACCT_EVNT_CD — nvarchar(20)
- OUR_REFR_NO — nvarchar(20)
- CONT_NO — nvarchar(100)
- CONT_DATE — nvarchar(10) — NOT NULL
- CONT_CURR — nvarchar(3) — NOT NULL
- CONT_AMNT — numeric(21,3) — NOT NULL
- CONT_BALN — numeric(21,3) — NOT NULL
- DRWR_NO — nvarchar(11) — NOT NULL
- DRWE_NO — nvarchar(11)
- DRWE_INFO — nvarchar(80) — NOT NULL
- PYMNT_TERM — nvarchar(200)
- HS_CD — nvarchar(20)
- LAST_SHIP_DATE — nvarchar(10)
- LOAD_PORT — nvarchar(65)
- DEST_PORT — nvarchar(65)
- CTRY_CD — nvarchar(2)
- EDI_YN — nvarchar(1) — NOT NULL
- EDI_SN — nvarchar(30)
- NLC_NO — nvarchar(20)
- LEGA_REFN_NO — nvarchar(30)
- MAINT_NO — nvarchar(30)
- MIG_USER — nvarchar(10)