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.

 

YDetailLookupTable

YDetailLookupTable contains information about custom lookup tables, such as the name and unique code. This table links to YDetailLookupItem for the root lookup item. This table represents the Custom Lookup Tables block on the Custom tab of the Lookup Tables screen.

Object: YDetailLookupTable (Y_DETAIL_LOOKUP_TABLE)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

               

Rules

Temp/Wiz

name

NAME

(VARCHAR2) (50)

Show items belonging to (Lookup Tables, Custom tab)

x

   

string (50)

The name of the custom lookup table.

   

primaryKey

PRIMARY_KEY
 

(NUMBER)

  x    

int

Unique ID for the custom lookup table.

   

rootItem-->

ROOT_ITEM_ID
 

(NUMBER)

   

x

YDetail
LookupItem

object

Links to the information about the root node in the lookup table, such as its name and its child items.

   

unique
Code

UNIQUE_CODE
 

(VARCHAR) (4)

Unique Code
(Lookup Tables, Custom tab)

x

   

string (4)

Four-character alphanumeric code that uniquely identifies the lookup table.

   

version

VERSION
 

(NUMBER)

 

x

   

int

Indicates how many times the lookup table has been updated.

   
  • Was this article helpful?