Sage 500 Data Warehouse Pre-mapped Tables

Home/Sage 500 Data Warehouse Pre-mapped Tables

List of pre-mapped Sage 500 tables available as of 05/05/2018:

tapVendClass
tapVendPmt_UnappliedPayments
tapVendPurchHist
tapVendor
tapVoucher
tapVoucherDetl
tapVoucher_OpenPayables
tarCommClass
tarCommPlan
tarCommPlanSplit
tarCustAddr
tarCustClass
tarCustomer
tarInvoice
tarInvoiceDetl
tarInvoiceLineDist
tarInvoice_OpenReceivables
tarNationalAcct
tarNationalAcctLevel
tarNationalAcctMember
tarSalesTeam
tarSalesTeamMember
tarSalesTerritory
tarSalesperson
tciAddress
tciCompany
tciPaymentTerms
tciTranType
tciUnitMeasConvert
tciUnitMeasure
tglAccount
tglAcctGroup
tglAcctHist
tglAcctRef
tglAcctSegment
tglAcctType
tglBudget
tglBudgetType
tglFiscalPeriod
tglFiscalYear
tglJournal
tglNaturalAcct
tglSegment
tglSegmentCode
tglTransaction
timCostTier
timInventory
timInvtCalPerHist
timInvtFiscPerHist
timInvtPeriod
timInvtTran
timItem
timItemClass
timItemDescription
timItemUnitOfMeas
timProdCatItem
timProdCategory
timPurchProdLine
timWarehouse
timWhseBin
timWhseBinInvt
timWhseGroup
timWhsePurchProdLn
tpoPOLine
tpoPOLineDist
tpoPurchOrder
tsoPickList
tsoSOLine
tsoSOLineDist
tsoSalesOrdShip
tsoSalesOrder
tsoShipLine
tsoShipLineDist
tsoShipment
tsoShipmentLog

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.