test-db
Tables (4)
ContainerWorkspaceStatus (container_instance_status)
- Key (instance_id) — VARCHAR(36) — Primary key — NOT NULL
- Key (node_id) — int(3) — Primary key — NOT NULL
- Field (status) — VARCHAR(20)
- Field (message) — varchar(1000)
Copy Of TB_EHC101 (TGT_EHC101)
- Key (PO_NO) — VARCHAR2(50) — Primary key — NOT NULL
- Field (ITEM_LINE_NO) — VARCHAR2(15) — Primary key
- Field2 (ITEM_LINE_SEQ) — VARCHAR2(3) — Primary key
- Field (ITEM_UPC) — VARCHAR2(20)
- Field (OMS_ITEM_CD) — VARCHAR2(20)
- Field2 (ITEM_NM) — VARCHAR2(100)
- Field (ITEM_QTY) — VARCHAR2(5)
- Field2 (UNIT_PRICE) — VARCHAR2(13)
- Field (TAX_RATE) — VARCHAR2(13)
- Field (TAX_AMT) — VARCHAR2(13)
- Field (SUB_TOT_AMT) — VARCHAR2(13)
- Field (SHIP_LOC) — VARCHAR2(13)
- Field (SHIP_CARRIER) — VARCHAR2(20)
- Field (SHIP_METHOD) — VARCHAR2(50)
- Field (TRACK_NO) — VARCHAR2(20)
- Field (SHIP_NM) — VARCHAR2(50)
- Field (SHIP_EMAIL) — VARCHAR2(50)
- Field (SHIP_PHONE) — VARCHAR2(50)
- Field (SHIP_ADDR1) — VARCHAR2(300)
- Field (SHIP_ADDR2) — VARCHAR2(300)
- Field (SHIP_CITY) — VARCHAR2(50)
- Field (SHIP_STATE) — VARCHAR2(4)
- Field (SHIP_POST_NO) — VARCHAR2(5)
- Field (SHIP_COUNTRY) — VARCHAR2(10)
- Field (SHIP_EXPECT_DT) — VARCHAR2(8)
- Field (ACK_CD) — VARCHAR2(2)
- Field (ACK_RSN) — VARCHAR2(2)
- Field (CONF_QTY) — VARCHAR2(5)
- Field (APPLY_ACK_CD) — VARCHAR2(2)
- Field (APPLY_ACK_RSN) — VARCHAR2(2)
- Field (APPLY_QTY) — VARCHAR2(5)
- Field (APPLY_EXPECT_DT) — VARCHAR2(8)
- Field (APPLY_PODIV_NO) — VARCHAR2(3)
- Field (APPLY_CAN_YN) — VARCHAR2(2)
- Field (TRANSACTION_ID) — VARCHAR2(16)
- Field (APPLY_STATUS) — VARCHAR2(2)
- Field (CANCEL_QTY) — VARCHAR2(5)
Untitled (WMS_ORDER_IF_HEADER)
- Key (KEY) — VARCHAR2(36) — Primary key — NOT NULL
- Field (ORDER_NO) — VARCHAR2(50)
- Field (BUYER_CD) — VARCHAR2(10)
- Field (SUP_CD) — VARCHAR2(10)
- Field (ORDER_DT) — VARCHAR2(8)
- Field (SHIPTO_NM) — VARCHAR2(100)
- Field (SHIPTO_CD) — VARCHAR2(20)
- Field (DLVRY_DT) — VARCHAR2(8)
- Field (IF_CRT_DTM) — DATE
- Field (IF_CHK) — VARCHAR2(1)
- Field (IF_CHK_DTM) — DATE
- Field (IF_ERR_MSG) — VARCHAR2(200)
Untitled (WMS_ORDER_IF_DETAIL)
- Field (SEQNO) — NUMBER(22) — Primary key
- Key (KEY) — VARCHAR2(36) — Foreign key → Untitled.Key — NOT NULL
- Field (ITEM_NM) — VARCHAR2(200)
- Field (ITEM_CD) — VARCHAR(20)
- Field (BOX_UNIT_QTY) — NUMBER(13)
- Field (ORDER_EA_QTY) — NUMBER(13)
- Field (ORDER_BOX_QTY) — NUMBER(13)
- Field (ORDER_DETL_KEY) — VARCHAR2(40)