Clock on the below link for more information :
http://www.ziddu.com/download/16394698/eTexttemplateFunctions.pdf.html
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 | |||
No comments:
Post a Comment