Invoice import inbound staging table

  • Release version: Zurich
  • Updated July 31, 2025
  • 3 minutes to read

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

    Invoice Import inbound staging table

    The following table lists fields for the invoice import inbound [sn_spend_intg_imp_invoice] staging table.
    Table 1. Invoice import inbound staging table
    Field Data type Description
    Amount invoiced String Total amount a supplier is expected to be paid.
    Business owner 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.