快遞物流管理系統(tǒng)需求分析課程(存儲版)
【正文】 IDDriverPKIDint是否結(jié)算IfBalancevarchar(50)回執(zhí)單狀態(tài)BackBillStatevarchar(50)起運時的預付費用StartAdvancemoney送貨單回執(zhí)押金CarryGoodsBillDepositmoney承運人訂裝貨物保證金CarryGoodsInsurancemoney配載服務費DispatchServiceFeemoney總運費AllCarriagemoney保險費Insurancemoney簽定時間SignTimedatetime接貨點AcceptStationvarchar(50)運費計價方式CarriageModevarchar(50)執(zhí)行Executebit 客戶回執(zhí)信息表名稱字段數(shù)據(jù)類型PKIDPKIDdecimal(18)貨運單編號GoodsBillCodenvarchar(50)客戶名稱Customernvarchar(50)驗收貨物記錄CheckGoodsRecordnvarchar(50)收貨人ReceiveGoodsPersonnvarchar(50)收貨日期ReceiveGoodsDatedatetime運單事件PKIDCarryBillEventPKIDint 貨物回執(zhí)信息表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運回執(zhí)編號GoodsRevertCodevarchar(50)司機名稱DriverNamevarchar(50)驗收貨物記錄CheckGoodsRecordvarchar(50)收貨人ReceiveGoodsPersonvarchar(50)收貨日期ReceiveGoodsDatedatetime 貨運差錯表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運回執(zhí)單編號GoodsRevertBillCodevarchar(50)貨運單編號GoodsBillCodevarchar(50)客戶名稱Customervarchar(50)貨物名稱GoodsNamevarchar(50)差錯類別MistakeTypevarchar(50)件數(shù)PieceAmountint規(guī)格Sizevarchar(50)貨物價值GoodsValuemoney 中轉(zhuǎn)信息表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運單編號GoodsBillCodevarchar(50)中轉(zhuǎn)地TransferStationvarchar(50)中轉(zhuǎn)驗收人TransferCheckvarchar(50)驗收時間CheckTimedatetime描述Descriptionvarchar(50)中轉(zhuǎn)公司名TransferCompanyvarchar(50)中轉(zhuǎn)地址TransferAddrvarchar(50)中轉(zhuǎn)地電話TransferStationTelvarchar(50)中轉(zhuǎn)費TransferFeevarchar(50)中轉(zhuǎn)后單號AfterTransferBillvarchar(50) 中轉(zhuǎn)公司信息表名稱字段數(shù)據(jù)類型PKIDPKIDint城市Cityvarchar(50)公司名稱CompanyNamevarchar(50)聯(lián)系電話LinkPhonevarchar(50)詳細地址DetailAddressvarchar(200) 司機結(jié)算主表名稱字段數(shù)據(jù)類型PKIDPKIDint司機名稱DriverNamevarchar(50)結(jié)算類型BalanceTypevarchar(50)回執(zhí)單編號BackBillCodevarchar(50)應付金額NeedPaymentmoney承運費CarryFeemoney預付金額PrepayMoneymoney訂裝保證金B(yǎng)indInsurancemoney加運費AddCarriagemoney已付金額PayedMoneymoney余額Balancemoney結(jié)算時間BalanceTimedatetime配載服務費DispatchServiceFeemoney保險費Insurancemoney 客戶運單結(jié)算表名稱字段數(shù)據(jù)類型PKIDPKIDint客戶名稱Customervarchar(50)貨運單編號GoodsBillCodevarchar(50)本單金額BillMoneymoney應收金額MoneyReceivablemoney已收金額ReceivedMoneymoney預付金額PrepayMoneymoney運費減款CarriageReduceFundmoney余額Balancemoney結(jié)算時間BalanceTimedatetime保險費Insurancemoney付回扣PayKickbackmoney送貨費CarryGoodsFeemoney結(jié)算類型BalanceTypevarchar(50) 代收貨款結(jié)算表名稱字段數(shù)據(jù)類型PKIDPKIDint客戶名稱Customervarchar(50)貨運單編號GoodsBillCodevarchar(50)應收貨款AccountReceivablemoney實收貨款FactReceiveFundmoney貨款變更GoodsPayChangemoney傭金率CommisionRatefloat(15)應收傭金CommisionReceivablemoney已收傭金ReceivedCommisionmoney結(jié)算日期BalanceDatedatetime 雜費結(jié)算表名稱字段數(shù)據(jù)類型PKIDPKIDint科目名稱SubjectNamevarchar(50)結(jié)算金額BalanceMoneymoney備注Remarkvarchar(50)結(jié)算日期BalanceDatedatetime結(jié)算類型BalanceTypevarchar(50) 投訴信息表名稱字段數(shù)據(jù)類型PKIDPKIDint客戶名稱Customervarchar(50)貨運單編號GoodsBillCodevarchar(50)投訴內(nèi)容AppealContentvarchar(50)投訴日期AppealDatevarchar(50)是否處理IfHandlevarchar(50)處理日期DealDatevarchar(50)處理結(jié)果DealResultvarchar(50)是否回告IfCallbackvarchar(50)回告日期CallBackDatevarchar(50)處理人DealPersonvarchar(50) 客戶回告表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運單PKIDGoodsBillPKIDint是否回告IfCallbackbit 回告信息表名稱字段數(shù)據(jù)類型序號IDint撥出號碼DialNOvarchar(50)類別Typevarchar(50)內(nèi)容Contentvarchar(255)填寫時間WriteTimedatetime填寫人Writervarchar(50)最后撥出時間FinallyDialTimedatetime成功Successbit鎖定Lockedbit單據(jù)號BillIDvarchar(50)單據(jù)類型BillTypevarchar(50) 回告信息歷史表名稱字段數(shù)據(jù)類型序號IDint撥出號碼DialNOvarchar(50)類別Typevarchar(50)內(nèi)容Contentvarchar(255)填寫時間WriteTimedat
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1