[Home] [Help] [Dependency Information]
Object Name: | FA_ADJUSTMENTS_MRC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OFA.FA_ADJUSTMENTS_MRC_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Reporting set of books identification number for GL sets of books |
TRANSACTION_HEADER_ID | NUMBER | (15) | Yes | Unique identifier of the adjustment transaction |
SOURCE_TYPE_CODE | VARCHAR2 | (15) | Yes | Type of adjustment transaction |
ADJUSTMENT_TYPE | VARCHAR2 | (15) | Yes | Indicates the type of account this adjustment affects |
DEBIT_CREDIT_FLAG | VARCHAR2 | (2) | Yes | Indicates whether to debit (DR) or credit (CR) the account |
CODE_COMBINATION_ID | NUMBER | (15) | Account number to which the adjustment is posted | |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Book name |
ASSET_ID | NUMBER | (15) | Yes | Asset identification number |
ADJUSTMENT_AMOUNT | NUMBER | Yes | Amount of the adjustment | |
DISTRIBUTION_ID | NUMBER | (15) | Yes | Distribution identification number |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
ANNUALIZED_ADJUSTMENT | NUMBER | Adjustment amount for a period multiplied by number of periods in fiscal year for retroactive transactions | ||
JE_HEADER_ID | NUMBER | (15) | Journal entry header in general ledger | |
JE_LINE_NUM | NUMBER | (15) | Journal entry line in general ledger | |
PERIOD_COUNTER_ADJUSTED | NUMBER | (15) | Yes | Period in which the adjustment transaction applies |
PERIOD_COUNTER_CREATED | NUMBER | (15) | Yes | Period you entered the adjustment |
ASSET_INVOICE_ID | NUMBER | (15) | Invoice, if there is an invoice associated with the adjustment | |
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved for country-specific functionality | |
DEPRN_OVERRIDE_FLAG | VARCHAR2 | (1) | Override status ('D' - stands for depreciation amount was overridden, 'B' stands for bonus amount was overridden, 'A' stands for depreciation and bonus amounts were overridden) | |
TRACK_MEMBER_FLAG | VARCHAR2 | (1) | 'Y' - When this column is set to Yes, it indicates that account information reated at the member level. This column is set to Yes only when you use the Track Member Accounts feature | |
SOURCE_DEST_CODE | VARCHAR2 | (15) | Indicates whether this line is on the source or destination side of a transaction | |
SOURCE_LINE_ID | NUMBER | (15) | Source line internal identifer | |
ADJUSTMENT_LINE_ID | NUMBER | (15) | Yes | System generated adjustment line identification number. |
Cut, paste (and edit) the following text to query this object:
SELECT SET_OF_BOOKS_ID
, TRANSACTION_HEADER_ID
, SOURCE_TYPE_CODE
, ADJUSTMENT_TYPE
, DEBIT_CREDIT_FLAG
, CODE_COMBINATION_ID
, BOOK_TYPE_CODE
, ASSET_ID
, ADJUSTMENT_AMOUNT
, DISTRIBUTION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ANNUALIZED_ADJUSTMENT
, JE_HEADER_ID
, JE_LINE_NUM
, PERIOD_COUNTER_ADJUSTED
, PERIOD_COUNTER_CREATED
, ASSET_INVOICE_ID
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, DEPRN_OVERRIDE_FLAG
, TRACK_MEMBER_FLAG
, SOURCE_DEST_CODE
, SOURCE_LINE_ID
, ADJUSTMENT_LINE_ID
FROM APPS.FA_ADJUSTMENTS_MRC_V;
|
|
|