Results for “ap_awt_temp_distributions_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AP_AWT_TEMP_DISTRIBUTIONS_ALL is a Payables (AP) module table in Oracle E-Business Suite, documented as VALID in the AP schema and titled "Withholding tax temporary distributions." It exists to hold the intermediate withholding tax calculation results generated during the Payables payment process for invoices subject to withholding tax (AWT) rules. Where the permanent withholding tax distributions are ultimately posted to the General Ledger, this table stores the temporary, process-scoped records that the withholding tax engine creates as it evaluates invoice lines, tax rates, and withholding groups against a given payment batch. It is populated and consumed during payment processing and withholding tax reporting, and its contents are specific to a selected payment run rather than being a long-lived transactional ledger in the ordinary sense.

From a data-modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is link. This is consistent with the table's role: it associates an invoice, a withholding group, a tax rate, an invoice payment, and a payment selection run, and it carries a small number of descriptive and amount-bearing attributes (gross amount, withholding amount, base withholding amount). Practically, the table functions as a transaction-level staging link, and its rows should be thought of as belonging to a processing run identified by CHECKRUN_NAME / CHECKRUN_ID.

Key Information Stored

The table is physically defined with 37 columns in the documented 12.2.2 schema. The most significant columns are:

• INVOICE_ID — the invoice to which the temporary withholding distribution relates; foreign key to AP_INVOICES_ALL.
• INVOICE_PAYMENT_ID — identifies the payment associated with the invoice; foreign key to AP_INVOICE_PAYMENTS_ALL.
• GROUP_ID — the withholding tax group applied; foreign key to AP_AWT_GROUPS.
• TAX_RATE_ID — the withholding tax rate used for the calculation; foreign key to AP_AWT_TAX_RATES_ALL.
• TAX_NAME — the descriptive name of the withholding tax.
• TAX_CODE_COMBINATION_ID — the accounting flexfield combination to which the withholding liability is coded; foreign key to GL_CODE_COMBINATIONS.
• GROSS_AMOUNT — the gross amount on which withholding tax is computed.
• WITHHOLDING_AMOUNT — the calculated withholding tax amount.
• BASE_WITHHOLDING_AMOUNT — the withholding amount expressed in the functional base currency.
• ACCOUNTING_DATE and PERIOD_NAME — the accounting date and GL period for the distribution.
• CHECKRUN_NAME and CHECKRUN_ID — identify the payment selection criteria run; both reference AP_INV_SELECTION_CRITERIA_ALL.
• PAYMENT_NUM — the payment number for the associated payment.
• ORG_ID — the operating unit, supporting multi-org access control.
• AWT_RELATED_ID — an internal identifier linking the temporary distribution to its related withholding context.

No surrogate primary key column is named in the documented metadata; the FK structure indicates the table is best keyed by the combination of invoice, payment, group, tax rate, and check run rather than by a single synthetic column. The GLOBAL_ATTRIBUTE_CATEGORY and GLOBAL_ATTRIBUTE1 through GLOBAL_ATTRIBUTE20 columns provide the standard EBS extensibility descriptor set.

Common Use Cases and Queries

Typical reporting use cases include reconciling withholding tax deducted on payments, auditing the tax amounts computed for a payment batch, and validating that the distribution was coded to the correct tax code combination before it posts to GL. A representative query joins the table to AP_INVOICES_ALL and GL_CODE_COMBINATIONS to list withholding amounts by check run:

• SELECT a.invoice_id, a.payment_num, a.tax_name, a.withholding_amount, a.period_name FROM ap_awt_temp_distributions_all a WHERE a.checkrun_name = :checkrun_name;
• Join to AP_AWT_GROUPS and AP_AWT_TAX_RATES_ALL to attribute withholding per group and rate.
• Join to GL_CODE_COMBINATIONS to verify the tax account assignment for auditor review.
• Aggregate BASE_WITHHOLDING_AMOUNT by ORG_ID and PERIOD_NAME for functional-currency withholding summaries.

Because rows are generated per payment processing run, reporting should always filter by CHECKRUN_ID or CHECKRUN_NAME rather than assuming persistent history.

Related Objects

• AP_INVOICES_ALL — via INVOICE_ID.
• AP_INVOICE_PAYMENTS_ALL — via INVOICE_PAYMENT_ID.
• AP_AWT_GROUPS — via GROUP_ID.
• AP_AWT_TAX_RATES_ALL — via TAX_RATE_ID.
• AP_INV_SELECTION_CRITERIA_ALL — via CHECKRUN_NAME and CHECKRUN_ID.
• GL_CODE_COMBINATIONS — via TAX_CODE_COMBINATION_ID.