When using Rossum’s Data matching feature, you can upload various types of data representing list of vendors, purchase orders or delivery notes. However, each of the possible document types is a little bit different and each of its fields might need some pre-processing in order to achieve the best master data matching results.

By default Rossum supports data pre-processing for some of the pre-defined fields. Moreover, you can also store more complex data structures representing e.g. list of line items.

Fields with pre-defined preprocessing

You can use the column/key names defined below when uploading your master data. Once used, the values of such columns/keys will be cleaned according to the cleaning rules. Such pre-processing enables more accurate matching behavior (e.g. it is easier to remove “-” when matching “ID-123” to “ID123”)

Column/Key name	Cleaning rules
vat number	Removing non-alphanumeric characters
vat_number	Removing non-alphanumeric characters
iban	Removing non-alphanumeric characters
account num	Removing non-alphanumeric characters
account_num	Removing non-alphanumeric characters
tax number 1	Removing non-alphanumeric characters
tax_number_1	Removing non-alphanumeric characters
tax number 2	Removing non-alphanumeric characters
tax_number_2	Removing non-alphanumeric characters

More complex data

When implementing e.g. purchase order matching, you might want to store the line items of the individual purchase orders. Rossum’s data matching database can of course deal with such situation.

When using JSON format for the uploaded file, you can define a new key which can contain an array of objects. See the key “line_items” in the snippet below.

[
  {
    "po_number": "1",
    "total_amount": 2520,
    "line_items": [
      {
        "item_sku": "123",
        "item_description": "Creme liquide semi epaisse",
        "item_quantity": 50,
        "item_amount_base": 10,
        "item_amount_total": 500
      },
      {
        "item_sku": "124",
        "item_description": "Beurre Demi-sel Moule de Bretagne",
        "item_quantity": 60,
        "item_amount_base": 20,
        "item_amount_total": 1200
      },
      {
        "item_sku": "125",
        "item_description": "Beurre Doux Tendre",
        "item_quantity": 40,
        "item_amount_base": 10,
        "item_amount_total": 400
      }
    ]
  },
  {
    "po_number": "2",
    "total_amount": 420,
    "line_items": [
      {
        "item_sku": "126",
        "item_description": "Lait Demi-Ecreme Bio",
        "item_quantity": 35,
        "item_amount_base": 10,
        "item_amount_total": 350
      }
    ]
  },
  {
    "po_number": "3",
    "total_amount": 480,
    "line_items": [
      {
        "item_sku": "127",
        "item_description": "Lait Demi-Ecreme",
        "item_quantity": 400,
        "item_amount_base": 10,
        "item_amount_total": 400
      }
    ]
  }
]