Additional Table Information window: Fields

 


Primary Table

Displays the name of the table you selected in the Table Descriptions window. This table will be referred to as the primary table in the description of this window.

Secondary Table

Displays the tables related to the primary table you're viewing. These tables are called secondary tables. When you select a table, the type of relationship the primary table has to that table will be displayed in the Relationship Type field.

Secondary Table Key

Displays the key for the secondary table that contains a field or fields that also exist in the primary table.

Related Fields

Displays the fields that exist in both tables and are used for the table relationship. If you're importing data or creating an integrating application, be sure to review the related fields for all related tables. These fields must be updated for every record in the primary table so the data can be stored properly.

For instance, the Account Master Table links to many records in the Transaction Amounts Work Table. That table uses GL_TRX_LINE_WORK_Key2 to sort and store information, and the Account Number field is shared between the Account Number and the Transaction Amounts Work tables.

If you're importing date or updating tables, be sure you review all of the table relationships for any table you're working with. When updating or importing new records to a table, the appropriate information for those records must appear in all tables related to the primary table.

Relationship Type

Displays the type of relationship between the primary table and the secondary table (the table that the primary table is related to). There are two types of relationships tables may have with one another: a one-to-one relationship, or a one-to-many relationship.

A one-to-one relationship (indicated by "One Record" in the Relationship Type field) means that for every record in the primary table, there is one corresponding record in the secondary table. For instance, each record in the Account Master Table is related to only one record in the Account Summary History Table - a one-to-one relationship.

A one-to-many relation (indicated by "Many Records" in the Relationship Type field) means that for every record in the primary table, there can be more than one record in the secondary table. For example, an invoice header table contains only the name and number of each invoice, while the invoice line item table contains the items on each invoice. Therefore, an invoice record in the header table will relate to many records, or items, in the line item table, indicating a one-to-many relationship.

Description

The information listed at the bottom of the Additional Table Information window briefly explains how the table is used, and provides additional information about the table.