[Home] [Help] [Dependency Information]
Object Name: | XLA_ACCT_PROG_DOCS_GT |
---|---|
Object Type: | TABLE |
Owner: | XLA |
Subobject Name: | |
Status: | VALID |
This table stores the entities to be processed by accounting program.
XLA.XLA_ACCT_PROG_DOCS_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ENTITY_ID | NUMBER | (15) | Entity internal identifier | |
LEDGER_ID | NUMBER | (15) | Ledger internal identifier | |
SOURCE_APPLICATION_ID | NUMBER | (15) | Source application internal identifier | |
LEGAL_ENTITY_ID | NUMBER | (15) | Legal entity internal identifier | |
ENTITY_TYPE_CODE | VARCHAR2 | (30) | Entity type code | |
VALUATION_METHOD | VARCHAR2 | (30) | Valuation method code | |
SOURCE_ID_INT_1 | NUMBER | (15) | Flexible source identifier (number) | |
SOURCE_ID_INT_2 | NUMBER | (15) | Flexible source identifier (number) | |
SOURCE_ID_INT_3 | NUMBER | (15) | Flexible source identifier (number) | |
SOURCE_ID_INT_4 | NUMBER | (15) | Flexible source identifier (number) | |
SOURCE_ID_CHAR_1 | VARCHAR2 | (30) | Flexible source identifier (char) | |
SOURCE_ID_CHAR_2 | VARCHAR2 | (30) | Flexible source identifier (char) | |
SOURCE_ID_CHAR_3 | VARCHAR2 | (30) | Flexible source identifier (char) | |
SOURCE_ID_CHAR_4 | VARCHAR2 | (30) | Flexible source identifier (char) |
Cut, paste (and edit) the following text to query this object:
SELECT ENTITY_ID
, LEDGER_ID
, SOURCE_APPLICATION_ID
, LEGAL_ENTITY_ID
, ENTITY_TYPE_CODE
, VALUATION_METHOD
, SOURCE_ID_INT_1
, SOURCE_ID_INT_2
, SOURCE_ID_INT_3
, SOURCE_ID_INT_4
, SOURCE_ID_CHAR_1
, SOURCE_ID_CHAR_2
, SOURCE_ID_CHAR_3
, SOURCE_ID_CHAR_4
FROM XLA.XLA_ACCT_PROG_DOCS_GT;
XLA.XLA_ACCT_PROG_DOCS_GT does not reference any database object
XLA.XLA_ACCT_PROG_DOCS_GT is referenced by following:
|
|
|