Dynamics GP - Manufacturing tables

MO Setup - Numbering - Each company's next number sequence is stored in the Dynamics db
MOPS0100 - Manufacturing Order Preference Defaults (has a company id in the table)

CT00102 - Item Account Maintenance - Costing (Additional Accounts window on Item Card)
CT40401 - Item Class Account Maintenance - Costing (Additional accounts window on Item Class)

• icivmuixi_VarMat
• icivwmixi_WipMaterial
• icivcmixi_CogsMaterial

MM010032 - Machine Definition Master
IVR10015 - Item Engineering Data
IV00102 - Item Quantities / Resource Planning
IV00115 - Manufacturing Item Information
LC010014 - Labor Code Master

SP010016 - Scheduling Preference Master

IV40700 - Site Master (Required for Work Centers)
WC010015 - Work Center Master
WC010931 - Work Center Header (you need both)

BM010415 - Manufacturing BOM Master Header
BM010115 - Manufacturing BOM Line Item Detail
BM10200 - BOM Routing Link

RT010001 - Routing Header (Primary Routing)
RT010130 - Routing Line

SC020030 - Sales Forecast Header
SC020130 - Sales Forecast Line Item Total
SC020230 - Sales Forecast Line Date breakdown

MF010030 - MPS Header
MF010130 - MPS Line Item Total
MF010230 - MPS Line Date Breakdown

MPSF1000 - MRP (Sales) Forecasting Selections

WO010032 - Manufacture Order Master

• IS010001 - MOP/SOP Link Cross reference table 
• SOITEMDUEDATE_I = In-House Due date
• SOITEMPROMISEDATE_I = Promise Date
• SOP10200.ReqShipDate = Requested Ship Date

MN010000 - MO Notes (BOM notes are connected to Item Engineering table)

PK010033 - Picklist Lines

IVIC0101 - Mfg Receipt / Inventory Adjustment Index
MOPW400 - Mfg Receipt Work
MOPW500 - Mfg Receipt Work

Make/Buy Codes

• 1-Make
• 2-Buy
• 3-Make/Buy

Fulfilment Methods

• 1-Make to stock
• 2-Make to Order-Manual
• 3-Make to Order-Silent

MO Status Codes

• 1-Quote
• 2-Open
• 3-Released
• 4-Hold
• 5-Canceled
• 6-Complete
• 7-Partially Received
• 8-Closed

Component Entry Trx Codes

• 1-Issue
• 2-Reverse Issue
• 3-Allocate
• 4-Reverse Allocate
• 5-Scrap
• 6-Reverse Scrap

MO Receipt Costs
Receiptcostsarray_1 - Total Item Costs
Receiptcostsarray_4 - Total Labor costs
Receiptcostsarray_7 - Total Machine Costs
receiptcostsarracy_10 - Total total costs

WO010213 - MOP Order History

MOP1210 - MOP Picklist Line Items
MOP1016 - MOP WIP Receipt
MOP1100 - MOP Receipt Master
MOP1110 - MOP Line Items

WR010130 - MO Routing Line

MRP0300 - MRP Exception List (Suggested MMO's, MPO's)

Full list of Manufacturing tables here
http://dyndeveloper.com/DynTable.aspx?ModuleID=MF

http://support.microsoft.com/kb/949762