Supported database extract tables for Birst

This table shows the Distribution SX.e database tables that can be extracted when you run the SA Data Extraction for Data Lake and Birst 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 Data Extraction for Data Lake and Birst 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 Data Extraction for Data Lake and Birst. 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* addon.transdt KPET
AODATA KPSO
APET* apet.invdt KPSG
APSP KPSK
APSS NOTES* notes.transdt
APSV OEEH oeeh.enterdt
ARET* aret.invdt OEEHA
ARETT OEEHC
ARSA OEEHP
ARSC OEEL* oeel.enterdt
ARSL OEELK
ARSS OEELM
BINMST PDER
CARRIER PDSC
COM PDSR
EMPMST POEH* poeh.enterdt
GLET* glet.postdt POEL* poel.enterdt
GLSA POELA
GLSB POELC
ICET POELO
ICETL POER
ICETS POERAH
ICSC POERAL
ICSD PV_PDSPS
ICSEL PV_USER
ICSES SASC
ICSEU SASJ* sasj.postdt
ICSL SASOO
ICSP SASTA
ICSS SASTN
ICSW SMSN
ICSWU TRANSACTIONS
ITEM