INFAC.SCM
Tables (4)
SCM_TB_DELIVERY_ORDER (dbo.SCM_TB_DELIVERY_ORDER)
- DELIVERY_ORDER_ID — varchar(50) — Primary key — NOT NULL
- PLANT_ID — varchar(50) — Foreign key → SCM_TB_PURCHASE_ORDER.PLANT_ID — NOT NULL
- PURCHASE_ORDER_ID — varchar(50) — Foreign key → SCM_TB_PURCHASE_ORDER.PURCHASE_ORDER_ID — NOT NULL
- DELIVERY_ORDER_NAME — nvarchar(160)
- DESCRIPTION — nvarchar(2500)
- ENTERPRISE_ID — varchar(50)
- VENDOR_ID — varchar(50)
- DUE_DATE — datetime2
- ORDER_QTY — decimal(38,0)
- OWNER — varchar(50)
- STATE — varchar(50)
- IS_HOLD — varchar(50)
- STATUS — varchar(50)
- SHIP_FLAG — varchar(50)
- SHIP_TIME — datetime2
- CREATOR — varchar(50)
- CREATED_TIME — datetime2
- MODIFIER — varchar(50)
- MODIFIED_TIME — datetime2
- LAST_TXN_HIST_KEY — varchar(50)
- LAST_TXN_ID — varchar(50)
- LAST_TXN_USER — varchar(50)
- LAST_TXN_TIME — datetime2
- VALID_STATE — varchar(50)
SCM_TB_DELIVERY_ORDER_ITEM (dbo.SCM_TB_DELIVERY_ORDER_ITEM)
- DELIVERY_ORDER_SEQ — decimal(18,0) — Primary key — NOT NULL
- DELIVERY_ORDER_ID — varchar(50) — Foreign key → SCM_TB_DELIVERY_ORDER.DELIVERY_ORDER_ID — NOT NULL
- PLANT_ID — varchar(50) — Foreign key → SCM_TB_DELIVERY_ORDER.PLANT_ID — NOT NULL
- PURCHASE_ORDER_ID — varchar(50) — Foreign key → SCM_TB_DELIVERY_ORDER.PURCHASE_ORDER_ID — NOT NULL
- PURCHASE_ORDER_SEQ — decimal(18,0)
- ITEM_DEF_ID — varchar(50)
- ITEM_DEF_VERSION — varchar(50)
- DESCRIPTION — nvarchar(2500)
- ENTERPRISE_ID — varchar(50)
- ORDER_QTY — decimal(18,0)
- DELIVERY_QTY — decimal(18,0)
- DELIVERY_DATE — datetime2
- VENDOR_ID — varchar(50)
- DUE_DATE — datetime2
- DELIVERY_ORDER_CHECK_FLAG — varchar(50)
- ARRIVE_FLAG — varchar(50)
- ARRIVE_TIME — datetime2
- INSPECT_FLAG — varchar(50)
- INSPECT_TIME — datetime2
- INSPECT_RESULT — varchar(50)
- INBOUND_FLAG — varchar(50)
- INBOUND_DATE — datetime2
- RETURN_FLAG — varchar(50)
- RETURN_TIME — datetime2
- CREATOR — varchar(50)
- CREATED_TIME — datetime2
- MODIFIER — varchar(50)
- MODIFIED_TIME — datetime2
- LAST_TXN_HIST_KEY — varchar(50)
- LAST_TXN_ID — varchar(50)
- LAST_TXN_USER — varchar(50)
- LAST_TXN_TIME — datetime2
SCM_TB_PURCHASE_ORDER
- PLANT_ID — varchar(50) — Primary key — NOT NULL
- PURCHASE_ORDER_ID — varchar(50) — Primary key — NOT NULL
- PURCHASE_ORDER_NAME — nvarchar(160)
- DESCRIPTION — nvarchar(2500)
- ENTERPRISE_ID — varchar(50)
- VENDOR_ID — varchar(50)
- ORDER_DATE — date
- INCOMING_DATE — date
- INBOUND_DATE — date
- ORDER_QTY — decimal(18,0)
- OWNER — varchar(50)
- STATE — varchar(50)
- IS_HOLD — varchar(50)
- STATUS — varchar(50)
- CREATOR — varchar(50)
- CREATED_TIME — datetime2
- MODIFIER — varchar(50)
- MODIFIED_TIME — datetime2
- LAST_TXN_HIST_KEY — varchar(50)
- LAST_TXN_ID — varchar(50)
- LAST_TXN_USER — varchar(50)
- LAST_TXN_TIME — datetime2
- VALID_STATE — varchar(50) — NOT NULL
SCM_TB_PURCHASE_ORDER_ITEM
- PURCHASE_ORDER_SEQ — decimal(18,0) — Primary key — NOT NULL
- PLANT_ID — varchar(50) — Foreign key → SCM_TB_PURCHASE_ORDER.PLANT_ID — NOT NULL
- PURCHASE_ORDER_ID — varchar(50) — Foreign key → SCM_TB_PURCHASE_ORDER.PURCHASE_ORDER_ID — NOT NULL
- PURCHASE_ORDER_NAME — nvarchar(160)
- ITEM_DEF_ID — varchar(50)
- ITEM_DEF_VERSION — varchar(50)
- BASE_PRICE — decimal(18,0)
- ORDER_QTY — decimal(18,0)
- ORDER_DATE — date
- INCOMING_DATE — date
- INBOUND_DATE — date
- VENDER_CHECK_FLAG — varchar(50)
- STATE — varchar(50)
- CREATOR — varchar(50)
- CREATED_TIME — datetime2
- MODIFIER — varchar(50)
- MODIFIED_TIME — datetime2
- LAST_TXN_HIST_KEY — varchar(50)
- LAST_TXN_ID — varchar(50)
- LAST_TXN_USER — varchar(50)
- LAST_TXN_TIME — datetime2