ZX_EVNT_CLS_OPTIONS
This table stores tax options for application event classes. Each row contains tax options defined by a first party organization for an application event class.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ZX_EVNT_CLS_OPTIONS_PK |
EVENT_CLASS_OPTIONS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EVENT_CLASS_OPTIONS_ID | NUMBER | 18 | Yes | Unique identifier | |
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Application event class code | |
| APPLICATION_ID | NUMBER | Yes | Application identifier | ||
| ENTITY_CODE | VARCHAR2 | 30 | Yes | Entity code for the application event class | |
| 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 | |
| USE_ROUNDED_AMT_FOR_CONV_FLAG | VARCHAR2 | 1 | Enables the use of rounded transaction currency tax amounts for currency conversion to functional currency and/or tax currency. If this value is set, the Tax Regime level setting will be used to determine the currency types, if any, for which rounded tax amounts should be used for currency conversion. | ||
| EFFECTIVE_FROM | DATE | Yes | Effective from date | ||
| EFFECTIVE_TO | DATE | Effective to date | |||
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates if the tax options setup is enabled for this event class and first party organization | |
| FIRST_PTY_ORG_ID | NUMBER | 18 | Yes | Party tax profile identifier for first party organization | |
| 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 | ||
| TAX_TOLERANCE | NUMBER | Tax tolerance percentage for this event class | |||
| TAX_TOL_AMT_RANGE | NUMBER | Tax tolerance range amount for this event class | |||
| RECORD_TYPE_CODE | VARCHAR2 | 30 | Yes | Lookup code to indicate whether the record is migrated, seeded or defined by the user | |
| 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 | |
| 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. | ||
| 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 | |
| PROCESS_FOR_APPLICABILITY_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether taxes should be automatically calculated for this event class or not | |
| 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. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| ALLOW_EXEMPTIONS_FLAG | VARCHAR2 | 1 | Y or N indicates whether exemptions are allowed for this event class | ||
| EXMPTN_PTY_BASIS_HIER_1_CODE | VARCHAR2 | 30 | Lookup code to indicate the first level of exemption party basis hierarchy for this event class | ||
| EXMPTN_PTY_BASIS_HIER_2_CODE | VARCHAR2 | 30 | Lookup code to indicate the second level of exemption party basis hierarchy for this event class | ||
| DEF_INTRCMP_TRX_BIZ_CATEGORY | VARCHAR2 | 240 | Default intercompany transaction business category code 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 | ||
| TAX_VARIANCE_CALC_FLAG | VARCHAR2 | 1 | Y or N indicates if Tax Variance needs to be determined for this event class. | ||
| DEF_TAX_POINT_BASIS | VARCHAR2 | 30 | Default Tax Point Basis for this event class. | ||
| 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 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. | ||
| ALLOW_REC_CNSGN_RCPT_FLAG | VARCHAR2 | 1 | Indicates whether tax recovery is allowed on consignment receipts. 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. | ||
| 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. | ||
| ERROR_HANDLING_MODE | VARCHAR2 | 1 | Attribute to capture the error handling mode. | ||
| CALC_VARIANCE_FLAG | VARCHAR2 | 1 | Indicates if the variance should be calculated for tax distributions. Valid values: Y and N. | ||
| ENABLE_INCL_TAX_CALC_FLAG | VARCHAR2 | 1 | Indicates whether inclusive tax calculation will be performed for an event class. Valid values: Y and N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ZX_EVNT_CLS_OPTIONS | zx_det_factor_templ_b | DET_FACTOR_TEMPL_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_EVNT_CLS_OPTIONS_N1 | Non Unique | Default | APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, FIRST_PTY_ORG_ID, EFFECTIVE_FROM, ENABLED_FLAG, INDIRECT_TAX_OR_WHT_FLAG |
| ZX_EVNT_CLS_OPTIONS_U1 | Unique | Default | EVENT_CLASS_OPTIONS_ID |