【正文】 0)郵編PostCodevarchar(50)聯(lián)系人Linkmanvarchar(50)聯(lián)系人手機(jī)LinkmanMobilevarchar(50)客戶類型CustomerTypevarchar(50)企業(yè)性質(zhì)EnterprisePropertyvarchar(50)企業(yè)規(guī)模EnterpriseSizevarchar(50)電子郵件Emailvarchar(50) 職員信息表名稱字段數(shù)據(jù)類型PKIDPKIDint職員編號EmployeeCodevarchar(50)職員姓名Employeevarchar(50)部門Departmentvarchar(50)職位Positionvarchar(50)性別Gendervarchar(50)出生日期Birthdaydatetime 司機(jī)信息表名稱字段數(shù)據(jù)類型PKIDPKIDint司機(jī)名稱DriverNamevarchar(50)身份證號IDCardvarchar(50)電話Phonevarchar(50)手機(jī)Mobilevarchar(50)性別Gendervarchar(50)出生日期Birthdayvarchar(50)狀態(tài)Statevarchar(50)車號CarNOvarchar(50)準(zhǔn)載體積AllowCarryVolumevarchar(50)準(zhǔn)載重量AllowCarryWeightvarchar(50)住址Addressvarchar(50)車型CarTypevarchar(50)車廂長度CarLengthvarchar(50)車屬單位CarDeptvarchar(50)車屬單位電話CarDeptTelvarchar(50)駕駛證DriveLicencevarchar(50)行駛證RunLicencevarchar(50)營運(yùn)證BizLicencevarchar(50)保險證InsuranceCardvarchar(50)車廂寬度CarWidthvarchar(50)載物高度GoodsHeightvarchar(50)車架號CarFrameNOvarchar(50)發(fā)動機(jī)號EngineNOvarchar(50)備注Remarkvarchar(50)公司車CompanyCarbit 地區(qū)城市表名稱字段數(shù)據(jù)類型PKIDPKIDint城市Cityvarchar(50) 城市擴(kuò)充表名稱字段數(shù)據(jù)類型PKIDPKIDint城市PKIDCityPKIDint范圍城市RangeCityvarchar(50) 線路信息名稱字段數(shù)據(jù)類型PKIDPKIDint起點(diǎn)StartStationvarchar(50)終點(diǎn)EndStationvarchar(50)里程Distancereal抵運(yùn)時間FetchTimereal 功能表名稱字段數(shù)據(jù)類型PKIDPKIDint頁面功能PageFunctionvarchar(50)頁面名稱PageNamevarchar(50) 用戶組表名稱字段數(shù)據(jù)類型PKIDPKIDint組名稱GroupNamevarchar(50)描述Descriptionvarchar(255) 用戶表名稱字段數(shù)據(jù)類型PKIDPKIDint登錄IDLoginIDvarchar(50)密碼Passwordvarchar(50)是否在線IfOnlinebit 功能與組表名稱字段數(shù)據(jù)類型PKIDPKIDint功能PKIDFunctionPKIDint組PKIDGroupPKIDint 用戶與組表名稱字段數(shù)據(jù)類型PKIDPKIDint用戶PKIDUserPKIDint組PKIDGroupPKIDint 職員用戶關(guān)系表名稱字段數(shù)據(jù)類型PKIDPKIDint職員PKIDEmployeePKIDint用戶PKIDUserPKIDint 打印客戶運(yùn)量名稱字段數(shù)據(jù)類型發(fā)貨客戶SendGoodsCustomervarchar(50)運(yùn)費(fèi)總計(jì)CarriageTotalmoney保險費(fèi)總計(jì)InsuranceTotalmoney件數(shù)總計(jì)PieceAmountTotalint 打印專線整體名稱字段數(shù)據(jù)類型裝貨地點(diǎn)LoadStationvarchar(50)交貨地點(diǎn)DealGoodsStationvarchar(50)總運(yùn)費(fèi)總計(jì)AllCarriageTotalmoney保險費(fèi)總計(jì)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)司機(jī)名稱DriverNamevarchar(50)車牌號CarCardNOvarchar(50)手機(jī)Mobilevarchar(50)件數(shù)PieceAmountint貨運(yùn)回執(zhí)單編號GoodsRevertBillCodevarchar(50) 打印司機(jī)運(yùn)量名稱字段數(shù)據(jù)類型車號CarNOvarchar(50)承運(yùn)費(fèi)總計(jì)CarryFeeTotalmoney加運(yùn)費(fèi)總計(jì)AddCarriageTotalmoney總計(jì)Totalmoney 打印業(yè)務(wù)統(tǒng)計(jì)日報(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ù)3RemainPieceCoun