[Home] [Help] [Dependency Information]
Object Name: | XLA_GL_TRANSFER_BATCHES_ALL |
---|---|
Object Type: | TABLE |
Owner: | XLA |
FND Design Data: | XLA.XLA_GL_TRANSFER_BATCHES_ALL |
Subobject Name: | |
Status: | VALID |
Transferred Batches History Table. Maintains the log of the transfers submitted.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XLA_GL_TRANSFER_BATCHES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | GL_TRANSFER_RUN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GL_TRANSFER_RUN_ID | NUMBER | (15) | Yes | Transfer Run Id for a Batch. Unique for each set of book |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
APPLICATION_ID | NUMBER | (15) | Calling Application ID | |
USER_ID | NUMBER | (15) | User Id | |
SELECTION_TYPE | NUMBER | Describes the transfer type. e.g. 1-Batch Transfer 2- Document Invoice Specific Transfer | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Id of the Set of Books | |
BATCH_NAME | VARCHAR2 | (30) | Transfer batch Name | |
SOURCE_ID | NUMBER | (15) | The Id of the source document. | |
SOURCE_TABLE | VARCHAR2 | (30) | Source entity that accounting event is linked to | |
TRANSFER_FROM_DATE | DATE | Transfer start date | ||
TRANSFER_TO_DATE | DATE | Transfer end date. Used together with the transfer start date to set the transfer date range | ||
AE_CATEGORY | VARCHAR2 | (30) | Describes the journal category of the document | |
GL_TRANSFER_MODE | VARCHAR2 | (1) | Describes the mode in which the transfer was submitted. D - Detail, A- Summarized by accounting date, P- Summarized by accounting period | |
SUBMIT_JOURNAL_IMPORT | VARCHAR2 | (1) | Specifies whether journal import to be submitted immediately after the transfer | |
SUMMARY_JOURNAL_ENTRY | VARCHAR2 | (1) | Specifies whether journal import should summarize the entries. | |
PROCESS_DAYS | NUMBER | Describes number of days to be processed in one commit cycle. | ||
GL_TRANSFER_DATE | DATE | Date on which the transfer was submitted (System date) | ||
GLLEZL_REQUEST_ID | NUMBER | (15) | Journal Import Request Id | |
INTERFACE_RUN_ID | NUMBER | (15) | Journal Import Processing defining column | |
GROUP_ID | NUMBER | (15) | Interface group defining column | |
ORG_ID | NUMBER | (15) | Organization identifier | |
LEGAL_ENTITY_ID | NUMBER | (15) | Legal Entity Id. Used for CST transfer | |
COST_TYPE_ID | NUMBER | (15) | Cost Type Id. Used for CST transfer. | |
COST_GROUP_ID | NUMBER | (15) | Cost Group ID Used for CST transfer | |
TRANSFER_STATUS | VARCHAR2 | (1) | Describes the transfer status. 'P' - The transfer is in progress, 'C' - The transfer completed successfully, 'N' - No rows are created. | |
PACKET_ID | NUMBER | (15) | Budgetary control packet defining column. |
Cut, paste (and edit) the following text to query this object:
SELECT GL_TRANSFER_RUN_ID
, REQUEST_ID
, APPLICATION_ID
, USER_ID
, SELECTION_TYPE
, SET_OF_BOOKS_ID
, BATCH_NAME
, SOURCE_ID
, SOURCE_TABLE
, TRANSFER_FROM_DATE
, TRANSFER_TO_DATE
, AE_CATEGORY
, GL_TRANSFER_MODE
, SUBMIT_JOURNAL_IMPORT
, SUMMARY_JOURNAL_ENTRY
, PROCESS_DAYS
, GL_TRANSFER_DATE
, GLLEZL_REQUEST_ID
, INTERFACE_RUN_ID
, GROUP_ID
, ORG_ID
, LEGAL_ENTITY_ID
, COST_TYPE_ID
, COST_GROUP_ID
, TRANSFER_STATUS
, PACKET_ID
FROM XLA.XLA_GL_TRANSFER_BATCHES_ALL;
XLA.XLA_GL_TRANSFER_BATCHES_ALL does not reference any database object
XLA.XLA_GL_TRANSFER_BATCHES_ALL is referenced by following:
|
|
|