Table schemas for document parsing
For document extraction to work properly, the table schemas for document parsing must match the content fields to be extracted. As a result, the tables schemas for document parsing are immutable and can't be altered by app editors.
A user may still edit the UX of the table views to suit their needs but must ensure that required fields are present for the creation of entries into these tables.
The following sections summarize the schemas for the tables that are generated during document processing, based on the document type.
Invoice table summary
The following table summarizes the information extracted for each invoice.
Column
Format
Column
Format
_RowNumber
Number
Supplier Address
Text
_ID
Text
Receiver Name
Text
File
File
Receiver Address
Text
Invoice Number
Text
Ship To Name
Text
Invoice Date
Date
Ship To Address
Text
Total Amount
Decimal
Remit to Name
Text
Net Amount
Decimal
Remit to Address
Text
Total Tax Amount
Decimal
Carrier
Text
Currency Code
Text
Delivery Date
Text
Purchase Order
Text
Supplier Tax Id
Text
Due Date
Date
Customer Tax Id
Text
Payment Terms
Text
Related receipts_line_items
List
Supplier Name
Text
Receipt table summary
The following table summarizes the information extracted for each receipt.
Column
Format
Column
Format
_RowNumber
Number
Supplier Name
Text
_ID (Key)
Text
Supplier Address
Text
File
File
Supplier City
Text
Receipt Date
Date
Purchase Time
Text
Total Amount
Decimal
Related receipts name_line_items
List
Currency Code
Text
W-9 Form table summary
The following table summarizes the information extracted for each W-9 form.
Column
Format
Column
Format
_RowNumber
Number
EIN
Date
_ID (Key)
Text
Federal Tax Classification
Text
File
File
LLC Tax Classification
Text
Name
Text
Exempt FATCA Code
Text
Address
Text
Exempt Payee Code
Text
City
Text
Account Numbers
Text
State
Text
Form Revision Date
Text
Zip
Text
Has Signature
Yes/No
Business Name
Text
Has Signature Date
Yes/No
SSN
Text
Line items table summary
The following table summarizes the information extracted for each line item in an invoice or receipt.
Column
Format
Notes
_RowNumber
Number
_ID
Ref
Amount
Decimal
Description
Text
Product Code
Text
Unit Price
Decimal
Invoice only
Quantity
Number
Invoice only
Unit
Text
Invoice only