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)