C1-TND-DERIV

This algorithm reads the data in the BO_​DATA_​AREA column of the C1_​UPL_​REQUEST table and accordingly inserts the records in the C1_​UPLOAD_​REQ_​DTLS table. In addition, the status of each record in the C1_​UPLOAD_​REQ_​DTLS table is set to Pending.

It validates the following:

• Either the external reference ID or check number is specified in the record.

• Cancel reason is specified in the record.

It then derives the payment tender using the external reference ID or check number and the payment event associated with the respective payment tender. It also considers additional filters, such as external source ID, tender type, and/or tender amount, if any, given in the record while deriving the payment tender. Note that if both the external reference ID and check number are given in the record, the system considers only external reference ID and not check number while deriving the payment tender.

Once the payment tender and payment event are derived, the corresponding record is updated in the C1_​UPLOAD_​REQ_​DTLS table. If the system could not derive the payment tender and payment event, the status of the record in the C1_​UPLOAD_​REQ_​DTLS table is changed to Invalid. In addition, if any of the above validations fail, the status of the record in the C1_​UPLOAD_​REQ_​DTLS table is changed to Invalid.

This algorithm also derives the fields which can be used as search filters based on the mapping defined in the respective upload request type.