This page provides information about the fields Semantik extracts from invoices.
What is JSON?
Semantik exports the data it extracts from your invoices in JSON, or JavaScript Object Notation. JSON is based on key-value pairs and ordered lists, formatted in a way that's easier for humans to read and faster for computers to process.
Here's an example of data encoded in JSON:
{
"Fields": {
"CustomerId": "1234",
"InvoiceNumber": "929641258",
"PONumber": "8658921",
"InvoiceDate": "2020-04-15",
"DueDate": "2020-05-15",
"OrderDate": "2020-03-29",
"Terms": "Net 30 days",
},
}
In this example, you can easily see the relationship between each entry. For example, the customer ID is "1234".
Semantik JSON Fields
The following table describes all data Semantik exports when an invoice is processed. Some fields are pulled from the invoice data or vendor master list, while others are generated by Semantik.
JSON Field | Description | Source | Example |
AmountDue | This is the amount owed to the vendor after surcharges and deductions. | Invoice | 3693.80 |
DocumentId | The unique ID assigned to the Invoice by Semantik. | Semantik | 00000000-0000-0000-0000-000000000000 |
DueDate | The date the payment is due. | Invoice | 2020-04-15 |
Entity | The business unit that received products or services from a vendor. | Invoice | Kordtronics, Inc. |
FileName | The filename of the invoice sent to Semantik. | Invoice | Kord-Invoice9291873611.pdf |
InvoiceDate | The date the invoice was created. | Invoice | 2020-03-29 |
InvoiceNumber | Invoice number generated by the vendor. | Invoice | 9291873611 |
OrderDate | The date the order was placed. | Invoice | 2020-03-29 |
PdfUrl | Link to Semantik processed invoice in PDF format. | Semantik | |
PONumber | Purchase order number. | Invoice | 8762943181 |
PostingDate | Date when funds are removed from an account to pay a bill. | Invoice | 2021-07-23 |
ShipDate | The date the order was shipped. | Invoice | 2020-04-10 |
ShipFreight | Charges for shipping, freight, and handling. | Invoice | 123.45 |
SubTotal | The total amount of invoice items. This number does not include surcharges or deductions. | Invoice | 3358 |
TableURL | Link to extracted invoice line items table. | Semantik | |
TaxAmount | Amount of tax billed for the invoice. | Invoice | 335.80 |
TaxId | Vendor's federal tax ID. | Vendor list | 012-34-56789 |
TaxRate | Tax percentage applied to invoice. | Invoice | 10 |
TenantId | Universally unique identifier (UUID) assigned by Semantik for the tenant. | Semantik | 555e4d7e-0115-4ec4-adac-892367844222 |
Terms | When a payment is expected for the invoice amount. | Invoice | Net 30 days |
TotalAmount | Total invoice amount with surcharges, not including any deductions. | Invoice | 3693.80 |
Vendor:Country | Vendor's country. | Vendor list | US |
Vendor:Custom1 | Vendor custom 1 value. | Vendor list | Custom1 |
Vendor:Custom2 | Vendor custom 2 value. | Vendor list | Custom2 |
Vendor:Custom3 | Vendor custom 3 value. | Vendor list | Custom3 |
Vendor:Custom4 | Vendor custom 4 value. | Vendor list | Custom4 |
Vendor:Custom5 | Vendor custom 5 value. | Vendor list | Custom5 |
Vendor:CustomerId | Vendor-assigned customer ID. | Vendor list | 1 |
Vendor:IBAN | Vendor's International Bank Account Number. | Vendor list | aa5d5efa-fcaf-4d2b-a118-a093f184a876 |
Vendor:VendorId | ID assigned to this vendor. | Invoice or Vendor list | 95bba4ab-1897-4e9d-aff1-f42ae7e5cb86 |
Vendor:Locality | Vendor's city or locality within a region. | Vendor list | Salt Lake City |
Vendor:Matched | True if vendor matched from the vendor list. | Vendor list | true |
Vendor:Name | Name of the vendor company. | Vendor list | Kord Industries |
Vendor:POBox | Vendor's post office box number. | Vendor list | 123 |
Vendor:Region | Vendor's state or region of locality. | Vendor list | UT |
Vendor:Status | Current vendor status, such as active or inactive. | Vendor list | active |
Vendor:SWIFT | Vendor's SWIFT code used to represent a specific bank branch. | Vendor list | 1b0f74e1-ce62-4d1d-9153-f07e88bc0a29 |
Vendor:StreetAddress | Vendor's street address. | Vendor list | 2775 S. 900 W. |
Vendor:Telephone | Vendor's telephone number. | Vendor list | 513-101-4074 |