Skip to main content
Skip table of contents

Sage 300 Pre-mapped Data Warehouse Tables

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

Tables

Pre-mapped ETL+ tables available for Sage 300 as of 12/2022. Subject to change without notice.

Source

Table Name

Sage 300

APIBD

Sage 300

APIBH

Sage 300

APOBS

Sage 300

APPJD

Sage 300

APRAS

Sage 300

APRTA

Sage 300

APVEN

Sage 300

APVGR

Sage 300

ARCSP

Sage 300

ARCUS

Sage 300

ARCUSO_T

Sage 300

ARGRO

Sage 300

ARIBD

Sage 300

ARIBH

Sage 300

ARITH

Sage 300

AROBL

Sage 300

AROBS

Sage 300

ARPJD

Sage 300

ARRAS

Sage 300

ARRTA

Sage 300

ARSAP

Sage 300

CSCOM

Sage 300

CSFSC

Sage 300

CSOPTFD

Sage 300

GLACGRP

Sage 300

GLAFS

Sage 300

GLAMF

Sage 300

GLASV

Sage 300

GLPOST

Sage 300

GLSRCE

Sage 300

ICACCT

Sage 300

ICCATG

Sage 300

ICHIST

Sage 300

ICILOC

Sage 300

ICITEM

Sage 300

ICITEMO_T

Sage 300

ICITMV

Sage 300

ICLOC

Sage 300

ICPRIC

Sage 300

ICUNIT

Sage 300

OEAUDD

Sage 300

OEAUDH

Sage 300

OECRDD

Sage 300

OECRDH

Sage 300

OEINVD

Sage 300

OEINVH

Sage 300

OEMISC

Sage 300

OEORDD

Sage 300

OEORDH

Sage 300

OEORDHO_T

Sage 300

OESHDT

Sage 300

OESTATS

Sage 300

OETERMI

Sage 300

POHSTL

Sage 300

POPORH1

Sage 300

POPORHO_T

Sage 300

POPORL

Data Warehouse

4_Today

Data Warehouse

5_Date

Data Warehouse

6_DatePeriod

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 300

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

Source: Sage 300: Sage 300 tables that have been pre-mapped in ETL+. They are part of DataSelf Step 1 - mirroring Sage 300 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.

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 300 table and its column names, indexes, and formatting in ETL+. Ex.: AUDTORG and IDCUST are the primary keys of 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 ARIBH using the Replace feature. This example only updates the last 30-days worth of transactions.

Using table linking in the ETL SQL Statement, one can link detail tables that don’t have date fields with their parent tables and then set up the delta refreshes.

Table Linking Example

The following is an example of how Sage 300 _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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.