ERP數(shù)據(jù)庫(kù)詳細(xì)設(shè)計(jì)說明書

1、ERP數(shù)據(jù)庫(kù)設(shè)計(jì)說明書項(xiàng)目代號(hào)：CX-2010-04-XXXXXXXXX技術(shù)有限企業(yè)2011-04-28目錄1、數(shù)據(jù)庫(kù)設(shè)計(jì).錯(cuò)誤!不決義書簽。、命名規(guī)則.錯(cuò)誤!不決義書簽。、共用表.錯(cuò)誤!不決義書簽。、基礎(chǔ)數(shù)據(jù).錯(cuò)誤!不決義書簽。、庫(kù)存子系統(tǒng).錯(cuò)誤!不決義書簽。、銷售子系統(tǒng).錯(cuò)誤!不決義書簽。、采買子系統(tǒng).錯(cuò)誤!不決義書簽。1、命名規(guī)則見數(shù)據(jù)庫(kù)表名與字段名命名規(guī)范2、基礎(chǔ)數(shù)據(jù)見erp項(xiàng)目數(shù)據(jù)庫(kù)腳本.sql文件2.1、物料類型(設(shè)計(jì)人：XXX)字段名種類能否為空主鍵外鍵默認(rèn)值中文說明matypeidVarchar2(50)noyes物料類型編號(hào)matypenameVarchar2(50)no物料

2、類又名稱matypeengnameVarchar2(50)yes英文名稱matyperemarkVarchar2(2000)yes備注safetyonevarchar2(50)yesNoNoNo保存字段safetytwovarchar2(50)yesNoNoNo保存字段enablesnumber默認(rèn)1不表記能否刪除刪除，0：刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】2.2、庫(kù)房表(設(shè)計(jì)人：XXX)字段名種類能否為主外鍵默認(rèn)值中文說明空鍵stoidVarchar2(50)noyes庫(kù)房編號(hào)stonameVarchar2(50)no庫(kù)房名稱stosimplenameVarc

3、har2(50)yes庫(kù)房簡(jiǎn)稱stoconnectperVarchar2(50)yes聯(lián)系人stoempidVarchar2(50)yes聯(lián)系人ID(新增)stophoneVarchar2(50)yes聯(lián)系電話stoaddressVarchar2(50)yes庫(kù)房地點(diǎn)storemarkVarchar2(2000)yes備注safetyonevarchar2(50)yesNoNoNo保存字段safetytwovarchar2(50)yesNoNoNo保存字段enablesnumber默認(rèn)1不刪除，0：表記能否刪除刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】2.3、物料主文件

4、(設(shè)計(jì)人：XXX)字段名種類能否主鍵外鍵默認(rèn)值中文說明為空matidVarchar2(50)yes物料編號(hào)nomatnameVarchar2(50)no物料名稱matspecVarchar2(50)yes規(guī)格型號(hào)mattypeidVarchar2(20)no物料類型（偽外鍵）mattypenameVarchar2(50)no物料類又名稱matadvicepricenumber(19,4)no建議售價(jià)matadvicepriceAnumber(19,4)yes售價(jià)AmatadvicepriceBnumber(19,4)Yes售價(jià)BmatadvicepriceCnumber(19,4)Yes售價(jià)C

5、matadvicepriceDnumber(19,4)Yes售價(jià)DmatadvicepriceEnumber(19,4)Yes售價(jià)Ematstandardpricenumber(19,4)no標(biāo)準(zhǔn)進(jìn)價(jià)matshapeVarchar(50)no成品物料型態(tài)matifdutyNumber(9)No0：否能否含稅matdutyratenumber(19,4)No稅率matstockaheaddatenumber(9)no0采買提早期matmainaffordVarchar2(50)yes主供給商matmainaffordidVarchar2(50)yes主供給商IDmatgawpdatenumber

6、(9)yes30呆板起計(jì)天數(shù)matstopdatedateyes停用日期matremarkVarchar2(2000)yes備注matunitVarchar2(50)yes計(jì)量單位safetyonevarchar2(50)yesNoNoNo保存字段safetytwovarchar2(50)yesNoNoNo保存字段EnableNumber(9)NoNoNoNo表記能否刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】2.4、客戶主文件(設(shè)計(jì)人：XXX)字段名種類能否為空主鍵外鍵默認(rèn)值中文說明cliidVarchar2(50)NY客戶編號(hào)clitypeidVarchar2(50)

7、客戶類型IdclinameVarchar2(50)N客戶全稱clishortnameVarchar2(50)客戶簡(jiǎn)稱cliaddressVarchar2(50)地方（詳細(xì)）cliareaVarchar2(50)地域clienameVarchar2(50)英文全稱clieshortnameVarchar2(50)英文簡(jiǎn)稱基本資料cliprincipalVarchar2(50)負(fù)責(zé)人clilinkmanVarchar2(50)聯(lián)系人cliphoneoneVarchar2(50)聯(lián)系電話一cliphonetwoVarchar2(50)聯(lián)系電話二cliphonethreeVarchar2(50)聯(lián)系電

8、話三clibankaccountsVarchar2(50)銀行帳號(hào)cliopenbankVarchar2(50)開戶銀行empidVarchar2(50)N業(yè)務(wù)人員idclimobilephoneVarchar2(50)挪動(dòng)電話cliemailVarchar2(50)電子郵件cliwebVarchar2(50)網(wǎng)址clifaxesVarchar2(50)傳真號(hào)碼銷售信息clioldoutdatedate最先銷售出貨日clioldintodatedate最先銷售退貨日clinewoutdatedate近來銷售出貨日clinewintodatedate近來銷售退貨日clidiscountVarch

9、ar2(50)折數(shù)(%)clipricestepVarchar2(50)售價(jià)等級(jí)clicreatedatedate客戶成立日clistopdatedate停止交易日收款信息clizhangkuaneduVarchar2(50)賬款額度cliremaineduVarchar2(50)節(jié)余額度cliconditionVarchar2(50)收款條件（天）climonthreckoningdate每個(gè)月結(jié)賬日clicreditstepVarchar2(50)信譽(yù)等級(jí)cliqcpremoneynumber(19,4)期初預(yù)收款cliqcdealmoneynumber(19,4)期初應(yīng)收款cliqmpr

10、emoneynumber(19,4)期末預(yù)收款cliqmdealmoneynumber(19,4)期末應(yīng)收款其余cliotherremarkVarchar2(2000)備注clitrashNumber(4,0)能否廢碼safetyonevarchar2(50)保存字段safetytwovarchar2(50)保存字段enablesnumber默認(rèn)1表記能否刪除不刪除，0：刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】2.5、客戶類型表(設(shè)計(jì)人：XXX)字段名種類能否為空主鍵外鍵默認(rèn)值中文說明clitypeidVarchar2（50）NN類型編號(hào)clitypenameVarc

11、har2（50）N類又名稱clitypeenameVarchar2（50）N英文名稱cliremarkVarchar2（500）Y備注clitypetrashNumber(4,0)0能否廢碼safetyonesafetytwoEnablevarchar2(50)varchar2(50)Number(9)yesyesNo保存字段保存字段表記能否刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】2.6、人員表(設(shè)計(jì)人：XXX)字段名種類能否為空主鍵外鍵默認(rèn)值中文說明empidVarchar2（50）NY人員編號(hào)empnameVarchar2（50）N人員姓名empenameVarc

12、har2（50）英文姓名depidVarchar2（50）N部門編號(hào)idempsexVarchar2（50）N性別（默認(rèn)男）empcardVarchar2（50）N身份證號(hào)基本資料empstateVarchar2（50）N任職狀態(tài)idempdutyVarchar2（50）職務(wù)（改字段名）empphoneoneVarchar2（50）聯(lián)系電話一empphonetwoVarchar2（50）聯(lián)系電話二empphonethreeVarchar2（50）聯(lián)系電話三empbankaccountsVarchar2（50）銀行賬號(hào)empbirthdayDate出誕辰期(改正數(shù)據(jù)種類)empjobVarcha

13、r2（50）崗位EmpemailVarchar2（50）電子郵件（一個(gè)郵箱）empwebVarchar2（50）網(wǎng)址empfaxesVarchar2（50）傳真號(hào)碼empopenbankVarchar2（50）開戶銀行其余信息emptopVarchar2（50）最高學(xué)歷empdegreeVarchar2（50）學(xué)位empgotimedate到期日期empgraduatetimeVarchar2（50）畢業(yè)學(xué)校emppactstarttimedate合同開端日期emppactendtimedate合同停止日期通信資料empnowmailidVarchar2（50）現(xiàn)郵編empfamilyphon

14、eVarchar2（50）家庭電話empfamilyplaceVarchar2（50）家庭地址empnowphoneVarchar2（50）現(xiàn)電話empnowplaceVarchar2（50）現(xiàn)地址empexigencemanVarchar2（50）緊迫聯(lián)系人empfamilymailidVarchar2（50）家庭郵編其余empremarkvarchar2(2000)emptrashNumber(4,0)safetyonevarchar2(50)safetytwovarchar2(50)enablesnumber【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】備注0能否廢碼保存

15、字段保存字段默認(rèn)1不刪除，0：表記能否刪除刪除2.7、供給商種類表(設(shè)計(jì)人：XXX)字段名種類空否主鍵外鍵默認(rèn)值中文說明peeidVarchar2（50）NY類型編號(hào)peenameVarhcar2(50)N類又名稱peeEnameVarchar2(50)N類型英文名稱peeremarkVarchar2(2000)Y備注peetrashNumber(4,0)0能否廢碼safetyonevarchar2(50)保存字段safetytwovarchar2(50)保存字段enablesnumber默認(rèn)1不刪除，0：表記能否刪除刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】2.8、供

16、給商主文件表(設(shè)計(jì)人：XXX)字段名種類空否主鍵外鍵默認(rèn)值中文說明peoidVarchar2(50)NY供給商編號(hào)peonameVarchar2(50)N供給商全稱peoshortnameVarchar2(50)供給商簡(jiǎn)稱peoascriptionVarchar2(50)N帳款歸屬peopeeidVarchar2(50)供給商種類表idpeopeenameVarchar2(50)供給商種類表名稱（新增）peoareaVarchar2(50)地域peoprincipalVarchar2(50)負(fù)責(zé)人peolinkmanVarchar2(50)聯(lián)系人peophoneoneVarchar2(50)聯(lián)

17、系電話一peophonetwoVarchar2(50)聯(lián)系電話二peomobilephoneVarchar2(50)挪動(dòng)電話peobankaccountsVarchar2(50)銀行帳號(hào)peoopenbankVarchar2(50)開戶銀行PeoempidVarchar2(50)（業(yè)務(wù)人員編號(hào)）PeoempnameVarchar2(50)（業(yè)務(wù)人員名稱）peocallingVarchar2(50)行業(yè)別peoemailVarchar2(50)電子郵件peowebVarchar2(50)網(wǎng)址peofaxesVarchar2(50)傳真號(hào)碼peocreatedateVarchar2(50)成立日期

18、peocreditclassVarchar2(50)信譽(yù)等級(jí)peozhangkuanedunumber(19,4)帳款額度peoremainedunumber(19,4)節(jié)余額度peomonthreckoningnumber(19,4)31每個(gè)月結(jié)帳日Peoqcprepaymoneynumber(19,4)期初預(yù)支款peoqcdealmoneynumber(19,4)期初對(duì)付款peoqmprepaymoneynumber(19,4)期末預(yù)支款peoqmdealmoneynumber(19,4)期末對(duì)付款peoremarkVarchar2(2000)備注peotrashNumber(4,0)0能

19、否廢碼safetyonevarchar2(50)保存字段safetytwovarchar2(50)保存字段enablesnumber默認(rèn)1不刪除，0：表記能否刪除刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】2.9、部門表(設(shè)計(jì)人：XXX)字段名種類空否主鍵外鍵默認(rèn)值中文說明depidVarchar2(50)NY部門編號(hào)depnameVarchar2(50)N部門名稱depremarkVarchar2(2000)備注deptrashVarchar2(50)N能否廢碼safetyonevarchar2(50)保存字段safetytwovarchar2(50)保存字段enabl

20、esnumber默認(rèn)1不刪除，0：表記能否刪除刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】3、共用表3.1、庫(kù)存總賬表（設(shè)計(jì)人：黃?。┳侄蚊N類能否為主鍵外鍵默認(rèn)值中文說明空GenidVarchar2(50)NoYesNo行號(hào)genmaterielidVarchar2(50)NoNo物料編號(hào)genstoragenoVarchar2(20)NoNo庫(kù)房編號(hào)(偽外鍵)genstoragenameVarchar2(20)NoNoNo庫(kù)房genexpectstartqtyNumber(9)no期初總數(shù)目genstandarcostnumber(19,4)no標(biāo)準(zhǔn)成本genallc

21、ostnumber(19,4)no標(biāo)準(zhǔn)總成本genexpectstartallcostnumber(19,4)no期初總成本gensafetyqtyNumber(9)no安全數(shù)目GenavgcostNumber(19,4)NoNoNoNo均勻成本GenqtyNumber(9)NoNoNoNo現(xiàn)有總數(shù)目GennowavgcostNumber(19,4)NoNoNoNo現(xiàn)行均勻成本GenstandardcostallNumber(19,4)NoNoNoNo標(biāo)準(zhǔn)總成本（更名字）GennowcostNumber(19,4)NoNoNoNo現(xiàn)行總成本safetyonevarchar2(50)yesNoN

22、oNo保存字段safetytwovarchar2(50)yesNoNoNo保存字段enablesnumber表記能否刪除默認(rèn)1不刪除，0：刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】3.2、庫(kù)存出入明細(xì)表(設(shè)計(jì)人：XXX)字段名種類能否為空主鍵外鍵默認(rèn)值中文說明MinusaddidNumber(9)Nn主鍵IDMinusdatedatenn票據(jù)日期MatypeidVarchar2(20)nn物料編號(hào)MatypenameVarchar2(50)nn物料名稱MinusaddNumber(9)nn數(shù)目（+，-）UnitpriceNumber(19,4)單價(jià)MoneysNumbe

23、r(19,4)金額storagedateDate時(shí)間StoidVarchar2(50)nn庫(kù)房IDStonameVarchar2(50)nn庫(kù)房名稱OrigintypeVarchar2(20)nn根源單別OriginidVarchar2(20)nn根源單號(hào)AftermathNumber(9)nn期末結(jié)存enablesnumber默認(rèn)1不刪除，0：表記能否刪除刪除Safetytonevarchar2(50)Yn保存字段1Safetytwovarchar2(50)Yn保存字段2【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】3.3、采買賬款明細(xì)表(XXX）字段名種類能否為主鍵外鍵默認(rèn)

24、值中文說明空storageidNumber(9)Ny主鍵IDstoragedatedaten票據(jù)日期origintypesVarchar2(50)y根源單別originidVarchar2(20)y根源單號(hào)nowdateatdatey日期clientsupplyVarchar2(50)y供貨商名稱citationidVarchar2(50)y供貨商IDformerlymoneysNumber(19,4)y原單金額nowadaysmoneysNumber(19,4)y現(xiàn)行余額enablesnumber默認(rèn)1不刪除，0：刪表記能否刪除除safetytonevarchar2(50)Yn保存字段saf

25、etytwovarchar2(50)Yn保存字段【表說明】記錄每個(gè)庫(kù)房每次數(shù)目和金額的改變量【主鍵說明】流水號(hào)【外鍵說明】票據(jù)類型【索引說明】時(shí)間字段加索引【字段增補(bǔ)說明】4、庫(kù)存子系統(tǒng)4.1、清點(diǎn)主表(設(shè)計(jì)人：XXX)字段名種類能否為空主鍵外鍵默認(rèn)值中文說明cheidVarchar2(50)NOYNo清點(diǎn)單的流水號(hào)chestoragenoVarchar2(50)NoNo清點(diǎn)的庫(kù)房編號(hào)Storage(stoid)chestoragenameVarchar2(50)NONo清點(diǎn)的庫(kù)房名稱chedatedateNoSysdate清點(diǎn)的日期chemanVarchar2(50)NoNo清點(diǎn)人名稱che

26、deptnameVarchar2(50)NoNo部門名稱cherestrictmanVarchar2(50)YesNo制單人-目前登錄人cheauditingmanVarchar2(50)YesNo審查人-目前登錄人chestatuNumber(2)NoNo審查狀態(tài)，0為未審查safetyonevarchar2(50)yesNo保存字段safetytwovarchar2(50)yesNo保存字段enablesnumber默認(rèn)1不刪除，表記能否刪除0：刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】4.2、清點(diǎn)明細(xì)表(設(shè)計(jì)人:XXX)字段名種類能否為空主鍵外鍵默認(rèn)值中文說明ch

27、eidVarchar2(50)NoYesYesNo清點(diǎn)單的流水號(hào)check(cheid)chelineidNumber(9)NoYesNoNo欄號(hào)chematerielidVarchar2(50)NoNoNoNo物料的編號(hào)Materiel(matid)chematerielnameVarchar2(50)NoNoNoNo物料的名稱cheunitnameVarchar2(50)NoNoNoNo單位名稱cheaccountqtyNumber(9)NoNoNoNo賬面數(shù)目checheckqtyNumber(9)NoNoNoNo清點(diǎn)數(shù)目cheprofitandlossqNumber(9)NoNoNoN

28、o盈虧數(shù)目tycheprofitandlossmNumber(19,4)NoNoNoNo盈虧金額oneychepriceNumber(19,4)NoNoNoNo單價(jià)cheremarkVarchar2(2000)YesNoNoNo備注safetyonevarchar2(50)yesNoNoNo保存字段safetytwovarchar2(50)yesNoNoNo保存字段enablesnumber默認(rèn)1不刪除，0：表記能否刪除刪除【表說明】【主鍵說明】AltertablecheckdetailAddconstraintcheckdetail_PK_1primarykey(cheid,chelinei

29、d);【外鍵說明】altertablecheckdetailaddconstraintcheckdetail_FK_1foreignkey(cheid)referencecheck(cheid)【索引說明】【字段增補(bǔ)說明】按數(shù)目和金額4.3、其余出庫(kù)主表(設(shè)計(jì)人：劉XXX)字段名種類能否為空主鍵外鍵默認(rèn)值中文說明Othidvarchar2(50)Y票據(jù)號(hào)碼(系統(tǒng)自帶)OthdateDate票據(jù)日期othouttypeidvarchar2(50)出庫(kù)種類idothstorevarchar2(50)庫(kù)房Othoutnamevarchar2(50)出庫(kù)人名Othdeptvarchar2(50)所屬部

30、門Othmakemanidvarchar2(50)制單人員Othrepeatuseridvarchar2(50)復(fù)核人員clitrashNumber(4,0)能否廢碼safetyonevarchar2(50)保存字段safetytwovarchar2(50)保存字段enablesnumber默認(rèn)1不刪除，0：表記能否刪除刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】4.4、其余出庫(kù)明細(xì)表(設(shè)計(jì)人：XXX)字段名種類能否為空主鍵外鍵默認(rèn)值中文說明otheroutidvarchar2(50)YY票據(jù)號(hào)碼(其余出庫(kù)主表id)Othoutlinenovarchar2(50)Y欄號(hào)O

31、thoutmertialsidvarchar2(50)物料編號(hào)Othoutmertialnamevarchar2(50)物料名稱Othouttypesvarchar2(50)規(guī)格型號(hào)Othoutunitsvarchar2(50)單位Othoutamountnumber(9)0數(shù)目othoutremarkvarchar2(2000)備注clitrashNumber(4,0)能否廢碼safetyonevarchar2(50)保存字段safetytwovarchar2(50)保存字段enablesnumber默認(rèn)1不刪除，0：表記能否刪除刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說

32、明】4.5、其余入庫(kù)主表(設(shè)計(jì)人：XXX)字段名種類能否為空主鍵外鍵默認(rèn)值中文說明Othcomeidvarchar2(50)Ny票據(jù)號(hào)碼(系統(tǒng)自帶)OthcomedateDateN票據(jù)日期othcometypeidvarchar2(50)N入庫(kù)種類Othcomestorevarchar2(50)庫(kù)房Othcomenamevarchar2(50)入庫(kù)人員Othcomedeptvarchar2(50)所屬部門Othcomemakemanivarchar2(50)制單人員dOthcomerepeatuserivarchar2(50)Y復(fù)核人員dclitrashNumber(4,0)能否廢碼safet

33、yonevarchar2(50)保存字段safetytwovarchar2(50)保存字段enablesnumber默認(rèn)刪除1不刪除，0：表記能否刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】4.6、其余入庫(kù)明細(xì)表(設(shè)計(jì)人：XXX)字段名種類能否為空主鍵外鍵默認(rèn)值中文說明Othcomeidvarchar2(50)YY其余入庫(kù)主表idOthcomenovarchar2(50)NY欄號(hào)Othcomemertialsidvarchar2(50)N物料編號(hào)Othcomemertialnamevarchar2(50)N物料名稱Othcometypesvarchar2(50)Y規(guī)格型號(hào)

34、Othcomeunitsvarchar2(50)單位Othcomeamountnumber(9)0數(shù)目othcomeremarkvarchar2(2000)備注clitrashNumber(4,0)能否廢碼safetyonevarchar2(50)保存字段safetytwovarchar2(50)保存字段enablesnumber默認(rèn)表記能否刪除1不刪除，0：刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】4.7、調(diào)價(jià)主表(設(shè)計(jì)人：XXX)字段名種類能否為空主鍵外鍵默認(rèn)值中文說明movedatedateNN票據(jù)日期moveorderNoVarchar2(50)Y票據(jù)號(hào)碼mov

35、eadjustVarchar2(50)N調(diào)整方式movestorageNoVarchar2(50)N庫(kù)房編號(hào)movemakeVarchar2(50)N制單人員movecheckVarchar2(50)N復(fù)核人員moveremarkVarchar2(2000)N備注moveAuditingStatNumber(9)N審查狀態(tài)esafetyonevarchar2(50)yesNoNoNo保存字段safetytwovarchar2(50)yesNoNoNo保存字段enablesnumber默認(rèn)1不刪除，0：表記能否刪除刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】4.8、調(diào)價(jià)明細(xì)

36、表(設(shè)計(jì)人：XXX)字段名種類能否為空主鍵外鍵默認(rèn)值中文說明MoveinileNumber(9)Y行號(hào)moveorderNoVarchar2(50)NY票據(jù)號(hào)碼MovematerielnoVarchar2(50)N物料編號(hào)MovematerielnameVarchar2(50)物料名稱MovespectypeVarchar2(50)規(guī)格型號(hào)MoveunitVarchar2(50)單位MovestocksNumber(9)庫(kù)存量moveaveragecostNumber(19,4)現(xiàn)行均勻成本movepriceNumber(19,4)單價(jià)（自己填）movemovepriceNumber(19,4

37、)調(diào)價(jià)金額safetyonevarchar2(50)yesNoNoNo保存字段safetytwovarchar2(50)yesNoNoNo保存字段enablesnumber默認(rèn)1不刪除，0：表記能否刪除刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】4.9、調(diào)撥單主表(設(shè)計(jì)人：XXX)字段名種類空否主鍵外鍵默認(rèn)值中文說明MsenoVarchar2(50)NY票據(jù)號(hào)碼(單號(hào))msedatedateN目前系統(tǒng)時(shí)間票據(jù)日期MseoutstorageVarchar2(50)N出庫(kù)倉(cāng)（庫(kù)房編號(hào)）mseinsertstorVarchar2(50)N入庫(kù)倉(cāng)（庫(kù)房編號(hào)）mseemployee

38、Varchar2(50)N制作人mesAuditingempVarchar2(50)N審查人MesremarkVarchar2(2000)備注messtateVarchar2(50)0：未審查審查狀態(tài)MestrashVarchar2(50)0：報(bào)廢1:可用能否可用MespreservingoneVarchar2(50)保存字段1mespreservingtwoVarchar2(50)保存字段1enablesnumber默認(rèn)1表記能否刪除不刪除，0：刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】4.10、調(diào)撥單明細(xì)表(設(shè)計(jì)人:XXX)字段名種類空否主鍵外鍵默認(rèn)值中文說明Mds

39、noVarchar2(50)NY單號(hào)MdsmsenoVarchar2(50)NYY票據(jù)號(hào)碼(單號(hào))mdsmaterieltypeVarchar2(50)N物料編號(hào)mdsmaterielnameVarchar2(50)N物料名稱mdsmaterielspecsVarchar2(50)物料規(guī)格mdsmaterielunitVarchar2(50)單位mdsmaterielnumVarchar2(50)N數(shù)目MdsavgcostVarchar2(50)N現(xiàn)行均勻成本（出庫(kù)）mdscostVarchar2(50)N總現(xiàn)行均勻成本MdsremarkVarchar2(2000)備注Mespreservin

40、goneVarchar2(50)保存字段1mespreservingtwoVarchar2(50)保存字段1enablesnumber默認(rèn)1不刪除，0：表記能否刪除刪除【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】5、銷售子系統(tǒng)5.1、銷售報(bào)價(jià)主表(設(shè)計(jì)人：XXX)字段名種類空否主鍵外鍵默認(rèn)值中文說明billIdvarchar2(20)NotnullY票據(jù)號(hào)碼billDateDateNotnull票據(jù)日期sinIdnumber(9)Notnull票據(jù)種類singleType(sinId)sinNameVarchar(50)null票據(jù)名稱cliidVarchar2(50)Not

41、null客戶編號(hào)client(cliid)clishortnameVarchar2(50)Notnull客戶簡(jiǎn)稱cliplaceidVarchar2(50)Null地點(diǎn)編號(hào)CliplaceVarchar2(50)Null地點(diǎn)effectdateDateNull有效日期currencyTypeVarchar2(50)Notnull幣別priceWhetherTaxvarchar2(20)Notnull單價(jià)能否含稅empidVarchar2(50)Notnull業(yè)務(wù)人員編號(hào)，也就是人員編號(hào)employee(empid)empNameVarchar2(50)Notnull業(yè)務(wù)人員depidVarch

42、ar2(50)Notnull部門編號(hào)depttab(depid)depNameVarchar2(50)Notnull所屬部門makeEmpNameVarchar2(50)Notnull制單人員AuditingEmpNameVarchar2(50)null復(fù)核人員checkstateNumber(9)Notnull默認(rèn)0未審審查狀態(tài)核，1：審查totalMoneyNumber(19,4)Null共計(jì)金額totalTaxNumber(19,4)Null共計(jì)稅額totalTaxMoneyNumber(19,4)Null共計(jì)含稅金額remarkvarchar2(2000)Null備注enablesnu

43、mber默認(rèn)1不刪表記能否刪除除，0：刪除Safetyonevarchar2(50)Null保存字段safetytowvarchar2(50)null保存字段【表說明】銷售報(bào)價(jià)主表【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】Safetyone與safetytwo是一個(gè)保存字段Enable是一個(gè)表記能否刪除，默認(rèn)1不刪除，0：刪除5.2、銷售報(bào)價(jià)明細(xì)表(設(shè)計(jì)人：XXX)字段名種類空否主鍵外鍵默認(rèn)值中文說明billIdvarchar2(20)NotnullYY票據(jù)號(hào)碼sellquote(billId)coteMarkNumber(9)NotnullY欄號(hào)matidVarchar2(50)N

44、otnull物料編號(hào)Materiel(matid)matnamevarchar2(50)Notnull物料名稱matspecvarchar2(50)null規(guī)格型號(hào)matunitvarchar2(50)Notnull單位名稱quonumbernumber(9)Notnull數(shù)目agioAgoPricenumber(19,4)Notnull折扣前單價(jià)agioNumber(19,4)Notnull默認(rèn)100折數(shù)priceNumber(19,4)Notnull單價(jià)moneyNumber(19,4)Notnull金額cessNumber(19,4)Notnull默認(rèn)17稅率taxmoneyNumber

45、(19,4)Notnull稅額intaxmoneynumber(19,4)Notnull含稅金額presentvarchar2(4)Null是和否贈(zèng)品factCostnumber(19,4)Null實(shí)質(zhì)成本criterionCostnumber(19,4)Null標(biāo)準(zhǔn)成本enablesnumber默認(rèn)1不刪表記能否刪除除，0：刪除safetyonevarchar2(50)Null保存字段safetytwovarchar2(50)Null保存字段【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】5.3、銷售訂單主表(設(shè)計(jì)人：XXX)字段名種類空否主鍵外鍵默認(rèn)值中文說明billIdva

46、rchar2(20)NotnullY票據(jù)號(hào)碼billDateDateNotnull票據(jù)日期sinIdnumber(9)Notnull票據(jù)種類singleType(sinId)sinNameVarchar(50)null票據(jù)名稱cliidVarchar2(50)Notnull客戶編號(hào)client(cliid)clishortnameVarchar2(50)Notnull客戶簡(jiǎn)稱cliplaceidVarchar2(50)Null地點(diǎn)編號(hào)CliplaceVarchar2(50)Null地點(diǎn)orderStatusnumber(2)NotNull1未了案，2訂單情況已了案、3無效currencyTyp

47、eVarchar2(50)Notnull幣別priceWhetherTaxvarchar2(20)Notnull單價(jià)能否含稅empidVarchar2(50)Notnull業(yè)務(wù)人員編號(hào)，也就是人員編號(hào)employee(empid)empNameVarchar2(50)Notnull業(yè)務(wù)人員depidVarchar2(50)Notnull部門編號(hào)depttab(depid)depNameVarchar2(50)Notnull所屬部門makeEmpNameVarchar2(50)Notnull制單人員AuditingEmpNameVarchar2(50)null復(fù)核人員checkstateNumb

48、er(9)Notnull默認(rèn)0未審審查狀態(tài)核，1：審查remarkvarchar2(2000)Null備注totalMoneyNumber(19,4)Null共計(jì)金額totalTaxNumber(19,4)Null共計(jì)稅額totalTaxMoneyNumber(19,4)Null共計(jì)含稅金額enablesnumber默認(rèn)1不刪表記能否刪除除，0：刪除safetyonevarchar2(50)Null保存字段safetytwovarchar2(50)Null保存字段【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】5.4、銷售訂單明細(xì)表(設(shè)計(jì)人:XXX)字段名種類空否主鍵外鍵默認(rèn)值中

49、文說明billIdvarchar2(20)NotnullYY票據(jù)號(hào)碼sellOrder(billId)coteMarkNumber(9)NotnullY欄號(hào)matidVarchar2(50)Notnull物料編號(hào)Materiel(matid)matnamevarchar2(50)Notnull物料名稱matspecvarchar2(50)null規(guī)格型號(hào)matunitvarchar2(50)Notnull單位名稱numbernumber(9)Notnull數(shù)目agioAgoPricenumber(19,4)Notnull折扣前單價(jià)agioNumber(19,4)Notnull默認(rèn)100折數(shù)pr

50、iceNumber(19,4)Notnull單價(jià)moneyNumber(19,4)Notnull金額cessNumber(19,4)Notnull默認(rèn)17稅率taxmoneyNumber(19,4)Notnull稅額intaxmoneynumber(19,4)Notnull含稅金額presentvarchar2(4)Null是和否贈(zèng)品factCostnumber(19,4)Null實(shí)質(zhì)成本criterionCostnumber(19,4)Null標(biāo)準(zhǔn)成本outStoreroomDateNotnull預(yù)出庫(kù)日notOutNumbernumber(19,4)Notnull未出數(shù)目sinNameVa

51、rchar(50)Null根源單別originBillIdvarchar2(20)根源單號(hào)enablesnumber默認(rèn)1不刪表記能否刪除除，0：刪除safetyonevarchar2(50)Null保存字段safetytwovarchar2(50)Null保存字段【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】5.5、銷售出庫(kù)主表(設(shè)計(jì)人：XXX)字段名種類空否主鍵外鍵默認(rèn)值中文說明billIdvarchar2(20)NotnullY票據(jù)號(hào)碼billDateDateNotnull票據(jù)日期sinIdnumber(9)Notnull票據(jù)種類singleType(sinId)Sinn

52、ameVarchar(50)null票據(jù)名稱cliidVarchar2(50)Notnull客戶編號(hào)client(cliid)clishortnameVarchar2(50)Notnull客戶簡(jiǎn)稱cliplaceidVarchar2(50)Null地點(diǎn)編號(hào)CliplaceVarchar2(50)Null地點(diǎn)effectdateDateNull有效日期currencyTypeVarchar2(50)Notnull幣別priceWhetherTaxvarchar2(20)Notnull單價(jià)能否含稅stoidVarchar2(50)Notnull庫(kù)房編號(hào)stonamevarchar2(50)Notn

53、ull庫(kù)房名稱empidVarchar2(50)Notnull業(yè)務(wù)人員編號(hào)，也就是人員編號(hào)employee(empid)empNameVarchar2(50)Notnull業(yè)務(wù)人員depidVarchar2(50)Notnull部門編號(hào)depttab(depid)depNameVarchar2(50)Notnull所屬部門makeEmpNameVarchar2(50)Notnull制單人員AuditingEmpNameVarchar2(50)null復(fù)核人員checkstateNumber(9)Notnull默認(rèn)0未審審查狀態(tài)核，1：審查remarkvarchar2(2000)Null備注to

54、talMoneyNumber(19,4)Null共計(jì)金額totalTaxNumber(19,4)Null共計(jì)稅額totalTaxMoneyNumber(19,4)Null共計(jì)含稅金額enablesnumber默認(rèn)1不刪表記能否刪除除，0：刪除safetyonevarchar2(50)Null保存字段safetytwovarchar2(50)Null保存字段【表說明】銷售報(bào)價(jià)主表【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】Safetyone與safetytwo是一個(gè)保存字段Enable是一個(gè)表記能否刪除，默認(rèn)1不刪除，0：刪除5.6、銷售出庫(kù)明細(xì)表(設(shè)計(jì)人：XXX)字段名種類空否主鍵外鍵

55、默認(rèn)值中文說明billIdvarchar2(20)NotnullYY票據(jù)號(hào)碼sellissueorder(billId)coteMarkNumber(9)NotnullY欄號(hào)matidVarchar2(50)Notnull物料編號(hào)Materiel(matid)matnamevarchar2(50)Notnull物料名稱matspecvarchar2(50)null規(guī)格型號(hào)matunitvarchar2(50)Notnull單位名稱numbernumber(9)Notnull數(shù)目agioAgoPricenumber(19,4)Notnull折扣前單價(jià)agioNumber(19,4)Notnull

56、默認(rèn)100折數(shù)priceNumber(19,4)Notnull單價(jià)moneyNumber(19,4)Notnull金額cessNumber(19,4)Notnull默認(rèn)17稅率taxmoneyNumber(19,4)Notnull稅額intaxmoneynumber(19,4)Notnull含稅金額presentvarchar2(4)Null是和否贈(zèng)品factCostnumber(19,4)Null實(shí)質(zhì)成本criterionCostnumber(19,4)Null標(biāo)準(zhǔn)成本sinNameVarchar(50)Null根源單別originBillIdvarchar2(20)根源單號(hào)enablesn

57、umber默認(rèn)1不刪表記能否刪除除，0：刪除safetyonevarchar2(50)Null保存字段safetytwovarchar2(50)Null保存字段【表說明】【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】5.7、銷售退貨主表(設(shè)計(jì)人：XXX)字段名種類空否主外鍵默認(rèn)值中文說明鍵billIdvarchar2(20)NotnullY票據(jù)號(hào)碼billDateDateNotnull票據(jù)日期sinIdnumber(9)NotnullY票據(jù)種類singleType(sinId)cliidVarchar2(50)Notnull客戶編號(hào)client(cliid)clishortnameVar

58、char2(50)Notnull客戶簡(jiǎn)稱cliplaceidVarchar2(50)Null地點(diǎn)編號(hào)CliplaceVarchar2(50)Null地點(diǎn)effectdateDateNull有效日期currencyTypeVarchar2(50)Notnull幣別priceWhetherTaxvarchar2(20)Notnull單價(jià)能否含稅stoidVarchar2(50)Notnull庫(kù)房編號(hào)stonamevarchar2(50)Notnull庫(kù)房名稱whetheranewenterstoragenumber(2)Notnull是和否能否從頭入庫(kù)empidVarchar2(50)Notnul

59、l業(yè)務(wù)人員編號(hào)，也就是人員編號(hào)employee(empid)empNameVarchar2(50)Notnull業(yè)務(wù)人員depidVarchar2(50)Notnull部門編號(hào)depttab(depid)depNameVarchar2(50)Notnull所屬部門makeEmpNameVarchar2(50)Notnull制單人員AuditingEmpNameVarchar2(50)null復(fù)核人員checkstateNumber(9)Notnull默認(rèn)0未審審查狀態(tài)核，1：審查EnableNumber(9)Notnull默認(rèn)1不刪表記能否刪除除，0：刪除remarkvarchar2(2000

60、)Null備注totalMoneyNumber(19,4)Null共計(jì)金額totalTaxNumber(19,4)Null共計(jì)稅額totalTaxMoneyNumber(19,4)Null共計(jì)含稅金額enablesnumber默認(rèn)1不刪表記能否刪除除，0：刪除safetyonevarchar2(50)Null保存字段safetytwovarchar2(50)Null保存字段【表說明】銷售退貨主表【主鍵說明】【外鍵說明】【索引說明】【字段增補(bǔ)說明】Safetyone與safetytwo是一個(gè)保存字段Enable是一個(gè)表記能否刪除，默認(rèn)1不刪除，0：刪除5.8、銷售退貨明細(xì)表(設(shè)計(jì)人：XXX)字段