ZX_EVNT_CLS_MAPPINGS
This table stores mappings of tax event classes to application event classes of Oracle Applications.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
ZX_EVNT_CLS_MAPPINGS_PK |
EVENT_CLASS_MAPPING_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Application event class code | |
| APPLICATION_ID | NUMBER | Yes | Application identifier | ||
| ENTITY_CODE | VARCHAR2 | 30 | Yes | Entity code for this application event class | |
| TAX_EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Tax event class code | |
| RECORD_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether tax lines for this event class are recorded in the tax repository | |
| DET_FACTOR_TEMPL_CODE | VARCHAR2 | 30 | Yes | Determining factor template to be used for tax regime determination for this event class | |
| DEFAULT_ROUNDING_LEVEL_CODE | VARCHAR2 | 30 | Yes | Lookup code to indicate the default level of rounding for this event class. Possible values are LINE and HEADER. | |
| ROUNDING_LEVEL_HIER_1_CODE | VARCHAR2 | 30 | Lookup code to indicate the first precedence for level of rounding for this event class | ||
| ROUNDING_LEVEL_HIER_2_CODE | VARCHAR2 | 30 | Lookup code to indicate the second precedence for level of rounding for this event class | ||
| ROUNDING_LEVEL_HIER_3_CODE | VARCHAR2 | 30 | Lookup code to indicate the third precedence for level of rounding for this event class | ||
| ROUNDING_LEVEL_HIER_4_CODE | VARCHAR2 | 30 | Lookup code to indicate the fourth precedence for level of rounding for this event class | ||
| ALLOW_MANUAL_LIN_RECALC_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates if the tax is recalculated for manually entered tax lines of this event class | |
| ALLOW_OVERRIDE_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates if the user is allowed to override tax calculated by the system for this event class | |
| ALLOW_MANUAL_LINES_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates if the user is allowed to manually eneter tax lines for this event class | |
| PERF_ADDNL_APPL_FOR_IMPRT_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates if additional applicability is performed for imported documents of this event class | |
| SHIP_TO_PARTY_TYPE | VARCHAR2 | 30 | Source of the ship to party for this event class | ||
| SHIP_FROM_PARTY_TYPE | VARCHAR2 | 30 | Source of the ship from party for this event class | ||
| POA_PARTY_TYPE | VARCHAR2 | 30 | Source of the point of acceptance party for this event class | ||
| POO_PARTY_TYPE | VARCHAR2 | 30 | Source of the point of order party for this event class | ||
| PAYING_PARTY_TYPE | VARCHAR2 | 30 | Source of the paying party for this event class | ||
| OWN_HQ_PARTY_TYPE | VARCHAR2 | 30 | Source of the own HQ party for this event class | ||
| TRAD_HQ_PARTY_TYPE | VARCHAR2 | 30 | Source of the trading HQ party for this event class | ||
| POI_PARTY_TYPE | VARCHAR2 | 30 | Source of the point of inventory party for this event class | ||
| POD_PARTY_TYPE | VARCHAR2 | 30 | Source of the point of destination party for this event class | ||
| BILL_TO_PARTY_TYPE | VARCHAR2 | 30 | Source of the bill to party for this event class | ||
| BILL_FROM_PARTY_TYPE | VARCHAR2 | 30 | Source of the bill from party for this event class | ||
| TTL_TRNS_PARTY_TYPE | VARCHAR2 | 30 | Source of the title transfer party for this event class | ||
| MERCHANT_PARTY_TYPE | VARCHAR2 | 30 | Source of the merchant party for this event class | ||
| SHIP_TO_PTY_SITE_TYPE | VARCHAR2 | 30 | Source of the ship to party site for this event class | ||
| SHIP_FROM_PTY_SITE_TYPE | VARCHAR2 | 30 | Source of the ship from party site for this event class | ||
| POA_PTY_SITE_TYPE | VARCHAR2 | 30 | Source of the point of acceptance party site for this event class | ||
| POO_PTY_SITE_TYPE | VARCHAR2 | 30 | Source of the point of order party site for this event class | ||
| PAYING_PTY_SITE_TYPE | VARCHAR2 | 30 | Source of the paying party site for this event class | ||
| OWN_HQ_PTY_SITE_TYPE | VARCHAR2 | 30 | Source of the own HQ party site for this event class | ||
| TRAD_HQ_PTY_SITE_TYPE | VARCHAR2 | 30 | Source of the trading HQ party site for this event class | ||
| POI_PTY_SITE_TYPE | VARCHAR2 | 30 | Source of the point of inventory party site for this event class | ||
| POD_PTY_SITE_TYPE | VARCHAR2 | 30 | Source of the point of destination party site for this event class | ||
| BILL_TO_PTY_SITE_TYPE | VARCHAR2 | 30 | Source of the bill to party site for this event class | ||
| BILL_FROM_PTY_SITE_TYPE | VARCHAR2 | 30 | Source of the bill from party site for this event class | ||
| TTL_TRNS_PTY_SITE_TYPE | VARCHAR2 | 30 | Source of the title transfer party site for this event class | ||
| ENFORCE_TAX_FROM_ACCT_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether the tax associated with the natural account segment is enforced for this event class | |
| OFFSET_TAX_BASIS_CODE | VARCHAR2 | 30 | Lookup code for tax basis used in offset tax calculation for this event class | ||
| REFERENCE_APPLICATION_ID | NUMBER | Not currently used | |||
| PROD_FAMILY_GRP_CODE | VARCHAR2 | 30 | Yes | Lookup code to indicate the product family of this event class. Possible values are P2P and O2C | |
| ALLOW_OFFSET_TAX_CALC_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether offset taxes are determined for this event class. This is applicable only if this event class belongs to the procure to pay product family | |
| SELF_ASSESS_TAX_LINES_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether the self assessment is done for this event class. This is applicable only if this event class belongs to the procure to pay product family | |
| TAX_RECOVERY_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether tax recovery is determined for this event class | |
| ALLOW_CANCEL_TAX_LINES_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether the user can be allowed to cancel tax lines for this event class. This is applicable only if this event class belongs to the procure to pay product family | |
| ALLOW_MAN_TAX_ONLY_LINES_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates if the user is allowed to manually enter tax only lines for this event class. This is applicable only if this event class belongs to the procure to pay product family | |
| TAX_VARIANCE_CALC_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates if tax variances are determined for this event class | |
| ENABLE_MRC_FLAG | VARCHAR2 | 1 | Yes | Not currently used | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| TAX_REPORTING_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates if tax needs to be reported for this event class | |
| ENTER_OVRD_INCL_TAX_LINES_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether the user is allowed to enter or override inclusive tax lines for this event class | |
| CTRL_EFF_OVRD_CALC_LINES_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates if all impacted system tax lines are recalculated for this event class, when there is an override on a inclusive tax line | |
| SUMMARIZATION_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates if summary tax lines are determined for this event class | |
| RETAIN_SUMM_TAX_LINE_ID_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether existing summary tax line identifier is retained for this event class | |
| RECORD_FOR_PARTNERS_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether this event class is recorded in repositories of external service providers | |
| MANUAL_LINES_FOR_PARTNER_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether for this event class, the user is allowed to manually enter tax lines for tax regimes subscribed to external service providers | |
| MAN_TAX_ONLY_LIN_FOR_PTNR_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether for this event class, the user is allowed to manually enter tax only lines for tax regimes subscribed to external service providers | |
| ALWAYS_USE_EBTAX_FOR_CALC_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether eBusiness Tax always determines taxes for this event class inspite of any subscriptions to external service providers | |
| PROCESSING_PRECEDENCE | NUMBER | Order in which this event class is processed for tax calculation, when multiple event classes are processed at the same time | |||
| EVENT_CLASS_MAPPING_ID | NUMBER | 18 | Yes | Event class mapping identifier | |
| ENFORCE_TAX_FROM_REF_DOC_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether this event class checks that tax name on the event class line is same as tax name on the corresponding reference document line. | |
| PROCESS_FOR_APPLICABILITY_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether taxes should be automatically calculated for this event class or not | |
| DISPLAY_USER_KEY1_FLAG | VARCHAR2 | 1 | Y or N indicates if user key 1 is displayed on Additional Tax Information page/window for this event class | ||
| DISPLAY_USER_KEY2_FLAG | VARCHAR2 | 1 | Y or N indicates if user key 2 is displayed on Additional Tax Information page/window for this event class | ||
| DISPLAY_USER_KEY3_FLAG | VARCHAR2 | 1 | Y or N indicates if user key 3 is displayed on Additional Tax Information page/window for this event class | ||
| DISPLAY_USER_KEY4_FLAG | VARCHAR2 | 1 | Y or N indicates if user key 4 is displayed on Additional Tax Information page/window for this event class | ||
| DISPLAY_USER_KEY5_FLAG | VARCHAR2 | 1 | Y or N indicates if user key 5 is displayed on Additional Tax Information page/window for this event class | ||
| DISPLAY_USER_KEY6_FLAG | VARCHAR2 | 1 | Y or N indicates if user key 6 is displayed on Additional Tax Information page/window for this event class | ||
| ALLOW_EXEMPTIONS_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether exemptions are allowed for this event class | |
| SUP_CUST_ACCT_TYPE_CODE | VARCHAR2 | 30 | Lookup code to indicate whether the third party information represents supplier or customer for this event class. Possible values are SUPPLIER and CUSTOMER. | ||
| DISPLAY_TAX_CLASSIF_FLAG | VARCHAR2 | 1 | Y or N indicates if tax classification code is displayed on Additional Tax Information page/window for this event class | ||
| INTGRTN_DET_FACTORS_UI_FLAG | VARCHAR2 | 1 | Y or N indicates if this event class is integrated with the Additional Tax Information page/window | ||
| INTRCMP_TX_EVNT_CLS_CODE | VARCHAR2 | 30 | Intercompany tax event class code for this event class | ||
| INTRCMP_SRC_ENTITY_CODE | VARCHAR2 | 30 | Intercompany source document entity code for this event class | ||
| INTRCMP_SRC_EVNT_CLS_CODE | VARCHAR2 | 30 | Intercompany source document event class code for this event class | ||
| INTRCMP_SRC_APPLN_ID | NUMBER | Intercompany source document application identifier for this event class | |||
| ALLOW_TAX_PARAM_EXTN_FLAG | VARCHAR2 | 1 | Y or N indicates whether tax parameter extension is allowed for this event class | ||
| ALLOW_USER_API_EXTN_FLAG | VARCHAR2 | 1 | Y or N indicates whether user api extension is allowed for this event class | ||
| LOGICAL_TAX_POINT_BASIS | VARCHAR2 | 30 | Logical Tax Point Basis for this event class. | ||
| REF_EVENT_CLASS_CODE | VARCHAR2 | 30 | Reference Event Class to which the user defined event class is mapped. | ||
| ACCT_REP_TREATMENT_CODE | VARCHAR2 | 30 | Column to indicate accounting and reporting treatment for the external transactions. | ||
| INCLUSIVE_TREATMENT_CODE | VARCHAR2 | 30 | Column to indicate if item distribution needs to be adjusted for inclusive tax calculation. | ||
| INDIRECT_TAX_OR_WHT_FLAG | VARCHAR2 | 1 | Indicates whether the event class mapping is for indirect tax (I) or withholding tax (W). | ||
| ENFORCE_TAX_POINT_BASIS_FLAG | VARCHAR2 | 1 | Yes or No indicates whether all tax lines should have the same tax point basis as the logical tax point basis on event class. | ||
| ENABLE_CALC_FOR_JRNL_LN_FLAG | VARCHAR2 | 1 | Yes or No indicates if tax calculation for journal lines is enabled. | ||
| ENABLE_INCL_TAX_CALC_FLAG | VARCHAR2 | 1 | Indicates whether inclusive tax calculation will be performed for an event class. Valid values: Y and N. | ||
| WHT_CALC_POINT_FLAG | VARCHAR2 | 1 | Point at which withholding tax is applied. Possible values are I for invoice, P for payment, B for both, and N for never. | ||
| DEFAULTING_TEMPLATE_CODE | VARCHAR2 | 30 | Indicates the defaulting template associated with an application event class. | ||
| TAX_AUTH_INV_CREATION_POINT | VARCHAR2 | 30 | Point at which a withholding tax authority invoice is created. Possible values are I for invoice and P for payment. | ||
| WHT_CASH_DISCOUNT_APPL_FLAG | VARCHAR2 | 1 | Indicates whether the discount amount is included in withholding tax calculation. Valid values: Y and N. | ||
| TRX_TAX_WHT_APPLICABILITY_FLAG | VARCHAR2 | 1 | Indicates whether the tax amount is included in the withholding tax calculation. Valid values: Y and N. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ZX_EVNT_CLS_MAPPINGS | zx_event_classes_b | EVENT_CLASS_CODE |
| ZX_EVNT_CLS_MAPPINGS | zx_event_classes_b | INTRCMP_TX_EVNT_CLS_CODE |
| ZX_EVNT_CLS_MAPPINGS | zx_det_factor_templ_b | DET_FACTOR_TEMPL_CODE |
| zx_event_class_params | zx_evnt_cls_mappings | EVENT_CLASS_MAPPING_ID |
| zx_lines_det_factors | zx_evnt_cls_mappings | EVENT_CLASS_MAPPING_ID |
| zx_evnt_typ_mappings | zx_evnt_cls_mappings | EVENT_CLASS_MAPPING_ID |
| zx_product_options_all | zx_evnt_cls_mappings | EVENT_CLASS_MAPPING_ID |
| zx_rules_b | zx_evnt_cls_mappings | EVENT_CLASS_MAPPING_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_EVNT_CLS_MAPPINGS_U1 | Unique | Default | EVENT_CLASS_MAPPING_ID, ORA_SEED_SET1 |
| ZX_EVNT_CLS_MAPPINGS_U11 | Unique | Default | EVENT_CLASS_MAPPING_ID, ORA_SEED_SET2 |
| ZX_EVNT_CLS_MAPPINGS_U2 | Unique | Default | EVENT_CLASS_CODE, APPLICATION_ID, ENTITY_CODE, INDIRECT_TAX_OR_WHT_FLAG, ORA_SEED_SET1 |
| ZX_EVNT_CLS_MAPPINGS_U21 | Unique | Default | EVENT_CLASS_CODE, APPLICATION_ID, ENTITY_CODE, INDIRECT_TAX_OR_WHT_FLAG, ORA_SEED_SET2 |