Treasury Settlements Export
Export of these records is included as a Standard CSV Export.
Settlements Export
Exports all records created within the last 7 days.
|
Column Name |
Description |
Req'd |
Unique |
Type |
Allowable Values |
|---|---|---|---|---|---|
|
UniqueID |
Unique ID |
GuIDentifier |
|
||
|
IntegerID (Entity) |
Id |
int |
|
||
|
Abbreviation (Entity) |
Abbreviation of the Participant |
string |
|
||
|
CoreID (Entity) |
ID of the legal entity / financial counterparty in Coupa Core |
|
|
||
|
ReportingClassification (Entity) |
ReportingClassification of the Participant (Internal or External) |
|
Internal, External |
||
|
IntegerID (Counterparty) |
Id |
int |
|
||
|
Abbreviation (Counterparty) |
Abbreviation of the Participant |
string |
|
||
|
CoreID (Counterparty) |
ID of the legal entity / financial counterparty in Coupa Core |
|
|
||
|
ReportingClassification (Counterparty) |
ReportingClassification of the Participant (Internal or External) |
|
Internal, External |
||
|
Value Date |
Value Date |
date |
|
||
|
Amount |
Amount |
decimal |
|
||
|
Currency |
Currency |
string |
|
||
|
ID (Account) |
ID of the account |
int |
|
||
|
Name (Account) |
Name of the account |
string(50) |
|
||
|
GL Account Number (Account) |
Currency of the account |
string(9) |
|
||
|
EntityIntegerID (Account) |
Entity Integer ID |
|
|
||
|
EntityAbbreviation (Account) |
Entity Abbreviation |
|
|
||
|
EntityCoreID (Account) |
Entity Core ID |
|
|
||
|
EntityReportingClassification (Account) |
Entity Reporting Classification |
|
|
||
|
BankIntegerID (Account) |
Bank Integer ID |
|
|
||
|
BankAbbreviation (Account) |
Bank Abbreviation |
|
|
||
|
Settlement Flow Type |
Settlement Flow Type
|
Enum |
manual, Amortization, Capital, CapitalAndAmortization, CapitalAmortizationInterestAndWHT, Fees, Interest, InterestAndWHT, VAT, WHT, |
||
|
Deal Reference |
Deal Reference |
string |
|
||
|
Payment Method |
Payment Method |
Enum |
EntityDirectDebitsFromCounterparty, EntityIsDirectlyDebited, EntityPaysActively, EntityReceivesFromCounterparty, NoDirectSettlement, SettlementOnICAccounts |
||
|
UniqueID (Standard Settlement Instruction) |
Unique ID |
GuIDentifier |
|
||
|
Name (Standard Settlement Instruction) |
Name
|
string |
|
||
|
UniqueID (Payment Template) |
Unique ID |
GuIDentifier |
|
||
|
IntegerID (Payment Template) |
Integer ID |
integer |
|
||
|
Name (Payment Template) |
Name |
string |
|
||
|
UniqueID (Direct Debit Template) |
Unique ID |
GuIDentifier |
|
||
|
IntegerID (Direct Debit Template) |
Integer ID |
integer |
|
||
|
Name (Direct Debit Template) |
Name |
string |
|
||
|
Settlement Status |
Settlement Status |
Enum |
CashFlowExported, CashFlowNotYetExported, CashFlowNotYetReconciled, CashFlowReconciled, Incomplete, NoDirectSettlement, PaymentDDNotYetCreated, PaymentDDNotYetSent, PaymentDDSent, CashFlowNotReconciled, PaymentDDSent, CashFlowReconciled |
||
|
Action Status |
Action Status |
Enum |
ChangeSI, CreatePaymentDD, Done |
||
|
Payment/DD exists |
Payment/DD exists |
boolean |
|
||
|
Is Locked |
Is Locked |
boolean |
|
||
|
Has Reconciled Cash Flow |
Has Reconciled Cash Flow |
boolean |
|
||
|
Has Exported Cash Flow |
Has Exported Cash Flow |
boolean |
|
||
|
Scheduled Process |
Name of the scheduled process |
string |
|
||
|
Entered Date (Audit Details) |
Entered Date
|
|
NoEndToEndStatusExpected, WaitingForFinalConfirmation, OnlyPositiveStatusCodesAvailableButNotAllTransactionsAreCovered, OnlyNegativeStatusCodesAvailableButNotAllTransactionsAreCovered, BothNegativeAndPositiveStatusCodesAreAvailableButNotAllTransactionsAreCovered, PaymentRejected, PaymentInPartExecuted, PaymentExecuted |
||
|
Entered By (Audit Details) |
Entered By |
|
|
||
|
Last Modified Date (Audit Details) |
Last Modified Date |
|
NoEndToEndStatusExpected, WaitingForFinalConfirmation, OnlyPositiveStatusCodesAvailableButNotAllTransactionsAreCovered, OnlyNegativeStatusCodesAvailableButNotAllTransactionsAreCovered, BothNegativeAndPositiveStatusCodesAreAvailableButNotAllTransactionsAreCovered, PaymentRejected, PaymentInPartExecuted, PaymentExecuted |
||
|
Last Modified By (Audit Details) |
Last Modified By |
|
|