[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ZX_EVNT_CLS_MAPPINGS |
|---|---|
| Object Type: | TABLE |
| Owner: | ZX |
| FND Design Data: |  ZX.ZX_EVNT_CLS_MAPPINGS
|
| Subobject Name: | |
| Status: | VALID |
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ZX_EVNT_CLS_MAPPINGS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 EVENT_CLASS_MAPPING_ID
|
| ZX_EVNT_CLS_MAPPINGS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
EVENT_CLASS_CODE
APPLICATION_ID
ENTITY_CODE
|
| Name | Datatype | Length | Mandatory | 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 | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| 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 | (15) | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_CLASS_CODE
, APPLICATION_ID
, ENTITY_CODE
, TAX_EVENT_CLASS_CODE
, RECORD_FLAG
, DET_FACTOR_TEMPL_CODE
, DEFAULT_ROUNDING_LEVEL_CODE
, ROUNDING_LEVEL_HIER_1_CODE
, ROUNDING_LEVEL_HIER_2_CODE
, ROUNDING_LEVEL_HIER_3_CODE
, ROUNDING_LEVEL_HIER_4_CODE
, ALLOW_MANUAL_LIN_RECALC_FLAG
, ALLOW_OVERRIDE_FLAG
, ALLOW_MANUAL_LINES_FLAG
, PERF_ADDNL_APPL_FOR_IMPRT_FLAG
, SHIP_TO_PARTY_TYPE
, SHIP_FROM_PARTY_TYPE
, POA_PARTY_TYPE
, POO_PARTY_TYPE
, PAYING_PARTY_TYPE
, OWN_HQ_PARTY_TYPE
, TRAD_HQ_PARTY_TYPE
, POI_PARTY_TYPE
, POD_PARTY_TYPE
, BILL_TO_PARTY_TYPE
, BILL_FROM_PARTY_TYPE
, TTL_TRNS_PARTY_TYPE
, MERCHANT_PARTY_TYPE
, SHIP_TO_PTY_SITE_TYPE
, SHIP_FROM_PTY_SITE_TYPE
, POA_PTY_SITE_TYPE
, POO_PTY_SITE_TYPE
, PAYING_PTY_SITE_TYPE
, OWN_HQ_PTY_SITE_TYPE
, TRAD_HQ_PTY_SITE_TYPE
, POI_PTY_SITE_TYPE
, POD_PTY_SITE_TYPE
, BILL_TO_PTY_SITE_TYPE
, BILL_FROM_PTY_SITE_TYPE
, TTL_TRNS_PTY_SITE_TYPE
, ENFORCE_TAX_FROM_ACCT_FLAG
, OFFSET_TAX_BASIS_CODE
, REFERENCE_APPLICATION_ID
, PROD_FAMILY_GRP_CODE
, ALLOW_OFFSET_TAX_CALC_FLAG
, SELF_ASSESS_TAX_LINES_FLAG
, TAX_RECOVERY_FLAG
, ALLOW_CANCEL_TAX_LINES_FLAG
, ALLOW_MAN_TAX_ONLY_LINES_FLAG
, TAX_VARIANCE_CALC_FLAG
, ENABLE_MRC_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TAX_REPORTING_FLAG
, ENTER_OVRD_INCL_TAX_LINES_FLAG
, CTRL_EFF_OVRD_CALC_LINES_FLAG
, SUMMARIZATION_FLAG
, RETAIN_SUMM_TAX_LINE_ID_FLAG
, RECORD_FOR_PARTNERS_FLAG
, MANUAL_LINES_FOR_PARTNER_FLAG
, MAN_TAX_ONLY_LIN_FOR_PTNR_FLAG
, ALWAYS_USE_EBTAX_FOR_CALC_FLAG
, PROCESSING_PRECEDENCE
, EVENT_CLASS_MAPPING_ID
, ENFORCE_TAX_FROM_REF_DOC_FLAG
, PROCESS_FOR_APPLICABILITY_FLAG
, DISPLAY_USER_KEY1_FLAG
, DISPLAY_USER_KEY2_FLAG
, DISPLAY_USER_KEY3_FLAG
, DISPLAY_USER_KEY4_FLAG
, DISPLAY_USER_KEY5_FLAG
, DISPLAY_USER_KEY6_FLAG
, ALLOW_EXEMPTIONS_FLAG
, SUP_CUST_ACCT_TYPE_CODE
, DISPLAY_TAX_CLASSIF_FLAG
, INTGRTN_DET_FACTORS_UI_FLAG
, INTRCMP_TX_EVNT_CLS_CODE
, INTRCMP_SRC_ENTITY_CODE
, INTRCMP_SRC_EVNT_CLS_CODE
, INTRCMP_SRC_APPLN_ID
FROM ZX.ZX_EVNT_CLS_MAPPINGS;
ZX.ZX_EVNT_CLS_MAPPINGS does not reference any database object
ZX.ZX_EVNT_CLS_MAPPINGS is referenced by following:
APPS
ZX_EVNT_CLS_MAPPINGS
|
|
|
|