Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Description of the Manufacturing setup tables that you can copy from an existing company to a new company in Microsoft Dynamics GP

Description of the Manufacturing setup tables that you can copy from an existing company to a new company in Microsoft Dynamics GP

INTRODUCTION

This article lists the Manufacturing setup tables that you can copy from an existing company to a new company in Microsoft Dynamics GP.

↑ Back to the top

More Information

Inventory item and related setup information

Table IDTable name
BC010000Buyer Codes
COSS0401pref_cost_sys
CT00001IC Cost Standard Company Default
CT00002IC Cost Standard Item Class Defaults
CT00003IC Cost Standard Items Defaults
CT00102IC Cost Item Master
CT40401 IC Cost Item Class Setup
ICIV0323 IC_IV_STANDARD
IVR10015Item Engineering
IVR10100Alternate Parts
PC010000MRP_Planner_Codes


Bills of material

Table IDTable name
BM010115Bill of Materials Line
BM010415BOM Revision
BM010116BOM_Line_HIST
BM010416BOM_Revision_HIST
BMPF0114 pref_bom_user
BMPS0114pref_bom_sys

Routings

Table IDTable name
RT010001routing_mstr
RT010130routing_line
RTPS0130pref_router_sys
RTPU0130 pref_router_user

Facility setup information

Note Facility setup information includes calendars, work centers, machines, and labor codes.




Table IDTable name
DD010000Down Day
CO010000MFG_Company_ Info
DD020000Down on Weekends
DD030000Up_Days
MM010032Machine Master
WC010015Work Center Master
WC010100Work Center Employee Line Item
WC010200Work Center Machine Line
WC010300Work Center –Employee Absences
WC010400WC_Down_On_Weekends
WC010500WC_Down_Days
WC010600Work Center - Alternates
WC010714WC Operations Codes
WC010800WC Up Days
WC019831Work Center Header
WCPF0100pref_workcenter_user
WCPS0100pref_workcenter_sys
LC010014Labor Code Master
PFH10000pref_hdr

Order processing setup information

Table IDTable name
mops0100pref_mop_sys
MOPS0200pref_mop_sched_sys
SP010016Scheduling Preference_MSTR
SP010100Scheduling_Preference_Line
IS050000 Order Fulfillment Setup
IS090000Manufacturing Fulfillment Item Master
ISSP0201Manufacturing Series Sales Order Preferences
SOPS113Bpref_sop_sys
WPPS0114pref_wip_sys
WPPU0114pref_wip_user

Material requirements planning setup information

Table IDTable name
MPPS0130MRP Setup
MPPS0230pref_mrp_sys
MPPU0130pref_mrp_user
MRP0200mrpScheduleHDR
MRP0201mrpScheduleDetail

Engineering change management information

Table IDTable name
ECPS0000pref_ecm_sys
ECPU0000pref_ecm_user
EC020230ECM_Disposition
EC030030ECM_REJECT_CODE
EC020030ECM_Routing_HDR

Job costing information

Table IDTable name
ICJC0003Job Categories
ICJC0004ICJC_Category
ICJC0005ICJC_Line_Categories
ICJC0006ICJC_Revenue_Expense_Code
JCPS0040pref_jc_sys

Capacity requirements planning information

Table IDTable name
CP010530CRP_Prefs

Sales configurator information

Table IDTable name
OC010000Option Category MSTR
OC010100Option Category LINE
OC010200Option Category Exclusion
OC010300Option_Category_Inclusion
OC010400Option Promotion MSTR

Quality assurance information

Table IDTable name
QAPS0032pref_qa_sys
QAPU0032pref_qa_user
QA100032QA_Procedure_MSTR
QA100132QA_Procedure_LINE
QA110032AQL_MSTR
QA110132AQL_LINE
QA110232AQL_Sample
QA120032QA_Inspector
QA130032QA_Measurement_Types_MSTR
QA130132QA_Measurement_Types_LINE
QA140032QA_Defect_Code
QA150032QA_Disposition_Code
QA160032QA_Item_Procedure

↑ Back to the top

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:
  1. 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.
  2. Run the mfgfix90checkdata stored procedure. To do this, use one of the following methods.

    Method 1: SQL Server Management Studio

    1. In Object Explorer, expand Databases, and then click Dynamics.
    2. Click New Query, and then type the following select statement in the query pane:
      Exec mfgfix90checkdata

    Method 2: SQL Query Analyzer

    1. Type the following select statement in the query pane:
      Exec mfgfix90checkdata
    2. On the Query menu, click Results in Text, and then click Execute.
  3. On the Query menu, point to Results To, and then click Results to Text.
  4. 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:
http://support.microsoft.com/contactus/?ws=support

↑ Back to the top

Keywords: kbmbspartner, kbexpertiseinter, kbhowto, kbinfo, kbmbsmigrate, kbexpertisebeginner, kb

↑ Back to the top

Article Info
Article ID : 949762
Revision : 1
Created on : 1/7/2017
Published on : 7/14/2012
Exists online : False
Views : 94