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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

15、廠家varchar50廠家零件總承號varchar50零件總承號零件名稱varchar50零件名稱零件號varchar50零件號板材定額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ù)類型長度備注序號int4序號廠家varchar50廠家零件總承號varchar50零件總承號零件名稱varchar50零件名稱零件號varchar50零件號板材定額int4板材定額料片定額int4料片定額月計(jì)劃數(shù)量int4月計(jì)劃數(shù)量預(yù)算需求數(shù)量int4預(yù)算需求數(shù)量生產(chǎn)計(jì)劃

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

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

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

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

20、度備注日期datetime8日期序號varchar50序號名稱varchar50名稱用途varchar50用途規(guī)格型號varchar50規(guī)格型號單位varchar50單位數(shù)量int4數(shù)量申請部門varchar50申請部門申請人varchar50申請人是否審批varchar50是否審批采購計(jì)劃信息字段名數(shù)據(jù)類型長度備注序號varchar50序號材料名稱varchar50材料名稱材質(zhì)或型號varchar50材質(zhì)或型號規(guī)格varchar50規(guī)格型號varchar50型號單位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ù)類型長度備注Didint4IDOutOddNumbervarchar30出庫單號ClientNamevarchar50客戶名稱Ddatedatetime8當(dāng)前日期PartNamevarchar50零件名稱PartNumbervarchar30零件號Amountint4數(shù)量PABill（PA收發(fā)清單）字段名數(shù)據(jù)類型長度備注Pidint4IDPDatedatetime8當(dāng)前日期Purchaservarchar50客戶PartNumbervarchar30零件號PartNamevarchar50零件名稱Am

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

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