[Home] [Help] [Dependency Information]
Object Name: | FA_BALANCES_REP_ITF |
---|---|
Object Type: | TABLE |
Owner: | FA |
FND Design Data: | OFA.FA_BALANCES_REP_ITF |
Subobject Name: | |
Status: | VALID |
FA_BALANCES_REP_ITF is an interface table tracking balances for RX reports.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FA_BALANCES_REP_ITF_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Concurrent request ID | ||
COMPANY | VARCHAR2 | (25) | Company of the asset | |
COST_CENTER | VARCHAR2 | (25) | Cost center of the asset | |
ACCOUNT | VARCHAR2 | (25) | Account of the asset | |
ASSET_NUMBER | VARCHAR2 | (15) | User assigned asset number | |
TAG_NUMBER | VARCHAR2 | (15) | Tag number of the asset | |
DESCRIPTION | VARCHAR2 | (80) | Description of the asset | |
BEGIN_BALANCE | NUMBER | Beginning balance of the asset | ||
ADDITIONS | NUMBER | Addition transactions of the asset | ||
ADJUSTMENTS | NUMBER | Adjustment transactions of the asset | ||
RETIREMENTS | NUMBER | Retirement transactions of the asset | ||
REVALUATIONS | NUMBER | Revaluation transactions of the asset | ||
RECLASSES | NUMBER | Reclass transactions of the asset | ||
CAPITALIZATIONS | NUMBER | Capitalization transactions of the asset | ||
TRANSFERS | NUMBER | Transfer transactions of the asset | ||
DEPRECIATION | NUMBER | Depreciation transactions of the asset | ||
AMORTIZATION | NUMBER | Amortization transactions of the asset | ||
END_BALANCE | NUMBER | Ending balance of the asset | ||
OUT_OF_BALANCE_FLAG | VARCHAR2 | (1) | Out of balance flag | |
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
CREATED_BY | NUMBER | Standard Who column | ||
CREATION_DATE | DATE | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
SERIAL_NUMBER | VARCHAR2 | (35) | Serial number of the asset | |
ASSET_KEY | VARCHAR2 | (240) | Identifies an asset key flexfield combination for the asset | |
INVENTORIAL | VARCHAR2 | (3) | Indicates whether the asset should be included in physical inventory | |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Book name | |
COST_ACCOUNT | VARCHAR2 | (25) | Cost account of the asset | |
COST_BEGIN_BALANCE | NUMBER | Beginning balance of the cost account | ||
ACCOUNT_DESCRIPTION | VARCHAR2 | (240) | Account description of the asset | |
DATE_PLACED_IN_SERVICE | DATE | Date asset was placed in service | ||
LIFE_IN_MONTHS | NUMBER | Life of the asset | ||
STL_DEPRECIATION_RATE | NUMBER | The straight-line depreciation rate of the asset | ||
DEPRN_METHOD | VARCHAR2 | (12) | Depreciation method of the asset | |
CATEGORY | VARCHAR2 | (500) | Category ccid of the asset | |
CONCAT_LOCATION | VARCHAR2 | (500) | Concatenated location segments of the asset | |
CONCAT_VENDOR_NAME | VARCHAR2 | (500) | Concatenated vendor name of the asset | |
CONCAT_INVOICE_NUMBER | VARCHAR2 | (500) | Concatenated invoice number of the asset | |
CONCAT_INVOICE_DESCRIPTION | VARCHAR2 | (500) | Concatenated invoice description of the asset | |
CONCAT_RETIREMENT_TYPE | VARCHAR2 | (500) | Concatenated retirement type of the asset | |
GROUP_ASSET_NUMBER | VARCHAR2 | (15) | Group asset number for any associated group asset. |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, COMPANY
, COST_CENTER
, ACCOUNT
, ASSET_NUMBER
, TAG_NUMBER
, DESCRIPTION
, BEGIN_BALANCE
, ADDITIONS
, ADJUSTMENTS
, RETIREMENTS
, REVALUATIONS
, RECLASSES
, CAPITALIZATIONS
, TRANSFERS
, DEPRECIATION
, AMORTIZATION
, END_BALANCE
, OUT_OF_BALANCE_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, SERIAL_NUMBER
, ASSET_KEY
, INVENTORIAL
, BOOK_TYPE_CODE
, COST_ACCOUNT
, COST_BEGIN_BALANCE
, ACCOUNT_DESCRIPTION
, DATE_PLACED_IN_SERVICE
, LIFE_IN_MONTHS
, STL_DEPRECIATION_RATE
, DEPRN_METHOD
, CATEGORY
, CONCAT_LOCATION
, CONCAT_VENDOR_NAME
, CONCAT_INVOICE_NUMBER
, CONCAT_INVOICE_DESCRIPTION
, CONCAT_RETIREMENT_TYPE
, GROUP_ASSET_NUMBER
FROM FA.FA_BALANCES_REP_ITF;
FA.FA_BALANCES_REP_ITF does not reference any database object
FA.FA_BALANCES_REP_ITF is referenced by following:
|
|
|