[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GL_ALOC_BAS |
|---|---|
| Object Type: | TABLE |
| Owner: | GMF |
| FND Design Data: |  GMF.GL_ALOC_BAS
|
| Subobject Name: | |
| Status: | VALID |
This table contains the basis information for an allocation code
about the items to which expenses will be allocated, the allocation
criteria based upon the basis account or fixed percent, and the cost
component class bucket to which the allocated cost will go.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GL_ALOC_BAS_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ALLOC_ID
LINE_NO
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ALLOC_ID | NUMBER | (10) | Yes | Allocation Code identifier |
| LINE_NO | NUMBER | (10) | Yes | Line number |
| ALLOC_METHOD | NUMBER | (5) | Yes | Indicator for allocation method. 0 = Alloc Percent Depends on Basis Amount; 1 = Fixed Percent is Used for Allocation. Note that alloc_method will have same value for all lines of an alloc_id |
| ITEM_ID | NUMBER | (10) | Item to which allocation will be done | |
| BASIS_ACCOUNT_KEY | VARCHAR2 | (255) | The basis account used to compute the allocation percentage. This will have a value only for alloc_method = 0. | |
| BASIS_ACCOUNT_DESC | VARCHAR2 | (70) | The basis account description | |
| BALANCE_TYPE | NUMBER | (10) | Indicator for the type of the basis account. Only for alloc_method = 0. 0 = Statistical; 1 = Budget; 2 = Actual | |
| BAS_YTD_PTD | NUMBER | (10) | YTP/PTD Indicator. Determines which amount to use to compute the allocation %age. Only for alloc_method = 0. 0 = Use Period to Date Basis Amount; 1 = Use Year to Date Basis Amount | |
| FIXED_PERCENT | NUMBER | Indicate fixed allocation %age. Only for alloc_method = 1. | ||
| CMPNTCLS_ID | NUMBER | (10) | Yes | surrogate for the component class assigned to the cost from expense. |
| WHSE_CODE | VARCHAR2 | (4) | The whse to which the cost 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 | |
| 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 | |
| DELETE_MARK | NUMBER | (5) | Yes | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| BASIS_ACCOUNT_ID | NUMBER | (15) | basis account code combination id | |
| BASIS_TYPE | NUMBER | (2) | basis type | |
| INVENTORY_ITEM_ID | NUMBER | (15) | inventory item identifier | |
| ORGANIZATION_ID | NUMBER | (15) | organization identifier | |
| ANALYSIS_CODE#1 | VARCHAR2 | (32) | Yes | ANALYSIS CODE #1 |
Cut, paste (and edit) the following text to query this object:
SELECT ALLOC_ID
, LINE_NO
, ALLOC_METHOD
, ITEM_ID
, BASIS_ACCOUNT_KEY
, BASIS_ACCOUNT_DESC
, BALANCE_TYPE
, BAS_YTD_PTD
, FIXED_PERCENT
, CMPNTCLS_ID
, WHSE_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TRANS_CNT
, TEXT_CODE
, DELETE_MARK
, BASIS_ACCOUNT_ID
, BASIS_TYPE
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, ANALYSIS_CODE#1
FROM GMF.GL_ALOC_BAS;
GMF.GL_ALOC_BAS does not reference any database object
GMF.GL_ALOC_BAS is referenced by following:
GMF
GL_ALOC_BAS#
|
|
|
|