XLA_TPM_WORKING_HDRS_T
This table is used by the Third Party Merge PL/SQL.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
XLA_TPM_WORKING_HDRS_T_PK |
MERGE_EVENT_ID, AE_HEADER_ID, REQUEST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| MERGE_EVENT_ID | NUMBER | 18 | Yes | Identifier of a third party merge event. | Active | |
| AE_HEADER_ID | NUMBER | 18 | Yes | Identifier of a subledger journal entry at the header level. | Active | |
| REQUEST_ID | NUMBER | 18 | Yes | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | Active | |
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | |||
| PROCESS_TYPE_FLAG | VARCHAR2 | 1 | Yes | Indicates the process to be applied to the journal entry | Active |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| XLA_TPM_WORKING_HDRS_T_U1 | Unique | Default | MERGE_EVENT_ID, AE_HEADER_ID, REQUEST_ID |