【正文】 0)郵編PostCodevarchar(50)聯系人Linkmanvarchar(50)聯系人手機LinkmanMobilevarchar(50)客戶類型CustomerTypevarchar(50)企業(yè)性質EnterprisePropertyvarchar(50)企業(yè)規(guī)模EnterpriseSizevarchar(50)電子郵件Emailvarchar(50) 職員信息表名稱字段數據類型PKIDPKIDint職員編號EmployeeCodevarchar(50)職員姓名Employeevarchar(50)部門Departmentvarchar(50)職位Positionvarchar(50)性別Gendervarchar(50)出生日期Birthdaydatetime 司機信息表名稱字段數據類型PKIDPKIDint司機名稱DriverNamevarchar(50)身份證號IDCardvarchar(50)電話Phonevarchar(50)手機Mobilevarchar(50)性別Gendervarchar(50)出生日期Birthdayvarchar(50)狀態(tài)Statevarchar(50)車號CarNOvarchar(50)準載體積AllowCarryVolumevarchar(50)準載重量AllowCarryWeightvarchar(50)住址Addressvarchar(50)車型CarTypevarchar(50)車廂長度CarLengthvarchar(50)車屬單位CarDeptvarchar(50)車屬單位電話CarDeptTelvarchar(50)駕駛證DriveLicencevarchar(50)行駛證RunLicencevarchar(50)營運證BizLicencevarchar(50)保險證InsuranceCardvarchar(50)車廂寬度CarWidthvarchar(50)載物高度GoodsHeightvarchar(50)車架號CarFrameNOvarchar(50)發(fā)動機號EngineNOvarchar(50)備注Remarkvarchar(50)公司車CompanyCarbit 地區(qū)城市表名稱字段數據類型PKIDPKIDint城市Cityvarchar(50) 城市擴充表名稱字段數據類型PKIDPKIDint城市PKIDCityPKIDint范圍城市RangeCityvarchar(50) 線路信息名稱字段數據類型PKIDPKIDint起點StartStationvarchar(50)終點EndStationvarchar(50)里程Distancereal抵運時間FetchTimereal 功能表名稱字段數據類型PKIDPKIDint頁面功能PageFunctionvarchar(50)頁面名稱PageNamevarchar(50) 用戶組表名稱字段數據類型PKIDPKIDint組名稱GroupNamevarchar(50)描述Descriptionvarchar(255) 用戶表名稱字段數據類型PKIDPKIDint登錄IDLoginIDvarchar(50)密碼Passwordvarchar(50)是否在線IfOnlinebit 功能與組表名稱字段數據類型PKIDPKIDint功能PKIDFunctionPKIDint組PKIDGroupPKIDint 用戶與組表名稱字段數據類型PKIDPKIDint用戶PKIDUserPKIDint組PKIDGroupPKIDint 職員用戶關系表名稱字段數據類型PKIDPKIDint職員PKIDEmployeePKIDint用戶PKIDUserPKIDint 打印客戶運量名稱字段數據類型發(fā)貨客戶SendGoodsCustomervarchar(50)運費總計CarriageTotalmoney保險費總計InsuranceTotalmoney件數總計PieceAmountTotalint 打印專線整體名稱字段數據類型裝貨地點LoadStationvarchar(50)交貨地點DealGoodsStationvarchar(50)總運費總計AllCarriageTotalmoney保險費總計InsuranceTotalmoney次數Timesint 裝貨發(fā)車清單名稱字段數據類型用戶IDUserIDvarchar(50)序號IDvarchar(50)發(fā)貨客戶SendGoodsCustomervarchar(50)貨物名稱GoodsNamevarchar(50)貨物編號GoodsCodevarchar(50)中轉目的地TransferDestinationvarchar(50)發(fā)貨客戶電話SendGoodsCustomerTelvarchar(50)現付CashPaymoney提付PickupPaymoney回結BackCostmoney代收款HelpAcceptFundvarchar(50)備注Remarkvarchar(50)司機名稱DriverNamevarchar(50)車牌號CarCardNOvarchar(50)手機Mobilevarchar(50)件數PieceAmountint貨運回執(zhí)單編號GoodsRevertBillCodevarchar(50) 打印司機運量名稱字段數據類型車號CarNOvarchar(50)承運費總計CarryFeeTotalmoney加運費總計AddCarriageTotalmoney總計Totalmoney 打印業(yè)務統(tǒng)計日報表名稱字段數據類型提貨點PickupStationvarchar(50)收貨地址1ReceiveGoodsAddr1varchar(50)應收金額1MoneyReceivable1varchar(50)已收金額1ReceivedMoney1varchar(50)余額1Balance1varchar(50)應收件數1PieceCountReceivable1varchar(50)已收件數1ReceivedPieceCount1varchar(50)剩余件數1RemainPieceCount1varchar(50)收貨地址2ReceiveGoodsAddr2varchar(50)應收金額2MoneyReceivable2varchar(50)已收金額2ReceivedMoney2varchar(50)余額2Balance2varchar(50)應收件數2PieceCountReceivable2varchar(50)已收件數2ReceivedPieceCount2varchar(50)剩余件數2RemainPieceCount2varchar(50)收貨地址3ReceiveGoodsAddr3varchar(50)應收金額3MoneyReceivable3varchar(50)已收金額3ReceivedMoney3varchar(50)余額3Balance3varchar(50)應收件數3PieceCountReceivable3varchar(50)已收件數3ReceivedPieceCount3varchar(50)剩余件數3RemainPieceCoun