All Collections
Settings
Exporting Data
Understanding Semantik Data
Understanding Semantik Data
Paul King avatar
Written by Paul King
Updated over a week ago

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

Did this answer your question?