中英文翻譯基于微軟的Access數(shù)據(jù)庫(kù)ERPMRP

1、基于微軟的Access數(shù)據(jù)庫(kù)ERP/MRP PEDYN是一家專門針對(duì)開發(fā)小企業(yè)的生產(chǎn)操作系統(tǒng)、工程管理和文件控制軟件的公司?？v觀公司的P2000企業(yè)資源方案ERP/MRP工程，采用微軟Access數(shù)據(jù)庫(kù)平臺(tái)所設(shè)計(jì)開發(fā)。P2000系統(tǒng)是一款能完全解決你業(yè)務(wù)上所有問題的低本錢軟件，從設(shè)計(jì)觀念，到方案管理和對(duì)購(gòu)置,物料控制，生產(chǎn)和訂購(gòu)的文件控制。它采用圖解式設(shè)計(jì)，而且設(shè)計(jì)了向?qū)?，使P2000易學(xué)易用。而且因?yàn)樗捎梦④浀腁ccess數(shù)據(jù)庫(kù)開發(fā)，所以能與其他產(chǎn)品很好的兼容，并能很容易地根據(jù)客戶的需要，做二次開發(fā)。這個(gè)軟件還能根據(jù)所需的模塊和貴公司的其他ERP/MRP軟件同時(shí)使用。P2000是可擴(kuò)展的,

2、有柔性的，而且為中小型的工程或制造公司提供了是近乎完美的低費(fèi)用解決方案。那為什么還要把資金投入到那些昂貴而復(fù)雜卻并不適合公司的特殊要求的東西上去呢？由于使用了微軟的Access作為前置操作系統(tǒng)，這意味著你能擁有完整的控制性和靈活性。在你需要的時(shí)候，能生成新的報(bào)表，無論你選擇哪一個(gè)操作系統(tǒng)都能得到擴(kuò)展。ERP軟件的種類和特征1. 制造和操作模塊：制造軟件、生產(chǎn)方案、操作軟件、操作方案、制造解決方案、產(chǎn)品管理方案、產(chǎn)品控制管理、離散制造、產(chǎn)品方案、制造資源方案、物料需求方案MRP、制造資源方案MRPII、企業(yè)資源規(guī)劃ERP、企業(yè)資源規(guī)劃軟件、MIS、庫(kù)存補(bǔ)給系統(tǒng)、產(chǎn)品工作流程管理、產(chǎn)品管理、供給鏈

3、管理、SCM、材料管理、業(yè)務(wù)管理、企業(yè)的方案與調(diào)度、多用戶制造控制軟件、物料清單管理、物料清單控制、產(chǎn)品管理、庫(kù)存控制軟件、小企業(yè)解決方案、小企業(yè)MRP 、小企業(yè)ERP。:工程管理軟件、工程軟件、工程方案、工程工程管理、軟件方案，設(shè)計(jì)管理軟件、工程師任務(wù)管理、工程任務(wù)管理、每日任務(wù)管理、工作、工程變更通知、工程變更請(qǐng)求、工程變更順序、工程變更命令、 ECN 、 ECO 、 DCO 、 DCN 、 ECR、 DCR、工程操作、工程工程方案和日程安排、在線任務(wù)管理。:文件控制軟件、文件控制管理、發(fā)票簽發(fā)控制、結(jié)構(gòu)控制管理、結(jié)構(gòu)管理軟件,結(jié)構(gòu)控制軟件、匯票管理,文件變更順序、變更命令 、BOM 軟件

4、、物料清單BOM、多層次訂貨、參考指示、制圖任務(wù)管理、制圖人員、CAD 、AUTOCAD ，結(jié)構(gòu)管理、電子文檔管理、企業(yè)文件管理系統(tǒng)、規(guī)格管理、提貨控制，修正控制、工作流程系統(tǒng)、規(guī)格控制圖，資源控制圖、SCD ，制造生產(chǎn)圖畫，集成圖、在線信號(hào)開關(guān)表、工程變更命令、ECN 、ECO 、DCO、DCN 、ECR 、DCR 、BOM 、PDM 產(chǎn)品數(shù)據(jù)管理，PDM 軟件、PDM Access數(shù)據(jù)庫(kù)。:制造命令 、 集合命令 、 建立命令 、 配置命令、網(wǎng)狀自動(dòng)化制造、預(yù)測(cè)、標(biāo)準(zhǔn)的本錢計(jì)算、物料接收，裝載運(yùn)送，資源，主要的日程安排，生產(chǎn)能力、 車間裝載和能力方案、業(yè)務(wù)流程、工作車間、工序路線安排、電子

5、命令流程、要求命令、行程安排，廢料，生產(chǎn)本錢、勞動(dòng)力、 WIP 、完成的貨物、庫(kù)存控制、物料清單控制、標(biāo)準(zhǔn)本錢，標(biāo)準(zhǔn)本錢的計(jì)算、平均本錢的計(jì)算、平均費(fèi)用、預(yù)測(cè)、傳輸、精選目錄、廠商目錄、成份、匯總、材料方案、需求方案，預(yù)測(cè)、銷售方案、分配方案、制造方案、工作順序管理、客戶順序管理、命令輸入、定價(jià)，裝運(yùn)、載入廠房、 工藝路線安排、工程主管、零件清單、零件說明書、 采購(gòu)單 、購(gòu)置命令、PO、采購(gòu)、工作指令、銷售順序 , 命令輸入、客戶需求流程、入庫(kù)單,退貨單、裝載運(yùn)送、零件裝配、總裝，產(chǎn)品本錢計(jì)算、主要產(chǎn)品安排、 碼頭庫(kù)存、驗(yàn)貨、測(cè)試、參照ISO 9000、參照ISO 9001 、財(cái)政和會(huì)計(jì)接口、

6、可付帳目、帳戶應(yīng)收帳款、主要分類帳、開發(fā)票、本錢管理、 財(cái)政控制、現(xiàn)金流動(dòng)預(yù)測(cè)、財(cái)政預(yù)測(cè)、方案系統(tǒng)、發(fā)票、追蹤、分析、人力資源、薪資帳冊(cè)、人事管理。:MS Access 數(shù)據(jù)庫(kù)平臺(tái)、 Microsoft Access數(shù)據(jù)庫(kù)、 MS Access97、 MS Access2000、 WindowsXP( 2002 2003)、 MS Access Forms、Microsoft Windows 98、 Microsoft Windows 2000, Microsoft NT、 Microsoft XP、 Excel、 SQL、MySQL、 ACCESS 、EDYNE、 PEDYNAMICS, P

7、2000, Software, Program, Custom, Customized, Access Programming, Custom Database, Low Cost, LOW COST, Free Demo, Free Trial 等等。:PDM產(chǎn)品數(shù)據(jù)管理, 重復(fù)產(chǎn)品經(jīng)營(yíng)、 商業(yè)方案、出售和操作方案、 發(fā)布需求方案、 能力需求方案、 CRP、 業(yè)務(wù)管理、 產(chǎn)品數(shù)據(jù)管理、 信息管理系統(tǒng)、 倉(cāng)庫(kù)、 配送中心操作、 倉(cāng)庫(kù)經(jīng)營(yíng)系統(tǒng)、WMS、 電子的數(shù)據(jù)交換、 EDI、 客戶關(guān)系管理、 CRM、 公司解答、QRM、 快速反響生產(chǎn)、補(bǔ)給鏈方案、供給商管理、存貨清單、 VMI、位置定位方案

8、、資源配送方案、 DRP、 資源監(jiān)測(cè)、 行政管理、 JIT、需求方案、 需求鏈、商業(yè)智囊、智能企業(yè)、流程技術(shù)、 商業(yè)解答、 敏捷電子商務(wù)、 QuickBooks、 PeachTree、 質(zhì)量管理。物質(zhì)的需求方案概論物質(zhì)的需求方案 (MRP)是為協(xié)助制造商管理存貨清單和產(chǎn)品而設(shè)計(jì)的。使用MRP能保證原材料得到充分的使用，生產(chǎn)時(shí)間也更為適當(dāng)，而不會(huì)因?yàn)樵牧系截浱缍^度地消耗掉。MRP能夠配合預(yù)期需求和補(bǔ)給生成如果需要的話或修正產(chǎn)品方案，以保證及時(shí)地消耗掉原材料和全部的零部件。MRP為每一個(gè)終端產(chǎn)品或零部件從頭到尾地編制物料清單BOM，這些清單是生產(chǎn)終端產(chǎn)品或零件所需要的。從理論上講，這些物料的

9、編制要繼續(xù)循環(huán)，例舉出每一個(gè)所需零部件的子部件，一直到新的原材料物料清單的出現(xiàn)。在實(shí)踐中，某一個(gè)制造商可能會(huì)比擬喜歡去擴(kuò)展一個(gè)專門例舉的，并且是假設(shè)建立在零件或原材料同一水平需求上的那種物料清單。其次，MRP需要與每一個(gè)制造或裝配生產(chǎn)過程有關(guān)的引導(dǎo)時(shí)間信息，以生產(chǎn)出需要的零件或終端產(chǎn)品。引導(dǎo)時(shí)間是將零件制造或裝配成為終端產(chǎn)品或更高一級(jí)的零件所需要的時(shí)間，并且包含全部所需要的已有零件的生產(chǎn)和裝配的時(shí)間。這些引導(dǎo)時(shí)間可能將根據(jù)每個(gè)單位的零件/產(chǎn)品或預(yù)期要生產(chǎn)的一批零件的尺寸進(jìn)行編碼。MRP結(jié)合物料清單、引導(dǎo)時(shí)間和對(duì)所需終端產(chǎn)品的預(yù)計(jì)，生成一個(gè)主產(chǎn)品方案表，這個(gè)方案表是一個(gè)生產(chǎn)和裝配的詳細(xì)安排，能讓

10、生產(chǎn)商到達(dá)預(yù)期的產(chǎn)量。這個(gè)時(shí)間表只表示出裝配或生產(chǎn)的最終水平即產(chǎn)生終端產(chǎn)品，并且包括了產(chǎn)品的用時(shí)和產(chǎn)量。主產(chǎn)品方案表為MRP更高一級(jí)的信息提供源信息。采用主產(chǎn)品方案表就如同有了一個(gè)起點(diǎn)，這在概念上是個(gè)很簡(jiǎn)單的事但對(duì)計(jì)算機(jī)語(yǔ)言的要求很高，結(jié)合引導(dǎo)時(shí)間的數(shù)據(jù)和物料清單去推動(dòng)零件也可能是原材料需求的時(shí)間方案，盡管有多種裝配和生產(chǎn)方式供制造商選擇。這個(gè)時(shí)間表這些工程：中間產(chǎn)品、當(dāng)前庫(kù)存、原材料和零件的待辦定單、零件的直接需求作為要解決的因子。使用了這個(gè)需求時(shí)間表，制造商肯定會(huì)決定出一個(gè)滿足這些需求的原料補(bǔ)給解決方案。廣泛而多樣的排序規(guī)那么和直觀推斷法要合并到基于計(jì)算機(jī)的MRP模塊中。除了物料需求，其他

11、有用的數(shù)據(jù)也從主產(chǎn)品方案表中生成，這包括方案中每個(gè)終端產(chǎn)品的清單、方案中每個(gè)裝配和生產(chǎn)過程的時(shí)間表，還包括方案中對(duì)特殊產(chǎn)品能力的利用。這些數(shù)據(jù)信息都應(yīng)該能幫助我們估算出當(dāng)前或潛在的物料補(bǔ)給需求策略。計(jì)算機(jī)對(duì)MRP的真正實(shí)施有著很大幫助，因?yàn)榇罅繑?shù)據(jù)處理需要原始的物料需求數(shù)據(jù)。另外，整個(gè)分析有時(shí)可能必須在條件不斷變化之中重復(fù)很屢次比方，命令的變化，生產(chǎn)流程的變化，物料需求的變化等。這就需要條理清晰的電腦了。這里有個(gè)例子說明了在SAS/AF實(shí)際運(yùn)用中使用SAS/OR軟件尤其是PROC CPM和PROC GANTT平臺(tái)。假定一個(gè)服裝制造商采用了物料需求方案，只有少局部數(shù)據(jù)步和相關(guān)的簡(jiǎn)單流程來自SAS

12、/OR, Base SAS,和SAS/GRAPH所需的計(jì)算操作，來支持這個(gè)運(yùn)作。其實(shí)很少會(huì)用單一地假定去限制這個(gè)樣板運(yùn)作的范圍，在實(shí)際運(yùn)用中，是會(huì)放開手腳地把更為繁雜、更為實(shí)際的MRP設(shè)置運(yùn)用起來。這個(gè)運(yùn)用也可以在更加廣泛的生產(chǎn)和物料清單控制系統(tǒng)中去實(shí)現(xiàn)MRP模塊。MS Access MRP Manufacturing Resource PlanningSmall Business MRP - Small Business ERP Microsoft Access Database ERP MRP Program ERP / MRP Manufacturing S

13、oftware ProgramPEDYN specializes in Small Business Manufacturing Operations, Engineering Management, and Document Control Software. See the all in one P2000 Enterprise Resource Planning (ERP / MRP) program that uses Microsoft Access as the program platform. The P2000 is a powerful Low Cost solution

14、for your complete business operations, from design concept, project management and documentations control to purchasing, material control, manufacturing, and order entry. It's graphical design and drill down navigation make the P2000 very easy to learn and use. Since the program is completely wr

15、itten using Microsoft Access, it interfaces well with other products, and can be easily customized to fit your ever changing business requirements. The program can be used along with other ERP / MRP programs that your company may be using by activating only the modules that you require. The P2000 is

16、 expandable, flexible and provides the perfect low cost solutions for small to mid size engineering and manufacturing companies. Why spend a fortune on expensive complicated system programs that are not easily adaptable to your specific needs. Using Microsoft Access as a front-end operating sys

17、tem means that you have full control and flexibility. Create new forms and reports as you need them. Expand your operating system anyway you choose. ERP software Categories and Features 1.Manufacturing and Operations Modules:Manufacturing Software, Manufacturing Program, Operations Softwar

18、e, Operations Program, Manufacturing Solutions, Production Management Program, Production Control Management, Discrete Manufacturing, Production Planning, Material Requirement PlanningMRP， Manufacturing Resource Planning MRP II, Enterprise Resource Planning, ERP Software, MIS,  Stock Reple

19、nishment Systems, Production Workflow Management, Product Management, Supply Chain Management, SCM, Supply Management, Materials Management, Business Management, Planning and Scheduling Enterprise, Multi-User Manufacturing Control Software, Inventory Management, Inventory Control, Product Manag

20、ement, Stock Control software, Small Business Soluitions, Small Business MRP, Small Business ERP2.Engineering Modules:Engineering Management Software, Engineering Software, Engineering Program, Engineering Project Management Software Programs, Design Management Software Engineer Task Management, Eng

21、ineering Task Management, Daily Task Management, Tasking, Engineering Change Notice, Engineering Change Request, Engineering Change Order, Engineering Change Orders, ECN, ECO, DCO, DCN, ECR, DCR, Engineering Operations, Engineering Project Planning and Scheduling, Online Task Management3.Docume

22、ntation Modules:Documentation Control software, Document Control Management, Drawing Control, Configuration Control Management, Configuration Management Software, Configuration Control Software, Drafting Management, Document Change Order, Change Orders, BOM software,  Bill Of Materials, Indente

23、d Multi Level, Reference Designators, Drafting Task Management, Draftsman,CAD,  AUTOCAD, Configuration Management, Electronic Document Management, Enterprise Document Management Systems, Specification Management, Release Control, Revision Control, Workflow Systems, Specification Control Drawing

24、s, Source Control Drawings, SCD, Fabrication Drawing, Assembly Drawings,  Online Sign-off and Approval Forms, Engineering Change Orders, ECN, ECO, DCO, DCN, ECR, DCR, BOM, bom, PDM Product Data Management, PDM Software, PDM Access Database4.Processes:Make To Order, Assemble To Order, Build To O

25、rder, Configure To Order, Cellular Manufacturing, , Forecasting, Standard Costing, Material Receiving, Shipping, Resources, Master Scheduling, Production Capacity, Shop Loading and Capacity Planning, Business Processes,  Job Shop, Routing, Electronic Order Processing, Demand, Scheduling, Scrap,

26、 Product Cost, Labor, WIP, Finished Goods, Stock Control, Inventory Control, Standard Cost, Standard Costing, Average Costing, Average cost, Forecasting, Delivery, Pick List, Vendor List, Components, Sub Assemblies, Material Planning, Demand Planning, Forecasting, Sales Planning, Distribution Planni

27、ng, Production Planning, Work Order Management, Customer Order Management, Order Entry,  Pricing, Shipping, Load Building, Routing, Item Master, Parts List, Parts Book, Purchase Order, Purchase Orders, PO, Purchasing, Work Order, Sales Order, Order Entry, Customer Order Processing, Shop Or

28、der, Back Order, Shipping Order, Parts Allocation, Allocations, Product Costing, Master Production Scheduling,  Dock-to-Stock,  Inspection, Testing, ISO 9000 Compliant, ISO 9001 Compliance, Finance and Accounting Interface, Accounts Payable, Accounts Receivable, General Ledger, Invoicing,

29、Cost Management,  Financial Control, Cash Flow Forecasting, Financial Forecasting, Planning System, Invoice, Tracking, Time, Analysis, Human Resources, Payroll, Time, Personnel5.Platform:MS Access Database Platform, Microsoft Access Database, MS Access97, MS Access2000, MS Access 97, MS Access

30、2000, Access XP 2002 2003, MSAccess Forms, MSAccess Reports, Microsoft Windows 98, Microsoft Windows 2000, Microsoft NT, Microsoft XP, Excel, SQL, MySQL, ACCESS PEDYNE, PEDYNAMICS, P2000, Software, Program, Custom, Customized, Access Programming, Custom Database, Low Cost, LOW COST, Free Demo, Free

31、Trial6.Other:PDM Product Data Management, Repetitive Production Management, Business Planning, Sales and Operations Planning,  Distribution Requirements Planning, Capacity Requirements Planning, CRP, Process Management, Product Data Management,  Information Management Systems, Warehousing,

32、 Distribution Center Operations,  Warehouse Management Systems, WMS, Electronic Data Interchange, EDI, Customer Relationship Management, CRM, Company Solutions, QRM, Quick Response Manufacturing, Supply Chain Planning, Vendor Managed Inventory, VMI, Site Location Planning, Distribution Res

33、ource Planning, DRP,  Resource Monitoring,  Administrative Management, JIT, Demand Planning, Demand Chain, Business Intelligence, Intelligent Enterprise,  Flow Techniques, Business Solutions, Agile E-Business, QuickBooks, PeachTree, Quality ManagementMaterial Requirements Planning Ove

34、rviewMaterial Requirements Planning (MRP) is designed to assist manufacturers in inventory and production management. Using MRP helps ensure that materials will be available in sufficient quantity and at the proper time for production to occur, without incurring excess costs by having the materials

35、on hand too early. MRP assists in generating and (as needed) revising production plans to meet expected demands and replenishment plans to assure the timely availability of raw materials and all levels of product components.MRP begins by compiling a Bill of Materials (BOM) for each end product or co

36、mponent of interest. This is a listing of the components and quantities that are needed to manufacture the end product or component. Theoretically, the compilation of BOMs continues recursively, enumerating the subcomponents that are needed to manufacture each component, until only raw materials app

37、ear in the generated BOMs. In practice, a manufacturer may prefer to extend the BOM enumeration for only a specified number of levels and to assume that components and/or raw materials beneath that level are available on demand.Next, MRP requires information on the lead times associated with each ma

38、nufacturing or assembly procedure that is required to produce the components and end products. Lead time is the time required to assemble or manufacture the needed components into the end product (or higher-level component), and thus is the time elapsed between the point at which all needed componen

39、ts are present and the end of assembly or manufacturing. These lead times may be compiled per unit of each component/product or may be based on predetermined batch sizes.MRP combines the BOMs, the lead times, and estimates of demand for end products to generate the Master Production Schedule, which

40、details a schedule of assembly and production that enables the manufacturer to meet the estimated demand. This schedule addresses only the final level of assembly or production (resulting in end products), and includes both the timing and quantities of production. The Master Production Schedule serv

41、es as the basis for all further output information from MRP.Using the Master Production Schedule as a starting point, it is a conceptually simple (but computationally demanding) task to combine it with the data on lead times and BOMs to derive a schedule of component (and possibly raw materials) req

42、uirements, through as many levels of assembly and production as the manufacturer chooses. This schedule can account for such factors as work-in-progress, current inventory of and pending orders for materials and components, and direct demand for components as service items. Using this schedule of re

43、quirements, the manufacturer must determine a material replenishment strategy that satisfies these requirements. A wide variety of ordering rules and heuristics can be incorporated into computer-based MRP models.In addition to the material requirements, other useful data can be generated from the Master P