TRANSACTION_TEMPLATE
// Change the GL from 0003010001335 to expected GL for Bangla QR. //
SET DEFINE OFF;
Insert into TRANSACTION_TEMPLATE
(ID, ACCOUNT_BRANCH_EXPRESSION, ACCOUNT_EXPRESSION, ACCOUNT_TYPE_EXPRESSION, ACTIVE,
AMOUNTCCYEXPRESSION, AMOUNTLCYEXPRESSION, AMOUNT_TYPE, TR_CODE, COMMAND_NAME,
CURRENCY_EXPRESSION, EXCHANGE_RATE_EXPRESSION, EXCHANGE_RATE_TYPE, IBTA_REQUIRED,
INITIATOR_BRANCH_EXPRESSION,
NARRATION_EXPRESSION, SET_NAME, SET_NUMBER, TRANSACTION_ENTRY_TYPE,
TRANSACTION_TYPE_CODE,
VALUE_DATE_EXPRESSION, ACCOUNT_CURRENCY_EXP, AMOUNTRCYEXPRESSION, EXCHANGE_RATE_EXP,
EXCHANGE_RATE_TYPE_EXP,
INST_DATE_EXPRESSION, INST_NO_EXPRESSION, INST_TYPE_EXPRESSION, EXP_LANG)
Values
(11000, '107', '[Link]', '[Link]', 1,
NULL, '[Link]', 0, '611', NULL,
'[Link]', NULL, 1, 0, '[Link]',
'"Bangla QR Transaction, Amount: " + [Link] + "BDT"', 'SET_ONE', 1, '''Debit''',
NULL,
'[Link]', '[Link]', '[Link]', NULL, NULL,
NULL, NULL, NULL, NULL);
Insert into TRANSACTION_TEMPLATE
(ID, ACCOUNT_BRANCH_EXPRESSION, ACCOUNT_EXPRESSION, ACCOUNT_TYPE_EXPRESSION, ACTIVE,
AMOUNTCCYEXPRESSION, AMOUNTLCYEXPRESSION, AMOUNT_TYPE, TR_CODE, COMMAND_NAME,
CURRENCY_EXPRESSION, EXCHANGE_RATE_EXPRESSION, EXCHANGE_RATE_TYPE, IBTA_REQUIRED,
INITIATOR_BRANCH_EXPRESSION,
NARRATION_EXPRESSION, SET_NAME, SET_NUMBER, TRANSACTION_ENTRY_TYPE,
TRANSACTION_TYPE_CODE,
VALUE_DATE_EXPRESSION, ACCOUNT_CURRENCY_EXP, AMOUNTRCYEXPRESSION, EXCHANGE_RATE_EXP,
EXCHANGE_RATE_TYPE_EXP,
INST_DATE_EXPRESSION, INST_NO_EXPRESSION, INST_TYPE_EXPRESSION, EXP_LANG)
Values
(12000, '107', '''0003010001335''', '''GL''', 1,
NULL, '[Link]', 0, '611', NULL,
'[Link]', NULL, 1, 0, '[Link]',
'"Bangla QR Transaction, Amount: " + [Link] + "BDT"', 'SET_ONE', 1, '''Credit''',
NULL,
'[Link]', '[Link]', '[Link]', NULL, NULL,
NULL, NULL, NULL, NULL);
COMMIT;
TRANSACTION_TEMPLATE_MAPPING
SET DEFINE OFF;
Insert into TRANSACTION_TEMPLATE_MAPPING
(ID, TR_CODE, TXN_TYPE, INITIATOR_BR_EXP, TXN_DESCRIPTION,
DEBIT_NARRATION_CHARGE_EXP, CREATED_BY, CREATE_BY_CLIENT, CREATE_DATE,
CREATE_DATE_TIME,
CREATE_TERMINAL, CREATE_USER_AGENT, UPDATED_BY, UPDATE_BY_CLIENT, UPDATE_DATE,
UPDATE_DATE_TIME, UPDATE_TERMINAL, UPDATE_USER_AGENT, VERIFY_BY, VERIFY_DATE,
VERIFY_DATE_TIME, VERIFY_TERMINAL, VERIFY_USER_AGENT, TXN_TYPE_EXPRESSION)
Values
(19000, '611', 'TRANSFER', '''107''', 'BanglaQR',
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL);
COMMIT;