In order to search in TGP Resources for all information about a field as well as its SQL code, follow the following guide.
STEP 1: #
In the search box: enter either the table name or the physical name. Then, click the blue physical name to see the details.
STEP 2: #
The system will display all the field names with display names, data type, size, and the possible values.
STEP 3: #
Click on Show SQL and the window will transform to show you an SQL Statement with translated names and possible values calculated. It also converts Account Indexes to account numbers and names, and Note Indexes to text.
STEP 4: #
Press the Preview button to see a limited dataset using the new column names. Export to SQL and Create an SQL View, or copy the statement to the clipboard.