CMA_MES
Tables (4)
WR_1000
- WORK_DATE — char(8) — Primary key — NOT NULL
- SQEN_NUMB — char(6) — Primary key — NOT NULL
- INVO_GUBN — varchar(1)
- JSNO — char(9) — NOT NULL
- REPE_JSNO — varchar(9)
- JSNO_NUMB — varchar(9)
- ESTM_NUMB — varchar(20)
- ESTM_RNUM — varchar(30)
- EXPT_NUMB — varchar(30)
- JPSU_DATE — char(8) — NOT NULL
- PINO_NUMB — varchar(20)
- PINO_RNUM — varchar(20)
- PINO_REFE — varchar(20)
- CNFM_DATE — varchar(8)
- DUEE_DATE — char(8) — NOT NULL
- DUEE_XXXX — varchar(5) — NOT NULL
- PREV_DUEE — char(8)
- JSNO_GUBN — varchar(2)
- ORDR_GUBN — varchar(2)
- PAYS_METH — varchar(2)
- COMB_GUBN — char(1)
- ITEM_GUBN — varchar(2)
- ITEM_FMLY — varchar(10)
- SALE_MTHD — varchar(10)
- BUYR_CODE — varchar(8)
- BUYR_ADCO — varchar(5)
- BUYR_ADDR — varchar(500)
- BUYR_EMPL — varchar(50)
- CUST_CODE — varchar(8)
- CTRY_CODE — varchar(5)
- REGN_GUBN — varchar(10)
- VATT_NUMB — varchar(20)
- TRAN_GUBN — varchar(2)
- TRAN_CODE — varchar(4)
- TRAN_COND — varchar(2)
- DEST_NAME — nvarchar(50)
- TRAN_REGN — nvarchar(50)
- PYMT_GUBN — varchar(2)
- CMAA_BANK — varchar(5)
- AMNT_UNIT — varchar(5)
- ITEM_AMNT — decimal(20, 4)
- EXCN_RATE — decimal(20, 4)
- NEGO_RATE — decimal(20, 4)
- KRWW_AMNT — decimal(20, 4)
- TRAN_AMNT — decimal(20, 4)
- FRGN_TOTL — decimal(20, 4)
- KRWW_TOTL — decimal(20, 4)
- SALE_DAMM — varchar(20)
- OPER_DAMM — varchar(20)
- PUBL_DAMM — varchar(20)
- TEAM_GUBN — varchar(10)
- PREV_JSNO — varchar(9)
- MEMO_XXXX — nvarchar(1000)
- CNFM_0001 — varchar(20)
- CNFM_DAT1 — datetime
- CNFM_0002 — varchar(20)
- CNFM_DAT2 — datetime
- CNFM_0003 — varchar(20)
- CNFM_DAT3 — datetime
- CNFM_0004 — varchar(20)
- … +30
WR_1001
- WORK_DATE — char(8) — Primary key — NOT NULL
- HEAD_NUMB — char(6) — Primary key — NOT NULL
- SQEN_NUMB — char(6) — Primary key — NOT NULL
- JSNO — char(9) — NOT NULL
- JKJI_NUMB — char(9) — NOT NULL
- PROC_NUMB — char(9) — NOT NULL
- PONO_NUMB — varchar(20)
- COMB_SETT — varchar(5)
- ITEM_CODE — varchar(11)
- ITEM_STAN — nvarchar(30)
- BUYE_ITEM — varchar(30)
- MODL_NUMB — nvarchar(30)
- DEGN_NAME — nvarchar(30)
- COLR_NAME — nvarchar(30)
- FILE_PATH — nvarchar(200)
- TOTL_QNTY — decimal(14, 4)
- TOTL_UNIT — varchar(2)
- PROC_QNTY — decimal(14, 4)
- RECV_QNTY — decimal(14, 4)
- RECV_GUBN — char(1)
- PAYS_METH — varchar(2)
- ITEM_GUBN — varchar(2)
- AMNT_GUBN — varchar(2)
- UNIT_AMNT — decimal(14, 4)
- UNIT_TAXX — decimal(14, 4)
- QNTY_UNIT — varchar(2)
- SETT_AMNT — decimal(14, 4)
- ITEM_AMNT — decimal(14, 4)
- KRWW_AMNT — decimal(14, 4)
- KRWW_SUMM — decimal(14, 4)
- IMGE_VALU — varchar(1)
- SAMP_DATE — nvarchar(50)
- SAMP_MEMO — nvarchar(100)
- PREV_JSNO — nvarchar(9)
- PREV_JKJI — nchar(9)
- HSNO_NUMB — nvarchar(50)
- LOSS_QNTY — decimal(14, 4)
- PROC_USE1 — varchar(50)
- PROC_USE2 — varchar(50)
- PROC_USE3 — varchar(50)
- PUBL_DATE — nvarchar(8)
- PUBL_CHCK — char(1)
- BALJ_DATE — char(8)
- BALJ_GUBN — char(1)
- MEMO_XXXX — nvarchar(1000)
- SAMP_USEE — varchar(2)
- SAMP_QTY1 — decimal(14, 4)
- SAMP_QTY2 — decimal(14, 4)
- SAMP_RESN — varchar(2)
- SAMP_CORI — varchar(2)
- SAMP_ETCC — nvarchar(1000)
- PROD_AMNT — decimal(14, 4)
- PACK_AMNT — decimal(14, 4)
- DELT_GUBN — varchar(1)
- ADDS_GUBN — varchar(1)
- GJGU_ENDD — char(1)
- GJGU_DATE — char(8)
- ENDD_GUBN — char(10)
- ENDD_DATE — char(8)
- GJGU_CODE — varchar(50)
- … +14
WR_1004
- JKJI_NUMB — char(9) — Primary key — NOT NULL
- SQEN_NUMB — char(6) — Primary key — NOT NULL
- WORK_DATE — char(8)
- HEAD_NUMB — char(6)
- DETL_NUMB — char(6)
- JSNO — char(9)
- GJGU_CODE — varchar(10)
- GJGU_VALU — varchar(1000)
- CHCK_GUBN — varchar(1)
- INPT_USER — varchar(20)
- UPDT_USER — varchar(20)
- INPT_DATE — datetime
- UPDT_DATE — datetime
- INPT_GUBN — char(1)
- DATA_VAL1 — nvarchar(100)
- DATA_VAL2 — nvarchar(100)
- MEMO_XXXX — varchar(250)
- BUYR_MEMO — varchar(250)
- TYPE_GUBN — nvarchar(50)
- DELT_GUBN — varchar(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
WR_1007
- JSNO — varchar(10) — Primary key — NOT NULL
- HEAD_NUMB — varchar(6) — Primary key — NOT NULL
- SQEN_NUMB — varchar(6) — Primary key — NOT NULL
- USED_GUBN — varchar(1)
- ETDD_DATE — varchar(8)
- ARRV_DATE — varchar(8)
- TRNS_MODE — varchar(5)
- TRNS_COMP — varchar(5)
- TERM_MODE — varchar(5)
- TERM_MEMO — varchar(100)
- ARRV_DEST — varchar(50)
- LCAL_AREA — varchar(50)
- BUYR_CONT — varchar(50)
- MEMO_XXXX — varchar(100)
- TRAN_QNTY — decimal(14, 4)
- TRAN_AMUN — varchar(2)
- TRAN_AMTR — decimal(14, 4)
- TRAN_AMNT — decimal(14, 4)
- TRAN_QNUN — varchar(2)
- TAKE_USER — varchar(20)
- ADDR_NAME — varchar(100)
- SHIP_ADDR — varchar(500)
- SHIP_PHON — varchar(20)
- POST_NUMB — varchar(10)
- WORK_USER — varchar(20)
- ITEM_CODE — varchar(11)
- JKJI_NUMB — char(9)
- MODL_NUMB — nvarchar(30)
- DEGN_NAME — nvarchar(30)
- COLR_NAME — nvarchar(30)
- PACK_QNTY — decimal(14, 4)
- UPDT_USER — varchar(20)
- INPT_DATE — datetime
- UPDT_DATE — datetime
- DELT_GUBN — varchar(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =