ㅅ

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)