Invoice payment detail import inbound table
Field descriptions and data types for the Invoice Payment Detail Import Inbound [sn_spend_intg_imp_invoice_payment_detail] staging table used to store imported invoice payment detail data from ERP systems before transfer 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.
| 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:USThis 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. |
Parent Topic:Inbound staging tables for Accounts Payable Operations
Related topics
Invoice import inbound staging table
Invoice line import inbound staging table
Organization tax details inbound staging table