Search Results ap_awt_tax_rates_all




Overview
Explore in AI Chat

Overview

The AP_AWT_TAX_RATES_ALL table is a core data repository within the Oracle E-Business Suite Payables module, specifically for versions 12.1.1 and 12.2.2. It serves as the master table for storing withholding tax (AWT - Automatic Withholding Tax) rates. This table is fundamental for the system's ability to calculate, apply, and report on tax withholding amounts for supplier invoices and payments. Its multi-org structure, indicated by the "_ALL" suffix, allows it to store data for multiple operating units, making it a critical component for global financial implementations that must comply with diverse regional tax regulations.

Key Information Stored

The table's primary purpose is to define the applicable tax rates for withholding. Its structure, as inferred from the provided metadata, includes key identifiers and relational columns. The primary key is TAX_RATE_ID, which uniquely identifies each tax rate record. Essential foreign key columns establish relationships with other central entities: VENDOR_ID links to PO_VENDORS, VENDOR_SITE_ID links to PO_VENDOR_SITES_ALL, and INVOICE_NUM links to AP_INVOICES_ALL. These relationships enable the system to determine the correct withholding rate based on the specific supplier, supplier site, and transaction. While the full column list is not provided, typical data stored includes the effective tax rate percentage, effective start and end dates, associated tax authority, and the applicable income tax type.

Common Use Cases and Queries

This table is primarily accessed during invoice validation and payment processing to retrieve the correct withholding rate. Common operational and reporting scenarios include validating the tax rate applied to an invoice distribution and analyzing withholding tax liabilities by vendor or tax authority. A typical query to find the rate applied to a specific invoice distribution would join this table with the invoice distributions table. For auditing purposes, a report summarizing all active withholding tax rates by vendor site can be generated by querying this table and joining with vendor and vendor site tables, filtering on the effective date columns.

Related Objects

As documented in the ETRM metadata, AP_AWT_TAX_RATES_ALL has integral relationships with several other Payables and Purchasing tables. It is referenced as a foreign key by transaction tables such as AP_INVOICE_DISTRIBUTIONS_ALL (via AWT_TAX_RATE_ID) and AP_AWT_TEMP_DISTRIBUTIONS_ALL (via TAX_RATE_ID), which store the calculated withholding amounts. Conversely, it holds foreign keys to master data tables: PO_VENDORS, PO_VENDOR_SITES_ALL, and AP_INVOICES_ALL. This network of relationships ensures data integrity and enables the transactional flow from defining a tax rate to applying it on an invoice line and ultimately creating a tax withholding liability.