[Home] [Help] [Dependency Information]
Object Name: | GL_ALOC_EXP |
---|---|
Object Type: | TABLE |
Owner: | GMF |
FND Design Data: | GMF.GL_ALOC_EXP |
Subobject Name: | |
Status: | VALID |
This table contains the expense to allocate information for an
allocation code. The data from this table is used for GL expense
allocation processing in determining total expense to allocate.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_ALOC_EXP_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ALLOC_ID
LINE_NO |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALLOC_ID | NUMBER | (10) | Yes | Allocation identifier |
LINE_NO | NUMBER | (10) | Yes | Line number |
FROM_ACCOUNT | VARCHAR2 | (255) | From Account Key | |
TO_ACCOUNT | VARCHAR2 | (255) | To Account Key | |
FROM_DESCRIPTION | VARCHAR2 | (70) | Description of From Account Key | |
TO_DESCRIPTION | VARCHAR2 | (70) | Description of To Account Key | |
BALANCE_TYPE | NUMBER | (10) | Yes | Balance Type Indicator. 0 = Statistical; 1 = Budget; 2 = Actual |
EXP_YTD_PTD | NUMBER | (10) | Yes | Indicator for using period to date or year to date expenses for allocation: 0 = Period to Date Expenses will be Allocated; 1 = Year to Date Expenses will be Allocated |
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 | |
DELETE_MARK | NUMBER | (5) | Yes | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TRANS_CNT | NUMBER | (10) | Not currently used | |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
FROM_ACCOUNT_ID | NUMBER | (15) | From Account code combination id | |
TO_ACCOUNT_ID | NUMBER | (15) | To Account code combination id |
Cut, paste (and edit) the following text to query this object:
SELECT ALLOC_ID
, LINE_NO
, FROM_ACCOUNT
, TO_ACCOUNT
, FROM_DESCRIPTION
, TO_DESCRIPTION
, BALANCE_TYPE
, EXP_YTD_PTD
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, DELETE_MARK
, TRANS_CNT
, TEXT_CODE
, FROM_ACCOUNT_ID
, TO_ACCOUNT_ID
FROM GMF.GL_ALOC_EXP;
GMF.GL_ALOC_EXP does not reference any database object
GMF.GL_ALOC_EXP is referenced by following:
|
|
|