Field Name |
Description |
Field Type |
Required/Unique |
Possible Values |
Type |
Describes the type of row. Possible values are Payment, Payment Details or
Payment Detail Allocation |
|
No/No |
|
Payment ID |
The ID of the payment |
integer |
No/No |
|
Payment Batch ID |
The ID of the Payment Batch the payment belongs to |
integer |
No/No |
|
Payment Batch Type |
The type of Payment Batch the payment belongs to. It can be an Invoice Payment
Batch or Expense Payment Batch |
|
No/No |
|
Payment Batch Status |
The status of the Payment Batch the payment belongs to |
|
No/No |
|
Payment Status |
The status of the payment |
string(255) |
No/No |
|
Created At |
The date the payment was created on |
datetime |
No/No |
|
Updated At |
The date the payment was last updated on |
datetime |
No/No |
|
Exported |
A flag to check if the payment was already exported |
|
No/No |
|
Pay From Account Name |
The company payment account name used for the payment |
|
No/No |
|
Pay From Account Kind |
The company payment account type used for the payment |
|
No/No |
|
Pay From Account Currency |
The company payment account currency used for the payment |
|
No/No |
|
Pay From Account Total |
The total amount to be used for the payment from the company payment
account |
|
No/No |
|
Pay To Account Name |
The payee's payment account name |
|
No/No |
|
Pay To Account Kind |
The payee's payment account type |
|
No/No |
|
Pay to Account Currency |
The payee's payment account currency |
|
No/No |
|
Pay To Account Total |
The total amount the payee is to be paid in its account currency |
|
No/No |
|
Reporting Pay To Currency |
The reported currency for the payee |
|
No/No |
|
Reporting Pay To Total |
The reported total amount to be paid based on payee's currency |
decimal |
No/No |
|
Exchange Rate |
The exchange rate used for the payment |
decimal(30,9) |
No/No |
|
Payee ID |
A unique number identifing the payee. This is unique within each source
transaction type |
integer |
No/No |
|
Payee Name |
The name of the payee |
string(255) |
No/No |
|
Payee Display Name |
A commonly used name for the payee |
|
No/No |
|
Payee Login |
The login ID used for employees. This is blank for suppliers |
|
No/No |
|
Payee Email |
The email used by the payee to receive payment notifications |
|
No/No |
|
Payee Number |
A unique number identifing the payee. This is unique within each source
transaction type |
|
No/No |
|
Pay To Total |
The total amount to be paid |
decimal |
No/No |
|
Error Text |
Error text on completed with error payments |
text |
No/No |
|
Digital Check Number |
The digital check number when there is one attached to the payment |
|
No/No |
|
Estimated Pay From Total |
The estimated pay from total based on exchange rates loaded in the
system |
decimal |
No/No |
|
Source Name |
Source Name provided for payments loaded from external source |
string(255) |
No/No |
|
Source Reference |
Source Reference provided for payments in an external source |
string(255) |
No/No |
|
Payment Type |
The Payment Type |
|
No/No |
|
Description |
Description provided describing the payment |
string(255) |
No/No |
|
Payment Identifier |
Payment Identifier provided used to reference the payment |
string(255) |
No/No |
|
Legal Entity name |
Legal Entity name |
|
No/No |
|
Transfer Type |
Transfer Type is used by the Bank or Payment Partner and defines how a payment
will need to be processed (ACH, WIRE, Standard, Next Day, Same Day) |
string(255) |
No/No |
|
Requested Execution Date |
When sending payment instructions to a bank, the Requested Execution Date can
be used to request the bank to initiate a payment on a specific date |
datetime |
No/No |
|
Total Processed by Payee |
Amount of total charges processed by payee |
|
No/No |
|