ZX_QUICK_RULE_RESULTS_F
This table contains tax rules that are defined to evaluate the rule results based on the tax determinants for quick rule processing.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ZX_QUICK_RULE_RESULTS_F_PK |
QUICK_RULE_RESULT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| QUICK_RULE_RESULT_ID | NUMBER | 18 | Yes | Unique identifier for the quick rule record. | |
| RULE_TEMPLATE_CODE | VARCHAR2 | 30 | Yes | Code of the template used to populate the rule conditions. | |
| APPLICATION_ID | NUMBER | 18 | Identifier of a functional area within a software suite of products. For example: Financials or Payroll. | ||
| TAX_EVENT_CLASS_CODE | VARCHAR2 | 30 | Groups the application event classes that are essentially the same from a tax perspective such as receivables invoice, on-account credit memo, etc. | ||
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Application event class code associated with the tax rule. | ||
| TAX_REGIME_CODE | VARCHAR2 | 30 | Yes | Tax regime code associated with the tax rule. | |
| TAX | VARCHAR2 | 30 | Yes | Tax code associated with the tax rule. | |
| PRIORITY | NUMBER | Yes | Priority in which this tax rule is evaluated for the tax determination process. | ||
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the tax rule is enabled for processing. Valid values: Y and N. | |
| EFFECTIVE_START_DATE | DATE | Yes | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
| EFFECTIVE_END_DATE | DATE | Yes | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | ||
| CONTENT_OWNER_ID | NUMBER | 18 | Yes | Party tax profile identifier for the configuration owner of this tax rule. | |
| RECORD_TYPE_CODE | VARCHAR2 | 30 | Yes | Code to indicate whether the record is migrated, seeded, or defined by the user. | |
| SERVICE_TYPE_CODE | VARCHAR2 | 30 | Yes | Type of rule used for processing. Valid values: DET_TAXABLE_ VALUE_ ADDITION, DET_PER_UNIT_THRESHOLD, DET_TAXABLE_BASIS, and DET_DIRECT_RATE. DET_TAXABLE_ VALUE_ ADDITION means the rule is used to determine the taxable amount value additions. DET_PER_UNIT_THRESHOLD means the rule is used to determine the unit price threshold, DET_TAXABLE_BASIS means the rule is used to determine the taxable basis. DET_DIRECT_RATE means the rule is used to determine the tax rate. | |
| MIN_THRESHOLD_VALUE | NUMBER | Minimum threshold value associated with the tax rule. | |||
| MAX_THRESHOLD_VALUE | NUMBER | Maximum threshold value associated with the tax rule. | |||
| UNIT_PRICE_THRESHOLD_TYPE | VARCHAR2 | 30 | Unit price level threshold type. Valid values: NULL, MIN_MAX, MIN_MAX_ENFMIN, FIXED_PRICE. MIN_MAX means the minimum or maximum threshold is applicable on the unit price threshold rule. MIN_MAX_ENFMIN means the minimum or maximum threshold is applicable on the unit price threshold rule, and the minimum threshold will be enforced if defined. FIXED_PRICE means the specified fixed price is applicable on the unit price threshold rule. | ||
| RECOVERY_TYPE_CODE | VARCHAR2 | 30 | Code to indicate the recovery type for the tax of this tax rule. Only applicable for the recovery rate determination rule. | ||
| TAX_STATUS_CODE | VARCHAR2 | 30 | Tax status code. Only applicable for tax rate determination rule. | ||
| NUMERIC_RESULT | NUMBER | Numeric value of the result from the tax determination process. | |||
| ALPHANUMERIC_RESULT | VARCHAR2 | 150 | Alphanumeric result value from the tax determination process. | ||
| PRODUCT_FC_TYPE | VARCHAR2 | 30 | Type code for the product fiscal classification condition. | ||
| PRODUCT_FC_OPERATOR | VARCHAR2 | 30 | Operator for the product fiscal classification condition. | ||
| PRODUCT_FC_VALUE | VARCHAR2 | 150 | Alphanumeric value of the product fiscal classification code condition. | ||
| PARTY_FC_CODE | VARCHAR2 | 30 | Alphanumeric value of the party fiscal classification code condition. | ||
| PARTY_FC_PARTY_TYPE | VARCHAR2 | 30 | Type for the party fiscal classification condition. | ||
| PARTY_FC_OPERATOR | VARCHAR2 | 30 | Operator for the party fiscal classification condition. | ||
| PARTY_FC_VALUE | VARCHAR2 | 150 | Alphanumeric value for the party fiscal classification condition. | ||
| INTENDED_USE_OPERATOR | VARCHAR2 | 30 | Operator for the intended use condition. | ||
| INTENDED_USE_ID | NUMBER | 18 | Numeric identifier for the intended use condition. | ||
| TRX_BIZ_CATEGORY_LEVEL_CODE | VARCHAR2 | 30 | Level code for the transaction business category condition. | ||
| TRX_BIZ_CATEGORY_OPERATOR | VARCHAR2 | 30 | Operator for the transaction business category condition. | ||
| TRX_BIZ_CATEGORY_VALUE | VARCHAR2 | 240 | Alphanumeric value for the transaction business category condition. | ||
| BILL_FROM_PTY_REG_OPERATOR | VARCHAR2 | 30 | Operator for the bill-from party registration condition. | ||
| BILL_FROM_PTY_REG_VALUE | VARCHAR2 | 30 | Alphanumeric value for the bill-from party registration condition. | ||
| BILL_TO_PTY_REG_OPERATOR | VARCHAR2 | 30 | Operator for the bill-to party registration condition. | ||
| BILL_TO_PTY_REG_VALUE | VARCHAR2 | 30 | Alphanumeric value for the bill-to party registration condition. | ||
| SHIP_FROM_GEO1_TYPE | VARCHAR2 | 30 | Geography type for the first ship-from geography condition. | ||
| SHIP_FROM_GEO1_OPERATOR | VARCHAR2 | 30 | Operator for the first ship-from geography condition. | ||
| SHIP_FROM_GEO1_ID | NUMBER | 18 | Numeric identifier for the first ship-from geography condition. | ||
| SHIP_FROM_GEO2_TYPE | VARCHAR2 | 30 | Geography type for the second ship-from geography condition. | ||
| SHIP_FROM_GEO2_OPERATOR | VARCHAR2 | 30 | Operator for the second ship-from geography condition. | ||
| SHIP_FROM_GEO2_ID | NUMBER | 18 | Numeric identifier for the second ship-from geography condition. | ||
| SHIP_TO_GEO1_TYPE | VARCHAR2 | 30 | Geography type for the first ship-to geography condition. | ||
| SHIP_TO_GEO1_OPERATOR | VARCHAR2 | 30 | Operator for the first ship-to geography condition. | ||
| SHIP_TO_GEO1_ID | NUMBER | 18 | Numeric identifier for the first ship-to geography condition. | ||
| SHIP_TO_GEO2_TYPE | VARCHAR2 | 30 | Geography type for the second ship-to geography condition. | ||
| SHIP_TO_GEO2_OPERATOR | VARCHAR2 | 30 | Operator for the second ship-to geography condition. | ||
| SHIP_TO_GEO2_ID | NUMBER | 18 | Numeric identifier for the second ship-to geography condition. | ||
| BILL_FROM_GEO1_TYPE | VARCHAR2 | 30 | Geography type for the first bill-from geography condition. | ||
| BILL_FROM_GEO1_OPERATOR | VARCHAR2 | 30 | Operator for the first bill-from geography condition. | ||
| BILL_FROM_GEO1_ID | NUMBER | 18 | Numeric identifier for the first bill-from geography condition. | ||
| BILL_TO_GEO2_TYPE | VARCHAR2 | 30 | Geography type for the second bill-from geography condition. | ||
| BILL_TO_GEO2_OPERATOR | VARCHAR2 | 30 | Operator for the second bill-from geography condition. | ||
| BILL_TO_GEO2_ID | NUMBER | 18 | Numeric identifier for the second bill-from geography condition. | ||
| PRODUCT_TYPE_OPERATOR | VARCHAR2 | 30 | Operator for the product type condition. | ||
| PRODUCT_TYPE_VALUE | VARCHAR2 | 150 | Alphanumeric value of the product type condition. | ||
| PRODUCT_CATEGORY_LEVEL | VARCHAR2 | 30 | Level of the product category condition. | ||
| PRODUCT_CATEGORY_OPERATOR | VARCHAR2 | 30 | Operator for the product category condition. | ||
| PRODUCT_CATEGORY_VALUE | VARCHAR2 | 150 | Alphanumeric value of the product category condition. | ||
| LINE_ACCOUNT_OPERATOR | VARCHAR2 | 30 | Operator for the line account condition. | ||
| TAX_CLASSIFICATION_OPERATOR | VARCHAR2 | 30 | Operator for the tax classification condition. | ||
| TAX_CLASSIFICATION_VALUE | VARCHAR2 | 30 | Alphanumeric value for the tax classification condition. | ||
| FLEX_FILTER_VALUE | XMLTYPE | Alphanumeric value for accounting segment condition. | |||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
| 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. | |
| CONDITION_GROUP_CODE | VARCHAR2 | 50 | A code assigned to a group of conditions that are evaluated during tax calculation process. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_QUICK_RULE_RESULTS_F_N1 | Non Unique | Default | TAX_REGIME_CODE, TAX, CONTENT_OWNER_ID, SERVICE_TYPE_CODE, ENABLED_FLAG |
| ZX_QUICK_RULE_RESULTS_F_U1 | Unique | Default | QUICK_RULE_RESULT_ID |
| ZX_QUICK_RULE_RESULTS_F_U2 | Unique | Default | TAX_REGIME_CODE, TAX, CONTENT_OWNER_ID, SERVICE_TYPE_CODE, EFFECTIVE_START_DATE, RULE_TEMPLATE_CODE, RECOVERY_TYPE_CODE, TAX_STATUS_CODE, PRIORITY |