...
| Table of Contents | ||
|---|---|---|
|
Click here for learning to learn about Tableau, Power BI, and MS Excel templates for Sage 100.
...
Source | Table |
|---|---|
Sage X3 | ATEXTRA |
Sage X3 | BALANA |
Sage X3 | BOMD |
Sage X3 | BPADDRESS |
Sage X3 | BPARTNER |
Sage X3 | BPCCATEG |
Sage X3 | BPCUSTOMER |
Sage X3 | BPSUPPLIER |
Sage X3 | CACCE |
Sage X3 | COMPANY |
Sage X3 | FACGROUP |
Sage X3 | FACILITY |
Sage X3 | GACCCLS |
Sage X3 | GACCCODE |
Sage X3 | GACCDUDATE |
Sage X3 | GACCENTRY |
Sage X3 | GACCENTRYA |
Sage X3 | GACCENTRYD |
Sage X3 | GACCOUNT |
Sage X3 | GCOA |
Sage X3 | GJOURNAL |
Sage X3 | GTYPACCENT |
Sage X3 | ITMCATEG |
Sage X3 | ITMFACILIT |
Sage X3 | ITMMASTER |
Sage X3 | ITMMVT |
Sage X3 | ORDERS |
Sage X3 | PERIOD |
Sage X3 | PINVOICE |
Sage X3 | PORDER |
Sage X3 | PORDERP |
Sage X3 | PORDERQ |
Sage X3 | SALESREP |
Sage X3 | SINVOICE |
Sage X3 | SINVOICED |
Sage X3 | SINVOICEV |
Sage X3 | SORDER |
Sage X3 | SORDERP |
Sage X3 | SORDERQ |
Sage X3 | STOCK |
Sage X3 | STOJOU |
Sage X3 | TABBOMALT |
Sage X3 | TABSOHTYP |
Data Warehouse | 4_Today |
Data Warehouse | 5_Date |
Data Warehouse | 6_DatePeriod |
Data Warehouse | BPCUSTOMER_T |
Data Warehouse | BPSUPPLIER_T |
Data Warehouse | GLz_02_AccountOverrides |
Data Warehouse | GLz_10_C3_Detail |
Data Warehouse | GLz_10_C3_Detail-CYE |
Data Warehouse | GLz_12_C1_MajorTotal |
Data Warehouse | GLz_14_C15_MinorTotal |
Data Warehouse | GLz_16_C2_MinorTotal |
Data Warehouse | GLz_20_C_Labels_Unioned |
Data Warehouse | GLz_30_BUD_Unpivoted |
Data Warehouse | GLz_34_GACCENTRYs |
Data Warehouse | GLz_38_BALANA_Unpivoted |
Data Warehouse | INH_01_TranBase |
Data Warehouse | INH_03_TransMonthly |
Data Warehouse | INH_10_EndBalBase |
Data Warehouse | INH_25_AllItemsTransEndOH |
Data Warehouse | INH_26_AllItemsTransOH |
Data Warehouse | INH_30_AllItemsMonths |
Data Warehouse | INH_35_ItemsMonthsHistoryDates |
Data Warehouse | ITMMASTER_T |
Data Warehouse | MFGz_BOM01_Item |
Data Warehouse | MFGz_BOM02_Component |
Data Warehouse | MFGz_BOM03_Header |
Data Warehouse | MFGz_BOM10_Level0 |
Data Warehouse | MFGz_BOM11_Level1 |
Data Warehouse | MFGz_BOM12_Level2 |
Data Warehouse | MFGz_BOM13_Level3 |
Data Warehouse | MFGz_BOM14_Level4 |
Data Warehouse | MFGz_BOM15_Level5 |
Data Warehouse | zDateUntreated |
Data Warehouse | zEntity |
...
Source: Sage X3: Sage X3 tables that have been pre-mapped in ETL+. They are part of DataSelf Step 1 - mirroring Sage X3 raw data in the data warehouse. This pre-mapping includes:
Popular tables and columns for BI and reporting. We only map popular tables and columns to keep the extraction efficient and less taxing on resources. It’s easy to add more tables and columns via ETL+.
Many columns might have their data types adjusted for reporting purposes.
Large tables come pre-configured with delta refresh set up. This includes delta Load Type settings, as well as column data type formatting and indexing.
Source: Data Warehouse: These special tables provide enhanced reporting value. Summary:
4_ 5_ and 6_ tables for advanced period analytics.
GLz_ tables are used to report GL Trial Balances, P&L, B/S, and Cash Flow.
INz_ table(s) for inventory planning (combining Inventory On Hand Today, Open POs/WOs, Open SOs, and Sales projection).
MFGz tables for manufacturing BOM and Production Order reporting.
...