Search Results je_it_list_lines_all




Overview
Explore in AI Chat

Overview

The JE_IT_LIST_LINES_ALL table resides in the JE schema and belongs to the Oracle E-Business Suite European Localizations module (product code JE). It stores the detail-level extract data used to produce the Italian Annual Supplier and Customer Listing (the Elenchi Intrastat-adjacent "Spesometro"-style annual communication of VAT-relevant transactions to the Italian tax authority). Each row represents a single reporting line derived from a source transaction or transaction distribution, capturing the taxable base, VAT amount, and classification attributes required by the Italian declaration format.

From a Data Vault modeling perspective, the mined foreign-key structure suggests this object behaves as a satellite (or, given the presence of descriptive measure columns tied to a transaction grain, potentially a link-satellite hybrid). It carries descriptive and financial attributes rather than serving as a pure hub of business keys, which supports treating it as a satellite dependent on a transaction-party link.

Key Information Stored

The table contains 34 documented columns at the 12.2.2 schema level. The most operationally significant columns are:

The documented metadata does not identify an explicit single-column surrogate primary key; business-key candidates would naturally comprise the combination of PERIOD_NAME, ORG_ID, TRX_ID, TRX_DIST_ID, and YEAR_OF_DECLARATION, which together should uniquely identify a reported line.

Common Use Cases and Queries

The table is queried primarily for Italian annual listing reporting, reconciliation against subledger transactions, and audit of VAT declaration amounts. Typical SQL patterns filter by declaration year, operating unit, and party:

  • Extracting declaration lines for a given year and operating unit: SELECT * FROM JE.JE_IT_LIST_LINES_ALL WHERE YEAR_OF_DECLARATION = :year AND ORG_ID = :org_id;
  • Summarizing VAT by party: SELECT PARTY_ID, SUM(TAXABLE_AMT) taxable, SUM(VAT_AMT) vat FROM JE.JE_IT_LIST_LINES_ALL WHERE YEAR_OF_DECLARATION = :year GROUP BY PARTY_ID;
  • Reconciling credit-memo corrections against originals by joining on TRX_DIST_ID and comparing CM_* amounts to base amounts.
  • Reporting by VAT reporting entity: SELECT VAT_REPORTING_ENTITY_ID, SUM(TAXABLE_VAT_INV_AMT) FROM JE.JE_IT_LIST_LINES_ALL GROUP BY VAT_REPORTING_ENTITY_ID;

Related Objects

The foreign-key metadata anchors this table to the following related objects:

  • IGI_EXP_TRX_TYPE — referenced via JE_IT_LIST_LINES_ALL.TRX_TYPE_ID = IGI_EXP_TRX_TYPE.TRX_TYPE_ID; classifies transaction types.
  • JG_ZZ_VAT_REP_ENTITIES — referenced via JE_IT_LIST_LINES_ALL.VAT_REPORTING_ENTITY_ID = JG_ZZ_VAT_REP_ENTITIES.VAT_REPORTING_ENTITY_ID; defines the VAT reporting entity.
  • Related JE Italian localization extract objects (header-level listing tables and concurrent program output) consume the lines produced here.
  • Underlying subledger sources such as AP/AR transaction and distribution tables supply the TRX_ID and TRX_DIST_ID values used for drill-down.