快遞物流管理系統(tǒng)需求分析課程-wenkub
2023-07-02 03:45:55 本頁面
【正文】 Ovarchar(50)發(fā)貨客戶SendGoodsCustomervarchar(50)發(fā)貨客戶電話SendGoodsCustomerTelvarchar(50)發(fā)貨客戶地址SendGoodsCustomerAddrvarchar(50)收貨客戶編號ReceiveGoodsCustomerCodevarchar(50)收貨客戶ReceiveGoodsCustomervarchar(50)收貨客戶電話ReceiveGoodsCustomerTelvarchar(50)收貨客戶地址ReceiveGoodsCustomerAddrvarchar(50)發(fā)貨日期SendGoodsDatedatetime發(fā)貨地址SendGoodsAddrvarchar(50)收貨地址ReceiveGoodsAddrvarchar(50)預(yù)期交貨日期PredeliveryDatedatetime實(shí)際交貨日期FactDealDatedatetime代收貨款HelpAcceptPaymentmoney代收手續(xù)費(fèi)率AcceptprocedureRatevarchar(50)付款方式PayModevarchar(50)取貨方式FetchGoodsModevarchar(50)填票人WriteBillPersonvarchar(50)填寫日期WriteDatedatetime有效性Validityvarchar(50)是否審核IfAuditvarchar(50)是否結(jié)帳IfSettleAccountsvarchar(50)中轉(zhuǎn)地TransferStationvarchar(50)中轉(zhuǎn)費(fèi)TransferFeemoney減款ReduceFundmoney付回扣PayKickbackmoney代收貨款變更后金額MoneyOfChangePaymoney送貨費(fèi)CarryGoodsFeemoney運(yùn)費(fèi)Carriagemoney保險(xiǎn)費(fèi)Insurancemoney職員PKIDEmployeePKIDint備注Remarkvarchar(50)接貨點(diǎn)AcceptStationvarchar(100)發(fā)貨客戶手機(jī)SendGoodsCustomerMobilevarchar(50)收貨客戶手機(jī)ReceiveGoodsCustomerMobilevarchar(50) 貨運(yùn)單事件表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運(yùn)單PKIDGoodsBillPKIDint事件名稱EventNamevarchar(50)備注Remarkvarchar(50)發(fā)生時(shí)間OccurTimedatetime 貨運(yùn)回執(zhí)單詳表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運(yùn)回執(zhí)單PKIDGoodsRevertBillPKIDint貨運(yùn)單詳表PKIDGoodsBillDetailPKIDint件數(shù)PieceAmountint重量Weightreal體積Volumereal計(jì)價(jià)方式PriceModevarchar(50)計(jì)費(fèi)標(biāo)準(zhǔn)PriceStandardvarchar(50)貨物價(jià)值GoodsValuemoney 貨運(yùn)回執(zhí)單主表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運(yùn)回執(zhí)單編號GoodsRevertBillCodevarchar(50)裝貨地點(diǎn)LoadStationvarchar(50)起運(yùn)時(shí)間StartCarryTimedatetime交貨地點(diǎn)DealGoodsStationvarchar(50)到達(dá)時(shí)間ArriveTimedatetime收貨聯(lián)系人ReceiveGoodsLinkmanvarchar(50)聯(lián)系人電話LinkmanPhonevarchar(50)聯(lián)系人手機(jī)LinkmanMobilevarchar(50)收貨詳細(xì)地址ReceiveGoodsDetailAddrvarchar(50)運(yùn)費(fèi)結(jié)算方式CarriageBanlanceModevarchar(50)備注Remarkvarchar(50)司機(jī)PKIDDriverPKIDint是否結(jié)算IfBalancevarchar(50)回執(zhí)單狀態(tài)BackBillStatevarchar(50)起運(yùn)時(shí)的預(yù)付費(fèi)用StartAdvancemoney送貨單回執(zhí)押金CarryGoodsBillDepositmoney承運(yùn)人訂裝貨物保證金CarryGoodsInsurancemoney配載服務(wù)費(fèi)DispatchServiceFeemoney總運(yùn)費(fèi)AllCarriagemoney保險(xiǎn)費(fèi)Insurancemoney簽定時(shí)間SignTimedatetime接貨點(diǎn)AcceptStationvarchar(50)運(yùn)費(fèi)計(jì)價(jià)方式CarriageModevarchar(50)執(zhí)行Executebit 客戶回執(zhí)信息表名稱字段數(shù)據(jù)類型PKIDPKIDdecimal(18)貨運(yùn)單編號GoodsBillCodenvarchar(50)客戶名稱Customernvarchar(50)驗(yàn)收貨物記錄CheckGoodsRecordnvarchar(50)收貨人ReceiveGoodsPersonnvarchar(50)收貨日期ReceiveGoodsDatedatetime運(yùn)單事件PKIDCarryBillEventPKIDint 貨物回執(zhí)信息表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運(yùn)回執(zhí)編號GoodsRevertCodevarchar(50)司機(jī)名稱DriverNamevarchar(50)驗(yàn)收貨物記錄CheckGoodsRecordvarchar(50)收貨人ReceiveGoodsPersonvarchar(50)收貨日期ReceiveGoodsDatedatetime 貨運(yùn)差錯(cuò)表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運(yùn)回執(zhí)單編號GoodsRevertBillCodevarchar(50)貨運(yùn)單編號GoodsBillCodevarchar(50)客戶名稱Customervarchar(50)貨物名稱GoodsNamevarchar(50)差錯(cuò)類別MistakeTypevarchar(50)件數(shù)PieceAmountint規(guī)格Sizevarchar(50)貨物價(jià)值GoodsValuemoney 中轉(zhuǎn)信息表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運(yùn)單編號GoodsBillCodevarchar(50)中轉(zhuǎn)地TransferStationvarchar(50)中轉(zhuǎn)驗(yàn)收人TransferCheckvarchar(50)驗(yàn)收時(shí)間CheckTimedatetime描述Descriptionvarchar(50)中轉(zhuǎn)公司名TransferCompanyvarchar(50)中轉(zhuǎn)地址TransferAddrvarchar(50)中轉(zhuǎn)地電話TransferStationTelvarchar(50)中轉(zhuǎn)費(fèi)TransferFeevarchar(50)中轉(zhuǎn)后單號AfterTransferBillvarchar(50) 中轉(zhuǎn)公司信息表名稱字段數(shù)據(jù)類型PKIDPKIDint城市Cityvarchar(50)公司名稱CompanyNamevarchar(50)聯(lián)系電話LinkPhonevarchar(50)詳細(xì)地址DetailAddressvarchar(200) 司機(jī)結(jié)算主表名稱字段數(shù)據(jù)類型PKIDPKIDint司機(jī)名稱DriverNamevarchar(50)結(jié)算類型BalanceTypevarchar(50)回執(zhí)單編號BackBillCodevarchar(50)應(yīng)
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1