sql表结构

4.1 单据分发表 BillRelease(int id, String billType, String billCode, String receiveBillPerson, String acceptStation,
Date receiveBillTime, String releasePerson)
4.2 单据明细表BillInfo(int id, String billType, String billCode, String billState, Date writeDate, String acceptStation)
4.3 货运单主表GoodsBill(String goodsBillCode, String sendGoodsCustomerNo, String sendGoodsCustomer,
String sendGoodsCustomerTel, String sendGoodsCustomerAddr, String receiveGoodsCustomerCode,
String receiveGoodsCustomer, String receiveGoodsCustomerTel, String receiveGoodsCustomerAddr,
Date sendGoodsDate, String sendGoodsAddr, String receiveGoodsAddr, Date predeliveryDate, Date factDealDate,
double helpAcceptPayment, String acceptProcedureRate, String payMode, String fetchGoodsMode,
String writeBillPerson, Date writeDate, boolean validity, boolean ifAudit, boolean ifSettleAccounts,
String transferStation, double transferFee, double reduceFund, double payKickback, double moneyOfChangePay,
double carryGoodsFee, double carriage, double insurance, String employeeCode, String remark,
String acceptStation)
4.4 货运单事件表GoodsBillEvent(String goodsBillId, String eventName, String remark, Date occurTime)
4.5 货运回执单详表CargoReceiptDetail(String goodsRevertBillId, String goodsBillDetailId, int pieceAmount, double weight,
double volume, String priceMode, String priceStandard, double goodsValue)
4.6 货运回执单主表 CargoReceipt(String goodsRevertBillCode, String loadStation, Date startCarryTime, String dealGoodsStation,
Date arriveTime, String receiveGoodsLinkman, String linkmanPhone, String receiveGoodsDetailAddr,
String carriageBanlanceMode, String remark, String driverId, String ifBalance, String backBillState,
double startAdvance, double carryGoodsBillDeposit, double carryGoodsInsurance, double dispatchServiceFee,
double allCarriage, double insurance, Date signTime, String acceptStation, String carriageMode)
4.7 客户回执信息表 CustomerReceiptInfo(int id, String goodsBillCode, String customer, String checkGoodsRecord,
String receiveGoodsPerson, Date receiveGoodsDate, int carryBillEventId)
4.8 货物回执信息表GoodsReceiptInfo(int id, String goodsRevertCode, String driverName, String checkGoodsRecord,
String receiveGoodsPerson, Date rceiveGoodsDate)
4.9 货运差错表 CargoError(int id, String goodsRevertBillCode, String goodsBillCode, String customer, String goodsName,
String mistakeType, int pieceAmount, String size, double goodsValue)
4.10 中转信息表TransferInfo(int id, String goodsBillCode, String transferStation, String transferCheck, Date checkTime,
String description, String transferCompany, String transferAddr, String transferStationTel,
double transferFee, String afterTransferBill)
4.11 中转公司信息表 TransferComInfo(int id, String city, String companyName, String linkPhone, String detailAddress)
4.12 司机结算主表DriverClear(String backBillCode, String driverCode, String balanceType, double needPayment, double carryFee,
double prepayMoney, double bindInsurance, double addCarriage, double payedMoney, double balance,
Date balanceTime, double dispatchServiceFee, double insurance)
4.13 客户运单结算表CustomerBillClear(String customerCode, String goodsBillCode, double billMoney, double moneyReceivable,
double receivedMoney, double prepayMoney, double carriageReduceFund, double balance, Date balanceTime,
double insurance, double payKickback, double carryGoodsFee, String balanceType)
4.14 代收货款结算表ProxyFeeClear(String goodsBillCode, String customerCode, double accountReceivable, double factReceiveFund,
double goodsPayChange, float commisionRate, double commisionReceivable, double receivedCommision,
Date balanceDate)

4.18 回告信息表 CallbackInfo(int id, String dialNo, String type, String content, String goodsBillId, Date writeTime,
String writer, Date finallyDialTime, boolean success, boolean locked, String billId, String billType)

4.15 杂费结算表ExtraClear(int id, String subjectName, double balanceMoney, String remark, Date balanceDate,
String balanceType)
4.16 投诉信息表ComplaintInfo(int id, String customer, String goodsBillCode, String appealContent, String appealDate,
boolean ifHandle, String dealDate, String dealResult, boolean ifCallback, String callBackDate,
String dealPerson)
4.20 营业外收入表ExtraIncome(int id, String name, double money, String incomeMonth, Date writeDate)

转用户表

4.21 员工工资表EmployeeWage(int id, String employeeCode, double basicWage, double stationWage, double allowance, Date date,
String employee)
4.22 财务费用表FinanceFee(int id, double fee, String payoutMonth, Date writeDate)
4.23 管理费用表ManageFee(int id, double officeFee, double houseRent, double waterElecFee, double phoneFee,
double otherPayout, String payoutMonth, Date writeDate)
4.24 赔偿信息表CompensationInfo(int id, double amends, String customer, Date amendsTime, String remark,
int receiveStationId, double badDestroyGoods, String receiveStationName, Date writeDate)

4.25 客户基本信息表CustomerInfo(String customerCode, String customer, String phone, String fax, String address,
String postCode, String linkman, String linkmanMobile, String customerType, String enterpriseProperty,
String enterpriseSize, String email)
4.26 职员信息表Employee(String employeeCode, String employeeName, String department, String position, String gender,
Date birthday)
4.27 司机信息表DriverInfo(String id, String driverName, String idCard, String phone, String gender, Date birthday,
String state, String carNo, double allowCarryVolume, double allowCarryWeight, String address,
String carType, String carLength, String carDept, String carDeptTel, String driveLicence, String runLicence,
String bizLicence, String insuranceCard, String carWidth, String goodsHeight, String carFrameNo,
String engineNo, String remark, boolean companyCar)
4.28 地区城市表Region(int id, String city)
4.28 地区城市表RouteInfo(int id, int startStation, String passStation, int endStation, double distance,
double fetchTime)
4.29 城市扩充表 CityExpand(int id, int cityId, String rangeCity)

4.31 功能�? Function(int id, String pageFunction, String pageName)
4.32 用户组表UserGroup(int id, String groupName, String description)
4.33 用户表User(String loginId, String password, boolean ifOnline)
4.34 功能与组表FunctionWithGroup(int id, int functionId, int groupId)
4.35 用户与组表UserWithGroup(int id, String userId, int groupId)
4.36 职员用户关系�?EmployeeUser(int id, int employeeId, int userId)

清单
4.37 打印客户运量CustomerAmount( String sendGoodsCustomer, double carriageTotal, double insuranceTotal,
int pieceAmountTotal)
4.38 打印专线整体LineOverall(int id, String loadStation, String dealGoodsStation, double allCarriageTotal,
double insuranceTotal, int times)
4.39 装货发车清单SentList(int id, int userId, String sendGoodsCustomer, String goodsName, String goodsCode,
String transferDestination, String sendGoodsCustomerTel, double cashPay, double pickupPay, double backCost,
String helpAcceptFund, String remark, String driverName, String carCardNo, String mobile, int pieceAmount,
String goodsRevertBillCode)
4.40 打印司机运量 DriverAmount(int id, String driverCode, double carryFeeTotal, double addCarriageTotal, double total)
4.42 打印车辆成本CarCost(String driverCode, String carNo, String carType, double allowCarryWeight, String carWidth,
String goodsHeight, double carryFeeTotal, double addCarriageTotal, double factCarriageTotal,
String loadStation, String dealGoodsStation, String backBillCode, Date balanceTime)
4.43 打印�?来业�? ContactsService( String sendGoodsCustomer, String goodsBillCode, String sendGoodsAddr,
String receiveGoodsAddr, double carriage, double insurance, double billMoney, double moneyReceivable,
double receivedMoney, double balance, Date sendGoodsDate)
4.45 损益月报临时�?IncomeMonthlyTemp(int id, double income, double payout, double bizIncome, double carriageMoney,
double insuranceMoney, double unbizIncome, double bizFee, double carCarriage, double conveyWage,
double manageFee, double officeFee, double houseRent, double waterElecFee, double phoneFee, double other,
double financeFee, double profit, double wage, String month)