GL_CROSS_VALIDATION_RULES_INT
This table is an interface table used to load cross-validation rules into the application.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
GL_CROSS_VAL_RULES_INT_PK |
GROUP_NUMBER, ROW_NUMBER |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| GROUP_NUMBER | NUMBER | 18 | Yes | Cross-validation rule interface group identifier. | |
| ROW_NUMBER | NUMBER | 18 | Yes | Cross-validation rule interface row number. | |
| CHART_OF_ACCOUNTS_CODE | VARCHAR2 | 30 | Yes | The chart of accounts structure code for which cross-validation rules are being imported. | |
| RULE_CODE | VARCHAR2 | 30 | Yes | The name of the cross-validation rule for which rules are being imported. | |
| DESCRIPTION | VARCHAR2 | 240 | The description of the cross-validation rule. | ||
| IMPORT_ACTION_CODE | VARCHAR2 | 30 | Yes | The action that the import process must perform. Valid values are INSERT and DELETE. | |
| START_DATE_ACTIVE | DATE | Earliest date on which this cross-validation rule is valid. | |||
| END_DATE_ACTIVE | DATE | Latest date on which this cross-validation rule is valid. | |||
| RULE_ERROR_MESSAGE_TEXT | VARCHAR2 | 240 | Yes | The user-defined error message for a cross-validation rule violation. | |
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the cross-validation rule is available for use. | |
| CONDITION_SEGMENT_CODE | VARCHAR2 | 30 | Segment column that contains the condition filter segment used in the cross-validation rule. | ||
| CONDITION_OPERATOR_NAME | VARCHAR2 | 30 | Segment operator for the condition filter segment of the cross-validation rule. | ||
| CONDITION_VALUES | VARCHAR2 | 1000 | Segment values for the condition filter segment of the cross-validation rule. | ||
| VALIDATION_SEGMENT_CODE | VARCHAR2 | 30 | Segment column that contains the validation filter segment used in the cross-validation rule. | ||
| VALIDATION_OPERATOR_NAME | VARCHAR2 | 30 | Segment operator for the validation filter segment of the cross-validation rule. | ||
| VALIDATION_VALUES | VARCHAR2 | 1000 | Segment values for the validation filter segment of the cross-validation rule. | ||
| STATUS_CODE | VARCHAR2 | 30 | Yes | Code that indicates the import status of the cross-validation rule. Valid values are NEW, SUCCESS, and ERROR. | |
| ERROR_MESSAGE | VARCHAR2 | 1000 | The error message of the cross-validation rule that could not be imported. Oracle internal use only. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. This column is used in internal processing only. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_CROSS_VAL_RULES_INT_N1 | Non Unique | Default | RULE_CODE, CHART_OF_ACCOUNTS_CODE, LOAD_REQUEST_ID |
| GL_CROSS_VAL_RULES_INT_U1 | Unique | Default | GROUP_NUMBER, ROW_NUMBER |