2020年(ERPMRP管理)速達(dá)erp庫(kù)表結(jié)構(gòu)

1、（ERPMRP管理）速達(dá)erp庫(kù)表結(jié)構(gòu)20XX年XX月多年的企業(yè)涔詢顧詡遢,經(jīng)過實(shí)戰(zhàn)臉證可以落地抑亍的卓越管理方案，值得您下戟用M退貨明細(xì)表（從表）表名：BACKDETAIL描述:記錄所退貨品的詳細(xì)資料字段名中文描述字段類型/長(zhǎng)度否為空說明BACKDRAWID主表IDINTEGERNOTPrimary;TEMNO明細(xì)號(hào)SMALLINTNOTGOODSID貨品IDVARCHAR(20),QUANTITY數(shù)量DOUBLEPRECISION,APRICE單價(jià)DOUBLEPRECISION13退貨單（主表）表名：BACKDRAW描述：字段名中文描述字段類型/長(zhǎng)度是否為空說明BACKDRAWID單據(jù)ID

2、INTEGERNOTPrimary;CODE“XVARCHAR(25)NOTUnique;BILLDATE“據(jù)日期DATE,FLAG中紅標(biāo)志INTEGERREFERBILLID沖紅單IDINTEGEROPERATOR“作員VARCHAR(10),BACKMANID，貨員INTEGER,NSIDM入倉(cāng)庫(kù)號(hào)INTEGER,TOTALAMT總金額DOUBLEPRECISION,MEMO備注VARCHAR(40),UPDATETIME修改日期DATE,RPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT倉(cāng)庫(kù)盤點(diǎn)單（明細(xì)）表名：BALDETAIL

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

4、IDINTEGERBALSID倉(cāng)庫(kù)IDINTEGEROPERATOR操作員VARCHAR(10),TOTALAMT總金額DOUBLEPRECISION,MEMO備注VARCHAR(40),UPDATETIME修改日期DATE,RPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT調(diào)撥從表表名：DALLOT描述：字段名。描述字段類型/字段長(zhǎng)度是否為空說明ALLOTID單據(jù)IDINTEGERNOTPrimary;TEMNO明細(xì)號(hào)SMALLINTNOTPrimaryGOODSID貨品IDVARCHAR(20),QUANTITY數(shù)量DOUBLEP

5、RECISION,APRICE單價(jià)DOUBLEPRECISION所有單據(jù)表表名：DETAILBILLFLOW描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說明D順序號(hào)INTEGERNOTPrimary ；BILLDATE單據(jù)日期DATENOTBILLTYPE單據(jù)類型SMALLINTNOTBILLID單據(jù)IDINTEGERNOTBILLCODE單據(jù)編號(hào)VARCHAR(25)NOTTEMNO明細(xì)號(hào)INTEGERNOTGOODSID貨品IDVARCHAR(20)NOTNQTY增加數(shù)量DOUBLEPRECISIONNPRICE單價(jià)DOUBLEPRECISIONOUTQTY減少數(shù)量DOUBLEPRECI

6、SIONOUTPRICE單價(jià)DOUBLEPRECISIONEQTY庫(kù)存量DOUBLEPRECISIONEPRICE單價(jià)DOUBLEPRECISIONSTOREID倉(cāng)庫(kù)IDINTEGERCACULATEFLAG重新計(jì)算成本底稿標(biāo)志VARCHARNOTNULLNOUTFLAG增加減少標(biāo)志INTEGEREAMOUNT總金額DOUBLEPRECISIONDIFAMOUNT差額DOUBLEPRECISION庫(kù)存變動(dòng)從表表名：DINOUT描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說明NOUTID單據(jù)IDINTEGERNOTPrimary;TEMNO明細(xì)號(hào)SMALLINTNOTPrimaryGOODSI

7、D貨品IDVARCHAR(20)PRICE單價(jià)DOUBLEPRECISIONQUANTITY數(shù)量DOUBLEPRECISIONBACKQTY退貨數(shù)量DOUBLEPRECISIONREFERINOUTID自引用單據(jù)IDINTEGERREFERITEMNO自引用明細(xì)IDINTEGER領(lǐng)料單（明細(xì)）表名：DRAWDETAIL描述：字段名E描述字段類型/字段長(zhǎng)度是否為空說明DRAWITEMID單據(jù)IDINTEGERNOTPrimary;TEMNO明細(xì)號(hào)SMALLINTNOTPrimary ；GOODSID貨品IDVARCHAR(20)QUANTITY數(shù)量DOUBLEPRECISIONAPRICE單價(jià)D

8、OUBLEPRECISION50領(lǐng)料單（主表）表名：DRAWITEM描述：字段名E描述字段類型/字段長(zhǎng)度是否為空說明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)IDSMA

9、LLINTSFLAG傳輸標(biāo)志SMALLINT貨品從表（用于裝拆）表名：GCMB描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說明GOODSID貨品IDVARCHAR(20)NOTPrimaryCMBGOODSID貨品兀素IDVARCHAR(20)NOTPrimaryQTY數(shù)量DOUBLEPRECISION貨品表表名:GOODS描述：字段名中文描述字段類型/長(zhǎng)度是否為空說明GOODSID貨品編碼VARCHAR(20)NOTPrimaryNAME名稱規(guī)格VARCHAR(40)GOODSTYPEID類別編號(hào)SMALLINTGCMID核算方法SMALLINTKIND種類代號(hào)SMALLINTUNIT十位

10、VARCHAR(8)SPRICE計(jì)售價(jià)DOUBLEPRECISIONPPRICE參考進(jìn)價(jià)DOUBLEPRECISIONAPRICE加權(quán)成本價(jià)DOUBLEPRECISIONTOPQTY率存上限D(zhuǎn)OUBLEPRECISIONDOWNQTY率存下限D(zhuǎn)OUBLEPRECISIONCANCMB可組裝/拆卸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à)格DOUBLEPRECISIONL

11、OWPRICE最低價(jià)格DOUBLEPRECISION62貨品初始化表表名：GOODSINIT描述：字段名中文描述字段類型/長(zhǎng)度是否為空說明YEAR年份SMALLINTNOTPrimaryMONTH月份SMALLINTNOTPrimaryGOODSID貨品IDVARCHAR(20)NOTPrimaryBQTY期初數(shù)量DOUBLEPRECISIONBPRICE單價(jià)DOUBLEPRECISIONNQTY本期增加數(shù)量DOUBLEPRECISIONOUTQTY本期減少數(shù)量DOUBLEPRECISIONEQTY期末數(shù)量DOUBLEPRECISIONEPRICE單價(jià)DOUBLEPRECISIONBAMOUN

12、T期初金額DOUBLEPRECISIONEAMOUNT期末金額DOUBLEPRECISION63貨品類型表名:GOODSTYPE描述：字段名中文描述字段類型/長(zhǎng)度是否為空說明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)度是否為空說明NPRODUCTID單據(jù)IDINTEGERNOTPrimary;TEMNO明細(xì)號(hào)SMALLINTNOT

13、NULLPrimaryGOODSID貨品IDVARCHAR(20)QUANTITY卜量DOUBLEPRECISIONPRICE價(jià)DOUBLEPRECISION庫(kù)存變動(dòng)單表名：INOUT描述：字段名中文描述字段類型/長(zhǎng)度是否為空說明NOUTID單據(jù)IDINTEGERNOTNULLPrimaryCODE“據(jù)編號(hào)VARCHAR(25)NOTUniqueBILLDATE“XDATEFLAG中紅標(biāo)志INTEGERREFERBILLID沖紅單IDINTEGEROPERATORM作員VARCHAR(10)STOREIDa庫(kù)號(hào)INTEGERSATID進(jìn)/出標(biāo)志SMALLINTPEOPLE“作人VARCHAR(

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

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

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

17、maryGOODSID貨品IDVARCHAR(20)QUANTITY數(shù)量DOUBLEPRECISIONRCVDQTY收貨數(shù)量DOUBLEPRECISIONPRICE單價(jià)DOUBLEPRECISIONTAX稅VARCHARTAXRATE稅率DOUBLEPRECISIONCLOSED使用標(biāo)志VARCHARDISC折扣DOUBLEPRECISION93采購(gòu)付款表名:PAY描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說明PAYID單據(jù)IDINTEGERNOTPrimary;CODE單據(jù)編號(hào)VARCHAR(25)NOTUniqueBILLDATE單據(jù)日期DATEFLAG沖紅標(biāo)志INTEGERREFER

18、BILLID沖紅單IDINTEGEROPERATOR懊作員VARCHAR(10)VENDORID業(yè)務(wù)員IDINTEGERNOTNULLAMOUNT總金額DOUBLEPRECISIONPAYTYPEID付款方式SMALLINTCHECKNOEg a.K勺VARCHAR(20)BANKID限行號(hào)SMALLINTSPP預(yù)付款標(biāo)志INTEGERMEMO備注VARCHAR(40)UPDATETIME修改日期DATERPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT94采購(gòu)付款從表表名：PAYDETAIL描述：字段名中文描述字段類型/字段長(zhǎng)度是否

19、為空說明PAYID單據(jù)IDINTEGERNOTNULLPrimaryTEMNO明細(xì)號(hào)SMALLINTNOTNULLPrimaryRECIEVEDID采購(gòu)單IDINTEGERAMOUNT金額DOUBLEPRECISION95付款方式表表名:PAYTYPE描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說明PAYTYPEID方式IDSMALLINTNOTNULLPrimaryNAME名稱VARCHAR(16)NOTNULLUniqueBANKID銀行IDSMALLINTUPFLAG發(fā)送標(biāo)志VARCHAR97采購(gòu)定單主表表名：PORDER字段名中文描述描述：字段類型/字段長(zhǎng)度是否為空說明ORDERID

20、單據(jù)IDINTEGERNOTNULLPrimaryCODE單據(jù)編號(hào)VARCHAR(25)NOTUniqueBILLDATEFLAG單據(jù)日期沖紅標(biāo)志DATEINTEGERREFERBILLID沖紅單IDINTEGEROPERATOR懊作員VARCHAR(10)EXEMANID經(jīng)辦人IDINTEGERVENDORID供應(yīng)商IDINTEGERAMOUNT金額DOUBLEPRECISIONMONEYID貨幣IDSMALLINTEXRATEREVDATE率交貨日期DOUBLEPRECISIONDATEBILLTO交貨地址VARCHAR(40)CLOSED使用標(biāo)志VARCHARMEMO備注VARCHAR(

21、40)UPDATETIME修改日期DATERPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT100 米購(gòu)?fù)素洀谋肀砻篜RDETAIL描述：字段名中文描述字段類型/字段長(zhǎng)度是否為空說明PRETURNID單據(jù)IDINTEGERNOTNULLPrimaryTEMNO明細(xì)號(hào)SMALLINTNOTNULLPrimaryGOODSID貨品IDVARCHAR(20)PRICE參考進(jìn)價(jià)DOUBLEPRECISIONQUANTITY數(shù)量DOUBLEPRECISIONTAXRATE稅率DOUBLEPRECISIONDISC折扣DOUBLEPRECISI

22、ONRECIEVEID收貨單IDNTEGERRECIEVEITEMNO收貨單明細(xì)號(hào)SMALLINT101采購(gòu)?fù)素浿鞅肀砻?PRETURN描述：字段名中文描述字段類型/長(zhǎng)度是否為空說明PRETURNID單據(jù)IDINTEGERNOTNULLPrimaryCODE單據(jù)編號(hào)VARCHAR(25)NOTNULLUniqueBILLDATE單據(jù)日期DATEFLAG沖紅標(biāo)志INTEGERREFERBILLID沖紅單IDINTEGEROPERATOR糜作員VARCHAR(10)EXEMANID軍辦人INTEGERSTOREID倉(cāng)庫(kù)IDINTEGERVENDORID供應(yīng)商IDINTEGERNOTNULLTOTA

23、LAMT總金額DOUBLEPRECISIONBACKMONEY是否退現(xiàn)款VARCHAR(1)PAYTYPEID支付方式SMALLINTBANKID銀行IDSMALLINTCHECKNO西立 不勺VARCHAR(20)MEMO備注VARCHAR(40)UPDATETIME修改日期DATERPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT107 米購(gòu)收貨從表表名：RCVDDETAIL“述：字段名中文描述字段類型/長(zhǎng)度是否為空說明RECIEVEDID單據(jù)IDINTEGERNOTNULLPrimaryTEMNO明細(xì)號(hào)SMALLINTNOTNU

24、LLPrimaryGOODSID貨品IDVARCHAR(20)PRICE參考進(jìn)價(jià)DOUBLEPRECISIONAPRICE加權(quán)成本價(jià)DOUBLEPRECISIONTAXRATE稅率DOUBLEPRECISIONQUANTITY數(shù)量DOUBLEPRECISIONRETURNQTY退貨數(shù)量DOUBLEPRECISIONORDERID定單IDINTEGERORDERITEMNO定單明細(xì)號(hào)SMALLINTDISC折扣DOUBLEPRECISION10表名：RECIEVED卜述：字段名中文描述字段類型/長(zhǎng)度是否為空說明RECIEVEDID單據(jù)IDINTEGERNOTNULLPrimaryCODE單據(jù)編號(hào)

25、VARCHAR(25)NOTUniqueBILLDATE單據(jù)日期DATEFLAG沖紅標(biāo)志INTEGER米購(gòu)收貨主表REFERBILLID沖紅單IDINTEGEROPERATOR操作員VARCHAR(10)EXEMANID經(jīng)辦人INTEGERBILLTYPEID單據(jù)類型IDSMALLINTSTOREID倉(cāng)庫(kù)IDINTEGERVENDORID供應(yīng)商IDNTEGERNOTNULLTOTALPAID已付款DOUBLEPRECISIONTOTALAMT總金額DOUBLEPRECISIONMEMO備注VARCHAR(40)TOTALRETURN已退款DOUBLEPRECISIONUPDATETIME修改日

26、期DATERPTID打印/羊式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT113 其他庫(kù)存變動(dòng)表名:SAT描述：字段名中文描述字段類型/長(zhǎng)度是否為空說明SATID單據(jù)IDSMALLINTNOTPrimarySIN出入標(biāo)志VARCHARNEEDBACK退還標(biāo)志VARCHAR表名:STORE描述：字段名中文描述字段類型/長(zhǎng)度是否為空說明STOREID倉(cāng)庫(kù)IDINTEGERNOTPrimaryNAME倉(cāng)庫(kù)名稱VARCHAR(20)NOTUniqueLOCATION地址VARCHAR(40)MEMO備注VARCHAR(40)UPFLAG發(fā)送標(biāo)志VARCHAR(1)倉(cāng)庫(kù)資料11119 倉(cāng)庫(kù)資料初始化表名：STOREGOODSINIT描述：字段名中文描述字段類型/長(zhǎng)度是否為空說明YEAR年份SMALLINTNOTPrimaryMONTH月份SMALLINTNOTPrimarySTOREID倉(cāng)庫(kù)IDINTEGERNOTPrimaryGOODSID貨品IDVARCH