Outbound invoice line staging table

  • Release version: Washingtondc
  • Updated June 10, 2024
  • 1 minute to read
  • The Outbound invoice line [sn_spend_intg_outbound_invoice_line] staging table stores important invoice line data so that an ERP integrator can export this data to a third-party ERP system.

    Outbound invoice line staging table

    The following table lists the mandatory fields for the Outbound invoice line [sn_spend_intg_outbound_invoice_line] staging table.
    Table 1. Outbound invoice line staging table
    Field Data type Description
    Line description String Description of the invoice line.
    Purchase order line Reference Information of the individual lines under a purchase order line or a sourcing request for the referenced supplier.
    Invoice line quantity String The number of items that have been invoiced.
    Line unit price String Unit price of the line item in the invoice.
    Ledger account Reference Displays General Ledger Account.
    Tax amount.amount String Tax rate applied on the invoice amount.
    Subtotal.amount String Total amount of money to be paid to the supplier excluding tax and shipping charges.
    Cost center Reference Represent business entity to which costs can be allocated
    Invoice.Legal entity. ERP source String Stores organizational entities defined in the application
    ERP line number String Displays the ERP number at the line item level
    Invoice Reference Transaction record used to track purchase between shopper and supplier
    Number String The number in the invoice
    Status Choice Status of an invoice
    Line amount.invoiced amount String The total amount for the invoice line