Finding B1 UI Field Labels for Database Fields Without Tedious Mapping

[jun_dolor]

I need to map the SAP Business One database fields to their corresponding labels as they appear in the B1 client UI. For instance, in the Sales Quotation form, the field OQUT.CardCode is labeled as Customer in the UI.

I know I can use View > System Information to see this information, but with the number of fields across various tables, this approach feels a bit... overwhelming.

Is there a reference, document, or method to retrieve all these mappings in a more efficient way? 

[Felipe_Lima]

Hi.

The query SELECT * FROM SDIS retrieves all changes to the default labels. I couldn't find a way to retrieve the original names apart from using Query Generator, but you'll have to do it for every single table. The names are stored in the system files rather than the database. UI and DI-API documentation do not supply it either. So I think this is only achievable via SDK.

[msundararaja_perumal]

Dear @jun_dolor,

If you have installed SDK, then look for SDK help file, it describes the tables with field name, field description and its functionality. This will show only that are exposed in Business One.

Thanks.