--- title: Invoice line import inbound staging table description: 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. locale: en-US canonical_url: https://www.servicenow.com/docs/r/australia/source-to-pay-operations/source-to-pay-integration-framework/inbound-invoice-line-staging-table.html release: australia product: Source-to-Pay Integration Framework classification: source-to-pay-integration-framework topic_type: reference last_updated: "2026-03-12" reading_time_minutes: 3 breadcrumb: [Inbound staging tables for Accounts Payable Operations, Inbound staging tables, Source-to-Pay integration framework, Integration with third-party applications, Integrations, Source-to-Pay Operations, Finance and Supply Chain] --- # Invoice line import inbound staging table 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 The following table lists the mandatory fields for the Invoice line import inbound \[sn\_spend\_intg\_imp\_invoice\_line\] staging table.
| 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. |