...
Sage 100 Technical Details – issues in more depth
Sage 100 Providex Dates – Adjusting date values on the ETL+ Design Page, – How to process ‘bad’ dates
Providex SQL Syntax – SQL syntax only for use on the ETL+ Extract SQL Statement Panel
ETL+ Load Replace with Date-time fields – special caution for Sage 100 users.
– Guide to finding SQL documentation in this reference manual.
PxPlus Documentation – Link to the reference manual itself
SQL syntax for Sage 100
SQL syntax to use in the ETL+ Extract SQL Statement Panel
...
https://help-sage100.na.sage.com/2022/FLOR/index.htm#File_Layouts/File_Layouts_Overview.htm?TocPath=File%2520Layouts%257C_____0 – Sage 100 database metadata / database guide. See File Layouts tab for details on each file/table.
Search: S100, Sage100, database guide, file layouts