djterp1
테이블 (192)
dt_acnt(계정) (Untitled)
- acntcd (Key) — 기본 키 — NOT NULL
- acntnm (Field)
- agrpcd (Key2) — 외래 키 → dt_agrp(회계).agrpcd — NOT NULL
- unitcd (Key3) — 외래 키 — NOT NULL
- combgb (Field4)
- itemgb (Field5)
- remark (Field6)
- usechk (Field7)
- fworkid (Field8)
- fworkdt (Field9)
- lworkid (Field10)
- lworkdt (Field11)
dt_after(후처리) (CopyOfUntitled)
- aftcd (Key) — 기본 키 — NOT NULL
- aftnm (Field)
- remark (Field2)
- usechk (Field3)
- fworkid (Field4)
- fworkdt (Field5)
- lworkid (Field6)
- lworkdt (Field7)
dt_agrp(회계) (Untitled6)
- agrpcd (Key) — 기본 키 — NOT NULL
- agrpnm (Field)
- djncd (Field2)
- djnnm (Field3)
- remark (Field4)
- usechk (Field5)
- fworkid (Field6)
- fworkdt (Field7)
- lworkid (Field8)
- lworkdt (Field9)
dt_bank (Untitled7)
- bnkcd (Key) — 기본 키 — NOT NULL
- bnknm (Field)
- remark (Field2)
- usechk (Field3)
- fworkid (Field4)
- fworkdt (Field5)
- lworkid (Field6)
- lworkdt (Field7)
dt_bclr(컬러) (CopyOfCopyOfUntitled)
- bclrcd (Key) — 기본 키 — NOT NULL
- bclrnm (Field)
- bndcd (Key2) — 외래 키 → dt_brand(브랜드).bndcd — NOT NULL
- clrgb (Field3)
- dnggb (Field4)
- clrspc (Field5)
- fluogb (Field6)
- blkgb (Field7)
- remark (Field8)
- usechk (Field9)
- fworkid (Field10)
- fworkdt (Field11)
- lworkid (Field12)
- lworkdt (Field13)
dt_bctgl(카테고리) (CopyOfCopyOfCopyOfUntitled)
- bctcd (Key) — 기본 키 — NOT NULL
- bctnm (Field)
- bndcd (Key2) — 외래 키 → dt_brand(브랜드).bndcd — NOT NULL
- remark (Field3)
- usechk (Field4)
- fworkid (Field5)
- fworkdt (Field6)
- lworkid (Field7)
- lworkdt (Field8)
dt_bmdl(모델) (CopyOfCopyOfCopyOfCopyOfUntitled)
- bmdcd (Key) — 기본 키 — NOT NULL
- bmdnm (Field)
- bndcd (Key2) — 외래 키 → dt_brand(브랜드).bndcd — NOT NULL
- remark (Field3)
- usechk (Field4)
- fworkid (Field5)
- fworkdt (Field6)
- lworkid (Field7)
- lworkdt (Field8)
dt_brand(브랜드) (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- bndcd (Key) — 기본 키 — NOT NULL
- bndnm (Field)
- remark (Field2)
- usechk (Field3)
- fworkid (Field4)
- fworkdt (Field5)
- lworkid (Field6)
- lworkdt (Field7)
dt_bsple(샘플단계) (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- bspcd (Key) — 기본 키 — NOT NULL
- bspnm (Field)
- bspno (Field2)
- bndcd (Key2) — 외래 키 → dt_brand(브랜드).bndcd — NOT NULL
- remark (Field4)
- usechk (Field5)
- fworkid (Field6)
- fworkdt (Field7)
- lworkid (Field8)
- lworkdt (Field9)
dt_bsson(시즌) (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- bsscd (Key) — 기본 키 — NOT NULL
- bssnm (Field)
- bndcd (Key2) — 외래 키 → dt_brand(브랜드).bndcd — NOT NULL
- remark (Field3)
- usechk (Field4)
- fworkid (Field5)
- fworkdt (Field6)
- lworkid (Field7)
- lworkdt (Field8)
dt_btstitm (Untitled14)
- btstcd (Key) — 기본 키 — NOT NULL
- btstnm (Field)
- tgrpcd (Key2) — 외래 키 — NOT NULL
- tuntcd (Field3)
- btstsrt (Field4)
- remark (Field5)
- usechk (Field6)
- fworkid (Field7)
- fworkdt (Field8)
- lworkid (Field9)
- lworkdt (Field10)
dt_cbclruse (Untitled112)
- cdowner (Key) — 기본 키 — NOT NULL
- cbclrnm (Key4) — 기본 키 — NOT NULL
- bclrcd (Key5) — 외래 키 → dt_bclr(컬러).bclrcd — NOT NULL
- bndcd (Key3) — 외래 키 → dt_brand(브랜드).bndcd — NOT NULL
- usechk (Field)
- remark (Field2)
- fworkid (Field3)
- fworkdt (Field4)
- lworkid (Field5)
- lworkdt (Field6)
dt_cbmduse (Untitled12)
- cdowner (Key) — 기본 키 — NOT NULL
- cbmdnm (Key4) — 기본 키 — NOT NULL
- bmdcd (Key5) — 외래 키 → dt_bmdl(모델).bmdcd — NOT NULL
- bndcd (Key3) — 외래 키 → dt_brand(브랜드).bndcd — NOT NULL
- usechk (Field)
- remark (Field2)
- fworkid (Field3)
- fworkdt (Field4)
- lworkid (Field5)
- lworkdt (Field6)
dt_chgbclr (Untitled100)
- chgcino (Key) — 기본 키 — NOT NULL
- chgcidt (Field)
- oridplnino (Key2) — 외래 키 → dt_dyetrtpln(염가공).dplnino — NOT NULL
- chgdplnino (Field3)
- chgrsn (Field4)
- remark (Field5)
- fworkid (Field6)
- fworkdt (Field7)
- lworkid (Field8)
- lworkdt (Field9)
dt_clmacptm (Untitled18)
- claptino (Key) — 기본 키 — NOT NULL
- claptidt (Field)
- claptddt (Field2)
- dpccd (Key4) — 외래 키 → dt_delplc(납품처).dpccd — NOT NULL
- clmman (Field4)
- clmphn (Field5)
- clmtxt (Field6)
- clmkcd (Key3) — 외래 키 → dt_clmknd.clmkcd — NOT NULL
- clmacd (Key2) — 외래 키 → dt_clmact.clmacd — NOT NULL
- remark (Field9)
- fworkid (Field10)
- fworkdt (Field11)
- lworkid (Field12)
- lworkdt (Field13)
dt_clmacpts (Untitled113)
- claptino (Key) — 기본 키 — NOT NULL
- claptseq (Key2) — 기본 키 — NOT NULL
- plotno (Field)
- atchgb (Field2)
- pmakrcd (Field3)
- dyeono (Field4)
- prdcd (Key4) — 외래 키 — NOT NULL
- bclrcd (Key3) — 외래 키 → dt_bclr(컬러).bclrcd — NOT NULL
- untlngh (Field7)
- rollqty (Field8)
- remark (Field9)
- fworkid (Field10)
- fworkdt (Field11)
- lworkid (Field12)
- lworkdt (Field13)
dt_clmact (Untitled17)
- clmacd (Key) — 기본 키 — NOT NULL
- clmanm (Field)
- remark (Field2)
- usechk (Field3)
- fworkid (Field4)
- fworkdt (Field5)
- lworkid (Field6)
- lworkdt (Field7)
dt_clmknd (Untitled19)
- clmkcd (Key) — 기본 키 — NOT NULL
- clmknm (Field)
- remark (Field2)
- usechk (Field3)
- fworkid (Field4)
- fworkdt (Field5)
- lworkid (Field6)
- lworkdt (Field7)
dt_cntry (CopyOfUntitled19)
- cntrcd (Key) — 기본 키 — NOT NULL
- cntrnm (Field)
- remark (Field2)
- usechk (Field3)
- fworkid (Field4)
- fworkdt (Field5)
- lworkid (Field6)
- lworkdt (Field7)
dt_comp (Untitled84)
- compcd (Key) — 기본 키 — NOT NULL
- compno (Field)
- compnm (Field2)
- mbgb (Field3)
- compgb (Field4)
- bossnm (Field5)
- opendt (Field6)
- lawno (Field7)
- adrs1 (Field8)
- adrs2 (Field9)
- cform (Field10)
- ckind (Field11)
- phnno (Field12)
- faxno (Field13)
- fmail (Field14)
- cmpknd (Field15)
- usechk (Field16)
- fworkid (Field17)
- fworkdt (Field18)
- lworkid (Field19)
- lworkdt (Field20)
dt_coninfo (Untitled79)
- winid (Key) — 외래 키 — NOT NULL
- conip1 (Field2)
- conip2 (Field3)
- macaddr (Field4)
- remark (Field5)
- fworkid (Field6)
- fworkdt (Field7)
dt_cprduse (Untitled145)
- cdowner (Key) — 기본 키 — NOT NULL
- cprdnm (Key3) — 기본 키 — NOT NULL
- prdcd (Key4) — 외래 키 — NOT NULL
- usechk (Field)
- remark (Field2)
- fworkid (Field3)
- fworkdt (Field4)
- lworkid (Field5)
- lworkdt (Field6)
dt_cstitem (Untitled128)
- custcd (Key3) — 외래 키 → dt_cust(거래처).custcd — NOT NULL
- prdcd (Key) — 외래 키 — NOT NULL
- cstitmno (Field)
- remark (Field2)
- fworkid (Field3)
- fworkdt (Field4)
- lworkid (Field5)
- lworkdt (Field6)
dt_cstknd (Untitled67)
- cstkcd (Key) — 기본 키 — NOT NULL
- cstknm (Field)
- remark (Field2)
- usechk (Field3)
- fworkid (Field4)
- fworkdt (Field5)
- lworkid (Field6)
- lworkdt (Field7)
dt_cstyrn (Untitled129)
- custcd (Key3) — 외래 키 → dt_cust(거래처).custcd — NOT NULL
- yrncd (Key) — 외래 키 — NOT NULL
- cstyrnm (Field)
- remark (Field2)
- fworkid (Field3)
- fworkdt (Field4)
- lworkid (Field5)
- lworkdt (Field6)
dt_curr(통화코드) (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- curcd (Key) — 기본 키 — NOT NULL
- curnm (Field)
- remark (Field2)
- usechk (Field3)
- fworkid (Field4)
- fworkdt (Field5)
- lworkid (Field6)
- lworkdt (Field7)
dt_cust(거래처) (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- custcd (Key) — 기본 키 — NOT NULL
- custnm (Field)
- custgb (Field2)
- cstkcd (Field3)
- compno (Field4)
- compgb (Field5)
- expgb (Field6)
- bossnm (Field7)
- opendt (Field8)
- lawno (Field9)
- adrs1 (Field10)
- adrs2 (Field11)
- cform (Field12)
- ckind (Field13)
- phnno (Field14)
- faxno (Field15)
- fmail (Field16)
- homepg (Field17)
- usechk (Field18)
- remark (Field19)
- fworkid (Field20)
- fworkdt (Field21)
- lworkid (Field22)
- lworkdt (Field23)
- untdtgb (Field24)
dt_custside (Untitled127)
- bndcd (Key3) — 외래 키 → dt_brand(브랜드).bndcd — NOT NULL
- custcd (Key2) — 외래 키 → dt_cust(거래처).custcd — NOT NULL
- untdtgb (Field)
- remark (Field2)
- fworkid (Field3)
- fworkdt (Field4)
- lworkid (Field5)
- lworkdt (Field6)
dt_delog (Untitled80)
- winid (Key) — 외래 키 — NOT NULL
- deltxt (Field2)
- fworkid (Field3)
- fworkdt (Field4)
dt_delplc(납품처) (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- dpccd (Key) — 기본 키 — NOT NULL
- dpcnm (Field)
- cntrcd (Key2) — 외래 키 → dt_cntry.cntrcd — NOT NULL
- bndcd (Key3) — 외래 키 → dt_brand(브랜드).bndcd — NOT NULL
- custcd (Key4) — 외래 키 → dt_cust(거래처).custcd — NOT NULL
- remark (Field5)
- usechk (Field6)
- fworkid (Field7)
- fworkdt (Field8)
- lworkid (Field9)
- lworkdt (Field10)
- ormtrgb (Field11)
dt_djobknd (CopyOfCopyOfUntitled19)
- djkcd (Key) — 기본 키 — NOT NULL
- djknm (Field)
- remark (Field2)
- usechk (Field3)
- fworkid (Field4)
- fworkdt (Field5)
- lworkid (Field6)
- lworkdt (Field7)
- atchgb (Field8)
- pmakrcd (Field9)
dt_dlvrym (Untitled22)
- dlvrino (Key) — 기본 키 — NOT NULL
- dlvridt (Field)
- dlvrddt (Field2)
- dpccd (Key2) — 외래 키 → dt_delplc(납품처).dpccd — NOT NULL
- delvgb (Field4)
- exblnum (Field5)
- remark (Field6)
- fworkid (Field7)
- fworkdt (Field8)
- lworkid (Field9)
- lworkdt (Field10)
dt_dlvrys (CopyOfUntitled22)
- dlvrseq (Key2) — 기본 키 — NOT NULL
- dlvrino (Key3) — 외래 키 → dt_dlvrym.dlvrino — NOT NULL
- ordyino (Key) — 외래 키 — NOT NULL
- ordyseq (Field2)
- ordno (Key4) — 외래 키 — NOT NULL
- dlvlngh (Field4)
- remark (Field6)
- fworkid (Field7)
- fworkdt (Field8)
- lworkid (Field9)
- lworkdt (Field10)
- redlvgb (Field5)
dt_dstkctrl (Untitled29)
- dscino (Key) — 기본 키 — NOT NULL
- dscidt (Field)
- sevtdt (Field2)
- dyecd (Key2) — 외래 키 → dt_dyestf(염조제).dyecd — NOT NULL
- warcd (Key3) — 외래 키 — NOT NULL
- ctrqty (Field5)
- stkcd (Key4) — 외래 키 — NOT NULL
- remark (Field7)
- fworkid (Field8)
- fworkdt (Field9)
- lworkid (Field10)
- lworkdt (Field11)
dt_dwfilter (Untitled71)
- dwfltno (Field)
- winid (Key2) — 외래 키 — NOT NULL
- userid (Key) — 외래 키 — NOT NULL
- dwname (Field4)
- colnm (Field5)
- coltype (Field6)
- coloper (Field7)
- coldata (Field8)
- filtertxt (Field9)
- fworkdt (Field10)
dt_dyebad (CopyOfUntitled222)
- dbadcd (Key) — 기본 키 — NOT NULL
- dgrpnm (Field)
- remark (Field6)
- usechk (Field2)
- fworkid (Field7)
- fworkdt (Field8)
- lworkid (Field9)
- lworkdt (Field10)
- atchgb (Field3)
- pmakrcd (Field4)
dt_dyebttst (Untitled38)
- dtpino (Key2) — 외래 키 → dt_dyetrtpur(염가공발주).dtpino — NOT NULL
- bttstidt (Field)
- bttstddt (Field2)
- bttstgb (Field3)
- rcpchkgb (Field4)
- remark (Field5)
- fworkid (Field6)
- fworkdt (Field7)
- lworkid (Field8)
- lworkdt (Field9)
dt_dyecomb (Untitled3)
- ofileno (Key) — 기본 키 — NOT NULL
- newfileno (Field)
- dyoindt (Field2)
- ordknd (Field3)
- bndcd (Key9) — 외래 키 → dt_brand(브랜드).bndcd — NOT NULL
- dpccd (Key10) — 외래 키 → dt_delplc(납품처).dpccd — NOT NULL
- prdcd (Key12) — 외래 키 — NOT NULL
- bclrcd (Key8) — 외래 키 → dt_bclr(컬러).bclrcd — NOT NULL
- stkuqty (Field8)
- prdqty (Field9)
- unitcd (Key13) — 외래 키 — NOT NULL
- aftcd (Key2) — 외래 키 → dt_after(후처리).aftcd — NOT NULL
- bsscd (Key6) — 외래 키 → dt_bsson(시즌).bsscd — NOT NULL
- bmdcd (Key4) — 외래 키 → dt_bmdl(모델).bmdcd — NOT NULL
- bspcd (Key5) — 외래 키 → dt_bsple(샘플단계).bspcd — NOT NULL
- bctcd (Key3) — 외래 키 → dt_bctgl(카테고리).bctcd — NOT NULL
- rolltxt (Field16)
- urgtgb (Field17)
- atchgb (Field18)
- pmakrcd (Field19)
- odtldt (Field20)
- ptstgb (Field21)
- pmakgb (Field22)
- fbringb (Field23)
- ordno (Key11) — 외래 키 — NOT NULL
- salesnm (Field25)
- jobspc (Field26)
- dyocnc (Field27)
- orgivgb (Field28)
- injobcd (Key7) — 외래 키 — NOT NULL
- ordsumgb (Field30)
- sprdgb (Field31)
- dyoingb (Field32)
- remark (Field33)
- fworkid (Field34)
- fworkdt (Field35)
- lworkid (Field36)
- lworkdt (Field37)
- endrsn (Field38)
- dordendgb (Field39)
dt_dyedone (Untitled23)
- dyegino (Key) — 기본 키 — NOT NULL
- dyegidt (Field)
- dmsncd (Key2) — 외래 키 → dt_dyemsn.dmsncd — NOT NULL
- dplnino (Key4) — 외래 키 → dt_dyetrtpln(염가공).dplnino — NOT NULL
- dyejobgb (Field4)
- djoblngh (Field5)
- unitcd (Key5) — 외래 키 — NOT NULL
- djobwght (Field7)
- cworkcd (Key3) — 외래 키 — NOT NULL
- djobsdt (Field9)
- djobedt (Field10)
- jobstt (Field11)
- remark (Field12)
- fworkid (Field13)
- fworkdt (Field14)
- lworkid (Field15)
- lworkdt (Field16)
dt_dyegrp (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- dgrpcd (Key) — 기본 키 — NOT NULL
- dgrpnm (Field)
- remark (Field8)
- usechk (Field2)
- fworkid (Field9)
- fworkdt (Field10)
- lworkid (Field11)
- lworkdt (Field12)
- atchgb (Field3)
- pmakrcd (Field4)
dt_dyeinp (Untitled30)
- dinino (Key) — 기본 키 — NOT NULL
- dinidt (Field)
- dinpdt (Field2)
- dprino (Field3)
- custcd (Key3) — 외래 키 → dt_cust(거래처).custcd — NOT NULL
- dyecd (Key2) — 외래 키 → dt_dyestf(염조제).dyecd — NOT NULL
- dlotno (Field6)
- warcd (Key4) — 외래 키 — NOT NULL
- dinpqty (Field8)
- pendgb (Field9)
- pedqty (Field10)
- dpedym (Field11)
- remark (Field12)
- fworkid (Field13)
- fworkdt (Field14)
- lworkid (Field15)
- lworkdt (Field16)
dt_dyejobgrps (Untitled31)
- djgrpino (Field)
- djgsubno (Field2)
- dyecd (Key) — 외래 키 → dt_dyestf(염조제).dyecd — NOT NULL
- remark (Field4)
- fworkid (Field5)
- fworkdt (Field6)
- lworkid (Field7)
- lworkdt (Field8)
dt_dyemsn (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- dmsncd (Key) — 기본 키 — NOT NULL
- dmsnnm (Field)
- warcd (Key2) — 외래 키 — NOT NULL
- makrnm (Field3)
- dcapa (Field4)
- dmsntp (Field5)
- dmsngb (Field6)
- usechk (Field7)
- remark (Field8)
- fworkid (Field9)
- fworkdt (Field10)
- lworkid (Field11)
- lworkdt (Field12)
dt_dyeonum (Untitled114)
- bclrcd (Key4) — 외래 키 → dt_bclr(컬러).bclrcd — NOT NULL
- dpccd (Key3) — 외래 키 → dt_delplc(납품처).dpccd — NOT NULL
- prdcd (Key) — 외래 키 — NOT NULL
- dyeonum (Field)
- fworkid (Field2)
- fworkdt (Field3)
dt_dyeorder(파일) (Untitled4)
- ofileno (Key) — 기본 키 — NOT NULL
- dyoindt (Field)
- ordknd (Field2)
- bndcd (Key9) — 외래 키 → dt_brand(브랜드).bndcd — NOT NULL
- dpccd (Key10) — 외래 키 → dt_delplc(납품처).dpccd — NOT NULL
- prdcd (Key12) — 외래 키 — NOT NULL
- bclrcd (Key8) — 외래 키 → dt_bclr(컬러).bclrcd — NOT NULL
- stkuqty (Field7)
- prdqty (Field8)
- unitcd (Key13) — 외래 키 — NOT NULL
- aftcd (Key2) — 외래 키 → dt_after(후처리).aftcd — NOT NULL
- bsscd (Key6) — 외래 키 → dt_bsson(시즌).bsscd — NOT NULL
- bmdcd (Key4) — 외래 키 → dt_bmdl(모델).bmdcd — NOT NULL
- bspcd (Key5) — 외래 키 → dt_bsple(샘플단계).bspcd — NOT NULL
- bctcd (Key3) — 외래 키 → dt_bctgl(카테고리).bctcd — NOT NULL
- rolltxt (Field15)
- atchgb (Field16)
- pmakrcd (Field17)
- odeldt (Field18)
- ptstgb (Field19)
- pmakgb (Field20)
- fbringb (Field21)
- ordno (Key11) — 외래 키 — NOT NULL
- salesnm (Field23)
- jobspc (Field24)
- dyocnc (Field25)
- orgivgb (Field26)
- injobcd (Key7) — 외래 키 — NOT NULL
- ordsumgb (Field28)
- sprdgb (Field29)
- dyoingb (Field30)
- remark (Field31)
- fworkid (Field32)
- fworkdt (Field33)
- lworkid (Field34)
- lworkdt (Field35)
- nnmfileno (Field36)
- dordendgb (Field37)
- endrsn (Field38)
dt_dyepur (Untitled32)
- dprino (Key) — 기본 키 — NOT NULL
- dpridt (Field)
- dpurdt (Field2)
- dyecd (Key2) — 외래 키 → dt_dyestf(염조제).dyecd — NOT NULL
- custcd (Key3) — 외래 키 → dt_cust(거래처).custcd — NOT NULL
- dpurqty (Field5)
- inhopdt (Field6)
- warcd (Key4) — 외래 키 — NOT NULL
- dinpqty (Field8)
- endgb (Field9)
- endrsn (Field10)
- endqty (Field11)
- remark (Field12)
- fworkid (Field13)
- fworkdt (Field14)
- lworkid (Field15)
- lworkdt (Field16)
dt_dyepurend (Untitled33)
- dpeino (Key) — 기본 키 — NOT NULL
- dpeidt (Field)
- dpedym (Field2)
- custcd (Key4) — 외래 키 → dt_cust(거래처).custcd — NOT NULL
- dyecd (Key3) — 외래 키 → dt_dyestf(염조제).dyecd — NOT NULL
- untprc (Field5)
- pedqty (Field6)
- vatgb (Field7)
- curamt (Field8)
- curcd (Key2) — 외래 키 → dt_curr(통화코드).curcd — NOT NULL
- exrate (Field10)
- wonamt (Field11)
- wonvat (Field12)
- wontot (Field13)
- remark (Field14)
- fworkid (Field15)
- fworkdt (Field16)
- lworkid (Field17)
- lworkdt (Field18)
dt_dyepurendpre (Untitled34)
- dpedym (Field)
- custcd (Key3) — 외래 키 → dt_cust(거래처).custcd — NOT NULL
- dyecd (Key) — 외래 키 → dt_dyestf(염조제).dyecd — NOT NULL
- untprc (Field4)
- dinpqty (Field5)
- curcd (Key2) — 외래 키 → dt_curr(통화코드).curcd — NOT NULL
dt_dyercpm (Untitled27)
- drcpino (Key) — 기본 키 — NOT NULL
- drcpidt (Field)
- dpccd (Key3) — 외래 키 → dt_delplc(납품처).dpccd — NOT NULL
- bclrcd (Key2) — 외래 키 → dt_bclr(컬러).bclrcd — NOT NULL
- prdcd (Key4) — 외래 키 — NOT NULL
- recpno (Field5)
- dyemth (Field6)
- atchgb (Field7)
- pmakrcd (Field8)
- revinum (Field9)
- remark (Field10)
- fworkid (Field11)
- fworkdt (Field12)
- lworkid (Field13)
- lworkdt (Field14)
- dyeptrn (Field15)
dt_dyercpmhis (Untitled28)
- drcpino (Key) — 외래 키 → dt_dyercpm.drcpino — NOT NULL
- drcpidt (Field2)
- dpccd (Key3) — 외래 키 → dt_delplc(납품처).dpccd — NOT NULL
- prdcd (Key4) — 외래 키 — NOT NULL
- bclrcd (Key2) — 외래 키 → dt_bclr(컬러).bclrcd — NOT NULL
- recpno (Field6)
- dyemth (Field7)
- atchgb (Field8)
- pmakrcd (Field9)
- revinum (Field10)
- remark (Field11)
- fworkid (Field12)
- fworkdt (Field13)
- lworkid (Field14)
- lworkdt (Field15)
- upjobid (Field16)
- upjobdt (Field17)
dt_dyercps (Untitled20)
- insseq (Key4) — 기본 키 — NOT NULL
- djkcd (Key5) — 외래 키 → dt_djobknd.djkcd — NOT NULL
- drcpino (Key3) — 외래 키 → dt_dyercpm.drcpino — NOT NULL
- dyecd (Key) — 외래 키 → dt_dyestf(염조제).dyecd — NOT NULL
- fmurate (Field)
- useseq (Field2)
- djobdgr (Field3)
- remark (Field4)
- fworkid (Field5)
- fworkdt (Field6)
- lworkid (Field7)
- lworkdt (Field8)
dt_dyercpshis (Untitled21)
- drcpino (Key2) — 외래 키 → dt_dyercpm.drcpino — NOT NULL
- dyecd (Key3) — 외래 키 → dt_dyestf(염조제).dyecd — NOT NULL
- djkcd (Key) — 외래 키 → dt_djobknd.djkcd — NOT NULL
- fmurate (Field4)
- useseq (Field5)
- djobdgr (Field6)
- insseq (Field7)
- revinum (Field8)
- remark (Field9)
- fworkid (Field10)
- fworkdt (Field11)
- lworkid (Field12)
- lworkdt (Field13)
dt_dyerqstm (Untitled24)
- drqsino (Key) — 기본 키 — NOT NULL
- drqsidt (Field)
- dplnino (Key4) — 외래 키 → dt_dyetrtpln(염가공).dplnino — NOT NULL
- dmsncd (Key2) — 외래 키 → dt_dyemsn.dmsncd — NOT NULL
- dyefwght (Field4)
- wtrrate (Field5)
- cworkcd (Key3) — 외래 키 — NOT NULL
- atchgb (Field7)
- pmakrcd (Field8)
- recpno (Field9)
- drqsgb (Field10)
- remark (Field11)
- fworkid (Field12)
- fworkdt (Field13)
- lworkid (Field14)
- lworkdt (Field15)
dt_dyerqsts (CopyOfUntitled21)
- drcpino (Field)
- dyecd (Key2) — 외래 키 → dt_dyestf(염조제).dyecd — NOT NULL
- djkcd (Key) — 외래 키 → dt_djobknd.djkcd — NOT NULL
- fmurate (Field4)
- duseqty (Field5)
- doutdt (Field6)
- doutqty (Field7)
- useseq (Field8)
- djobdgr (Field3)
- insseq (Field14)
- remark (Field9)
- fworkid (Field10)
- fworkdt (Field11)
- lworkid (Field12)
- lworkdt (Field13)
dt_dyestf(염조제) (CopyOfCopyOfUntitled2222)
- dyecd (Key) — 기본 키 — NOT NULL
- dyenm (Field)
- dyegb (Field2)
- dgrpcd (Key2) — 외래 키 → dt_dyegrp.dgrpcd — NOT NULL
- bunitcd (Field7)
- sunitcd (Field8)
- dcasno (Field9)
- dmsds (Field10)
- makrnm (Field3)
- remark (Field4)
- usechk (Field5)
- fworkid (Field11)
- fworkdt (Field12)
- lworkid (Field13)
- lworkdt (Field14)
- atchgb (Field15)
- pmakrcd (Field16)
dt_dyetrtcmt (Untitled39)
- dtpino (Key2) — 외래 키 → dt_dyetrtpur(염가공발주).dtpino — NOT NULL
- dplncmt (Field)
- fworkid (Field2)
- fworkdt (Field3)
- lworkid (Field4)
- lworkdt (Field5)
dt_dyetrtend (CopyOfUntitled4)
- dtpeino (Key) — 기본 키 — NOT NULL
- tinino (Key3) — 기본 키 — NOT NULL
- dtpeidt (Field2)
- dtpedym (Field3)
- dtesubno (Field4)
- custcd (Key6) — 외래 키 → dt_cust(거래처).custcd — NOT NULL
- bclrcd (Field6)
- paylngh (Field7)
- prdqty (Field8)
- frelngh (Field9)
- chgaftcd (Key2) — 외래 키 → dt_after(후처리).aftcd — NOT NULL
- lrsncd (Key4) — 외래 키 — NOT NULL
- untprc (Field12)
- vatgb (Field13)
- curamt (Field14)
- curcd (Key5) — 외래 키 → dt_curr(통화코드).curcd — NOT NULL
- exrate (Field16)
- wonamt (Field17)
- wonvat (Field18)
- wontot (Field19)
- dtpendgb (Field20)
- remark (Field21)
- fworkid (Field22)
- fworkdt (Field23)
- lworkid (Field34)
- lworkdt (Field35)
- chgaftcd (Field38)
- nxtmongb (Field)
dt_dyetrtinp (Untitled40)
- tinino (Key) — 기본 키 — NOT NULL
- tinidt (Field)
- tinpdt (Field2)
- custcd (Key3) — 외래 키 → dt_cust(거래처).custcd — NOT NULL
- dtpino (Key2) — 외래 키 → dt_dyetrtpur(염가공발주).dtpino — NOT NULL
- pvinpno (Field5)
- shptino (Field6)
- shptseq (Field7)
- wrapino (Field8)
- plotno (Field9)
- unitcd (Key4) — 외래 키 — NOT NULL
- tqtylngh (Field10)
- tinpgb (Field12)
- remark (Field13)
- fworkid (Field14)
- fworkdt (Field15)
- lworkid (Field16)
- lworkdt (Field17)
dt_dyetrtpln(염가공) (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- dplnino (Key) — 기본 키 — NOT NULL
- dplnidt (Field)
- dmsncd (Key2) — 외래 키 → dt_dyemsn.dmsncd — NOT NULL
- dtpino (Key3) — 외래 키 → dt_dyetrtpur(염가공발주).dtpino — NOT NULL
- dplnqty (Field4)
- dplnwght (Field5)
- dplnsdt (Field6)
- dplnedt (Field7)
- bcchggb (Field8)
- dplncnc (Field9)
- remark (Field10)
- fworkid (Field11)
- fworkdt (Field12)
- lworkid (Field13)
- lworkdt (Field14)
- dyeono (Field15)
- dtpsubno (Field16)
- dplnendgb (Field17)
- cncrsn (Field18)
- endrsn (Field19)
dt_dyetrtpur(염가공발주) (CopyOfUntitled42)
- dtpino (Key) — 기본 키 — NOT NULL
- dtpidt (Field)
- ofileno (Field2)
- salesnm (Field3)
- ordknd (Field4)
- bndcd (Key5) — 외래 키 → dt_brand(브랜드).bndcd — NOT NULL
- dpccd (Key6) — 외래 키 → dt_delplc(납품처).dpccd — NOT NULL
- prdcd (Key8) — 외래 키 — NOT NULL
- bclrcd (Key4) — 외래 키 → dt_bclr(컬러).bclrcd — NOT NULL
- prdqty (Field9)
- aftcd (Key2) — 외래 키 → dt_after(후처리).aftcd — NOT NULL
- unitcd (Key9) — 외래 키 — NOT NULL
- rolltxt (Field15)
- urgtgb (Field16)
- atchgb (Field17)
- pmakrcd (Field18)
- onewgb (Field19)
- odeldt (Field20)
- ptstgb (Field21)
- ordno (Key7) — 외래 키 — NOT NULL
- jobspc (Field23)
- dyocnc (Field24)
- orgivgb (Field25)
- injobcd (Key3) — 외래 키 — NOT NULL
- remark (Field31)
- fworkid (Field32)
- fworkdt (Field33)
- lworkid (Field34)
- lworkdt (Field35)
- nnmfileno (Field36)
- pmakgb (Field37)
- fbringb (Field38)
- dtrtendgb (Field10)
- endrsn (Field12)
dt_dyetrtseq (Untitled101)
- dplnino (Key2) — 외래 키 → dt_dyetrtpln(염가공).dplnino — NOT NULL
- dyeseq (Field)
- fworkid (Field2)
- fworkdt (Field3)
- lworkid (Field4)
- lworkdt (Field5)
dt_env (Untitled72)
- userid (Key2) — 외래 키 — NOT NULL
- userphn (Field)
- usermail (Field2)
- dwred (Field3)
- dwgrn (Field4)
- dwblu (Field5)
- gfdwred (Field6)
- gfdwgrn (Field7)
- gfdwblu (Field8)
- oddred (Field9)
- oddgrn (Field10)
- oddblu (Field11)
- evenred (Field12)
- evengrn (Field13)
- evenblu (Field14)
- tabsongb (Field15)
- savechk (Field16)
- alertgb (Field17)
- autoret (Field18)
- langgb (Field19)
- lworkdt (Field20)
- fworkdt (Field21)
- clheight (Field22)
- clborder (Field23)
- winid (Key) — 외래 키 — NOT NULL
dt_exrate (Untitled85)
- exrdt (Key) — 기본 키 — NOT NULL
- curcd (Key3) — 외래 키 → dt_curr(통화코드).curcd — NOT NULL
- exrate (Field)
- remark (Field2)
- fworkid (Field3)
- fworkdt (Field4)
- lworkid (Field5)
- lworkdt (Field6)
dt_favolist (Untitled73)
- winid (Key) — 외래 키 — NOT NULL
- userid (Key3) — 외래 키 — NOT NULL
- fworkdt (Field)
dt_fbrc(생지) (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- fbrcd (Key) — 기본 키 — NOT NULL
- ftstgb (Field)
- fdjtno (Field2)
- ftstno (Field3)
- fbrnm (Field4)
- fgrpcd (Key2) — 외래 키 → dt_fbrgrp.fgrpcd — NOT NULL
- fwght (Field6)
- fswght (Field7)
- unitcd (Key4) — 외래 키 — NOT NULL
- fwrng (Field8)
- fwdth (Field10)
- fwcnt (Field11)
- fdnct (Field12)
- fclgh (Field13)
- fgage (Field14)
- ftrpl (Field15)
- fbar (Field16)
- jqdgb (Field17)
- pducd (Key3) — 외래 키 — NOT NULL
- fsizuk (Field19)
- frpm (Field20)
- frnrt (Field21)
- frtcnt (Field22)
- ftkup (Field23)
- cdayv (Field24)
- fmchn (Field25)
- fmcwd (Field26)
- ffeeder (Field27)
- fbrspc (Field28)
- revinum (Field29)
- remark (Field30)
- fpath1 (Field31)
- fname1 (Field32)
- fsize1 (Field33)
- usechk (Field34)
- fworkid (Field35)
- fworkdt (Field36)
- lworkid (Field37)
- lworkdt (Field38)
dt_fbrcfile1 (Untitled83)
- fbrcd (Key2) — 외래 키 → dt_fbrc(생지).fbrcd — NOT NULL
- fname1 (Field)
- fblob1 (Field2)
- fworkid (Field3)
- fworkdt (Field4)
dt_fbrchis (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled2)
- fbrcd (Key3) — 외래 키 → dt_fbrc(생지).fbrcd — NOT NULL
- ftstgb (Field)
- fdjtno (Field2)
- ftstno (Field3)
- fbrnm (Field4)
- fgrpcd (Key2) — 외래 키 → dt_fbrgrp.fgrpcd — NOT NULL
- fwght (Field6)
- fswght (Field7)
- fwrng (Field8)
- unitcd (Key4) — 외래 키 — NOT NULL
- fwdth (Field10)
- fwcnt (Field11)
- fdnct (Field12)
- fclgh (Field13)
- fgage (Field14)
- ftrpl (Field15)
- fbar (Field16)
- fygtxt (Field17)
- pducd (Key) — 외래 키 — NOT NULL
- fsizuk (Field19)
- frpm (Field20)
- frnrt (Field21)
- frtcnt (Field22)
- ftkup (Field23)
- cdayv (Field24)
- fmchn (Field25)
- fmcwd (Field26)
- ffeeder (Field27)
- fbrspc (Field28)
- revinum (Field29)
- remark (Field30)
- fpath1 (Field31)
- fname1 (Field32)
- fsize1 (Field33)
- usechk (Field34)
- fworkid (Field35)
- fworkdt (Field36)
- lworkid (Field37)
- lworkdt (Field38)
- upjobid (Field39)
- upjobdt (Field40)
dt_fbrdone (Untitled44)
- fbrdoino (Key) — 기본 키 — NOT NULL
- fplnino (Field)
- subno (Field2)
- fdiddt (Field3)
- fmsncd (Key2) — 외래 키 → dt_fbrmsn.fmsncd — NOT NULL
- flotno (Field5)
- ylotno (Field6)
- fbrlngh (Field7)
- fbrwght (Field8)
- fbrwtgb (Field9)
- cworkcd (Key3) — 외래 키 — NOT NULL
- fbrjobgb (Field11)
- errcnt (Field12)
- fworkid (Field13)
- fworkdt (Field14)
dt_fbrfrcast (Untitled133)
- fbrplnno (Key) — 기본 키 — NOT NULL
- fppidt (Field)
- fbrcd (Key2) — 외래 키 → dt_fbrc(생지).fbrcd — NOT NULL
- fpplnym (Field3)
- fpurgb (Field4)
- fnedqty (Field5)
- revinum (Field6)
- remark (Field7)
- fworkid (Field8)
- fworkdt (Field9)
- lworkid (Field10)
- lworkdt (Field11)
dt_fbrgrp (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- fgrpcd (Key) — 기본 키 — NOT NULL
- fgrpnm (Field)
- drslgb (Field2)
- fmakgb (Field3)
- remark (Field4)
- usechk (Field5)
- fworkid (Field6)
- fworkdt (Field7)
- lworkid (Field8)
- lworkdt (Field9)
dt_fbrinp (Untitled42)
- finino (Key) — 기본 키 — NOT NULL
- finidt (Field)
- finpdt (Field2)
- frqino (Field3)
- custcd (Key2) — 외래 키 → dt_cust(거래처).custcd — NOT NULL
- fbrcd (Key3) — 외래 키 → dt_fbrc(생지).fbrcd — NOT NULL
- flotno (Field6)
- warcd (Key4) — 외래 키 — NOT NULL
- untlngh (Field8)
- finpqty (Field9)
- pendgb (Field10)
- pefqty (Field11)
- fpedym (Field12)
- remark (Field13)
- fworkid (Field14)
- fworkdt (Field15)
- lworkid (Field16)
- lworkdt (Field17)
- fvinpno (Field18)
- forino (Field19)
dt_fbrlotno (Untitled45)
- flotno (Key) — 기본 키 — NOT NULL
- atchgb (Field)
- fmakrcd (Field2)
- fbrcd (Key3) — 외래 키 → dt_fbrc(생지).fbrcd — NOT NULL
- fmsncd (Key2) — 외래 키 → dt_fbrmsn.fmsncd — NOT NULL
- ylotno (Field5)
- fworkid (Field6)
- fworkdt (Field7)
dt_fbrmove (Untitled43)
- fmvino (Key) — 기본 키 — NOT NULL
- fmvidt (Field)
- fmotdt (Field2)
- flotno (Field3)
- fbrcd (Key3) — 외래 키 → dt_fbrc(생지).fbrcd — NOT NULL
- atchgb (Field5)
- fmakrcd (Field6)
- untlngh (Field7)
- unitcd (Key5) — 외래 키 — NOT NULL
- fmvqty (Field9)
- fwarcd (Field10)
- fjobnm (Field11)
- warcd (Key4) — 외래 키 — NOT NULL
- treqnm (Field13)
- fmindt (Field14)
- forino (Field15)
- remark (Field16)
- fworkid (Field17)
- fworkdt (Field18)
- lworkid (Field19)
- lworkdt (Field20)
- finino (Key2) — 외래 키 → dt_fbrinp.finino — NOT NULL
dt_fbrmsn (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- fmsncd (Key) — 기본 키 — NOT NULL
- fmsnnm (Field)
- warcd (Key2) — 외래 키 — NOT NULL
- drslgb (Field3)
- fmakgb (Field4)
- elhvgb (Field5)
- maxbar (Field6)
- fgage (Field7)
- hspdgb (Field8)
- jqdgb (Field9)
- fmcwd (Field10)
- makrnm (Field11)
- usechk (Field12)
- remark (Field13)
- fworkid (Field14)
- fworkdt (Field15)
- lworkid (Field16)
- lworkdt (Field17)
dt_fbrnoneout (Untitled50)
- fseino (Key) — 기본 키 — NOT NULL
- fseidt (Field)
- fswidt (Field2)
- flotno (Field3)
- warcd (Key5) — 외래 키 — NOT NULL
- fbrcd (Key4) — 외래 키 → dt_fbrc(생지).fbrcd — NOT NULL
- bclrcd (Key3) — 외래 키 → dt_bclr(컬러).bclrcd — NOT NULL
- atchgb (Field7)
- fmakrcd (Field8)
- untlngh (Field9)
- unitcd (Key6) — 외래 키 — NOT NULL
- rollqty (Field11)
- fjobnm (Field12)
- ioutkcd (Key2) — 외래 키 — NOT NULL
- remark (Field14)
- fworkid (Field15)
- fworkdt (Field16)
- lworkid (Field17)
- lworkdt (Field18)
dt_fbroutreq (Untitled134)
- forino (Key) — 기본 키 — NOT NULL
- foridt (Field)
- forddt (Field2)
- ofileno (Field3)
- fbrcd (Key2) — 외래 키 → dt_fbrc(생지).fbrcd — NOT NULL
- forqty (Field5)
- fwarcd (Field6)
- twarcd (Field7)
- inhopdt (Field8)
- fmvqty (Field9)
- outspc (Field10)
- remark (Field11)
- fworkid (Field12)
- fworkdt (Field13)
- lworkid (Field14)
- lworkdt (Field15)
- nnmfileno (Field16)
- dtforqty (Field17)
dt_fbrpurend (Untitled86)
- fpeino (Key) — 기본 키 — NOT NULL
- fpeidt (Field)
- fpedym (Field2)
- fpurgb (Field3)
- custcd (Key3) — 외래 키 → dt_cust(거래처).custcd — NOT NULL
- fbrcd (Key4) — 외래 키 → dt_fbrc(생지).fbrcd — NOT NULL
- untprc (Field6)
- fqtylngh (Field7)
- vatgb (Field8)
- curamt (Field9)
- curcd (Key2) — 외래 키 → dt_curr(통화코드).curcd — NOT NULL
- exrate (Field11)
- wonamt (Field12)
- wonvat (Field13)
- wontot (Field14)
- remark (Field15)
- fworkid (Field16)
- fworkdt (Field17)
- lworkid (Field18)
- lworkdt (Field19)
dt_fbrpurendpre (Untitled87)
- fpedym (Field)
- custcd (Key2) — 외래 키 → dt_cust(거래처).custcd — NOT NULL
- fpurgb (Field3)
- fbrcd (Key3) — 외래 키 → dt_fbrc(생지).fbrcd — NOT NULL
- untprc (Field5)
- untlngh (Field6)
- finpqty (Field7)
- curcd (Key) — 외래 키 → dt_curr(통화코드).curcd — NOT NULL
dt_fbrqst (Untitled46)
- frqino (Key) — 기본 키 — NOT NULL
- frqidt (Field)
- freqdt (Field2)
- atchgb (Field3)
- fmakrcd (Field4)
- fbrcd (Key3) — 외래 키 → dt_fbrc(생지).fbrcd — NOT NULL
- freqqty (Field6)
- frchdt (Field7)
- urgtgb (Field8)
- jobspc (Field9)
- fpurgb (Field10)
- fmsncd (Key2) — 외래 키 → dt_fbrmsn.fmsncd — NOT NULL
- warcd (Key4) — 외래 키 — NOT NULL
- fplnqty (Field13)
- endgb (Field14)
- endrsn (Field15)
- endqty (Field16)
- remark (Field17)
- fworkid (Field18)
- fworkdt (Field19)
- lworkid (Field20)
- lworkdt (Field21)
dt_fbrqstpln (Untitled47)
- fplnino (Key) — 기본 키 — NOT NULL
- fplnidt (Field)
- fmsncd (Key2) — 외래 키 → dt_fbrmsn.fmsncd — NOT NULL
- frqino (Field3)
- fplnqty (Field4)
- fplnsdt (Field5)
- fplnedt (Field6)
- jobfclgh (Field7)
- jobfrpm (Field8)
- endgb (Field9)
- endrsn (Field10)
- jobspc (Field11)
- remark (Field12)
- fworkid (Field13)
- fworkdt (Field14)
- lworkid (Field15)
- lworkdt (Field16)
외 112개 테이블