Search Results vat_code




Overview
Explore in AI Chat

Overview

The AP_TAX_CODES_ACTIVE_V view is a Payables (AP) reporting object that exposes the set of tax codes currently available for transaction entry within a given set of books. Its primary purpose is to present a filtered, human-readable list of tax codes — including the VAT code name, tax type, rate, and effective dates — while suppressing codes that are inactive or that are reserved for internal use. The view is of particular interest to implementers searching for the term "vat_code," because its first column, VAT_CODE, is the alias under which the underlying AP_TAX_CODES.NAME value is surfaced. In the ETRM documentation this view is annotated as "(Release 10SC Only)" and, in the documented metadata, carries no recorded owner and no documented base objects; the documentation also states that the object is "Not implemented in this database." Consequently, the view should be understood primarily from its published view text rather than from live data-dictionary evidence, and it should be treated as a legacy or non-deployed object within the 12.1.1 / 12.2.2 environments described.

Underlying Base Objects

Although the ETRM metadata records no base objects, the view text identifies four source tables joined in a single query. The driving table is AP_TAX_CODES, aliased TC, which stores the tax code definitions. AP_LOOKUP_CODES (LC) provides the displayed tax-type description through the TAX TYPE lookup type. AP_SYSTEM_PARAMETERS (SP) supplies the set-of-books context and the REQUIRE_TAX_ENTRY_FLAG setting. Finally, PO_VENDOR_SITES (VS) contributes the offset tax flag and vendor site identifier. The joins enforce lookup validation on tax type, restrict the query to tax codes belonging to the same set of books as the system parameters, and apply conditional logic so that "USE" tax types are excluded when tax entry is mandatory. Because the metadata lists no documented referenced base objects, this join structure should be verified against the target instance before reliance.

Key Columns

  • VAT_CODE — the tax code name sourced from TC.NAME; this is the alias that drives "vat_code" searches.
  • TAX_TYPE_DISPLAY — the user-facing description of the tax type from AP_LOOKUP_CODES.DISPLAYED_FIELD.
  • DESCRIPTION — the tax code description.
  • TAX_TYPE — the internal tax type code.
  • TAX_RATE — the applicable tax rate.
  • OFFSET_TAX_FLAG — indicates whether the code is an offset tax, sourced from PO_VENDOR_SITES.
  • VENDOR_SITE_ID — the associated vendor site identifier.
  • TAX_ID — the unique tax code identifier.
  • START_DATE and INACTIVE_DATE — the effective and expiry dates of the tax code.

Common Use Cases and Queries

The view supports reporting on active tax codes for a set of books, validating VAT codes prior to invoice entry, and populating list-of-values or integration extracts. A representative query is:

SELECT VAT_CODE, TAX_TYPE_DISPLAY, TAX_RATE, START_DATE, INACTIVE_DATE
FROM AP_TAX_CODES_ACTIVE_V
WHERE VAT_CODE LIKE :vat_code
ORDER BY VAT_CODE;

Because the object is documented as not implemented, this query should be validated against the target database, and, where the view is absent, equivalent logic may be reconstructed directly from AP_TAX_CODES and its supporting lookups.