LCountryItem contains information about the country items defined for contact addresses. This includes the name of the country item, tree position, and display order. This table represents the Country Item system lookup table.
Object: LCountryItem (L_COUNTRY_ITEM)
Attribute |
Database column name |
Field in UI |
End of path |
Bridge |
Links to object table: |
Data type |
Comments |
Commonly used in: |
|
Rules |
Temp/Wiz |
||||||||
childList--> |
n/a |
|
|
|
|
|
Do not apply. These lookup items cannot have a hierarchical structure. |
|
|
parent--> |
PARENT_ID (NUMBER) |
|
|
|
|
|
|
|
|
displayOrder |
DISPLAY_ORDER (NUMBER) |
Order |
x |
|
|
int |
The order in which the table items will be listed in the GUI, lowest number first. |
|
|
name |
NAME (VARCHAR2) (50) |
Item Name |
x |
|
|
string (50) |
The name of the country. |
|
|
primaryKey |
PRIMARY_KEY (NUMBER) |
|
x |
|
|
int |
The unique ID of the country list item. |
|
|
treePosition |
TREE_POSITION (VARCHAR2) (250) |
Tree Position |
x |
|
|
string (250) |
The unique four-character alphanumeric code that is created when the country list item is defined. |
|
|
version |
VERSION (NUMBER) |
|
x |
|
|
int |
Indicates how many times the country list item was updated. |
|
|