【正文】 )運(yùn)費(fèi)總計(jì)CarriageTotalmoney保險(xiǎn)費(fèi)總計(jì)InsuranceTotalmoney件數(shù)總計(jì)PieceAmountTotalint 打印專線整體名稱字段數(shù)據(jù)類型裝貨地點(diǎn)LoadStationvarchar(50)交貨地點(diǎn)DealGoodsStationvarchar(50)總運(yùn)費(fèi)總計(jì)AllCarriageTotalmoney保險(xiǎn)費(fèi)總計(jì)InsuranceTotalmoney次數(shù)Timesint 裝貨發(fā)車清單名稱字段數(shù)據(jù)類型用戶IDUserIDvarchar(50)序號(hào)IDvarchar(50)發(fā)貨客戶SendGoodsCustomervarchar(50)貨物名稱GoodsNamevarchar(50)貨物編號(hào)GoodsCodevarchar(50)中轉(zhuǎn)目的地TransferDestinationvarchar(50)發(fā)貨客戶電話SendGoodsCustomerTelvarchar(50)現(xiàn)付CashPaymoney提付PickupPaymoney回結(jié)BackCostmoney代收款HelpAcceptFundvarchar(50)備注Remarkvarchar(50)司機(jī)名稱DriverNamevarchar(50)車牌號(hào)CarCardNOvarchar(50)手機(jī)Mobilevarchar(50)件數(shù)PieceAmountint貨運(yùn)回執(zhí)單編號(hào)GoodsRevertBillCodevarchar(50) 打印司機(jī)運(yùn)量名稱字段數(shù)據(jù)類型車號(hào)CarNOvarchar(50)承運(yùn)費(fèi)總計(jì)CarryFeeTotalmoney加運(yùn)費(fèi)總計(jì)AddCarriageTotalmoney總計(jì)Totalmoney 打印業(yè)務(wù)統(tǒng)計(jì)日?qǐng)?bào)表名稱字段數(shù)據(jù)類型提貨點(diǎn)PickupStationvarchar(50)收貨地址1ReceiveGoodsAddr1varchar(50)應(yīng)收金額1MoneyReceivable1varchar(50)已收金額1ReceivedMoney1varchar(50)余額1Balance1varchar(50)應(yīng)收件數(shù)1PieceCountReceivable1varchar(50)已收件數(shù)1ReceivedPieceCount1varchar(50)剩余件數(shù)1RemainPieceCount1varchar(50)收貨地址2ReceiveGoodsAddr2varchar(50)應(yīng)收金額2MoneyReceivable2varchar(50)已收金額2ReceivedMoney2varchar(50)余額2Balance2varchar(50)應(yīng)收件數(shù)2PieceCountReceivable2varchar(50)已收件數(shù)2ReceivedPieceCount2varchar(50)剩余件數(shù)2RemainPieceCount2varchar(50)收貨地址3ReceiveGoodsAddr3varchar(50)應(yīng)收金額3MoneyReceivable3varchar(50)已收金額3ReceivedMoney3varchar(50)余額3Balance3varchar(50)應(yīng)收件數(shù)3PieceCountReceivable3varchar(50)已收件數(shù)3ReceivedPieceCount3varchar(50)剩余件數(shù)3RemainPieceCount3varchar(50) 打印車輛成本名稱字段數(shù)據(jù)類型司機(jī)名稱DriverNamevarchar(50)車號(hào)CarNOvarchar(50)車型CarTypevarchar(50)準(zhǔn)載重量AllowCarryWeightvarchar(50)車廂寬度CarWidthvarchar(50)載物高度GoodsHeightvarchar(50)承運(yùn)費(fèi)總計(jì)CarryFeeTotalmoney加運(yùn)費(fèi)總計(jì)AddCarriageTotalmoney實(shí)際總運(yùn)費(fèi)FactCarriageTotalmoney裝貨地點(diǎn)LoadStationvarchar(50)交貨地點(diǎn)DealGoodsStationvarchar(50)回執(zhí)單編號(hào)BackBillCodevarchar(50)結(jié)算時(shí)間BalanceTimedatetime 打印往來(lái)業(yè)務(wù)名稱字段數(shù)據(jù)類型發(fā)貨客戶SendGoodsCustomervarchar(50)貨運(yùn)單編號(hào)GoodsBillCodevarchar(50)發(fā)貨地址SendGoodsAddrvarchar(50)收貨地址ReceiveGoodsAddrvarchar(50)運(yùn)費(fèi)Carriagemoney保險(xiǎn)費(fèi)Insurancemoney本單金額BillMoneymoney應(yīng)收金額MoneyReceivablemoney已收金額ReceivedMoneymoney余額Balancemoney發(fā)貨日期SendGoodsDatedatetime 損益月報(bào)表名稱字段數(shù)據(jù)類型PKIDPKIDint大類Categoryvarchar(50)中類MidCategoryvarchar(50)小類SubTypevarchar(50)金額Moneymoney統(tǒng)計(jì)起始日期StatStartDatedatetime統(tǒng)計(jì)結(jié)束日期StatEndDatedatetime結(jié)算日期BalanceDatedatetime 損益月報(bào)臨時(shí)表名稱字段數(shù)據(jù)類型PKIDPKIDint收入Inemoney支出Payoutmoney營(yíng)業(yè)收入BizInemoney運(yùn)費(fèi)金額CarriageMoneymoney保險(xiǎn)金額InsuranceMoneymoney非營(yíng)業(yè)收入_名稱_1UnbizIne_Name_1varchar(50)非營(yíng)業(yè)收入_金額_1UnbizIne_Money_1money非營(yíng)業(yè)收入_名稱_2UnbizIne_Name_2varchar(50)非營(yíng)業(yè)收入_金額_2UnbizIne_Money_2money非營(yíng)業(yè)收入_名稱_3UnbizIne_Name_3varchar(50)非營(yíng)業(yè)收入_金額_3UnbizIne_Money_3money非營(yíng)業(yè)收入_名稱_4UnbizIne_Name_4varchar(50)非營(yíng)業(yè)收入_金額_4UnbizIne_Money_4money非營(yíng)業(yè)收入_名稱_5UnbizIne_Name_5varchar(50)非營(yíng)業(yè)收入_金額_5UnbizIne_Money_5money非營(yíng)業(yè)收入_名稱_6UnbizIne_Name_6varchar(50)非營(yíng)業(yè)收入_金額_6UnbizIne_Money_6money非營(yíng)業(yè)收入_名稱_7UnbizIne_Name_7varchar(50)非營(yíng)業(yè)收入_金額_7UnbizIne_Money_7money非營(yíng)業(yè)收入_名稱_8UnbizIne_Name_8varchar(50)非營(yíng)業(yè)收入_金額_8UnbizIne_Money_8money經(jīng)營(yíng)費(fèi)用BizFeemoney車運(yùn)費(fèi)CarCarriagemoney賠款A(yù)mendsFundmoney貨差貨損BadDestroyGoodsmoney搬運(yùn)工資ConveyWagemoney管理費(fèi)用ManageFeemoney辦公費(fèi)OfficeFeemoney房租費(fèi)HouseRentmoney水電費(fèi)WaterElecFeemoney電話費(fèi)PhoneFeemoney其他Othermoney財(cái)務(wù)費(fèi)用FinanceFeemoney利潤(rùn)Profitmoney第5