Work anywhere from any device with Microsoft 365
Upgrade to Microsoft 365 to work anywhere with the latest features and updates.
Upgrade now
INTRODUCTION
This article lists the Manufacturing setup tables that you can copy from an existing company to a new company in Microsoft Dynamics GP.
More Information
Inventory item and related setup information
|
Table ID |
Table name |
|
BC010000 |
Buyer Codes |
|
COSS0401 |
pref_cost_sys |
|
CT00001 |
IC Cost Standard Company Default |
|
CT00002 |
IC Cost Standard Item Class Defaults |
|
CT00003 |
IC Cost Standard Items Defaults |
|
CT00102 |
IC Cost Item Master |
|
CT40401 |
IC Cost Item Class Setup |
|
ICIV0323 |
IC_IV_STANDARD |
|
IVR10015 |
Item Engineering |
|
IVR10100 |
Alternate Parts |
|
PC010000 |
MRP_Planner_Codes |
Bills of material
|
Table ID |
Table name |
|
BM010115 |
Bill of Materials Line |
|
BM010415 |
BOM Revision |
|
BM010116 |
BOM_Line_HIST |
|
BM010416 |
BOM_Revision_HIST |
|
BMPF0114 |
pref_bom_user |
|
BMPS0114 |
pref_bom_sys |
Routings
|
Table ID |
Table name |
|
RT010001 |
routing_mstr |
|
RT010130 |
routing_line |
|
RTPS0130 |
pref_router_sys |
|
RTPU0130 |
pref_router_user |
Facility setup information
Note Facility setup information includes calendars, work centers, machines, and labor codes.
|
Table ID |
Table name |
|
DD010000 |
Down Day |
|
CO010000 |
MFG_Company_ Info |
|
DD020000 |
Down on Weekends |
|
DD030000 |
Up_Days |
|
MM010032 |
Machine Master |
|
WC010015 |
Work Center Master |
|
WC010100 |
Work Center Employee Line Item |
|
WC010200 |
Work Center Machine Line |
|
WC010300 |
Work Center –Employee Absences |
|
WC010400 |
WC_Down_On_Weekends |
|
WC010500 |
WC_Down_Days |
|
WC010600 |
Work Center - Alternates |
|
WC010714 |
WC Operations Codes |
|
WC010800 |
WC Up Days |
|
WC019831 |
Work Center Header |
|
WCPF0100 |
pref_workcenter_user |
|
WCPS0100 |
pref_workcenter_sys |
|
LC010014 |
Labor Code Master |
|
PFH10000 |
pref_hdr |
Order processing setup information
|
Table ID |
Table name |
|
mops0100 |
pref_mop_sys |
|
MOPS0200 |
pref_mop_sched_sys |
|
SP010016 |
Scheduling Preference_MSTR |
|
SP010100 |
Scheduling_Preference_Line |
|
IS050000 |
Order Fulfillment Setup |
|
IS090000 |
Manufacturing Fulfillment Item Master |
|
ISSP0201 |
Manufacturing Series Sales Order Preferences |
|
SOPS113B |
pref_sop_sys |
|
WPPS0114 |
pref_wip_sys |
|
WPPU0114 |
pref_wip_user |
Material requirements planning setup information
|
Table ID |
Table name |
|
MPPS0130 |
MRP Setup |
|
MPPS0230 |
pref_mrp_sys |
|
MPPU0130 |
pref_mrp_user |
|
MRP0200 |
mrpScheduleHDR |
|
MRP0201 |
mrpScheduleDetail |
Engineering change management information
|
Table ID |
Table name |
|
ECPS0000 |
pref_ecm_sys |
|
ECPU0000 |
pref_ecm_user |
|
EC020230 |
ECM_Disposition |
|
EC030030 |
ECM_REJECT_CODE |
|
EC020030 |
ECM_Routing_HDR |
Job costing information
|
Table ID |
Table name |
|
ICJC0003 |
Job Categories |
|
ICJC0004 |
ICJC_Category |
|
ICJC0005 |
ICJC_Line_Categories |
|
ICJC0006 |
ICJC_Revenue_Expense_Code |
|
JCPS0040 |
pref_jc_sys |
Capacity requirements planning information
|
Table ID |
Table name |
|
CP010530 |
CRP_Prefs |
Sales configurator information
|
Table ID |
Table name |
|
OC010000 |
Option Category MSTR |
|
OC010100 |
Option Category LINE |
|
OC010200 |
Option Category Exclusion |
|
OC010300 |
Option_Category_Inclusion |
|
OC010400 |
Option Promotion MSTR |
Quality assurance information
|
Table ID |
Table name |
|
QAPS0032 |
pref_qa_sys |
|
QAPU0032 |
pref_qa_user |
|
QA100032 |
QA_Procedure_MSTR |
|
QA100132 |
QA_Procedure_LINE |
|
QA110032 |
AQL_MSTR |
|
QA110132 |
AQL_LINE |
|
QA110232 |
AQL_Sample |
|
QA120032 |
QA_Inspector |
|
QA130032 |
QA_Measurement_Types_MSTR |
|
QA130132 |
QA_Measurement_Types_LINE |
|
QA140032 |
QA_Defect_Code |
|
QA150032 |
QA_Disposition_Code |
|
QA160032 |
QA_Item_Procedure |
More Information
After you copy all the setup tables, you can run the mfgfix90checkdata stored procedure to determine any potential issues with the data. To do this, follow these steps:
-
Take one of the following actions, depending on the version of Microsoft SQL Server that you are using.
-
If you are using SQL Server 2005, start SQL Server Management Studio. To do this, point to All Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio.
-
If you are using SQL Server 2000, start SQL Query Analyzer. To do this, click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
-
-
Run the mfgfix90checkdata stored procedure. To do this, use one of the following methods.
Method 1: SQL Server Management Studio
-
In Object Explorer, expand Databases, and then click Dynamics.
-
Click New Query, and then type the following select statement in the query pane:
Exec mfgfix90checkdata
Method 2: SQL Query Analyzer
-
Type the following select statement in the query pane:
Exec mfgfix90checkdata
-
On the Query menu, click Results in Text, and then click Execute.
-
-
On the Query menu, point to Results To, and then click Results to Text.
-
On the Query menu, click Execute
Note For more information about how to fix the issues that are described here, request a Check Data document from your partner or from Microsoft Customer Support Services. For Customer Support Services telephone numbers, visit the following Microsoft Web site:
