Search Results zx_evnt_cls_typs




Overview
Explore in AI Chat

Overview

The ZX_EVNT_CLS_TYPS table is a core reference table within the ZX (E-Business Tax) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It serves as a master repository for defining and storing the specific types of taxable events that can occur within the application. Each record in this table represents a unique tax event type, which is always associated with a broader tax event class. This table is critical for the tax determination engine, as it provides the foundational classification for all transactional activities that may have tax implications. It is important to note that this table contains seeded data only, meaning its content is delivered and maintained by Oracle; custom rows should not be inserted by implementations.

Key Information Stored

The table's structure is defined by a composite primary key that ensures uniqueness for each event type within its class. The key columns are TAX_EVENT_CLASS_CODE and TAX_EVENT_TYPE_CODE. The TAX_EVENT_CLASS_CODE acts as a foreign key to the ZX_EVENT_CLASSES_B table, linking the event type to its parent classification (e.g., Purchase Invoice, Sales Invoice, AR Invoice). The TAX_EVENT_TYPE_CODE defines the specific event variant within that class. While the provided metadata does not list descriptive columns, such as NAME or DESCRIPTION, these are typically stored in related TL (translatable) tables. The table's primary role is to establish a controlled, valid list of event type and class code combinations for the system to reference.

Common Use Cases and Queries

The primary use case is tax setup and reporting, where this table is joined to transactional data to understand the tax context of a document line. A common query pattern involves listing all valid event types for a given class to verify setup or for integration purposes. For instance, to find all event types within the 'PURCHASE_INVOICE' class, one might execute:

  • SELECT tax_event_type_code FROM zx_evnt_cls_typs WHERE tax_event_class_code = 'PURCHASE_INVOICE';

In reporting scenarios, this table is frequently joined to the ZX_LINES table to enrich tax line reports with the event classification. Troubleshooting tax determination failures often involves verifying that the transaction's event class and type code pair exists in this reference table.

Related Objects

ZX_EVNT_CLS_TYPS is centrally connected to several key E-Business Tax tables. It references the ZX_EVENT_CLASSES_B table via its TAX_EVENT_CLASS_CODE column to validate the parent event class. More significantly, its primary key is referenced by multiple transactional and setup tables, establishing it as a key parent entity. The documented foreign key relationships are:

  • ZX_EVNT_TYP_MAPPINGS: References (TAX_EVENT_CLASS_CODE, TAX_EVENT_TYPE_CODE). This table maps event types to tax regimes and other tax options.
  • ZX_LINES_DET_FACTORS: References (TAX_EVENT_CLASS_CODE, TAX_EVENT_TYPE_CODE). This table stores determining factors used in tax calculation for specific event types.
  • ZX_LINES: References (TAX_EVENT_CLASS_CODE, TAX_EVENT_TYPE_CODE). This is the core transactional table storing all calculated tax lines, directly linking each line to its event classification.

These relationships underscore the table's role in ensuring data integrity across the tax engine's configuration and transaction processing layers.

  • Table: ZX_EVNT_CLS_TYPS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVNT_CLS_TYPS,  object_name:ZX_EVNT_CLS_TYPS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax event types. Each row in this table stores a tax event type for a tax event class. This table contains seeded data only. ,  implementation_dba_data: ZX.ZX_EVNT_CLS_TYPS , 

  • Table: ZX_EVNT_CLS_TYPS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVNT_CLS_TYPS,  object_name:ZX_EVNT_CLS_TYPS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax event types. Each row in this table stores a tax event type for a tax event class. This table contains seeded data only. ,  implementation_dba_data: ZX.ZX_EVNT_CLS_TYPS , 

  • Table: ZX_EVENT_CLASSES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVENT_CLASSES_B,  object_name:ZX_EVENT_CLASSES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax event classes. This table contains seeded data only. ,  implementation_dba_data: ZX.ZX_EVENT_CLASSES_B , 

  • Table: ZX_EVENT_CLASSES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVENT_CLASSES_B,  object_name:ZX_EVENT_CLASSES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax event classes. This table contains seeded data only. ,  implementation_dba_data: ZX.ZX_EVENT_CLASSES_B , 

  • Table: ZX_EVNT_TYP_MAPPINGS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVNT_TYP_MAPPINGS,  object_name:ZX_EVNT_TYP_MAPPINGS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores mappings of application event types to tax event types for all event classes mapped to tax event classes in ZX_EVNT_CLS_MAPPINGS. This table contains seeded data only. ,  implementation_dba_data: ZX.ZX_EVNT_TYP_MAPPINGS , 

  • Table: ZX_EVNT_TYP_MAPPINGS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVNT_TYP_MAPPINGS,  object_name:ZX_EVNT_TYP_MAPPINGS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores mappings of application event types to tax event types for all event classes mapped to tax event classes in ZX_EVNT_CLS_MAPPINGS. This table contains seeded data only. ,  implementation_dba_data: ZX.ZX_EVNT_TYP_MAPPINGS , 

  • Table: ZX_LINES 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES,  object_name:ZX_LINES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores detail tax lines for transactions of multiple event classes. ,  implementation_dba_data: ZX.ZX_LINES , 

  • Table: ZX_LINES 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES,  object_name:ZX_LINES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores detail tax lines for transactions of multiple event classes. ,  implementation_dba_data: ZX.ZX_LINES , 

  • Table: ZX_LINES_DET_FACTORS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES_DET_FACTORS,  object_name:ZX_LINES_DET_FACTORS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores transaction related attributes used for tax calculation and reporting. Each row stores a trasnaction line of an event class. ,  implementation_dba_data: ZX.ZX_LINES_DET_FACTORS , 

  • Table: ZX_LINES_DET_FACTORS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES_DET_FACTORS,  object_name:ZX_LINES_DET_FACTORS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores transaction related attributes used for tax calculation and reporting. Each row stores a trasnaction line of an event class. ,  implementation_dba_data: ZX.ZX_LINES_DET_FACTORS ,