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