Fields types
There are two categories of field types—standard and business. Standard field types are based on standard data types like integer, alphanumeric, etc. Some of the examples of regular field types in TruCap+ are Numeric, Alpha Numeric, and Date. Business field types represent data that point to some meaningful information with a set format. Some of the examples of business field types in TruCap+ are Pan Number, Website, and Email. Unlike standard types, where you have to define the format for extracting the data (for example, number of digits), for business field types, pre-defined regular expressions are already available.
Field types
Aadhaar Number | Address (INDIA) | Address (USA) | Alpha Numeric
Alphabetic | Amount | Datatable | Date | Description
Email | GST (table) | GST | HST Number | Invoice Date | Invoice
Net Amount | Numeric | PINCode (INDIA) | Pan Number
Payment Due Date | Payment Term | Quantity | Source ID
Source Name | Tax Amount | Unit | Website | Word To Number
Note:
In the above field types, the underlined ones are the standard field types while the rest are business field types.
Refer the table below for field type details.
|
FIELD TYPE |
DESCRIPTION |
CATEGORY |
|---|---|---|
|
Aadhaar Number |
Represents a value that is in valid Aadhaar number format. |
Business |
|
Address (India) |
Represents a value that is in valid Indian address format. For example, Mumbai - 400064 Maharashtra |
Business |
|
Address (International) |
Represents a value in an international address format (to be identified by ML services) other than a valid Indian and USA address format. |
Business |
|
Address (USA) |
Represents a value that is in valid USA address format. For example, Clarksburg Park Road Ap #826-649 Sit Rd. Azusa New York 35531 (793) 151-7830 |
Business |
|
Alpha Numeric |
Represents an alphanumeric value, i.e., consists of letters and digits. For example, 12ADE45 |
Standard |
|
Alpha Numeric (Special) |
Represents an alphanumeric value including special characters. For example, 12ADE#45 |
Standard |
|
Alphabetic |
Represents a value comprising of English letters. For example, DEFGKL |
Standard |
|
Barcode |
Represents a barcode. |
Business |
|
Choice |
Represents a choice. |
Business |
|
Currency Value |
Represents a value that is in valid currency format. |
Business |
|
Datatable |
Represents a reference to a datatable, where the datatable is stored in memory for quick access For example, @VendorName |
Business |
|
47943 |
Represents a value that is in valid date format. For example, 31/12/2023, 12/31/2023, 31-December-2023, 31 décembre 2023, etc. (Support for French calendar months is available.) |
Standard |
|
Description |
Represents the description data that is present in the tables. |
Business |
|
|
Represents a value that is in valid email format. For example, TruCap@Datamatics.com |
Business |
|
GST Number |
Represents a value that is in valid GST format. For example, 27AABCU9603R1ZN |
Business |
|
GST of Recipient - QR Code |
Represents a value that is in valid GST format for Indian invoices. |
Business |
|
GST of Supplier - QR Code |
Represents a value that is in valid GST format for Indian invoices. |
Business |
|
GST (Table) |
Represents a value that is in valid GST format for Indian invoices. |
Business |
|
HSN Code - QR Code |
Represents a value that is in valid HSN format for Indian invoices. |
Business |
|
HST Number |
Represents a value that is in valid Harmonized Sales Tax (HST) code format. For example, HST@13% |
Business |
|
IFSC |
Represents a value that is in valid IFSC format. |
Business |
|
Image |
Represents an image. |
Business |
|
Invoice Amount |
Represents a value that is in amount format. For example, 25000.00 |
Business |
|
47943 |
Represents a value that is in valid date format. For example, 31/12/2023, 12/31/2023, 31-December-2023, 31 décembre 2023, etc. (Support for French calendar months is available.) |
Business |
|
Invoice Date - QR Code |
Represents a value that is in valid date format for Indian invoices. |
Business |
|
Invoice Number - QR Code |
Represents a value that is in valid number format for Indian invoices. |
Business |
|
Invoice Reference Number |
Represents a value that is in valid number format for Indian invoices. |
Business |
|
Invoice Value - QR Code |
Represents a value that is in valid value format for Indian invoices. |
Business |
|
Json |
Represents a JSON file from which value is to be extracted. |
Business |
|
Key |
Represents the key. |
Business |
|
MRZ Data |
Represent the MRZ data present in a passport in valid format. |
Business |
|
Net Amount |
Represents a value that is in valid amount format. |
Business |
|
No of Line Items - QR Code |
Represents the number of line items present in a table in valid format for Indian invoices. |
Business |
|
Numeric |
Represents a value that is in integer format. For example, 12345 |
Standard |
|
Numeric (Special) |
Represents a value that is in integer format including special characters. Characters allowed are: 0 1 2 3 4 5 6 7 8 9 ! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~ For example, [+91-9800011122] |
Business |
|
Pan Number |
Represents a value that is in valid PAN format. For example, ABCDE1537H |
Business |
|
47943 |
Represents a value that is in valid date format. For example, 31/12/2023, 12/31/2023, 31-December-2023, 31 décembre 2023, etc. (Support for French calendar months is available.) |
Business |
|
Payment Term |
Represents a value that is in valid duration format. |
Business |
|
Person Photo |
Represents the photo of an individual. |
Business |
|
PINCode (India) |
Represents a value that is in valid PIN code format. Here, PIN code refers to Indian Pincode format. For example, 400064 |
Business |
|
Quantity |
Represents a value that is in valid quantity format. |
Business |
|
Remarks |
Represents a field used to add remarks on MI/QC screen. |
Business |
|
Search Zone |
Represents the search zone to extract data. |
Business |
|
Signature |
Represents the signature of an individual. |
Business |
|
Source Name |
Represents a source name. |
Business |
|
Suggestion |
Represents the suggestion to provide when extracting data using OpenAI. |
Business |
|
Table Line Number |
Represents the table line number from which the data is to be extracted. |
Business |
|
Table Line Number Numeric |
Represents the table line number in numeric format from which the data is to be extracted. |
Business |
|
Tax Amount |
Represents a value that is in valid amount format. |
Business |
|
Unit |
Represents a value that is in valid unit format. |
Business |
|
Value |
Represents a value. |
Business |
|
Virtual Table |
Represents a virtual table. |
Business |
|
Website |
Represents a value that is in valid website format. For example, http://www.datamatics.com |
Business |
|
Word to Number |
Represents a value that is in valid duration format. |
Business |
Note
A business field type is associated with default extraction functions and regular expressions.