Invoice staging table
The invoice staging [sn_ap_ic_invoice_stage] table temporarily stores the header-level invoice data from Document Intelligence before it is transferred to the invoice record.
Invoice inbound staging table (sn_ap_ic_invoice_stage)
The following table lists the fields for the invoice inbound [sn_ap_ic_invoice_stage] staging table.
| Field | Data type | Description |
|---|---|---|
| Number | string | Auto-generated identifier for the staging record. Read only. |
| Supplier invoice number | string | Invoice number as printed on the source document. |
| Supplier | string | Supplier name extracted from the document. |
| Supplier tax id | string | Supplier VAT or tax identification number. |
| Invoice date | string | Invoice date as extracted from the document (raw string). |
| Invoice date (parsed) | glide_date | Parsed date field populated by Document Intelligence from the raw invoice date string. |
| Purchase order | string | PO number referenced on the invoice. |
| Subtotal | string | Invoice subtotal before tax and other charges. |
| Amount invoiced (Transaction currency) | string | Total invoiced amount in the transaction currency. |
| Tax rate | string | Tax rate as extracted from the document. |
| Tax amount | string | Tax amount as extracted from the document. |
| Shipping amount | string | Shipping charges extracted from the document. |
| Other charges | string | Miscellaneous charges extracted from the document. |
| Invoice currency | string | Currency code of the invoice. |
| Original invoice number | string | For credit memos, the number of the invoice being credited. |
| Bill to company name | string | Company name from the bill-to address on the invoice. |
| Bill to street | string | Street address from the bill-to address on the invoice. |
| Bill to city | string | City from the bill-to address on the invoice. |
| Bill to state/province | string | State or province from the bill-to address on the invoice. |
| Bill to country | string | Country from the bill-to address on the invoice. |
| Bill to zip/postal code | string | ZIP or postal code from the bill-to address on the invoice. |
| Remit to street | string | Street address for supplier payment remittance. |
| Remit to city | string | City for supplier payment remittance. |
| Remit to state/province | string | State or province for supplier payment remittance. |
| Remit to country | string | Country for supplier payment remittance. |
| Remit to zip/postal code | string | ZIP or postal code for supplier payment remittance. |
| Ship to street | string | Street address from the ship-to address on the invoice. |
| Ship to city | string | City from the ship-to address on the invoice. |
| Ship to state/province | string | State or province from the ship-to address on the invoice. |
| Ship to country | string | Country from the ship-to address on the invoice. |
| Ship to zip/postal code | string | ZIP or postal code from the ship-to address on the invoice. |
| Supplier bank name | string | Supplier bank name extracted for payment routing. |
| ACH routing number | string | ACH routing number extracted for payment routing. |
| Wire routing number | string | Wire transfer routing number extracted for payment routing. |
| Account number | string | Supplier bank account number extracted for payment routing. |
| Swift code | string | SWIFT code for international wire transfers. |
| Status | choice | Processing status of the staging record. |
| Invoice email | reference | Reference to the inbound email record that delivered this invoice. |
| Sender email address | string | Email address from which the invoice was sent. |
| Recipient email address | string | Email address that will receive the invoice. |
| Related invoice | reference | Reference to the invoice record created from this staging record. |