---
sourceDocument: Xanadu Finance and Supply Chain
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/source-to-pay-operations

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu Finance and Supply Chain

ft:clusterId :

    - stpop

bundleId :

    - stpop

workflow :

    - Creator


---

# Inbound Invoice staging table

# Inbound Invoice staging table {#ariaid-title1}

* Release version: Xanadu
* 
* Updated September 9, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read

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

## Inbound Invoice staging table {#spo-inbound-invoice-table__section_f1j_drc_rcc}

The following table lists fields for Inbound Invoice \[sn_shop_invoice\] staging table.{#spo-inbound-invoice-table__table_nl4_txw_rbc__entry__3}

| 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. |
[Table 1. Inbound Invoice staging table]

{#spo-inbound-invoice-table__table_nl4_txw_rbc}
**Related reference**   

* [CMDB Model Category Stage inbound staging table](https://servicenow-prod.fluidtopics.net/kJ087JmTVH9AUH_ww1HgAw "The CMDB Model Category Stage inbound [sn_fcms_intg_cmdb_model_category_stage] staging table temporarily stores important data about product model categories before this data is sent to the primary table.")
* [CMDB Service Model Stage inbound staging table](https://servicenow-prod.fluidtopics.net/l3AnqXeSFFktK4KW3fw8FQ "The CMDB Service Model Stage inbound [sn_fcms_intg_cmdb_service_model_stage] staging table temporarily stores important data about service models before this data is sent to the primary table.")
* [CMN Location Stage inbound staging table](https://servicenow-prod.fluidtopics.net/DH3kHRj4GLj0_T0sB5x2mQ "The CMN Location Stage inbound [sn_fcms_intg_cmn_location_stage] staging table temporarily stores important data about locations before this data is sent to the primary table.")
* [Catalog Import staging table](https://servicenow-prod.fluidtopics.net/UcWKeuMlQe4o8u43Qbv3ug "The Catalog Import [sn_spend_intg_imp_catalog] staging table temporarily stores important data about catalog imports before this data is sent to the primary table.")
* [Catalog Error staging table](https://servicenow-prod.fluidtopics.net/5P82t8~7iG0z1_Fc0LOHLw "The Catalog Error [sn_spend_intg_catalog_error] staging table temporarily stores important data about any catalog errors before this data is sent to the primary table.")
* [Cost Center Stage inbound staging table](https://servicenow-prod.fluidtopics.net/GTpYSULfIraqlU8E3mQ~Iw "The Cost Center Stage inbound [sn_fcms_intg_imp_cost_center] staging table temporarily stores important data about cost centers before this data is sent to the primary table.")
* [Department Stage inbound staging table](https://servicenow-prod.fluidtopics.net/aTBIctwqecsKo5IACcZibA "The Department Stage inbound [sn_fcms_intg_department_stage] staging table temporarily stores important data about departments before this data is sent to the primary table.")
* [ERP Plant Address Mapping Stage inbound staging table](https://servicenow-prod.fluidtopics.net/v3mrLIFfhhwvJS2ZwdU9KQ "The ERP Plant Address Mapping Stage inbound [sn_fcms_intg_erp_plant_address_mapping_stage] staging table temporarily stores important data about ERP plant address before this data is sent to the primary table.")
* [FX Currency Stage inbound staging table](https://servicenow-prod.fluidtopics.net/EfKcSXXVZW9gC2i~qeEmVw "The FX Currency Stage inbound [sn_fcms_intg_fx_currency_stage] staging table temporarily stores important data about FX currencies before this data is sent to the primary table.")
* [FX Rate Stage inbound staging table](https://servicenow-prod.fluidtopics.net/hbePlEaZoQOgKf2zekB9xQ "The FX Rate Stage inbound [sn_fcms_intg_fx_rate_stage] staging table temporarily stores important data about FX rates before this data is sent to the primary table.")
* [Fixed asset details stage inbound table](https://servicenow-prod.fluidtopics.net/KleWEtyt2VBPibZVcJl2lg "The Fixed asset details inbound [sn_fcms_intg_imp_fixed_asset_details] staging table temporarily stores important data about imported invoice line before this data is sent to the primary table.")
* [GL Account Stage inbound staging table](https://servicenow-prod.fluidtopics.net/F47W65Fb3IaGRXvsAFhiRA "The GL Account Stage inbound [sn_fcms_intg_gl_account_stage] staging table temporarily stores important data about General Ledger (GL) accounts before this data is sent to the primary table.")
* [Import Availability Updates inbound staging table](https://servicenow-prod.fluidtopics.net/esdzHX4a8yWQdo_KkYW4Hg "The Import Availability Updates inbound [sn_spend_intg_imp_availability] staging table temporarily stores important data about cost allocations before this data is sent to the primary table.")
* [Availability Error staging table](https://servicenow-prod.fluidtopics.net/ZtVKFYpmhwMgDCgbn1wpYA "The Availability Error [sn_spend_intg_availability_error] staging table stores important data about availability error so that an ERP integrator can export this data to a third-party ERP system.")
* [Inbound Cost Allocation staging table](https://servicenow-prod.fluidtopics.net/aGhMgQaAkQNtgBFSRIEZ_w "The Inbound Cost Allocation [sn_spend_intg_imp_cost_allocation] staging table temporarily stores important data about cost allocations before this data is sent to the primary table.")
* [Inbound Purchase Order staging table](https://servicenow-prod.fluidtopics.net/k1svrx7k31wavRKfaosV0Q "The Inbound Purchase Order [sn_fcms_intg_imp_order] staging table temporarily stores important data about purchase orders before this data is sent to the primary table.")
* [Inbound Purchase Order Line staging table](https://servicenow-prod.fluidtopics.net/NO1cMcJ8VuuLt6sMPgn0vQ "The Inbound Purchase Order Line [sn_fcms_intg_imp_order_line] staging table temporarily stores important data about purchase order lines before this data is sent to the primary table.")
* [Inbound Receipt staging table](https://servicenow-prod.fluidtopics.net/zvUEofw2N~tKQg~w9dPifA "The Inbound Receipt [sn_fcms_intg_imp_receipt] staging table temporarily stores important data about receipts before this data is sent to the primary table.")
* [Legal Entity Stage inbound staging table](https://servicenow-prod.fluidtopics.net/rAKBe3wMwTthhZvC8QP7lw "The Legal entity stage inbound [sn_fcms_intg_legal_entity_stage] staging table temporarily stores important data about legal entities before this data is sent to the primary table.")
* [Office Location Stage inbound staging table](https://servicenow-prod.fluidtopics.net/fGIiLbBAcL1ru4SCLUd52A "The Office Location Stage inbound [sn_fcms_intg_office_location_stage] staging table temporarily stores important data about office locations before this data is sent to the primary table.")
* [Order Acknowledgement staging table](https://servicenow-prod.fluidtopics.net/c~36lV5c1GaOgocxp0pWOw "The Order Acknowledgment [sn_spend_intg_imp_purchase_order_ack] staging table temporarily stores important data about order acknowledgements before this data is sent to the primary table.")
* [Order Acknowledgement Error staging table](https://servicenow-prod.fluidtopics.net/e35q_~kZQvokvgyFQTxltA "The Order Acknowledgement Error [sn_spend_intg_order_ack_error] staging table temporarily stores important data about any errors in the order price imports before this data is sent to the primary table.")
* [Payment Terms Stage inbound staging table](https://servicenow-prod.fluidtopics.net/Aw~F1mpaXyf~urSQGX5x6w "The Payment Terms Stage inbound [sn_fcms_intg_payment_term_stage] staging table temporarily stores important data about payment terms before this data is sent to the primary table.")
* [Price Import staging table](https://servicenow-prod.fluidtopics.net/prNk96KoMfGXvOJ5vRvfxA "The Price Import [sn_spend_intg_imp_price] staging table temporarily stores important data about price imports before this data is sent to the primary table.")
* [Price Error outbound staging table](https://servicenow-prod.fluidtopics.net/8~soAl3bUDNXwyB~89CQlw "The Price Error [sn_spend_intg_price_error] staging table stores important data about pricing error so that an ERP integrator can export this data to a third-party ERP system.")
* [Product Model Stage inbound staging table](https://servicenow-prod.fluidtopics.net/oSwH5IA7ZL0dv1Izf2zMNw "The Product Model Stage inbound [sn_fcms_intg_cmdb_model_stage] staging table temporarily stores important data about product models before this data is sent to the primary table.")
* [Purchase Entity Stage inbound staging table](https://servicenow-prod.fluidtopics.net/~RNHOM_4FcWXkbxP3Y8dgQ "The Purchase Entity Stage inbound [sn_fcms_intg_imp_purchase_entity] staging table temporarily stores important data about purchase entities before this data is sent to the primary table.")
* [Purchase Line Stage inbound staging table](https://servicenow-prod.fluidtopics.net/nJs5cGGN9x9Xhvjec1MciQ "The Purchase Entity Stage inbound [sn_spend_intg_purchase_line] staging table temporarily stores important data about purchase entities before this data is sent to the primary table.")
* [Purchase Requisition staging table](https://servicenow-prod.fluidtopics.net/DNeq3F7rWzB7h7rnh3X6oQ "The Purchase requisition [sn_spend_intg_purchase_requisition] staging table temporarily stores important data about purchase requests before this data is sent to the primary table.")
* [Spend Shipment Import inbound staging table](https://servicenow-prod.fluidtopics.net/ZhQtSHZFBEXSyenLrzzOiA "The Spend Shipment Import inbound [sn_spend_intg_imp_shipment] staging table temporarily stores important data about spend shipment imports before this data is sent to the primary table.")
* [Shipment Error staging table](https://servicenow-prod.fluidtopics.net/xKktIQer9hl8LfoMIm5ynQ "The Shipment Error [sn_spend_intg_shipment_error] staging table temporarily stores important data on any shipment errors before this data is sent to the primary table.")
* [Supplier Product Stage inbound staging table](https://servicenow-prod.fluidtopics.net/A_P_9O1apOG~t6J~HcvFkQ "The Supplier Product Stage inbound [sn_spend_intg_supplier_product_stage] staging table temporarily stores important data about supplier products before this data is sent to the primary table.")
* [Third Party Sourcing Registration staging table](https://servicenow-prod.fluidtopics.net/MG79_oNLCIMr_h4aJv2Lpg "The Third Party Sourcing Registration [sn_spend_intg_sourcing_vendor] table temporarily stores important data on third party sourcing registrations before this data is sent to the primary table.")
* [Third Party Unit Mapping staging table](https://servicenow-prod.fluidtopics.net/_eadAkOGNBvUpzuata63NQ "The Third Party Unit Mapping [sn_spend_intg_third_party_uom_map] staging table temporarily stores important data on third party mapping before this data is sent to the primary table.")
* [Third Party Unit staging table](https://servicenow-prod.fluidtopics.net/jy_ExMVLz5bYsEI1mPBVMw "The Third Party Unit [sn_spend_intg_third_party_uom] staging table temporarily stores important data on third party units before this data is sent to the primary table.")