[Home] [Help] [Dependency Information]
Object Name: | GL_ALOC_INP |
---|---|
Object Type: | TABLE |
Owner: | GMF |
FND Design Data: | GMF.GL_ALOC_INP |
Subobject Name: | |
Status: | VALID |
This table contains the expense and basis amount computed during the allocation processing. Currently these values are being brought over from Oracle Financials and the user has the option to maintain them via a maintenance screen.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_ALOC_INP_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | GL_ALOC_INP_ID |
GL_ALOC_INP_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PERIOD_ID
COST_TYPE_ID ALLOC_ID LINE_NO ACCOUNT_KEY_TYPE ACCOUNT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GL_ALOC_INP_ID | NUMBER | (15) | Yes | Surrogate for a row |
CALENDAR_CODE | VARCHAR2 | (10) | Cost Calendar code | |
PERIOD_CODE | VARCHAR2 | (10) | Cost Period code | |
ALLOC_ID | NUMBER | (10) | Yes | Allocation identifier |
LINE_NO | NUMBER | (10) | Yes | Allocation line |
ACCOUNT_KEY_TYPE | NUMBER | (10) | Yes | 0-Expense; 1-Basis |
ACCOUNT_KEY | VARCHAR2 | (255) | Expense/Basis Account key | |
ACCOUNT_DESC | VARCHAR2 | (70) | Expense/Basis Account Key Description | |
AMOUNT | NUMBER | Yes | Expense/Basis Amount | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
TRANS_CNT | NUMBER | (10) | Not currently used | |
DELETE_MARK | NUMBER | (5) | Yes | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
ACCOUNT_ID | NUMBER | (15) | Account code combination id | |
COST_TYPE_ID | NUMBER | (15) | Cost Type identifier | |
PERIOD_ID | NUMBER | period identifier |
Cut, paste (and edit) the following text to query this object:
SELECT GL_ALOC_INP_ID
, CALENDAR_CODE
, PERIOD_CODE
, ALLOC_ID
, LINE_NO
, ACCOUNT_KEY_TYPE
, ACCOUNT_KEY
, ACCOUNT_DESC
, AMOUNT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TRANS_CNT
, DELETE_MARK
, TEXT_CODE
, ACCOUNT_ID
, COST_TYPE_ID
, PERIOD_ID
FROM GMF.GL_ALOC_INP;
GMF.GL_ALOC_INP does not reference any database object
GMF.GL_ALOC_INP is referenced by following:
|
|
|