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.APAdjust
AP.APInvoice
AP.APRegister
AP.VendorClass
AP.Vendor
AR.ARAdjust
AR.ARContact
AR.ARInvoice
AR.ARRegister
AR.ARTran
AR.Customer
AR.CustomerClass
AR.CustomerLocation
AR.CustSalesPeople
AR.SalesPerson
CR.Address
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
CS.ReasonCode
CS.Segment
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.GLTran
GL.Ledger
GL.SegmentValue
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
SO.SOOrderType
SO.SOShipment

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.
* Plain pre-mapped tables. Other tables have more preconfigured features such as indexes, update refresh (when available), and derived formulas and/or views.