Invoice import inbound staging table

  • Release version: Washingtondc
  • Updated June 10, 2024
  • 1 minute 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 the mandatory fields for the invoice import inbound [sn_spend_intg_imp_invoice] staging table.
    Table 1. Invoice import inbound staging table
    Field Data type Description
    Invoice Type Choice Examples: invoice/non_ po_invoice, debit _memo, credit_memo Details about the invoice.
    Supplier String Name of the ERP supplier code.
    Invoice date String (yyyy-mm-dd) The date on which the invoice is created.
    Subtotal Decimal number. Example 12345.65 Total amount of money to be paid to the supplier excluding tax and shipping charges.
    Other charges Decimal number Additional charges incurred on the invoice.
    External invoice number String

    Invoice number originated from a third party application.
    ERP source String

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