JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

StandardLookupsLOV

Queries the list of valid codes and meanings for standard lookups, ensuring consistent use of reference data.

Columns

Name Type Description
LookupType [KEY] String The type of the lookup, categorizing the data and defining the group to which this lookup belongs (for example, status types, country codes).
LookupCode [KEY] String Unique identifier for the lookup value, used to reference a specific entry in the lookup table.
Meaning String The meaning or value description associated with the lookup code, providing context to what the code represents (for example, 'Active', 'Inactive').
Description String A detailed description of the lookup value, often explaining the context or usage of the code in business processes.
Tag String A tag associated with the lookup value, often used for categorization or additional metadata that can help identify related values.
ActiveDate Date The date on which the lookup value becomes active, indicating when the lookup is valid for use in the system.
Bind_ParentLookupCode String The lookup code of the parent lookup value, used to establish a relationship between this value and a broader lookup hierarchy.
Bind_ParentSetidDetermType String Type of the parent set ID determination, which defines how the parent lookup is linked to the child lookup in the system.
Bind_ParentSetidDetermValue String The value associated with the parent set ID determination, providing the specific reference for the lookup hierarchy relationship.
Bind_RelationshipId Long Unique identifier for the relationship between this lookup value and its parent, used to link and organize related lookup codes.
BindActiveDate Date The date on which the binding relationship between the parent and child lookup values becomes active.
BindLookupCode String The lookup code of the parent or related lookup value that is bound to this particular lookup, establishing a link.
BindLookupType String The type of lookup the parent lookup belongs to, used for identifying the nature of the parent lookup in the relationship.
BindTag String A tag associated with the binding of lookup values, providing additional metadata or categorization for the relationship.
Finder String Search or query reference related to the StandardLookupsLOV, potentially used for filtering or looking up specific lookup values.
NewLookupCode1 String Additional lookup code, typically used for tracking or referencing new or updated values in the lookup hierarchy.
NewLookupCode2 String Additional lookup code, typically used for tracking or referencing new or updated values in the lookup hierarchy.
NewLookupCode3 String Additional lookup code, typically used for tracking or referencing new or updated values in the lookup hierarchy.
NewLookupCode4 String Additional lookup code, typically used for tracking or referencing new or updated values in the lookup hierarchy.
NewLookupCode5 String Additional lookup code, typically used for tracking or referencing new or updated values in the lookup hierarchy.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434