[Home] [Help] [Dependency Information]
Object Name: | XLA_REVERSE_EVENTS_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | XLA |
FND Design Data: | XLA.XLA_REVERSE_EVENTS_INTERFACE |
Subobject Name: | |
Status: | VALID |
The XLA_REVERSE_EVENTS_INTERFACE table stores records for accounting events that are to be reversed in bulk. The Bulk Reversal Event API reverses all these events in one run.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XLA_REVERSE_EVENTS_INTF_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BATCH_CODE
APPLICATION_ID LEDGER_ID EVENT_ID |
XLA_REVERSE_EVENTS_INTF_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | REVERSAL_EVENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Yes | Internal identifier of the application associated with the event. |
BATCH_CODE | VARCHAR2 | (30) | Yes | The unique code for each event batch that needs to be reversed in one run. |
LEDGER_ID | NUMBER | (15) | Yes | Internal identifier of the ledger associated with the event. |
ENTITY_CODE | VARCHAR2 | (30) | Yes | The code of the transaction entity associated with the event. |
EVENT_ID | NUMBER | (15) | Yes | |
PROCESS_STATUS_CODE | VARCHAR2 | (1) | Yes | The code of the event process status to indicate an event is reversed or not.The available process status codes are: P(Processed), U(Unprocessed)and E(Error). |
REVERSAL_GL_DATE | DATE | Yes | The accounting date on which the event is to be reversed. | |
REVERSAL_ENTITY_ID | NUMBER | (15) | Internal identifier of the reversed entity.The Bulk Reversal Event API populates this column. | |
REVERSAL_EVENT_ID | NUMBER | (15) | Internal identifier of the reversed event.The Bulk Reversal Event API populates this column. | |
ACCOUNTING_BATCH_ID | NUMBER | (15) | Internal identifier of the reversed accounting batch.The Bulk Reversal Event API populates this column. |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, BATCH_CODE
, LEDGER_ID
, ENTITY_CODE
, EVENT_ID
, PROCESS_STATUS_CODE
, REVERSAL_GL_DATE
, REVERSAL_ENTITY_ID
, REVERSAL_EVENT_ID
, ACCOUNTING_BATCH_ID
FROM XLA.XLA_REVERSE_EVENTS_INTERFACE;
XLA.XLA_REVERSE_EVENTS_INTERFACE does not reference any database object
XLA.XLA_REVERSE_EVENTS_INTERFACE is referenced by following:
|
|
|