[Home] [Help] [Dependency Information]
Object Name: | IGI_IAC_BALANCES_REPORT |
---|---|
Object Type: | TABLE |
Owner: | IGI |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGI_BALANCES_REPORT_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | ASSET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSET_ID | NUMBER | (15) | Yes | Asset identifier |
DISTRIBUTION_CCID | NUMBER | (15) | Yes | Depreciation expense account for asset |
ADJUSTMENT_CCID | NUMBER | (15) | Adjustment code combination identifier | |
CATEGORY_BOOKS_ACCOUNT | VARCHAR2 | (25) | Account being adjusted or depreciation reserve account | |
SOURCE_TYPE_CODE | VARCHAR2 | (15) | Yes | Transaction or balance this row describes |
AMOUNT | NUMBER | Depreciation, adjustment, cost or reserve balance account | ||
COST_ACCOUNT | VARCHAR2 | (25) | Asset Cost account | |
COST_BEGIN_BALANCE | NUMBER | Cost beginning balance amount | ||
DATA_SOURCE | VARCHAR2 | (30) | Yes | 'FA' if FA row, 'IAC' if IAC row |
DISPLAY_ORDER | NUMBER | (5) | The order of the records to be displayed in the report with in the records for a grouping of company, category, cost center and data source | |
COMPANY | VARCHAR2 | (30) | Company segment information | |
COST_CENTER | VARCHAR2 | (30) | Cost center information | |
ACCOUNT | VARCHAR2 | (30) | Account segment information |
Cut, paste (and edit) the following text to query this object:
SELECT ASSET_ID
, DISTRIBUTION_CCID
, ADJUSTMENT_CCID
, CATEGORY_BOOKS_ACCOUNT
, SOURCE_TYPE_CODE
, AMOUNT
, COST_ACCOUNT
, COST_BEGIN_BALANCE
, DATA_SOURCE
, DISPLAY_ORDER
, COMPANY
, COST_CENTER
, ACCOUNT
FROM IGI.IGI_IAC_BALANCES_REPORT;
IGI.IGI_IAC_BALANCES_REPORT does not reference any database object
IGI.IGI_IAC_BALANCES_REPORT is referenced by following:
|
|
|