Invoice line import inbound staging table

  • Release version: Washingtondc
  • Updated June 10, 2024
  • 1 minute 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
    External invoice source String Name of the third party application associated with the invoice. Derive logic from external invoice number.
    Line description String Description of the invoice line.
    Line quantity Decimal number The number of items that have been invoiced
    Line unit price Decimal number Unit price of the line item in the invoice.
    Subtotal Decimal number Example (12345.65) Total amount of money to be paid to the supplier excluding tax and shipping charges.
    ERP source String

    The available ERP source.
    External invoice source String Name of the third party application associated with the invoice.