GL_XFR_TRACKING
GL_XFR_TRACKING contains details about balance transfer run status.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
GL_XFR_TRACKING_PK |
XFER_REQUEST_ID, SYSTEM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| XFER_REQUEST_ID | NUMBER | 15 | Yes | Balance transfer request identifier. | |
| JE_SOURCE_KEY | VARCHAR2 | 25 | Yes | Journal source key receiving transfer journals. | |
| GROUP_ID | NUMBER | 15 | Yes | Identifier that identifies the interface group. | |
| SYSTEM_ID | NUMBER | 15 | Yes | Transfer system identifier to identify the record. | |
| INTERFACE_TABLE_NAME | VARCHAR2 | 30 | Yes | Interface table name for the transfer journal. | |
| LEDGER_ID | NUMBER | 15 | Yes | Ledger identifier to track journal to be imported. | |
| STATUS_CODE | VARCHAR2 | 30 | Yes | Balance transfer run status code. | |
| ORIGINAL_FIRST_PERIOD | VARCHAR2 | 15 | Name of the balance transfer run period. | ||
| CREATION_DATE | DATE | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | NUMBER | 15 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | DATE | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | NUMBER | 15 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | NUMBER | 15 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_XFR_TRACKING_U1 | Unique | Default | XFER_REQUEST_ID, SYSTEM_ID |