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: