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

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Finance and Supply Chain

ft:clusterId :

    - stpop

bundleId :

    - stpop

workflow :

    - Employee


---

# Inbound Invoice staging table

# Inbound Invoice staging table {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](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/sySbvm6AV2ErxTJ0DbR_AA "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/rn7Ajh_qFwhRRs~~LMqAxA "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/r2pzhCfLKxS1EZQaYlMObg "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/WsNDHhGDMcDjfMcT5vZr6w "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/r3f57F5cDunK3OFuyD5Isg "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/_W~jZX99UIajd0C1gfW2fA "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. You can use this table to lookup all the cost center details.")
* [Department Stage inbound staging table](https://servicenow-prod.fluidtopics.net/VmNQ6G1dRncgyiLZFMGg0g "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/eRcJUwd9kCNNw9GUBalIvg "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/zPxpalWIo1UiMuerILCBaA "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/j6~T~lUp81K0Z3hVjwSb3A "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/9XoedvQEkrlFEgJnDXhF9A "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/eFPhaRummAMFFYEmwtUnwQ "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/nAsziEy0ALyIyTMP_iuZJQ "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/dnKFW18I~5qUaKkooJCF0Q "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/fP~HEk~1~KqxwQMZ5GHZLA "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/vuRpDZDwdZ629GsI0uWhXw "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/_6yP35znLoXNMnW7SPpKDw "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/0BaPlsrcfHoOC4XGQlVBoQ "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/YhUPIstj0WPfg11nTjNCsA "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/YmQNEc61Bl_Pgac9Y1NnUw "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/_nP4mGJsZWO2U8VWckzK~Q "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/QHWV10EnxZVQeSMJA7Fpzg "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/L4Cer3sid4HG5rL8NGxaGA "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/cApy2xx3SLzpds2ppziaOw "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/Z0EpqDTYVZV15r_Y3AJqAQ "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/pUXpMnRL6~XzM0N3seGe7g "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/TmPZ7nJLHcMQWWCsf9nQ2Q "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/WncFsx6GUYcp_ain6Ha5Cg "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/Kg9FwVWRqUe2IznNIYrFqw "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/nhhSzhHFhEGqNKRQIOSkVw "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/nK4bkSF_Y5ySUdlTmiUQuA "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/_kr5kXjLTe7aqMHo3uypkA "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/sPD_Xa5iAovMD8tf0EGVDg "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/zh~zfFbx4hsPl8qOJsPjYw "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/7OJ1Fu2Qk3P6EFFwaL2S_w "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.")
* [Unit of Measure inbound staging table](https://servicenow-prod.fluidtopics.net/TcnjWHdSl2z8iFHfZB4x7w "The Third Party Unit [sn_fcms_intg_imp_uom] staging table temporarily stores important data on third party units before this data is sent to the primary table.")