Help Center
Table of Contents
< All Topics

How do I use the search?

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.

~ Oate: Feb : SQL Select table 101 , trE%YPE , CA ! IIEHrYPE ELSE , )• DECPLQrY ce(DECPLQTY,ø))) , | Index) Shipping

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.

Previous How do I activate TGP Interpret?
Categories