Sequence Command for BI PUblisher eText
Summary:
Sequence Command for BI PUblisher eText
Content (required):
Hi Folks,
I'm using eText template to do payments, I need a unique id for each payment but for each new payment made, the sequence returns to 001. The sequence should be incremented by 1 for each new payment file.
This is the sequence of commands I'm using in the template:
<DEFINE SEQUENCE> IFP_TD_WIRE_SEQ
<RESET AT LEVEL> PERIODIC_SEQUENCE
<INCREMENT BASIS> LEVEL
<START AT> /OutboundPaymentInstruction/PaymentInstructionInfo/PaymentSequence[SequenceName= ‘IFP_TD_WIRE_SEQ’]/LastValue + 1
<MAXIMUM> 999
<END DEFINE SEQUENCE > IFP_TD_WIRE_SEQ
Does anyone know what I can do so that each new payment made can increment by 1 ?
Tagged:
0