The table name is AR_InvoiceHistoryHeader and AR_InvoiceHistoryDetail.  But if you do not have the software how do you expect to get the data out of them?

Here is a link to the "Table Listing":  https://help-sage100.na.sage.com/2021/FLOR/index.htm#File_and_Table_Listings/File_and_Table_Listings_Overview.htm?TocPath=File%2520and%2520Table%2520Listings%257C_____0

Here is a link to the Schema for AR Invoice History Tables:  https://help-sage100.na.sage.com/2021/FLOR/index.htm#File_Layouts/Accounts_Receivable/AR_InvoiceHistoryHeader.htm?TocPath=File%2520Layouts%257CAccounts%2520Receivable%257C_____66 

https://help-sage100.na.sage.com/2021/FLOR/index.htm#File_Layouts/Accounts_Receivable/AR_InvoiceHistoryDetail.htm?TocPath=File%2520Layouts%257CAccounts%2520Receivable%257C_____65

https://help-sage100.na.sage.com/2021/FLOR/index.htm#File_Layouts/Accounts_Receivable/AR_InvoiceHistoryLotSerial.htm?TocPath=File%2520Layouts%257CAccounts%2520Receivable%257C_____67

But without a copy of Sage 100 I don't see how you are going to be able to read the data in those tables.  

Depending on the version last installed, you may need ARN and ARO (ARN - invoice history header; ARO - invoice history detail).

Look in MAS90\WKSetup\ for a workstation installer.  Run that (crossing your fingers and toes that it will run on a modern operating system), including the workstation update, then log in (assuming you know an old MAS90 login / password).  After that you can use the SOTAMAS90 DSN to query the data from the raw tables.

Old framework table names can be found here:

https://help-sage100.na.sage.com/2020/FLOR/index.htm#Old_File_Names_to_New_File_Names_Listing/AR%20Old%20vs.%20New%20Names%20with%20Embeddeds.htm?TocPath=Cross%2520Reference%2520Information%257COld%2520File%2520Names%2520to%2520New%2520File%2520Names%2520Mappings%257C_____2

If you still have the MAS90 folder intact you can run it without the program.  

To Run Sage 100 Advanced from the ProvideX prompt:

1. In Windows Explorer, go to the server’s ..\MAS90\Home folder
2. Double-click Pvxwin32.exe
3. At the ProvideX prompt, type RUN “STARTUP.M4P”
   • Note: For MAS 90/200 versions 3.7x or below, type RUN “MAS90”
4. Press ENTER
5. Log into Sage 100

To create a “Sage 100 ERP Standard” shortcut icon: 

1. Make a copy of the Sage 100 ERP Advanced shortcut icon
2. Modify the following fields in the new icon (where X is the mapped drive letter, or C at the server):
3. Target:
   “X:\MAS90\Home\ Pvxwin32.exe” ..\Launcher\Sota.ini ..\SOA\Startup.m4p
4. Start In (quotes are required only if the path contains a space):

I can launch pvxwin32.exe.  I can see files with the names ARNSBP.SOA.  When I do a read record on it i can't line up the data with the table definition in the link you sent me.  I can't find an ARN table without the sbp.soa suffix.  

I also get a permissions error trying to run MAS90, although I am not sure I can run the whole application. All the IT people did was put the MAS90 folder on a test server, no install was done.  

If I can get a good set of file layouts I am pretty certain I can get the data.  I have 40+ years of writing in Open Basic, BBx, and Pvx.

Thanks

Try looking for M4T files instead.  2008 files might be v4.3, which might put AR in the new framework.

Column data in "old framework" files is not intuitive at all. (Note: old framework data files include the company code in the file name... so that could be the correct file name for company code SBP).

It would be best if you could try to run the workstation installer.  (Autorun, then WKSUpdate).  If it works, that should enable ODBC (if you can print / preview a report, then ODBC works)...

...and you might also get version specific help files installed too.  (I'm not sure if the workstation installer includes these or not).

Pretty sure A/R was moved to the new framework in Version 4.1

this might help: ARNSBP.SOA refers to ARN (A/R Invoice History Header) file for SBP company code  (detail file = AR0). ARNSBP.SOA would be legacy (non-business frameworks) A/R Invoice History Header file for the SBP company in Sage 100.  But that file could be left over from a prior migration/upgrade and you might still have the new version \MAS90\MAS_SBP\ARSBP\AR_InvoiceHistoryHeader.M4T file from a slightly newer version of MAS90 (now Sage 100).  Check if there is a MAS_SBP folder under \MAS90\ and if so is there a ARSBP folder under MAS_SBP, then you can look for the new file name and see the date, if it does not exist then it may be older installation that uses only the old ARN file. 

You should be able to open up Status.flp in Notepad to see the version number (in the ..\MAS90\SOA directory). It sounds like the old TRSG might be needed to see the structure of ARN and ARO if they can get them open in DFDM (isn't there still a version of that online somewhere?).

With the old versions I always have better luck just copying the MAS90 directory to a workstation, then run PVXWIN32.exe in Windows 7 compatibility mode - or something along those lines.

How about this for a blast from the past?