Default Column Sequence
How does Acumatica take the alphabetic list of columns generated when selecting all table columns in the generic inquiry builder to whatever gets displayed in the generic inquiry viewer? For example, while trying to figure out the columns to join two tables, I typically dump the data and model the join in Excel. That worked great, but I still could not determine the Acumatica column names without guessing since the columns do not display in the sequence listed in the generic inquiry builder and I don't see a way to find the column name.
The Data Access Class (DAC) layer sits between the Database and the front-end. The DAC is what converts the field name from the Database name to the front-end name. It also picks up any language translation that you do and uses that name instead of the default name.
You can override the default column names on the front-end by setting the Caption value on the RESULTS GRID tab of the Generic Inquiry definition screen.