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
Receipt table summary
W-9 Form table summary
Line items table summary

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

Was this helpful?

How can we improve it?