ZX_PROCESS_RESULTS
This table stores the results from the evaluation for tax rules. Each record stores the process result from the evaluation of a specific condition set in a tax rule.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ZX_PROCESS_RESULTS_PK |
RESULT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CONDITION_GROUP_CODE | VARCHAR2 | 50 | Yes | Condition group code for which this process result is defined | |
| PRIORITY | NUMBER | Yes | Priority order for this process result in which the condition groups using the same determining factor template are evaluated to obtain this result | ||
| RESULT_TYPE_CODE | VARCHAR2 | 30 | Yes | Lookup code to indicates the type of this process result | |
| TAX_STATUS_CODE | VARCHAR2 | 30 | Tax status code for this process result | ||
| NUMERIC_RESULT | NUMBER | Column to store the numeric result value for this process result | |||
| ALPHANUMERIC_RESULT | VARCHAR2 | 150 | Column to store the alphanumeric result value for this process result | ||
| STATUS_RESULT | VARCHAR2 | 150 | Tax status code pointed by this process result when the condition group evaluates to be true | ||
| RATE_RESULT | VARCHAR2 | 150 | Tax rate code pointed by this process result when the condition group evaluates to be true | ||
| LEGAL_MESSAGE_CODE | VARCHAR2 | 30 | Legal mnessage code pointed by this process result when the condition group evaluates to be true | ||
| MIN_TAX_AMT | NUMBER | Minimum threshold for tax amount pointed by this process result when the condition group evaluates to be true | |||
| MAX_TAX_AMT | NUMBER | Maximum threshold for tax amount pointed by this process result when the condition group evaluates to be true | |||
| MIN_TAXABLE_BASIS | NUMBER | Minimum threshold for taxable basis pointed by this process result when the condition group evaluates to be true | |||
| MAX_TAXABLE_BASIS | NUMBER | Maximum threshold for taxable basis pointed by this process result when the condition group evaluates to be true | |||
| MIN_TAX_RATE | NUMBER | Minimum threshold for tax rate pointed by this process result when the condition group evaluates to be true | |||
| MAX_TAX_RATE | NUMBER | Maximum threshold for tax rate pointed by this process result when the condition group evaluates to be true | |||
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates if this process result is enabled | |
| ALLOW_EXEMPTIONS_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether exemptions are applicable for this process result | |
| ALLOW_EXCEPTIONS_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether exceptions are applicable for this process result | |
| RECORD_TYPE_CODE | VARCHAR2 | 30 | Yes | Lookup code to indicate whether the record is migrated, seeded or defined by the user | |
| 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. | ||
| REQUEST_ID | NUMBER | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Application identifier of last concurrent program to update this record | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Program identifier of last concurrent program to update this record | ||
| CONDITION_SET_ID | NUMBER | 18 | Condition set identifier for this process result | ||
| EXCEPTION_SET_ID | NUMBER | 18 | Exception set identifier for this process result | ||
| PROGRAM_LOGIN_ID | NUMBER | Login user identifier of last concurrent program to update this record | |||
| RESULT_ID | NUMBER | 18 | Yes | Unique identifier | |
| CONTENT_OWNER_ID | NUMBER | 18 | Yes | Party tax profile identifier for configuration owner of this process result | |
| CONDITION_GROUP_ID | NUMBER | 18 | Yes | Condition group identifier for which this process result is defined | |
| TAX_RULE_ID | NUMBER | 18 | Yes | Tax rule identifier for which this process result is defined | |
| 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. | ||
| RESULT_API | VARCHAR2 | 2000 | API pointed by this process result when the condition group evaluates to be true | ||
| 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. | |
| TAX_POINT_BASIS_RESULT | VARCHAR2 | 30 | Column to store the tax point basis value for this process result. | ||
| SELF_ASSESED_FLAG | VARCHAR2 | 1 | Column to store self assessed flag value for this process result. | ||
| INCLUSIVE_TAX_FLAG | VARCHAR2 | 1 | Column to store inclusive tax flag g value for this process result. | ||
| TAX_RATE_THRSHLD_CODE | VARCHAR2 | 30 | Code for the associated tax rate threshold. | ||
| TAXABLE_AMT_THRSHLD_CODE | VARCHAR2 | 30 | Code for the associated taxable amount threshold. | ||
| TAX_AMT_THRSHLD_CODE | VARCHAR2 | 30 | Code for the associated tax amount threshold. | ||
| TAXABLE_BASIS_FORMULA_RESULT | VARCHAR2 | 30 | Tax formula code in the process result for which the rule condition is successfully evaluated. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ZX_PROCESS_RESULTS | zx_condition_groups_b | CONDITION_GROUP_CODE |
| ZX_PROCESS_RESULTS | zx_rules_b | TAX_RULE_ID |
| ZX_PROCESS_RESULTS | zx_party_tax_profile | CONTENT_OWNER_ID |
| zx_rec_nrec_dist | zx_process_results | APPLICABILITY_RESULT_ID |
| zx_lines | zx_process_results | CALC_RESULT_ID |
| zx_lines | zx_process_results | PLACE_OF_SUPPLY_RESULT_ID |
| zx_lines | zx_process_results | TAX_DATE_RULE_ID |
| zx_lines | zx_process_results | TAX_REG_NUM_DET_RESULT_ID |
| zx_lines | zx_process_results | EVAL_EXMPT_RESULT_ID |
| zx_lines | zx_process_results | EVAL_EXCPT_RESULT_ID |
| zx_lines | zx_process_results | TAX_APPLICABILITY_RESULT_ID |
| zx_lines | zx_process_results | DIRECT_RATE_RESULT_ID |
| zx_lines | zx_process_results | STATUS_RESULT_ID |
| zx_lines | zx_process_results | RATE_RESULT_ID |
| zx_lines | zx_process_results | BASIS_RESULT_ID |
| zx_lines | zx_process_results | THRESH_RESULT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_PROCESS_RESULTS_N1 | Non Unique | Default | CONDITION_GROUP_CODE, ENABLED_FLAG |
| ZX_PROCESS_RESULTS_U1 | Unique | Default | RESULT_ID |
| ZX_PROCESS_RESULTS_U2 | Unique | Default | TAX_RULE_ID, CONDITION_GROUP_CODE, ENABLED_FLAG, PRIORITY, TAX_STATUS_CODE, CONDITION_SET_ID, EXCEPTION_SET_ID |