---
sourceDocument: Xanadu Finance and Supply Chain
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/source-to-pay-operations

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu Finance and Supply Chain

ft:clusterId :

    - stpop

bundleId :

    - stpop

workflow :

    - Creator


---

# Invoice payment detail import inbound table

# Invoice payment detail import inbound table {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 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 {#invoice-payment-detail-staging-table__section_jls_tvt_rbc}

The following table lists the fields for the Invoice payment detail import inbound \[sn_spend_intg_imp_invoice_payment_detail\] staging table.{#invoice-payment-detail-staging-table__table_nwp_byw_rbc__entry__3}

| 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. |
[Table 1. Invoice payment detail import inbound staging table]

{#invoice-payment-detail-staging-table__table_nwp_byw_rbc}
**Related reference**   

* [Invoice import inbound staging table](https://servicenow-prod.fluidtopics.net/3N_ce549ho1Lfyd8w8oApw "The invoice import inbound [sn_spend_intg_imp_invoice] staging table temporarily stores important data about the imported invoice before this data is sent to the [sn_shop_invoice] primary table.")
* [Import error staging table](https://servicenow-prod.fluidtopics.net/xT14boXv9qyqQeICl3f21w "The Import error [sn_spend_intg_import_error] staging table temporarily stores important data on errors before this data is sent to the primary table.")
* [Invoice line import inbound staging table](https://servicenow-prod.fluidtopics.net/eO5abUGAei4Z1TJwruv9uw "The Invoice line import inbound [sn_spend_intg_imp_invoice_line] staging table temporarily stores important data about imported invoice line before this data is sent to the [sn_shop_invoice_line] primary table.")
* [Organization tax details inbound staging table](https://servicenow-prod.fluidtopics.net/6XcPK44fxtFtV0ROiksLAQ "The Organization tax details inbound [sn_fcms_intg_org_tax_detail_inbound] staging table temporarily stores important data about an organization's tax information before this data is sent to the Organization Tax Details [sn_fin_org_tax_detail] primary table.")
* [Invoice tax line staging table](https://servicenow-prod.fluidtopics.net/JDkkqrGTpn~X6zILI~u6Ow "The invoice tax line inbound [sn_spend_intg_imp_invoice_tax_line] staging table temporarily stores important data about the invoice tax line before this data is sent to the [sn_shop_invoice_tax_line] primary table.")