...
Pre-mapped ETL+ tables available for Sage 100 (Providex and MS SQL Server) as of 02/2022. Subject to change without notice.
Source | Table Name | Advanced | Pro & Ent |
|---|---|---|---|
Sage 100 | AP_InvoiceHistoryHeader |
| |
Sage 100 | AP_OpenInvoice |
| |
Sage 100 | AP_Vendor |
| |
Sage 100 | AR_Customer |
|
|
Sage 100 | AR_InvoiceHistoryDetail |
|
|
Sage 100 | AR_InvoiceHistoryHeader |
|
|
Sage 100 | AR_OpenInvoice |
|
|
Sage 100 | AR_Salesperson |
|
|
Sage 100 | BM_BillDetail |
| |
Sage 100 | BM_BillHeader |
| |
Sage 100 | BM_ProductionHistoryDetail |
| |
Sage 100 | BM_ProductionHistoryHeader |
| |
Sage 100 | BM_ProductionHistoryTierDist |
| |
Sage 100 | CI_Item |
|
|
Sage 100 | GL_Account |
|
|
Sage 100 | GL_AccountCategory |
|
|
Sage 100 | GL_AccountGroup |
|
|
Sage 100 | GL_AccountStructure |
|
|
Sage 100 | GL_AccountType |
|
|
Sage 100 | GL_DetailPosting |
|
|
Sage 100 | GL_FiscalYearDetail |
|
|
Sage 100 | GL_MainAccount |
|
|
Sage 100 | GL_PeriodBudgetDetail |
|
|
Sage 100 | GL_PeriodPostingHistory |
|
|
Sage 100 | GL_SubAccount |
|
|
Sage 100 | IM_ItemTransactionHistory |
| |
Sage 100 | IM_ItemWarehouse |
|
|
Sage 100 | IM_ItemWhseHistoryByPeriod |
| |
Sage 100 | IM_PeriodPostingHistory |
| |
Sage 100 | PO_PurchaseOrderDetail |
|
|
Sage 100 | PO_PurchaseOrderHeader |
|
|
Sage 100 | SO_SalesOrderHeader |
|
|
Sage 100 | SO_SalesOrderHistoryDetail |
|
|
Sage 100 | SO_SalesOrderHistoryHeader |
|
|
Sage 100 | SO_ShipToAddress |
|
|
Data Warehouse | 4_Today |
|
|
Data Warehouse | 5_Date |
|
|
Data Warehouse | 6_DatePeriod |
|
|
Data Warehouse | GLz_04_Dimensions_NoOverride |
|
|
Data Warehouse | GLz_05_Dimensions |
|
|
Data Warehouse | GLz_10_C3_Detail |
|
|
Data Warehouse | GLz_12_C1_MajorTotal |
|
|
Data Warehouse | GLz_14_C15_MinorTotal |
|
|
Data Warehouse | GLz_16_C2_MinorTotal |
|
|
Data Warehouse | GLz_50_Balances_Budget |
|
|
Data Warehouse | GLz_60_PeriodBudgetDetail_WithDates |
|
|
Data Warehouse | IMz_01_PeriodPostingHistory_ItemWhseAllPeriods |
| |
Data Warehouse | SY0_CompanyParameters |
|
|
Data Warehouse | zSage 100 Tips & Documentation |
|
|
Notes:
Some of the above tables will only be deployed using customized SOWs or via services.
We only recommend extracting tables that are important for your reporting purposes.
...