Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our Manufacturing scripts. All of our scripts for Dynamics GP can be found here
Manufacturing Scripts
 
No records to display.
Module List > Module COMPANY..Manufacturing tables
DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally make the world a better place.
You are currently viewing the COMPANY database.
Change


ClearPixel
Freq
Used
 Display Name
 BC010000Buyer Codes
 BM010115Bill Of Material Line File
 BM010116BOM_Line_HIST
 BM010117BOM_Mass_Changes_Line_Defaults
 BM010200BOM <--> Routing Link
 BM010300Bill Of Materials Log File
 BM010415BOM Revision
 BM010416BOM_Revision_HIST
 CO00101 
 CO00102 
 CO00103coAttachProperties
 CO00104coAttachStatus
 CO00105coAttachEmail
 CO00121QueryDesigner_FieldsList
 CO00122QueryDesigner_Relationships
 CO00123QueryDesigner_Conditions
 CO010000MFG_Company_Info
 CO07260 
 CP010030Capacity Master File
 CP010100CRP Line Item
 CP010230Capacity Weeks File
 CP010330Capacity Months File
 CP010400CRP_Accelerator
 CP010530CRP Preferences File
 CT00001IC COST Standard Company Defaults
 CT00002IC COST Standard Item Class Defaults
 CT00003IC COST Standard Item Defaults
 CT00004IC_COST_Rollup_Tracking
 CT00005IC_COST_Proposed_Overhead
 CT00102IC COST Item Master
 CT00200IC_COST_Tracked_Changes
 DW010013draw
 DW010100drawgrp
 EC010031ECM_MSTR
 EC010100ECM_Text1
 EC010131ECM_HIST
 EC010200ECM_Text2
 EC010230ECM_HDR
 EC010300ECM_Text3
 EC010330ECM_User_Defined
 EC010400ECM_Text4
 EC020030ECM_Routing_HDR
 EC020130ECM_Routing
 EC020230ECM_Disposition
 EC030030ECM_REJECT_CODE
 EC030031ECM_Reject
 FI010100Fiorruci Sales Line Item
 FI010110Fiorruci Sales Line Item
 FI020000Fiorruci Food Item MSTR
 ICW00001IC_COST_Recursion_WORK
 IS010001ICONrol Sale Order Line
 IS010201Shipping History Line Hist
 IS010202Manufacturing Sales Serial/Lot Work and Hist
 IS010210Shipping History Line
 IS030001ICONrol Sale Order Line History
 LC010014Labor Code MSTR
 MF010030MPS Master
 MF010130MPS Line
 MF010230MPS Schedule
 MF010330MPS Line Header
 MF010430MPS Transaction Log
 MM010032Machine Master
 MN010000MFG_Notes
 MOS02000MOP_Sched_Interface_Orders
 MOS03000MOP_Sched_Interface_Report_Before
 MOS04000MOP_Sched_Interface_Report_After
 MOS05000MOP_Sched_Interface_Report_Difference
 MP010000Manufacture Order Locking
 MP030000MRP Exclusion List
 MPB01000MRP_BOM_Validate_WORK
 MRP0100mrpItemsList
 MRP0101mrpItemSitesList
 MRP0111mrpNetChangeQueue
 MRP0200mrpScheduleHDR
 MRP0201mrpScheduleDetail
 MRP0300mrpExceptionsEPS
 MRP4010mrpMOPLinesEPS
 MRP4020mrpPicklistLinesEPS
 MRP4030mrpPopLinesEPS
 MRP4040mrpIvLinesEPS
 MRP4050mrpDependentDemandEPS
 MRP4060mrpSopLinesEPS
 MRP4070mrpSuggestionsEPS
 OC010000Option Category MSTR
 OC010100Option Category LINE
 OC010200Option Category Exclusion
 OC010300Option_Category_Inclusion
 OC010400Option Promotion MSTR
 PC010000MRP_Planner_Codes
 PK010033Picklist File
 PK01200Picklist Sequence Master
 PK020031Picklist File for a single Finished Good
 PO020031POAP_Item_MSTR
 QA010032QA_HIST_Incoming_HDR
 QA010132QA_HIST_Incoming_MSTR
 QA010232QA_HIST_Incoming_STEP
 QA010332QA_HIST_Incoming_LINE
 QA010433QA_HIST_NSR_Incoming
 QA010532QA_HIST_SCAR
 QA020032QA_In_Process_MSTR
 QA020232QA_In_Process_Step_LINE
 QA020332QA_In_Process_Measurement_LINE
 QA021032QA_In_Process_RTSeq_Procedure
 QA021132QA_In_Process_RTSequence_LINE
 RT010001routing_mstr
 RT010130routing_line
 RT010300routing_rtgmcid
 RT010400routing_rtgwcid
 RT010500Routing Cycle Time
 RVP0100pref_recv_user
 SC020030Sales Forecast Master
 SC020130Sales Forecast Line
 SC020230Sales Forecast Date
 SC020330Sales Forecast Customers
 SC020430Sales Forecast Salespeople
 SC020530SF_HIST
 SC020630SF_HIST_LINE
 SC020730SF_LINE_HDR
 SF010014Data Collection MSTR
 SF010115Data Collection Line Items
 SF010200Data Collection Transaction Log
 SF010300Data Collection Transaction Security
 SF010400Data_Collection_Material
 SF010500Automated Data Collection Input Records
 SF010501Automated Data Collection Records
 SF010502Automated Data Collection Matched Records
 SF010600DC_Labor_Batch_Entry_Hdr
 SF010601DC_Labor_Batch_Entry_Dtl
 SO030000Sales Order FOB
 SP010016Scheduling Preference_MSTR
 SP010100Scheduling_Preference_Line
 TL020000Tool Group Master File
 TP010000Tape Number MSTR
 UF010100URF_Reports
 UF010200Manufacturing Report Groups
 WC010015Work Center Master File
 WC010100Work Center Employee Line Item File
 WC010200Work Center Machine Line
 WC010300Work Center - Employee Absences
 WC010400WC_Down_on_Weekends
 WC010500WC_Down_Days
 WC010600Work Centers - Alternates
 WC010714WC Operation Codes
 WC010800WC UP Days
 WC010931Work Center Header File
 WC01100WC_Skill
 WO010032Manufacture Order Master
 WO010116MOP Historical Variance
 WO010213Manufacture Order History
 WO010302Manufacture Order Lot Issue
 WO010302RebuildManufacture Order Lot Issue
 WO010400Manufacture Order Lot/Serial Issue
 WO01050MOP_Close_WIP_Hist
 WO010515Manufacture Order Serial Issue
 WO010515RebuildManufacture Order Serial Issue
 WO010615Manufacture Order Finished Serial Assign
 WO010701Manufacture Order Closing File
 WO010702MOP_Close_WIP
 WOA01060Manufacture Order Finished Serial Assign Arc
 WR010130MOP_Routing_Line
 WR010400MOP_rtgwcid
 WR010500MOP_rtgmcid
Freq
Used
 Display Name
 BMS10000BOM Security
 IC10200Manufacturing Series Purchase Receipts
 IVR10100Alternate Parts
 IVR10232IV_Item_VNDR
 IVR10300Inventory Item ABC Settings
 MNH10000MFG_Notes_Next_Index
 MOP1000MOP WIP Stack
 MOP1000RebuildMOP WIP Stack
 MOP1001MOP WIP Stack
 MOP1002MOP_WIP_Costs
 MOP1003MOP_MOVar_HIST
 MOP1004MOP_MO_Variance_Material_Hist
 MOP1005MOP WIP Variance
 MOP1006MOP_Item_MSTR_Qty_Var
 MOP1007MOP_WIP_ReconcileErrors
 MOP1008MFG_TrackProcesses
 MOP1009MOP_WIPCostChanges
 MOP1010MOP WIP Labor and Machine
 MOP1011MOP_Item_MSTR_Qty_Var_STD
 MOP1012MOP_MO_Variance_Material_Hist_STD
 MOP1014IC_COST_QTY_History
 MOP1015MOP_WIPOverrideHist
 MOP1016MOP_WIP_Receipt_History
 MOP1020Manufacture Order Lot Issue
 MOP10213Manufacture Order Activity
 MOP10223Manufacture Order Locking
 MOP1025Manufacture Order Pending Bin
 MOP1026Manufacture Order Pending Bin Trx
 MOP1027Manufacture Order Lot Issue
 MOP1027RebuildManufacture Order Lot Issue
 MOP1030Manufacture Order Lot Issue
 MOP1040MOP Serial Lot Assign
 MOP1041MOP Nontracked Assign
 MOP1042MOP Serial Pre Entry
 MOP1043MOP_Serial_Lot_Links
 MOP1050MOP Component Trx Serial Lot History
 MOP1055MOP Component Trx Serial Lot History
 MOP1070MOPEdit MO Status Header
 MOP1071MOP Edit MO Status Line
 MOP1072MOP_EditMOStatus_Line_DTL
 MOP1090Manufacture Order Lot Issue HIST
 MOP1090RebuildManufacture Order Lot Issue HIST
 MOP1095Manufacture Order Pending Bin HIST
 MOP1095RebuildManufacture Order Pending Bin HIST
 MOP1098MOP_Rebuild
 MOP1099MOP_CheckData
 MOP1100MOP_Receipt_MSTR
 MOP1110MOP_Receipt_Detail
 MOP1120MOP_Receipt_Detail_Serial_Lot
 MOP1121MOP_Receipt_Detail_Nontacked_Bin
 MOP1200MOP_PickDoc_MSTR
 MOP1210MOP_PickDoc_Line
 MOP1220MOP_PickDoc_Line_WORK
 MOP1230MOP_PickDoc_Number_Security
 MOP1400MOP_Picklist_Site_QTYS
 MOP1410MOP_Picklist_Site_Bin_QTYS
 MOP1500MOP_Backflushed_Costs
 MOP1510MOP_Backflushed_Costs
 MOP1600Manufacture Order Complete Close Work
 MOP1700MOP_Interim_Allocations
 MOP1800MOP_Picklist_Reconcile_Report_MSTR
 MOP1810MOP_Picklist_Reconcile_Report_Line
 MOP1900MOP_Trx_Bin_WORK
 MOP1950MOP_Purge_Work
 MPO10001MRP_CRP_Scheduled_Orders
 MPS10000MRP Security
 MRP1000PR_Request_Resolution_Lock
 MRP1010PR_Short_Items_Work
 MRP1011PR_Short_Items_Work_Dup
 MRP1020PR_Short_Items_Consolidate
 MRP1030PR_Suppliers_Work
 MRP1600mrpPlannedOrdersEPS
 PFH10000pref_hdr
 PMR10000PM_Vendor
 PRL10030PRERRORLOG
 QA100032QA_Procedure_MSTR
 QA100132QA_Procedure_LINE
 QA100232QA_Procedure_History_MSTR
 QA100332QA_Procedure_History_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
 QAD10032QA_Incoming_HDR
 QAD10132QA_Incoming_MSTR
 QAD10232QA_Incoming_STEP
 QAD10332QA_Incoming_LINE
 QAD10433QA_NSR_Incoming
 QAD10532QA_SCAR
 RTH10100routing_sum
 RTS10001routing_security
 RTW10000tempglrt
 WRS10001MOP_Routing_Security
Freq
Used
 Display Name
 MRP2130mrpDaysEPS
 MRP2230mrpWeeksEPS
 MRP2330mrpMonthsEPS
 MRP2430mrpUserEPS
 RTW20000tempglrthdr
Work Tables
Freq
Used
 Display Name
 BMH30100BOM_Log_Header
 MOP3000MOP Variances
 MOP30301MOP Inventory Transaction Detail History
 QAD30000QA_Item_MSTR
Freq
Used
 Display Name
 ADSK0100items exported from Autodesk
 ADSK0200BOMs exported from Autodesk
 ADSK0300BOM items exported from Autodesk
 ADSK0400BOMs exported from GP
 ADSK0500BOMs exported from GP
 ADSK0700AD_Item_Class_Setup
 ADSK0800AD IDs
 ADSK0900AD Item Drawings
 ADSK1000AD Drawing
 BMMU0001BOM_Mass_Changes_WORK
 BMMU0002BOM_Removed_Archived_BOMs_WORK
 BMMU0005BOM_Mass_Changes_Reporting_WORK
 BMPF0114pref_bom_user
 BMPS0114pref_bom_sys
 BMUF0101Report_Options
 BMUF0130BOM_Report_Options
 Bomlev1Bomlevel_1
 Bomlev2Bomlevel_2
 CO40100 
 COSS0401pref_cost_sys
 CPSP0200CRP_Parallel
 CPSP0300Critical Path Working File
 CPSP0400CRP_Critical_Path_WORK
 CPUF0131CRP Report Options
 CT40401IC COST Item Class Setup
 DD040000Up_Days_Work
 DWUF0130Drawing Report Options
 EC040131ECM_Exclude_Items
 EC050031ECM_Item_LINE
 EC090000ECM_Password
 ECPS0000pref_ecm_sys
 ECPU0000pref_ecm_user
 ECUF0132ECM_Report_Options
 FI040000Fiorucci Import Master Table
 FI040001Fiorucci Import Master Table
 FI040100Fiorucci Import Line Table
 FI040101Fiorucci Import Line Table
 FI080000Fiorucci Item Class Options
 IC090000Manufacturing Customer Master
 ICGL0102Manufacturing Series GL Line
 ICIV0323IC_IV_STANDARD
 ICIV0324ivConfiguredStandardCosts
 ICIV0400IC_COST_Rollup_User
 ICIV0500Mfg Components not Removed
 ICJC0001Job Master File
 ICJC0003Job Categories
 ICJC0004ICJC_Category
 ICJC0005ICJC_Line_Categories
 ICJC0006ICJC_Revenue_Expense_Code
 ICJC0007ICJC_Transactions
 ICJC0008ICJC_Transaction_List
 ICJC0009ICJC_Transaction_List_Line
 ICJC0100ICJC_IV_TRX_WORK_LINE
 ICJC0125ICJC_Report_Options
 ICJC1002ICJC_Linker
 ICJC1003ICJC_ManualTrx
 ICJC1004ICJC_Job_Transaction_MSTR
 ICJC1005ICJC_Job_Transaction_LINE
 ICJC1100ICJC_Linked_Elements
 ICJC1200ICJC_Linked_Trx
 ICJC2000ICJC_Job_LINE
 ICJC2005ICJC_Applied_Purchases
 ICJC2006ICJC_Applied_Purchases_Work
 ICJC2007ICJC_Applied_Purchases_LINE_WORK
 ICJC3000ICJC_DPOP_Linker
 ICJC3020ICJC_DPOP_Linker
 ICJC3100ICJC_DPOP_POP_Detail
 ICJC3110ICJC_DPOP_POP_Detail
 ICJC3120ICJC_DPOP_POP_Detail
 ICJC3200ICJC_DPOP_REC_Detail
 ICJC3210ICJC_DPOP_REC_Detail
 ICJC3300ICJC_DPOP_Invoice_Detail
 ICJC3310ICJC_DPOP_Invoice_Detail
 ICJC3500ICJC_DPOP_Transaction_MSTR
 ICJC3700ICJC_DPOP_Job_Distribution_Entry
 ICJC3710ICJC_DPOP_Job_Distribution_Work
 ICJC5000ICJC_DataCollection_Link
 ICJC5001ICJC_MDataCollection_Link
 ICJC6003ICJC_LinkerStatuses
 ICJC7000ICJC_Link_Memory
 ICJC7002ICJC_LinkerPrefs
 ICJC9000ICJC RM Sales Work
 ICJC9001PM Transaction WORK File
 IS050000Order Fulfillment Setup
 IS090000Manufacturing Fulfillment Item Master
 ISCVTLNEManufacturing SOP to Dynamics SOP Convert Lo
 ISCVTLOGManufacturing SOP to Dynamics SOP Convert Lo
 ISSP0201Manufacturing Series Sales Order Preferences
 IVIC0101Manufacturing Series Inventory Line
 IVIC0200Manufacturing Series Inventory Header
 IVR40400Manufacturing Item Class Setup
 IVR40500Manufacturing Series Item Class Fulfill Setu
 IVR50000Inventory Item Options
 IVUF0130IV_Report_Options
 JCPS0040pref_jc_sys
 MFGCONV1MFG_Conversion_Results
 MFGEXT01Mfg_Extra_Labels
 MFUF0101MF_Report_Options
 MMUF0130MFG_Module_Options_Machine
 MOJB0031MOP_JOB_LINK
 MOPA1040MOP Serial Lot Assign Archived
 mops0100pref_mop_sys
 MOPS0200pref_mop_sched_sys
 MOPW100MOP_Receipt_Labor_Costs_WORK
 MOPW200MOP_Comp_Trx_Items_Tab_WORK
 MOPW300MOP_Comp_Trx_PickDoc_Tab_WORK
 MOPW400MOP Receipt Detail Work
 MOPW500MOP Receipt TEMP WORK
 MP040000MRP Statuses
 MP040901MRP_Routing_Line
 MPPS0130MRP Setup File
 MPPS0230pref_mrp_sys
 MPPU0130pref_mrp_user
 MPSF1000MRP_Forecasting
 MPUF0130MFG_Module_Options_MRP
 MRP6060mrpQuantitiesQuery
 MRPW4010mrpMOPWork
 MRPW4020mrpPicklistWork
 MRPW4030mrpPopWork
 MRPW4060mrpSopLinesWork
 MRPW4061mrpSopForecastPlans
 MRPW4062mrpSopForecastWork
 OCUF0010Option Category Report Options
 OSRC1000OSRC_MOP_POP_Link_MSTR
 OSRC1010OSRC_MOP_POP_Link_Work
 OSRC1100OSRC_Suggested_PO_MSTR
 OSRC1110OSRC_Suggested_PO_Work
 OSRC1200OSRC_Suggested_Shipments_MSTR
 OSRC1300OSRC_Recorded_Shipments_MSTR
 OSRC1400OSRC_Additional_Costs_MSTR
 OSRC1500OSRC_Selected_Lot_Numbers_MSTR
 OSRC1600OSRC Selected Serials MSTR
 OSRC1700OSRC_MOP_POP_Link_DETAIL
 OSRC1800OSRC_New_Rec_Ivc_Lines_Work
 OSRC2000OSRC_WIP_Accounts
 POPF0113pref_pop_user
 POPS0132pref_pop_sys
 POPS0231pref_poap_sys
 PRPF0113pref_por_user
 QADUF132Report_Options
 QANS1000QA_NSR_Number_Security
 QAPS0032pref_qa_sys
 QAPU0032pref_qa_user
 QASS1000QA_SCAR_Number_Security
 QAUF0132QA_HIST_Report_Options
 RebuildErrorsRebuildErrors
 RTPS0130pref_router_sys
 RTPU0130pref_router_user
 RTUF0130routing_Report_Options
 RVPS0132pref_recv_sys
 SCSU0010Sales Configurator Setup
 SCSU0020Sales_Config_Component_Price
 SCSU0030Sales_Config_Item_Option
 SCUF0101SF_Report_Options
 SFUF0130Data Collection Reporting Options
 SOPS113Bpref_sop_sys
 TARD1001TA_Reference_Designator_Line
 TL040000Tool Grouping File
 TLPS0100pref_tool_sys
 TLPU0100pref_tool_user
 WCPF0100pref_workcenter_user
 WCPS0100pref_workcenter_sys
 WCTE0000wc_template
 WCTEHD00wc_template_hdr
 WCUF0130Work Center Reporting Options
 WOPS0100Manufacture Order Setup File
 WOUF0132Manufacture Order Reporting Options
 WPPS0114pref_wip_sys
 WPPU0114pref_wip_user
 WRUF0130MOP_Routing_Report_Options
 XXUF0100URF_Report_Options
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3