Supported database extract tables for Birst

This table shows the Distribution SX.e database tables that can be extracted when you run the SA Administrator Birst Extraction Report using an Extract Type of Text. The report creates text files for each of the selected tables based on the REST API FetchWhere temp-tables.

You can run the SA Administrator Birst Extraction Report to extract all tables by selecting All for the Tables to Extract option. To run the report for one or multiple tables, specify each table name, separated by commas.

This table also shows the date that is used to select records for extraction if you specify a date range. Only certain tables can be selected using the Date Range field. These are noted with an asterisk. If you specify a value in the Days to Extract option when you run the report, each record's Transdttmz field is checked. If the record does not have a Transdttmz field, the Transdt is used.

As of publication, these are the standard database tables that are supported for extraction by the SA Administrator Birst Extraction Report. Not all tables in this list are used to populate the domains supported in the current version of Distribution Analytics Content for Birst.

See the supported data load sources in the Infor Distribution Analytics for Birst Administration Guide.

Contact Infor Consulting Services for assistance with extracting a table that is not defined as a standard temp-table in the FetchWhere service.
Table Date Field Table Date Field
ADDON   OEEH* oeeh.enterdt
AODATA addon.transdt OEEL* oeel.enterdt
APET apet.invdt PDER  
APSP   POEH* poeh.enterdt
APSS   POEL* poel.enterdt
APSV   POELC* poelc.costeddt
ARET aret.invdt SASC  
ARSC   SASJ* sasj.postdt
ARSS   SASOO  
GLET* glet.postdt SASTA  
GLSA   SMSN  
ICSD      
ICSL      
ICSP      
ICSS      
ICSW      
ICSWU      
NOTES notes.transdt