Skip to main content
Mitratech Success Center

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

 

YDetailLookupItem

YDetailLookupItem contains information about custom lookup table items, such as the item's name, tree position, and display order.

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

YDetail
LookupItem

 

Links to the list of all child items that belong to this lookup table item.

   

display
Order

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 
tab)

x

   

string (50)

The name of the lookup item.

   

parent-->

PARENT_ID

(NUMBER)

In node: (drop- down list, Lookup Tables, Custom tab)

 

x

YDetail
LookupItem

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

YDetail
Lookup
Table

object

Links to the lookup table to which this lookup item belongs.

   

treePosition

TREE_POSITION

(VARCHAR2) (250)

Tree
Position
(Lookup Tables, Custom tab)

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.

   
  • Was this article helpful?