速达erp库表结构VIP免费

退货明细表（从表）表名:BACKDETAIL描述:记录所退货品的详细资料字段名中文描述字段类型/长度否为空说明BACKDRAWID主表IDINTEGERNOTPrimary;ITEMNO明细号SMALLINTNOTGOODSID货品IDVARCHAR(20),QUANTITY数量DOUBLEPRECISION,APRICE单价DOUBLEPRECISIONl3退货单（主表）表名:BACKDRAW描述：字段名中文描述字段类型/长度是否为空说明BACKDRAWID单据IDINTEGERNOTPrimary;CODE单据号VARCHAR(25)NOTUnique;BILLDATE单据日期DATE,FLAG冲红标志INTEGERREFERBILLID冲红单IDINTEGEROPERATOR操作员VARCHAR(10),BACKMANID退货员INTEGER,INSID退入仓库号INTEGER,TOTALAMT总金额DOUBLEPRECISION,MEMO备注VARCHAR(40),UPDATETIME修改日期DATE,RPTID打印样式IDINTEGERSHOPID分支机构IDSMALLINTSFLAG传输标志SMALLINT仓库盘点单（明细）表名:BALDETAIL描述：字段名中文描述字段类型/长度是否为空说明BALITEMID盘点单IDINTEGERNOTPrimary;ITEMNO明细号SMALLINTNOTPrimary;GOODSID货品IDVARCHAR(20),QUANTITY数量DOUBLEPRECISION,APRICE单价DOUBLEPRECISIONl6仓库盘点单表名:BALITEM描述：字段名中文描述字段类型/长度是否为空说明BALITEMID盘点单IDINTEGERNOTPrimary;CODE单据编号VARCHAR(25)NOTUniqueBILLDATE单据日期DATE,FLAG冲红标志INTEGERREFERBILLID冲红单IDINTEGERBALSID仓库IDINTEGEROPERATOR操作员VARCHAR(10),TOTALAMT总金额DOUBLEPRECISION,MEMO备注VARCHAR(40),UPDATETIME修改日期DATE,RPTID打印样式IDINTEGERSHOPID分支机构IDSMALLINTSFLAG传输标志SMALLINT调拨从表表名:DALLOT描述：字段名中文描述字段类型/字段长度是否为空说明ALLOTID单据IDINTEGERNOTPrimary;ITEMNO明细号SMALLINTNOTPrimaryGOODSID货品IDVARCHAR(20),QUANTITY数量DOUBLEPRECISION,APRICE单价DOUBLEPRECISION所有单据表表名:DETAILBILLFLOW描述：字段名中文描述字段类型/字段长度是否为空说明ID顺序号INTEGERNOTPrimary；BILLDATE单据日期DATENOTBILLTYPE单据类型SMALLINTNOTBILLID单据IDINTEGERNOTBILLCODE单据编号VARCHAR(25)NOTITEMNO明细号INTEGERNOTGOODSID货品IDVARCHAR(20)NOTINQTY增加数量DOUBLEPRECISIONINPRICE单价DOUBLEPRECISIONOUTQTY减少数量DOUBLEPRECISIONOUTPRICE单价DOUBLEPRECISIONEQTY库存量DOUBLEPRECISIONEPRICE单价DOUBLEPRECISIONSTOREID仓库IDINTEGERCACULATEFLAG重新计算成本底稿标志VARCHAR(1)NOTNULLINOUTFLAG增加减少标志INTEGEREAMOUNT总金额DOUBLEPRECISIONDIFAMOUNT差额DOUBLEPRECISION库存变动从表表名:DINOUT描述：字段名中文描述字段类型/字段长度是否为空说明INOUTID单据IDINTEGERNOTPrimary;ITEMNO明细号SMALLINTNOTPrimaryGOODSID货品IDVARCHAR(20)PRICE单价DOUBLEPRECISIONQUANTITY数量DOUBLEPRECISIONBACKQTY退货数量DOUBLEPRECISIONREFERINOUTID自引用单据IDINTEGERREFERITEMNO自引用明细IDINTEGER领料单（明细）表名:DRAWDETAIL描述：字段名中文描述字段类型/字段长度是否为空说明DRAWITEMID单据IDINTEGERNOTPrimary;ITEMNO明细号SMALLINTNOTPrimary；GOODSID货品IDVARCHAR(20)QUANTITY数量DOUBLEPRECISIONAPRICE单价DOUBLEPRECISION50领料单（主表）表名:DRAWITEM描述：字段名中文描述字段类型/字段长度是否为空说明DRAWITEMID单据IDINTEGERNOTPrimary;CODE单据编号VARCHAR(25)NOTUniqueBILLDATE单据日期DATEFLAG冲红标志INTEGERREFERBILLID冲红单IDINTEGEROPERATOR操作员VARCHAR(10)DRAWMANID领料人IDINTEGEROUTSID仓库IDINTEGERMEMO备注VARCHAR(40)UPDATETIME修改日期DATERPTID打印样式IDINTEGERSHOPID分支机构IDSMALLINTSFLAG传输标志SMALLINT货品从表（用于装拆）表名:GCMB描述：字段名中文描述字段类型/字段长度是否为空说明GOODSID货品IDVARCHAR(20)NOTPrimaryCMBGOODSID货品元素IDVARCHAR(20)NOTPrimaryQTY数量DOUBLEPRECISION货品表表名:GOODS描述：字段名中文描述字段类型/长度是否为空说明GOODSID货品编码VARCHAR(20)NOTPrimaryNAME名称规格VARCHAR(40)GOODSTYPEID类别编号SMALLINTGCMID核算方法SMALLINTKIND种类代号SMALLINTUNIT计量单位VARCHAR(8)SPRICE参...