ㅅ
Tables (50)
T8010H
- WCGBN — varchar(10) — Primary key — NOT NULL
- WCJO — varchar(10) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key — NOT NULL
- FACTCD — varchar(10) — Foreign key — NOT NULL
T8011H
- WCGBN — varchar(10) — Primary key — NOT NULL
- SEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key — NOT NULL
- FACTCD — varchar(10) — Foreign key — NOT NULL
T8012H
- WCGBN — varchar(10) — Primary key — NOT NULL
- SHCD — varchar(10) — Primary key — NOT NULL
- SEQ — int — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key — NOT NULL
- FACTCD — varchar(10) — Foreign key — NOT NULL
T8020D
- WPNO — varchar(10) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8020H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8020H.FACTCD — NOT NULL
- WCCD — varchar(10) — Foreign key → T8020H.WCCD — NOT NULL
- SHCD — varchar(10) — Foreign key → T8020H.SHCD — NOT NULL
T8020H
- SHCD — varchar(10) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key — NOT NULL
- FACTCD — varchar(10) — Foreign key — NOT NULL
- WCCD — varchar(10) — Foreign key — NOT NULL
T8035H
- NGCD — varchar(10) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key — NOT NULL
- FACTCD — varchar(10) — Foreign key — NOT NULL
- WCCD — varchar(10) — Foreign key — NOT NULL
T8036H
- SEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key — NOT NULL
- FACTCD — varchar(10) — Foreign key — NOT NULL
- WCCD — varchar(10) — Foreign key — NOT NULL
T8050H
- COMCD — varchar(10) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key — NOT NULL
- FACTCD — varchar(10) — Foreign key — NOT NULL
T8060H
- WCCD — varchar(10) — Primary key — NOT NULL
- WORKCD — varchar(10) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8050H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8050H.FACTCD — NOT NULL
- COMCD — varchar(10) — Foreign key → T8050H.COMCD — NOT NULL
T8070H
- IDLECD — varchar(10) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key — NOT NULL
- FACTCD — varchar(10) — Foreign key — NOT NULL
T8080H
- WCCD — varchar(10) — Primary key — NOT NULL
- WORKCD — varchar(10) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8070H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8070H.FACTCD — NOT NULL
- IDLECD — varchar(10) — Foreign key → T8070H.IDLECD — NOT NULL
T8100D
- MPSEQ — varchar(4) — Primary key — NOT NULL
- SEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8100H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8100H.FACTCD — NOT NULL
- MPNO — varchar(20) — Foreign key → T8100H.MPNO — NOT NULL
- WCCD — varchar(10)
T8100D_CP
- MPNO — varchar(20) — Primary key — NOT NULL
- MPSEQ — varchar(4) — Primary key — NOT NULL
- SEQ — varchar(4) — Primary key — NOT NULL
- OUTSEQ — varchar(4) — Primary key — NOT NULL
- CPSEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8050H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8050H.FACTCD — NOT NULL
- COMCD — varchar(10) — Foreign key → T8050H.COMCD
T8100D_IDLE
- MPNO — varchar(20) — Primary key — NOT NULL
- MPSEQ — varchar(4) — Primary key — NOT NULL
- SEQ — varchar(4) — Primary key — NOT NULL
- OUTSEQ — varchar(4) — Primary key — NOT NULL
- IDLESEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8070H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8070H.FACTCD — NOT NULL
- IDLECD — varchar(10) — Foreign key → T8070H.IDLECD
T8100D_OUT
- OUTSEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8100D.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8100D.FACTCD — NOT NULL
- MPNO — varchar(20) — Foreign key → T8100D.MPNO — NOT NULL
- MPSEQ — varchar(4) — Foreign key → T8100D.MPSEQ — NOT NULL
- SEQ — varchar(4) — Foreign key → T8100D.SEQ — NOT NULL
- WCCD — varchar(10)
T8100H
- FACTCD — varchar(10) — Primary key — NOT NULL
- MPNO — varchar(20) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key — NOT NULL
- CUSTCD — varchar(10) — Foreign key
- ITEMCD — varchar(20)
T8100H_HIS
- MPSEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8100H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8100H.FACTCD — NOT NULL
- MPNO — varchar(20) — Foreign key → T8100H.MPNO — NOT NULL
- CUSTCD — varchar(10)
- ITEMCD — varchar(20)
T8200D_HIS_LOT
- LOTNO — varchar(20) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8200H_HIS.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8200H_HIS.FACTCD — NOT NULL
- LAYOUTNO — varchar(20) — Foreign key → T8200H_HIS.LAYOUTNO — NOT NULL
- LAYOUTSEQ — varchar(4) — Foreign key → T8200H_HIS.LAYOUTSEQ — NOT NULL
T8200D_HIS_PLAN
- WORKSEQ — varchar(4) — Primary key — NOT NULL
- WORKSUBSEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8200D_HIS_LOT.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8200D_HIS_LOT.FACTCD — NOT NULL
- LAYOUTNO — varchar(20) — Foreign key → T8200D_HIS_LOT.LAYOUTNO — NOT NULL
- LAYOUTSEQ — varchar(4) — Foreign key → T8200D_HIS_LOT.LAYOUTSEQ — NOT NULL
- LOTNO — varchar(20) — Foreign key → T8200D_HIS_LOT.LOTNO — NOT NULL
- WCCD — varchar(10)
T8200D_HIS_PLANCP
- LAYOUTNO — varchar(20) — Primary key — NOT NULL
- LAYOUTSEQ — varchar(4) — Primary key — NOT NULL
- LOTNO — varchar(20) — Primary key — NOT NULL
- WORKSEQ — varchar(4) — Primary key — NOT NULL
- WORKSUBSEQ — varchar(4) — Primary key — NOT NULL
- OUTSEQ — varchar(4) — Primary key — NOT NULL
- CPSEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8050H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8050H.FACTCD — NOT NULL
- COMCD — varchar(10) — Foreign key → T8050H.COMCD
T8200D_HIS_PLANIDLE
- LAYOUTNO — varchar(20) — Primary key — NOT NULL
- LAYOUTSEQ — varchar(4) — Primary key — NOT NULL
- LOTNO — varchar(20) — Primary key — NOT NULL
- WORKSEQ — varchar(4) — Primary key — NOT NULL
- WORKSUBSEQ — varchar(4) — Primary key — NOT NULL
- OUTSEQ — varchar(4) — Primary key — NOT NULL
- IDLESEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8070H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8070H.FACTCD — NOT NULL
- IDLECD — varchar(10) — Foreign key → T8070H.IDLECD
T8200D_HIS_PLANOUT
- OUTSEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8200D_HIS_PLAN.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8200D_HIS_PLAN.FACTCD — NOT NULL
- LAYOUTNO — varchar(20) — Foreign key → T8200D_HIS_PLAN.LAYOUTNO — NOT NULL
- LAYOUTSEQ — varchar(4) — Foreign key → T8200D_HIS_PLAN.LAYOUTSEQ — NOT NULL
- LOTNO — varchar(20) — Foreign key → T8200D_HIS_PLAN.LOTNO — NOT NULL
- WORKSEQ — varchar(4) — Foreign key → T8200D_HIS_PLAN.WORKSEQ — NOT NULL
- WORKSUBSEQ — varchar(4) — Foreign key → T8200D_HIS_PLAN.WORKSUBSEQ — NOT NULL
- WCCD — varchar(10)
T8200D_HIS_PLANPO
- PONO — varchar(20) — Primary key — NOT NULL
- POSEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8200D_HIS_LOT.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8200D_HIS_LOT.FACTCD — NOT NULL
- LAYOUTNO — varchar(20) — Foreign key → T8200D_HIS_LOT.LAYOUTNO — NOT NULL
- LAYOUTSEQ — varchar(4) — Foreign key → T8200D_HIS_LOT.LAYOUTSEQ — NOT NULL
- LOTNO — varchar(20) — Foreign key → T8200D_HIS_LOT.LOTNO — NOT NULL
- PODEPTCD — varchar(10)
- POPNO — varchar(10)
- CUSTCD — varchar(10)
- ITEMCD — varchar(20)
T8200D_HIS_PO
- PONO — varchar(20) — Primary key — NOT NULL
- POSEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8200D_HIS_LOT.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8200D_HIS_LOT.FACTCD — NOT NULL
- LAYOUTNO — varchar(20) — Foreign key → T8200D_HIS_LOT.LAYOUTNO — NOT NULL
- LAYOUTSEQ — varchar(4) — Foreign key → T8200D_HIS_LOT.LAYOUTSEQ — NOT NULL
- LOTNO — varchar(20) — Foreign key → T8200D_HIS_LOT.LOTNO — NOT NULL
- PODEPTCD — varchar(10)
- POPNO — varchar(10)
- CUSTCD — varchar(10)
- ITEMCD — varchar(20)
T8200D_LOT
- LOTNO — varchar(20) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8200H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8200H.FACTCD — NOT NULL
- LAYOUTNO — varchar(20) — Foreign key → T8200H.LAYOUTNO — NOT NULL
T8200D_PLAN
- WORKSEQ — varchar(4) — Primary key — NOT NULL
- WORKSUBSEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8200D_LOT.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8200D_LOT.FACTCD — NOT NULL
- LAYOUTNO — varchar(20) — Foreign key → T8200D_LOT.LAYOUTNO — NOT NULL
- LOTNO — varchar(20) — Foreign key → T8200D_LOT.LOTNO — NOT NULL
- WCCD — varchar(10)
T8200D_PLANCP
- LAYOUTNO — varchar(20) — Primary key — NOT NULL
- LOTNO — varchar(20) — Primary key — NOT NULL
- WORKSEQ — varchar(4) — Primary key — NOT NULL
- WORKSUBSEQ — varchar(4) — Primary key — NOT NULL
- OUTSEQ — varchar(4) — Primary key — NOT NULL
- CPSEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8050H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8050H.FACTCD — NOT NULL
- COMCD — varchar(10) — Foreign key → T8050H.COMCD
T8200D_PLANIDLE
- LAYOUTNO — varchar(20) — Primary key — NOT NULL
- LOTNO — varchar(20) — Primary key — NOT NULL
- WORKSEQ — varchar(4) — Primary key — NOT NULL
- WORKSUBSEQ — varchar(4) — Primary key — NOT NULL
- OUTSEQ — varchar(4) — Primary key — NOT NULL
- IDLESEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8070H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8070H.FACTCD — NOT NULL
- IDLECD — varchar(10) — Foreign key → T8070H.IDLECD
T8200D_PLANOUT
- OUTSEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8200D_PLAN.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8200D_PLAN.FACTCD — NOT NULL
- LAYOUTNO — varchar(20) — Foreign key → T8200D_PLAN.LAYOUTNO — NOT NULL
- LOTNO — varchar(20) — Foreign key → T8200D_PLAN.LOTNO — NOT NULL
- WORKSEQ — varchar(4) — Foreign key → T8200D_PLAN.WORKSEQ — NOT NULL
- WORKSUBSEQ — varchar(4) — Foreign key → T8200D_PLAN.WORKSUBSEQ — NOT NULL
- WCCD — varchar(10)
T8200D_PLANPO
- PONO — varchar(20) — Primary key — NOT NULL
- POSEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8200D_LOT.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8200D_LOT.FACTCD — NOT NULL
- LAYOUTNO — varchar(20) — Foreign key → T8200D_LOT.LAYOUTNO — NOT NULL
- LOTNO — varchar(20) — Foreign key → T8200D_LOT.LOTNO — NOT NULL
- PODEPTCD — varchar(10)
- POPNO — varchar(10)
- CUSTCD — varchar(10)
- ITEMCD — varchar(20)
T8200D_PO
- PONO — varchar(20) — Primary key — NOT NULL
- POSEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8200D_LOT.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8200D_LOT.FACTCD — NOT NULL
- LAYOUTNO — varchar(20) — Foreign key → T8200D_LOT.LAYOUTNO — NOT NULL
- LOTNO — varchar(20) — Foreign key → T8200D_LOT.LOTNO — NOT NULL
- PODEPTCD — varchar(10)
- POPNO — varchar(10)
- CUSTCD — varchar(10)
- ITEMCD — varchar(20)
T8200D_WORK
- LOTNO — varchar(20) — Primary key — NOT NULL
- WORKSEQ — varchar(4) — Primary key — NOT NULL
- WORKSUBSEQ — varchar(4) — Primary key — NOT NULL
- SEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8200H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8200H.FACTCD — NOT NULL
- LAYOUTNO — varchar(20) — Foreign key → T8200H.LAYOUTNO — NOT NULL
- WCCD — varchar(10)
T8200D_WORKCP
- LAYOUTNO — varchar(20) — Primary key — NOT NULL
- LOTNO — varchar(20) — Primary key — NOT NULL
- WORKSEQ — varchar(4) — Primary key — NOT NULL
- WORKSUBSEQ — varchar(4) — Primary key — NOT NULL
- SEQ — varchar(4) — Primary key — NOT NULL
- CPSEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8050H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8050H.FACTCD — NOT NULL
- COMCD — varchar(10) — Foreign key → T8050H.COMCD
T8200D_WORKERTIME
- BIZCD — varchar(10) — Primary key — NOT NULL
- FACTCD — varchar(10) — Primary key — NOT NULL
- LAYOUTNO — varchar(20) — Primary key — NOT NULL
- LOTNO — varchar(20) — Primary key — NOT NULL
- WORKSEQ — varchar(4) — Primary key — NOT NULL
- WORKSUBSEQ — varchar(4) — Primary key — NOT NULL
- SEQ — varchar(4) — Primary key — NOT NULL
- WORKERCNT — int — Primary key — NOT NULL
T8200D_WORKIDLE
- LAYOUTNO — varchar(20) — Primary key — NOT NULL
- LOTNO — varchar(20) — Primary key — NOT NULL
- WORKSEQ — varchar(4) — Primary key — NOT NULL
- WORKSUBSEQ — varchar(4) — Primary key — NOT NULL
- SEQ — varchar(4) — Primary key — NOT NULL
- IDLESEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8070H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8070H.FACTCD — NOT NULL
- IDLECD — varchar(10) — Foreign key → T8070H.IDLECD
T8200H
- FACTCD — varchar(10) — Primary key — NOT NULL
- LAYOUTNO — varchar(20) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key — NOT NULL
- DEPTCD — varchar(10) — Foreign key
- PNO — varchar(10)
T8200H_HIS
- LAYOUTSEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8200H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8200H.FACTCD — NOT NULL
- LAYOUTNO — varchar(20) — Foreign key → T8200H.LAYOUTNO — NOT NULL
T8200H_MATINFO
- COILFILENO — varchar(20) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8200H_MINFO.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8200H_MINFO.FACTCD — NOT NULL
- LAYOUTNO — varchar(20) — Foreign key → T8200H_MINFO.LAYOUTNO — NOT NULL
- MFILENO — varchar(20) — Foreign key → T8200H_MINFO.MFILENO — NOT NULL
T8200H_MINFO
- MFILENO — varchar(20) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8200H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8200H.FACTCD — NOT NULL
- LAYOUTNO — varchar(20) — Foreign key → T8200H.LAYOUTNO — NOT NULL
T8320H
- MERGELAYOUTNO — varchar(20) — Primary key — NOT NULL
- MERGELOTNO — varchar(20) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8200D_LOT.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8200D_LOT.FACTCD — NOT NULL
- LAYOUTNO — varchar(20) — Foreign key → T8200D_LOT.LAYOUTNO — NOT NULL
- LOTNO — varchar(20) — Foreign key → T8200D_LOT.LOTNO — NOT NULL
T8424H
- TRANNO — varchar(20) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key — NOT NULL
- FACTCD — varchar(10) — Foreign key — NOT NULL
- DEPTCD — varchar(10)
- PNO — varchar(10)
- CUSTCD — varchar(10)
- WIPFILENO — varchar(20) — Foreign key
- ITEMCD — varchar(20)
T8425D
- FACTCD — varchar(10) — Primary key — NOT NULL
- DEBTNO — varchar(20) — Primary key — NOT NULL
- SEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key — NOT NULL
- DEPTCD — varchar(10) — Foreign key
- PNO — varchar(10)
- ITEMCD — varchar(20)
T8425DD
- DEBTNO — varchar(20) — Primary key — NOT NULL
- SEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8424H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8424H.FACTCD — NOT NULL
- TRANNO — varchar(20) — Foreign key → T8424H.TRANNO — NOT NULL
- WIPFILENO — varchar(20)
T8425H
- FACTCD — varchar(10) — Primary key — NOT NULL
- DEBTNO — varchar(20) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key — NOT NULL
- DEPTCD — varchar(10)
- PNO — varchar(10)
- CUSTCD — varchar(10) — Foreign key
T8450H
- INSPECSBFILENO — varchar(20) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8200D_WORK.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8200D_WORK.FACTCD — NOT NULL
- LAYOUTNO — varchar(20) — Foreign key → T8200D_WORK.LAYOUTNO
- LOTNO — varchar(20) — Foreign key → T8200D_WORK.LOTNO
- WORKSEQ — varchar(4) — Foreign key → T8200D_WORK.WORKSEQ
- WORKSUBSEQ — varchar(4) — Foreign key → T8200D_WORK.WORKSUBSEQ
- WORKSEQSEQ — varchar(4) — Foreign key → T8200D_WORK.SEQ
T8460H
- PACKSBFILENO — varchar(20) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8200D_WORK.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8200D_WORK.FACTCD — NOT NULL
- LAYOUTNO — varchar(20) — Foreign key → T8200D_WORK.LAYOUTNO
- LOTNO — varchar(20) — Foreign key → T8200D_WORK.LOTNO
- WORKSEQ — varchar(4) — Foreign key → T8200D_WORK.WORKSEQ
- WORKSUBSEQ — varchar(4) — Foreign key → T8200D_WORK.WORKSUBSEQ
- WORKSEQSEQ — varchar(4) — Foreign key → T8200D_WORK.SEQ
T8461D
- PACKFILESEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8461H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8461H.FACTCD — NOT NULL
- PACKFILENO — varchar(20) — Foreign key → T8461H.PACKFILENO — NOT NULL
T8461H
- PACKFILENO — varchar(20) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key — NOT NULL
- FACTCD — varchar(10) — Foreign key — NOT NULL
- WIPFILENO — varchar(20) — Foreign key
- ITEMCD — varchar(20)
T8500D
- PRODSBFILESEQ — varchar(4) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key → T8500H.BIZCD — NOT NULL
- FACTCD — varchar(10) — Foreign key → T8500H.FACTCD — NOT NULL
- PRODSBFILENO — varchar(20) — Foreign key → T8500H.PRODSBFILENO — NOT NULL
T8500H
- PRODSBFILENO — varchar(20) — Primary key — NOT NULL
- BIZCD — varchar(10) — Foreign key — NOT NULL
- FACTCD — varchar(10) — Foreign key — NOT NULL
- WIPFILENO — varchar(20) — Foreign key
- POCUSTCD — varchar(10)
- ITEMCD — varchar(20)