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