---
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


---

# Invoice line import inbound staging table

# Invoice line import inbound staging table {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read

The Invoice line import inbound \[sn_spend_intg_imp_invoice_line\] staging table temporarily stores important data about imported invoice line before this data is sent to the \[sn_shop_invoice_line\] primary table.

## Invoice line import inbound staging table {#inbound-invoice-line-staging-table__id_dp2_cxt_rbc}

The following table lists the mandatory fields for the Invoice line import inbound \[sn_spend_intg_imp_invoice_line\] staging table. {#inbound-invoice-line-staging-table__table_imh_yxw_rbc__entry__3}

| Field | Data type | Description |
|-|-|-|
| Cost center | String | Cost center for which the invoice is generated. |
| Currency | String | Currency format associated with the invoice. |
| ERP line number | String | ERP line number. |
| ERP source | String | Available ERP source. This is a mandatory field. |
| External invoice number | String | Invoice number from external invoice. |
| External invoice source | String | Name of the third party application associated with the invoice. Derive logic from external invoice number. This is a mandatory field. |
| Final tax | String | Final tax. |
| GL account | String | Account used to generate the invoice. |
| Inbound source | String | External invoice source. |
| Line amount invoiced | String | The total cost which is being billed for this good or service. |
| Line description | String | Description of the invoice line. This is a mandatory field. |
| Line quantity | Decimal number | Number of items that have been invoiced. This is a mandatory field. |
| Line unit price | Decimal number | Unit price of the line item in the invoice. This is a mandatory field. |
| Purchase order line | String | Purchase line related to the invoiced amount. |
| 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 | Address 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 should be shipped. |
| Status | String | Current status of this invoice line. |
| Subtotal | Decimal number Example (12345.65) | Total amount of money to be paid to the supplier excluding tax and shipping charges. This is a mandatory field. |
| Supplier part number | String | Supplier part number of the supplier product. |
| Supplier tax rate | String | Supplier tax rate. |
| Target ERP | String | ERP number of inbound source. |
| Tax amount | String | Tax for the invoice amount. |
| Tax code | String | Tax code of the invoice. |
| Third party import ID | String | Unique identifier for external data imports. |
| Unit | String | The unit or rate in which this product is sold by the supplier. |
[Table 1. Invoice line import inbound staging table]

{#inbound-invoice-line-staging-table__table_imh_yxw_rbc}
**Related reference**   

* [Invoice import inbound staging table](https://servicenow-prod.fluidtopics.net/S1tW7ZiPIWrwBnDB4xQI4A "The invoice import inbound [sn_spend_intg_imp_invoice] staging table temporarily stores important data about the imported invoice before this data is sent to the [sn_shop_invoice] primary table.")
* [Import error staging table](https://servicenow-prod.fluidtopics.net/L6CzdVP1d8m_TLfqtkfTZQ "The Import error [sn_spend_intg_import_error] staging table temporarily stores important data on errors before this data is sent to the primary table.")
* [Invoice payment detail import inbound table](https://servicenow-prod.fluidtopics.net/iEc0PWmFtfJ2tPzcv8Cu2Q "The Invoice Payment detail import inbound [sn_spend_intg_imp_invoice_payment_detail] staging table temporarily stores important data about supplier before this data is sent to the [sn_shop_invoice_payment_detail] primary table.")
* [Organization tax details inbound staging table](https://servicenow-prod.fluidtopics.net/52UWbRula6Zr2GKzWv0McA "The Organization tax details inbound [sn_fcms_intg_org_tax_detail_inbound] staging table temporarily stores important data about an organization's tax information before this data is sent to the Organization Tax Details [sn_fin_org_tax_detail] primary table.")
* [Invoice tax line staging table](https://servicenow-prod.fluidtopics.net/mkQOR1B1BTGp1kz0ex3VvQ "The invoice tax line inbound [sn_spend_intg_imp_invoice_tax_line] staging table temporarily stores important data about the invoice tax line before this data is sent to the [sn_shop_invoice_tax_line] primary table.")