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)