Treasury Single Direct Debits Export

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

Payer Name

Payer Name

string

Payer Street

Payer Street

string

Payer Postal/ZIP Code

Payer Postal/ZIP Code

string

Payer City

Payer City

string

Payer Province/State

Payer Province/State

string

Payer Country/Region

Payer 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

Execution Date

Execution Date

date

Separate Transmission

Separate Transmission

boolean

Direct Debit Type

Direct Debit Type

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

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 1 User)

Classic User IntegerID (Departmental Approval 1 User)

integer

Core User IntegerID (Departmental Approval 1 User)

Core User IntegerID (Departmental Approval 1 User)

integer

Departmental Approval 1 Date

First departmental approval date

date

Departmental Approval 1 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

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 1 User)

Classic User IntegerID (Bank Approval 1 User)

integer

Core User IntegerID (Bank Approval 1 User)

Core User IntegerID (Bank Approval 1 User)

integer

Bank Approval 1 Date

First bank approval date

date

Bank Approval 1 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

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