【正文】 第4章 數(shù)據(jù)字典 單據(jù)分發(fā)表名稱字段數(shù)據(jù)類型PKIDPKIDint單據(jù)類型BillTypevarchar(50)單據(jù)開始編號BillStartCodevarchar(50)單據(jù)結(jié)束編號BillEndCodevarchar(50)領(lǐng)票人ReceiveBillPersonvarchar(50)接貨點AcceptStationvarchar(50)領(lǐng)票時間ReceiveBillTimedatetime分發(fā)人ReleasePersonvarchar(50) 單據(jù)明細表名稱字段數(shù)據(jù)類型PKIDPKIDint單據(jù)類型BillTypevarchar(50)單據(jù)編號BillCodevarchar(50)單據(jù)狀態(tài)BillStatevarchar(50)填寫日期WriteDatedatetime接貨點AcceptStationvarchar(50) 貨運單主表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運單編號GoodsBillCodevarchar(50)發(fā)貨客戶編號SendGoodsCustomerNOvarchar(50)發(fā)貨客戶SendGoodsCustomervarchar(50)發(fā)貨客戶電話SendGoodsCustomerTelvarchar(50)發(fā)貨客戶地址SendGoodsCustomerAddrvarchar(50)收貨客戶編號ReceiveGoodsCustomerCodevarchar(50)收貨客戶ReceiveGoodsCustomervarchar(50)收貨客戶電話ReceiveGoodsCustomerTelvarchar(50)收貨客戶地址ReceiveGoodsCustomerAddrvarchar(50)發(fā)貨日期SendGoodsDatedatetime發(fā)貨地址SendGoodsAddrvarchar(50)收貨地址ReceiveGoodsAddrvarchar(50)預(yù)期交貨日期PredeliveryDatedatetime實際交貨日期FactDealDatedatetime代收貨款HelpAcceptPaymentmoney代收手續(xù)費率AcceptprocedureRatevarchar(50)付款方式PayModevarchar(50)取貨方式FetchGoodsModevarchar(50)填票人WriteBillPersonvarchar(50)填寫日期WriteDatedatetime有效性Validityvarchar(50)是否審核IfAuditvarchar(50)是否結(jié)帳IfSettleAccountsvarchar(50)中轉(zhuǎn)地TransferStationvarchar(50)中轉(zhuǎn)費TransferFeemoney減款ReduceFundmoney付回扣PayKickbackmoney代收貨款變更后金額MoneyOfChangePaymoney送貨費CarryGoodsFeemoney運費Carriagemoney保險費Insurancemoney職員PKIDEmployeePKIDint備注Remarkvarchar(50)接貨點AcceptStationvarchar(100)發(fā)貨客戶手機SendGoodsCustomerMobilevarchar(50)收貨客戶手機ReceiveGoodsCustomerMobilevarchar(50) 貨運單事件表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運單PKIDGoodsBillPKIDint事件名稱EventNamevarchar(50)備注Remarkvarchar(50)發(fā)生時間OccurTimedatetime 貨運回執(zhí)單詳表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運回執(zhí)單PKIDGoodsRevertBillPKIDint貨運單詳表PKIDGoodsBillDetailPKIDint件數(shù)PieceAmountint重量Weightreal體積Volumereal計價方式PriceModevarchar(50)計費標(biāo)準(zhǔn)PriceStandardvarchar(50)貨物價值GoodsValuemoney 貨運回執(zhí)單主表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運回執(zhí)單編號GoodsRevertBillCodevarchar(50)裝貨地點LoadStationvarchar(50)起運時間StartCarryTimedatetime交貨地點DealGoodsStationvarchar(50)到達時間ArriveTimedatetime收貨聯(lián)系人ReceiveGoodsLinkmanvarchar(50)聯(lián)系人電話LinkmanPhonevarchar(50)聯(lián)系人手機LinkmanMobilevarchar(50)收貨詳細地址ReceiveGoodsDetailAddrvarchar(50)運費結(jié)算方式CarriageBanlanceModevarchar(50)備注Remarkvarchar(50)司機PKIDDriverPKIDint是否結(jié)算IfBalancevarchar(50)回執(zhí)單狀態(tài)BackBillStatevarchar(50)起運時的預(yù)付費用StartAdvancemoney送貨單回執(zhí)押金CarryGoodsBillDepositmoney承運人訂裝貨物保證金CarryGoodsInsurancemoney配載服務(wù)費DispatchServiceFeemoney總運費AllCarriagemoney保險費Insurancemoney簽定時間SignTimedatetime接貨點AcceptStationvarchar(50)運費計價方式CarriageModevarchar(50)執(zhí)行Executebit 客戶回執(zhí)信息表名稱字段數(shù)據(jù)類型PKIDPKIDdecimal(18)貨運單編號GoodsBillCodenvarchar(50)客戶名稱Customernvarchar(50)驗收貨物記錄CheckGoodsRecordnvarchar(50)收貨人ReceiveGoodsPersonnvarchar(50)收貨日期ReceiveGoodsDatedatetime運單事件PKIDCarryBillEventPKIDint 貨物回執(zhí)信息表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運回執(zhí)編號GoodsRevertCodevarchar(50)司機名稱DriverNamevarchar(50)驗收貨物記錄CheckGoodsRecordvarchar(50)收貨人ReceiveGoodsPersonvarchar(50)收貨日期ReceiveGoodsDatedatetime 貨運差錯表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運回執(zhí)單編號GoodsRevertBillCodevarchar(50)貨運單編號GoodsBillCodevarchar(50)客戶名稱Customervarchar(50)貨物名稱GoodsNamevarchar(50)差錯類別MistakeTypevarchar(50)件數(shù)PieceAmountint規(guī)格Sizevarchar(50)貨物價值GoodsValuemoney 中轉(zhuǎn)信息表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運單編號GoodsBillCodevarchar(50)中轉(zhuǎn)地TransferStationvarchar(50)