ZX_CONDITION_GROUPS_B
This table stores Condition Groups
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ZX_CONDITION_GROUPS_B_PK |
CONDITION_GROUP_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CONDITION_GROUP_CODE | VARCHAR2 | 50 | Yes | Condition group code | |
| FLEX_FILTER_VALUE | XMLTYPE | Flex Filter Value | |||
| DET_FACTOR_TEMPL_CODE | VARCHAR2 | 30 | Yes | Determining factor template code | |
| COUNTRY_CODE | VARCHAR2 | 2 | Country code for which the condition group is defined. This is NULL for condition groups that are generic for all countries. | ||
| MORE_THAN_MAX_COND_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether the Condition Group has more than 10 conditions | |
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates if the Condition Group is enabled or disabled | |
| DETERMINING_FACTOR_CODE1 | VARCHAR2 | 30 | Determining factor code for first condition | ||
| TAX_PARAMETER_CODE1 | VARCHAR2 | 50 | Tax parameter code for the determining factor of first condition | ||
| DATA_TYPE1_CODE | VARCHAR2 | 30 | Data type of the determining factor for first condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | ||
| DETERMINING_FACTOR_CLASS1_CODE | VARCHAR2 | 30 | Determining factor class code for first condition | ||
| DETERMINING_FACTOR_CQ1_CODE | VARCHAR2 | 30 | Determining factor class qualifier code for first condition. This is a sub classification of the determining factor class. | ||
| OPERATOR1_CODE | VARCHAR2 | 30 | Operator used for defining first condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | ||
| NUMERIC_VALUE1 | NUMBER | Column for recording the numeric value to be compared with the determining factor for first condition | |||
| DATE_VALUE1 | DATE | Column for recording the date value to be compared with the determining factor for first condition | |||
| ALPHANUMERIC_VALUE1 | VARCHAR2 | 150 | Column for recording the alphanumeric value to be compared with the determining factor for first condition | ||
| VALUE_LOW1 | VARCHAR2 | 1000 | Column for recording the lowest value in the range to be compared with the determining factor for first condition, when operator is BETWEEN | ||
| VALUE_HIGH1 | VARCHAR2 | 1000 | Column for recording the highest value in the range to be compared with the determining factor for first condition, when operator is BETWEEN | ||
| DETERMINING_FACTOR_CODE2 | VARCHAR2 | 30 | Determining factor code for second condition | ||
| TAX_PARAMETER_CODE2 | VARCHAR2 | 50 | Tax parameter code for the determining factor of second condition | ||
| DATA_TYPE2_CODE | VARCHAR2 | 30 | Data type of the determining factor for second condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | ||
| DETERMINING_FACTOR_CLASS2_CODE | VARCHAR2 | 30 | Determining factor class code for second condition | ||
| DETERMINING_FACTOR_CQ2_CODE | VARCHAR2 | 30 | Determining factor class qualifier code for second condition. This is a sub classification of the determining factor class. | ||
| OPERATOR2_CODE | VARCHAR2 | 30 | Operator used for defining second condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | ||
| NUMERIC_VALUE2 | NUMBER | Column for recording the numeric value to be compared with the determining factor for second condition | |||
| DATE_VALUE2 | DATE | Column for recording the date value to be compared with the determining factor for second condition | |||
| ALPHANUMERIC_VALUE2 | VARCHAR2 | 150 | Column for recording the alphanumeric value to be compared with the determining factor for second condition | ||
| VALUE_LOW2 | VARCHAR2 | 1000 | Column for recording the lowest value in the range to be compared with the determining factor for second condition, when operator is BETWEEN | ||
| VALUE_HIGH2 | VARCHAR2 | 1000 | Column for recording the highest value in the range to be compared with the determining factor for second condition, when operator is BETWEEN | ||
| DETERMINING_FACTOR_CODE3 | VARCHAR2 | 30 | Determining factor code for third condition | ||
| TAX_PARAMETER_CODE3 | VARCHAR2 | 50 | Tax parameter code for the determining factor of third condition | ||
| DATA_TYPE3_CODE | VARCHAR2 | 30 | Data type of the determining factor for third condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | ||
| DETERMINING_FACTOR_CLASS3_CODE | VARCHAR2 | 30 | Determining factor class code for third condition | ||
| DETERMINING_FACTOR_CQ3_CODE | VARCHAR2 | 30 | Determining factor class qualifier code for third condition. This is a sub classification of the determining factor class. | ||
| OPERATOR3_CODE | VARCHAR2 | 30 | Operator used for defining third condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | ||
| NUMERIC_VALUE3 | NUMBER | Column for recording the numeric value to be compared with the determining factor for third condition | |||
| DATE_VALUE3 | DATE | Column for recording the date value to be compared with the determining factor for third condition | |||
| ALPHANUMERIC_VALUE3 | VARCHAR2 | 150 | Column for recording the alphanumeric value to be compared with the determining factor for third condition | ||
| VALUE_LOW3 | VARCHAR2 | 1000 | Column for recording the lowest value in the range to be compared with the determining factor for third condition, when operator is BETWEEN | ||
| VALUE_HIGH3 | VARCHAR2 | 1000 | Column for recording the highest value in the range to be compared with the determining factor for third condition, when operator is BETWEEN | ||
| DETERMINING_FACTOR_CODE4 | VARCHAR2 | 30 | Determining factor code for fourth condition | ||
| TAX_PARAMETER_CODE4 | VARCHAR2 | 50 | Tax parameter code for the determining factor of fourth condition | ||
| DATA_TYPE4_CODE | VARCHAR2 | 30 | Data type of the determining factor for fourth condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | ||
| DETERMINING_FACTOR_CLASS4_CODE | VARCHAR2 | 30 | Determining factor class code for fourth condition | ||
| DETERMINING_FACTOR_CQ4_CODE | VARCHAR2 | 30 | Determining factor class qualifier code for fourth condition. This is a sub classification of the determining factor class. | ||
| OPERATOR4_CODE | VARCHAR2 | 30 | Operator used for defining fourth condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | ||
| NUMERIC_VALUE4 | NUMBER | Column for recording the numeric value to be compared with the determining factor for fourth condition | |||
| DATE_VALUE4 | DATE | Column for recording the date value to be compared with the determining factor for fourth condition | |||
| ALPHANUMERIC_VALUE4 | VARCHAR2 | 150 | Column for recording the alphanumeric value to be compared with the determining factor for fourth condition | ||
| VALUE_LOW4 | VARCHAR2 | 1000 | Column for recording the lowest value in the range to be compared with the determining factor for fourth condition, when operator is BETWEEN | ||
| VALUE_HIGH4 | VARCHAR2 | 1000 | Column for recording the highest value in the range to be compared with the determining factor for fourth condition, when operator is BETWEEN | ||
| DETERMINING_FACTOR_CODE5 | VARCHAR2 | 30 | Determining factor code for fifth condition | ||
| TAX_PARAMETER_CODE5 | VARCHAR2 | 50 | Tax parameter code for the determining factor of fifth condition | ||
| DATA_TYPE5_CODE | VARCHAR2 | 30 | Data type of the determining factor for fifth condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | ||
| DETERMINING_FACTOR_CLASS5_CODE | VARCHAR2 | 30 | Determining factor class code for fifth condition | ||
| DETERMINING_FACTOR_CQ5_CODE | VARCHAR2 | 30 | Determining factor class qualifier code for fifth condition. This is a sub classification of the determining factor class. | ||
| OPERATOR5_CODE | VARCHAR2 | 30 | Operator used for defining fifth condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | ||
| NUMERIC_VALUE5 | NUMBER | Column for recording the numeric value to be compared with the determining factor for fifth condition | |||
| DATE_VALUE5 | DATE | Column for recording the date value to be compared with the determining factor for fifth condition | |||
| ALPHANUMERIC_VALUE5 | VARCHAR2 | 150 | Column for recording the alphanumeric value to be compared with the determining factor for fifth condition | ||
| VALUE_LOW5 | VARCHAR2 | 1000 | Column for recording the lowest value in the range to be compared with the determining factor for fifth condition, when operator is BETWEEN | ||
| VALUE_HIGH5 | VARCHAR2 | 1000 | Column for recording the highest value in the range to be compared with the determining factor for fifth condition, when operator is BETWEEN | ||
| DETERMINING_FACTOR_CODE6 | VARCHAR2 | 30 | Determining factor code for sixth condition | ||
| TAX_PARAMETER_CODE6 | VARCHAR2 | 50 | Tax parameter code for the determining factor of sixth condition | ||
| DATA_TYPE6_CODE | VARCHAR2 | 30 | Data type of the determining factor for sixth condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | ||
| DETERMINING_FACTOR_CLASS6_CODE | VARCHAR2 | 30 | Determining factor class code for sixth condition | ||
| DETERMINING_FACTOR_CQ6_CODE | VARCHAR2 | 30 | Determining factor class qualifier code for sixth condition. This is a sub classification of the determining factor class. | ||
| OPERATOR6_CODE | VARCHAR2 | 30 | Operator used for defining sixth condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | ||
| NUMERIC_VALUE6 | NUMBER | Column for recording the numeric value to be compared with the determining factor for sixth condition | |||
| DATE_VALUE6 | DATE | Column for recording the date value to be compared with the determining factor for sixth condition | |||
| ALPHANUMERIC_VALUE6 | VARCHAR2 | 150 | Column for recording the alphanumeric value to be compared with the determining factor for sixth condition | ||
| VALUE_LOW6 | VARCHAR2 | 1000 | Column for recording the lowest value in the range to be compared with the determining factor for sixth condition, when operator is BETWEEN | ||
| VALUE_HIGH6 | VARCHAR2 | 1000 | Column for recording the highest value in the range to be compared with the determining factor for sixth condition, when operator is BETWEEN | ||
| DETERMINING_FACTOR_CODE7 | VARCHAR2 | 30 | Determining factor code for seventh condition | ||
| TAX_PARAMETER_CODE7 | VARCHAR2 | 50 | Tax parameter code for the determining factor of seventh condition | ||
| DATA_TYPE7_CODE | VARCHAR2 | 30 | Data type of the determining factor for seventh condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | ||
| DETERMINING_FACTOR_CLASS7_CODE | VARCHAR2 | 30 | Determining factor class code for seventh condition | ||
| DETERMINING_FACTOR_CQ7_CODE | VARCHAR2 | 30 | Determining factor class qualifier code for seventh condition. This is a sub classification of the determining factor class. | ||
| OPERATOR7_CODE | VARCHAR2 | 30 | Operator used for defining seventh condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | ||
| NUMERIC_VALUE7 | NUMBER | Column for recording the numeric value to be compared with the determining factor for seventh condition | |||
| DATE_VALUE7 | DATE | Column for recording the date value to be compared with the determining factor for seventh condition | |||
| ALPHANUMERIC_VALUE7 | VARCHAR2 | 150 | Column for recording the alphanumeric value to be compared with the determining factor for seventh condition | ||
| VALUE_LOW7 | VARCHAR2 | 1000 | Column for recording the lowest value in the range to be compared with the determining factor for seventh condition, when operator is BETWEEN | ||
| VALUE_HIGH7 | VARCHAR2 | 1000 | Column for recording the highest value in the range to be compared with the determining factor for seventh condition, when operator is BETWEEN | ||
| DETERMINING_FACTOR_CODE8 | VARCHAR2 | 30 | Determining factor code for eighth condition | ||
| TAX_PARAMETER_CODE8 | VARCHAR2 | 50 | Tax parameter code for the determining factor of eighth condition | ||
| DATA_TYPE8_CODE | VARCHAR2 | 30 | Data type of the determining factor for eighth condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | ||
| DETERMINING_FACTOR_CLASS8_CODE | VARCHAR2 | 30 | Determining factor class code for eighth condition | ||
| DETERMINING_FACTOR_CQ8_CODE | VARCHAR2 | 30 | Determining factor class qualifier code for eighth condition. This is a sub classification of the determining factor class. | ||
| OPERATOR8_CODE | VARCHAR2 | 30 | Operator used for defining eighth condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | ||
| NUMERIC_VALUE8 | NUMBER | Column for recording the numeric value to be compared with the determining factor for eighth condition | |||
| DATE_VALUE8 | DATE | Column for recording the date value to be compared with the determining factor for eighth condition | |||
| ALPHANUMERIC_VALUE8 | VARCHAR2 | 150 | Column for recording the alphanumeric value to be compared with the determining factor for eighth condition | ||
| VALUE_LOW8 | VARCHAR2 | 1000 | Column for recording the lowest value in the range to be compared with the determining factor for eighth condition, when operator is BETWEEN | ||
| VALUE_HIGH8 | VARCHAR2 | 1000 | Column for recording the highest value in the range to be compared with the determining factor for eighth condition, when operator is BETWEEN | ||
| DETERMINING_FACTOR_CODE9 | VARCHAR2 | 30 | Determining factor code for ninth condition | ||
| TAX_PARAMETER_CODE9 | VARCHAR2 | 50 | Tax parameter code for the determining factor of ninth condition | ||
| DATA_TYPE9_CODE | VARCHAR2 | 30 | Data type of the determining factor for ninth condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | ||
| DETERMINING_FACTOR_CLASS9_CODE | VARCHAR2 | 30 | Determining factor class code for ninth condition | ||
| DETERMINING_FACTOR_CQ9_CODE | VARCHAR2 | 30 | Determining factor class qualifier code for ninth condition. This is a sub classification of the determining factor class. | ||
| OPERATOR9_CODE | VARCHAR2 | 30 | Operator used for defining ninth condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | ||
| NUMERIC_VALUE9 | NUMBER | Column for recording the numeric value to be compared with the determining factor for ninth condition | |||
| DATE_VALUE9 | DATE | Column for recording the date value to be compared with the determining factor for ninth condition | |||
| ALPHANUMERIC_VALUE9 | VARCHAR2 | 150 | Column for recording the alphanumeric value to be compared with the determining factor for ninth condition | ||
| VALUE_LOW9 | VARCHAR2 | 1000 | Column for recording the lowest value in the range to be compared with the determining factor for ninth condition, when operator is BETWEEN | ||
| VALUE_HIGH9 | VARCHAR2 | 1000 | Column for recording the highest value in the range to be compared with the determining factor for ninth condition, when operator is BETWEEN | ||
| DETERMINING_FACTOR_CODE10 | VARCHAR2 | 30 | Determining factor code for tenth condition | ||
| TAX_PARAMETER_CODE10 | VARCHAR2 | 50 | Tax parameter code for the determining factor of tenth condition | ||
| DATA_TYPE10_CODE | VARCHAR2 | 30 | Data type of the determining factor for tenth condition. Possible values are DATE, NUMERIC and ALPHANUMERIC. | ||
| DETERMINING_FACTOR_CLAS10_CODE | VARCHAR2 | 30 | Determining factor class code for tenth condition | ||
| DETERMINING_FACTOR_CQ10_CODE | VARCHAR2 | 30 | Determining factor class qualifier code for tenth condition. This is a sub classification of the determining factor class. | ||
| OPERATOR10_CODE | VARCHAR2 | 30 | Operator used for defining tenth condition. Possible values are =, <>, =CQ, <>CQ, BETWEEN and IN | ||
| NUMERIC_VALUE10 | NUMBER | Column for recording the numeric value to be compared with the determining factor for tenth condition | |||
| DATE_VALUE10 | DATE | Column for recording the date value to be compared with the determining factor for tenth condition | |||
| ALPHANUMERIC_VALUE10 | VARCHAR2 | 150 | Column for recording the alphanumeric value to be compared with the determining factor for tenth condition | ||
| VALUE_LOW10 | VARCHAR2 | 1000 | Column for recording the lowest value in the range to be compared with the determining factor for tenth condition, when operator is BETWEEN | ||
| VALUE_HIGH10 | VARCHAR2 | 1000 | Column for recording the highest value in the range to be compared with the determining factor for tenth condition, when operator is BETWEEN | ||
| 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. | |||
| CONSTRAINT_ID | NUMBER | 18 | Constraint identifier | ||
| PROGRAM_LOGIN_ID | NUMBER | Login user identifier of last concurrent program to update this record | |||
| CONDITION_GROUP_ID | NUMBER | 18 | Yes | Unique identifier | |
| 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. | ||
| LEDGER_ID | NUMBER | 18 | Ledger defining column | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Accounting key flexfield structure defining column | ||
| 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. | |
| PROGRAM_NAME | VARCHAR2 | 30 | Program name of last concurrent program to update this record | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Application name of last concurrent program to update this record |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| zx_process_results | zx_condition_groups_b | CONDITION_GROUP_CODE |
| zx_conditions | zx_condition_groups_b | CONDITION_GROUP_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_CONDITION_GROUPS_B_N1 | Non Unique | Default | CONDITION_GROUP_CODE, CONSTRAINT_ID |
| ZX_CONDITION_GROUPS_B_N2 | Non Unique | Default | DET_FACTOR_TEMPL_CODE, CONDITION_GROUP_CODE, ENABLED_FLAG |
| ZX_CONDITION_GROUPS_B_U1 | Unique | Default | CONDITION_GROUP_ID |
| ZX_CONDITION_GROUPS_B_U2 | Unique | Default | CONDITION_GROUP_CODE |