快遞物流管理系統(tǒng)需求分析課程(文件)
【正文】 付金額NeedPaymentmoney承運費CarryFeemoney預(yù)付金額PrepayMoneymoney訂裝保證金B(yǎng)indInsurancemoney加運費AddCarriagemoney已付金額PayedMoneymoney余額Balancemoney結(jié)算時間BalanceTimedatetime配載服務(wù)費DispatchServiceFeemoney保險費Insurancemoney 客戶運單結(jié)算表名稱字段數(shù)據(jù)類型PKIDPKIDint客戶名稱Customervarchar(50)貨運單編號GoodsBillCodevarchar(50)本單金額BillMoneymoney應(yīng)收金額MoneyReceivablemoney已收金額ReceivedMoneymoney預(yù)付金額PrepayMoneymoney運費減款CarriageReduceFundmoney余額Balancemoney結(jié)算時間BalanceTimedatetime保險費Insurancemoney付回扣PayKickbackmoney送貨費CarryGoodsFeemoney結(jié)算類型BalanceTypevarchar(50) 代收貨款結(jié)算表名稱字段數(shù)據(jù)類型PKIDPKIDint客戶名稱Customervarchar(50)貨運單編號GoodsBillCodevarchar(50)應(yīng)收貨款A(yù)ccountReceivablemoney實收貨款FactReceiveFundmoney貨款變更GoodsPayChangemoney傭金率CommisionRatefloat(15)應(yīng)收傭金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)填寫時間WriteTimedatetime填寫人Writervarchar(50)最后撥出時間FinallyDialTimedatetime成功Successbit鎖定Lockedbit單據(jù)號BillIDvarchar(50)單據(jù)類型BillTypevarchar(50) 營業(yè)外收入表名稱字段數(shù)據(jù)類型PKIDPKIDint名稱Namevarchar(50)金額Moneymoney收入月份IneMonthdatetime填寫日期WriteDatedatetime 員工工資表名稱字段數(shù)據(jù)類型PKIDPKIDint職員編號EmployeeCodevarchar(50)基本工資BasicWagemoney崗位工資StationWagemoney津貼Allowancemoney日期Datedatetime職員姓名Employeevarchar(50) 財務(wù)費用表名稱字段數(shù)據(jù)類型PKIDPKIDint財務(wù)費用FinanceFeemoney支出月份PayoutMonthdatetime填寫日期WriteDatedatetime 管理費用表名稱字段數(shù)據(jù)類型PKIDPKIDint辦公費OfficeFeemoney房租費HouseRentmoney水電費WaterElecFeemoney電話費PhoneFeemoney其他支出OtherPayoutmoney支出月份PayoutMonthdatetime填寫日期WriteDatedatetime 賠償信息表名稱字段數(shù)據(jù)類型PKIDPKIDint賠償費Amendsmoney客戶名稱Customervarchar(50)賠償時間AmendsTimedatetime備注Remarkvarchar(255)收貨點IDReceiveStationIDint貨差貨損BadDestroyGoodsmoney收貨點名ReceiveStationNamevarchar(50)填寫日期WriteDatedatetime 客戶基本信息表名稱字段數(shù)據(jù)類型PKIDPKIDint客戶編號CustomerCodevarchar(50)客戶名稱Customervarchar(50)電話Phonevarchar(50)傳真Faxvarchar(50)地址Addressvarchar(50)郵編PostCodevarchar(50)聯(lián)系人Linkmanvarchar(50)聯(lián)系人手機LinkmanMobilevarchar(50)客戶類型CustomerTypevarchar(50)企業(yè)性質(zhì)EnterprisePropertyvarchar(50)企業(yè)規(guī)模EnterpriseSizevarchar(50)電子郵件Emailvarchar(50) 職員信息表名稱字段數(shù)據(jù)類型PKIDPKIDint職員編號EmployeeCodevarchar(50)職員姓名Employeevarchar(50)部門Departmentvarchar(50)職位Positionvarchar(50)性別Gendervarchar(50)出生日期Birthdaydatetime 司機信息表名稱字段數(shù)據(jù)類型PKIDPKIDint司機名稱DriverNamevarchar(50)身份證號IDCardvarchar(50)電話Phonevarchar(50)手機Mobilevarcha
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1