【文章內容簡介】 varchar(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)驗收時間CheckTimedatetime描述Descriptionvarchar(50)中轉公司名TransferCompanyvarchar(50)中轉地址TransferAddrvarchar(50)中轉地電話TransferStationTelvarchar(50)中轉費TransferFeevarchar(50)中轉后單號AfterTransferBillvarchar(50) 中轉公司信息表名稱字段數據類型PKIDPKIDint城市Cityvarchar(50)公司名稱CompanyNamevarchar(50)聯(lián)系電話LinkPhonevarchar(50)詳細地址DetailAddressvarchar(200) 司機結算主表名稱字段數據類型PKIDPKIDint司機名稱DriverNamevarchar(50)結算類型BalanceTypevarchar(50)回執(zhí)單編號BackBillCodevarchar(50)應付金額NeedPaymentmoney承運費CarryFeemoney預付金額PrepayMoneymoney訂裝保證金B(yǎng)indInsurancemoney加運費AddCarriagemoney已付金額PayedMoneymoney余額Balancemoney結算時間BalanceTimedatetime配載服務費DispatchServiceFeemoney保險費Insurancemoney 客戶運單結算表名稱字段數據類型PKIDPKIDint客戶名稱Customervarchar(50)貨運單編號GoodsBillCodevarchar(50)本單金額BillMoneymoney應收金額MoneyReceivablemoney已收金額ReceivedMoneymoney預付金額PrepayMoneymoney運費減款CarriageReduceFundmoney余額Balancemoney結算時間BalanceTimedatetime保險費Insurancemoney付回扣PayKickbackmoney送貨費CarryGoodsFeemoney結算類型BalanceTypevarchar(50) 代收貨款結算表名稱字段數據類型PKIDPKIDint客戶名稱Customervarchar(50)貨運單編號GoodsBillCodevarchar(50)應收貨款AccountReceivablemoney實收貨款FactReceiveFundmoney貨款變更GoodsPayChangemoney傭金率CommisionRatefloat(15)應收傭金CommisionReceivablemoney已收傭金ReceivedCommisionmoney結算日期BalanceDatedatetime 雜費結算表名稱字段數據類型PKIDPKIDint科目名稱SubjectNamevarchar(50)結算金額BalanceMoneymoney備注Remarkvarchar(50)結算日期BalanceDatedatetime結算類型BalanceTypevarchar(50) 投訴信息表名稱字段數據類型PKIDPKIDint客戶名稱Customervarchar(50)貨運單編號GoodsBillCodevarchar(50)投訴內容AppealContentvarchar(50)投訴日期AppealDatevarchar(50)是否處理IfHandlevarchar(50)處理日期DealDatevarchar(50)處理結果DealResultvarchar(50)是否回告IfCallbackvarchar(50)回告日期CallBackDatevarchar(50)處理人DealPersonvarchar(50) 客戶回告表名稱字段數據類型PKIDPKIDi