Treasury Bulk Payment Details Export

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