Untitled

insert into matching_rule (change_time, priority, name, condition, creation_time, close_time)
values (now(), 1, 'ROW_NUMB', 
'(((trans["Authoriz_row"] == "0" or trans["Authoriz_row"] == None) and int(event["rowNumb"]) == int(trans["Transact_row"])) or
(trans["Authoriz_row"] != "0" and trans["Authoriz_row"] != None and int(event["rowNumb"]) == int(trans["Authoriz_row"])))
and
(((trans["Appr_code"] == None or trans["Appr_code"] == '') and event["fld038"] == '') or
(trans["Appr_code"] != None and trans["Appr_code"] != '' and event["fld038"] == trans["Appr_code"]))
and
(event["fld025"] != 1777 or event["fld025"] == None)',
now(), null);

insert into matching_rule (change_time, priority, name, condition, creation_time, close_time)
values (now(), 2, 'TID', 
'(event["fld025"] != 1777 or event["fld025"] == None)
and
(event["fld095"] != None and trans["FLD_095"] != None and tlvParser(event["fld095"], "0003") == tlvParser(trans["FLD_095"], "0003"))',
now(), null);

insert into matching_rule (change_time, priority, name, condition, creation_time, close_time)
values (now(), 3, 'FIELDS', 
'(((trans["Appr_code"] == None or trans["Appr_code"] == '') and event["fld038"] == '') or
(trans["Appr_code"] != None and trans["Appr_code"] != '' and event["fld038"] == trans["Appr_code"]))
and
((event["fld037"] == trans["Ref_number"] and trans["Ref_number"] != None and trans["Ref_number"] != "" and event["fld037"] != None and event["fld037"] != "") or
((event["fld037"] == None or event["fld037"] == "") and trans["Ref_number"] != None and trans["Ref_number"] != "") or
((trans["Ref_number"] == None or trans["Ref_number"] == "") and event["fld037"] != None and event["fld037"] != ""))
and
((trans["Msg_type"] != None and trans["Msg_type"] != "" and (event["msgType"].startswith(trans["Msg_type"][0:2]))) or
((trans["Msg_type"] == "" or trans["Msg_type"] == None) and event["msgType"] == trans["Msg_type"]))
and
event["fld026"] == trans["MCC_code"]
and
differenceBetweenAmounts(trans["Amount"], event["fld004"], 10)',
now(), null);