dae
Tables (45)
CARRIER
- CARNR — Primary key — NOT NULL
- CARTYPE — int
- CARMODE — int
- CARSTATE — char(16)
- PLOADSTATE — char(1)
- POSADDR — int
- POSNAME — char(4)
- DESTADDR — int
- DESTNAME — char(4)
- TRSEQSTATE — int
- LOADSEQNR — int
- LOADSEQMASK — int
- INFOWORD1 — int
- INFOWORD2 — int
- ACTIVEERRORCODE — int
- TRCOMPLTIME — date
- BATTCAP — int
- BATTLOW — int
- BATLOWLIMIT — int
- BATCHARGBEGIN — date
- BATCHARGEND — date
- TESTACTIVE — char(1)
- TESTSEQNR — int
- ACTTESTORDERNR — int
- TESTLOOPCOUNT — int
- TESTLOOPMAXCOUNT — int
- LASTTRORDID — int
- IDLELOOP — char(8)
- COMMNR — int
- REPCOUNT — int
- ACTIVENGN — int
- CURRENTTRC — int
- TELEGRAM — char(80)
- CARMODE1 — float
- NODERELEASE — varchar(1)
Copy Of MTSPCD (CopyOfMTSPCD)
- Key — Primary key — NOT NULL
- spcd_code — varchar(2) — NOT NULL
- spcd_name — varchar(20)
- spcd_date — varchar(8)
DP_DESCR
- LAYOUTADDR (Key) — Primary key — NOT NULL
- SL_NR — int
- WSL_NR — int
ERRORLOG
- TIME — DATE — Primary key — NOT NULL
- TEXT — char(512) — NOT NULL
- COUNT — int — NOT NULL
ErrorMessage
- Seq — bigint — Primary key — NOT NULL
- Name — nvarchar(100)
- ERROR — int
- ELINE — int
- Message — nvarchar(1000
IL_LOCATION
- IL_NAME — char(8) — Primary key — NOT NULL
- LAYOUTADDR — int
- LOCPOS — int
LOCATION
- NAME — char(4) — Primary key — NOT NULL
- PROP — int
- TYPE — int
- STATE — int
- READY — int
- ACCESS_1 — int
- LAYOUTTYPE — int — NOT NULL
- PREDESTADDR — int
- LAYOUTADDR — int
- PICKSEQNR — int
- PICKSEQMASK — int
- PICKIW1 — int
- PICKIW2 — int
- DEPOSEQNR — int
- DEPOSEQMASK — int
- DEPOIW1 — int
- DEPOIW2 — int
- PRENODEMASK — int
- PRENODEFUNC — int
- NODEFUNC — int
LOCATION_PRIO
- LOCATION_NAME — char(4) — Primary key — NOT NULL
- STRATEGY — int
- INITPRIO — int
- PRIOINCR — int
- INCRTIME — int
- MAXPRIO — int
LOGDIGINPUTS
- FUNCTIONNAME — CHAR(20) — Primary key — NOT NULL
- INPUTSIGNALID — char(20) — Primary key — NOT NULL
- FUNCGROUPID — int — NOT NULL
- FUNCSIGNALID — int — NOT NULL
- ACTION — char(1) — NOT NULL
- PARAM1 — char(20)
- PARAM2 — char(20)
- PARAM3 — char(20)
- PARAM4 — char(20)
- PARAM5 — char(20)
MTBAGM
- bagm_code — Primary key — NOT NULL
- bagm_name — varchar(20)
- bagm_unit — numeric(10, 3)
- bagm_date — varchar(8)
MTGUBN
- gubn_code — char(2) — Primary key — NOT NULL
- gubn_name — varchar(20)
- gubn_date — varchar(8)
MTHOOU
- HOOU_GUBUN — Primary key — NOT NULL
- HOOU_DETAIL_ID — Primary key — NOT NULL
- HOOU_DETAIL_HANG — Primary key — NOT NULL
- item_code — varchar(20) — Foreign key → MTITEM.item_code — NOT NULL
- HOOU_CODE — varchar(20) — NOT NULL
- HOOU_LOT — varchar(12)
- HOOU_BAG — varchar(2)
- HOOU_SP — varchar(2)
- HOOU_WRAP — varchar(1)
- HOOU_OUT_DATE — varchar(8)
- HOOU_OUT_TIME — varchar(6)
- HOOU_ORDER_DATE — varchar(8)
- HOOU_ORDER_TIME — varchar(6)
- HOOU_QTY — numeric(10, 3)
- HOOU_ISSU_ID — varchar(14)
- HOOU_ISSU_HANG — int
- HOOU_AWH — varchar(10)
- HOOU_SEND_FLAG_S — varchar(1)
- HOOU_ATTR10 — varchar(10)
MTIOHT
- ioht_io (Key) — Primary key — NOT NULL
- ioht_date (Key2) — Primary key — NOT NULL
- ioht_time (Key3) — Primary key — NOT NULL
- ioht_bank (Key4) — Primary key — NOT NULL
- ioht_bay (Key5) — Primary key — NOT NULL
- ioht_level (Key6) — Primary key — NOT NULL
- loht_kot (Key7) — Primary key — NOT NULL
- loht_wrap (Key8) — Primary key — NOT NULL
- item_code — varchar(20) — Foreign key → MTITEM.item_code — NOT NULL
- bagm_code — Foreign key → MTBAGM.bagm_code — NOT NULL
- spcd_code — varchar(2) — Foreign key → MTSPCD.spcd_code — NOT NULL
- IOHT_TIDX — varchar(4)
- IOHT_CODE — varchar(20)
- IOHT_LOT — varchar(12)
- IOHT_BAG — varchar(2)
- IOHT_SP — varchar(2)
- IOHT_LINE — varchar(3)
- IOHT_GUBUN — varchar(1)
- IOHT_QTY — numeric(10, 3)
- IOHT_REIN — numeric(10, 3)
- IOHT_IDATE — varchar(8)
- IOHT_CAR_NO — varchar(20)
- IOHT_REVD_NO — varchar(20)
- IOHT_DETAIL_ID — varchar(14)
- IOHT_BATCH_NO — varchar(12)
- IOHT_TO_BANK — varchar(2)
- IOHT_TO_BAY — varchar(2)
- IOHT_TO_LEVEL — varchar(2)
- IOHT_PTIME — varchar(8)
- IOHT_SALE_NO — varchar(10)
- IOHT_SALE_TYPE — varchar(4)
- IOHT_SALE_GUBUN — varchar(2)
- IOHT_LOGID — varchar(10)
- IOHT_SEND_FLAG_T — varchar(1) — NOT NULL
- IOHT_SEND_SQN_T — varchar(6) — NOT NULL
- IOHT_SEND_FLAG_S — varchar(1) — NOT NULL
- IOHT_SEND_SQN_S — varchar(15) — NOT NULL
- IOHT_SEND_SALE_S — varchar(1)
- IOHT_CANCEL — varchar(1)
- IOHT_SEND_SSQN_S — varchar(15)
- IOHT_SALE_CNT — varchar(6)
- IOHT_REM — varchar(80)
MTITEM
- item_code — varchar(20) — Primary key — NOT NULL
- item_name1 — varchar(70)
- item_name2 — varchar(70)
- item_plant — varchar(10)
- item_date — varchar(8)
- item_yongdo — varchar(20)
- item_cust — varchar(20)
- item_film — varchar(20)
- item_attr01 — varchar(20)
- item_attr02 — varchar(10)
MTLSTK
- lstk_lot (Key) — Primary key — NOT NULL
- lstk_wrap (Key2) — Primary key — NOT NULL
- lstk_bay (Key3) — Primary key — NOT NULL
- lstk_bank (Key4) — Primary key — NOT NULL
- lstk_level (Key5) — Primary key — NOT NULL
- spcd_code — varchar(2) — Foreign key → MTSPCD.spcd_code — NOT NULL
- bagm_code — Foreign key → MTBAGM.bagm_code — NOT NULL
- item_code — varchar(20) — Foreign key → MTITEM.item_code — NOT NULL
- lstk_bay — varchar(2) — NOT NULL
- lstk_bank — varchar(2) — NOT NULL
- lstk_level — varchar(2) — NOT NULL
- lstk_date — varchar(8)
- lstk_time — varchar(6)
- lstk_flag — varchar(1)
- lstk_tidx — varchar(4)
- lstk_line — varchar(3)
- lstk_igubn — varchar(2)
- lstk_qty — numeric(10, 3)
- lstk_batch_no — varchar(12)
- lstk_rdate — varchar(8)
- lstk_dansu — varchar(1)
- lstk_hogi — int
- lstk_remarks — varchar(70)
MTOGUBN
- ogubn_code — char(2) — Primary key — NOT NULL
- ogubn_name — varchar(20)
- ogubn_date — varchar(8)
MTPPR05
- CHITNO — varchar(12) — NOT NULL
- SEQNO — int — NOT NULL
- WRKCLAS — varchar(2) — NOT NULL
- SHIPSITE — varchar(2) — NOT NULL
- GRADE — varchar(20) — NOT NULL
- LOTNO — varchar(10) — NOT NULL
- BAGCLAS — varchar(2) — NOT NULL
- SPCL — varchar(2) — NOT NULL
- WRAP — varchar(1) — NOT NULL
- REPQTY — numeric(10, 3)
- REPDATE — varchar(8)
- REPTIME — varchar(6)
- LOC — varchar(10)
- PROCESS_TAG — varchar(1)
- PROCESS_DATE — varchar(8)
- PROCESS_TIME — varchar(6)
- LOC2 — varchar(10)
MTREVD
- REVD_DETAIL_ID — varchar(14) — NOT NULL
- REVD_DETAIL_HANG — int — NOT NULL
- REVD_DATE — varchar(8)
- REVD_TIME — varchar(6)
- REVD_CODE — varchar(20)
- REVD_LOT — varchar(12)
- REVD_BAG — varchar(2)
- REVD_SP — varchar(2)
- REVD_WRAP — varchar(1)
- REVD_REQU_QTY — numeric(10, 3)
- REVD_QTY — numeric(10, 3)
- REVD_OQTY — nchar(10)
- REVD_CAR_NO — varchar(20)
- REVD_CANCEL_QTY — numeric(10, 3)
- REVD_SALE_NO — varchar(10)
- REVD_SALE_TYPE — varchar(4)
- REVD_SALE_GUBUN — varchar(2)
- REVD_LOGID — varchar(10)
- REVD_SALE_CNT — varchar(6)
MTSIOT
- siot_lot — varchar(12) — Primary key — NOT NULL
- siot_wrap — Primary key — NOT NULL
- item_code — varchar(20) — Foreign key → MTITEM.item_code — NOT NULL
- spcd_code — varchar(2) — Foreign key → MTSPCD.spcd_code — NOT NULL
- bagm_code — Foreign key → MTBAGM.bagm_code — NOT NULL
- siot_iwol — numeric(10, 3)
- siot_inpt — numeric(10, 3)
- siot_oupt — numeric(10, 3)
- siot_stok — numeric(10, 3)
- SIOT_UPDT — numeric(10, 3)
- siot_yiwol — numeric(10, 3)
- siot_yinpt — numeric(10, 3)
- siot_youpt — numeric(10, 3)
- siot_ystok — numeric(10, 3)
- SIOT_YUPDT — numeric(10, 3)
- SIOT_CIWOL — numeric(10, 3)
- SIOT_CINPT — numeric(10, 3)
- SIOT_COUPT — numeric(10, 3)
- SIOT_CSTOK — numeric(10, 3)
- SIOT_CUPDT — numeric(10, 3)
- SIOT_STOK_REVD — numeric(10, 3)
- SIOT_YSTOK_REVD — numeric(10, 3)
- SIOT_CSTOK_REVD — numeric(10, 3)
- Field
MTSPCD
- spcd_code — varchar(2) — Primary key — NOT NULL
- spcd_name — varchar(20)
- spcd_date — varchar(8)
MTSTOK
- stok_date (Key) — Primary key — NOT NULL
- stok_lot (Key2) — Primary key — NOT NULL
- stok_wrap (Key3) — Primary key — NOT NULL
- item_code — varchar(20) — Foreign key → MTITEM.item_code — NOT NULL
- bagm_code — Foreign key → MTBAGM.bagm_code — NOT NULL
- spcd_code — varchar(2) — Foreign key → MTSPCD.spcd_code — NOT NULL
- stok_iwol — numeric(10, 3)
- stok_inpt — numeric(10, 3)
- stok_oupt — numeric(10, 3)
- stok_stok — numeric(10, 3)
- STOK_UPDT — numeric(10, 3)
- stok_yiwol — numeric(10, 3)
- stok_yinpt — numeric(10, 3)
- stok_youpt — numeric(10, 3)
- stok_ystok — numeric(10, 3)
- STOK_YUPDT — numeric(10, 3)
- STOK_CIWOL — numeric(10, 3)
- STOK_CINPT — numeric(10, 3)
- STOK_COUPT — numeric(10, 3)
- STOK_CSTOK — numeric(10, 3)
- STOK_CUPDT — numeric(10, 3)
- STOK_STOK_REVD — numeric(10, 3)
- STOK_YSTOK_REVD — numeric(10, 3)
- STOK_CSTOK_REVD — numeric(10, 3)
- STOK_CHG_DATE — varchar(8)
- STOK_CHG_TIME — varchar(6)
MTTRAK
- TRAK_IO (Key) — Primary key — NOT NULL
- TRAK_TIDX (Key2) — Primary key — NOT NULL
- TRAK_LINE — varchar(3)
- TRAK_TARGET — varchar(2)
- TRAK_SOURCE — varchar(2)
- TRAK_LOT — varchar(12)
- TRAK_BAG — varchar(2)
- TRAK_WRAP — varchar(1)
- TRAK_QTY — numeric(10, 3)
- TRAK_REIN — numeric(10, 3)
- TRAK_BANK — varchar(2)
- TRAK_BAY — varchar(2)
- TRAK_LEVEL — varchar(2)
- TRAK_BATCH_NO — varchar(12)
- TRAK_CAR_NO — varchar(20)
- TRAK_IGUBN — varchar(2)
- TRAK_IDATE — varchar(8)
- TRAK_OGUBN — varchar(2)
- TRAK_DETAIL_ID — varchar(14)
- TRAK_DETAIL_HANG — int
- TRAK_STS — varchar(1)
- TRAK_HOGI — int
- TRAK_DATE — varchar(8)
- TRAK_TIME — varchar(6)
- TRAK_SLIP_NO — int
- TRAK_LOGID — varchar(10)
- TRAK_FROM_BANK — varchar(2)
- TRAK_FROM_BAY — varchar(2)
- TRAK_FROM_LEVEL — varchar(2)
- TRAK_SALE_NO — varchar(10)
- TRAK_SALE_TYPE — varchar(4)
- TRAK_SALE_GUBUN — varchar(2)
- TRAK_SALE_CNT — varchar(6)
MTUPDT
- UPDT_DATE — Primary key — NOT NULL
- UPDT_TIME — Primary key — NOT NULL
- UPDT_PROGRAM — varchar(40)
- UPDT_LOGUSER — varchar(10)
- UPDT_GUBUN — varchar(1)
- UPDT_CODE — varchar(20)
- UPDT_LOT — varchar(12)
- UPDT_BAG — varchar(2)
- UPDT_SP — varchar(2)
- UPDT_WRAP — varchar(1)
- UPDT_IO_GUBN — varchar(2)
- UPDT_BANK — varchar(2)
- UPDT_BAY — varchar(2)
- UPDT_LEVEL — varchar(2)
- UPDT_QTY — numeric(10, 3)
- UPDT_YQTY — numeric(10, 3)
- UPDT_CQTY — numeric(10, 3)
- UPDT_TO_CODE — varchar(20)
- UPDT_TO_LOT — varchar(12)
- UPDT_TO_BAG — varchar(2)
- UPDT_TO_SP — varchar(2)
- UPDT_TO_WRAP — varchar(1)
- UPDT_TO_IO_GUBN — varchar(2)
- UPDT_TO_BANK — varchar(2)
- UPDT_TO_BAY — varchar(2)
- UPDT_TO_LEVEL — varchar(2)
- UPDT_TO_QTY — numeric(10, 3)
- UPDT_TO_YQTY — numeric(10, 3)
- UPDT_TO_CQTY — numeric(10, 3)
- UPDT_LINE — varchar(3)
- UPDT_TO_LINE — varchar(3)
MTUSER
- user_id — Primary key — NOT NULL
- user_name — varchar(10)
- user_passwd — varchar(10)
- user_permission — char(1)
NODE
- NODENR — INT — Primary key — NOT NULL
- MAXNROFCAR — int
- ACTNROFCAR — int
- DIGINRESERVED — int
- OUTPUTSIGNALID — char(20)
- FLAG — char(1)
NODECARRIER
- CARNR — int
- ACTIVENGN — int
- CURRENTTRC — int
NODERESERVATION
- NODENR — INT — Primary key — NOT NULL
- ENTRYNR — int
- NGN — int
- TRC — int
- CARNR — int
- STATE — int
- CREATETIME — date
PHYSDIGINPUTS
- INPUTSIGNALID — Primary key — NOT NULL
- DRIVERNAME — char(20) — NOT NULL
- INPUTLINE — int — NOT NULL
- INPUTUNIT — int — NOT NULL
- INPUTSIGNAL — int — NOT NULL
- SIGNALSTATE — char(1) — NOT NULL
STATISTIC
- TRORDGEN — int
- TRORDSTART — int
- TRORDFIN — int
- TRORDMAN — int
- TRORDDEL — int
- STARTTIME — date
- STOPTIME — date
S_LIST
- SL_NR — int — Primary key — NOT NULL
- STATIONNAME — char(4)
- ORDERNR — int
- PRIORITY — int
TESTSEQELEMBYYADDR
- TESTSEQNR — int — Primary key — NOT NULL
- ORDERNR — int
- DESTADDR — int
- DESTCMD — int
TRORDER
- TRORDERNR (Key) — Primary key — NOT NULL
- SOURCENAME (Key2) — Primary key — NOT NULL
- DESTNAME (Key3) — Primary key — NOT NULL
- HOST_NR — int
- TRUNITNR — int
- TRUNITTYPE — int
- CARTYPE — int
- CARNR — int
- SOURCEPOS — int
- DESTPOS — int
- TRORDERSTATE — int
- ERRORSTATE — int
- CONFLAMPSIGID — char(20)
- CONFLAMPFUNC — int
- CARLOADED — int
- CREATETIME — date
- STARTTIME — date
- PRIORITY — int — NOT NULL
- USERNAME — char(12)
- OPMODE — int
TRORDERHISTORY
- SOURCENAME — Primary key — NOT NULL
- DESTNAME — Primary key — NOT NULL
- TRORDERNR — int
- TRUNITNR — int
- HOST_NR — int
- CARTYPE — int
- CARNR — int
- TRUNITTYPE — int
- TRORDERSTATE — int
- SOURCEPOS — int
- DESTPOS — int
- CREATETIME — date
- STARTTIME — date
- ENDTIME — date
- USERNAME — char(12)
TRUNIT
- TRUNITNR — int
- TRUNITID — char(10)
- LOCNAME — char(10)
- LOCPOS — int
- PROCESSNAME — char(30)
- INDATE — date
- ACCESSTIME — date
TWAGVH
- AGVH_LUG (Key) — Primary key — NOT NULL
- AGVH_DATE — varchar(8)
- AGVH_TIME — varchar(6)
- AGVH_FLOC — varchar(4)
- AGVH_TLOC — varchar(4)
- AGVH_RPRIOR — varchar(2)
- AGVH_PALLET — varchar(1)
- AGVH_CMD — char(1)
- AGVH_MESG — varchar(4)
TWAGVT
- user_id — Foreign key → MTUSER.user_id — NOT NULL
- agvt_cycle — varchar(2)
- agvt_jend — varchar(1)
- agvt_fheng — varchar(4)
- agvt_theng — varchar(4)
- agvt_ftidx — varchar(4)
- agvt_btidx — varchar(4)
- agvt_hogi — int
TWIOCV
- ICV_PKB_ERUN — char(1)
- ICV_PKB_RUN — char(1)
- ICV_PLTZER_B_RUN — char(1)
- ICV_PLTZER_ERUN — char(1)
- ICV_PLTZER_A_RUN — char(1)
- ICV_PKA_ERUN — char(1)
- ICV_PKA_RUN — char(1)
- ICV_INST01_RUN — char(1)
- ICV_INST02_RUN — char(1)
- ICV_INST03_RUN — char(1)
- ICV_INST04_RUN — char(1)
- ICV_INST05_RUN — char(1)
- ICV_INST06_RUN — char(1)
- ICV_INST07_RUN — char(1)
- ICV_INST08_RUN — char(1)
- ICV_INST09_RUN — char(1)
- ICV_INST10_RUN — char(1)
- ICV_INST11_RUN — char(1)
- ICV_OUST01_RUN — char(1)
- ICV_OUST02_RUN — char(1)
- ICV_OUST03_RUN — char(1)
- ICV_OUST04_RUN — char(1)
- ICV_OUST05_RUN — char(1)
- ICV_OUST06_RUN — char(1)
- ICV_OUST07_RUN — char(1)
- ICV_OUST08_RUN — char(1)
- ICV_OUST09_RUN — char(1)
- ICV_OUST10_RUN — char(1)
- ICV_OUST11_RUN — char(1)
- ICV_OUGT11_RUN — char(1)
- ICV_OUGT12_RUN — char(1)
- ICV_OUGT13_RUN — char(1)
- ICV_OUGT14_RUN — char(1)
- ICV_OUGT21_RUN — char(1)
- ICV_OUGT22_RUN — char(1)
- ICV_OUGT23_RUN — char(1)
- ICV_OUGT24_RUN — char(1)
- ICV_OUGT31_RUN — char(1)
- ICV_OUGT32_RUN — char(1)
- ICV_OUGT33_RUN — char(1)
- ICV_OUGT34_RUN — char(1)
- ICV_OUGT41_RUN — char(1)
- ICV_OUGT42_RUN — char(1)
- ICV_OUGT43_RUN — char(1)
- ICV_OUGT44_RUN — char(1)
- ICV_OUGT51_RUN — char(1)
- ICV_OUGT52_RUN — char(1)
- ICV_OUGT53_RUN — char(1)
- ICV_OUGT54_RUN — char(1)
- ICV_OUGT61_RUN — char(1)
- ICV_OUGT62_RUN — char(1)
- ICV_OUGT63_RUN — char(1)
- ICV_OUGT64_RUN — char(1)
- ICV_EPLT01_RUN — char(1)
- ICV_EPLT02_RUN — char(1)
- ICV_EPLT03_RUN — char(1)
- ICV_PKB_PLT — int
- ICV_PKE_PLT — int
- ICV_PKA_PLT — int
- ICV_PKB_OUREQU — char(1)
- … +377
TWISET
- iset_site (Key) — Primary key — NOT NULL
- iset_sts (Key2) — Primary key — NOT NULL
- item_code — varchar(20) — Foreign key → MTITEM.item_code — NOT NULL
- bagm_code — Foreign key → MTBAGM.bagm_code — NOT NULL
- spcd_code — varchar(2) — Foreign key → MTSPCD.spcd_code — NOT NULL
- iset_igubn — varchar(2)
- iset_lot — varchar(12)
- iset_wrap — varchar(1)
- iset_rqty_unit — numeric(10, 3)
- iset_prod_qty — numeric(10, 3)
- iset_rack_qty — numeric(10, 3)
- iset_jickchul — varchar(50)
- iset_jickchul_requ — numeric(10, 3)
- iset_jickchul_qty — numeric(10, 3)
- iset_log_no — varchar(4)
- iset_hogi — int
- iset_heng — varchar(2)
- iset_cmd — varchar(1)
- iset_batch_no — varchar(12)
- iset_LOGID — varchar(10)
- iset_prod_requ — numeric(10, 3)
- iset_plttype — char(1)
TWMESG
- user_id — Foreign key → MTUSER.user_id — NOT NULL
- MESG_NAME — varchar(40)
- MESG_DATE — varchar(8)
TWSSCC
- SCC_HOGI — int — NOT NULL
- SCCI_ONLN — varchar(1)
- SCCI_READY — varchar(1)
- SCCI_RUN — varchar(1)
- SCCI_FFORK_PLT — varchar(1)
- SCCI_BFORK_PLT — varchar(1)
- SCCI_CENT — varchar(1)
- SCCI_FFORK_POS — varchar(1)
- SCCI_BFORK_POS — varchar(1)
- SCCI_INPT_POS — varchar(1)
- SCCI_OUPT_POS — varchar(1)
- SCCI_FNSH — varchar(1)
- SCCI_ERR — varchar(2)
- SCCI_ERR_CODE — varchar(2)
- SCCI_BAY — varchar(2)
- SCCI_LEVEL — varchar(4)
- SCCO_FTIDX — varchar(4)
- SCCO_BTIDX — varchar(1)
- SCCO_RACK_IO — varchar(1)
- SCCO_OUST — varchar(1)
- SCCO_INST — varchar(1)
- SCCO_FFORK — varchar(1)
- SCCO_BFORK — varchar(1)
- SCCO_OUPT_CMD — varchar(1)
- SCCO_INPT_CMD — varchar(1)
- SCCO_IOSELECT — varchar(1)
- SCCO_CYCLE — varchar(2)
- SCCO_JOB_END — varchar(1)
- SCCO_BANK — varchar(2)
- SCCO_BAY — varchar(2)
- SCCO_LEVEL — varchar(2)
- SCCO_SCER — varchar(1)
- SCCO_FEXFG — varchar(1)
- SCCO_BEXFG — varchar(1)
TWSTAT
- Stat_wms — varchar(1) — NOT NULL
- Stat_agv — varchar(1)
- stat_comm — varchar(1)
- stat_host — varchar(1)
- stat_icnt_401 — int
- stat_icnt_402 — int
- stat_icnt_403 — int
- stat_icnt_404 — int
- STAT_ICNT_REIN_EPLT — int
- stat_ocnt — int
- stat_odate — varchar(8)
- stat_otime — varchar(6)
- stat_gtlr01 — varchar(1)
- stat_gtlr02 — varchar(1)
- stat_gtlr03 — varchar(1)
- stat_gtlr04 — varchar(1)
- stat_gtlr05 — varchar(1)
- stat_gtlr06 — varchar(1)
- stat_jyunpyo — int
- stat_isend — int
- stat_msend — int
- stat_eplt_auto — varchar(1)
TWTRKI
- user_id — Foreign key → MTUSER.user_id — NOT NULL
- TRKI_LOG_NO — varchar(4)
- TRKI_CMD — varchar(1)
- TRKI_HOGI — int
- TRKI_STS — varchar(1)
- TRKI_PLTTYPE — char(1)
TWTRKO
- user_id — Foreign key → MTUSER.user_id — NOT NULL
- Trko_log_no — varchar(4)
- Trko_cmd — varchar(1)
- Trko_heng — varchar(2)
WS_DESCR
- WS_NAME — char(4) — Primary key — NOT NULL
- WS_TYPE — int
- MAXNROFCAR — int
- LAYOUTADDR1 — int
- LAYOUTADDR2 — int
- BLOCKED — char(1)
WS_LIST
- WSL_NR — int — Primary key — NOT NULL
- WS_NAME — char(4)
- ORDERNR — int — NOT NULL