Acumatica Data Warehouse Pre-mapped Tables

Home/Acumatica Data Warehouse Pre-mapped Tables

List of pre-mapped Acumatica tables available as of 09/01/2018:

AP.APInvoice
AP.APRegister
AP.VendorClass
AP.Vendor
AP.VendorR
AR.ARBalances
AR.Customer
AR.CustomerClass
AR.CustSalesPeople
AR.SalesPerson
AR.ARInvoice
AR.ARTran
CR.Address
CR.BAccountR
CR.BAccount
CR.Contact
CR.CRCampaign
CR.CRCampaignType
CR.CRCase
CR.CRCaseClass
CR.CRContactClass
CR.CROpportunity
CR.CROpportunityProbability
CR.CROpportunityProducts
CR.CRRelation
CR.Location
CS.CSAnswers
CT.Contract
CT.ContractItem
CT.ContractTemplate
EP.EPEmployee
EP.EPEmployeeClass
FA.FATran
FA.FADetails
FA.FALocationHistory
FA.FixedAsset
FS.FSEquipment
FS.FSServiceContract
FS.FSServiceOrder
FS.FSSODet
GL.Account
GL.AccountClass
GL.Branch
GL.Company
GL.GLHistory
GL.GLHistoryByPeriod
GL.GLTranR
GL.Sub
IN.INItemClass
IN.InventoryItem
IN.INItemStats
IN.INRegister
IN.INSite
IN.INTran
IN.INTranDetail
IN.INUnit
PM.PMAccountGroup
PM.PMBudget
PM.PMProject
PM.PMTask
PM.PMTran
PO.POLine
PO.POOrder
SM.Users
SM.Version
SO.SOAddress
SO.SOInvoice
SO.SOLine
SO.SOOrder

Only the most popular fields for reporting purposes are pre-mapped out of the box. It’s simple to import additional fields from pre-mapped tables.