사고보고서
테이블 (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)