Treasury Cash Management - Reconciliation Result Cash Flows
Export of these records is included as a Standard CSV Export.
Note:
Because Integration Transaction Formats are not available for Treasury objects, you cannot configure the columns for this export.
Reconciliation Result Cash Flows
Exports all records created within the last 7 days.
|
Column Name |
Description |
Req'd |
Unique |
Type |
Allowable Values |
|---|---|---|---|---|---|
|
Reconciliation ID |
|
||||
|
IntegerID (Entity) |
Id |
integer |
|||
|
Abbreviation (Entity) |
Abbreviation of the Participant |
string |
|||
|
CoreID (Entity) |
ID of the legal entity / financial counterparty in Coupa Core |
||||
|
Internal Participant (Entity) |
Internal Participant |
boolean |
|||
|
ID (Account) |
ID of the account |
integer |
|||
|
Name (Account) |
Name of the account |
string(50) |
|||
|
GL Account Number (Account) |
Currency of the account |
string(9) |
|||
|
Entity (Account) |
|||||
|
Bank (Account) |
|||||
|
Currency (Account) |
string |
||||
|
Account Category (Account) |
|||||
|
Classic Cash Pool (Account) |
|||||
|
CoreID (Account) |
ID of the company financial account in Coupa Core |
||||
|
Type |
|||||
|
Amount |
|||||
|
Value Date |
|||||
|
Booking Date |
|||||
|
Payment Reference |
|||||
|
Category |
|||||
|
UniqueID (Project) |
GuID given by the system |
|
|||
|
IntegerID (Project) |
Integer ID given by the system |
integer |
|||
|
Abbreviation (Project) |
Abbreviation of the project |
TRUE |
string |
||
|
UniqueID (Portfolio) |
GuID given by the system |
|
|||
|
IntegerID (Portfolio) |
Integer ID given by the system |
integer |
|||
|
Abbreviation (Portfolio) |
Abbreviation of the portfolio |
TRUE |
TRUE |
string |
|
|
Source |
|||||
|
Counterparty |
|||||
|
Transaction Code |
|||||
|
Cash Flow GL number |
|||||
|
Comment |
|||||
|
Entered Date (Audit details) |
|||||
|
Entered By (Audit details) |
|||||
|
Last Modified Date (Audit details) |
|||||
|
Last Modified By (Audit details) |
|||||
|
Reconciliation Rule |
Recon Rule Name |