Subversion Repositories DevTools

Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$destinationParticipantId$', '@PARTICIPANTID', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@PARTICIPANTID', '101', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$deviceId$', '@DEVICEID', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$formatVersion$', '@FORMATVERSION', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$txnDateTime$', '@UTCNOW', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$businessDate$', '@TODAY', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$txnMac$', '@MAC', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$udsn$', '@UDSN', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$keyVersion$', '@KEYVERSION', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$processedDate$', '@YESTERDAY', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$udSubType$', '@UDSUBTYPE', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$cardSerialNumber$', '@MYCARD', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$udType$', '@UDTYPE', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@DEVICEID', '12451841', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$applicationProviderId$', '101', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$cardLifeCycleCount$', '@LIFECYCLE', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@LIFECYCLE', '0', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$applicationSerialNumber$', '@APPSERIALNUM', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@APPSERIALNUM', '1', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$cardType$', '@CARDTYPE', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@CARDTYPE', '2', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@KEYVERSION', '1', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$applicationType$', '@APPTYPE', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@APPTYPE', 'Transit', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@MYCARD', '1000000', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$operatorShiftNumber$', '@OPSHIFTNUM', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@OPSHIFTNUM', '1', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@PASS30DAYMAG', '4021', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@PRODUCTPURSE', '40', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$currencyIndicatorFinDetails$', '@CURRENCY', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@CURRENCY', '752', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$taxRate$', '@TAXRATE6', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@TAXRATE6', '6', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$taxCode$', '@TAXCODE1', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@TAXCODE1', '1', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@NUMOFPAYMENTS', '1', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$paymentMethod[1]$', '@CASH', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@CASH', '1', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@PASSEMPLOYEE', '"SL Employee Card"', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@CARDRANGE', '@SEQ(#CSN,1,1100000,1)', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@PSN', '@SEQ(PSN,1,10000,1)', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$cardIssuerId$', '101', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$sourceParticipantId$', '@DEFAULTPARTICIPANT', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@DEFAULTPARTICIPANT', '@SL', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$serviceParticipantId$', '@DEFAULTPARTICIPANT', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$deviceSSN$', '1', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$cardActionSequenceNumber$', '0', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$blockedViaActionlist$', 'True', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$reasonCode$', '2', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$expiryDate$', '@TOMORROW', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$productIssuerId$', '101', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$productSerialNumber$', '2', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$productType$', '@PASSEMPLOYEE', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$productActionSequenceNumber$', '0', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$passEndDateTime$', '@TOMORROW', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$viaActionlist$', 'False', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$transactionValue$', '@VALUE', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$numberOfPayments$', '1', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@SL', '101', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@VALUE', '100', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$routeLineId$', '1', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$originLocation$', '0', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@UDSN', '@SEQ(#UDSN,1,10000000,1,DEVICEID)', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$paymentValue[1]$', '@VALUE', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@ANNUALCARDMAGNETIC', '4061', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$paymentValue$', '@VALUE', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$paymentMethod$', '@CASH', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@GAK1', '12451841', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@AUDEVICEID', '12451841', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@RANGEOFGAKS', '@SEQ(GAKS,12451841,12452840,1)', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$applicationPassengerType$', '255', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$applicationPersonaliseCat$', '1', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$numberOfPassengers$', '1', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$salesTax$', '@SALESTAXVALUE', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@SALESTAXVALUE', '6', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$deviceLocation$', '0', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$ptsn$', '@PTSN', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@PTSN', '1', 1);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '@SAMID', '1', 0);
Insert into TSB.ITERATION_PARAMS
   (PROJECT_CODE, ITERATION, NAME, FIELDVALUE, SUPPORTED)
 Values
   ('SLS', 25, '$unblockedViaActionlist$', 'True', 0);
COMMIT;