[Home] [Help] [Dependency Information]
Object Name: | GL_BC_PERIOD_MAP |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_BC_PERIOD_MAP |
Subobject Name: | |
Status: | VALID |
GL_BC_PERIOD_MAP was created to maximize the performance of a query on the GL_BALANCES table. The aforementioned query determines funds availability for journal entries. This table stores up to date information related to the accounting period(s) that need to be queried to perform a funds check.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_BC_PERIOD_MAP_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LEDGER_ID
TRANSACTION_PERIOD_NAME ACTUAL_FLAG BOUNDARY_CODE BUDGET_VERSION_ID QUERY_PERIOD_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEDGER_ID | NUMBER | (15) | Yes | Ledger defining column |
BOUNDARY_CODE | VARCHAR2 | (1) | Yes | Budgetary control time interval end point |
TRANSACTION_PERIOD_NAME | VARCHAR2 | (15) | Yes | Accounting period name for transaction awaiting funds check |
ACTUAL_FLAG | VARCHAR2 | (1) | Yes | Transaction balance type (Actual, Budget, or Encumbrance) |
BUDGET_VERSION_ID | NUMBER | (15) | Budget version defining column | |
QUERY_PERIOD_NAME | VARCHAR2 | (15) | Yes | Accounting period name for transactions that affect funds availability |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard Who column | |
REQUEST_ID | NUMBER | (15) | Concurrent process request id | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Extended Who column | |
PROGRAM_ID | NUMBER | (15) | Extended Who column | |
PROGRAM_UPDATE_DATE | DATE | Extended Who column |
Cut, paste (and edit) the following text to query this object:
SELECT LEDGER_ID
, BOUNDARY_CODE
, TRANSACTION_PERIOD_NAME
, ACTUAL_FLAG
, BUDGET_VERSION_ID
, QUERY_PERIOD_NAME
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM GL.GL_BC_PERIOD_MAP;
GL.GL_BC_PERIOD_MAP does not reference any database object
GL.GL_BC_PERIOD_MAP is referenced by following:
|
|
|