Column mapping: Payments

Mappings · approved version 1

Canonical fields and suggestions

Canonical fields
Field	Required	Approved source	Suggested source	Notes
payment_number	required	Payment No	Payment No(synonym)	—
direction	required	Type	Type(synonym)	map the column's values to: received, disbursed
payment_date	required	Date	Date(synonym)	838 values also read as DD/MM/YYYY; confirm
party_code	required	Name ID	—	—
method	required	Method	Method(exact)	map the column's values to: check, ach, wire
currency	required	Currency	Currency(exact)	—
amount	required	Amount	Amount(exact)	—
fx_rate	required	Exchange Rate	Exchange Rate(synonym)	—
functional_amount	required	Amount (USD)	—	—
reference	optional	Check/Ref No	—	—
applied_document	optional	Applied To	Applied To(synonym)	—
applied_amount	optional	Applied Amount	Applied Amount(exact)	—
unapplied_amount	optional	Unapplied	Unapplied(synonym)	—
party_name	optional	Name	Name(synonym)	—

Unmatched columns: Name ID, Check/Ref No, Amount (USD). Start from the suggestion

Edit and preview

Mapping (JSON)

{
  "fields": {
    "amount": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "parse_decimal",
          "thousands_separator": ","
        }
      ],
      "source": "Amount"
    },
    "applied_amount": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "empty_to_null"
        },
        {
          "step": "parse_decimal",
          "thousands_separator": ","
        }
      ],
      "source": "Applied Amount",
      "required": false
    },
    "applied_document": {
      "steps": [
        {
          "step": "trim"
        }
      ],
      "source": "Applied To",
      "required": false
    },
    "currency": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "currency"
        }
      ],
      "source": "Currency"
    },
    "direction": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "value_map",
          "mapping": {
            "Receipt": "received",
            "Bill Payment": "disbursed"
          }
        }
      ],
      "source": "Type"
    },
    "functional_amount": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "parse_decimal",
          "thousands_separator": ","
        }
      ],
      "source": "Amount (USD)"
    },
    "fx_rate": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "parse_decimal"
        }
      ],
      "source": "Exchange Rate"
    },
    "method": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "value_map",
          "mapping": {
            "ACH": "ach",
            "WIRE": "wire",
            "CHECK": "check"
          }
        }
      ],
      "source": "Method"
    },
    "party_code": {
      "steps": [
        {
          "step": "trim"
        }
      ],
      "source": "Name ID"
    },
    "party_name": {
      "steps": [
        {
          "step": "trim"
        }
      ],
      "source": "Name"
    },
    "payment_date": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "parse_date",
          "format": "MM/DD/YYYY"
        }
      ],
      "source": "Date"
    },
    "payment_number": {
      "steps": [
        {
          "step": "trim"
        }
      ],
      "source": "Payment No"
    },
    "reference": {
      "steps": [
        {
          "step": "trim"
        }
      ],
      "source": "Check/Ref No",
      "required": false
    },
    "unapplied_amount": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "empty_to_null"
        },
        {
          "step": "parse_decimal",
          "thousands_separator": ","
        }
      ],
      "source": "Unapplied",
      "required": false
    }
  },
  "exclude_rows_where_blank": []
}

Preview a mapping to propose it.

Versions

Version 1 approvedchange request