Sign Up for Training |
Jet Global Company Site
Community
Downloads
Training
Submit a Request
Become a Jet Insider
Give Feedback

Install Friendly Table/Field Names in a Universal Data Source


This information applies to the Jet Universal Connector (not Dynamics GP or NAV)

Jet Reports provides the ability to use Friendly Names if you are using a Universal Connector.  Often times the field and table names defined in your database are not as intuitive as you might wish.  Friendly Names gives you the ability to define your own names for the fields and tables in your database and then use them in Jet Reports.  In order to use this functionality you will need to add three tables to your database: JETFPG, JETTMAP, and JETFMAP and then configure your Jet Reports data source to use Friendly Names.

  1. JETFPG

    JETFPG holds the Friendly Name Group. Groups give you the ability to have multiple Friendly Names for a single table or field. This would be useful for translating your tables and fields into multiple languages.

    JETFPG table definition
    Field: FPG JETNAME
    Type: Integer VarChar
    Primary Key: Yes Yes
    Description: Number uniquely identifying the Friendly Name Group Name of Friendly Name Group
  2. JETMAP

    JETMAP maps the existing table name to a Friendly Name and Group

    JETMAP table definition
    Field: FPG TFN TPN
    Type: Integer VarChar VarChar
    Primary Key: Yes Yes No
    Description: Number uniquely identifying the Friendly Name Group Friendly Name of the Table Table Name as defined in the database (actual table name)
  3. JETFMAP

    JETFMAP maps the existing field name to the table it is on as well as the Friendly Name and Group

    JETFMAP table definition
    Field: FPG TPN FFN FPN
    Type: Integer VarChar VarChar VarChar
    Primary Key: yes Yes Yes No
    Description: Number uniquely identifying the Friendly Name Group Table name as defined in the database (actual table name) Friendly Field Name Field Name as defined in the database (actual field name)

Once these three tables have been added and populated with your desired Friendly Names you will be able to use either Friendly or Actual names in your Jet Reports.

Was this article helpful?
0 out of 0 found this helpful

Comments