[Home] [Help]
View: FABV_TRANS_LINES
View Text
SELECT ADJUSTMENT_TYPE
, DECODE(DEBIT_CREDIT_FLAG
, 'DR'
, ADJUSTMENT_AMOUNT)
, DECODE(DEBIT_CREDIT_FLAG
, 'CR'
, ADJUSTMENT_AMOUNT)
, TRANSACTION_HEADER_ID
, SOURCE_TYPE_CODE
, BOOK_TYPE_CODE
, ASSET_ID
, CODE_COMBINATION_ID
, DISTRIBUTION_ID
, PERIOD_COUNTER_ADJUSTED
, PERIOD_COUNTER_CREATED
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM FA_ADJUSTMENTS WITH READ ONLY
Columns
Name |
ACCOUNT_TYPE |
DEBIT_AMOUNT |
CREDIT_AMOUNT |
TRANSACTION_HEADER_ID |
SOURCE_TYPE_CODE |
BOOK_TYPE_CODE |
ASSET_ID |
CODE_COMBINATION_ID |
DISTRIBUTION_ID |
PERIOD_COUNTER_ADJUSTED |
PERIOD_COUNTER_CREATED |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |