1231

Tables (4)

EAI_CLASSDATA_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — NOT NULL
  • CLSS_MANP_SN — VARCHAR2(50)
  • CLSS_SN — VARCHAR2(50)
  • ORDR — VARCHAR2(50)
  • CLSS_MANP_CD — VARCHAR2(50)
  • STT — CHAR(1)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)

EAI_CLASS_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — NOT NULL
  • CLSS_SN — VARCHAR2(50)
  • CLSS_CD — VARCHAR2(50)
  • CLSS_NM — VARCHAR2(256)
  • USE_YN — VARCHAR2(50)
  • STT — CHAR(1)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)

EAI_MATERIALSTCK_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — NOT NULL
  • ITEM_CD — VARCHAR2(50)
  • EVAL_TYPE — VARCHAR2(18)
  • ITEM_LC_CD — VARCHAR2(50)
  • ITEM_QY — VARCHAR2(50)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)

EAI_MATERIALS_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — NOT NULL
  • ITEM_CD — VARCHAR2(50)
  • ITEM_NM — VARCHAR2(500)
  • LCLAS_NM — VARCHAR2(500)
  • MLSFC_NM — VARCHAR2(500)
  • SCLAS_NM — VARCHAR2(500)
  • DTLCLFC_NM — VARCHAR2(500)
  • BAS_UNIT — VARCHAR2(50)
  • USE_YN — CHAR(1)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)