Common
System Types Table Lookup
Use this page to Add a Lookup Table Manually.
To access this page:
- Select
- Click the Tables icon for a System Type.
- Click the Fields icon for a Table Name.
- Click a lookup table name in the LOOKUP TABLE column.
NOTE: Excel Integration has been enabled on this page. Refer to Use Excel Integration for more information.
|
Field |
Description |
|
System Type |
Displays the name of the external system. |
|
Table Name |
Displays table name within the System Type. |
|
Description |
Displays brief description of the table. |
|
Description Table |
|
|
Description Table |
Displays the name of the table that stores the descriptions for the values in the value table. |
|
Description Table Field ID |
Displays the name of the column that stores the descriptions for the values in the value table. |
|
Description Table Key Field |
Displays the key column on the Description table used to uniquely identify values if the Description table key is different from the Value table's key column. This field is used by the T006 table. NOTE: If this field is blank, the Description Table Key uses the Value Table Key. |
|
Description Table Client Field |
Displays the column on the Description Table that stores the Client or Tenant of the data. Used with SAP only. |
|
Description Table Language Field |
Displays the column on the Description Table that stores the language identifier column. Used with SAP only. |
|
Lookup Table |
|
|
Lookup Table Type |
Displays an option indicating whether fields in the lookup table should be value mapped. |
|
Lookup Table Field |
Displays the key in the lookup table |
|
Lookup Table Field 2 |
Displays the second key in a lookup table with a multipart key. |
|
Lookup Table Field 3 |
Displays the third key in a lookup table with a multipart key. |
|
Lookup Table Field 4 |
Displays the fourth key in a lookup table with a multipart key. |
|
Lookup Table Field 5 |
Displays the fifth key in a lookup table with a multipart key. |
|
Lookup Table Client Field |
Displays the column on the lookup table that stores the Client or Tenant of the data. Used with SAP only. |
|
Lookup Table Language Field |
Displays the column on the lookup table that stores the language identifier column. Used with SAP only. |
|
Multi Value Field Lookup Table Value Field |
Displays the column containing the value to use if more than one value table column is set for the value table (for example, there is data in the Check Table Field 1 and Check Table Field 2 field).This is the actual field that will be loaded into the target table |
|
Lookup Table Where Clause |
Displays the where clause used to filter values in the lookup table column to restrict the values used in the lookup table. |
