Invoice payment detail import inbound table

  • 릴리스 버전: Australia
  • 업데이트 날짜 2026년 03월 12일
  • 소요 시간: 3분

    • 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 fields for the Invoice payment detail import inbound [sn_spend_intg_imp_invoice_payment_detail] staging table.
    표 1. Invoice payment detail import inbound staging table
    Field Data type Description
    Currency String Currency used in the invoice.

    This is a mandatory field.
    ERP invoice number String Unique identifier for invoices in the ERP system.

    This is a mandatory field.
    ERP Source String Specifies the original source of ERP.

    This is a mandatory field.
    ERP supplier code String ERP supplier code from the external supplier.

    This is a mandatory field.
    Payment amount Decimal number Total amount to be paid.

    This is a mandatory field.
    Payment date String (yyy-mm-dd) Date by which payment is to be completed.

    This is a mandatory field.
    Payment method Choice Example: bank_transfer/ cash_payment/ cheque /credit_card /debit_card /wire_transfer Mode through which the payment is done.

    This is a mandatory field.
    Payment reference ID Alphanumeric A unique ID to track the payment details.

    This is a mandatory field.
    Remit to city String City to which the payment is made.

    This is a mandatory field.
    Remit to country String Country to which the payment is made in ISO 3166 format. Example:US

    This is a mandatory field.
    Remit to state/province String State or province to which the payment is made.

    This is a mandatory field.
    Remit to street String Street address to which the payment is made.

    This is a mandatory field.
    Remit to ZIP/postal code String Zip or postal code address to which the payment is made.

    This is a mandatory field.
    Scheduled payment date String (yyyy-mm-dd) Date at which the payment will be made.

    This is a mandatory field.
    Third party import ID String Unique identifier for imported data set.