Invoice payment detail import inbound table

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

    • The Invoice Payment detail import inbound [sn_spend_intg_imp_invoice_payment_detail] staging table temporarily stores important data about supplier before this data is sent to the [sn_shop_invoice_payment_detail] primary table.

    Invoice payment detail import inbound staging table

    The following table lists the mandatory fields for the Invoice payment detail import inbound [sn_spend_intg_imp_invoice_payment_detail] staging table.
    Table 1. Invoice payment detail import inbound staging table
    Field Data type Description
    Payment amount Decimal number Payment details about the invoice.
    ERP invoice number String The ERP invoice number of the supplier invoice.
    Payment date String (yyy-mm-dd) The date on which the invoice payment was completed.
    Payment method Choice Example: bank_transfer/ cash_payment/ cheque /credit_card /debit_card /wire_transfer Mode of payment.
    Payment reference ID Alpha numeric A unique ID to track the payment details.
    Remit to city String The city to which the payment is made.
    Remit to country String The country to which the payment is made in ISO 3166 format. Example:US
    Remit to state/province String The state or province to which the payment is made.
    Remit to street String The street address to which the payment is made.
    Remit to zip/postal code String The zip or postal code address to which the payment is made.
    Scheduled payment date String (yyyy-mm-dd) The date at which the payment will be made.
    ERP supplier code Combination of ERP supplier code and ERP source Integer ERP code of the supplier in the ERP system.
    ERP Source String The available ERP.
    Currency String Standard of amount exchanged in Currency Code ISO 4217 format (USD, GBP, INR, etc).