快遞物流管理系統(tǒng)需求分析課程-文庫吧資料
2025-06-23 03:45本頁面
【正文】 中轉(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)后單號(hào)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í)單編號(hào)BackBillCodevarchar(50)應(yīng)付金額NeedPaymentmoney承運(yùn)費(fèi)CarryFeemoney預(yù)付金額PrepayMoneymoney訂裝保證金B(yǎng)indInsurancemoney加運(yùn)費(fèi)AddCarriagemoney已付金額PayedMoneymoney余額Balancemoney結(jié)算時(shí)間BalanceTimedatetime配載服務(wù)費(fèi)DispatchServiceFeemoney保險(xiǎn)費(fèi)Insurancemoney 客戶運(yùn)單結(jié)算表名稱字段數(shù)據(jù)類型PKIDPKIDint客戶名稱Customervarchar(50)貨運(yùn)單編號(hào)GoodsBillCodevarchar(50)本單金額BillMoneymoney應(yīng)收金額MoneyReceivablemoney已收金額ReceivedMoneymoney預(yù)付金額PrepayMoneymoney運(yùn)費(fèi)減款CarriageReduceFundmoney余額Balancemoney結(jié)算時(shí)間BalanceTimedatetime保險(xiǎn)費(fèi)Insurancemoney付回扣PayKickbackmoney送貨費(fèi)CarryGoodsFeemoney結(jié)算類型BalanceTypevarchar(50) 代收貨款結(jié)算表名稱字段數(shù)據(jù)類型PKIDPKIDint客戶名稱Customervarchar(50)貨運(yùn)單編號(hào)GoodsBillCodevarchar(50)應(yīng)收貨款A(yù)ccountReceivablemoney實(shí)收貨款FactReceiveFundmoney貨款變更GoodsPayChangemoney傭金率CommisionRatefloat(15)應(yīng)收傭金CommisionReceivablemoney已收傭金ReceivedCommisionmoney結(jié)算日期BalanceDatedatetime 雜費(fèi)結(jié)算表名稱字段數(shù)據(jù)類型PKIDPKIDint科目名稱SubjectNamevarchar(50)結(jié)算金額BalanceMoneymoney備注Remarkvarchar(50)結(jié)算日期BalanceDatedatetime結(jié)算類型BalanceTypevarchar(50) 投訴信息表名稱字段數(shù)據(jù)類型PKIDPKIDint客戶名稱Customervarchar(50)貨運(yùn)單編號(hào)GoodsBillCodevarchar(50)投訴內(nèi)容AppealContentvarchar(50)投訴日期AppealDatevarchar(50)是否處理IfHandlevarchar(50)處理日期DealDatevarchar(50)處理結(jié)果DealResultvarchar(50)是否回告IfCallbackvarchar(50)回告日期CallBackDatevarchar(50)處理人DealPersonvarchar(50) 客戶回告表名稱字段數(shù)據(jù)類型PKIDPKIDint貨運(yùn)單PKIDGoodsBillPKIDint是否回告IfCallbackbit 回告信息表名稱字段數(shù)據(jù)類型序號(hào)IDint撥出號(hào)碼DialNOvarchar(50)類別Typevarchar(50)內(nèi)容Contentvarchar(255)填寫時(shí)間WriteTimedatetime填寫人Writervarchar(50)最后撥出時(shí)間FinallyDialTimedatetime成功Successbit鎖定Lockedbit單據(jù)號(hào)BillIDvarchar(50)單據(jù)類型BillTypevarchar(50) 回告信息歷史表名稱字段數(shù)據(jù)類型序號(hào)IDint撥出號(hào)碼DialNOvarchar(50)類別Typevarchar(50)內(nèi)容Contentvarchar(255)填寫時(shí)間WriteTimedatetime填寫人Writervarchar(50)最后撥出時(shí)間FinallyDialTimedatetime成功Successbit鎖定Lockedbit單據(jù)號(hào)BillIDvarchar(50)單據(jù)類型BillTypevarchar(50) 營業(yè)外收入表名稱字段數(shù)據(jù)類型PKIDPKIDint名稱Namevarchar(50)金額Moneymoney收入月份IneMonthdatetime填寫日期WriteDatedatetime 員工工資表名稱字段數(shù)據(jù)類型PKIDPKIDint職員編號(hào)EmployeeCodevarchar(50)基本工資BasicWagemoney崗位工資StationWagemoney津貼Allowancemoney日期Datedatetime職員姓名Employeevarchar(50) 財(cái)務(wù)費(fèi)用表名稱字段數(shù)據(jù)類型PKIDPKIDint財(cái)務(wù)費(fèi)用FinanceFeemoney支出月份PayoutMonthdatetime填寫日期WriteDatedatetime 管理費(fèi)用表名稱字段數(shù)據(jù)類型PKIDPKIDint辦公費(fèi)OfficeFeemoney房租費(fèi)HouseRentmoney水電費(fèi)WaterElecFeemoney電話費(fèi)PhoneFeemoney其他支出OtherPayoutmoney支出月份PayoutMonthdatetime填寫日期WriteDatedatetime 賠償信息表名稱字段數(shù)據(jù)類型PKIDPKIDint賠償費(fèi)Amendsmoney客戶名稱Customervarchar(50)賠償時(shí)間AmendsTimedatetime備注Remarkvarchar(255)收貨點(diǎn)IDReceiveStationIDint貨差貨損BadDestroyGoodsmoney收貨點(diǎn)名ReceiveStationNamevarchar(50)填寫日期WriteDatedatetime 客戶基本信息表名稱字段數(shù)據(jù)類型PKIDPKIDint客戶編號(hào)CustomerCodevarchar(50)客戶名稱Customervarchar(50)電話Phonevarchar(50)傳真Faxvarchar(50)地址Addressvarchar(5
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1