Treasury Bulk Payment Details Export
Export of these records is included as a Standard CSV Export.
Because Integration Transaction Formats are not available for Treasury objects, you cannot configure the columns for this export.
Column Name |
Description |
Req'd |
Unique |
Type |
Allowable Values |
---|---|---|---|---|---|
IntegerID |
IntegerID |
integer |
|||
UniqueId |
UniqueId |
GuIDentifier |
|||
UniqueId (Bulk Payment) |
UniqueId (Bulk Payment) |
GuIDentifier |
|||
IntegerID (Bulk Payment) |
IntegerID (Bulk Payment) |
integer |
|||
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) |
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 |
||||
Beneficiary Name |
string |
||||
Beneficiary Street |
string |
||||
Beneficiary Postal/ZIP Code |
string |
||||
Beneficiary City |
string |
||||
Beneficiary Province/State |
string |
||||
Beneficiary Country/Region |
string |
||||
IBAN |
string |
||||
SWIFT Code / BIC |
string |
||||
Account Number |
string |
||||
Bank Code |
string |
||||
Branch Code |
string |
||||
Bank Name |
string |
||||
Bank Street |
string |
||||
Bank Postal/ZIP Code |
string |
||||
Bank City |
string |
||||
Bank Province/State |
|
string |
|||
Bank Country/Region |
string |
||||
Payment Information ID |
string |
||||
SWIFT UETR |
string |
||||
Amount |
decimal |
||||
Payment Reference |
string |
||||
End-to-end Reference |
string |
||||
Expense Regulation |
string |
||||
Execution Date |
date |
||||
Urgent Payment |
boolean |
||||
Payment Instruction 1 |
string |
||||
Payment Instruction 2 |
string |
||||
Payment Instruction 3 |
string |
||||
Payment Instruction 4 |
string |
||||
Payment Instruction 5 |
string |
||||
Payment Instruction 6 |
string |
||||
Payment Instruction 7 |
string |
||||
Payment Instruction 8 |
string |
||||
Payment Instruction 9 |
string |
||||
Payment Instruction 10 |
string |
||||
Intermediary Bank |
string |
||||
Intermediary Bank IBAN |
string |
||||
Intermediary Bank SWIFT Code / BIC |
string |
||||
Intermediary Bank Account Number |
string |
||||
Intermediary Bank Bank Code |
string |
||||
Intermediary Bank Name |
string |
||||
Intermediary Bank Street |
string |
||||
Intermediary Bank Postal/ZIP Code |
string |
||||
Intermediary Bank City |
string |
||||
Intermediary Bank Province/State |
string |
||||
Intermediary Bank Country/Region |
string |
||||
Ultimate Debtor Name |
string |
||||
Ultimate Debtor Street |
string |
||||
Ultimate Debtor Postal/ZIP Code |
string |
||||
Ultimate Debtor City |
string |
||||
Ultimate Debtor Province/State |
string |
||||
Ultimate Debtor Country/Region |
string |
||||
Comment |
string |
||||
IntegerID (Category) |
Integer ID given by the system |
integer |
|||
UniqueID (Category) |
GuID given by the system |
GuIDentifier |
|||
Abbreviation (Category) |
TRUE |
TRUE |
string |
||
Name (Category) |
TRUE |
FALSE |
string |
||
UniqueID (Project) |
GuID given by the system |
|
|
|
|
IntegerID (Project) |
Integer ID given by the system |
|
|
int |
|
Abbreviation (Project) |
Abbreviation of the project |
TRUE |
|
string |
|
UniqueID (Portfolio) |
GuID given by the system |
|
|
|
|
IntegerID (Portfolio) |
Integer ID given by the system |
|
|
int |
|
Abbreviation (Portfolio) |
Abbreviation of the portfolio |
TRUE |
TRUE |
string |
|
Cash Forecast Value Date |
date |
||||
Value Date Follows Execution Date |
boolean |
||||
Entered Status |
|
Canceled, Canceled Payment requires attention, Entered |
|||
Classic User IntegerID (Entered User) |
integer |
||||
Core User IntegerID (Entered User) |
integer |
||||
Entered Date |
date |
||||
Changed Date |
Date and time the payment was changed the last time |
|
|||
Classic User IntegerID (Changed User) |
integer |
||||
Core User IntegerID (Changed User) |
integer |
||||
Departmental Approval Status |
|
||||
Classic User IntegerID (Departmental Approval 1 User) |
integer |
||||
Core User IntegerID (Departmental Approval 1 User) |
integer |
||||
Departmental Approval 1 Date |
First departmental approval date |
date |
|||
IntegerID (Departmental Approval 1 Auth. Level) |
ID of signing authority |
integer |
|||
Signing Authority Unique ID (Departmental Approval 1 Auth. Level) |
Unique ID of signing authority |
GuIDentifier |
|||
Signing Authority (Departmental Approval 1 Auth. Level) |
Signing authority assigned to the user |
E, A, B, O, S, Eminus, Aminus, Bminus, EL, AL, BL, ELminus, ALminus, BLminus, ET, AT, BT, ETminus, ATminus, BTminus, |
|||
Classic User IntegerID (Departmental Approval 2 User) |
integer |
|
|||
Core User IntegerID (Departmental Approval 2 User) |
integer |
|
|||
Departmental Approval 2 Date |
Second departmental approval date |
|
|
||
IntegerID (Departmental Approval 2 Auth. Level) |
ID of signing authority |
integer |
|
||
Signing Authority Unique ID (Departmental Approval 2 Auth. Level) |
Unique ID of signing authority |
GuIDentifier |
|
||
Signing Authority (Departmental Approval 2 Auth. Level) |
Signing authority assigned to the user |
|
E, A, B, O, S, Eminus, Aminus, Bminus, EL, AL, BL, ELminus, ALminus, BLminus, ET, AT, BT, ETminus, ATminus, BTminus, |
||
Bank Approval Status |
|
NoApprovals, BankApproval1, BankApproval2 |
|||
Classic User IntegerID (Bank Approval User) |
integer |
|
|||
Core User IntegerID (Bank Approval User) |
integer |
|
|||
Bank Approval Date |
First bank approval date |
date |
|
||
IntegerID (Bank Approval Auth. Level) |
ID of signing authority |
integer |
|
||
Signing Authority Unique ID (Bank Approval Auth. Level) |
Unique ID of signing authority |
GuIDentifier |
|
||
Signing Authority (Bank Approval Auth. Level) |
Signing authority assigned to the user |
|
E, A, B, O, S, Eminus, Aminus, Bminus, EL, AL, BL, ELminus, ALminus, BLminus, ET, AT, BT, ETminus, ATminus, BTminus, |
||
Classic User IntegerID (Bank Approval 2 User) |
integer |
|
|||
Core User IntegerID (Bank Approval 2 User) |
integer |
|
|||
Bank Approval 2 Date |
Second bank approval date |
|
|
||
IntegerID (Bank Approval 2 Auth. Level) |
ID of signing authority |
integer |
|
||
Signing Authority Unique ID (Bank Approval 2 Auth. Level) |
Unique ID of signing authority |
GuIDentifier |
|
||
Signing Authority (Bank Approval 2 Auth. Level) |
Signing authority assigned to the user |
|
E, A, B, O, S, Eminus, Aminus, Bminus, EL, AL, BL, ELminus, ALminus, BLminus, ET, AT, BT, ETminus, ATminus, BTminus, |
||
Transmission Status |
|
Unsent, InTransit, TransmissionStopped, TransmittedToBank |
|||
Bank Processing Status |
|
NotReceivedByBank, InProcessAtBank, OnlyPositiveStatusCodesAvailableButNotAllTransactionsAreCovered, OnlyNegativeStatusCodesAvailableButNotAllTransactionsAreCovered, BothNegativeAndPositiveStatusCodesAreAvailableButNotAllTransactionsAreCovered, PaymentRejected, PaymentInPartExecuted, PaymentComplete |
|||
End-to-End Status Status |
|
NoEndToEndStatusExpected, WaitingForFinalConfirmation, OnlyPositiveStatusCodesAvailableButNotAllTransactionsAreCovered, OnlyNegativeStatusCodesAvailableButNotAllTransactionsAreCovered, BothNegativeAndPositiveStatusCodesAreAvailableButNotAllTransactionsAreCovered, PaymentRejected, PaymentInPartExecuted, PaymentExecuted |
|||
Subject to Verification |
boolean |
|
|||
Verification Status |
|
NotYetValidated, Verified, Suspicious, Rejected |
|||
Classic User IntegerID (Verification User) |
integer |
|
|||
Core User IntegerID (Verification User) |
integer |
|
|||
Verification Date |
date |
|