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

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.