Column mapping: Vendors

Mappings · approved version 1

Canonical fields and suggestions

Canonical fields
Field	Required	Approved source	Suggested source	Notes
party_code	required	Vendor ID	Vendor ID(synonym)	—
name	required	Vendor Name	Vendor Name(synonym)	—
address_line1	optional	Address	Address(synonym)	—
city	optional	City	City(exact)	—
region	optional	State	State(synonym)	—
postal_code	optional	Zip	Zip(synonym)	—
tax_id_last4	optional	Tax ID	Tax ID(synonym)	—
payment_terms_days	optional	Terms	Terms(synonym)	—
is_active	optional	Status	Status(synonym)	map the column's values to true and false
created_on	optional	Created	Created(synonym)	35 values also read as DD/MM/YYYY; confirm
notes	optional	Notes	Notes(exact)	—

Unmatched columns: Created By. Start from the suggestion

Edit and preview

Mapping (JSON)

{
  "fields": {
    "address_line1": {
      "steps": [
        {
          "step": "trim"
        }
      ],
      "source": "Address"
    },
    "city": {
      "steps": [
        {
          "step": "trim"
        }
      ],
      "source": "City"
    },
    "created_on": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "parse_date",
          "format": "MM/DD/YYYY"
        }
      ],
      "source": "Created"
    },
    "is_active": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "parse_boolean",
          "true": [
            "Active"
          ],
          "false": [
            "Inactive"
          ]
        }
      ],
      "source": "Status"
    },
    "name": {
      "steps": [
        {
          "step": "trim"
        }
      ],
      "source": "Vendor Name"
    },
    "notes": {
      "steps": [
        {
          "step": "trim"
        }
      ],
      "source": "Notes",
      "required": false
    },
    "party_code": {
      "steps": [
        {
          "step": "trim"
        }
      ],
      "source": "Vendor ID"
    },
    "payment_terms_days": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "value_map",
          "mapping": {
            "Due on receipt": "Net 0"
          },
          "passthrough": true
        },
        {
          "step": "regex_extract",
          "group": 1,
          "pattern": "^Net (\\d+)$"
        },
        {
          "step": "parse_integer"
        }
      ],
      "source": "Terms"
    },
    "postal_code": {
      "steps": [
        {
          "step": "trim"
        }
      ],
      "source": "Zip"
    },
    "region": {
      "steps": [
        {
          "step": "trim"
        }
      ],
      "source": "State"
    },
    "tax_id_last4": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "empty_to_null"
        },
        {
          "step": "regex_extract",
          "group": 1,
          "pattern": "(\\d{4})$"
        }
      ],
      "source": "Tax ID",
      "required": false
    }
  },
  "exclude_rows_where_blank": []
}

View-only in public demo

Preview a mapping to propose it.

Versions

Version 1 approvedchange request