Column Name

Description

Required

Unique

Applies to (Type)

Allowable Values and Notes

Payment Source Name

( source-name )

Name of the source system providing the payment. Combination of Payment Source Name and Payment Source Reference must be unique.

Yes

Yes when paired with source-reference

All payment types.

source-name and source-reference together form a uniqueness key to disallow double payments.

Payment Source Reference

( source-reference )

Reference identifier from the ERP or other source system providing the payment details.

Yes

Yes when paired with source-name

All payment types.

Payment Type

The type of payment.

Yes

No

All payment types.

Vendor Payment, Employee Reimbursement, Loan, Intercompany Transfer, Payroll, Tax Payment, Other.

Payment Rail

The intended payment rails of the payment.

Yes

No

All payment types.

Bank Transfer, Digital Check, Virtual Card, Digital Wallet.

Payment Delivery Method

The delivery method based on the specified payment rail.

Yes

No

All payment types.

Allowed values are Transfermate, Direct Bank, Supplier Downloads via CSP, Payer Downloads and Prints, Print and Mail Service, Email, and Pay Pal, depending on the payment type.

Payment Transfer Type

The payment transfer type to be used (DBI only).

No

No

Bank Transfer (TransferMate or DBI).

Allowed values for TransferMate are standard_direct_debit, urgent_direct_debit.

Allowed values for DBI are standard_transfer, wire, standard_bacs, standard_chaps, sepa.

Pay From Source Reference

Source Reference identifier in the Company Financial Account to specify the Pay From Account

Yes

No

All payment types.

Pay To Amount

The amount of the payment.

Yes

No

All payment types.

Pay To Currency Code

The three letter currency code of the payment.

Yes

No

All payment types.

Payment Date

ERP proposed payment date.

Yes

No

All payment types.

This date is for information only as the actual payment date is dependent on approval and release of the payment batch.

Remittance Email Addresses

Allows for a remittance email to be sent to the beneficiary.

No

No

All payment types.

The email address or addresses where the remittance email gets sent.

Remittance Email Message

A note that can be included on the standard remittance notification (optional).

No

No

All payment types.

Free text, up to 512 characters.

Beneficiary Name

The name of the beneficiary.

Yes

Yes

All payment types.

Beneficiary Number

An identifier used in the ERP or payment source. This number is appended to the Beneficiary Name and used to uniquely identify a Beneficiary Payment Account (BPA).

No

No

All payment types.

Beneficiary Type

The type of beneficiary.

Yes

No

All payment types.

Supplier, Employee, Tax Agency.

Pay To Bank Name

The name of the pay to bank.

No

No

Bank Transfer (TransferMate or DBI).

Pay To Bank Street1

The address of the pay to bank.

Yes (see note)

No

Bank Transfer (DBI only).

Might be required for DBI bank transfer payments, depending on country/currency rules.

Pay To Bank Street2

The address of the pay to bank.

Yes (see note)

No

Bank Transfer (DBI only).

Might be required for DBI bank transfer payments, depending on country/currency rules.

Pay To Bank City

The address of the pay to bank.

Yes (see note)

No

Bank Transfer (DBI only).

Might be required for DBI bank transfer payments, depending on country/currency rules.

Pay To Bank Subdivision

The address of the pay to bank.

Yes (see note)

No

Bank Transfer (TransferMate or DBI).

Pay To Bank Postal Code

The address of the pay to bank.

Yes (see note)

No

Bank Transfer (DBI only).

Might be required for DBI bank transfer payments, depending on country/currency rules.

Pay To Bank Country Code

The address of the pay to bank.

Yes (see note)

No

Bank Transfer (TransferMate or DBI).

Only required for Bank Transfer payments.

Pay to Bank Account Number

The pay to bank account number.

Yes (see note)

No

Bank Transfer (TransferMate or DBI).

Might be required for bank transfer payments, depending on country/currency rules.

Pay To Bank IBAN

The pay to bank IBAN.

Yes (see note)

No

Bank Transfer (TransferMate or DBI).

Might be required for bank transfer payments, depending on country/currency rules.

Pay To Bank Transit Code

The pay to bank transit code.

Yes (see note)

No

Bank Transfer (TransferMate or DBI).

Might be required for bank transfer payments, depending on country/currency rules.

Pay To Bank Transit Code Type

The pay to bank transit code type.

Yes (see note)

No

Bank Transfer (TransferMate or DBI).

Might be required for bank transfer payments, depending on country/currency rules.

Pay To Bank SWIFT Code

The pay to bank SWIFT code.

Yes (see note)

No

Bank Transfer (TransferMate or DBI).

Might be required for bank transfer payments, depending on country/currency rules.

Pay To Email Address

The email address of the party responsible for receiving the payment.

Yes (see note)

No

Virtual Card, Check - Supplier Downloads via CSP, Digital Wallet.

Pay To Phone Country Code

The pay to phone number.

Yes (see note)

No

Bank Transfer (TransferMate or DBI).

Might be required for bank transfer payments, depending on country/currency rules.

Pay To Phone Dialing Code

The pay to phone number.

Yes (see note)

No

Bank Transfer (TransferMate or DBI).

Might be required for bank transfer payments, depending on country/currency rules.

Pay To Phone Number

The pay to phone number.

Yes (see note)

No

Bank Transfer (TransferMate or DBI).

Might be required for bank transfer payments, depending on country/currency rules.

Pay To Tax ID

The tax ID of the beneficiary.

Yes (see note)

No

Bank Transfer (TransferMate or DBI).

Might be required for bank transfer payments, depending on country/currency rules.

Pay To Tax Country Code

The 2-letter country code for the beneficiary's tax ID.

Yes (see note)

No

Bank Transfer (TransferMate or DBI).

Might be required for bank transfer payments, depending on country/currency rules.

Must be the standard 2-letter country code. For example, US for United States of America or FR for France.

Remit-To Code

The remit-to code.

No

No

All payment types

If specified, will be used to look up an existing remit-to address.

Remit-To Codes can be found in the Remit-To Addresses record: Setup > Suppliers > Remit-To

Remit-To Name

The remit-to name. If specified will be used to lookup an existing remit-to address.

No

No

All payment types

Remit-To Street1

The remit-to address.

Yes

No

All payment types

Remit-To Street2

The remit-to address.

No

No

All payment types

Remit-To City

The remit-to address.

Yes

No

All payment types

Remit-To Subdivision

The remit-to address.

Yes (see note)

No

All payment types

Required if the country has subdivisions.

Remit-To Postal Code

The remit-to address.

Yes

No

All payment types

Remit-To Country Code

The remit-to address.

Yes

No

All payment types

Payment Instruction 1

Extra payment instructions required for payments in certain countries.

Yes (see note)

No

Bank Transfer (DBI only).

Depends on the payment rules for the payment partner and payment type. You can also choose to add optional instructions.

Format: {field name}~{instruction key}~{instruction value}

Example: invoice_number~/RFRDDOCNB/~INV12345

Payment Instruction 2

Extra payment instructions required for payments in certain countries.

Yes (see note)

No

Bank Transfer (DBI only).

Depends on the payment rules for the payment partner and payment type. You can also choose to add optional instructions.

Format: {field name}~{instruction key}~{instruction value}

Example: invoice_number~/RFRDDOCNB/~INV12345

Payment Instruction 3

Extra payment instructions required for payments in certain countries.

Yes (see note)

No

Bank Transfer (DBI only)..

Depends on the payment rules for the payment partner and payment type. You can also choose to add optional instructions.

Format: {field name}~{instruction key}~{instruction value}

Example: invoice_number~/RFRDDOCNB/~INV12345

Payment Instruction 4

Extra payment instructions required for payments in certain countries.

Yes (see note)

No

Bank Transfer (DBI only).

Depends on the payment rules for the payment partner and payment type. You can also choose to add optional instructions.

Format: {field name}~{instruction key}~{instruction value}

Example: invoice_number~/RFRDDOCNB/~INV12345

Payment Instruction 5

Extra payment instructions required for payments in certain countries.

Yes (see note)

No

Bank Transfer (DBI only).

Depends on the payment rules for the payment partner and payment type. You can also choose to add optional instructions.

Format: {field name}~{instruction key}~{instruction value}

Example: invoice_number~/RFRDDOCNB/~INV12345

Payment Instruction 6

Extra payment instructions required for payments in certain countries.

Yes (see note)

No

Bank Transfer (DBI only).

Depends on the payment rules for the payment partner and payment type. You can also choose to add optional instructions.

Format: {field name}~{instruction key}~{instruction value}

Example: invoice_number~/RFRDDOCNB/~INV12345

Payment Instruction 7

Extra payment instructions required for payments in certain countries.

Yes (see note)

No

Bank Transfer (DBI only).

Depends on the payment rules for the payment partner and payment type. You can also choose to add optional instructions.

Format: {field name}~{instruction key}~{instruction value}

Example: invoice_number~/RFRDDOCNB/~INV12345

Payment Instruction 8

Extra payment instructions required for payments in certain countries.

Yes (see note)

No

Bank Transfer (DBI only).

Depends on the payment rules for the payment partner and payment type. You can also choose to add optional instructions.

Format: {field name}~{instruction key}~{instruction value}

Example: invoice_number~/RFRDDOCNB/~INV12345

Payment Instruction 9

Extra payment instructions required for payments in certain countries.

Yes (see note)

No

Bank Transfer (DBI only).

Depends on the payment rules for the payment partner and payment type. You can also choose to add optional instructions.

Format: {field name}~{instruction key}~{instruction value}

Example: invoice_number~/RFRDDOCNB/~INV12345

Payment Instruction 10

Extra payment instructions required for payments in certain countries.

Yes (see note)

No

Bank Transfer (DBI only).

Depends on the payment rules for the payment partner and payment type. You can also choose to add optional instructions.

Format: {field name}~{instruction key}~{instruction value}

Example: invoice_number~/RFRDDOCNB/~INV12345

Custom Field 1

Custom field value.

No

No

All payment types

Custom Field 2

Custom field value.

No

No

All payment types

Custom Field 3

Custom field value.

No

No

All payment types

Custom Field 4

Custom field value.

No

No

All payment types

Custom Field 5

Custom field value.

No

No

All payment types

Custom Field 6

Custom field value.

No

No

All payment types

Custom Field 7

Custom field value.

No

No

All payment types

Custom Field 8

Custom field value.

No

No

All payment types

Custom Field 9

Custom field value.

No

No

All payment types

Custom Field 10

Custom field value.

No

No

All payment types