Overview

Global Configuration – Used to add or override columns such as merchant_id and txn_status. If all transactions belong to the same merchant, this configuration ensures consistency across all records.

Local Configuration – Allows processing logic to differ for ORDER, REFUND, and other types. Filters are applied based on specific conditions like transaction_type = ORDER, and correct mappings and transformations are applied.

Mapping – Maps the column headers from your uploaded transaction file to Juspay's internal field names.  For example, a column in your transaction file named "payment gateway" would be linked to Juspay's "gateway" field.

Validation – Ensures data quality by running checks like:

• Missing Value Check: Flags records with empty or null values in mandatory fields.

• Duplicate Record Check: Identifies repeated entries based on defined unique keys to avoid double processing.

• Date Format Validation: Confirms that all date fields adhere to the required format (e.g., YYYY-MM-DD), ensuring compatibility and consistency.

• Numeric Field Validation: Verifies that fields expected to be numeric contain only valid numerical values, with no letters or invalid symbols.

Checks – The check section is used to manage validation checks. You can enable or disable specific validations by including their names in the checks list.