djerp

Tables (221)

dt_acnt (Untitled)

  • acntcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • acntnm (Field3) — not null
  • agrpcd (Field4) — not null
  • unitcd (Field5) — not null
  • combgb (Field6) — not null
  • itemgb (Field7) — not null
  • remark (Field8) — null
  • usechk (Field9) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • agrpcd (Key2) — not null — Foreign key → dt_agrp.agrpcd — NOT NULL
  • unitcd (Key3) — not null — Foreign key — NOT NULL

dt_after (CopyOfUntitled)

  • aftcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • aftnm (Field3) — not null
  • remark (Field8) — null
  • usechk (Field9) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null

dt_agrp (CopyOfUntitled2)

  • agrpcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • agrpnm (Field3) — not null
  • djncd (Field4) — null
  • djnnm (Field5) — null
  • remark (Field8) — null
  • usechk (Field9) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null

dt_bank (CopyOfCopyOfUntitled)

  • bnkcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • bnknm (Field3) — not null
  • remark (Field8) — null
  • usechk (Field9) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null

dt_bclr (CopyOfUntitled3)

  • bclrcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • bclrnm (Field3) — not null
  • bndcd (Field4) — not null
  • clrgb (Field5) — not null
  • dnggb (Field6) — not null
  • clrspc (Field7) — not null
  • fluogb (Field14) — not null
  • blkgb (Field15) — not null
  • remark (Field8) — null
  • usechk (Field9) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • bndcd (Key2) — not null — Foreign key → dt_brand.bndcd — NOT NULL
  • bndcd (Key3) — not null — Foreign key → dt_brand.bndcd — NOT NULL

dt_bctgl (CopyOfCopyOfUntitled2)

  • bctcd (Key2) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • bctnm (Field3) — not null
  • bndcd (Field4) — not null
  • remark (Field8) — null
  • usechk (Field9) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • bndcd (Key) — not null — Foreign key → dt_brand.bndcd — NOT NULL
  • bndcd (Key3) — not null — Foreign key → dt_brand.bndcd — NOT NULL

dt_bdread (CopyOfCopyOfCopyOfUntitled2)

  • bdlstno (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • viewchk (Field3) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null

dt_bmdl (CopyOfCopyOfCopyOfUntitled22)

  • bmdcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • bmdnm (Field3) — not null
  • bndcd (Field4) — not null
  • usechk (Field9) — not null
  • remark (Field8) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • bndcd (Key2) — not null — Foreign key → dt_brand.bndcd — NOT NULL

dt_board (CopyOfCopyOfCopyOfCopyOfUntitled22)

  • bdlstno (Key2) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • boatt (Field3) — not null
  • boact (Field4) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • bdlstno (Key) — not null — Foreign key → dt_bdread.bdlstno — NOT NULL

dt_brand (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled22)

  • bndcd (Key) — not null — Primary key — NOT NULL
  • bndcd (Key3) — not null — Foreign key — NOT NULL
  • gcmpcd (Field2) — not null
  • bndnm (Field3) — not null
  • boact (Field4) — null
  • remark (Field5) — null
  • usechk (Field6) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null

dt_bsple (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled22)

  • bspcd (Key2) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • bspnm (Field3) — not null
  • bspno (Field4) — not null
  • bndcd (Field) — not null
  • remark (Field5) — null
  • usechk (Field6) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • bndcd (Key) — not null — Foreign key → dt_brand.bndcd — NOT NULL
  • bndcd (Key3) — not null — Foreign key → dt_brand.bndcd — NOT NULL

dt_bsson (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled22)

  • bsscd (Key2) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • bssnm (Field3) — not null
  • remark (Field5) — null
  • usechk (Field6) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • bndcd (Key) — not null — Foreign key → dt_brand.bndcd — NOT NULL
  • bndcd (Key3) — not null — Foreign key → dt_brand.bndcd — NOT NULL

dt_btstitm (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled222)

  • btstcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • btstnm (Field3) — not null
  • tgrpcd (Field4) — not null
  • btstsrt (Field7) — not null
  • remark (Field5) — null
  • usechk (Field6) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • tgrpcd (Key2) — not null — Foreign key — NOT NULL

dt_calnd (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled222)

  • soldt (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • wknd (Field3) — not null
  • daytt (Field4) — not null
  • workt (Field7) — not null
  • rstgb (Field6) — not null
  • remark (Field5) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null

dt_cbclruse (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled2222)

  • cdowner (Key3) — not null — Primary key — NOT NULL
  • bndcd (Key4) — not null — Primary key — NOT NULL
  • bclrcd (Key5) — not null — Primary key — NOT NULL
  • cbclrnm (Key6) — null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • cdowner (Field) — not null
  • bndcd (Field3) — not null
  • bclrcd (Field4) — not null
  • cbclrnm (Field7) — not null
  • usechk (Field6) — not null
  • remark (Field5) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • bclrcd (Key) — not null — Foreign key → dt_bclr.bclrcd — NOT NULL
  • bndcd (Key2) — not null — Foreign key → dt_brand.bndcd — NOT NULL
  • bndcd (Key32) — not null — Foreign key → dt_brand.bndcd — NOT NULL

dt_cbmduse (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled2222)

  • gcmpcd (Field2) — not null
  • cdowner (Field) — not null
  • bndcd (Field3) — not null
  • bmdcd (Field4) — not null
  • cbmdnm (Field7) — not null
  • usechk (Field6) — not null
  • remark (Field5) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • bmdcd (Key) — not null — Foreign key → dt_bmdl.bmdcd — NOT NULL
  • bndcd (Key2) — not null — Foreign key → dt_brand.bndcd — NOT NULL
  • bndcd (Key3) — not null — Foreign key → dt_brand.bndcd — NOT NULL

dt_chgbclr (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled2222)

  • chgcino (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • chgcidt (Field3) — not null
  • oridplnino (Field4) — not null
  • chgdplnino (Field7) — not null
  • chgrsn (Field6) — null
  • remark (Field5) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null

dt_clmacptm (CopyOfCopyOfUntitled3)

  • claptino (Key3) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • claptidt (Field3) — not null
  • claptddt (Field4) — not null
  • dpccd (Field5) — not null
  • clmman (Field6) — null
  • clmphn (Field7) — null
  • clmphn (Field14) — not null
  • clmtxt (Field15) — not null
  • clmkcd (Field16) — not null
  • clmacd (Field17) — not null
  • remark (Field8) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • clmacd (Key) — not null — Foreign key → dt_clmact.clmacd — NOT NULL
  • clmkcd (Key2) — not null — Foreign key → dt_clmknd.clmkcd — NOT NULL
  • dpccd (Key4) — not null — Foreign key → dt_delplc.dpccd — NOT NULL
  • custcd (Key22) — not null — Foreign key → dt_delplc.custcd — NOT NULL
  • bndcd (Key32) — not null — Foreign key → dt_delplc.bndcd — NOT NULL

dt_clmacpts (CopyOfCopyOfCopyOfUntitled3)

  • claptino (Key2) — not null — Primary key — NOT NULL
  • claptseq (Key3) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • plotno (Field4) — not null
  • atchgb (Field5) — not null
  • pmakrcd (Field6) — null
  • dyeono (Field7) — not null
  • prdcd (Field14) — not null
  • bclrcd (Field15) — not null
  • untlngh (Field16) — not null
  • rollqty (Field17) — not null
  • remark (Field8) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • bclrcd (Key) — not null — Foreign key → dt_bclr.bclrcd — NOT NULL
  • bndcd (Key32) — not null — Foreign key → dt_bclr.bndcd — NOT NULL
  • untpdt (Key5) — not null — Foreign key — NOT NULL
  • prccd (Key4) — not null — Foreign key — NOT NULL
  • prdcd (Key6) — not null — Foreign key — NOT NULL

dt_clmact (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled2222)

  • clmacd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • clmanm (Field3) — not null
  • remark (Field5) — null
  • usechk (Field6) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null

dt_clmknd (CopyOfCopyOfUntitled4)

  • clmkcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • clmknm (Field3) — not null
  • remark (Field8) — null
  • usechk (Field9) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null

dt_cntry (CopyOfCopyOfCopyOfUntitled4)

  • cntrcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • cntrnm (Field3) — not null
  • remark (Field8) — null
  • usechk (Field9) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null

dt_comdvc (CopyOfCopyOfUntitled32)

  • dvcno (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • dvcgb (Field3) — not null
  • modnm (Field4) — not null
  • serno (Field5) — null
  • winver (Field6) — null
  • cpu (Field7) — null
  • ram (Field14) — null
  • hdd (Field15) — null
  • ssd (Field16) — null
  • dmaker (Field17) — not null
  • buydt (Field18) — null
  • mkrdt (Field19) — not null
  • remark (Field8) — null
  • usechk (Field9) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null

dt_comdvcuser (CopyOfCopyOfUntitled22)

  • dvcno (Key) — not null — Primary key — NOT NULL
  • usedt (Key2) — not null — Primary key — NOT NULL
  • dvcusernm (Key3) — null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • usedt (Field3) — not null
  • dvpartnm (Field5) — not null
  • dvplc (Field8) — null
  • remark (Field9) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • dvcno (Key4) — not null — Foreign key → dt_comdvc.dvcno — NOT NULL

dt_comp (CopyOfCopyOfCopyOfUntitled32)

  • compcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • compno (Field3) — not null
  • compnm (Field4) — not null
  • mbgb (Field5) — not null
  • compgb (Field6) — not null
  • bossnm (Field7) — not null
  • opendt (Field14) — null
  • lawno (Field15) — null
  • adrs1 (Field16) — null
  • adrs2 (Field17) — null
  • cform (Field18) — null
  • phnno (Field19) — null
  • faxno (Field20) — null
  • fmail (Field21) — null
  • cmpknd (Field22) — not null
  • usechk (Field9) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null

dt_coninfo(Px) (CopyOfCopyOfCopyOfUntitled222)

  • gcmpcd (Field2) — not null
  • winid (Field) — not null
  • conip1 (Field3) — null
  • conip2 (Field4) — null
  • macaddr (Field5) — null
  • remark (Field9) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • winid (Key) — not null — Foreign key — NOT NULL

dt_cprduse (CopyOfCopyOfCopyOfCopyOfUntitled222)

  • cdowner (Key) — not null — Primary key — NOT NULL
  • prdcd (Key2) — not null — Primary key — NOT NULL
  • cprdnm (Key3) — null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • remark (Field9) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field5) — not null
  • lworkdt (Field6) — not null
  • prccd (Key4) — not null — Foreign key — NOT NULL
  • prdcd (Key5) — not null — Foreign key — NOT NULL

dt_cstitem (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled222)

  • custcd (Key2) — not null — Primary key — NOT NULL
  • prdcd (Key3) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • cstitmno (Field4) — not null
  • remark (Field9) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field5) — not null
  • lworkdt (Field6) — not null
  • prccd (Key) — not null — Foreign key — NOT NULL
  • prdcd (Key4) — not null — Foreign key — NOT NULL

dt_cstknd (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled222)

  • cstkcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • cstknm (Field3) — not null
  • remark (Field9) — null
  • fworkid (Field10) — not null
  • usechk (Field4) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field5) — not null
  • lworkdt (Field6) — not null

dt_cstyrn (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled222223)

  • gcmpcd (Field2) — not null
  • custcd (Field) — not null
  • yrncd (Field3) — not null
  • cstyrnm (Field9) — not null
  • remark (Field4) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field5) — not null
  • lworkdt (Field6) — not null
  • custcd (Key) — not null — Foreign key → dt_cust.custcd — NOT NULL
  • custcd (Key22) — not null — Foreign key — NOT NULL
  • yrncd (Key2) — not null — Foreign key — NOT NULL

dt_curr (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled22222)

  • curcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • curnm (Field3) — not null
  • remark (Field9) — null
  • usechk (Field4) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field5) — not null
  • lworkdt (Field6) — not null

dt_cust (CopyOfCopyOfCopyOfCopyOfUntitled32)

  • custcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • custnm (Field3) — not null
  • custgb (Field4) — not null
  • cstkcd (Field5) — null
  • compno (Field6) — null
  • compgb (Field7) — not null
  • expgb (Field14) — not null
  • bossnm (Field15) — null
  • opendt (Field16) — null
  • lawno (Field17) — null
  • adrs1 (Field18) — null
  • adrs2 (Field19) — null
  • cform (Field20) — not null
  • ckind (Field21) — null
  • phnno (Field22) — null
  • faxno (Field9) — NULL
  • fmaail (Field8) — null
  • homepg (Field23) — not null
  • usechk (Field24) — not null
  • remark (Field25) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • untdtgb (Field26) — not null
  • cstkcd (Key2) — not null — Foreign key → dt_cstknd.cstkcd — NOT NULL

dt_custside (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled22222)

  • custcd (Key2) — not null — Primary key — NOT NULL
  • bndcd (Key3) — not null — Primary key — NOT NULL
  • custcd (Key) — not null — Foreign key → dt_cust.custcd — NOT NULL
  • gcmpcd (Field2) — not null
  • untdtgb (Field9) — not null
  • remark (Field4) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field5) — not null
  • lworkdt (Field6) — not null

dt_delog (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled22222)

  • gcmpcd (Field2) — not null
  • winid (Field) — not null
  • deltxt (Field3) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • winid (Key) — not null — Foreign key — NOT NULL
  • winid (Key2) — not null — Foreign key — NOT NULL

dt_delplc (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled222222)

  • dpccd (Key4) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • dpcnm (Field3) — not null
  • cntrcd (Field9) — not null
  • bndcd (Field4) — not null
  • custcd (Field10) — not null
  • fworkdt (Field11) — not null
  • remark (Field7) — null
  • fworkid (Field8) — not null
  • lworkid (Field5) — not null
  • lworkdt (Field6) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • ormtrgb (Field14) — not null
  • bndcd (Key) — not null — Foreign key → dt_brand.bndcd — NOT NULL
  • cntrcd (Key2) — not null — Foreign key → dt_cntry.cntrcd — NOT NULL
  • custcd (Key3) — not null — Foreign key → dt_cust.custcd — NOT NULL
  • custcd (Key22) — not null — Foreign key — NOT NULL
  • bndcd (Key32) — not null — Foreign key → dt_brand.bndcd — NOT NULL

dt_djobknd (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled222223)

  • djkcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • djknm (Field3) — not null
  • remark (Field4) — null
  • usechk (Field9) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field5) — not null
  • lworkdt (Field6) — not null
  • atchgb (Field7) — not null
  • pmakrcd (Field8) — not null

dt_dlvrym (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled222223)

  • dlvrino (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • dlvridt (Field3) — not null
  • dlvrddt (Field4) — not null
  • dpccd (Field9) — not null
  • delvgb (Field10) — not null
  • exblnum (Field11) — null
  • remark (Field12) — null
  • fworkid (Field7) — not null
  • fworkdt (Field8) — not null
  • lworkid (Field5) — not null
  • lworkdt (Field6) — not null
  • dpccd (Key4) — not null — Foreign key → dt_delplc.dpccd — NOT NULL
  • custcd (Key22) — not null — Foreign key → dt_delplc.custcd — NOT NULL
  • bndcd (Key32) — not null — Foreign key → dt_delplc.bndcd — NOT NULL

dt_dlvrys (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled222223)

  • dlvrino (Key) — not null — Primary key — NOT NULL
  • dlvrseq (Key2) — not null — Primary key — NOT NULL
  • dlvrino (Key3) — not null — Foreign key → dt_dlvrym.dlvrino — NOT NULL
  • gcmpcd (Field2) — not null
  • ordyino (Field4) — not null
  • ordyseq (Field9) — not null
  • ordno (Field10) — not null
  • dlvlngh (Field11) — not null
  • remark (Field12) — null
  • fworkid (Field7) — not null
  • fworkdt (Field8) — not null
  • lworkid (Field5) — not null
  • lworkdt (Field6) — not null
  • endlngh (Field13) — not null

dt_dstkctrl (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled222223)

  • dscino (Key3) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • dscidt (Field3) — not null
  • sevtdt (Field4) — not null
  • warcd (Field9) — not null
  • dyecd (Field10) — not null
  • ctrqty (Field11) — not null
  • stkcd (Field12) — not null
  • remark (Field13) — null
  • fworkid (Field7) — not null
  • fworkdt (Field8) — not null
  • lworkid (Field5) — not null
  • lworkdt (Field6) — not null
  • warcd (Key) — not null — Foreign key — NOT NULL
  • stkcd (Key2) — not null — Foreign key — NOT NULL
  • dyecd (Key32) — not null — Foreign key → dt_dyestf.dyecd — NOT NULL

dt_dwfilter(Px) (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled222223)

  • gcmpcd (Field2) — not null
  • dwfltno (Field) — not null
  • winid (Field3) — not null
  • userid (Field4) — not null
  • dwname (Field9) — not null
  • colnm (Field10) — not null
  • coltype (Field11) — not null
  • coloper (Field12) — not null
  • coldata (Field13) — null
  • filtertxt (Field7) — not null
  • fworkdt (Field8) — not null
  • userid (Key) — not null — Foreign key — NOT NULL
  • winid (Key2) — not null — Foreign key — NOT NULL
  • colnm (Key3) — not null — Foreign key — NOT NULL

dt_dyebad (CopyOfCopyOfCopyOfUntitled42)

  • dbadcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • dbadnm (Field3) — not null
  • remark (Field8) — null
  • usechk (Field9) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null

dt_dyebttst (CopyOfCopyOfCopyOfUntitled223)

  • dtpino (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field2) — not null
  • bttstidt (Field3) — not null
  • bttstddt (Field4) — not null
  • bttstgb (Field5) — not null
  • rcpchkgb (Field8) — null
  • remark (Field9) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null

dt_dyecomb (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled32)

  • ofileno (Key5) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • newfileno (Field2) — not null
  • dyoindt (Field4) — not null
  • ordknd (Field5) — not null
  • bndcd (Field6) — not null
  • dpccd (Field7) — not null
  • prdcd (Field14) — not null
  • bclrcd (Field15) — not null
  • stkuqty (Field16) — not null
  • prdqty (Field17) — not null
  • unitcd (Field18) — not null
  • aftcd (Field19) — not null
  • bsscd (Field20) — not null
  • bmdcd (Field21) — not null
  • bspcd (Field22) — not null
  • bctcd (Field9) — not null
  • rolltxt (Field8) — null
  • urgtgb (Field23) — not null
  • atchgb (Field24) — not null
  • pmakrcd (Field27) — not null
  • odeldt (Field28) — not null
  • ptstgb (Field29) — not null
  • pmakgb (Field30) — not null
  • fbringb (Field31) — not null
  • ordno (Field32) — null
  • salesnm (Field33) — not null
  • jobspc (Field34) — null
  • dyocnc (Field35) — not null
  • orgivgb (Field36) — not null
  • injobcd (Field37) — not null
  • ordsumgb (Field38) — not null
  • sprdgb (Field39) — not null
  • dyoingb (Field40) — not null
  • remark (Field25) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • endrsn (Field26) — not null
  • dordendgb (Field41) — not null
  • aftcd (Key) — not null — Foreign key → dt_after.aftcd — NOT NULL
  • bclrcd (Key2) — not null — Foreign key → dt_bclr.bclrcd — NOT NULL
  • bmdcd (Key3) — not null — Foreign key → dt_bmdl.bmdcd — NOT NULL
  • bndcd (Key4) — not null — Foreign key → dt_brand.bndcd — NOT NULL
  • bspcd (Key22) — not null — Foreign key → dt_bsple.bspcd — NOT NULL
  • bsscd (Key23) — not null — Foreign key → dt_bsson.bsscd — NOT NULL
  • dpccd (Key42) — not null — Foreign key → dt_delplc.dpccd — NOT NULL
  • custcd (Key222) — not null — Foreign key → dt_delplc.custcd — NOT NULL
  • bndcd (Key32) — not null — Foreign key → dt_brand.bndcd — NOT NULL
  • unitcd (Key6) — not null — Foreign key — NOT NULL
  • bctcd (Key24) — not null — Foreign key → dt_bctgl.bctcd — NOT NULL
  • prccd (Key7) — not null — Foreign key — NOT NULL
  • ofieno (Key62) — not null — Foreign key — NOT NULL
  • prdcd (Key8) — not null — Foreign key — NOT NULL

dt_dyedone (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled32)

  • dyegino (Key3) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • dyegidt (Field3) — not null
  • dmsncd (Field4) — not null
  • dplnino (Field5) — not null
  • dyejobgb (Field6) — not null
  • djoblngh (Field7) — not null
  • unitcd (Field14) — not null
  • djobwght (Field15) — not null
  • cworkcd (Field16) — not null
  • djobsdt (Field17) — not null
  • djobedt (Field18) — null
  • jobstt (Field19) — not null
  • remark (Field25) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • dmsncd (Key) — not null — Foreign key → dt_dyemsn.dmsncd — NOT NULL
  • cworkcd (Key2) — not null — Foreign key — NOT NULL
  • unitcd (Key4) — not null — Foreign key — NOT NULL

dt_dyegrp (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled32)

  • dgrpcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • dgrpnm (Field3) — not null
  • remark (Field25) — null
  • usechk (Field4) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • atchgb (Field18) — not null
  • pmakrcd (Field19) — not null

dt_dyeinp (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled322)

  • dinino (Key4) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • dinidt (Field3) — not null
  • dinpdt (Field4) — not null
  • dprino (Field5) — not null
  • custcd (Field6) — not null
  • dyecd (Field7) — not null
  • dlotno (Field14) — null
  • warcd (Field15) — not null
  • dinpqty (Field16) — not null
  • pendgb (Field17) — not null
  • dpedym (Field18) — not null
  • remark (Field19) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • dprino (Key) — not null — Foreign key → dt_dyepur.dprino — NOT NULL
  • custcd (Key2) — not null — Foreign key → dt_cust.custcd — NOT NULL
  • custcd (Key22) — not null — Foreign key — NOT NULL
  • warcd (Key3) — not null — Foreign key — NOT NULL

dt_dyejobgrpm (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled322)

  • djgrpino (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • djgrpidt (Field3) — not null
  • djgrpnm (Field4) — not null
  • atchgb (Field5) — not null
  • pmakrcd (Field6) — not null
  • remark (Field19) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null

dt_dyejobgrps(Px) (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled322)

  • gcmpcd (Field) — not null
  • djgrpino (Field2) — not null
  • djgsubno (Field3) — not null
  • dyecd (Field4) — not null
  • remark (Field19) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • djgrpino (Key) — not null — Foreign key → dt_dyejobgrpm.djgrpino — NOT NULL
  • dyecd (Key3) — not null — Foreign key → dt_dyercps.dyecd — NOT NULL

dt_dyemsn (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3222)

  • dmsncd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • dmsnnm (Field3) — not null
  • warcd (Field4) — not null
  • makrnm (Field5) — null
  • dcapa (Field6) — not null
  • dmsntp (Field19) — null
  • dmsngb (Field10) — not null
  • usechk (Field7) — not null
  • fworkid (Field8) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • warcd (Key2) — not null — Foreign key — NOT NULL

dt_dyeonum (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled322)

  • dpccd (Key2) — not null — Primary key — NOT NULL
  • prdcd (Key3) — not null — Primary key — NOT NULL
  • bclrcd (Key5) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • dyeonum (Field19) — not null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • bclrcd (Key) — not null — Foreign key → dt_bclr.bclrcd — NOT NULL
  • dpccd (Key4) — not null — Foreign key → dt_delplc.dpccd — NOT NULL
  • custcd (Key22) — not null — Foreign key → dt_delplc.custcd — NOT NULL
  • bndcd (Key32) — not null — Foreign key → dt_bclr.bndcd — NOT NULL
  • untpdt (Key52) — not null — Foreign key — NOT NULL
  • prccd (Key6) — not null — Foreign key — NOT NULL
  • prdcd (Key7) — not null — Foreign key — NOT NULL

dt_dyeorder (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled322)

  • ofileno (Key6) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • dyoindt (Field2) — not null
  • ordknd (Field4) — not null
  • bndcd (Field5) — not null
  • dpccd (Field6) — not null
  • prdcd (Field7) — not null
  • bclrcd (Field14) — not null
  • stkuqty (Field15) — not null
  • unitcd (Field16) — not null
  • aftcd (Field17) — not null
  • bsscd (Field18) — not null
  • bmdcd (Field19) — not null
  • bspcd (Field20) — not null
  • bctcd (Field21) — not null
  • rolltxt (Field22) — null
  • urgtgb (Field9) — not null
  • atchgb (Field8) — not null
  • pmakrcd (Field23) — not null
  • odeldt (Field24) — not null
  • ptstgb (Field27) — not null
  • pmakgb (Field28) — not null
  • fbringb (Field29) — not null
  • ordno (Field30) — not null
  • salesnm (Field31) — not null
  • jobspc (Field32) — null
  • dyocnc (Field33) — not null
  • orgivgb (Field34) — not null
  • injobcd (Field35) — not null
  • ordsumgb (Field36) — not null
  • sprdgb (Field37) — not null
  • dyoingb (Field38) — not null
  • remark (Field25) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • nnmfileno (Field26) — not null
  • dordendgb (Field41) — not null
  • endrsn (Field39) — null
  • aftcd (Key) — not null — Foreign key → dt_after.aftcd — NOT NULL
  • bclrcd (Key2) — not null — Foreign key → dt_bclr.bclrcd — NOT NULL
  • bmdcd (Key3) — not null — Foreign key → dt_bmdl.bmdcd — NOT NULL
  • bndcd (Key4) — not null — Foreign key → dt_brand.bndcd — NOT NULL
  • bspcd (Key22) — not null — Foreign key → dt_bsple.bspcd — NOT NULL
  • bsscd (Key23) — not null — Foreign key → dt_bsson.bsscd — NOT NULL
  • dpccd (Key42) — not null — Foreign key → dt_delplc.dpccd — NOT NULL
  • injobcd (Key5) — not null — Foreign key — NOT NULL
  • custcd (Key222) — not null — Foreign key → dt_delplc.custcd — NOT NULL
  • bndcd (Key32) — not null — Foreign key → dt_brand.bndcd — NOT NULL
  • unitcd (Key7) — not null — Foreign key — NOT NULL
  • bctcd (Key24) — not null — Foreign key → dt_bctgl.bctcd — NOT NULL
  • prccd (Key8) — not null — Foreign key — NOT NULL
  • prdcd (Key9) — not null — Foreign key — NOT NULL

dt_dyepur (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3222)

  • dprino (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • dpridt (Field3) — not null
  • dpurdt (Field4) — not null
  • custcd (Field5) — not null
  • dyecd (Field6) — not null
  • dpurqty (Field19) — not null
  • inhopdt (Field10) — null
  • warcd (Field7) — not null
  • dinpqty (Field9) — not null
  • endgb (Field14) — not null
  • endrsn (Field15) — null
  • endqty (Field16) — not null
  • remark (Field17) — not null
  • fworkid (Field8) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • custcd (Key2) — not null — Foreign key → dt_cust.custcd — NOT NULL
  • custcd (Key22) — not null — Foreign key — NOT NULL

dt_dyepurend (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3222)

  • dpeino (Key3) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • dpeidt (Field3) — not null
  • dpedym (Field4) — not null
  • custcd (Field5) — not null
  • dyecd (Field6) — not null
  • untprc (Field7) — not null
  • pedqty (Field14) — not null
  • vatgb (Field15) — not null
  • curamt (Field16) — not null
  • curcd (Field17) — not null
  • exrate (Field18) — not null
  • wonamt (Field19) — not null
  • wonvat (Field10) — not null
  • wontot (Field11) — not null
  • remark (Field8) — null
  • fworkid (Field9) — not null
  • fowrkdt (Field20) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • curcd (Key) — not null — Foreign key → dt_curr.curcd — NOT NULL
  • custcd (Key2) — not null — Foreign key → dt_cust.custcd — NOT NULL
  • custcd (Key22) — not null — Foreign key — NOT NULL

dt_dyepurendpre(Px) (Untitled2)

  • gcmpcd (Field) — not null
  • dpedym (Field2) — not null
  • custcd (Field3) — not null
  • dyecd (Field4) — not null
  • untprc (Field5) — not null
  • dinpqty (Field6) — not null
  • curcd (Field7) — not null
  • curcd (Key) — not null — Foreign key → dt_curr.curcd — NOT NULL
  • custcd (Key2) — not null — Foreign key → dt_cust.custcd — NOT NULL
  • custcd (Key22) — not null — Foreign key — NOT NULL

dt_dyercpm (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3222)

  • drcpino (Key2) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • drcpidt (Field3) — not null
  • dpccd (Field4) — not null
  • prdcd (Field5) — not null
  • bclrcd (Field6) — not null
  • recpno (Field19) — not null
  • dyemth (Field10) — not null
  • atchgb (Field7) — not null
  • pmakrcd (Field9) — not null
  • revinum (Field14) — not null
  • remark (Field17) — null
  • fworkid (Field8) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • dyeptrn (Field15) — not null
  • bclrcd (Key) — not null — Foreign key → dt_bclr.bclrcd — NOT NULL
  • dpccd (Key4) — not null — Foreign key → dt_delplc.dpccd — NOT NULL
  • custcd (Key22) — not null — Foreign key → dt_delplc.custcd — NOT NULL
  • bndcd (Key3) — not null — Foreign key → dt_bclr.bndcd — NOT NULL
  • untpdt (Key5) — not null — Foreign key — NOT NULL
  • prccd (Key6) — not null — Foreign key — NOT NULL
  • prdcd (Key7) — not null — Foreign key — NOT NULL

dt_dyercpmhis(Px) (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3222)

  • gcmpcd (Field) — not null
  • drcpino (Field2) — not null
  • drcpidt (Field3) — not null
  • dpccd (Field4) — not null
  • prdcd (Field5) — not null
  • bclrcd (Field6) — not null
  • recpno (Field19) — not null
  • dyemth (Field10) — not null
  • atchgb (Field7) — not null
  • pmakrcd (Field9) — not null
  • revinum (Field14) — not null
  • remark (Field17) — null
  • fworkid (Field8) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • upjobid (Field15) — not null
  • upjobdt (Field16) — not null
  • bclrcd (Key) — not null — Foreign key → dt_bclr.bclrcd — NOT NULL
  • dpccd (Key4) — not null — Foreign key → dt_delplc.dpccd — NOT NULL
  • custcd (Key22) — not null — Foreign key → dt_delplc.custcd — NOT NULL
  • bndcd (Key3) — not null — Foreign key → dt_bclr.bndcd — NOT NULL
  • untpdt (Key5) — not null — Foreign key — NOT NULL
  • prccd (Key2) — not null — Foreign key — NOT NULL
  • prdcd (Key6) — not null — Foreign key — NOT NULL

dt_dyercps (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3222)

  • drcpino (Key2) — not null — Primary key — NOT NULL
  • dyecd (Key3) — not null — Primary key — NOT NULL
  • djkcd (Key4) — not null — Primary key — NOT NULL
  • insseq (Key5) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • fmurate (Field6) — not null
  • useseq (Field19) — not null
  • djobdgr (Field10) — null
  • remark (Field17) — null
  • fworkid (Field8) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • djkcd (Key) — not null — Foreign key → dt_djobknd.djkcd — NOT NULL

dt_dyercpshis(Px) (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3222)

  • gcmpcd (Field) — not null
  • drcpino (Field2) — not null
  • dyecd (Field3) — not null
  • djkcd (Field4) — not null
  • fmurate (Field5) — not null
  • useseq (Field6) — not null
  • djobdgr (Field19) — null
  • insseq (Field10) — not null
  • revinum (Field7) — not null
  • remark (Field17) — null
  • fworkid (Field8) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • upjobid (Field9) — not null
  • upjobdt (Field14) — not null
  • djkcd (Key) — not null — Foreign key → dt_djobknd.djkcd — NOT NULL

dt_dyerqstm (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3222)

  • drqsino (Key3) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • drqsidt (Field3) — not null
  • dplnino (Field4) — not null
  • dmsncd (Field5) — not null
  • dyefwght (Field6) — not null
  • wtrrate (Field19) — not null
  • cworkcd (Field10) — not null
  • atchgb (Field7) — not null
  • pmakrcd (Field17) — not null
  • recpno (Field9) — not null
  • drqsgb (Field14) — not null
  • remark (Field15) — not null
  • fworkid (Field8) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • dmsncd (Key) — not null — Foreign key → dt_dyemsn.dmsncd — NOT NULL
  • cworkcd (Key2) — not null — Foreign key — NOT NULL

dt_dyerqsts(Px) (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3222)

  • gcmpcd (Field) — not null
  • drqsino (Field2) — not null
  • dyecd (Field3) — not null
  • djkcd (Field4) — not null
  • fmurate (Field5) — not null
  • duseqty (Field6) — not null
  • doutdt (Field19) — null
  • doutqty (Field10) — not null
  • useseq (Field7) — not null
  • djobdgr (Field17) — null
  • insseq (Field9) — not null
  • remark (Field15) — not null
  • fworkid (Field8) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • djkcd (Key) — not null — Foreign key → dt_djobknd.djkcd — NOT NULL
  • dyecd (Key3) — not null — Foreign key → dt_dyercps.dyecd — NOT NULL

dt_dyestf (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3222)

  • dyecd (Key2) — not null — Primary key — NOT NULL
  • dyecd (Key3) — not null — Foreign key → dt_dyercps.dyecd — NOT NULL
  • gcmpcd (Field) — not null
  • dyenm (Field3) — not null
  • dgrpcd (Field4) — not null
  • dyegb (Field5) — not null
  • bunitcd (Field6) — not null
  • sunitcd (Field19) — not null
  • dcasno (Field10) — null
  • dmssds (Field7) — not null
  • makrnm (Field17) — null
  • atchgb (Field9) — not null
  • pmakrcd (Field14) — not null
  • remark (Field15) — not null
  • usechk (Field16) — not null
  • fworkid (Field8) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • dgrpcd (Key) — not null — Foreign key → dt_dyegrp.dgrpcd — NOT NULL
  • unitcd (Key4) — not null — Foreign key — NOT NULL

dt_dyetrtcmt (CopyOfUntitled22)

  • dtpino (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • dplncmt (Field3) — null
  • fworkid (Field4) — not null
  • fworkdt (Field5) — not null
  • lworkid (Field6) — not null
  • lworkdt (Field7) — not null
  • dtpino (Key2) — not null — Foreign key → dt_dyebttst.dtpino — NOT NULL

dt_dyetrtend (Untitled5)

  • gcmpcd (Key) — not null — Primary key — NOT NULL
  • dtpeino (Key2) — not null — Primary key — NOT NULL
  • tinino (Key3) — not null — Primary key — NOT NULL
  • dtpeidt (Field) — not null
  • dtpedym (Field2) — not null
  • dtesubno (Field3) — not null
  • custcd (Field4) — not null
  • paylngh (Field5) — not null
  • frelngh (Field6) — not null
  • nxtmongb (Field7) — not null
  • lrsncd (Field8) — not null
  • untprc (Field9) — not null
  • vatgb (Field10) — not null
  • curamt (Field11) — not null
  • curcd (Field12) — not null
  • exrate (Field13) — not null
  • wonamt (Field14) — not null
  • wonvat (Field15) — not null
  • dtpendgb (Field16) — not null
  • remark (Field17) — null
  • fworkid (Field18) — not null
  • fworkdt (Field19) — not null
  • lworkid (Field20) — not null
  • lworkdt (Field21) — not null
  • chgaftcd (Field22) — not null
  • lrsncd (Key4) — not null — Foreign key — NOT NULL
  • curcd (Key5) — not null — Foreign key → dt_curr.curcd — NOT NULL
  • aftcd (Key6) — not null — Foreign key → dt_after.aftcd — NOT NULL
  • custcd (Key7) — not null — Foreign key → dt_cust.custcd — NOT NULL

dt_dyetrtinp (CopyOfUntitled5)

  • gcmpcd (Key) — not null — Primary key — NOT NULL
  • tinino (Key3) — not null — Primary key — NOT NULL
  • tinino (Key32) — not null — Foreign key → dt_dyetrtend.tinino — NOT NULL
  • tinidt (Field2) — not null
  • tinpdt (Field3) — not null
  • custcd (Field4) — not null
  • dtpino (Field5) — not null
  • pvinpno (Field6) — not null
  • shptino (Field7) — not null
  • shptseq (Field8) — not null
  • wrapino (Field9) — not null
  • plotno (Field10) — not null
  • tgtylngh (Field11) — not null
  • unitcd (Field12) — not null
  • tinpgb (Field13) — not null
  • remark (Field17) — null
  • fworkid (Field18) — not null
  • fworkdt (Field19) — not null
  • lworkid (Field20) — not null
  • lworkdt (Field21) — not null
  • unitcd (Key2) — not null — Foreign key — NOT NULL
  • pvinpno (Key4) — not null — Foreign key — NOT NULL

dt_dyetrtpln (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3222)

  • dplnino (Key2) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • dplnidt (Field3) — not null
  • dmsncd (Field4) — not null
  • dtpino (Field5) — not null
  • dplnqty (Field6) — not null
  • dplnwght (Field19) — null
  • dplnsdt (Field10) — not null
  • dplnedt (Field7) — not null
  • bcchggb (Field17) — not null
  • dyeono (Field9) — not null
  • dtpsubno (Field14) — not null
  • dplncnc (Field16) — not null
  • remark (Field15) — not null
  • fworkid (Field8) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • dmsncd (Key) — not null — Foreign key → dt_dyemsn.dmsncd — NOT NULL

dt_dyetrtpur (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled323)

  • dtpino (Key6) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • dtpidt (Field3) — not null
  • ofileno (Field4) — not null
  • nnmfileno (Field5) — null
  • salesnm (Field6) — not null
  • ordknd (Field7) — not null
  • bndcd (Field14) — not null
  • dpccd (Field15) — not null
  • prdcd (Field16) — not null
  • bclrcd (Field17) — not null
  • prdqty (Field18) — not null
  • unitcd (Field19) — not null
  • rolltxt (Field20) — null
  • urgtgb (Field21) — not null
  • atchgb (Field22) — not null
  • pmakrcd (Field9) — not null
  • onewgb (Field8) — not null
  • odeldt (Field23) — not null
  • ptstgb (Field24) — not null
  • pmakgb (Field27) — not null
  • fbringb (Field28) — not null
  • ordno (Field29) — null
  • jobspc (Field30) — null
  • dyocnc (Field31) — not null
  • orgivgb (Field32) — not null
  • injobcd (Field33) — not null
  • aftcd (Field34) — not null
  • remark (Field25) — null
  • fworkid (Field10) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field12) — not null
  • lworkdt (Field13) — not null
  • aftcd (Key) — not null — Foreign key → dt_after.aftcd — NOT NULL
  • bclrcd (Key2) — not null — Foreign key → dt_bclr.bclrcd — NOT NULL
  • bndcd (Key3) — not null — Foreign key → dt_brand.bndcd — NOT NULL
  • dpccd (Key4) — not null — Foreign key → dt_delplc.dpccd — NOT NULL
  • injobcd (Key5) — not null — Foreign key — NOT NULL
  • custcd (Key22) — not null — Foreign key → dt_delplc.custcd — NOT NULL
  • bndcd (Key32) — not null — Foreign key → dt_brand.bndcd — NOT NULL
  • unitcd (Key7) — not null — Foreign key — NOT NULL
  • prccd (Key8) — not null — Foreign key — NOT NULL
  • prdcd (Key9) — not null — Foreign key — NOT NULL

dt_dyetrtseq(Px) (CopyOfCopyOfUntitled222)

  • gcmpcd (Field) — not null
  • dtpino (Field2) — not null
  • dyeseq (Field3) — not null
  • fworkid (Field4) — not null
  • fworkdt (Field5) — not null
  • lworkid (Field6) — not null
  • lworkdt (Field7) — not null
  • dtpino (Key) — not null — Foreign key → dt_dyebttst.dtpino — NOT NULL

dt_env (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled323)

  • userid (Key) — not null — Primary key — NOT NULL
  • userid (Key2) — not null — Foreign key — NOT NULL
  • gcmpcd (Field) — not null
  • userphn (Field3) — null
  • usermail (Field4) — null
  • dwred (Field5) — not null
  • dwgrn (Field6) — not null
  • dwblu (Field7) — not null
  • gfdwred (Field14) — not null
  • gfdwgrn (Field15) — not null
  • gfdwblu (Field16) — not null
  • oddred (Field17) — not null
  • oddgrn (Field18) — not null
  • oddblu (Field19) — not null
  • evenred (Field20) — not null
  • evengrn (Field21) — not null
  • evenblu (Field22) — not null
  • tabsongb (Field9) — not null
  • savechk (Field8) — not null
  • alertgb (Field23) — not null
  • autoret (Field24) — not null
  • langgb (Field27) — not null
  • fbringb (Field28) — not null
  • fworkdt (Field11) — not null
  • lworkdt (Field13) — not null
  • clheight (Field10) — not null
  • clborder (Field12) — not null
  • winid (Field2) — not null
  • winid (Key3) — not null — Foreign key — NOT NULL

dt_exrate (CopyOfCopyOfCopyOfUntitled2222)

  • exrate (Key2) — not null — Primary key — NOT NULL
  • curcd (Key3) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • exrdt (Field2) — not null
  • fworkdt (Field5) — not null
  • remark (Field8) — null
  • fworkid (Field9) — not null
  • fworkdt (Field10) — not null
  • lworkid (Field6) — not null
  • lworkdt (Field7) — not null
  • curcd (Key) — not null — Foreign key → dt_curr.curcd — NOT NULL

dt_favolist (CopyOfCopyOfCopyOfCopyOfUntitled2222)

  • userid (Key2) — not null — Primary key — NOT NULL
  • winid (Key3) — not null — Primary key — NOT NULL
  • winid (Key4) — not null — Foreign key — NOT NULL
  • gcmpcd (Field) — not null
  • fworkdt (Field5) — not null
  • userid (Key) — not null — Foreign key — NOT NULL

dt_fbrc (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3232)

  • fbrcd (Key2) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • ftstgb (Field3) — not null
  • fdjtno (Field4) — not null
  • ftstno (Field5) — not null
  • fbrnm (Field6) — not null
  • fgrpcd (Field7) — not null
  • fwght (Field14) — not null
  • fswght (Field15) — not null
  • fwrng (Field16) — not null
  • unitcd (Field17) — not null
  • fwdth (Field18) — not null
  • fwcnt (Field19) — not null
  • fdnct (Field20) — not null
  • fclgh (Field21) — not null
  • fgage (Field22) — not null
  • ftrpl (Field9) — not null
  • fbar (Field8) — not null
  • jqdgb (Field23) — not null
  • pducd (Field24) — null
  • fsizuk (Field27) — not null
  • frpm (Field28) — not null
  • frnrt (Field29) — not null
  • frtcnt (Field30) — not null
  • ftkup (Field31) — not null
  • cdayv (Field32) — not null
  • fmchn (Field33) — null
  • fmcwd (Field34) — null
  • ffeeder (Field25) — not null
  • fbrspc (Field10) — null
  • revinum (Field11) — not null
  • remark (Field12) — null
  • fpath1 (Field13) — null
  • fname1 (Field26) — null
  • fsize1 (Field35) — null
  • usechk (Field36) — not null
  • fworkid (Field37) — not null
  • fworkdt (Field38) — not null
  • lworkid (Field39) — not null
  • lworkdt (Field40) — not null
  • pducd (Key) — not null — Foreign key — NOT NULL
  • unitcd (Key3) — not null — Foreign key — NOT NULL
  • fgrpcd (Key4) — not null — Foreign key → dt_fbrgrp.fgrpcd — NOT NULL

dt_fbrcfile1 (CopyOfCopyOfCopyOfCopyOfUntitled22222)

  • fbrcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • fname1 (Field3) — null
  • fblob1 (Field4) — null
  • fworkid (Field9) — not null
  • fworkdt (Field10) — not null
  • fbrcd (Key2) — not null — Foreign key → dt_fbrc.fbrcd — NOT NULL

dt_fbrchis(Px) (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3232)

  • gcmpcd (Field) — not null
  • fbrcd (Field2) — not null
  • fbrcd (Field3) — not null
  • ftstgb (Field4) — not null
  • fdjtno (Field5) — not null
  • ftstno (Field6) — null
  • fbrnm (Field7) — not null
  • fgrpcd (Field14) — not null
  • fwght (Field15) — not null
  • fswght (Field16) — not null
  • fwrng (Field17) — not null
  • unitcd (Field18) — not null
  • fwdth (Field19) — not null
  • fwcnt (Field20) — not null
  • fdnct (Field21) — null
  • fclgh (Field22) — not null
  • fgage (Field9) — null
  • ftrpl (Field8) — not null
  • fbar (Field23) — not null
  • fygtxt (Field24) — not null
  • jqdgb (Field27) — not null
  • pducd (Field28) — not null
  • fsizuk (Field29) — not null
  • frpm (Field30) — not null
  • frnrt (Field31) — null
  • frtcnt (Field32) — not null
  • ftkup (Field33) — not null
  • cdayv (Field34) — not null
  • fmchn (Field25) — null
  • fmcwd (Field10) — not null
  • ffeeder (Field11) — not null
  • fbrspc (Field12) — null
  • revinum (Field13) — not null
  • remark (Field26) — null
  • fpath1 (Field35) — not null
  • fsize1 (Field36) — NULL
  • usechk (Field41) — not null
  • fworkid (Field37) — not null
  • fworkdt (Field38) — not null
  • lworkid (Field39) — not null
  • lworkdt (Field40) — not null
  • upjobid (Field42) — not null
  • upjobdt (Field43) — not null
  • pducd (Key) — not null — Foreign key — NOT NULL
  • fbrcd (Key2) — not null — Foreign key → dt_fbrc.fbrcd — NOT NULL
  • unitcd (Key3) — not null — Foreign key — NOT NULL
  • fgrpcd (Key4) — not null — Foreign key → dt_fbrgrp.fgrpcd — NOT NULL

dt_fbrdone(Px) (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3222)

  • gcmpcd (Field) — not null
  • fbrdoino (Field2) — not null
  • fplnino (Field3) — not null
  • subno (Field4) — not null
  • fdiddt (Field5) — not null
  • fmsncd (Field6) — not null
  • flotno (Field19) — not null
  • ylotno (Field10) — not null
  • fbrlngh (Field7) — not null
  • fbrwght (Field17) — not null
  • fbrwtgb (Field9) — not null
  • cworkcd (Field14) — not null
  • fbrjobgb (Field16) — not null
  • errcnt (Field15) — not null
  • fworkid (Field8) — not null
  • fworkdt (Field11) — not null
  • cworkcd (Key) — not null — Foreign key — NOT NULL
  • fplnino (Key3) — not null — Foreign key — NOT NULL

dt_fbrfrcast (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3222)

  • fbrplnno (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • fppidt (Field3) — not null
  • fbrcd (Field4) — not null
  • fpplnym (Field5) — not null
  • fpurgb (Field6) — not null
  • fnedqty (Field19) — not null
  • revinum (Field10) — not null
  • remark (Field7) — null
  • fworkid (Field8) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field16) — not null
  • lworkdt (Field15) — not null
  • fbrcd (Key2) — not null — Foreign key → dt_fbrc.fbrcd — NOT NULL

dt_fbrgrp (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled3222)

  • fgrpcd (Key) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • fgrpnm (Field3) — null
  • drslgb (Field4) — not null
  • fmakgb (Field5) — not null
  • remark (Field7) — null
  • fworkid (Field8) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field16) — not null
  • lworkdt (Field15) — not null

dt_fbrinp (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled323)

  • finino (Key4) — not null — Primary key — NOT NULL
  • gcmpcd (Field) — not null
  • finidt (Field3) — not null
  • finpdt (Field4) — not null
  • frqino (Field5) — not null
  • custcd (Field6) — not null
  • fbrcd (Field7) — not null
  • fvinpno (Field14) — not null
  • flotno (Field15) — not null
  • warcd (Field16) — not null
  • untlngh (Field17) — not null
  • finpqty (Field18) — not null
  • pendgb (Field19) — not null
  • pefqty (Field20) — not null
  • fpedym (Field21) — not null
  • remark (Field28) — null
  • fwrkid (Field8) — not null
  • fworkdt (Field11) — not null
  • lworkid (Field13) — not null
  • lworkdt (Field10) — not null
  • forino (Field12) — not null
  • custcd (Key) — not null — Foreign key → dt_cust.custcd — NOT NULL
  • fbrcd (Key2) — not null — Foreign key → dt_fbrc.fbrcd — NOT NULL
  • fbrcd (Key22) — not null — Foreign key → dt_fbrc.fbrcd — NOT NULL
  • custcd (Key222) — not null — Foreign key — NOT NULL
  • warcd (Key3) — not null — Foreign key — NOT NULL
  • fvinpno (Key5) — not null — Foreign key — NOT NULL

and 141 more tables