Search Results iby_accttype




Overview
Explore in AI Chat

Overview

The IBY_ACCTTYPE table is a core reference data object within the Oracle E-Business Suite Payments module (IBY). It serves as a master repository for defining the distinct categories of financial accounts that the system supports. Its primary role is to standardize and control the classification of payment instruments, such as bank accounts and credit cards, across the entire application. By maintaining a centralized list of valid account types, it ensures data integrity and consistency for payment processing, reporting, and bank account setup. This table is fundamental to the configuration of payment methods and the storage of bank and credit card details.

Key Information Stored

The table's structure is designed to be a simple but critical lookup. The central column is ACCTTYPEID, which serves as the unique primary key identifier for each account type record. While the specific column list is not fully detailed in the provided metadata, the description indicates that each record would logically store a descriptive name (e.g., 'Checking', 'Savings', 'Visa', 'MasterCard') and potentially a code. The table acts as a parent reference for the specific account type values stored in related transactional and setup tables, enforcing referential integrity through its primary key constraint (IBY_ACCTTYPE_PK).

Common Use Cases and Queries

This table is primarily referenced during setup and reporting activities. A common use case is validating or listing all available account types when configuring a new bank account or credit card in the system. For reporting, it is frequently joined to transactional tables to translate numeric ACCTTYPEID keys into meaningful descriptions. A typical query would involve joining IBY_ACCTTYPE to a table like IBY_BANKACCT to produce a readable report.

  • Sample Query: Retrieve all internal bank accounts with their account type description.
    SELECT ba.bank_account_name, ba.bank_account_num, at.account_type_name
    FROM iby_bankacct ba, iby_accttype at
    WHERE ba.accttypeid = at.accttypeid;
  • Data Validation: The table is used to populate list of values (LOVs) in the Oracle EBS user interface for fields requiring an account type selection.

Related Objects

The IBY_ACCTTYPE table has defined relationships with several key tables in the Payments module, as indicated by its foreign key constraints. The IBY_BANKACCT table references it to classify internal bank accounts. The IBY_CREDITCARD table references it to specify the brand (Visa, MasterCard) of a stored credit card. Furthermore, the IBY_ACCPPMTMTHD (Account and Payment Method) table references it, linking specific account types to configured payment methods. These relationships underscore its role as a central reference point for classifying payment instruments throughout the IBY schema.