Results for “goods_code”
2 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view JE_NL_INVOICE_VALIDATION belongs to the Oracle E-Business Suite European Localizations module (product code JE). It exists to expose the Netherlands-specific invoice validation attributes that are maintained within the JG_ZZ_INVOICE_INFO table so that localization-driven validation and reporting logic can access them through a stable, named interface. The view presents a vertical-to-horizontal projection: three descriptive flexfield style attributes (JGZZ_INVOICE_INFO1, JGZZ_INVOICE_INFO10, and JGZZ_INVOICE_INFO11) are renamed into business-meaningful columns — PAYMENT_CATEGORY_CODE, GOODS_CODE, and PAYMENT_NATURE — alongside the INVOICE_ID that ties each row back to the originating invoice. In the context of Oracle EBS 12.1.1 and 12.2.2, the view supports Netherlands statutory invoice requirements, where payment category, goods classification, and payment nature must be captured and validated against invoice records. It is documented in ETRM as not implemented in the reference database, meaning the view text is captured for reference rather than deployed in every environment; it appears only where the relevant localization is installed.
Underlying Base Objects
The view is defined over a single documented base object: JG_ZZ_INVOICE_INFO. No additional base tables or views are documented in the ETRM metadata. The view performs a straightforward column-renaming SELECT against that table, capturing INVOICE_ID directly and mapping JGZZ_INVOICE_INFO11, JGZZ_INVOICE_INFO10, and JGZZ_INVOICE_INFO1 to PAYMENT_NATURE, GOODS_CODE, and PAYMENT_CATEGORY_CODE respectively. Because the underlying storage is a generic invoice-info table in which the Netherlands localization attributes are held in numbered JGZZ_INVOICE_INFO segments, the view supplies the semantic layer over that storage. There is no join, aggregation, or filtering logic documented, so referential integrity and uniqueness are inherited entirely from JG_ZZ_INVOICE_INFO.
Key Columns
- INVOICE_ID — The invoice identifier linking the localization attributes to the corresponding invoice record; serves as the join key to AP and localization invoice tables.
- PAYMENT_CATEGORY_CODE — Sourced from JGZZ_INVOICE_INFO1; classifies the invoice according to the Dutch payment category scheme required for reporting and validation.
- GOODS_CODE — Sourced from JGZZ_INVOICE_INFO10; identifies the goods classification associated with the invoice line or header.
- PAYMENT_NATURE — Sourced from JGZZ_INVOICE_INFO11; describes the nature of the payment for statutory categorization purposes.
Each attribute column is a free-form informational segment as stored, so consumers should apply the corresponding value set or lookup validation appropriate to the localization when interpreting the codes.
Common Use Cases and Queries
Typical use cases include Netherlands tax and statutory reporting, pre-validation of invoices before posting, and reconciliation of localization attributes against voucher data. A minimal query retrieving all validation attributes for a given invoice is:
SELECT invoice_id, payment_category_code, goods_code, payment_nature FROM je_nl_invoice_validation WHERE invoice_id = :p_invoice_id;SELECT payment_category_code, COUNT(*) FROM je_nl_invoice_validation GROUP BY payment_category_code;— summarizes invoices by payment category for reporting.SELECT v.invoice_id, v.payment_nature FROM je_nl_invoice_validation v WHERE v.goods_code IS NULL;— identifies invoices missing required goods classification.
Because the view is documented as not implemented in the reference database, availability must be confirmed in the target instance before these queries are relied upon in concurrent programs, reports, or integration extracts.
-
Not implemented in this database·Explore JE module →
-
Not implemented in this database·Explore JE module →