Invoice line import inbound staging table

  • Release version: Australia
  • Updated March 12, 2026
  • 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

    The following table lists the mandatory fields for the Invoice line import inbound [sn_spend_intg_imp_invoice_line] staging table.
    Table 1. Invoice line import inbound 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.