Results for “jl_co_gl_nits_u2”

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

Overview

The JL.JL_CO_GL_NITS table is a foundational reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the JL (Oracle Latin America Localizations) schema. Its primary function is to store Third Party Identifier information, which is critical for tax reporting and compliance, particularly in Latin American locales where specific taxpayer identification formats are used (such as the NIT in Colombia or RFC in Mexico). The table acts as a central repository for defining and validating external entities—such as suppliers, customers, or other payees—that interact with the financials system.

According to the documented metadata, this table is classified as hub-leaning in a Data Vault modeling context. This heuristic suggests that JL_CO_GL_NITS serves as a central business entity key repository. In Data Vault terms, it functions as a Hub, where the NIT_ID acts as the surrogate hash key, and the NIT column represents the unique business key. The table is automatically populated by the Third Party Balances program; if a taxpayer identifier does not exist during processing, a new row is inserted. Users can subsequently maintain this information via the Third Party Maintenance window.

Key Information Stored

The table contains 26 columns, but the most critical data points revolve around identification and categorization of third-party entities. The primary surrogate key is NIT_ID, a system-generated sequence number. The business-key candidate is NIT, a VARCHAR2(14) column holding the actual Taxpayer Identifier. A unique index, JL_CO_GL_NITS_U2, enforces the uniqueness of this identifier. Additionally, VERIFYING_DIGIT stores the validation digit used to mathematically verify the integrity of the NIT.

Descriptive attributes include TYPE (VARCHAR2(30)), which categorizes the third party (e.g., Supplier, Customer, or Legal Entity), and NAME (VARCHAR2(360)), which holds the full legal name of the third party. Standard Who Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN) are present to support auditing and concurrency control. The table also includes ten Descriptive Flexfield (DFF) columns (ATTRIBUTE1 through ATTRIBUTE15 as documented, though only up to 15 are typically available in this structure) and an ATTRIBUTE_CATEGORY column to define the structure, allowing for future extensibility without schema modification.

Common Use Cases and Queries

The primary use case for JL_CO_GL_NITS is to facilitate tax reporting and third-party balance reconciliation. The ETRM metadata highlights that the Third Party Balances program auto-inserts rows for new identifiers, making this table a staging ground for tax compliance data. A common reporting query would join this table to transaction or balance tables to aggregate financial data by tax ID.

For example, to retrieve a list of all third parties with their verifying digits and types, a query similar to the following is used:

SELECT n.nit_id, n.nit, n.verifying_digit, n.name, n.type
FROM jl.jl_co_gl_nits n
WHERE n.type = 'SUPPLIER'
ORDER BY n.name;

In a reconciliation scenario, one might join this table to JL_CO_GL_BALANCES or JL_CO_GL_TRX using the NIT_ID to generate tax reports. The uniqueness of the NIT column ensures data integrity when importing external data files. Since the table contains DFF columns, reporting queries often include the ATTRIBUTE_CATEGORY to filter for specific regional attributes, such as special tax regimes or withholding classifications.

Related Objects

The JL_CO_GL_NITS table is central to the Latin American localizations and is referenced by several transaction and balance tables via foreign keys on the NIT_ID column. The most significant related objects include:

• JL_CO_GL_BALANCES: This table stores third-party balance information and references NIT_ID to associate balances with the correct taxpayer identifier.
• JL_CO_GL_MG_LINES: This table contains magnetic media generation lines, used for tax reporting to local authorities. It joins to JL_CO_GL_NITS via NIT_ID to retrieve the taxpayer details required for reporting formats.
• JL_CO_GL_TRX: This table holds transaction information and also uses NIT_ID as a foreign key to link transactions to third-party entities.

These relationships, along with the unique indexes JL_CO_GL_NITS_U1 (on NIT_ID) and JL_CO_GL_NITS_U2 (on NIT), ensure that all downstream tax and balance processing correctly identifies and aggregates data for each unique taxpayer.