YDetailLookupItem
The lookup item hierarchy is handled by the attributes parent--> and childList-->. This table represents the item list displayed in the Custom Lookup Tables block on the Custom tab of the Lookup Tables screen, which are defined to be used for custom fields of type List.
Object: YDetailLookupItem (Y_DETAIL_LOOKUP_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 |
x |
Links to the list of all child items that belong to this lookup table item. |
||||||
display |
DISPLAY _ORDER (NUMBER) |
Order (Lookup Tables, Custom tab) |
x |
int |
The order in which the item appears in the list. |
||||
isActive |
IS_ACTIVE (NUMBER) |
boolean | |||||||
name |
NAME (VARCHAR2) (50) |
Item Name (Lookup Tables, Custom |
x |
string (50) |
The name of the lookup item. |
||||
parent--> |
PARENT_ID (NUMBER) |
In node: (drop- down list, Lookup Tables, Custom tab) |
x |
object |
Links to the parent item of this lookup table item. |
||||
primaryKey |
PRIMARY_KEY (NUMBER) |
x |
int |
The unique ID of the custom lookup item. |
|||||
table-- > |
TABLE_ID (NUMBER) |
Show items belonging to (drop- down list, Lookup Tables, Custom tab) |
x |
object |
Links to the lookup table to which this lookup item belongs. |
||||
treePosition |
TREE_POSITION (VARCHAR2) (250) |
Tree |
x |
string (250) |
The unique four- character alphanumeric code that is created when the lookup item is defined. |
||||
version |
VERSION (NUMBER) |
x |
int |
Indicates how many times the lookup item has been updated. |