Supported tables for text extract to Birst

This topic describes 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.

These tables are all supported in the Infor Data Lake:

activities edsv kpsk rtmst
addon email-links kpso sabs
aodata empmst mmextract sals
apeba equatecart notes sasb
apebc event_trans oeeh sasc
apei event_trans_sub oeeha sasgt
apeia gdprctrl oeehc sasj
apeid gleb oeehch sasoo
apeig glee oeehextra sasos
apemm glet oeehp sasta
apet gletv oeehta sastaz
apeta glsa oeel sastc
apsf glsb oeelextra sastn
apsp icecndtl oeelk sastp
apss icecnhdr oeelm sled
apsv icecnserlot orddtl smsc
aret icenh order_type smseh
aretp icenl ordhdr smsep
arett icet ordhdr_status smsew
arsa iceti oteh smsn
arsc icetl oteph smsp
arsd icets otepl smss
arsde icsc otevh smsv
arsg icscn otevl smsvp
arsl icsd palletdet smsvw
arsp icsdp palletmst smsw
arspt icsec pdenh stgmst
arsrt icsef pdenl task
arss icseg pder task_emp
arst icseh pderv taxtable
authsecure icsei pdsc taxtabledtl
base icsel pdsf trans_type
bded icselc pdsm transactions
bdet icses pdsn vaeh
bdsc icset pdsr vaelo
bdsr icseu pdsra vaes
bdst icsl pdst vaesl
binmst icsou pdsv vendaddr
carrier icsp pdsvc venddetail
cartondtl icspc pick venmst
cartonmst icspcd poeh wave
ccrecover icspe poel webextension
cmsp icspr poela webmodification
com icsprt poelc webnote
contacts-methods icss poelo wh_zone
contacts-roles icsv poer whmst
contacts icsw poerah wmet
counthistory icswb poeral wmsb
crerr icswu prodcat wmsbp
cret inventory pv_pdsps wteh
crsb item pv_secure wtel
cycle_cnt jurtax pv_user wtelo
depmst kpet rsao wterah
edsbwc kpsg rt_type wteral

If you specify a value in the Days to Extract or Date Range options when you run the report, then the specified tables use the Transdttmz field in the extraction unless one of these scenarios occurs:

  • The selected tables are not subject to restriction by the Date Range field in the extraction.
  • The specified tables use specific date fields such as Invoice Date or Entered Date in the extraction.
Note: If the record does not have a Transdttmz field, then the Transdt or trans_date is used.

These tables are never restricted by the Date Range when extracted:

aodata glsa icseu kpsk
apss glsb icsl kpso
apsv icetl icsp pder
arsc icets icss pv_user
arss icsc icsw sasc
binmst icsd icswu sasoo
carrier icsel item sasta
empmst icses kpsg smsn

These tables use a specific date field in the extraction:

Table Date field
addon addon.transdt
apet apet.invdt
aret aret.invdt
arett arett.invdt
glet glet.postdt
icet icet.postdt
kpet kpet.enterdt
notes notes.transdt
oeeh oeeh.invoicedt and oeeh.enterdt
Note: Both Invoice Date and Enter Date are used when a Date Range is entered.
oeel oeel.invoicedt and oeel.enterdt
Note: Both Invoice Date and Enter Date are used when a Date Range is entered.
poeh poeh.enterdt
poel poel.enterdt
poelc poelc.costeddt
sasj sasj.postdt
wteh wteh.enterdt
wtel wtel.enterdt

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.