1. Tables and Views for Financials
  2. ZX_PROCESS_RESULTS_

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_

LAST_UPDATE_DATE, LAST_UPDATED_BY, RESULT_ID

Columns

Name Datatype Length Precision Not-null Comments
CONDITION_GROUP_CODE VARCHAR2 50 Condition group code for which this process result is defined
PRIORITY NUMBER 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 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 Y or N indicates if this process result is enabled
ALLOW_EXEMPTIONS_FLAG VARCHAR2 1 Y or N indicates whether exemptions are applicable for this process result
ALLOW_EXCEPTIONS_FLAG VARCHAR2 1 Y or N indicates whether exceptions are applicable for this process result
RECORD_TYPE_CODE VARCHAR2 30 Lookup code to indicate whether the record is migrated, seeded or defined by the user
CREATION_DATE TIMESTAMP 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 18 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 Party tax profile identifier for configuration owner of this process result
CONDITION_GROUP_ID NUMBER 18 Condition group identifier for which this process result is defined
TAX_RULE_ID NUMBER 18 Tax rule identifier for which this process result is defined
CREATED_BY VARCHAR2 64 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 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.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.

Indexes

Index Uniqueness Tablespace Columns
ZX_PROCESS_RESULTS_N1_ Non Unique Default RESULT_ID
ZX_PROCESS_RESULTS_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, RESULT_ID