YDetailLookupTable

Last updated
Save as PDF

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.