还剩23页未读,继续阅读
本资源只提供10页预览,全部文档请下载后查看!喜欢就下载吧,查找使用更方便
文本内容:
图书系统表结构(注意表结构以数据库为准)
一、数据表如下系统基础表
1.C_Employee员工信息表编号字段中文说明类型备注是否为空是否主键1EmployeeID员工IDint是2EName员工姓名varchar203___Code性别varchar24Age年龄int是5StartDate上岗日期datetime6DeptCode工作部门varchar2是7DutyCode职务varchar2是8Phone工作__varchar16是9MobilePhone____varchar11是10varchar是否在岗varchar2是11Photo照片i__ge是12AddDate添加日期datetime13TransFlag传输标记int14DelFlag删除标记int15Re__rk备注varchar50是
2.P_RetailParameter零售参数表编号字段中文说明类型备注是否为空是否主键1IsPrintBill是否打印小票varchar2是2BillTitle小票标题varchar2003IsUseReader是否使用读码器varchar24AllowChangeRebate允许修改折扣varchar25PrintTypesCode打印机类型varchar26Welcome欢迎词varchar507IsPrintNumber打印单号varchar28IsPrintDate打印日期varchar29IsPrintCollector打印收费员varchar210Hint说明varchar10011Phone____varchar
163.Common_Code编码表(一些下拉框的配置信息)编号字段中文说明类型备注是否为空是否主键1CodeID类型int是2Code编码varchar2是3CodeName名称varchar304CodeDesc类型说明varchar605IsValid是否启用varchar36Re__rk备注varchar2007AddDate添加日期datetime
4.P_DefaultValue默认值表编号字段中文说明类型备注是否为空是否主键1TableID表IDint2TableName表名称varchar303FieldName字段名varchar304DefaultValue默认值varchar
1005.Common_DCode行政编码编号字段中文说明类型备注是否为空是否主键1DCode行政编码varchar9是2DName行政名称varchar403ProvName省名varchar104CityName地区名varchar105CountyName县名varchar106ProvCode省编码varchar27CityCode地区编码varchar28CountyCode县编码varchar29Re__rk备注varchar3010AddDate记录增加日期datetime
6.P_SystemParameter系统参数表编号字段中文说明类型备注是否为空是否主键1PID参数IDint是2PName参数名称varchar303ValueType参数值类型varchar24PValue参数值varchar605PStatusCode参数状态varchar26PExplainVarchar2007CanEditvarchar28TransFlagint
7.P_OperationLog操作日志表数据库里没有该表编号字段中文说明类型备注是否为空是否主键1OperationID操作IDbigint是2OperationTypes操作类型varchar23UnitName单元名称varchar34Explain操作说明varchar2005Operator操作人员varchar206OperateTime操作时间datetime
8.Common_User用户表编号字段中文说明类型备注是否为空是否主键1UserID用户代码varchar8是2Password用户__varchar1283re__rk备注varchar2004Status用户状态varchar25AddDate添加日期datetime6CanSeeAllvarchar
29.Common_Role_User角色和用户对照表编号字段中文说明类型备注是否为空是否主键1RoleID角色代码int是2UserID用户代码varchar30是3Com_UserID用户表_用户代码varchar
810.Common_Role角色表编号字段中文说明类型备注是否为空是否主键1RoleID角色代码int是2RoleName角色名称varchar303SysFlag系统标志tinyint4Re__rk备注varchar2005AddDate添加日期datetime
11.Common_Role_Operate操作和角色对照表编号字段中文说明类型备注是否为空是否主键1RoleID角色代码int是2OperateID操作代码varchar32是
12.Common_Operation操作列表编号字段中文说明类型备注是否为空是否主键1OperateID操作代码varchar32是2OperateName操作名称varchar303Re__rk描述varchar
20013.R_ReportCatalog报表目录编号字段中文说明类型备注是否为空是否主键1ReportID报表类型varchar2是2CreateDate统计时间datetime是3BeginDate开始日期datetime4EndDate终止日期datetime5Operator操作员varchar166Re__rk备注varchar507AddDate添加日期datetime8DelFlag删除标记int9ChFlag修改标记int10TransFlag传输标记int
14.客户图书传标记在数据库里没有该表编号字段中文说明类型备注是否为空是否主键1CustomerID客户IDint查询系统表
15、Qry_Types查询类型编号字段中文说明类型备注是否为空是否主键1QueryTypeID类型编码varchar30是2QueryTypeName类型名称varchar
3216、Qry_HeaderList查询的表头列表编号字段中文说明类型备注是否为空是否主键1StatementID查询语句编号int是2FieldID字段varchar40是3FieldWidth字段宽度int4FieldOrder字段顺序tinyint5FieldVisible字段是否显示tinyint
17、Qry_AllFields字段信息表编号字段中文说明类型备注是否为空是否主键1FieldID字段varchar40是2FieldName字段中文名称varchar403FieldType字段类型char14CodeType对应的编码类型int5Pri__ryFlag是否主键tinyint6Condition对应条件varchar
160018、Qry_Statements查询语句列表编号字段中文说明类型备注是否为空是否主键1StatementID查询语句编号int是2TypeID所属查询类型varchar303StatementName查询语句名称varchar304ParentStatementID上级查询语句int5SqlStatement查询语句text6__inTable主表名称varchar307Pri__rykey主键名称varchar1008Pro__ssType是否分页检索tinyint9PageField分页字段名称varchar6010OrderID排列顺序__allint11ExecuteFlag是否执行tinyint12IsSumSQL是否汇总查询tinyint13DelFlagValue对应DelFlag值int14RecycleFlag是否用于回收站tinyint15ExpandLevel可展开的层次tinyint16Re__rk备注varchar
60019、Qry_ClassifyStat分类统计表编号字段中文说明类型备注是否为空是否主键1StatementID查询语句编号int是2ClassifyTableID分类表编号int是3TableName表名称varchar324Pri__ryKey关键字段varchar325TargetField关联目标字段varchar326ExpandLevel展开层次int7Operate比较运算符varchar328SubCondtion附加条件varchar3009ShowField显示字段varchar32不在数据库里10TableName2表名称2varchar32不在数据库里11Pri__ryKey2关键字段2varchar32不在数据库里12TargetField2关联目标字段2varchar32不在数据库里13ShowField2显示字段2varchar32不在数据库里14SubCondition2附加条件2varchar300不在数据库里
20、Qry_Conditions存储的查询条件编号字段中文说明类型备注是否为空是否主键1ConditionID存储查询条件编号int是2StatementID查询语句编号int是3Name查询条件名称varchar304Condition查询条件varchar60005UserID对应用户varchar206IsDefault是否默认查询tinyint7ConditionOrder顺序__allint8Re__rk备注varchar
20021、Qry_FieldsList开放的查询字段编号字段中文说明类型备注是否为空是否主键1StatementID查询语句编号int是2FieldID字段varchar60是3FieldOrder字段顺序int主要业务表
22、U_Register用户注册信息编号字段中文说明类型备注是否为空是否主键1UserID用户IDuniqueidentifier是2UserNumber用户代码varchar303UserName用户名称varchar604ShortName简称varchar305AreaCode所在地varchar96Address详细地址varchar307ZipCode____varchar88Phone____varchar309Fax传真号码varchar2010Contact__n__人varchar2011E__ilE__ilvarchar3012BankName开户银行varchar6013AccountNumber银行帐号varchar3214TaxNumber增值税__账号varchar3015TaxAddress增值税发地址varchar6016TaxBank增值税发开户行varchar6017SizeCode单位规模char218RegisterDate注册日期datetime
23、P_PubCompany出版社信息出版社基础信息编号字段中文说明类型备注是否为空是否主键1PubID出版社IDint是2PubNumber出版社代码varchar303PubName名称varchar604ShortName简称varchar305PrivateCode自编码varchar306AreaCode所属省市varchar97Address地址varchar458ZipCode邮编varchar309Phone__varchar3010WebAddress网址varchar6011E__ilE__ilvarchar3012Contact__n__人varchar3013Operator操作员varchar1614Re__rk备注varchar10015AddDate添加日期datetime16DelFlag删除标记int17ChFlag修改标记int18TransFlag传输标记int
24、U_RequestOrder我的征订单(数据库里没有该表)编号字段中文说明类型备注是否为空是否主键1CustomerID客户IDint是2RequestNumber征订单号varchar163BookNumber书号varchar304RequestDate征订日期datetime5Pri__定价money6SaleRebate销售折扣float**7BookCount征订样本量int8AddDate添加日期datetime9Re__rk备注varchar5010DelFlag删除标记Int11ChFlag修改标记int12TransFlag传输标记inr
25、B_Books图书信息编号字段中文说明类型备注是否为空是否主键1BookNumber书号int是2BookGUID图书GUIDuniqueidentifier3I__NI__N号varchar204BookName书名varchar605PrivateCode自编码varchar606PubID出版社IDint7BookTypeCode类别varchar28Author__varchar309Translator译者varchar3010EditionOrder版次varchar3011PageStyleCode版别varchar212PageCount页码int13Pri__定价int**14BatchRebate批销折扣int15RetailRebate零售折扣int16__xValue库存上限int17MinValue库存下限int18StatusCode销售状态varchar219ProviderID供应商IDint20Ac__ssaryCode附件varchar221AmountInPackage每包册数int22PublishYear出版年份int23Operator操作员varchar1624AddDate添加日期datetime25Re__rk备注varchar5026OrderID排序号int自增27DelFlag删除标记int28ChFlag修改标记int29TransFlag传输标记int30Sour__Number源书号int31Sour__ID源IDint
26、B_BookTypes图书类型表编号字段中文说明类型备注是否为空是否主键1TypesID类型IDint是2TypesName类型名称varchar163ParentTypes上级类型varchar304VisibleCode是否可见datetime5OrderID显示预号money6IsSysFlag系统自带float**7AddDate添加日期int8Re__rk备注varchar509DelFlag删除标记int10ChFlag修改标记Int11TransFlag传输标记int
27、M_LevelRebate会员级别对应折扣表编号中文说明字段类型备注是否为空是否主键1MemberLevel会员级别varchar2是2RetailRebate对应折扣int3IsValid是否有效varchar24Operator操作员varchar165AddDate添加日期datetime6Re__rk备注varchar507DelFlag删除标记int8ChFlag修改标记int9TransFlag传输标记int
28、M_MemberBuyDetail会员购书记录编号字段中文说明类型备注是否为空是否主键1MemberID会员IDint2RetailNumber零售单号varchar163TransFlag删除标记int4Delflag修改标记int5SynchFlag传输标记int
29、M_Member会员信息表编号字段中文说明类型备注是否为空是否主键1BarCode条形码varchar13是2MName会员名varchar303___Code性别char24BirthDate出生日期datetime5Address住址varchar306Phone____varchar207EduGradeCode学历char28WorkPla__Code工作单位char29MLevelCode会员级别char210MTax会费money11Accumulate积分int12ValidDate积分有效日期datetime13MStatusCode会员状态char214JoinDate入会日期datetime15AddDate添加日期datetime16Re__rk备注varchar5017DelFlag删除标记int18ChFlag修改标记int19TransFlag传输标记int20MemberID会员IDint21MNumber会员编码varchar
1630、B_Retail零售记录表编号字段中文说明类型备注是否为空是否主键1RetailNumber零售单号varchar16是2SaleCount销售总数int3FixedMoney总码注money4DiscountedMoney总实洋money5Re__ivableMoney应收金额money6ComeToHandMoney接手金额money7OddMoney找零money8ChargeMoney实收金额money9Collector收费员varchar810RetailDate销售日期datetime11StateCode本单状态varchar212TotalCount本单数量int13I__ember是否会员varchar214AddDate添加日期datetime15Re__rk备注varchar5016DelFlag删除标记int17ChFlag修改标记int18TransFlag传输标记int19Sour__ID源IDint20Sour__Number源单号varchar
1631、B_RetailDetail零售明细编号字段中文说明类型备注是否为空是否主键1RetailNumber零售单号varchar16是2BookNumber书号int是3IDIDint是4BCount数量int5FixedPri__码洋money6RetailRebate零售折扣int7DiscountedPri__实洋money8Collector收费员varchar89Re__rk备注varchar5010DelFlag删除标记int11ChFlag修改标记int12TransFlag传输标记int
32、B_OddOrderForm散客户订单表编号字段中文说明类型备注是否为空是否主键1OrderNumber订单号varchar16是2BookNumber书号int是3BookName书名varchar30___要书名4PubID出版社IDint5PubName出版社名称varchar306CName客户姓名varchar307___Code性别char28Phone____varchar169E__ilE__ilvarchar3010BCount订数int11ValidDate有效日期datetime12Operator操作员varchar813AddDate添加日期datetime14Re__rk备注varchar5015DelFlag删除标记int16ChFlag修改标记int17TransFlag传输标记int18Sour__Number源单号varchar1619Sour__ID源IDint
33、P_Provider供应商信息编号字段中文说明类型备注是否为空是否主键1ProviderID供应商IDint是2ProviderGUID供应商GUIDuniqueidentifier3ProviderName供应商名称varchar604ShortName供应商简称varchar305PrivateCode自编码varchar306AreaCode所属区域varchar97Address详细地址varchar608ZipCode____varchar89Phone____varchar2010MobiPhone手机varchar1611Fax传真varchar2012WebAddress网址varchar6013E__il____varchar3014Contact__n__人varchar3015BankName开户银行varchar6016AccountNumber银行账号varchar2017TaxNumber税号varchar2018PreBalan__预付余额money19SendBackRate允许退书率int20Station铁路到站varchar2021Operator操作员varchar1622AddDate添加日期datetime23Re__rk备注varchar5024DelFlag删除标记int25ChFlag修改标记int26TransFlag传输标记int27Sour__PID源供应商IDint28Sour__ID源IDint29Global_ID30SynchFlag31没有找完
3234、P_RequestOrder供应商征订单编号字段中文说明类型备注是否为空是否主键1ProviderID供应商IDint是2RequestNumber征订单号varchar16是3BookName书名varchar604PubID出版社int5PrivateCode自编码varchar606BookTypeCode所属类别char27Author__varchar308Translator译者varchar309EditionOrder版次varchar3010Pri__定价money11BookCount征订样本量int12AddDate添加日期datetime13Re__rk备注varchar5014DelFlag删除标记int15ChFlag修改标记int16TransFlag传输标记int17Sour__Number源单号varchar1618Sour__ID源IDint
35、P_PaymentAccount付款对账单编号字段中文说明类型备注是否为空是否主键1ProviderID供应商IDint2PayAccountNumber对帐单号varchar16是3GenerateDate生成日期datetime4StartDate开始日期datetime5EndDate结束日期datetime6Balan__Code结算情况varchar27AddDate添加日期datetime8Re__rk备注varchar509Operator操作员varchar1610DelFlag删除标记int11ChFlag修改标记int12TransFlag传输标记int13Sour__Number源单号varchar1614Sour__ID源IDint
36、P_Payment付款表编号字段中文说明类型备注是否为空是否主键1PaymentNumber付款单号varchar16是2PayAccountNumber对帐单号varchar16是3ShouldPayMoney应付金额money4PreBalan__Money上次余额money5CurrBalan__Money当前余额money6GetBalan__Money本次取余money7PayMoney付款金额money8PayDate付款日期datetime9Payer付款人varchar1610PayModeCode付款方式varchar211CheckStateCode审核状态varchar212AddDate添加日期datetime13Re__rk备注varchar5014Operator操作员varchar1615DelFlag删除标记int16ChFlag修改标记int17TransFlag传输标记int该表多字段18Sour__Number源单号varchar1619Sour__ID源IDint
37、P_PrePayment预付款表编号字段中文说明类型备注是否为空是否主键1ProviderID供应商IDint是2PrePaymentNumber付款单号varchar163PrePayDate付款日期datetime4PrePayMoney付款金额money5Payer付款人varchar166PrePayModeCode付款方式varchar27CheckStateCode审核状态varchar28AddDate添加日期datetime9Re__rk备注varchar5010Operator操作员varchar1611DelFlag删除标记int12ChFlag修改标记int13TransFlag传输标记int14Sour__Number源单号varchar1615Sour__ID源IDint
38、U_SendBack我的退书单__TypesCode退货类型默认值为“01”滞销,当__TypesCode为“02”调拔时在字段Re__rk中填写__人信息编号字段中文说明类型备注是否为空是否主键1ProviderID供应商IDint是2SendBackNumber退货单号varchar163SendBackDate退货日期datetime4__TypesCode退货类型varchar25CarryModeCode发货方式char26TotalCount退书数量int7Operator操作员varchar168CheckStateCode审核状态varchar29AddDate添加日期datetime10Re__rk备注varchar5011DelFlag删除标记int12ChFlag修改标记int13TransFlag传输标记int14Sour__Number源单号varchar1615Sour__ID源IDint
39、U_SendBackDetail我的退书单明细编号字段中文说明类型备注是否为空是否主键1SendBackNumber退货单号varchar16是2BookNumber书号int3IDIDint4__Count数量int5FixedPri__码洋money6__Rebate退货折扣int7DiscountedPri__实洋money8Operator操作员varchar169Re__rk备注varchar5010DelFlag删除标记int11ChFlag修改标记int12TransFlag传输标记int
40、B_ProviderBooks供应商图书对应表编号字段中文说明类型备注是否为空是否主键1ProviderID供应商IDint是2BookNumber图书代码int3ProviderGUID供应商GUIDuniqueidentifier4I__N图书I__Nvarchar205I__ostly是否主供应商varchar
241、U_Stock进货记录表进货类型StockTypesCode默认为“01”采购,如是进货类型为“调拔”02,那么须在备注Re__rk中写入调入者的名称编号字段中文说明类型备注是否为空是否主键1StockNumber进货单号varchar16是2ProviderID供应商IDint3ProviderSNumber对方单号varchar164StockDate进货日期datetime5StockTypesCode进货类型varchar26ReturnDays退货天数int7StockModeCode购货方式varchar28PaymentStateCode付款情况varchar29CarryModeCode发货方式varchar210AllowSendBackCode是否允许退货varchar211CheckStateCode审核状态varchar212Plu__oney附加费money13TotalCount进货总数int14TotalFixedPri__总码洋money15TotalDiscountedPri__总实洋money16__erageRebate平均折扣float17StateCode单据状态varchar200录入和没有确认的01正常02作废18Operator操作员varchar1619AddDate添加日期datetime20Re__rk备注varchar5021DelFlag删除标记int22ChFlag修改标记int23TransFlag传输标记int24Sour__Number源单号varchar1625Sour__ID源IDint
42、U_StockDetail进货明细编号字段中文说明类型备注是否为空是否主键1StockNumber进货单号varchar16是2IDIDint3BookNumber书号int4StockCount进货数量int5FixedPri__码洋money6StockRebate进货折扣int7DiscountedPri__实洋money8RemoveCount已调数量int9IsSendBackCode是否退书varchar210SendBackCount退书数量int11AddDate添加日期datetime12Operator操作员varchar1613Re__rk备注varchar5014DelFlag删除标记int15ChFlag修改标记int16TransFlag传输标记int
43、U_OrderForm我的采购订单编号字段中文说明类型备注是否为空是否主键1ProviderID供应商IDint是2OrderNumber订单号varchar163OrderDate报订日期datetime4OrderModeCode订货方式varchar25CarryModeCode发货方式varchar26StatusCode订单状态varchar27LimitDate有效日期datetime8AddDate添加日期datetime9TotalCount图书数量int10Operator操作员varchar1611Re__rk备注varchar5012DelFlag删除标记int13ChFlag修改标记int14TransFlag传输标记int
44、U_OrderFormDetail采购单明细编号字段中文说明类型备注是否为空是否主键1OrderNumber采购订单号varchar16是2BookNumber书号int3IDIDint单子中的序号否4OrderCount数量int5AddDate添加日期datetime6Re__rk备注varchar507Operator操作员varchar168DelFlag删除标记int9ChFlag修改标记int10TransFlag传输标记int
45、C_Customer客户信息表编号字段中文说明类型备注是否为空是否主键1CustomerID客户IDint是2CustomerGUID客户GUIDuniqueidentifier3CustomerName客户名称varchar604PrivateCode自编码varchar305CTypeCode客户类型varchar26AreaCode所属区域varchar97Address详细地址varchar608ZipCode____varchar89Phone____varchar2010MobiPhone手机varchar1611Fax传真varchar2012E__il____varchar3013Contact__n__人varchar3014SendBackRete允许退货率int15Station铁路到站varchar2016Balan__预存余额money17SettleAccountsCode结算方式varchar218ContractedCode有无合同varchar219DefaultDiscount默认折扣int20__xOweValue欠款上限money21CreditCode诚信度varchar222Operator操作员varchar2023AddDate添加日期datetime24FromMsg信息来原varchar10025Sour__CustomerID源客户IDint26Re__rk备注varchar5027DelFlag删除标记int28TransFlag传输标记int29ChFlag修改标记int
46、C_PreRe__ive预收款表编号字段中文说明类型备注是否为空是否主键1CustomerID客户IDint是2PreRe__iveNumber预收款单号varchar163PreRe__iveDate预收日期datetime4PreRe__iveMoney预收金额money5Re__iver收款人varchar166IncomeModeCode收款方式varchar27CheckStateCode审核状态varchar28AddDate添加日期datetime9Re__rk备注varchar5010Operator操作员varchar1611DelFlag删除标记int12ChFlag修改标记int13TransFlag传输标记int14Sour__Number源单号varchar1615Sour__ID源IDint
47、C_Re__iveAccount收款对帐单编号字段中文说明类型备注是否为空是否主键1CustomerID客户IDint2Re__iveAccountNumber对帐单号varchar163GenerateDate生成日期datetime4StartDate开始日期datetime5EndDate结束日期datetime6Balan__Code结算情况varchar27AddDate添加日期datetime8Re__rk备注varchar509Operator操作员varchar1610DelFlag删除标记int11ChFlag修改标记int12TransFlag传输标记int13Sour__ID源IDint14Sour__Number源单号varchar
1648、C_Re__ive收款表编号字段中文说明类型备注是否为空是否主键1Re__iveNumber收款单号varchar16是2Re__iveAccountNumber对帐单号varchar163Re__iveDate收款日期datetime4ShouldRe__iveMoney应收金额money5CurrBalan__Money当前余额money6PreBalan__Money上次余额money7GetBalan__Money本次取余money8Re__iveMoney收款金额money9Re__iver收款人varchar1610CheckStateCode审核状态varchar211IncomeModeCode收款方式varchar212AddDate添加日期datetime13Re__rk备注varchar5014Sour__Number源单号varchar1615Sour__ID源IDint16Operator操作员varchar1617DelFlag删除标记int18ChFlag修改标记int19TransFlag传输标记int
49、C_OrderForm客户批销订单编号字段中文说明类型备注是否为空是否主键1CustomerID客户IDint是2OrderNumber订单号varchar163COrderNumber客户单号varchar164OrderDate订货日期datetime5OrderModeCode订货方式varchar26CarryModeCode发货方式varchar27OrderFromCode订单来源varchar28TotalCount图书数量int9StatusCode订单状态varchar210LimitDate有效日期datetime11Operator操作员varchar1612Re__rk备注varchar5013Sour__Number源单号varchar16订单号14Sour__ID源IDint网络id15AddDate添加日期datetime16DelFlag删除标记int17ChFlag修改标记int18TransFlag传输标记int
50、C_OrderFormDetail客户批销订单明细编号字段中文说明类型备注是否为空是否主键1OrderNumber订单号varchar16是2BookNumber书号int3IDIDint4OrderCount数量int5AddDate添加日期datetime6Re__rk备注varchar507Operator操作员varchar168DelFlag删除标记int9ChFlag修改标记int10TransFlag传输标记int
51、C_SendBack客户批销退货单__TypesCode退货类型默认值为“01”滞销,当__TypesCode为“02”调拔时在字段Re__rk中填写__人信息编号字段中文说明类型备注是否为空是否主键1CustomerID客户IDint2SendBackNumber退货单号varchar163OrderFromCode退单来源varchar24Sour__Number对方单号varchar165SendBackDate退货日期datetime6__TypesCode退货类型varchar27CarryModeCode发货方式varchar28CheckStateCode审核状态varchar29TotalCount退货数量int10Operator操作员varchar1611Re__rk备注varchar5012AddDate添加日期datetime13ChFlag修改标记int14DelFlag删除标记int15TransFlag传输标记int16Sour__Number2源单号varchar1617Sour__ID源IDint
52、C_SendBackDetail客户退货明细编号字段中文说明类型备注是否为空是否主键1SendBackNumber退货单号varchar162BookNumber书号int3IDIDint4__Count数量int5FixedPri__码洋money6__Rebate退货折扣int7DiscountedPri__实洋money8Operator操作员varchar169Re__rk备注varchar5010DelFlag删除标记int11ChFlag修改标记int12TransFlag传输标记int
53、C_BatchSale批销记录表BSTypesCode批销类型默认值为“01”直发,Re__rk不作任何处理当BSTypesCode为“02”调拔时在字段Re__rk中填写__人信息编号字段中文说明类型备注是否为空是否主键1BatchSaleNumber批销单号varchar16是2CustomerID客户IDint3SaleDate批销日期datetime4BSTypesCode批销类型varchar25CarryModeCode发货方式varchar26Re__iveModeCode收款方式varchar27CheckStateCode审核状态varchar28Re__iveStateCode收款情况varchar29AllowSendBackCode是否允许退货varchar210Plu__oney附加费money11TotalCount本单数量int12TotalFixedPri__总码洋money13TotalDiscountedPri__总实洋money14__erageRebate平均折扣float15StateCode单据状态varchar216AddDate添加日期datetime17Sour__Number源单号varchar1618Sour__ID源IDint19Operator操作员varchar1620Re__rk备注varchar5021DelFlag删除标记int22ChFlag修改标记int23TransFlag传输标记int
54、C_BatchSaleDetail批销明细表编号字段中文说明类型备注是否为空是否主键1BatchSaleNumber批销单号varchar16是2BookNumber书号int3IDIDint4SaleCount数量int5FixedPri__码洋money6BatchRebate批销折扣int7DiscountedPri__实洋money8RemoveCount已调数量int9IsSendBackCode是否退书varchar210SendBackCount已退数量int11SaleDate销售日期datetime12Operator操作员varchar1613Re__rk备注varchar5014DelFlag删除标记int15ChFlag修改标记int16TransFlag传输标记int
55、C_Contract合同管理表编号字段中文说明类型备注是否为空是否主键1O__ectID合同对象IDint2ContractID合同IDint3ContractNumber合同号varchar164O__ectTypesCode合同对象类型varchar25ContractName合同名称varchar306PaymentRate第月回款率float7StartDate签约日期datetime8Operator操作员varchar89AddDate添加日期datetime10Re__rk备注varchar5011DelFlag删除标记int12ChFlag修改标记int13TransFlag传输标记int
56、C_ContractDetail合同明细表编号字段中文说明类型备注是否为空是否主键1CustomerID客户IDint2ContractID合同IDint3BookTypeCode图书类型varchar124Stock__xValue最大进货量int5Discount折扣float6SendBackRate退货率float7AddDate添加日期datetime8Operator操作员varchar169Re__rk备注varchar5010DelFlag删除标记int11ChFlag修改标记int12TransFlag传输标记int
57、C_Tran__ooksFlag图书传输记录表编号字段中文说明类型备注是否为空是否主键1CustomerID客户IDinteger2BookNumber图号integer3I__NI__Nvarchar204TransDate传输日期datetime5TransFlag传输标记int
58、B_Storage图书库存表编号字段中文说明类型备注是否为空是否主键1BookNumber书号int2IDIDint3StoreCount库存量int4DelFlag删除标记int5ChFlag修改标记int6TransFlag传输标记int
59、B_AdjustOutStorage出库调整编号字段中文说明类型备注是否为空是否主键1OutStorageNumber出库单号varchar162OutDate出库日期datetime3Personnel出库人员varchar164OutTypesCode出库类型varchar25CheckStateCode审核状态varchar26Re__rk备注varchar507Operator操作人员varchar168AddDate添加日期datetime9DelFlag删除标记int10ChFlag修改标记int11TransFlag传输标记int12Sour__Number源单号varchar1613Sour__ID源IDint
60、B_AdjustOSDetail调整出库明细编号字段中文说明类型备注是否为空是否主键1OutStorageNumber出库单号varchar162BookNumber书号int3IDIDint4OSCount数量int5FixedPri__码洋money6OSRebate出库折扣int7DiscountedPri__实洋money8Operator操作员varchar169Re__rk备注varchar5010DelFlag删除标记int11ChFlag修改标记int12TransFlag传输标记int
61、B_EnterStorageLog入库记录表编号字段中文说明类型备注是否为空是否主键1OrderNumber入库单号varchar162BookNumber书号int3IDIDint4EnterDate入库日期datetime5StockTypeCode入库类型varchar26ESCount入库数量int7Operator操作员varchar88AddDate添加日期datetime9DelFlag删除标记int10ChFlag修改标记int11TransFlag传输标记int
62、B_AdjustEnterStorage入库调整编号字段中文说明类型备注是否为空是否主键1EnterStorageNumber入库单号varchar162EnterDate入库日期datetime3EnterTypesCode入库类型varchar24Personnel入库人员varchar165Operator操作员varchar166CheckStateCode审核状态varchar27Re__rk备注varchar508AddDate添加日期datetime9DelFlag删除标记int10ChFlag修改标记int11TransFlag传输标记int12Sour__Number源单号varchar1613Sour__ID源IDint
63、B_AdjustESDetail入库调整明细编号字段中文说明类型备注是否为空是否主键1EnterStorageNumber入库单号varchar162BookNumber书号int3IDIDint4ESCount数量int5FixedPri__码洋money6ESRebate入库折扣int7DiscountedPri__实洋money8Operator操作员varchar169Re__rk备注varchar5010DelFlag删除标记int11ChFlag修改标记int12TransFlag传输标记int。