XLA_EXTERNAL_SYSTEM_LEDGER_MAP
This table contains mapping between the Oracle Fusion General Ledger and external transaction ledger.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
XLA_EXT_SYSTEM_LEDGER_MAP_PK |
EXTERNAL_MAPPING_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXTERNAL_MAPPING_ID | NUMBER | 18 | Yes | External ledger mapping identifier. | |
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | ||
| BALANCING_SEGMENT_VALUE | VARCHAR2 | 25 | Oracle balancing segment value. | ||
| FUSION_LEDGER_ID | NUMBER | 18 | Yes | Ledger identifier used in ledgers defined by Oracle Fusion General Ledger. | |
| EXTERNAL_SYSTEM_LEDGER | VARCHAR2 | 100 | Name, identifier, or code that identifies the external system ledger. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | 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 | Yes | Who column: indicates the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| XLA_EXTERNAL_SYSTEM_LEDGER_MAP | gl_ledgers | FUSION_LEDGER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| XLA_EXT_SYSTEM_LEDGER_MAP_U1 | Unique | Default | EXTERNAL_MAPPING_ID |
| XLA_EXT_SYSTEM_LEDGER_MAP_U2 | Unique | Default | FUSION_LEDGER_ID, BALANCING_SEGMENT_VALUE |