There are three tables shown under POA 8.1A-8.1B using GridView: IR Detail History Composite, IR Detail History Additional,and IR Detail History. What is the difference between the three? I'm pretty sure the Detail History has everything I need but in the future??

Hi Mike,

The 'IR Detail History Composite' is a combination of both the 'IR Detail History' and 'IR Detail History Additional'. The 'additional' file contains only fields related to integration with Adagio JobCost. If you do not use Adagio JobCost with Purchase Orders, then both the 'IR Detail History' and 'Composite' tables are effectively the same. 'Composite' tables are a conglomeration of two or more related tables and will always have the most information available.

If you want to investigate what fields a GridView dictionary table contains, you can use the DataDictionaryExporter.exe utility to create an Excel spreadsheet for a specific dictionary, and every table is on a separate sheet - with a field listing, data file names, translation lookup tables and more. If you use GridView regularly and create views, this is an invaluable tool to locate where fields are stored in the dictionary.

1-IR Detail History - PO Details with DOS JobCost Info
2-IR Detail History Additional - Adagio JobCost Info
3-IR Detail History Composite - All fields from 1 & 2

If no Job Cost then all you need is 1

Thanks for the info. I should have checked first - I had the tables open in Excel too. Went back and checked. Discovered I had the wrong table (needed IR Details Master instead). But what does the 'det' prefix stand for?

Thanks
Mike