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 |