Search Results vat_code

Overview

The view AX_AP_TAXABLE_V belongs to the AX - Global Accounting Engine product family within Oracle E-Business Suite. It is a reporting and integration view that consolidates the taxable amount associated with tax and withholding invoice distributions on Payables invoices. Specifically, the view aggregates the amounts of charge distributions that have been allocated to tax or withholding lines, exposing both the taxable amount and the taxable base amount for each tax-bearing distribution.

The view is of particular interest to implementers and developers searching for the tax_code_id column, since TAX_CODE_ID is one of the four grouping keys returned by the view alongside INVOICE_ID, INVOICE_DISTRIBUTION_ID, and VAT_CODE. The Global Accounting Engine uses objects of this type to feed downstream accounting and reporting logic, and the view is documented as not implemented in the database, meaning it is provided as reference metadata rather than as an instantiated database object in every environment.

Underlying Base Objects

The view is defined over three underlying objects, all documented in the view text:

• AP_INVOICE_DISTRIBUTIONS_ALL AID — the source of the charge (item) distributions whose amounts are being summed.
• AP_CHRG_ALLOCATIONS_ALL ACA — the allocation table that links an item distribution (ITEM_DIST_ID) to a charge distribution (CHARGE_DIST_ID).
• AP_INVOICE_DISTRIBUTIONS_ALL AID2 — a second alias of the invoice distributions table, representing the tax or withholding distribution onto which the charge amounts are allocated.

The join path is AID.INVOICE_DISTRIBUTION_ID = ACA.ITEM_DIST_ID and ACA.CHARGE_DIST_ID = AID2.INVOICE_DISTRIBUTION_ID, with the constraint that AID2.LINE_TYPE_LOOKUP_CODE be either 'TAX' or 'AWT' (withholding tax). The view therefore sits directly on top of the core Payables distribution and charge allocation tables, with no intermediate objects documented.

Key Columns

• INVOICE_ID — identifier of the Payables invoice to which the taxable distribution belongs.
• INVOICE_DISTRIBUTION_ID — identifier of the tax or withholding distribution (the AID2 record) against which the allocated taxable amounts are grouped.
• TAX_CODE_ID — the tax code identifier associated with the tax distribution; this is the column most commonly targeted by reporting queries and is the object of the user's search.
• VAT_CODE — the VAT code associated with the distribution, exposed alongside the tax code for reporting and reconciliation.
• L_TAXABLE_AMOUNT — the sum of the allocated charge distribution amounts (SUM(AID.AMOUNT)), representing the taxable amount.
• L_TAXABLE_BASE_AMOUNT — the sum of NVL(AID.BASE_AMOUNT, AID.AMOUNT), providing the base amount used for tax computation, defaulting to the entered amount where no base amount is recorded.

Common Use Cases and Queries

Typical uses include reconciling taxable amounts against tax distributions on invoices, validating how charges were allocated to tax and withholding lines, and retrieving the tax code associated with a distribution for integration or reporting purposes. A representative query is shown below.

• Retrieve taxable amounts by tax code:

  SELECT tax_code_id,
         invoice_id,
         invoice_distribution_id,
         vat_code,
         l_taxable_amount,
         l_taxable_base_amount
  FROM   ax_ap_taxable_v
  WHERE  tax_code_id = :p_tax_code_id;

• Aggregate taxable base per invoice for a given VAT code:

  SELECT invoice_id,
         SUM(l_taxable_base_amount) total_base
  FROM   ax_ap_taxable_v
  WHERE  vat_code = :p_vat_code
  GROUP  BY invoice_id;

• Join to AP_INVOICES_ALL or AP_INVOICE_DISTRIBUTIONS_ALL to enrich the aggregated taxable figures with invoice-level attributes.

Because the view returns aggregated amounts, it is best used for summarisation and reconciliation rather than line-level transaction entry.