Results for “jl_zz_ap_comp_awt_types”

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

Overview

The JL_ZZ_AP_COMP_AWT_TYPES table is a Latin America Localizations (JL) object within the Oracle E-Business Suite database, residing in the JL schema. It stores withholding applicability information per company and location, specifically supporting the withholding tax requirements for Argentina and Colombia. The table defines which withholding agents, tax authorities, and payment cities apply to a given legal entity and withholding type code, enabling the Payables module to calculate and report the correct withholding amounts during invoice and payment processing.

Based on the heuristic Data Vault classification mined from the foreign key structure, this object is modeled as a standalone entity, meaning it functions independently as a reference or setup table rather than participating in a hub, link, or satellite pattern. It carries its own primary key and a foreign key to FV_LEGAL_ENTITIES, positioning it as a descriptive configuration object keyed to the legal entity master.

Key Information Stored

The documented physical schema contains 28 columns. The most significant are listed below, distinguishing the surrogate primary key from business-key candidates.

• COMP_AWT_TYPE_ID — the surrogate primary key, defined by the unique index JL_ZZ_AP_COMP_AWT_TYPES_U1 and enforced through JL_ZZ_AP_COMP_AWT_TYPES_PK. It uniquely identifies each withholding applicability record.
• LEGAL_ENTITY_ID — foreign key to FV_LEGAL_ENTITIES; identifies the company to which the withholding configuration applies.
• AWT_TYPE_CODE — the withholding type code. Together with LEGAL_ENTITY_ID, this forms the business-key candidate JL_ZZ_AP_COMP_AWT_TYPES_U3.
• LOCATION_ID — the location associated with the withholding applicability record.
• WH_AGENT_FLAG — indicates whether the entity acts as a withholding agent.
• TAX_AUTHORITY_TYPE — identifies the tax authority governing the withholding.
• PAYMENT_CITY — the city where payment is made, relevant for local withholding rules.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield columns, providing extensibility for additional localization-specific attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — standard audit columns tracking record creation and modification.

The composite unique index on LEGAL_ENTITY_ID and AWT_TYPE_CODE guarantees that only one active configuration record exists per company and withholding type, which is essential for deterministic withholding calculation.

Common Use Cases and Queries

This table is primarily queried during Payables withholding setup validation, reconciliation of withholding configuration across legal entities, and localization audits for Argentina and Colombia. A typical query retrieves all withholding types defined for a given legal entity:

• SELECT AWT_TYPE_CODE, LOCATION_ID, WH_AGENT_FLAG, TAX_AUTHORITY_TYPE, PAYMENT_CITY FROM JL_ZZ_AP_COMP_AWT_TYPES WHERE LEGAL_ENTITY_ID = :p_legal_entity_id;
• Joining to the legal entity master to resolve company names: SELECT a.AWT_TYPE_CODE, b.NAME FROM JL_ZZ_AP_COMP_AWT_TYPES a, FV_LEGAL_ENTITIES b WHERE a.LEGAL_ENTITY_ID = b.LEGAL_ENTITY_ID;
• Identifying entities acting as withholding agents: SELECT LEGAL_ENTITY_ID, AWT_TYPE_CODE FROM JL_ZZ_AP_COMP_AWT_TYPES WHERE WH_AGENT_FLAG = 'Y';

Reporting scenarios include generating withholding configuration extracts for tax compliance reviews, verifying that each legal entity has the required withholding type codes before period close, and supporting data migration or implementation validation when localizing new operating units.

Related Objects

The relationships documented in the ETRM metadata, supplemented by standard localization dependencies, include the following significant objects.

• FV_LEGAL_ENTITIES — referenced by the LEGAL_ENTITY_ID foreign key; the parent master defining the legal entities to which withholding applicability is attached.
• JL_ZZ_AP_COMP_AWT_TYPES_PK — the primary key constraint on COMP_AWT_TYPE_ID.
• JL_ZZ_AP_COMP_AWT_TYPES_U1 — unique index enforcing the surrogate key.
• JL_ZZ_AP_COMP_AWT_TYPES_U3 — composite unique index on LEGAL_ENTITY_ID and AWT_TYPE_CODE, defining the business key.
• Oracle Payables withholding and tax setup components, including AP withholding tax type definitions, which consume the applicability data maintained in this table during invoice validation and payment processing.

Because the table is classified as standalone, it does not cascade into a network of dependent child tables; its principal integration point remains the legal entity master and the Payables localization logic that reads its configuration at runtime.