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 Data Extraction for Data Lake and Birst using the Extract Type of DataLake.
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.
| Table | Date field | Table | Date field |
|---|---|---|---|
| ACTIVITIES | OEEH* | oeeh.enterdt | |
| ADDON* | addon.transdt | OEEHA | |
| AODATA | OEEHC | ||
| APEBA | OEEHCH | ||
| APEBC | OEEHEXTRA | ||
| APEI | OEEHP | ||
| APEIA | OEEHTA | ||
| APEID | OEEL* | oeel.enterdt | |
| APEIG | OEELEXTRA | ||
| APET* | apet.invdt | OEELK | |
| APETA | OEELM | ||
| APSF | ORDDTL | ||
| APSP | ORDER_TYPE | ||
| APSS | ORDHDR | ||
| APSV | ORDHDR_STATUS | ||
| ARET* | aret.invdt | OTEH | |
| ARETP | OTEPH | ||
| ARETT | OTEPL | ||
| ARSA | OTEVH | ||
| ARSC | OTEVL | ||
| ARSD | PALLETDET | ||
| ARSDE | PALLETMST | ||
| ARSG | PDENH | ||
| ARSL | PDENL | ||
| ARSP | PDER | ||
| ARSPT | PDERV | ||
| ARSRT | PDSC | ||
| ARSS | PDSM | ||
| ARST | PDSN | ||
| BDED | PDSR | ||
| BDET | PDSRA | ||
| BDSC | PDST | ||
| BDSR | PDSV | ||
| BDST | PDSVC | ||
| BINMST | PICK | ||
| CARRIER | POEH* | poeh.enterdt | |
| CARTONDTL | POEL* | poel.enterdt | |
| CARTONMST | POELA | ||
| CCRECOVER | POELC* | poelc.costeddt | |
| CMSP | POELO | ||
| COM | POER | ||
| CONTACTS | POERAH | ||
| CONTACTS-ROLES | POERAL | ||
| COUNTHISTORY | PRODCAT | ||
| CRERR | PTXQUEUE | ||
| CRET | PV_PDSPS | ||
| CRSB | PV_USER | ||
| CYCLE_CNT | RSAO | ||
| DEPMST | RT_TYPE | ||
| EDSBWC | RTMST | ||
| EDSV | SABS | ||
| EMPMST | SALS | ||
| EQUATECART | SASB | ||
| GDPRCTRL | SASC | ||
| GLEB | SASGT | ||
| GLEE | SASJ* | sasj.postdt | |
| GLET* | glet.postdt | SASOO | |
| GLETV | SASTA | ||
| GLSA | SASTAZ | ||
| GLSB | SASTC | ||
| ICECNDTL | SASTN | ||
| ICECNHDR | SASTP | ||
| ICECNSERLOT | SLED | ||
| ICENH | SMSC | ||
| ICENL | SMSEH | ||
| ICET | SMSEP | ||
| ICETI | SMSEW | ||
| ICETL | SMSN | ||
| ICETS | SMSP | ||
| ICSC | SMSS | ||
| ICSCN | SMSV | ||
| ICSD | SMSVP | ||
| ICSDP | SMSVW | ||
| ICSEC | SMSW | ||
| ICSEF | SUPPLIERACCESSHDR | ||
| ICSEG | TASK | ||
| ICSEH | TASK_EMP | ||
| ICSEI | TAXTABLE | ||
| ICSEL | TRANS_TYPE | ||
| ICSES | TRANSACTIONS | ||
| ICSEU | VAEH | ||
| ICSL | VAELO | ||
| ICSOU | VAES | ||
| ICSP | VAESL | ||
| ICSPC | VENDADDR | ||
| ICSPE | VENDDETAIL | ||
| ICSPR | VENMST | ||
| ICSS | WAVE | ||
| ICSV | WEBEXTENSION | ||
| ICSW | WEBMODIFICATION | ||
| ICSWB | WEBNOTE | ||
| ICSWU | WH_ZONE | ||
| INVENTORY | WHMST | ||
| ITEM | WMET | ||
| JURTAX | WMSB | ||
| KPET | WMSBP | ||
| KPSG | WTEH | ||
| KPSK | WTEL | ||
| KPSO | WTELO | ||
| MMEXTRACT | WTERAH | ||
| NOTES* | notes.transdt | WTERAL |