Search Results taxable_vat_amt




Overview
Explore in AI Chat

Overview

The JE_IT_LIST_PARTIES_ALL table resides in the JE schema and belongs to the JE - European Localizations product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the summary extract data used to produce the Italian Annual Supplier and Customer listing (the Elenco Clienti e Fornitori), a statutory periodic communication that Italian tax authorities require from VAT-registered entities. Each row represents a summarized position for a given party (customer or supplier) for a specific reporting period, capturing aggregated transaction amounts separated into taxable, non-taxable, exempt, and VAT components, together with any corresponding credit memo (CM) amounts.

The object is documented as a standalone table with a single foreign key to the VAT reporting entity. Under the heuristic Data Vault classification mined from the FK structure, it can be modeled as a satellite attached to a hub or link representing the reporting period, party, and reporting entity. It is not itself a hub or link: it carries descriptive and additive measures that describe a party's aggregated position rather than defining a business entity.

Key Information Stored

Of the 27 documented columns, the most significant are the following. The table does not expose an explicit surrogate primary key in the documented metadata; candidate business keys are the combination of PERIOD_NAME, ORG_ID, PARTY_ID, VAT_REPORTING_ENTITY_ID, and YEAR_OF_DECLARATION, which together uniquely identify a party's position for a reporting entity in a given period and declaration year.

Common Use Cases and Queries

The primary use case is the generation and reconciliation of the annual Italian customer and supplier listing. Extract programs populate this table by aggregating transactions for the reporting year, and reporting tools read it back to produce the file transmitted to the tax authority. A typical query retrieves all parties for a declaration year and reporting entity:

SELECT PARTY_ID, VAT_REGISTRATION_NUM, FISCAL_ID_NUM,
       TAXABLE_AMT, VAT_AMT, NON_TAXABLE_AMT, EXEMPT_AMT,
       CM_TAXABLE_AMT, CM_VAT_AMT
FROM   JE.JE_IT_LIST_PARTIES_ALL
WHERE  YEAR_OF_DECLARATION = :year
AND    VAT_REPORTING_ENTITY_ID = :entity_id
ORDER BY PARTY_SEQUENCE_NUM;

Additional scenarios include reconfirming that taxable and VAT amounts net correctly after credit memos, comparing period-over-period positions for the same PARTY_ID, and auditing rows by TRANSMISSION_NUM to confirm which submission a given summary was part of.

Related Objects

  • JG_ZZ_VAT_REP_ENTITIES — referenced by JE_IT_LIST_PARTIES_ALL.VAT_REPORTING_ENTITY_ID; defines the reporting entities eligible for the declaration.
  • JE_IT_LIST_PARTIES_LINES_ALL — the corresponding detail line table that feeds the summarized amounts held here.
  • JE_IT_LIST_EXTRACTION_GT and related extraction global temporary tables — staging structures used by the extract concurrent programs that populate this table.
  • Italian localization concurrent programs and the annual listing report — depend on this table for their output.
  • Tax reporting views supplied with the JE product family — used for submission file generation and reconciliation.

Because the table is a satellite rather than a defining entity, joins are typically made from the reporting entity, the period, and the party, with the summary rows aggregated at those granularities.