Show/Hide Toolbars

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.