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