資源描述：
《速達(dá)erp庫表結(jié)構(gòu)》由會員上傳分享，免費在線閱讀，更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫。
1、退貨明細(xì)表（從表）表名:BACKDETAIL描述:記錄所退貨品的詳細(xì)資料字段名中文描述字段類型/長度否為空說明BACKDRAWID主表IDINTEGERNOTPrimary;ITEMNO明細(xì)號SMALLINTNOT GOODSID貨品IDVARCHAR(20), QUANTITY數(shù)量DOUBLEPRECISION, APRICE單價DOUBLEPRECISION l3退貨單（主表）表名:BACKDRAW描述：字段名中文描述字段類型/長度是否為空說明BACKDRAWID單據(jù)IDINTEGERNOTPrimary;CODE單據(jù)號VARCHAR(25)NOTUnique;B
2、ILLDATE單據(jù)日期DATE, FLAG沖紅標(biāo)志INTEGER REFERBILLID沖紅單IDINTEGER OPERATOR操作員VARCHAR(10), BACKMANID退貨員INTEGER, INSID退入倉庫號INTEGER, TOTALAMT總金額DOUBLEPRECISION, MEMO備注VARCHAR(40), UPDATETIME修改日期DATE, RPTID打印樣式IDINTEGER SHOPID分支機(jī)構(gòu)IDSMALLINT SFLAG傳輸標(biāo)志SMALLINT 倉庫盤點單（明細(xì)）表名:BALDETAIL描述：字段名中文描述字
3、段類型/長度是否為空說明BALITEMID盤點單IDINTEGERNOTPrimary;ITEMNO明細(xì)號SMALLINTNOTPrimary;GOODSID貨品IDVARCHAR(20), QUANTITY數(shù)量DOUBLEPRECISION, APRICE單價DOUBLEPRECISION l6倉庫盤點單表名:BALITEM描述：字段名中文描述字段類型/長度是否為空說明BALITEMID盤點單IDINTEGERNOTPrimary;CODE單據(jù)編號VARCHAR(25)NOTUniqueBILLDATE單據(jù)日期DATE, FLAG沖紅標(biāo)志INTEGER REFE
4、RBILLID沖紅單IDINTEGER BALSID倉庫IDINTEGER OPERATOR操作員VARCHAR(10), TOTALAMT總金額DOUBLEPRECISION, MEMO備注VARCHAR(40), UPDATETIME修改日期DATE, RPTID打印樣式IDINTEGER SHOPID分支機(jī)構(gòu)IDSMALLINT SFLAG傳輸標(biāo)志SMALLINT 調(diào)撥從表表名:DALLOT描述：字段名中文描述字段類型/字段長度是否為空說明ALLOTID單據(jù)IDINTEGERNOTPrimary;ITEMNO明細(xì)號SMALLINTNOTPrimary
5、GOODSID貨品IDVARCHAR(20), QUANTITY數(shù)量DOUBLEPRECISION, APRICE單價DOUBLEPRECISION 所有單據(jù)表表名:DETAILBILLFLOW描述：字段名中文描述字段類型/字段長度是否為空說明ID順序號INTEGERNOTPrimary；BILLDATE單據(jù)日期DATENOT BILLTYPE單據(jù)類型SMALLINTNOT BILLID單據(jù)IDINTEGERNOT BILLCODE單據(jù)編號VARCHAR(25)NOT ITEMNO明細(xì)號INTEGERNOT GOODSID貨品IDVARCHAR(20)NOT INQT
6、Y增加數(shù)量DOUBLEPRECISION INPRICE單價DOUBLEPRECISION OUTQTY減少數(shù)量DOUBLEPRECISION OUTPRICE單價DOUBLEPRECISION EQTY庫存量DOUBLEPRECISION EPRICE單價DOUBLEPRECISION STOREID倉庫IDINTEGER CACULATEFLAG重新計算成本底稿標(biāo)志VARCHAR(1)NOTNULL INOUTFLAG增加減少標(biāo)志INTEGER EAMOUNT總金額DOUBLEPRECISION DIFAMOUNT差額DOUBLEPRECISION
7、庫存變動從表表名:DINOUT描述：字段名中文描述字段類型/字段長度是否為空說明INOUTID單據(jù)IDINTEGERNOTPrimary;ITEMNO明細(xì)號SMALLINTNOTPrimaryGOODSID貨品IDVARCHAR(20) PRICE單價DOUBLEPRECISION QUANTITY數(shù)量DOUBLEPRECISION BACKQTY退貨數(shù)量DOUBLEPRECISION REFERINOUTID自引用單據(jù)IDINTEGER REFERITEMNO自引用明細(xì)IDINTEGER 領(lǐng)料單（明細(xì)
