Outbound invoice staging table

The outbound invoice [sn_spend_intg_outbound_invoice] staging table stores important data about invoices so that an ERP integrator can export this data to a third-party ERP system.

Outbound invoice staging table

The following table lists both the mandatory and optional fields for the outbound invoice [sn_spend_intg_outbound_invoice] staging table.

Table 1. Outbound invoice staging table

Field	Data type	Description
Amount invoiced	String	Total amount for the invoice.
Business owner	String	An individual or group who owns the invoice.
Currency	String	Currency format associated with the invoice.
Default tax code	Reference	Default tax code levied on the total invoice amount.
Default tax code - deprecated	String	Indicates whether the Tax code on the invoice is deprecated or not.
Default tax jurisdiction code	String	Tax code jurisdiction to which the tax must be paid.
Discounts	String	Discounts applied on the invoice amount.
ERP number	String	Unique number generated within the ERP system for the purchase order.
ERP posting date	String	Date on which the invoice is posted in the ERP system.
ERP source	String	Target ERP where the invoice will be posted.
Final tax	String	Final tax on the invoice amount.
Integration status	String	Current status of the outbound invoice integration process.
Invoice date	String	Date on which this invoice is created.
Invoice status	String	Current status of this invoice.
Invoice type	String	Type of invoice for processing. Note: Accounts Payable Operations supports invoices of type PO invoice and Non-PO invoice.
Legal entity	Reference	Internal legal entity which incurs the cost of this invoice.
Number	String	An auto-generated number that uniquely identifies the invoice.
Original invoice	String	A unique invoice number created by the Supplier.
Other charges	String	Other charges applied on the invoice amount.
Payment terms	Reference	How and when to make payment for the products and services.
Processing message	String	A message that describes the current processing status.
Purchase order	Reference	Purchase order associated with this invoice.
Remit to city	String	City to which the payment is made.
Remit to country	Reference	Country to which the payment is made.
Remit to state/province	String	State or province to which the payment is made.
Remit to street	String	Street address to which the payment is made.
Remit to zip/postal code	String	ZIP or postal code to which the payment is made.
Ship from city	String	City from which the items on the purchase order is shipped.
Ship from country	Reference	Country from which the items on the purchase order is shipped.
Ship from state/province	String	State or province from which the items on the purchase order is shipped.
Ship from street	String	Street address from which the items on the purchase order is shipped.
Ship from zip/postal code	String	ZIP or postal code from which the items on the purchase order is shipped.
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 or province to which the items on the purchase order should be shipped.
Ship to street	String	Street address to which the items on the purchase order should be shipped.
Ship to zip/postal code	String	ZIP or postal code to which the items on the purchase order should be shipped.
Shipping amount	String	Shipping charges incurred for the invoice.
Subtotal	String	Total amount of money to be paid to the supplier excluding tax and shipping charges.
Supplier	Reference	Supplier who delivers the product or service.
Supplier invoice number	String	Invoice number of the supplier invoice.
Tax amount	String	Tax rate applied on the invoice amount.