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. |
Parent Topic:Inbound staging tables for Accounts Payable Operations
Related topics
Invoice import inbound staging table
Invoice payment detail import inbound table
Organization tax details inbound staging table