Inbound staging tables Sourcing Procurement › Inbound staging tables › Source-to-Pay integration framework › Integration with third-party applications › Integrations › Source-to-Pay Operations › Finance and Supply Chain

Release: Australia · Updated: 2026-03-12 · Official documentation · View source

Invoice inbound staging table

The Invoice inbound [sn_shop_invoice] staging table temporarily stores important data about shopping invoices before this data is sent to the primary table.

Invoice inboumd staging table

The following table lists fields for Invoice inbound [sn_shop_invoice] staging table.

Field	Data type	Description
External invoice number	String	Invoice number originated from a third party application. This is a mandatory field.
Inbound source	String	Individual or group who owns the invoice.
Currency	String	Currency format associated with this invoice.
Discounts	String	Discounts applied on the invoice.
ERP number	String	Unique number generated within the ERP system for the purchase order.
ERP source	String	The available ERP.This is a mandatory field.
External invoice number	String	Invoice number originated from a third party application. This is a mandatory field.
External invoice source	String	Name of the third party application associated with the invoice.This is a mandatory field.
Final tax	String	Total amount of tax to be paid.
Inbound source	String	External source system from where the invoice is received.
Invoice date	String \(yyyy-mm-dd\)	Date on which the invoice is created.This is a mandatory field.
Invoice date	String	Date on which the invoice was created.
Invoice line count	String	Total number of invoice lines in an invoice.
Invoice type	String	Type of the invoice for processing.
Legal entity	String	Name of the legal entity of the supplier.
Original invoice	String	Unique invoice number created by the Supplier.
Other charges	String	Other additional charges associated with the invoice.This is a mandatory field.
Payment terms	String	The agreed upon time and conditions under which a payment to a supplier is made.
Purchase order	String	The purchase order against which the invoice is created.
Remit to city	String	City to which the payment is made.
Remit to country	String	Country to which the payment is made.
Remit to state/province	String	State to which the payment is made.
Remit to street	String	Street to which the payment is made.
Remit to zip/postal code	String	Zip code to which the payment is made.
Ship from city	String	City from which the items on the purchase order are shipped.
Ship from country	String	Country from which the items on the purchase order are shipped.
Ship from state/province	String	State from which the items on the purchase order are shipped.
Ship from street	String	Street from which the items on the purchase order are shipped.
Ship from zip/postal code	String	Zip code from which the items on the purchase order are shipped.
Shipping amount	String	Shipping charges incurred for the invoice.
Ship to city	String	City to which the items on the purchase order should be shipped.
Ship to country	String	Country to which the items on the purchase order should be shipped.
Ship to state/province	String	State to which the items on the purchase order should be shipped.
Ship to street	String	Street to which the items on the purchase order should be shipped.
Ship to zip/postal code	String	Zip code to which the items on the purchase order is shipped.
Status	String	Current status of the inbound invoice.
Subtotal	String	Total amount of money to be paid to the supplier excluding tax and shipping charges.This is a mandatory field.
Supplier	String	Name of the supplier from whom the good or service is procured.This is a mandatory field.
Supplier invoice number	String	Unique invoice number created by the Supplier.
Supplier tax id	String	Tax ID associated to the third party reseller.
Supplier tax rate	String	Supplier tax rate.
Target ERP	String	Target ERP where the invoice is posted.
Tax amount	String	Tax amount levied on the total invoice amount.
Third party import ID	String	A unique identifier for external data imports.