速達(dá)erp庫(kù)表結(jié)構(gòu)

1、退貨明細(xì)表（從表）表名: BACKDETAIL描述:記錄所退貨品的詳細(xì)資料字段名中文描述字段類型/長(zhǎng)度否為空說(shuō)明BACKDRAWID主表IDINTEGERNOTPrimary;ITEMNO明細(xì)號(hào)SMALLINTNOTGOODSID貨品IDVARCHAR(20),QUANTITY數(shù)量DOUBLE PRECISION,APRICE單價(jià)DOUBLE PRECISIONl3 退貨單（主表）表名: BACKDRAW描述：字段名中文描述字段類型/長(zhǎng)度是否為空說(shuō)明BACKDRAWID單據(jù)IDINTEGERNOTPrimary;CODE單據(jù)號(hào)VARCHAR(25)NOTUnique;BILLDATE單據(jù)日期D

2、ATE,FLAG沖紅標(biāo)志INTEGERREFERBILLID沖紅單IDINTEGEROPERATOR操作員VARCHAR(10),BACKMANID退貨員INTEGER,INSID退入倉(cāng)庫(kù)號(hào)INTEGER,TOTALAMT總金額DOUBLE PRECISION,MEMO備注VARCHAR(40),UPDATETIME修改日期DATE,RPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT倉(cāng)庫(kù)盤點(diǎn)單（明細(xì)）表名: BALDETAIL描述：字段名中文描述字段類型/長(zhǎng)度是否為空說(shuō)明BALITEMID盤點(diǎn)單IDINTEGERNOTPrimary;

3、ITEMNO明細(xì)號(hào)SMALLINTNOTPrimary;GOODSID貨品IDVARCHAR(20),QUANTITY數(shù)量DOUBLE PRECISION,APRICE單價(jià)DOUBLE PRECISIONl6 倉(cāng)庫(kù)盤點(diǎn)單表名: BALITEM描述：字段名中文描述字段類型/長(zhǎng)度是否為空說(shuō)明BALITEMID盤點(diǎn)單IDINTEGERNOTPrimary;CODE單據(jù)編號(hào)VARCHAR(25)NOTUniqueBILLDATE單據(jù)日期DATE,FLAG沖紅標(biāo)志INTEGERREFERBILLID沖紅單IDINTEGERBALSID倉(cāng)庫(kù)IDINTEGEROPERATOR操作員VARCHAR(10),T

4、OTALAMT總金額DOUBLE PRECISION,MEMO備注VARCHAR(40),UPDATETIME修改日期DATE,RPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT調(diào)撥從表表名: DALLOT描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說(shuō)明ALLOTID單據(jù)IDINTEGERNOTPrimary;ITEMNO明細(xì)號(hào)SMALLINTNOTPrimaryGOODSID貨品IDVARCHAR(20),QUANTITY數(shù)量DOUBLE PRECISION,APRICE單價(jià)DOUBLE PRECISION所有單據(jù)表表名: DET

5、AILBILLFLOW描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說(shuō)明ID順序號(hào)INTEGERNOTPrimary；BILLDATE單據(jù)日期DATENOTBILLTYPE單據(jù)類型SMALLINTNOTBILLID單據(jù)IDINTEGERNOTBILLCODE單據(jù)編號(hào)VARCHAR(25)NOTITEMNO明細(xì)號(hào)INTEGERNOTGOODSID貨品IDVARCHAR(20)NOTINQTY增加數(shù)量DOUBLE PRECISIONINPRICE單價(jià)DOUBLE PRECISIONOUTQTY減少數(shù)量DOUBLE PRECISIONOUTPRICE單價(jià)DOUBLE PRECISIONEQTY庫(kù)存量

6、DOUBLE PRECISIONEPRICE單價(jià)DOUBLE PRECISIONSTOREID倉(cāng)庫(kù)IDINTEGERCACULATEFLAG重新計(jì)算成本底稿標(biāo)志VARCHAR(1)NOT NULLINOUTFLAG增加減少標(biāo)志INTEGEREAMOUNT總金額DOUBLE PRECISIONDIFAMOUNT差額DOUBLE PRECISION庫(kù)存變動(dòng)從表表名: DINOUT描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說(shuō)明INOUTID單據(jù)IDINTEGERNOTPrimary;ITEMNO明細(xì)號(hào)SMALLINTNOTPrimaryGOODSID貨品IDVARCHAR(20)PRICE單價(jià)D

7、OUBLE PRECISIONQUANTITY數(shù)量DOUBLE PRECISIONBACKQTY退貨數(shù)量DOUBLE PRECISIONREFERINOUTID自引用單據(jù)IDINTEGERREFERITEMNO自引用明細(xì)IDINTEGER領(lǐng)料單（明細(xì)）表名: DRAWDETAIL描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說(shuō)明DRAWITEMID單據(jù)IDINTEGERNOTPrimary;ITEMNO明細(xì)號(hào)SMALLINTNOTPrimary；GOODSID貨品IDVARCHAR(20)QUANTITY數(shù)量DOUBLE PRECISIONAPRICE單價(jià)DOUBLE PRECISION50

8、領(lǐng)料單（主表）表名: DRAWITEM描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說(shuō)明DRAWITEMID單據(jù)IDINTEGERNOTPrimary;CODE單據(jù)編號(hào)VARCHAR(25)NOTUniqueBILLDATE單據(jù)日期DATEFLAG沖紅標(biāo)志INTEGERREFERBILLID沖紅單IDINTEGEROPERATOR操作員VARCHAR(10)DRAWMANID領(lǐng)料人IDINTEGEROUTSID倉(cāng)庫(kù)IDINTEGERMEMO備注VARCHAR(40)UPDATETIME修改日期DATERPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志

9、SMALLINT貨品從表（用于裝拆）表名: GCMB描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說(shuō)明GOODSID貨品IDVARCHAR(20)NOTPrimaryCMBGOODSID貨品元素IDVARCHAR(20)NOTPrimaryQTY數(shù)量DOUBLE PRECISION貨品表表名: GOODS描述：字段名中文描述字段類型/長(zhǎng)度是否為空說(shuō)明GOODSID貨品編碼VARCHAR(20)NOTPrimaryNAME名稱規(guī)格VARCHAR(40)GOODSTYPEID類別編號(hào)SMALLINTGCMID核算方法SMALLINTKIND種類代號(hào)SMALLINTUNIT計(jì)量單位VARCHAR(8

10、)SPRICE參考售價(jià)DOUBLE PRECISIONPPRICE參考進(jìn)價(jià)DOUBLE PRECISIONAPRICE加權(quán)成本價(jià)DOUBLE PRECISIONTOPQTY庫(kù)存上限D(zhuǎn)OUBLE PRECISIONDOWNQTY庫(kù)存下限D(zhuǎn)OUBLE PRECISIONCANCMB可組裝/拆卸VARCHAR(1)CLOSED使用中標(biāo)志VARCHAR(1)UPFLAG發(fā)送標(biāo)志VARCHAR(1)STATUS是否重新計(jì)算成本)VARCHAR(1GOODSCODE貨品條碼VARCHAR(13)SHORTNAME貨品簡(jiǎn)稱VARCHAR(20)HIGHPRICE最高價(jià)格DOUBLE PRECISIONLOW

11、PRICE最低價(jià)格DOUBLE PRECISION62 貨品初始化表表名: GOODSINIT描述：字段名中文描述字段類型/長(zhǎng)度是否為空說(shuō)明YEAR年份SMALLINTNOTPrimaryMONTH月份SMALLINTNOTPrimaryGOODSID貨品IDVARCHAR(20)NOTPrimaryBQTY期初數(shù)量DOUBLE PRECISIONBPRICE單價(jià)DOUBLE PRECISIONINQTY本期增加數(shù)量DOUBLE PRECISIONOUTQTY本期減少數(shù)量DOUBLE PRECISIONEQTY期末數(shù)量DOUBLE PRECISIONEPRICE單價(jià)DOUBLE PRECISI

12、ONBAMOUNT期初金額DOUBLE PRECISIONEAMOUNT期末金額DOUBLE PRECISION63 貨品類型表名: GOODSTYPE描述：字段名中文描述字段類型/長(zhǎng)度是否為空說(shuō)明GOODSTYPEID類型IDSMALLINTNOTPrimaryLCODE編號(hào)VARCHAR(10)NOTNAME名稱VARCHAR(16)NOTNULLDESCRIPTION描述VARCHAR(30)UPFLAG發(fā)送標(biāo)志VARCHAR(1)產(chǎn)品進(jìn)倉(cāng)從表表名: INDETAIL描述：字段名中文描述字段類型/長(zhǎng)度是否為空說(shuō)明INPRODUCTID單據(jù)IDINTEGERNOTPrimary;ITEMN

13、O明細(xì)號(hào)SMALLINTNOT NULLPrimaryGOODSID貨品IDVARCHAR(20)QUANTITY數(shù)量DOUBLE PRECISIONPRICE單價(jià)DOUBLE PRECISION庫(kù)存變動(dòng)單表名: INOUT描述：字段名中文描述字段類型/長(zhǎng)度是否為空說(shuō)明INOUTID單據(jù)IDINTEGERNOT NULLPrimaryCODE單據(jù)編號(hào)VARCHAR(25)NOTUniqueBILLDATE單據(jù)號(hào)DATEFLAG沖紅標(biāo)志INTEGERREFERBILLID沖紅單IDINTEGEROPERATOR操作員VARCHAR(10)STOREID倉(cāng)庫(kù)號(hào)INTEGERSATID進(jìn)/出標(biāo)志SM

14、ALLINTPEOPLE操作人VARCHAR(32)TOTALAMT總金額DOUBLE PRECSIONMEMO備注VARCHAR(40)UPDATETIME修改日期DATERPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT產(chǎn)品進(jìn)倉(cāng)表表名: INPRODUCT描述：字段名中文描述字段類型/長(zhǎng)度是否為空說(shuō)明INVOICEID單據(jù)IDINTEGERNOTPrimary;CODE單據(jù)編號(hào)VARCHAR(25)NOTUniqueBILLDATE單據(jù)日期DATEFLAG沖紅標(biāo)志INTEGERREFERBILLID沖紅單IDINTEGEROPER

15、ATOR操作員VARCHAR(10)BATCHCODE批好VARCHAR(12)INSID進(jìn)倉(cāng)號(hào)INTEGERTOTALAMT總金額DOUBLE PRECISINMEMO備注VARCHAR(40)UPDATETIME修改日期DATERPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT庫(kù)存表表名: ONHAND描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說(shuō)明STOREID倉(cāng)庫(kù)號(hào)INTEGERNOTPrimary;GOODSID貨品IDVARCHAR(20)NOTNULLONHAND數(shù)量DOUBLEPRECISION89 初始化庫(kù)存表名:

16、 ONHANDINIT描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說(shuō)明STOREID倉(cāng)庫(kù)號(hào)INTEGERNOTPrimary;GOODSID貨品IDVARCHAR(20)NOTNULLQTY數(shù)量DOUBLEPRECISION90 總庫(kù)存表表名: ONHANDTABLE描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說(shuō)明GOODSID貨品IDVARCHAR(20)NOT NULLPrimaryTONHAND數(shù)量DOUBLEPRECISION91 操作員表92 采購(gòu)定單從表表名: ORDERDETAIL描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說(shuō)明ORDERID定單IDINTEGERNOT N

17、ULLPrimaryITEMNO明細(xì)號(hào)SMALLINTNOT NULLPrimaryGOODSID貨品IDVARCHAR(20)QUANTITY數(shù)量DOUBLE PRECISIONRCVDQTY收貨數(shù)量DOUBLE PRECISIONPRICE單價(jià)DOUBLE PRECISIONTAX稅VARCHAR(1)TAXRATE稅率DOUBLE PRECISIONCLOSED使用標(biāo)志VARCHAR(1)DISC折扣DOUBLE PRECISION93 采購(gòu)付款表名: PAY描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說(shuō)明PAYID單據(jù)IDINTEGERNOTPrimary;CODE單據(jù)編號(hào)VARCH

18、AR(25)NOTUniqueBILLDATE單據(jù)日期DATEFLAG沖紅標(biāo)志INTEGERREFERBILLID沖紅單IDINTEGEROPERATOR操作員VARCHAR(10)VENDORID業(yè)務(wù)員IDINTEGERNOT NULLAMOUNT總金額DOUBLE PRECISIONPAYTYPEID付款方式SMALLINTCHECKNO票號(hào)VARCHAR(20)BANKID銀行號(hào)SMALLINTISPP預(yù)付款標(biāo)志INTEGERMEMO備注VARCHAR(40)UPDATETIME修改日期DATERPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志

19、SMALLINT94 采購(gòu)付款從表表名: PAYDETAIL描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說(shuō)明PAYID單據(jù)IDINTEGERNOT NULLPrimaryITEMNO明細(xì)號(hào)SMALLINTNOT NULLPrimaryRECIEVEDID采購(gòu)單IDINTEGERAMOUNT金額DOUBLE PRECISION95 付款方式表表名: PAYTYPE描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說(shuō)明PAYTYPEID方式IDSMALLINTNOT NULLPrimaryNAME名稱VARCHAR(16)NOT NULLUniqueBANKID銀行IDSMALLINTUPFLAG發(fā)

20、送標(biāo)志VARCHAR(1)97 采購(gòu)定單主表表名: PORDER描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說(shuō)明ORDERID單據(jù)IDINTEGERNOT NULLPrimaryCODE單據(jù)編號(hào)VARCHAR(25)NOTUniqueBILLDATE單據(jù)日期DATEFLAG沖紅標(biāo)志INTEGERREFERBILLID沖紅單IDINTEGEROPERATOR操作員VARCHAR(10)EXEMANID經(jīng)辦人IDINTEGERVENDORID供應(yīng)商IDINTEGERAMOUNT金額DOUBLE PRECISIONMONEYID貨幣IDSMALLINTEXRATE匯率DOUBLE PRECISIO

21、NREVDATE交貨日期DATEBILLTO交貨地址VARCHAR(40)CLOSED使用標(biāo)志VARCHAR(1)MEMO備注VARCHAR(40)UPDATETIME修改日期DATERPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT100 采購(gòu)?fù)素洀谋肀砻? PRDETAIL描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說(shuō)明PRETURNID單據(jù)IDINTEGERNOT NULLPrimaryITEMNO明細(xì)號(hào)SMALLINTNOT NULLPrimaryGOODSID貨品IDVARCHAR(20)PRICE參考進(jìn)價(jià)DOUBLE P

22、RECISIONQUANTITY數(shù)量DOUBLE PRECISIONTAXRATE稅率DOUBLE PRECISIONDISC折扣DOUBLE PRECISIONRECIEVEID收貨單IDINTEGERRECIEVEITEMNO收貨單明細(xì)號(hào)SMALLINT101 采購(gòu)?fù)素浿鞅肀砻? PRETURN描述：字段名中文描述字段類型/長(zhǎng)度是否為空說(shuō)明PRETURNID單據(jù)IDINTEGERNOT NULLPrimaryCODE單據(jù)編號(hào)VARCHAR(25)NOT NULLUniqueBILLDATE單據(jù)日期DATEFLAG沖紅標(biāo)志INTEGERREFERBILLID沖紅單IDINTEGEROPERA

23、TOR操作員VARCHAR(10)EXEMANID經(jīng)辦人INTEGERSTOREID倉(cāng)庫(kù)IDINTEGERVENDORID供應(yīng)商IDINTEGERNOT NULLTOTALAMT總金額DOUBLE PRECISIONBACKMONEY是否退現(xiàn)款VARCHAR(1)PAYTYPEID支付方式SMALLINTBANKID銀行IDSMALLINTCHECKNO票號(hào)VARCHAR(20)MEMO備注VARCHAR(40)UPDATETIME修改日期DATERPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT107 采購(gòu)收貨從表表名: RCVDD

24、ETAIL描述：字段名中文描述字段類型/長(zhǎng)度是否為空說(shuō)明RECIEVEDID單據(jù)IDINTEGERNOT NULLPrimaryITEMNO明細(xì)號(hào)SMALLINTNOT NULLPrimaryGOODSID貨品IDVARCHAR(20)PRICE參考進(jìn)價(jià)DOUBLE PRECISIONAPRICE加權(quán)成本價(jià)DOUBLE PRECISIONTAXRATE稅率DOUBLE PRECISIONQUANTITY數(shù)量DOUBLE PRECISIONRETURNQTY退貨數(shù)量DOUBLE PRECISIONORDERID定單IDINTEGERORDERITEMNO定單明細(xì)號(hào)SMALLINTDISC折扣DO

25、UBLE PRECISION108 采購(gòu)收貨主表表名: RECIEVED描述：字段名中文描述字段類型/長(zhǎng)度是否為空說(shuō)明RECIEVEDID單據(jù)IDINTEGERNOT NULLPrimaryCODE單據(jù)編號(hào)VARCHAR(25)NOTUniqueBILLDATE單據(jù)日期DATEFLAG沖紅標(biāo)志INTEGERREFERBILLID沖紅單IDINTEGEROPERATOR操作員VARCHAR(10)EXEMANID經(jīng)辦人INTEGERBILLTYPEID單據(jù)類型IDSMALLINTSTOREID倉(cāng)庫(kù)IDINTEGERVENDORID供應(yīng)商IDINTEGERNOT NULLTOTALPAID已付款D

26、OUBLE PRECISIONTOTALAMT總金額DOUBLE PRECISIONMEMO備注VARCHAR(40)TOTALRETURN已退款DOUBLE PRECISIONUPDATETIME修改日期DATERPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT113 其他庫(kù)存變動(dòng)表名: SAT描述：字段名中文描述字段類型/長(zhǎng)度是否為空說(shuō)明SATID單據(jù)IDSMALLINTNOTPrimaryISIN出入標(biāo)志VARCHAR(1)NEEDBACK退還標(biāo)志VARCHAR(1)118 倉(cāng)庫(kù)資料表名: STORE描述：字段名中文描述字段類型/長(zhǎng)度是否為空說(shuō)明STOREID倉(cāng)庫(kù)IDINTEGERNOTPrimaryNAME倉(cāng)庫(kù)名稱VARCHAR(20)NOTUniqueLOCATION地址VARCHAR(40)MEMO備注VARCHAR(40)UPFLAG發(fā)送標(biāo)志VARCHAR(1)119 倉(cāng)庫(kù)資料初始化表名: STOREGOODSINIT描述：字段名中文描述字段類型/長(zhǎng)度是否為空說(shuō)明YEAR年份SMALLINTNOTPrimaryMONTH月份SMALLINTNOTPrimarySTOREID倉(cāng)庫(kù)IDINTEGERNOTPrimaryGOODSID貨品IDVARCHAR(20)NOTPr