eText Template Usefull Functions

Format Setup:

Hint: Define formatting options…

(TEMPLATE TYPE)	FIXED_POSITION_BASED
(OUTPUT CHARACTER SET)	iso-8859-1
(CASE CONVERSION)	Upper
(NEW RECORD CHARACTER)	Carriage Return
(INVALID CHARACTERS)	¿¶
(REPLACE CHARACTERS)
Ä	AO
Ë	EO
Ï	IO
Ö	OO
Ü	UO
+	?+
:	?:
‘	?’
?	??
_
(END REPLACE CHARACTERS)

Format Data Levels: Hint: Define data levels that are needed in the format which do not exist in data extract…
(DEFINE LEVEL)	PayMethodPayerInstrumentPayDate
(BASE LEVEL)	OutboundPayment
(GROUPING CRITERIA)	PaymentMethod/PaymentMethodFormatValue, Payer/PartyInternalID, BankAccount/BankAccountInternalID, PaymentDate
(END DEFINE LEVEL)	PayMethodPayerInstrumentPayDate

Sequences: Hint: Define sequence generators…
(DEFINE SEQUENCE)	(XXXX_TEST_SEQ)
(RESET AT LEVEL)	PayMethodPayerInstrumentPayDate
(INCREMENT BASIS)	LEVEL
(START AT)	1
(END DEFINE SEQUENCE )	(XXXX_TEST_SEQ)

Concatenated Records:

Hint: Define fields that are composed of concatenated records…

(DEFINE CONCATENATION)	(XXXX_TEST) Use this name to display the looping
(BASE LEVEL)	DocumentPayable
(ELEMENT)	DocumentNumber/ReferenceNumber
(DELIMITER)	‘,’
(END DEFINE CONCATENATION)	(XXXX_TEST)

Format Data Records:

(BEGIN FILLER BLOCK)	AllRecordsBlock
(FILLER CHARACTER)	9
(BLOCK SIZE)	10

(This is for total records should be divided by (10) and filled with (9) )

(END FILLER BLOCK)

AllRecordsBlock

(*****) à Number of characters to display

(***) à Value Position (Not Required)

(LEVEL)		OutboundPaymentInstruction
(POSITION)	(LENGTH)	(FORMAT)	(PAD)	(DATA)
(NEW RECORD)		FILE_HEADER
(***)	(*****)	Alpha	R, ‘ ‘	REPLACE((Value),’’)
		Number		ROUND((value)*12345.56)
				TO_CHAR((Value)) TO_NUMBER((Value))
		Number, Binary, Input_Hex		SEQUENCE_NUMBER((XXXX_TEST_SEQ))
		Number, BCD		SUM((Value))
				COUNT((Value))
				Length((Value))
				CEIL(((Value)) DIV (10))
		Date,DD-MON-YYYY		SYSDATE
		Date, BCD, MMDDhhmiss		TO_DATE(../(outer group values), ‘YYYYMMDD’, ‘GMT’)
				UPPER((value)) LOWER((value))
				Message_Length()
				INSTR((value),‘ ‘ ,-1)) SUBSTR((Value),1,8)
				MAX((value)) MIN((value))
				NVL(‘(Value)’,‘N’)
				DECODE((Value),1,’1111’, 2,’22222’, (value))
				IF Value1 = (Condition1) THEN Result1 ELSIF Value2 = (Condition2) THEN Result2 ELSE Result3 END IF
				LPAD(‘0’, 40, ‘0’) RPAD(‘0’, 40, ‘0’)

(LEVEL)		OutboundPayment
(SORT ASCENDING)		Payee/Name
(POSITION)	(LENGTH)	(FORMAT)	(PAD)	(DATA)
(NEW RECORD)		ADDENDA
(DISPLAY CONDITION)		Payment Method = (Condition1) OR PaymentMethod = (Condition2)
	80	Alpha	R, ' '	(XXXX_TEST)
(END LEVEL)		OutboundPayment