Class Diagram

cd_storage_receivable

stoReceivableID int (pk) customerID int (fk)project varchar(30)remark varchar(100)receivableDate date

cd_receiptRecord

receiptRecordID int (pk)receivableTotalID int(fk) customerID int (fk)project varchar(30)receiptNumber varchar(50)costTypeID int(fk)receiptmMoney double revenueMoney doublereceiptTime datecollectCostTypeID int(fk)collectCostName varchar(20)receiptCompanyID int(fk)receiptCompanyNameremark varchar(100)

cd_transport_receivableTotal

tranReceivableID int (pk)tranReceivableID int (fk)customerID int (fk)customerName varchar(20)project varchar(30)receiptCompanyName varchar(50)department varchar(20)planDate datepersonnel varchar(100)accountPeriodDate date transportation doublecoolieHire doubleadjust doubletiaoZhang doubleotherCharges double total doublecollectMoneyTotal doublecollectStatusID int(fk)collectStatusName varchar(20)receiptStatusID int(fk)receiptStatusName varchar(20)isOverdue varchar(20)

cd_PaymentRecord

PaymentRecordID int (pk)payableTotalID int(fk)supplierID int (fk)paymentMoney doublerevenueMoney doublepaymentCostTypeID int(fk)paymentCostTypeName varchar(20)paymentCompanyID int(fk)paymentCompanyName varchar(20)paymentModeID int(fk)paymentModelName varchar(20)paymentDate date

cd_transport_payable

tranPayableID int (pk)customerID int (fk)supplierID int(fk) project varchar(30)payableNumber varchar(50)model varchar(20)sendDate datecustomer varchar(100)orderType varchar(30)motorcycleType varchar(30)plateNumber varchar(30)driver varchar(20)driverPhone varchar(30)lastDate datecustomer varchar(100)institution varchar(100) goodsName varchar(50)standard varchar(50)DeliveryAddress varchar(100)terminalClient varchar(100)distributionArea varchar(100)distributionAddress varchar(100)count introughWeight varchar(30)volume varchar(30)transportation doubleadvanceMoney doubletotal double taxCost doubletaxTotal double

开票记录表

运输应收汇总表

cd_collectionRecord

collectionRecordID int (pk)receivableTotalID int(fk) customerID int (fk)project varchar(30)collectMoney doublecollectCompanyID int(fk)collecCompanyName varchar(20)collectModeID int(fk)collectModelName varchar(20)collectDate date

收款记录表

cd_transport_payabletotal

tranPayableTotalID int(pk)tranPayableID int(fk)supplierID int (fk)supplierName varchar(20)plateNumber varchar(30)transportation doubleadvanceMoney doubletotal double tiaozhan doubletaxCost doubletaxTotal doublepaymentMoney doublepayableMoneyTotal doubleremark1 varchar(30)remark2 vachar(30)paymentStatusID int(fk)paymentStatusName varchar(20)

运输应付明细表

cd_transport_receivable

tranReceivableID int (pk)customerID int (fk)project varchar(30)receivableNumber varchar(50)model varchar(20)planDate datecustomer varchar(100)orderType varchar(30)motorcycleType varchar(30)plateNumber varchar(30)driver varchar(20)institution varchar(100) goodsName varchar(50)standard varchar(50)DeliveryAddress varchar(100)terminalClient varchar(100)distributionArea varchar(100)distributionAddress varchar(100)count introughWeight varchar(30)volume varchar(30)transportation doublecoolieHire doubleotherCharges doubletotal double

运输应收明细表

运输应付汇总表

付款记录表