Journal Entry Reserve Ledger
Summary
Customization of the Journal Entry Reserve LedgerContent
I'm customising the Journal Entry Reserve Ledger report - I am trying to add new data columns and change the report, the questions i have are as followed:
1. What do you need to enter in the 'Lexicon Flexfields' to allow customisation of the Data Model? (I have attached screenshot and code for reference)
2. Has anyone successfully customised this report before?
Thanks,
Elliot
Version
19Code Snippet
SELECT &ACCT_FLEX_BAL_SEG COMP_CODE, decode(TRANSACTION_TYPE,'B',&RSV_FLEX_ACCT_SEG, &ACCT_FLEX_ACCT_SEG ) GL_ACCOUNT, &RSV_FLEX_ACCT_SEG RSV_ACCOUNT, &ACCT_FLEX_COST_SEG COST_CENTER, --- AD.ASSET_NUMBER || '-' || ADTL.DESCRIPTION ASSET_NUMBER, ADTL.DESCRIPTION || ' [' || AD.ASSET_NUMBER || ']' ASSET_NUMBER, &D_CATEGORY D_CATEGORY1, to_char(DATE_PLACED_IN_SERVICE, 'YYYY-MM-DD') START_DATE, METHOD_CODE METHOD, RSV.LIFE LIFE, RSV.RATE ADJ_RATE, FCAT.SEGMENT1, -- CUSTOMISATION FCAT.SEGMENT2, -- CUSTOMISATION FCAT.SEGMENT3, -- CUSTOMISATION DS.BONUS_RATE BONUS_RATE, SUM(decode(transaction_type,'B',NULL,COST)) COST, SUM(RSV.DEPRN_AMOUNT) DEPRN_AMOUNT, SUM(RSV.YTD_DEPRN) YTD_DEPRN, SUM(RSV.DEPRN_RESERVE) DEPRN_RESERVE, sum(decode(transaction_type,'B',NULL,nvl(PERCENT,0))) PERCENT, TRANSACTION_TYPE T_TYPE, FA_FAS400_XMLP_PKG.d_lifeformula(RSV.LIFE, RSV.RATE,
1