Outbound invoice staging table

  • Release version: Washingtondc
  • Updated June 10, 2024
  • 1 minute to read

    • The outbound invoice [sn_spend_intg_outbound_invoice] staging table stores important data about invoices so that an ERP integrator can export this data to a third-party ERP system.

    Outbound invoice staging table

    The following table lists the mandatory fields for the outbound invoice [sn_spend_intg_outbound_invoice] staging table.
    Table 1. Outbound invoice staging table
    Field Data type Description
    Supplier invoice number String The combination of supplier invoice number or supplier and ERP source and ERP invoice number.
    Business owner.Email String Name of the owner who owns the application from the business side.
    Amount invoiced (Transaction currency).amount String Charges added to the invoice.
    Amount invoiced (Transaction currency).currency String Charges added to the invoice.
    Discounts.amount String Reduction on the total amount incurred on the invoice.
    Legal Entity.ERP Source.Source String Stores organizational entities defined in the application.
    Type Choice Details about the invoice.
    Supplier Reference Name of the supplier.
    Supplier invoice number String Invoice number mentioned by the supplier.
    Purchase order Reference Binding contract between a buyer and a supplier that authorizes a purchasing transaction.
    Invoice date String (yyy-mm-dd) The date on which the invoice is created.
    Payment terms Reference Conditions applied on the payment.
    Tax amount.amount String Tax rate applied on the invoice amount.
    Shipping. amount String Shipping charges incurred for the invoice.
    Subtotal.amount String Total amount of money to be paid to the supplier excluding tax and shipping charges.
    Other charges.amount String Additional charges incurred on the invoice.
    Number String Unique business identifier associated with the business partner.
    Status Choice Current state of the invoice.
    Invoice date String (yyyy-mm-dd) Date on which the invoice was created.