Treasury Single Payment Export

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.

Column Name

Description

Req'd

Unique

Type

Allowable Values

IntegerID

IntegerID

integer

UniqueID

UniqueID

GuIDentifier

GroupID

GroupID

integer

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

UniqueID (Template)

UniqueID (Template)

GuIDentifier

IntegerID (Template)

IntegerID (Template)

integer

Name (Template)

Name (Template)

string

Transaction Type

Transaction Type

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)

EntityIntegerID (Account)

EntityAbbreviation (Account)

EntityAbbreviation (Account)

EntityCoreID (Account)

EntityCoreID (Account)

EntityReportingClassification (Account)

EntityReportingClassification (Account)

BankIntegerID (Account)

BankIntegerID (Account)

BankAbbreviation (Account)

BankAbbreviation (Account)

ID (Intercompany Account)

ID of the account

int

Name (Intercompany Account)

Name of the account

string(50)

GL Account Number (Intercompany Account)

Currency of the account

string(9)

EntityIntegerID (Intercompany Account)

EntityIntegerID (Intercompany Account)

EntityAbbreviation (Intercompany Account)

EntityAbbreviation (Intercompany Account)

EntityCoreID (Intercompany Account)

EntityCoreID (Intercompany Account)

EntityReportingClassification (Intercompany Account)

EntityReportingClassification (Intercompany Account)

BankIntegerID (Intercompany Account)

BankIntegerID (Intercompany Account)

BankAbbreviation (Intercompany Account)

BankAbbreviation (Intercompany Account)

Intercompany Account Mirror

Intercompany Account Mirror

boolean

Beneficiary Name

Beneficiary Name

string

Beneficiary Street

Beneficiary Street

string

Beneficiary Postal/ZIP Code

Beneficiary Postal/ZIP Code

string

Beneficiary City

Beneficiary City

string

Beneficiary Province/State

Beneficiary Province/State

string

Beneficiary Country/Region

Beneficiary Country/Region

string

IBAN

IBAN

string

SWIFT Code / BIC

SWIFT Code / BIC

string

Account Number

Account Number

string

Bank Code

Bank Code

string

Branch Code

Branch Code

string

Bank Name

Bank Name

string

Bank Street

Bank Street

string

Bank Postal/ZIP Code

Bank Postal/ZIP Code

string

Bank City

Bank City

string

Bank Province/State

Bank Province/State

string

Bank Country/Region

Bank Country/Region

string

Amount

Amount

decimal

Payment Reference

Payment Reference

string

End-to-end Reference

End-to-end Reference

string

Expense Regulation

Expense Regulation

string

Execution Date

Execution Date

date

Separate Transmission

Separate Transmission

boolean

Urgent Payment

Urgent Payment

boolean

Payment Instruction 1

Payment Instruction 1

string

Payment Instruction 2

Payment Instruction 2

string

Payment Instruction 3

Payment Instruction 3

string

Payment Instruction 4

Payment Instruction 4

string

Payment Instruction 5

Payment Instruction 5

string

Payment Instruction 6

Payment Instruction 6

string

Payment Instruction 7

Payment Instruction 7

string

Payment Instruction 8

Payment Instruction 8

string

Payment Instruction 9

Payment Instruction 9

string

Payment Instruction 10

Payment Instruction 10

string

Intermediary Bank

Intermediary Bank

string

Intermediary Bank IBAN

Intermediary Bank IBAN

string

Intermediary Bank SWIFT Code / BIC

Intermediary Bank SWIFT Code / BIC

string

Intermediary Bank Account Number

Intermediary Bank Account Number

string

Intermediary Bank Bank Code

Intermediary Bank Bank Code

string

Intermediary Bank Name

Intermediary Bank Name

string

Intermediary Bank Street

Intermediary Bank Street

string

Intermediary Bank Postal/ZIP Code

Intermediary Bank Postal/ZIP Code

string

Intermediary Bank City

Intermediary Bank City

string

Intermediary Bank Province/State

Intermediary Bank Province/State

string

Intermediary Bank Country/Region

Intermediary Bank Country/Region

string

Comment

Comment

string

IntegerID (Category)

Integer ID given by the system

integer

UniqueID (Category)

GuID given by the system

GuIDentifier

Abbreviation (Category)

Abbreviation (Category)

Yes

Yes

string

Name (Category)

Name (Category)

Yes

Yes

string

UniqueID (Project)

GuID given by the system

IntegerID (Project)

Integer ID given by the system

int

Abbreviation (Project)

Abbreviation of the project

Yes

string

UniqueID (Portfolio)

GuID given by the system

IntegerID (Portfolio)

Integer ID given by the system

int

Abbreviation (Portfolio)

Abbreviation of the portfolio

Yes

Yes

string

Cash Forecast Value Date

Cash Forecast Value Date

date

Value Date Follows Execution Date

Value Date Follows Execution Date

boolean

Entered Status

Entered Status

Canceled Canceled Payment requires attention Entered

Classic User IntegerID (Entered User)

Classic User IntegerID (Entered User)

integer

Core User IntegerID (Entered User)

Core User IntegerID (Entered User)

integer

Entered Date

Entered Date

date

Changed Date

Date and time the payment was changed the last time

Classic User IntegerID (Changed User)

Classic User IntegerID (Changed User)

integer

Core User IntegerID (Changed User)

Core User IntegerID (Changed User)

integer

Departmental Approval Status

Departmental Approval Status

Classic User IntegerID (Departmental Approval User)

Classic User IntegerID (Departmental Approval User)

integer

Core User IntegerID (Departmental Approval User)

Core User IntegerID (Departmental Approval User)

integer

Departmental Approval Date

First departmental approval date

date

Departmental Approval Auth. Level

First departmental appoval authorization

E, A, B, O, S, E-, A-, B-, EL, AL, BL, EL-, AL-, BL-, ET, AT, BT, ET-, AT-, BT-,

Classic User IntegerID (Departmental Approval 2 User)

Classic User IntegerID (Departmental Approval 2 User)

integer

Core User IntegerID (Departmental Approval 2 User)

Core User IntegerID (Departmental Approval 2 User)

integer

Departmental Approval 2 Date

Second departmental approval date

date

Departmental Approval 2 Auth. Level

Second departmental appoval authorization

E, A, B, O, S, E-, A-, B-, EL, AL, BL, EL-, AL-, BL-, ET, AT, BT, ET-, AT-, BT-,

Bank Approval Status

Bank Approval Status

NoApprovals, BankApproval1, BankApproval2

Classic User IntegerID (Bank Approval User)

Classic User IntegerID (Bank Approval User)

integer

Core User IntegerID (Bank Approval User)

Core User IntegerID (Bank Approval User)

integer

Bank Approval Date

First bank approval date

date

Bank Approval Auth. Level

First bank appoval authorization

E, A, B, O, S, E-, A-, B-, EL, AL, BL, EL-, AL-, BL-, ET, AT, BT, ET-, AT-, BT-,

Classic User IntegerID (Bank Approval 2 User)

Classic User IntegerID (Bank Approval 2 User)

integer

Core User IntegerID (Bank Approval 2 User)

Core User IntegerID (Bank Approval 2 User)

integer

Bank Approval 2 Date

Second bank approval date

date

Bank Approval 2 Auth. Level

Second bank appoval authorization

E, A, B, O, S, E-, A-, B-, EL, AL, BL, EL-, AL-, BL-, ET, AT, BT, ET-, AT-, BT-,

Transmission Status

Transmission Status

Unsent, InTransit, TransmissionStopped, TransmittedToBank

Bank Processing Status

Bank Processing Status

NotReceivedByBank, InProcessAtBank, OnlyPositiveStatusCodesAvailableButNotAllTransactionsAreCovered, OnlyNegativeStatusCodesAvailableButNotAllTransactionsAreCovered, BothNegativeAndPositiveStatusCodesAreAvailableButNotAllTransactionsAreCovered, PaymentRejected, PaymentInPartExecuted, PaymentComplete

End-to-End Status Status

End-to-End Status Status

NoEndToEndStatusExpected, WaitingForFinalConfirmation, OnlyPositiveStatusCodesAvailableButNotAllTransactionsAreCovered, OnlyNegativeStatusCodesAvailableButNotAllTransactionsAreCovered, BothNegativeAndPositiveStatusCodesAreAvailableButNotAllTransactionsAreCovered, PaymentRejected, PaymentInPartExecuted, PaymentExecuted

Subject to Verification

Subject to Verification

boolean

Verification Status

Verification Status

NotYetValidated, Verified, Suspicious, Rejected

Classic User IntegerID (Verification User)

Classic User IntegerID (Verification User)

integer

Core User IntegerID (Verification User)

Core User IntegerID (Verification User)

integer

Verification Date

Verification Date

date