Sage 100 Data Warehouse Pre-mapped Tables

Home/Sage 100 Data Warehouse Pre-mapped Tables

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

AP_CheckHistoryDetail
AP_CheckHistoryHeader
AP_Division
AP_InvHistoryDetail
AP_InvHistoryHeader
AP_OpenInvoice-E1000
AP_TermsCode
AP_Vendor
AR_BillToSoldTo
AR_Customer
AR_Division
AR_InvoiceHistoryDetail
AR_InvoiceHistoryHeader
AR_OpenInvoice
AR_Salesperson
AR_TermsCode
AR_TransactionPaymentHistory
CI_Item
GL_Account
GL_AccountCategory
GL_AccountGroup
GL_AccountStructure
GL_AccountType
GL_Budget
GL_DetailPosting
GL_FiscalYear
GL_FiscalYearDetail
GL_MainAccount
GL_PeriodBudgetDetail
GL_PeriodPostingHistory
GL_SourceJournal
GL_SubAccount
IM1_InventoryMasterfile
IM_ItemTransactionHistory
IM_ItemWarehouse
IM_ItemWhseHistoryByPeriod
IM_PeriodPostingHistory
IM_ProductLine
IM_WarehouseCode
JC0_CostTypes
JC0_Parameters
JC1_JobMaster
JC2_JobCostDetail
JC3_BillingAndPaymentDetail
JC3_TransactionDetail
JCA_JobTypeMasterfile
JCC_CostCodeHeader
JCC_CostCodeMaster
PO_PurchaseOrderDetail
PO_PurchaseOrderHeader
PO_ReceiptHistoryDetail
PO_ReceiptHistoryHeader
SM_531ComplaintCode
SM_531FailureReason
SM_531ServiceItemEntryHistory
SM_531ServiceItemSerialHistory
SM_531ServiceItemStatusLogHist
SM_531ServiceOrderHistDetail
SM_531ServiceOrderHistHeader
SM_531ServiceOrderUserLogHist
SM_531ServiceTechHistory
SM_531ServiceTechnician
SM_531StatusCode
SM_531WarrantyCode
SO_CancelReasonCode
SO_SalesOrderDetail
SO_SalesOrderHeader
SO_SalesOrderHistoryDetail
SO_SalesOrderHistoryHeader
SO_ShipToAddress

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.