Journal Entry Reserve Ledger

Summary

Customization of the Journal Entry Reserve Ledger

Content

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

19

Code 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,