Sage X3 Pre-Mapped Data Warehouse Tables

Click here for learning about Tableau, Power BI, and MS Excel templates for Sage 100.

Tables

Pre-mapped ETL+ tables available for Sage X3 as of 11/2021. Subject to change without notice.

Source

Table

Source

Table

Sage X3

ATEXTRA

Sage X3

BOMD

Sage X3

BALANA_Unpivoted

Sage X3

BPADDRESS

Sage X3

BPARTNER

Sage X3

BPCCATEG

Sage X3

BPCUSTOMER

Sage X3

BPSUPPLIER

Sage X3

BUD_Unpivoted

Sage X3

CACCE

Sage X3

COMPANY

Sage X3

FACGROUP

Sage X3

FACILITY

Sage X3

GACCDUDATE

Sage X3

GACCENTRY

Sage X3

GACCENTRYA

Sage X3

GACCENTRYD

Sage X3

GACCOUNT

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

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_26_AllItemsTransOH

Data Warehouse

INH_35_ItemsMonthsHistoryDates

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

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.

Sage X3

The out-of-the-box ETL+ and data warehouse mappings have been designed to let users easily extract the data from Sage X3.

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+.

  • 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 are special tables that provide enhanced reporting value. Summary:

  • 4_ 5_ and 6_ tables for advanced period analytics.

  • INH_ tables for performing inventory manipulations.

  • MFGz_ tables for performing manufacturing manipulations.

Table Columns Example

DataSelf ETL+ templates include adjustments to table columns' data types and indexes. Click here to learn more.

The following is an example of Sage X3 table and its column names, indexes, and formatting in ETL+. Column green icons indicate the data type and/or index definition have been set or changed in ETL+. Ex.: ROWID is set as the primary key for this table.

Delta Load Example

DataSelf ETL+ templates provide delta load configuration for popular large tables. This dramatically reduces the time to refresh the data warehouse. ETL+ Table Load Types.

The following is an example of SINVOICED using the Upsert feature: modified records are updated, and new records are added.

Table Linking Example

The following is an example of how Sage X3 _AR_Aging_Today tables are linked in DataSelf’s out-of-the-box templates. This linking applies the same way for Tableau data sources, Power BI data sets, Excel, and other reporting tools.