{"id":47861,"date":"2020-12-21T12:11:45","date_gmt":"2020-12-21T19:11:45","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/?post_type=docs&#038;p=47861"},"modified":"2021-10-18T17:27:42","modified_gmt":"2021-10-19T00:27:42","slug":"table-validation-rules","status":"publish","type":"docs","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/table-validation-rules\/","title":{"rendered":"Table Validation Rules"},"content":{"rendered":"<p>This document provides an overview of table validation rules in Ephesoft Transact. This information is intended for Transact administrators.<\/p>\n<p>For information about validation rules for index fields, refer to <a href=\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/index-fields-4050\/validation-rules\/\">Validation Rules<\/a>.<\/p>\n<h2><a id=\"post-47861-_1fob9te\"><\/a>Prerequisites<\/h2>\n<p>To create and configure table validation rules, the following prerequisites must be in place:<\/p>\n<ul>\n<li>You will need a batch class with a document type configured. For detailed steps, refer to <a href=\"https:\/\/ephesoft.com\/docs\/features-and-functions\/administrator\/batch-class-management\/add-new-document\/\">Add New Document Type<\/a>.<\/li>\n<li>The TABLE_EXTRACTION plugin must be added to the Extraction module and turned on.<\/li>\n<li>You will need a table with table columns configured. <span style=\"font-weight: 400\">For help, refer to <\/span><a href=\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/table-extraction-ui-rule-configurator-improvements\/\"><span style=\"font-weight: 400\">Table Extraction<\/span><\/a><span style=\"font-weight: 400\">.<\/span><\/li>\n<\/ul>\n<h2><a id=\"post-47861-_3znysh7\"><\/a>Overview<\/h2>\n<p>Table validation rules use regular expressions to determine if extracted table data is correct, or as a way to force operator review under certain conditions.<\/p>\n<p>When table data is extracted from a document, Transact will run the extracted value against the rules for that column. If the extracted value satisfies the conditions of the table validation rule, the value will be automatically validated. If it doesn&#8217;t satisfy the table validation rule, the value will be flagged for review.<\/p>\n<p>These rules are set at the document type level.<\/p>\n<h2><a id=\"post-47861-_m68p7icsmpom\"><\/a>Configuring Table Validation Rules<\/h2>\n<p>This section describes how to create and configure table validation rules.<\/p>\n<ol>\n<li>From the <strong>Batch Class Management <\/strong>screen, select and open your batch class.<\/li>\n<li>Go to <strong>Document Types <\/strong>&gt;<strong> <em>&lt;your document type&gt;<\/em> <\/strong>&gt;<strong> Tables <\/strong>&gt;<strong><em>&lt;your table&gt;<\/em><\/strong><em> &gt;<\/em><strong> Table Validation Rules<\/strong>.<\/li>\n<\/ol>\n<figure id=\"attachment_47862\" aria-describedby=\"caption-attachment-47862\" style=\"width: 1920px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"wp-image-47862\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-59.png\" alt=\"\" width=\"1920\" height=\"937\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-59.png 1920w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-59-300x146.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-59-1024x500.png 1024w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-59-768x375.png 768w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-59-1536x750.png 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><figcaption id=\"caption-attachment-47862\" class=\"wp-caption-text\"><em>Figure 1. Table Validation Rules<\/em><\/figcaption><\/figure>\n<ol start=\"3\">\n<li>Click <strong>Add<\/strong>.<\/li>\n<\/ol>\n<figure id=\"attachment_47863\" aria-describedby=\"caption-attachment-47863\" style=\"width: 1473px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"wp-image-47863\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-60.png\" alt=\"\" width=\"1473\" height=\"153\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-60.png 1473w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-60-300x31.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-60-1024x106.png 1024w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-60-768x80.png 768w\" sizes=\"(max-width: 1473px) 100vw, 1473px\" \/><figcaption id=\"caption-attachment-47863\" class=\"wp-caption-text\"><em>Figure 2. Add New Rule<\/em><\/figcaption><\/figure>\n<p>A new rule will be added as a row on the grid. The grid is broken up into three columns:<\/p>\n<table>\n<tbody>\n<tr bgcolor=\"#1f3864\">\n<td><span style=\"color: #ffffff\"><strong>Column<\/strong><\/span><\/td>\n<td><span style=\"color: #ffffff\"><strong>Description<\/strong><\/span><\/td>\n<\/tr>\n<tr bgcolor=\"#d9e2f3\">\n<td>Rule<\/td>\n<td>This field displays the rule as you are creating it. This field is view-only and cannot be edited.<\/td>\n<\/tr>\n<tr>\n<td>Description<\/td>\n<td>This mandatory field is where you describe the validation rule, limited to 255 characters.<\/td>\n<\/tr>\n<tr bgcolor=\"#d9e2f3\">\n<td>Set Rule<\/td>\n<td>This field contains an interactive editor.<\/p>\n<ul>\n<li>The first drop-down contains all columns mapped in Table Columns, plus the option to enter a value.<\/li>\n<li>The middle field is enabled when the first drop-down is set to <strong>Enter Value<\/strong>. This field becomes a text field you can use to validate a column against a specific dataset.<\/li>\n<li>The second drop-down contains a list of logical operators that can be used to configure the validation rule.\n<ul>\n<li>+ (add)<\/li>\n<li>* (multiply)<\/li>\n<li>&#8211; (subtract)<\/li>\n<li>\/ (division, returns the quotient)<\/li>\n<li>% (modulo operator, returns the remainder after division)<\/li>\n<li>&lt;= (less than or equal to)<\/li>\n<li>&gt;= (greater than or equal to)<\/li>\n<li>!= (does not equal)<\/li>\n<li>== (equals)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ol start=\"4\">\n<li>Create the rule in the <strong>Set Rule <\/strong>field.\n<ol type=\"a\">\n<li>In the left drop-down, select a column. If <strong>Enter Value <\/strong>is selected, enter a value in the middle text field.<\/li>\n<li>In the right drop-down, select a logical operator.<\/li>\n<li>Repeat to refine the validation rule.<\/li>\n<\/ol>\n<\/li>\n<li>Enter an intuitive description in the <strong>Description <\/strong>field.<\/li>\n<li>When you&#8217;re satisfied, click <strong>Apply<\/strong>.<\/li>\n<\/ol>\n<h2><a id=\"post-47861-_z2z37ftdj095\"><\/a>Configuring the Validation Rule Operator<\/h2>\n<p>When creating multiple table validation rules, you can specify whether all rules must be satisfied for a field to be validated, or only one rule. To do so, change the <strong>Validation Rule Operator <\/strong>on the <strong>Tables <\/strong>page.<\/p>\n<ol>\n<li>With your batch class open, go to <strong>Document Types <\/strong>&gt; <strong><em>&lt;your document type&gt; <\/em><\/strong>&gt; <strong>Tables<\/strong>.<\/li>\n<li>Select the <strong>Validation Rule Operator <\/strong>for your table.\n<ol type=\"a\">\n<li>AND \u2014 All rules must be satisfied (default).<\/li>\n<li>OR \u2014 Only one rule must be satisfied.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<figure id=\"attachment_47864\" aria-describedby=\"caption-attachment-47864\" style=\"width: 752px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"wp-image-47864\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-61.png\" alt=\"\" width=\"752\" height=\"183\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-61.png 752w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-61-300x73.png 300w\" sizes=\"(max-width: 752px) 100vw, 752px\" \/><figcaption id=\"caption-attachment-47864\" class=\"wp-caption-text\"><em>Figure 3. Validation Rule Operator<\/em><\/figcaption><\/figure>\n<ol start=\"3\">\n<li>Click <strong>Apply<\/strong>.<\/li>\n<\/ol>\n<h2><a id=\"post-47861-_xajnxpbk23jv\"><\/a>Best Practices<\/h2>\n<ol>\n<li>Create and test table validation rules in a non-production environment, to prevent disrupting the workflow.<\/li>\n<li>After creating table validation rules, do not rename your <strong>Table Columns<\/strong>. This will require reconfiguring the rules.<\/li>\n<li>Be careful not to create too many validation rules. Always ask: Is the rule a \u201cneed to have\u201d or \u201cnice to have\u201d? When in doubt, it&#8217;s best not to overcomplicate the validation process<\/li>\n<li>Remember to notify operators when you create or modify table validation rules.<\/li>\n<\/ol>\n<h2><a id=\"post-47861-_r1wv02abrfih\"><\/a>Example Table Validation Rules<\/h2>\n<p>This section shows how to create table validation rules using a sample mileage log, below.<\/p>\n<p><img decoding=\"async\" width=\"725\" height=\"138\" class=\"wp-image-47865\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-62.png\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-62.png 725w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-62-300x57.png 300w\" sizes=\"(max-width: 725px) 100vw, 725px\" \/><\/p>\n<h3><a id=\"post-47861-_59yexbmfbbix\"><\/a>Use Case<\/h3>\n<p>In this scenario, we are creating table validation rules for a mileage log. Our goal is to create two validation rules:<\/p>\n<ol>\n<li>A rule to confirm that the <strong>Total Mileage <\/strong>is equal to the difference between the odometer start and end.<\/li>\n<li>A rule to flag any entries over 50 miles for approval.<\/li>\n<\/ol>\n<p>The first rule is to ensure that the drivers have entered their mileage correctly, while the second is to cover a specific business need that requires a manager to approve entries over 50 miles.<\/p>\n<h3><a id=\"post-47861-_50euh1e319e\"><\/a>Pre-configurations<\/h3>\n<p>In this scenario, we have already configured the following:<\/p>\n<ul>\n<li>Created a document type: <strong>VehicleMileageReport<\/strong><\/li>\n<li>Created a table: <strong>Mileage Table<\/strong><\/li>\n<li>Mapped columns in <strong>Table Columns<\/strong><\/li>\n<li>Created an extraction rule in <strong>Table Extraction Rules<\/strong><\/li>\n<\/ul>\n<h3><a id=\"post-47861-_anabfei94wjg\"><\/a>Creating the Rules<\/h3>\n<p>First, we need to create the table validation rules.<\/p>\n<ol>\n<li>Open the batch class and go to <strong>Document Types <\/strong>&gt;<strong> VehicleMileageReport <\/strong>&gt;<strong> Tables <\/strong>&gt;<strong> Mileage Table <\/strong>&gt; <strong>Table Validation Rules.<\/strong><\/li>\n<\/ol>\n<figure id=\"attachment_47866\" aria-describedby=\"caption-attachment-47866\" style=\"width: 372px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"wp-image-47866\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-63.png\" alt=\"\" width=\"372\" height=\"306\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-63.png 372w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-63-300x247.png 300w\" sizes=\"(max-width: 372px) 100vw, 372px\" \/><figcaption id=\"caption-attachment-47866\" class=\"wp-caption-text\"><em>Figure 4. Table Validation Rules<\/em><\/figcaption><\/figure>\n<ol start=\"2\">\n<li>Click <strong>Add<\/strong>.<\/li>\n<\/ol>\n<figure id=\"attachment_47867\" aria-describedby=\"caption-attachment-47867\" style=\"width: 1290px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"wp-image-47867\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-64.png\" alt=\"\" width=\"1290\" height=\"138\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-64.png 1290w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-64-300x32.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-64-1024x110.png 1024w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-64-768x82.png 768w\" sizes=\"(max-width: 1290px) 100vw, 1290px\" \/><figcaption id=\"caption-attachment-47867\" class=\"wp-caption-text\"><em>Figure 5. Add New Rule<\/em><\/figcaption><\/figure>\n<ol start=\"3\">\n<li>For the <strong>Description<\/strong>, we used &#8220;Total Mileage equals difference between odometer start and stop&#8221;.<\/li>\n<li>Create the rule under <strong>Set Rule<\/strong>.\n<ol type=\"a\">\n<li>In the left drop-down, select <strong>Odometer Stop<\/strong>.<\/li>\n<li>In the right drop-down, select <strong>&#8211; <\/strong>(minus).<\/li>\n<li>In the left drop-down, select <strong>Odometer Start<\/strong>.<\/li>\n<li>In the right drop-down, select <strong>== <\/strong>(equals).<\/li>\n<li>In the left drop-down, select <strong>Mileage Total<\/strong>.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<figure id=\"attachment_47868\" aria-describedby=\"caption-attachment-47868\" style=\"width: 1291px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"wp-image-47868\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-6.gif\" alt=\"\" width=\"1291\" height=\"348\" \/><figcaption id=\"caption-attachment-47868\" class=\"wp-caption-text\"><em>Figure 6. Set First Rule<\/em><\/figcaption><\/figure>\n<ol start=\"5\">\n<li>Repeat this process for the second validation rule. For the <strong>Description<\/strong>, we used &#8220;Total mileage must be less than 50&#8221;.<\/li>\n<li>Create the second rule under <strong>Set Rule<\/strong>.\n<ol type=\"a\">\n<li>In the left drop-down, select <strong>Mileage Total<\/strong>.<\/li>\n<li>In the right drop-down, select<strong> &lt;= <\/strong>(less than or equal to).<\/li>\n<li>In the left drop-down, select <strong>Enter Value<\/strong>.<\/li>\n<li>In the middle field, enter &#8220;50&#8221;.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<figure id=\"attachment_47869\" aria-describedby=\"caption-attachment-47869\" style=\"width: 1291px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"wp-image-47869\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-7.gif\" alt=\"\" width=\"1291\" height=\"423\" \/><figcaption id=\"caption-attachment-47869\" class=\"wp-caption-text\"><em>Figure 7. Set Second Rule<\/em><\/figcaption><\/figure>\n<ol start=\"7\">\n<li>Click <strong>Apply<\/strong>.<\/li>\n<\/ol>\n<h3><a id=\"post-47861-_msnzubb5o0z8\"><\/a>Configuring the Validation Operator<\/h3>\n<p>Finally, we need to determine the <strong>Validation Rule Operator<\/strong>. In this scenario, we want both of these table validation rules to be satisfied with our tables. Therefore, we want to use the AND operator.<\/p>\n<p>Because the AND operator is the default, no changes are required.<\/p>\n<h3><a id=\"post-47861-_1nqcu8xdnfx3\"><\/a>Example Validation Flags<\/h3>\n<p>Refer to the following excerpt from our table:<\/p>\n<p><img decoding=\"async\" width=\"725\" height=\"138\" class=\"wp-image-47870\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-65.png\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-65.png 725w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-65-300x57.png 300w\" sizes=\"(max-width: 725px) 100vw, 725px\" \/><\/p>\n<p>With our table validation rules, Transact will flag two fields for validation.<\/p>\n<p><img decoding=\"async\" width=\"833\" height=\"137\" class=\"wp-image-47871\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-66.png\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-66.png 833w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-66-300x49.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-66-768x126.png 768w\" sizes=\"(max-width: 833px) 100vw, 833px\" \/><\/p>\n<ol>\n<li>Row two fails our first validation rule. Tim J. probably entered his <strong>Odometer Start <\/strong>or <strong>Odometer End <\/strong>incorrectly.<\/li>\n<li>Row three fails our second validation rule. John H. logged over 50 miles and needs manager approval.<\/li>\n<\/ol>\n<h2><a id=\"post-47861-_orjk4hc5grh5\"><\/a>Conclusion<\/h2>\n<p>This completes an overview of how to configure table validation rules in Ephesoft Transact.<\/p>\n","protected":false},"featured_media":0,"parent":31882,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v19.0 (Yoast SEO v22.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Table Validation Rules | Ephesoft Docs<\/title>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Table Validation Rules\" \/>\n<meta property=\"og:description\" content=\"This document provides an overview of table validation rules in Ephesoft Transact. This information is intended for Transact administrators. For [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/table-validation-rules\/\" \/>\n<meta property=\"og:site_name\" content=\"Ephesoft Docs\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-19T00:27:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-59.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/table-validation-rules\/\",\"url\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/table-validation-rules\/\",\"name\":\"Table Validation Rules | Ephesoft Docs\",\"isPartOf\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\"},\"datePublished\":\"2020-12-21T19:11:45+00:00\",\"dateModified\":\"2021-10-19T00:27:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/table-validation-rules\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/table-validation-rules\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/table-validation-rules\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ephesoft.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transact\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Features and Functions\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Administrator Role and Features\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Batch Class Management\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"Table Extraction\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/\"},{\"@type\":\"ListItem\",\"position\":7,\"name\":\"Table Validation Rules\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\",\"url\":\"https:\/\/ephesoft.com\/docs\/\",\"name\":\"Ephesoft Docs\",\"description\":\"Intelligent Document Processing Made Easy\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ephesoft.com\/docs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Table Validation Rules | Ephesoft Docs","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"Table Validation Rules","og_description":"This document provides an overview of table validation rules in Ephesoft Transact. This information is intended for Transact administrators. For [&hellip;]","og_url":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/table-validation-rules\/","og_site_name":"Ephesoft Docs","article_modified_time":"2021-10-19T00:27:42+00:00","og_image":[{"url":"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/12\/word-image-59.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/table-validation-rules\/","url":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/table-validation-rules\/","name":"Table Validation Rules | Ephesoft Docs","isPartOf":{"@id":"https:\/\/ephesoft.com\/docs\/#website"},"datePublished":"2020-12-21T19:11:45+00:00","dateModified":"2021-10-19T00:27:42+00:00","breadcrumb":{"@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/table-validation-rules\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/table-validation-rules\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/table-validation-rules\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ephesoft.com\/docs\/"},{"@type":"ListItem","position":2,"name":"Transact","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/"},{"@type":"ListItem","position":3,"name":"Features and Functions","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/"},{"@type":"ListItem","position":4,"name":"Administrator Role and Features","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/"},{"@type":"ListItem","position":5,"name":"Batch Class Management","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/"},{"@type":"ListItem","position":6,"name":"Table Extraction","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/"},{"@type":"ListItem","position":7,"name":"Table Validation Rules"}]},{"@type":"WebSite","@id":"https:\/\/ephesoft.com\/docs\/#website","url":"https:\/\/ephesoft.com\/docs\/","name":"Ephesoft Docs","description":"Intelligent Document Processing Made Easy","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ephesoft.com\/docs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"comment_count":0,"_links":{"self":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/47861"}],"collection":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/comments?post=47861"}],"version-history":[{"count":1,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/47861\/revisions"}],"predecessor-version":[{"id":49468,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/47861\/revisions\/49468"}],"up":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31882"}],"next":[{"title":"Configuring Currency Settings for Tables","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/support-of-currencies-in-table-validation-rules\/","href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31734"}],"prev":[{"title":"Configuring Table Extraction","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/configuring-table-extraction\/","href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/49464"}],"wp:attachment":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/media?parent=47861"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/doc_tag?post=47861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}