[Home] [Help] [Dependency Information]
Object Name: | GMF_LC_ACTUAL_COST_ADJS |
---|---|
Object Type: | TABLE |
Owner: | GMF |
FND Design Data: | GMF.GMF_LC_ACTUAL_COST_ADJS |
Subobject Name: | |
Status: | VALID |
This table used to store Actual Landed cost adjustments which are processed by actual cost proces for actual cost types
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GMF_LC_ACTUAL_COST_ADJS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ADJ_TRANSACTION_ID |
GMF_LC_ACTUAL_COST_ADJS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACCOUNTED_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AC_ADJUSTMENT_ID | NUMBER | Yes | Actual Cost LC Adjustment Identifier | |
ADJ_TRANSACTION_ID | NUMBER | Yes | Adjustment Transaction Identifier | |
ADJUSTMENT_QUANTITY | NUMBER | Adjustment Quantity | ||
COSTED_QUANTITY | NUMBER | Costed quantity, used in cost calculations | ||
TOTAL_QUANTITY | NUMBER | Total Quantity | ||
QUANTITY_UOM_CODE | VARCHAR2 | (25) | Quantity UOM Code | |
UNIT_BASE_PRICE | NUMBER | Unit Price for Adjustment in base currency | ||
BASE_AMOUNT | NUMBER | Actual LC Amount in base currency | ||
TRANS_AMOUNT | NUMBER | Actual LC Amount in Transactional currency | ||
BASE_ADJ_AMOUNT | NUMBER | Prorated Actual LC Adjustment in base currency | ||
TRANS_ADJ_AMOUNT | NUMBER | Prorated Actual LC Adjustment in transactional currency | ||
ADJUSTMENT_STATUS | NUMBER | (1) | Adjustment status: (0) Not applied (1) Applied | |
OUT_OF_PERIOD_IND | NUMBER | Indicator to indicate if adjustment is an out of period or not. 0 - Inperiod adjustment,1 - Out period adjustment | ||
PERIOD_ID | NUMBER | Period Identifier | ||
COST_TYPE_ID | NUMBER | Cost Type Identifier | ||
ACCOUNTED_FLAG | VARCHAR2 | (1) | Flag indicates Accounting pre processor status. N = not accounted, D = draft accounted, Null = Final Accounted | |
FINAL_POSTING_DATE | DATE | Date on which create accounting ran in Final mode | ||
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 | |
REQUEST_ID | NUMBER | Standard Concurrent Who Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Concurrent Who Column | ||
PROGRAM_ID | NUMBER | Standard Concurrent Who Column | ||
PROGRAM_UDPATE_DATE | DATE | Standard Concurrent Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT AC_ADJUSTMENT_ID
, ADJ_TRANSACTION_ID
, ADJUSTMENT_QUANTITY
, COSTED_QUANTITY
, TOTAL_QUANTITY
, QUANTITY_UOM_CODE
, UNIT_BASE_PRICE
, BASE_AMOUNT
, TRANS_AMOUNT
, BASE_ADJ_AMOUNT
, TRANS_ADJ_AMOUNT
, ADJUSTMENT_STATUS
, OUT_OF_PERIOD_IND
, PERIOD_ID
, COST_TYPE_ID
, ACCOUNTED_FLAG
, FINAL_POSTING_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UDPATE_DATE
FROM GMF.GMF_LC_ACTUAL_COST_ADJS;
GMF.GMF_LC_ACTUAL_COST_ADJS does not reference any database object
GMF.GMF_LC_ACTUAL_COST_ADJS is referenced by following:
|
|
|