ERP系統(tǒng)詳細(xì)設(shè)計(jì)說明書

1、 .1.3.3表結(jié)構(gòu)描述基礎(chǔ)管理中用表（12張）a_assistantMaterial(輔助材料庫)字段名數(shù)據(jù)類型長(zhǎng)度備注Aidint4編號(hào)ANamevarchar50材料名稱Typevarchar50型號(hào)Specvarchar50規(guī)格Unitvarchar50單位Pricedecimal17單價(jià)EarlierAmountvarchar50期初數(shù)量Memovarchar50備注MinimumStockvarchar50最低庫存Amountdecimal9數(shù)量AddDatedatetime8入庫日期IsDelint4是否刪除過JHBianHaovarchar50進(jìn)貨編號(hào)a_baseMateria

2、l（原材料庫）字段名數(shù)據(jù)類型長(zhǎng)度備注Bidint4IDMaterialNamevarchar50材料名稱MaterialQualityvarchar50材質(zhì)Specvarchar50規(guī)格Unitvarchar50單位Pricedecimal17單價(jià)EarlierAmountvarchar50期初數(shù)量Memovarchar50備注MinimumStockvarchar50最低庫存Amountdecimal9數(shù)量AddDatedatetime8入庫時(shí)間定額基本信息字段名數(shù)據(jù)類型長(zhǎng)度備注編號(hào)int4編號(hào)工序序號(hào)varchar50工序序號(hào)班產(chǎn)定額varchar50班產(chǎn)定額材料規(guī)格varchar50材料

3、規(guī)格板材定額varchar50板材定額料片定額varchar50料片定額單件人工定額decimal5單件人工定額承制部門varchar50承制部門備注varchar50備注a_enterprise（部門）字段名數(shù)據(jù)類型長(zhǎng)度備注Codevarchar64編號(hào)Enablebit1Namevarchar64部門名稱Sortint4部門級(jí)別Principalvarchar256部門領(lǐng)導(dǎo)Contactvarchar256聯(lián)系電話Remarkvarchar256備注DateTimedatetime8OrderIDint4afrockSparePartStoreRoom（工裝備件庫）字段名數(shù)據(jù)類型長(zhǎng)度備注F

4、idint4IDMaterialNamevarchar50材料名稱MaterialQualityvarchar50材質(zhì)Specvarchar50規(guī)格Unitvarchar50單位Pricedecimal17價(jià)格EarlierAmountvarchar50期初數(shù)量Memovarchar50備注MinimumStockvarchar50最低庫存Amountdecimal9數(shù)量AddDatedatetime8入庫時(shí)間isdelint4是否刪除工序基礎(chǔ)字段名數(shù)據(jù)類型長(zhǎng)度備注序號(hào)varchar50序號(hào)廠家名稱varchar50廠家名稱零件名稱varchar50零件名稱零件總承號(hào)varchar50零件總承

5、號(hào)零件號(hào)varchar50零件號(hào)工序名稱varchar50工序名稱a_halfProductStoreRoom（半成品）字段名數(shù)據(jù)類型長(zhǎng)度備注Hidint4IDManufactoryvarchar50廠家名稱PartNamevarchar50零件名稱PartNumbervarchar20零件號(hào)CostPricedecimal13成本價(jià)格SellPricedecimal13銷售價(jià)格MaterialSpecvarchar50材料規(guī)格BoardRationvarchar50材料定額PartRationvarchar50料片定額EarlierAmountvarchar50期初數(shù)量MaterialNam

6、evarchar50材質(zhì)AddDatedatetime8入庫時(shí)間EarlierMoneydecimal13初期金額MinimumStockint4最低庫存Amountdecimal9數(shù)量PartTotalNumbervarchar100總承號(hào)afProductStoreRoom（成品）字段名數(shù)據(jù)類型長(zhǎng)度備注Pidint4IDManufactoryvarchar50廠家名稱PartNamevarchar50零件名稱PartNumbervarchar20零件號(hào)CostPricedecimal13成本價(jià)格SellPricedecimal13銷售價(jià)格EarlierAmountvarchar50期初數(shù)量

7、MaterialNamevarchar50材料名稱AddDatedatetime8入庫時(shí)間EarlierMoneydecimal13初期金額MinimumStockint4最低庫存Amountdecimal9數(shù)量a_StandardStoreRoom（標(biāo)準(zhǔn)件）字段名數(shù)據(jù)類型長(zhǎng)度備注Sidint4IDSNamevarchar50材料名稱Typevarchar50型號(hào)Specvarchar50規(guī)格Unitvarchar50單位Pricedecimal17單價(jià)EarlierAmountvarchar50期初數(shù)量Memovarchar50備注MinimumStockvarchar50最低庫存Amoun

8、tdecimal9數(shù)量AddDatedatetime8入庫時(shí)間JHBianHaovarchar50進(jìn)貨編號(hào)a_ToolStoreRoom（工具庫）字段名數(shù)據(jù)類型長(zhǎng)度備注Tidint4IDTNamevarchar50材料名稱Typevarchar50型號(hào)Specvarchar50規(guī)格Unitvarchar50單位Pricedecimal17單價(jià)EarlierAmountvarchar50期初數(shù)量Memovarchar50備注MinimumStockvarchar50最低庫存Amountdecimal9數(shù)量AddDatedatetime8入庫時(shí)間a_client（客戶表）字段名數(shù)據(jù)類型長(zhǎng)度備注Co

9、devarchar64編號(hào)ClientNamevarchar64客戶名稱Contactvarchar64聯(lián)系人Telvarchar64電話Faxvarchar64傳真Phonevarchar64手機(jī)Emailvarchar64E-mailAddressvarchar64地址Cityvarchar64城市PrinCipalvarchar64領(lǐng)導(dǎo)Bankvarchar64銀行BankIDvarchar64銀行帳號(hào)Remarktext16備注Imageimage16圖片h_employee（人事表）字段名數(shù)據(jù)類型長(zhǎng)度備注IDbigint8自增為主鍵Numbervarchar64人員編號(hào)Namevar

10、char64姓名Birthdatetime8生日Polityvarchar64政治面貌Sexvarchar64性別Culturevarchar64文化程度Nationvarchar64民族Contactvarchar64聯(lián)系電話Addressvarchar256地址Remarktext16備注Photoimage16照片DateTimedatetime8入職時(shí)間Codevarchar50部門編碼BasePaydecimal9基本工資EaryPunishdecimal9早退處罰LatePunihdecimal9遲到處罰specialityvarchar64特長(zhǎng)graduateTimedateti

11、me8畢業(yè)時(shí)間Schoolvarchar64畢業(yè)學(xué)校EnglishStupvarchar64英語水平Emailvarchar64E-mailPersonPagevarchar64個(gè)人主頁HurryContactvarchar64緊急聯(lián)系人HurryTelvarchar64緊急電話CardNubervarchar64卡號(hào)FileNamevarchar64文件名ComputerLevelvarchar50計(jì)算機(jī)水平BaoXianNamevarchar200保險(xiǎn)人姓名BXBeginTimedatetime8保險(xiǎn)開始時(shí)間BXEndTimedatetime8保險(xiǎn)結(jié)束時(shí)間BaoDanNOvarchar50

12、保單編號(hào)ZaiZhivarchar50是否在職生產(chǎn)管理中的用表（18張）OrderForm（訂單）字段名數(shù)據(jù)類型長(zhǎng)度備注Oidint4IDManufacturervarchar40廠家PartNumbervarchar20零件號(hào)PartNamevarchar30零件名稱Amountint4數(shù)量DemandDatedatetime8要貨日期Odatedatetime8訂單日期OrderTypevarchar30訂單類型OrderNumbervarchar50訂單號(hào)RequestConfirmvarchar50審核確認(rèn)StuffRequestBill（材料請(qǐng)領(lǐng)單）字段名數(shù)據(jù)類型長(zhǎng)度備注Sidint

13、4IDStuffRequestUnitvarchar50請(qǐng)領(lǐng)單位ProduceNumbervarchar30零件號(hào)ProduceNamevarchar30零件名稱Amountdecimal5數(shù)量MaterialNamevarchar40材料名稱Specvarchar40規(guī)格Sdatedatetime8請(qǐng)領(lǐng)日期RequestConfirmvarchar10請(qǐng)領(lǐng)確認(rèn)ConfirmDatedatetime8確認(rèn)日期DepotTypeint4型號(hào)SequenceCard（轉(zhuǎn)序卡）字段名數(shù)據(jù)類型長(zhǎng)度備注Sidint4IDMaunfacturervarchar50廠家名稱PartNumbervarchar

14、50總承號(hào)PartNamevarchar50零件名稱PutAmountint4數(shù)量PutDatedatetime8投放日期ProductlnCountint4成品入庫數(shù)量FeiPinCountint4廢品數(shù)量SaveCountint4剩余數(shù)量IsTruevarchar2生產(chǎn)計(jì)劃信息字段名數(shù)據(jù)類型長(zhǎng)度備注序號(hào)int4序號(hào)廠家varchar50廠家零件名稱varchar50零件名稱零件總承號(hào)varchar50零件總承號(hào)零件號(hào)varchar50零件號(hào)月計(jì)劃數(shù)量int4月計(jì)劃數(shù)量日期datetime8日期是否已生成材需int4是否生成材料需求材料進(jìn)廠計(jì)劃字段名數(shù)據(jù)類型長(zhǎng)度備注序號(hào)varchar50序號(hào)

15、廠家varchar50廠家零件總承號(hào)varchar50零件總承號(hào)零件名稱varchar50零件名稱零件號(hào)varchar50零件號(hào)板材定額int4板材定額料片定額int4料片定額計(jì)劃需求數(shù)量int4計(jì)劃需求數(shù)量白班進(jìn)廠數(shù)量int4白班進(jìn)廠數(shù)量晚班進(jìn)廠數(shù)量int4晚班進(jìn)廠數(shù)量記錄日期datetime8記錄日期材料需求計(jì)劃字段名數(shù)據(jù)類型長(zhǎng)度備注序號(hào)int4序號(hào)廠家varchar50廠家零件總承號(hào)varchar50零件總承號(hào)零件名稱varchar50零件名稱零件號(hào)varchar50零件號(hào)板材定額int4板材定額料片定額int4料片定額月計(jì)劃數(shù)量int4月計(jì)劃數(shù)量預(yù)算需求數(shù)量int4預(yù)算需求數(shù)量生產(chǎn)計(jì)劃

16、序號(hào)int4生產(chǎn)計(jì)劃序號(hào)日期datetime8日期日排產(chǎn)計(jì)劃及完成情況匯總字段名數(shù)據(jù)類型長(zhǎng)度備注idint4id廠家varchar100廠家零件名稱varchar100零件名稱零件號(hào)varchar100零件號(hào)月計(jì)劃數(shù)量decimal5月計(jì)劃數(shù)量日計(jì)劃數(shù)量decimal5日計(jì)劃數(shù)量一班decimal5一班二班decimal5二班三班decimal5三班剩余decimal5剩余日期datetime8日期ProductDiscardBill（廢品單）字段名數(shù)據(jù)類型長(zhǎng)度備注Didint4IDManufactoryvarchar50廠家PartNamevarchar50零件名稱PartNumbervar

17、char20零件號(hào)DiscardDeptvarchar50報(bào)廢部門Amountint4數(shù)量DiscardReasonvarchar50報(bào)廢原因AutoNumbervarchar50自動(dòng)編號(hào)Examinevarchar20審核Ddatedatetime8當(dāng)前日期DepotTypeint4庫類型Pricedecimal9單價(jià)Employeevarchar50報(bào)廢人員HeXiao（核銷）字段名數(shù)據(jù)類型長(zhǎng)度備注Didint4IDNamevarchar50名稱Typevarchar50類型Specvarchar20規(guī)格DiscardDeptvarchar50報(bào)廢部門Amountint4數(shù)量Discard

18、Reasonvarchar50核銷原因AutoNumbervarchar50自動(dòng)編號(hào)Examinevarchar20審核Ddatedatetime8核銷日期DepotTypeint4庫類型Pricedecimal9單價(jià)Employeevarchar50報(bào)廢人員ReversionProductln（返修品入庫）字段名數(shù)據(jù)類型長(zhǎng)度備注Ridint4IDManufacturervarchar40廠家PartNumbervarchar20零件號(hào)PartNamevarchar30零件名稱Amountint4數(shù)量Odatedatetime8入庫日期Deptvarchar30部門Memovarchar50備

19、注Depotlnvarchar50入庫單號(hào)DepotTypeint4庫類型BaoFeiCountint4報(bào)廢數(shù)量OutDanhaovarchar50出庫單號(hào)ReversionProductOut（返修品出庫）字段名數(shù)據(jù)類型長(zhǎng)度備注Ridint4IDManufacturervarchar40廠家PartNumbervarchar20零件號(hào)PartNamevarchar30零件名稱Amountint4數(shù)量Odatedatetime8出庫日期Deptvarchar30部門Memovarchar50備注DepotOutvarchar50出庫單號(hào)DepotTypeint4庫類型采購申請(qǐng)單字段名數(shù)據(jù)類型長(zhǎng)

20、度備注日期datetime8日期序號(hào)varchar50序號(hào)名稱varchar50名稱用途varchar50用途規(guī)格型號(hào)varchar50規(guī)格型號(hào)單位varchar50單位數(shù)量int4數(shù)量申請(qǐng)部門varchar50申請(qǐng)部門申請(qǐng)人varchar50申請(qǐng)人是否審批varchar50是否審批采購計(jì)劃信息字段名數(shù)據(jù)類型長(zhǎng)度備注序號(hào)varchar50序號(hào)材料名稱varchar50材料名稱材質(zhì)或型號(hào)varchar50材質(zhì)或型號(hào)規(guī)格varchar50規(guī)格型號(hào)varchar50型號(hào)單位varchar50單位生產(chǎn)需求數(shù)量int4生產(chǎn)需求數(shù)量數(shù)量int4數(shù)量最低庫存int4最低庫存當(dāng)前庫存int4當(dāng)前庫存制定日期d

21、ateTime制定日期完成日期dateTime完成日期DepotOut（產(chǎn)成品出庫）字段名數(shù)據(jù)類型長(zhǎng)度備注Didint4IDOutOddNumbervarchar30出庫單號(hào)ClientNamevarchar50客戶名稱Ddatedatetime8當(dāng)前日期PartNamevarchar50零件名稱PartNumbervarchar30零件號(hào)Amountint4數(shù)量PABill（PA收發(fā)清單）字段名數(shù)據(jù)類型長(zhǎng)度備注Pidint4IDPDatedatetime8當(dāng)前日期Purchaservarchar50客戶PartNumbervarchar30零件號(hào)PartNamevarchar50零件名稱Am

22、ountint4數(shù)量PABillNumbervarchar30編號(hào)PurchaserNamevarchar30結(jié)算員SellMoneydecimal13銷售金額ShenHebit1審核外委加工信息字段名數(shù)據(jù)類型長(zhǎng)度備注序號(hào)varchar50序號(hào)產(chǎn)品名稱varchar50產(chǎn)品名稱產(chǎn)品代號(hào)varchar50產(chǎn)品代號(hào)加工內(nèi)容varchar50加工內(nèi)容加工數(shù)量int4加工數(shù)量加工單價(jià)decimal9加工單價(jià)加工金額decimal9加工金額日期datetime8日期外委返回信息字段名數(shù)據(jù)類型長(zhǎng)度備注返回序號(hào)varchar50返回序號(hào)序號(hào)varchar50序號(hào)返回?cái)?shù)量varchar50返回?cái)?shù)量返回日期da

23、tetime8返回日期是否審核varchar50是否審核Depotln（生產(chǎn)過程中的產(chǎn)成品入庫）字段名數(shù)據(jù)類型長(zhǎng)度備注Didint4IDOutOddNumbervarchar30入庫單號(hào)ClientNamevarchar50客戶名稱Ddatedatetime8入庫日期PartNamevarchar50零件名稱PartNumbervarchar30零件號(hào)Amountint4數(shù)量銷售出庫中的用表（4張）DepotOut（產(chǎn)成品出庫）字段名數(shù)據(jù)類型長(zhǎng)度備注Didint4IDOutOddNumbervarchar30出庫單號(hào)ClientNamevarchar50客戶名稱Ddatedatetime8當(dāng)前日期PartNamevarchar50零件名稱PartNumbervarchar30零件號(hào)Amountint4數(shù)量PABill（PA收發(fā)清單）字段名數(shù)據(jù)類型長(zhǎng)度備注Pidint4IDPDatedat