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