사고보고서

테이블 (12)

SA_ACD_CFM_DTL

  • ACD_SNO — 외래 키 → SA_ACD_CFM_MST.ACD_SNO — NOT NULL
  • ACD_CFM_AMT
  • ACD_CFM_FINAL_AGREE
  • ACD_CFM_PLAN

SA_ACD_CFM_MST

  • ACD_SNO — 외래 키 → SA_ACD_OCCUR_MST.ACD_SNO — NOT NULL
  • REG_DATE
  • ACD_DATE
  • TITLE
  • ACD_TYPE
  • QUANTITY
  • CURR_CODEC (CURR_CODE)
  • AMOUNT
  • DIC_CODE
  • PIC_CODE
  • ATTACH_NO
  • APRO_DOC_SNO
  • PROGRESS_ST
  • DEL_YN
  • SUBMIT_YN
  • INPUT_ID
  • INPUT_DT
  • MODIFY_ID
  • MODIFY_DT

SA_ACD_END_DTL

  • ACD_SNO — 외래 키 → SA_ACD_END_MST.ACD_SNO — NOT NULL
  • ACD_END_DESC

SA_ACD_END_MST

  • ACD_SNO — 외래 키 → SA_ACD_CFM_MST.ACD_SNO — NOT NULL
  • REG_DATE
  • ACD_DATE
  • TITLE
  • ACD_TYPE
  • QUANTITY
  • CURR_CODE
  • AMOUNT (Field7)
  • DIC_CODE
  • PIC_CODE
  • ATTACH_NO
  • APRO_DOC_SNO
  • PROGRESS_ST
  • DEL_YN
  • SUBMIT_YN
  • INPUT_ID
  • INPUT_DT
  • MODIFY_ID
  • MODIFY_DT

SA_ACD_OCCUR_DTL

  • ACD_SNO — 외래 키 → SA_ACD_OCCUR_MST.ACD_SNO — NOT NULL
  • ACD_OCCUR_DESC
  • ACD_OCCUR_AMT
  • ACD_OCCUR_PLAN

SA_ACD_OCCUR_MST

  • ACD_SNO — 기본 키 — NOT NULL
  • REG_DATE
  • ACD_DATE
  • TITLE
  • ACD_TYPE
  • QUANTITY
  • CURR_CODE
  • AMOUNT
  • DIC_CODE
  • PIC_CODE
  • ATTACH_NO
  • APRO_DOC_SNO
  • PROGRESS_ST
  • DEL_YN
  • SUBMIT_YN
  • INPUT_ID
  • INPUT_DT
  • MODIFY_ID
  • MODIFY_DT

SA_ACD_ORD_INFO

  • ACD_SNO — 외래 키 → SA_ACD_OCCUR_MST.ACD_SNO — NOT NULL
  • SER_NO
  • ORD_SNO
  • STYLE_NO
  • BUYER_CODE
  • BRAND
  • FACTORY_CODE
  • EX_FTY_DT
  • DEL_YN
  • INPUT_ID
  • INPUT_DT
  • MODIFY_ID
  • MODIFY_DT

SA_ACD_RPT_DEDUCT

  • DEDUCT_SNO — VARCHAR2(20) — 기본 키 — NOT NULL
  • ACD_SNO — VARCHAR2(20) — 외래 키 → SA_ACD_RPT_MST.ACD_SNO — NOT NULL
  • CUSTOMER_CODE — VARCHAR2(20)
  • CURR_CODE — VARCHAR2(20)
  • AMOUNT — NUMBER(20,8)
  • REMARK — VARCHAR2(500)
  • DEL_YN — VARCHAR2(1)
  • INPUT_ID — VARCHAR2(8)
  • INPUT_DT — VARCHAR2(14)
  • MODIFY_ID — VARCHAR2(8)
  • MODIFY_DT — VARCHAR2(14)

SA_ACD_RPT_DEDUCT (SA_ACD_RPT_DEDUCT2)

  • DEDUCT_SNO — 기본 키 — NOT NULL
  • ACD_SNO — 외래 키 → SA_ACD_CFM_MST.ACD_SNO — NOT NULL
  • SER_NO
  • CUSTOMER_CODE
  • CURR_CODE
  • AMOUNT
  • REMARK
  • DEL_YN
  • INPUT_ID
  • INPUT_DT
  • MODIFY_ID
  • MODIFY_DT

SA_ACD_RPT_DTL

  • ACD_SNO — VARCHAR2(20) — 외래 키 → SA_ACD_RPT_MST.ACD_SNO — NOT NULL
  • ACD_OCCUR_DESC — CLOB
  • ACD_OCCUR_AMT — CLOB
  • ACD_OCCUR_PLAN — CLOB
  • ACD_CFM_AMT — CLOB
  • ACD_CFM_FINAL_AGREE — CLOB
  • ACD_CFM_PLAN — CLOB
  • ACD_END_DESC — CLOB
  • INPUT_ID — VARCHAR2(8)
  • INPUT_DT — VARCHAR2(14)
  • MODIFY_ID — VARCHAR2(8)
  • MODIFY_DT — VARCHAR2(14)

SA_ACD_RPT_MST

  • ACD_SNO — VARCHAR2(20) — 기본 키 — NOT NULL
  • ACD_NO — VARCHAR2(20)
  • REG_DATE — VARCHAR2(8)
  • ACD_DATE — VARCHAR2(8)
  • TITLE — VARCHAR2(500)
  • ACD_TYPE — VARCHAR2(500)
  • ACD_DOC_TYPE — VARCHAR2(20)
  • DEDUCT_TYPE — VARCHAR2(20)
  • QUANTITY — NUMBER(20,8)
  • CURR_CODE — VARCHAR2(20)
  • AMOUNT — NUMBER(20,8)
  • DIC_CODE — VARCHAR2(8)
  • PIC_CODE — VARCHAR2(8)
  • ACD_DIC_CODE — VARCHAR2(8)
  • ACD_PIC_CODE — VARCHAR2(8)
  • ATTACH_NO — VARCHAR2(20)
  • ACD_HST_ATTACH_NO — VARCHAR2(20)
  • APRO_DOC_SNO_OCCUR — VARCHAR2(20)
  • APRO_DOC_SNO_CFM — VARCHAR2(20)
  • APRO_DOC_SNO_END — VARCHAR2(20)
  • PROGRESS_ST_OCCUR — VARCHAR2(20)
  • PROGRESS_ST_CFM — VARCHAR2(20)
  • PROGRESS_ST_END — VARCHAR2(20)
  • DEL_YN — VARCHAR2(1)
  • SUBMIT_YN — VARCHAR2(1)
  • LOSS_PROC_YN — VARCHAR2(1)
  • INPUT_ID — VARCHAR2(8)
  • INPUT_DT — VARCHAR2(14)
  • MODIFY_ID — VARCHAR2(8)
  • MODIFY_DT — VARCHAR2(14)

SA_ACD_RPT_ORD

  • ACD_SNO — VARCHAR2(20) — 외래 키 → SA_ACD_RPT_MST.ACD_SNO — NOT NULL
  • SER_NO — VARCHAR2(6)
  • ORD_SNO — VARCHAR2(20)
  • STYLE_NO — VARCHAR2(500)
  • BUYER_CODE — VARCHAR2(20)
  • BRAND — VARCHAR2(20)
  • FACTORY_CODE — VARCHAR2(20)
  • EX_FTY_DT — VARCHAR2(8)
  • QUANTITY — NUMBER(20,8)
  • REMARK — VARCHAR2(500)
  • DEL_YN — VARCHAR2(1)
  • INPUT_ID — VARCHAR2(8)
  • INPUT_DT — VARCHAR2(14)
  • MODIFY_ID — VARCHAR2(8)
  • MODIFY_DT — VARCHAR2(14)