{"id":8884,"date":"2019-05-20T22:58:23","date_gmt":"2019-05-20T20:58:23","guid":{"rendered":"https:\/\/sourcing-force.com\/?p=8884"},"modified":"2022-09-03T19:24:30","modified_gmt":"2022-09-03T17:24:30","slug":"example-of-spend-data-classification","status":"publish","type":"post","link":"https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/","title":{"rendered":"Example of Spend Data Classification"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text admin_label=”Text” _builder_version=”4.17.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n

\"\"<\/p>\n

[\/et_pb_text][et_pb_text admin_label=”Text” _builder_version=”4.17.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n

The amount of detail in spend data differs between companies. What is a critical field to one industry may not matter to another. As our team builds classification rules, we look at any and all fields that contain useful information.<\/span><\/p>\n

[\/et_pb_text][et_pb_text admin_label=”Text” _builder_version=”4.17.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n

Typical fields we may see in a file from a client:<\/span><\/strong><\/span><\/p>\n

[\/et_pb_text][et_pb_text admin_label=”Text” _builder_version=”4.17.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n

1 – Supplier Name<\/span><\/p>\n

2 – Supplier Code<\/span><\/p>\n

3 – Supplier Location<\/span><\/p>\n

4 – Line Item Description<\/span><\/p>\n

5 – Material\/Category Description<\/span><\/p>\n

6 – GL Account Description<\/span><\/p>\n

7 – Spend Amount<\/span><\/p>\n

8 – Source System<\/span><\/p>\n

 <\/p>\n

\n

In our experience, GL account descriptions are usually inaccurate and we rarely build rules based on this field. We can quickly categorize internal transactions based on supplier names.<\/span><\/p>\n<\/blockquote>\n

[\/et_pb_text][et_pb_text admin_label=”Text” _builder_version=”4.17.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n

An example of a simple classification rule is:<\/span><\/strong><\/span><\/h2>\n

[\/et_pb_text][et_pb_text admin_label=”Text” _builder_version=”4.17.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n

Classify transactions where\u00a0Supplier Name equals \u201cCargill Inc\u201d<\/em>\u00a0and\u00a0Material Description contains \u201cMalt\u201d<\/em>\u00a0to the client\u2019s category \u201cRaw Materials \u2013 Malt.\u201d This may alternatively be classified to UNSPSC code 50221302 \u2013 Barley Malt.<\/span><\/p>\n

 <\/p>\n

The level of detail to a classification rule can be an indicator of strength, and stronger rules often make for smarter rules. For example, a rule based on the conditions where\u00a0Supplier Name equals \u201cCargill Inc\u201d, Item Description contains \u201cMalt\u201d, Country Code contains \u201cGB\u201d,\u00a0<\/em>and\u00a0Spend Source equals \u201cInvoice\u201d<\/em>\u00a0will account for each of these four variables. The specificity of this rule insures that all invoiced Cargill Inc spend on malt that originated from Great Britain is classified correctly under Barley Malt.\u00a0\u00a0<\/span><\/p>\n

 <\/p>\n

\"\"<\/a><\/p>\n

\u00a0<\/span><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

The amount of detail in spend data differs between companies. What is a critical field to one industry may not matter to another. As our team builds classification rules, we look at any and all fields that contain useful information.Typical fields we may see in a file from a client:1 – Supplier Name 2 – […]<\/p>\n","protected":false},"author":2,"featured_media":8749,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"\"\"\r\n\r\nThe amount of detail in spend data differs between companies. What is a critical field to one industry may not matter to another. As our team builds classification rules, we look at any and all fields that contain useful information.<\/span><\/strong>\r\n\r\n \r\n\r\nTypical fields we may see in a file from a client:<\/span><\/strong><\/span>\r\n\r\n \r\n\r\n1 - Supplier Name<\/span>\r\n\r\n2 - Supplier Code<\/span>\r\n\r\n3 - Supplier Location<\/span>\r\n\r\n4 - Line Item Description<\/span>\r\n\r\n5 - Material\/Category Description<\/span>\r\n\r\n6 - GL Account Description<\/span>\r\n\r\n7 - Spend Amount<\/span>\r\n\r\n8 - Source System<\/span>\r\n\r\n \r\n

In our experience, GL account descriptions are usually inaccurate and we rarely build rules based on this field. We can quickly categorize internal transactions based on supplier names.\u00a0<\/span><\/blockquote>\r\n \r\n\r\nAn example of a simple classification rule is:<\/span><\/strong><\/span>\r\n\r\n \r\n\r\nClassify transactions where\u00a0Supplier Name equals \u201cCargill Inc\u201d<\/em>\u00a0and\u00a0Material Description contains \u201cMalt\u201d<\/em>\u00a0to the client\u2019s category \u201cRaw Materials \u2013 Malt.\u201d This may alternatively be classified to UNSPSC code 50221302 \u2013 Barley Malt.<\/span>\r\n\r\n \r\n\r\nThe level of detail to a classification rule can be an indicator of strength, and stronger rules often make for smarter rules. For example, a rule based on the conditions where\u00a0Supplier Name equals \u201cCargill Inc\u201d, Item Description contains \u201cMalt\u201d, Country Code contains \u201cGB\u201d,\u00a0<\/em>and\u00a0Spend Source equals \u201cInvoice\u201d<\/em>\u00a0will account for each of these four variables. The specificity of this rule insures that all invoiced Cargill Inc spend on malt that originated from Great Britain is classified correctly under Barley Malt.\u00a0\u00a0<\/span>\r\n\r\n \r\n\r\n\"\"<\/a>\r\n\r\n\u00a0<\/span>","_et_gb_content_width":"","footnotes":""},"categories":[36,46],"tags":[],"class_list":["post-8884","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spend-analytics","category-source-to-pay"],"yoast_head":"\nExample of Spend Data Classification - Sourcing Force<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Example of Spend Data Classification - Sourcing Force\" \/>\n<meta property=\"og:description\" content=\"The amount of detail in spend data differs between companies. What is a critical field to one industry may not matter to another. As our team builds classification rules, we look at any and all fields that contain useful information.Typical fields we may see in a file from a client:1 - Supplier Name 2 - […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/\" \/>\n<meta property=\"og:site_name\" content=\"Sourcing Force\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-20T20:58:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-03T17:24:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sourcing-force.com\/wp-content\/uploads\/2019\/05\/Screen-Shot-2019-05-05-at-9.33.48-PM.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1882\" \/>\n\t<meta property=\"og:image:height\" content=\"658\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Olivier Audino\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SourcingForce\" \/>\n<meta name=\"twitter:site\" content=\"@SourcingForce\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Olivier Audino\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sourcing-force.com\\\/en\\\/example-of-spend-data-classification\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sourcing-force.com\\\/en\\\/example-of-spend-data-classification\\\/\"},\"author\":{\"name\":\"Olivier Audino\",\"@id\":\"https:\\\/\\\/sourcing-force.com\\\/#\\\/schema\\\/person\\\/481e000db1e02e01e9dc0913e2430fbd\"},\"headline\":\"Example of Spend Data Classification\",\"datePublished\":\"2019-05-20T20:58:23+00:00\",\"dateModified\":\"2022-09-03T17:24:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sourcing-force.com\\\/en\\\/example-of-spend-data-classification\\\/\"},\"wordCount\":460,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/sourcing-force.com\\\/en\\\/example-of-spend-data-classification\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sourcing-force.com\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/Screen-Shot-2019-05-05-at-9.33.48-PM.png\",\"articleSection\":[\"Spend analytics\",\"Strategic Sourcing\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sourcing-force.com\\\/en\\\/example-of-spend-data-classification\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sourcing-force.com\\\/en\\\/example-of-spend-data-classification\\\/\",\"url\":\"https:\\\/\\\/sourcing-force.com\\\/en\\\/example-of-spend-data-classification\\\/\",\"name\":\"Example of Spend Data Classification - Sourcing Force\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sourcing-force.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sourcing-force.com\\\/en\\\/example-of-spend-data-classification\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sourcing-force.com\\\/en\\\/example-of-spend-data-classification\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sourcing-force.com\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/Screen-Shot-2019-05-05-at-9.33.48-PM.png\",\"datePublished\":\"2019-05-20T20:58:23+00:00\",\"dateModified\":\"2022-09-03T17:24:30+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/sourcing-force.com\\\/#\\\/schema\\\/person\\\/481e000db1e02e01e9dc0913e2430fbd\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sourcing-force.com\\\/en\\\/example-of-spend-data-classification\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sourcing-force.com\\\/en\\\/example-of-spend-data-classification\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sourcing-force.com\\\/en\\\/example-of-spend-data-classification\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sourcing-force.com\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/Screen-Shot-2019-05-05-at-9.33.48-PM.png\",\"contentUrl\":\"https:\\\/\\\/sourcing-force.com\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/Screen-Shot-2019-05-05-at-9.33.48-PM.png\",\"width\":1882,\"height\":658},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sourcing-force.com\\\/en\\\/example-of-spend-data-classification\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/sourcing-force.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Example of Spend Data Classification\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sourcing-force.com\\\/#website\",\"url\":\"https:\\\/\\\/sourcing-force.com\\\/\",\"name\":\"Sourcing Force\",\"description\":\"Digitalisez l\u2019int\u00e9gralit\u00e9 de votre processus Achat !\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sourcing-force.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sourcing-force.com\\\/#\\\/schema\\\/person\\\/481e000db1e02e01e9dc0913e2430fbd\",\"name\":\"Olivier Audino\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sourcing-force.com\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/olivier-audino-150x150.png\",\"url\":\"https:\\\/\\\/sourcing-force.com\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/olivier-audino-150x150.png\",\"contentUrl\":\"https:\\\/\\\/sourcing-force.com\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/olivier-audino-150x150.png\",\"caption\":\"Olivier Audino\"},\"url\":\"https:\\\/\\\/sourcing-force.com\\\/en\\\/author\\\/olivieraudino\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Example of Spend Data Classification - Sourcing Force","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/","og_locale":"en_US","og_type":"article","og_title":"Example of Spend Data Classification - Sourcing Force","og_description":"The amount of detail in spend data differs between companies. What is a critical field to one industry may not matter to another. As our team builds classification rules, we look at any and all fields that contain useful information.Typical fields we may see in a file from a client:1 - Supplier Name 2 - […]","og_url":"https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/","og_site_name":"Sourcing Force","article_published_time":"2019-05-20T20:58:23+00:00","article_modified_time":"2022-09-03T17:24:30+00:00","og_image":[{"width":1882,"height":658,"url":"https:\/\/sourcing-force.com\/wp-content\/uploads\/2019\/05\/Screen-Shot-2019-05-05-at-9.33.48-PM.png","type":"image\/png"}],"author":"Olivier Audino","twitter_card":"summary_large_image","twitter_creator":"@SourcingForce","twitter_site":"@SourcingForce","twitter_misc":{"Written by":"Olivier Audino","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/#article","isPartOf":{"@id":"https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/"},"author":{"name":"Olivier Audino","@id":"https:\/\/sourcing-force.com\/#\/schema\/person\/481e000db1e02e01e9dc0913e2430fbd"},"headline":"Example of Spend Data Classification","datePublished":"2019-05-20T20:58:23+00:00","dateModified":"2022-09-03T17:24:30+00:00","mainEntityOfPage":{"@id":"https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/"},"wordCount":460,"commentCount":0,"image":{"@id":"https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/#primaryimage"},"thumbnailUrl":"https:\/\/sourcing-force.com\/wp-content\/uploads\/2019\/05\/Screen-Shot-2019-05-05-at-9.33.48-PM.png","articleSection":["Spend analytics","Strategic Sourcing"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/","url":"https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/","name":"Example of Spend Data Classification - Sourcing Force","isPartOf":{"@id":"https:\/\/sourcing-force.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/#primaryimage"},"image":{"@id":"https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/#primaryimage"},"thumbnailUrl":"https:\/\/sourcing-force.com\/wp-content\/uploads\/2019\/05\/Screen-Shot-2019-05-05-at-9.33.48-PM.png","datePublished":"2019-05-20T20:58:23+00:00","dateModified":"2022-09-03T17:24:30+00:00","author":{"@id":"https:\/\/sourcing-force.com\/#\/schema\/person\/481e000db1e02e01e9dc0913e2430fbd"},"breadcrumb":{"@id":"https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/#primaryimage","url":"https:\/\/sourcing-force.com\/wp-content\/uploads\/2019\/05\/Screen-Shot-2019-05-05-at-9.33.48-PM.png","contentUrl":"https:\/\/sourcing-force.com\/wp-content\/uploads\/2019\/05\/Screen-Shot-2019-05-05-at-9.33.48-PM.png","width":1882,"height":658},{"@type":"BreadcrumbList","@id":"https:\/\/sourcing-force.com\/en\/example-of-spend-data-classification\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/sourcing-force.com\/en\/"},{"@type":"ListItem","position":2,"name":"Example of Spend Data Classification"}]},{"@type":"WebSite","@id":"https:\/\/sourcing-force.com\/#website","url":"https:\/\/sourcing-force.com\/","name":"Sourcing Force","description":"Digitalisez l\u2019int\u00e9gralit\u00e9 de votre processus Achat !","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sourcing-force.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sourcing-force.com\/#\/schema\/person\/481e000db1e02e01e9dc0913e2430fbd","name":"Olivier Audino","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sourcing-force.com\/wp-content\/uploads\/2022\/01\/olivier-audino-150x150.png","url":"https:\/\/sourcing-force.com\/wp-content\/uploads\/2022\/01\/olivier-audino-150x150.png","contentUrl":"https:\/\/sourcing-force.com\/wp-content\/uploads\/2022\/01\/olivier-audino-150x150.png","caption":"Olivier Audino"},"url":"https:\/\/sourcing-force.com\/en\/author\/olivieraudino\/"}]}},"_links":{"self":[{"href":"https:\/\/sourcing-force.com\/en\/wp-json\/wp\/v2\/posts\/8884","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sourcing-force.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sourcing-force.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sourcing-force.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sourcing-force.com\/en\/wp-json\/wp\/v2\/comments?post=8884"}],"version-history":[{"count":0,"href":"https:\/\/sourcing-force.com\/en\/wp-json\/wp\/v2\/posts\/8884\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sourcing-force.com\/en\/wp-json\/wp\/v2\/media\/8749"}],"wp:attachment":[{"href":"https:\/\/sourcing-force.com\/en\/wp-json\/wp\/v2\/media?parent=8884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sourcing-force.com\/en\/wp-json\/wp\/v2\/categories?post=8884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sourcing-force.com\/en\/wp-json\/wp\/v2\/tags?post=8884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}