GL_COA_MAP_SEGMENT_RULES_INT
This table is an interface table used to load of chart of accounts mapping definitions and segment rules into the application.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
GL_COA_MAP_SEG_RULES_INT_PK |
GROUP_NUMBER, ROW_NUMBER |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| GROUP_NUMBER | NUMBER | 18 | Yes | Chart of accounts mapping interface group identifier. | |
| ROW_NUMBER | NUMBER | 18 | Yes | Chart of accounts mapping interface row number. | |
| MAPPING_NAME | VARCHAR2 | 33 | Yes | User-defined chart of accounts definition name. | |
| FROM_CHART_OF_ACCOUNTS_CODE | VARCHAR2 | 30 | Yes | The source chart of accounts structure instance code for which mappings are being imported. | |
| TO_CHART_OF_ACCOUNTS_CODE | VARCHAR2 | 30 | Yes | The target chart of accounts structure instance code for which mappings are being imported. | |
| DESCRIPTION | VARCHAR2 | 40 | Chart of accounts definition description. | ||
| IMPORT_ACTION_CODE | VARCHAR2 | 30 | Yes | The action that the import process must perform. Valid values are INSERT and DELETE. | |
| TARGET_SEGMENT_CODE | VARCHAR2 | 30 | Segment code of the target chart of accounts segment. | ||
| MAPPING_METHOD_CODE | VARCHAR2 | 30 | Mapping action for a segment rule. Valid values are ASSIGN_SINGLE_VALUE, COPY_VALUE_FROM_SOURCE, or USE_ROLLUP_RULES. | ||
| TARGET_SEGMENT_VALUE | VARCHAR2 | 25 | Target segment value for Assign Single Value mapping. | ||
| FIRST_SOURCE_SEGMENT_CODE | VARCHAR2 | 30 | First source chart of accounts segment code for which a segment rule needs to be defined. | ||
| SECOND_SOURCE_SEGMENT_CODE | VARCHAR2 | 30 | Second source chart of accounts segment code for which a segment rule needs to be defined. | ||
| STATUS_CODE | VARCHAR2 | 30 | Code that indicates the import status of the mapping. Valid values are NEW, SUCCESS, and ERROR. | ||
| IMPORT_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: Indicates the request ID of the job that created or last updated the row. | ||
| ERROR_MESSAGE | VARCHAR2 | 1000 | The error message of the mappings that could not be imported. Oracle internal use only. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_COA_MAP_SEG_RULES_INT_N1 | Non Unique | Default | MAPPING_NAME, LOAD_REQUEST_ID |
| GL_COA_MAP_SEG_RULES_INT_U1 | Unique | Default | GROUP_NUMBER, ROW_NUMBER |