Supported tables for Data Lake
This table shows the Distribution SX.e database tables that can be extracted for the Infor Data Lake when you run the SA Administrator Birst Extraction Report using the Extract Type of DataLake.
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.
| Table | Date Field | Table | Date Field |
|---|---|---|---|
| ADDON | OEEH* | oeeh.enterdt | |
| AODATA | addon.transdt | OEEHA | |
| APEI | OEEHC | ||
| APET | apet.invdt | OEEHP | |
| APETA | OEEL* | oeel.enterdt | |
| APSF | OEELK | ||
| APSP | OEELM | ||
| APSS | PDENH | ||
| APSV | PDENL | ||
| ARET | aret.invdt | PDER | |
| ARETP | PDERV | ||
| ARETT | PDSC | ||
| ARSA | PDSN | ||
| ARSC | PDSR | ||
| ARSD | PDSRA | ||
| ARSG | PDST | ||
| ARSL | POEH* | poeh.enterdt | |
| ARSS | POEL* | poel.enterdt | |
| ARST | POELC* | poelc.costeddt | |
| CARRIER | POELO | ||
| CCRECOVER | POER | ||
| CMSP | POERAH | ||
| CRERR | POERAL | ||
| COM | PTXQUEUE | ||
| CONTACTS | PV_PDSPS | ||
| CONTACTROLES | PV_USER | ||
| CRET | RSAO | ||
| CRSB | SABS | ||
| EDSV | SALS | ||
| EMPMST | SASC | ||
| GDPRCTRL | SASGT | ||
| GLEE | SASJ | sasj.postdt | |
| GLET* | glet.postdt | SASOO | |
| GLETV | SASTA | ||
| GLSA | SASTAZ | ||
| GLSB | SASTN | ||
| ICENH | SLED | ||
| ICET | SMSN | ||
| ICETI | VAEH | ||
| ICSC | VAES | ||
| ICSD | VENDADDR | ||
| ICSEC | VENMST | ||
| ICSEG | WEBEXTENSION | ||
| ICSEI | WEBMODIFICATION | ||
| ICSEL | WEBNOTE | ||
| ICSES | WHMST | ||
| ICSEU | WTEH | ||
| ICSL | WTEL | ||
| ICSP | WTELO | ||
| ICSPC | |||
| ICSPR | |||
| ICSS | |||
| ICSW | |||
| ICSWU | |||
| KPET | |||
| KPSG | |||
| KPSK | |||
| KPSO | |||
| MMEXTRACT | |||
| NOTES | notes.transdt |