Search Results xtr_amount_types




Overview
Explore in AI Chat

Overview

The XTR_AMOUNT_TYPES table is a core reference data object within the Oracle E-Business Suite Treasury (XTR) module. It functions as a master repository that defines and controls the various monetary amounts associated with different treasury deal types. Its primary role is to establish a valid relationship between a specific DEAL_TYPE (e.g., Foreign Exchange, Money Market) and the AMOUNT_TYPEs (e.g., Principal, Interest, Settlement Amount) that are applicable and permissible for that deal. This table enforces data integrity and business rules by providing a controlled list of amount codes that can be used in transactional and accounting processes throughout the treasury lifecycle.

Key Information Stored

The table's structure is defined by a composite primary key consisting of DEAL_TYPE and AMOUNT_TYPE. The DEAL_TYPE column stores the code identifying a category of treasury transaction, such as a swap, forward, or deposit. The AMOUNT_TYPE column stores the specific code for a financial amount relevant to treasury operations. While the provided metadata does not list all columns, the table's description and foreign key relationships imply it likely contains descriptive columns (e.g., a name or description for the amount type) and potentially control attributes that govern how each amount type is processed, validated, or accounted for within the system.

Common Use Cases and Queries

This table is central to configuration, validation, and reporting. A common administrative use case is querying all valid amount types for a given deal type to set up or verify system parameters. For example: SELECT amount_type FROM xtr_amount_types WHERE deal_type = 'SWAP' ORDER BY amount_type;. From a reporting and data validation perspective, the table is frequently joined to transactional tables to retrieve meaningful descriptions for amount codes or to filter transactions by specific amount categories. Developers use this table to ensure that any custom processes or interfaces populate the AMOUNT_TYPE field with values sanctioned by this reference entity, thereby maintaining system integrity.

Related Objects

As indicated by the foreign key relationships, XTR_AMOUNT_TYPES is a parent table to several critical transactional and setup tables in the Treasury module. The XTR_DEAL_TYPES table is a parent to it, defining valid deal types. Key child tables that reference it include:

This network of relationships underscores the table's foundational role in ensuring consistent and rule-based processing of all financial amounts in Oracle Treasury.