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