Master tables for initial load
This table lists the M3 CE master tables for sending the initial load.
| Verb | Noun | M3 master table for Initial Load |
|---|---|---|
| Sync/Show | AccountingBookDefinition | CSYTAB |
| Sync/Show | AccountingChart | CSYTAB |
| Sync/Show | AccountingEntity | CMNDIV |
| Sync/Show | AccountingJournal | CSYTAB |
| Sync/Show | AdvanceShipNotice | MHEXRH |
| Sync/Show | AssetMaster | FFASMA |
| Sync/Show | BillOfMaterials | MPDHED |
| Sync/Show | BillOfResources | MPDSRC |
| Sync/Show | BillToPartyMaster | OCUSAD, OCUSMA |
| Sync/Show | CarrierParty | CIDMAS |
| Sync | Catalog | CSYTAB |
| Sync/Show | ChartOfAccounts | FCHACC |
| Sync/Show | CodeDefinition for Accounting Dimensions | FCHACC |
| Sync/Show | CodeDefinition for Action Codes | CIMACD |
| Sync/Show | CodeDefinition for AP Payment Methods | CSYTAB |
| Sync/Show | CodeDefinition for AR Payment Methods | CSYTAB |
| Sync/Show | CodeDefinition for Capabilities | CCADEF |
| Sync/Show | CodeDefinition for Cost Centers | FCHACC |
| Sync/Show | CodeDefinition for Customer Discount Groups | CSYTAB |
| Sync/Show | CodeDefinition for Customer Groups | CSYTAB |
| Sync/Show | CodeDefinition for Customs Statistics Number | CSYCSN |
| Sync/Show | CodeDefinition for Delivery Terms | CSYTAB |
| Sync/Show | CodeDefinition for Dynamic Dimension | FGLEDG |
| Sync/Show | CodeDefinition for Equipment Classes | MIEQCL |
| Sync/Show | CodeDefinition for Equipment Groups | MIEQGR |
| Sync/Show | CodeDefinition for Equipment Meter | SINDMD |
| Sync/Show | CodeDefinition for Error Code 1s | CSYTAB |
| Sync/Show | CodeDefinition for Error Code 2s | CSYTAB |
| Sync/Show | CodeDefinition for Error Code 3s | CSYTAB |
| Sync/Show | CodeDefinition for Feature Options | MPDFHE |
| Sync/Show | CodeDefinition for Freight Terms | CSYTAB |
| Sync/Show | CodeDefinition for General Code | CSYTAB |
| Sync/Show | CodeDefinition for Harbor & Airport | CSYTAB |
| Sync/Show | CodeDefinition for Individual Item Groups | CSYTAB |
| Sync/Show | CodeDefinition for Inspection Result Values | MPDIRV |
| Sync/Show | CodeDefinition for Issue Types | CIMTYP |
| Sync/Show | CodeDefinition for Item Discount Groups | CSYTAB |
| Sync/Show | CodeDefinition for Item Free Field 1 | CSYTAB |
| Sync/Show | CodeDefinition for Item Free Field 3 | CSYTAB |
| Sync/Show | CodeDefinition for Item Free Field 4 | CSYTAB |
| Sync/Show | CodeDefinition for Item Free Field 5 | CSYTAB |
| Sync/Show | CodeDefinition for Item Types | MITTTY |
| Sync/Show | CodeDefinition for Misc Cost Types | ACUEXP |
| Sync/Show | CodeDefinition for Options | MPDOPT |
| Sync/Show | CodeDefinition for Payment Terms | CSYTAB |
| Sync/Show | CodeDefinition for Points of Shipment | CSYTAB |
| Sync/Show | CodeDefinition for Price List Tables | OPLTMA |
| Sync/Show | CodeDefinition for Product Lines | CRPDLN |
| Sync/Show | CodeDefinition for Product Service Extend | SITCOM |
| Sync/Show | CodeDefinition for Product Structure Classes | CSYTAB |
| Sync/Show | CodeDefinition for Product Structure Types | CSYTAB |
| Sync/Show | CodeDefinition for Purchase Order Types | MPORDT |
| Sync/Show | CodeDefinition for Reason Codes | CIMRCD |
| Sync/Show | CodeDefinition for Routes | DROUTE |
| Sync/Show | CodeDefinition for Sales Order Charges | ODCHRG |
| Sync/Show | CodeDefinition for Sales Order Types | OOTYPE |
| Sync/Show | CodeDefinition for Seasons | CSEAMA |
| Sync/Show | CodeDefinition for Service Action | SMECOD |
| Sync/Show | CodeDefinition for Service Action Text | SMETXT |
| Sync/Show | CodeDefinition for Service Assignment Types | SASSTP |
| Sync/Show | CodeDefinition for Service Centers | MPDWCT |
| Sync/Show | CodeDefinition for Service Error Cause | SERCOD |
| Sync/Show | CodeDefinition for Service Error Symptom | SERSYM |
| Sync/Show | CodeDefinition for Service Managers | SSRESP |
| Sync/Show | CodeDefinition for Service Order Types | SSTYPE |
| Sync/Show | CodeDefinition for Service Qualifications | CSYTAB |
| Sync/Show | CodeDefinition for Service Types | CSYTAB |
| Sync/Show | CodeDefinition for Stock Locations | MITPCE |
| Sync/Show | CodeDefinition for Supplier Invoice Authorized Users | FAPRCD |
| Sync/Show | CodeDefinition for Transportation Methods | CSYTAB |
| Sync/Show | CodeDefinition for Unit Codes | CSYTAB |
| Sync/Show | CodeDefinition for VAT Codes | CSYTAB |
| Sync/Show | CodeDefinition for Work Order Types | MMORDT |
| Sync/Show | ConfiguredAssetMaster for Maintenance Order | MILOIN |
| Sync/Show | ConfiguredAssetMaster for Service Order | SINDIV |
| Sync/Show | ContactMaster | CCUCON |
| Sync/Show | Contract for CO Blanket Agreement | OAGRHE |
| Sync/Show | Contract for PO Agreement | MPAGRH |
| Sync/Show | CurrencyExchangeRateMaster | CCURRA |
| Sync/Show | CurrencyRateType | CSYTAB |
| Sync/Show | CustomerPartyMaster | OCUSMA |
| Sync/Show | CustomerReturn | OCHEAD |
| Sync/Show | FinancialCalendar | CSYPER |
| Sync/Show | FinancialPartyMaster | CBANMA |
| Sync/Show | InspectDelivery | MPLIND |
| Sync/Show | InspectionOrder for Work Order | MMOOPS |
| Sync/Show | InventoryAdjustment | MITTRA |
| Sync/Show | InventoryCount | MITTKV |
| Sync/Show | InventoryHold | MITTRA |
| Sync/Show | Invoice for BillforPrepayment | OOPINH |
| Sync/Show | Invoice for CustomerOrder Invoicing | CINHED |
| Sync/Show | Invoice for Leasing Agreement Invoicing | CINHED |
| Sync/Show | Invoice for Maintenance Order Invoicing | CINHED |
| Sync/Show | Invoice for Manual Invoicing | CINHED |
| Sync/Show | Invoice for Project Invoicing | CINHED |
| Sync/Show | Invoice for Rental Agreement Invoicing | CINHED |
| Sync/Show | ItemMaster | MITMAS |
| Sync/Show | Location for Facility | CFACIL |
| Sync/Show | Location for Warehouse | MITWHL |
| Sync/Show | PayableTransaction | FPLEDG |
| Sync/Show | PayFromPartyMaster | OCUSMA |
| Sync/Show | Person | CSYUSR |
| Sync/Show | ProductionOrder | MWOHED |
| Sync/Show | ProjectMaster | BPROJS |
| Sync/Show | Promotion | OPROMH |
| Sync/Show | PurchaseOrder | MPHEAD |
| Sync/Show | QualitySpecification for Work Order | MPDIID |
| Sync/Show | QualityTestMaster for Work Order | MPDIRE |
| Sync/Show | Quote | OOQUOH |
| Sync/Show | ReceivableTransaction | FSLEDG |
| Sync/Show | ReceiveDelivery | MPLIND |
| Sync/Show | ReceiveDelivery for Warehouse | MHDISH |
| Sync/Show | RemitToPartyMaster | CIDMAS |
| Sync/Show | Requisition | MPOPLP |
| Sync/Show | SalesOrder | OOHEAD |
| Sync | SecurityPermissionMaster | CMNPSU |
| Sync | SecurityRoleMaster | CMNROL |
| Sync/Show | ServiceOrder | SSHEAD |
| Sync/Show | ServiceOrder for Work Order | MMOHED |
| Sync/Show | ShipFromPartyMaster | CIDMAS |
| Sync/Show | Shipment | DCONSI |
| Sync/Show | Shipment for Delivery | MHDISH |
| Sync/Show | ShipToPartyMaster | OCUSAD, OCUSMA |
| Sync/Show | SourceSystemGLMovement for Actual | FBAVAL |
| Sync/Show | SourceSystemGLMovement for Budget | FBUDET |
| Sync/Show | SourceSystemJournalEntry | FGLHED |
| Sync | SupplierInvoice | FPLEDG |
| Sync/Show | SupplierPartyMaster | CIDMAS |
| Sync/Show | Transfer | MGHEAD |