Treasury Credit Line Export

UniqueID

string

IntegerID

number

IntegerID (Entity)

Id

int

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

IntegerID (Counterparty)

Id

int

Abbreviation (Counterparty)

Abbreviation of the Participant

string

CoreID (Counterparty)

ID of the legal entity / financial counterparty in Coupa Core

Internal Participant (Counterparty)

Internal Participant

boolean

UniqueID (Deal Type)

UniqueID of deal type

Abbreviation (Deal Type)

Abbreviation of deal type

Direction

TRUE

FALSE

string

Loan, Investment

Currency

TRUE

FALSE

string

Amount

TRUE

FALSE

number

Start Date

TRUE

FALSE

date

End Date

FALSE

FALSE

date

First Name (Contact Person)

string

Surname (Contact Person)

string

Title (Contact Person)

string

Email (Contact Person)

string

Phone (Contact Person)

string

Department (Contact Person)

string

External Reference

FALSE

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

IntegerID (Financial Status Main Category)

IntegerID of the Financial Status Main Category

Name (Financial Status Main Category)

Name (language dependent) of the Financial Status Main Category

IntegerID (Financial Status Category)

IntegerID of the Financial Status Category

Name (Financial Status Category)

Name (language dependent) of the Financial Status Category

Funding

FALSE

FALSE

boolean

UniqueID (Parent Credit Line)

string

IntegerID (Parent Credit Line)

number

Entity (Parent Credit Line)

TRUE

FALSE

string

Counterparty (Parent Credit Line)

TRUE

FALSE

string

Deal Type (Parent Credit Line)

TRUE

FALSE

Direction (Parent Credit Line)

TRUE

FALSE

string

Loan, Investment

Currency (Parent Credit Line)

TRUE

FALSE

string

Comment

FALSE

FALSE

string

Attachments Count

number

Active

boolean

Commitment Fee Rate

FALSE

FALSE

number

Commitment Fee Basis

FALSE

FALSE

string

NonUtilizedAmount, WholeAmount

Commitment Fee Payment Period

FALSE

FALSE

string

Monthly, Quarterly, Biannually, Annually, Unique

Commitment Fee First CalculationDate

FALSE

FALSE

date

Commitment Fee Calculation Date Rolling

FALSE

FALSE

string

Actual, Following, Modified Following, Preceding

Commitment Fee Calculation Ultimo

FALSE

FALSE

boolean

Commitment Fee DayCount Convention

FALSE

FALSE

string

actual365, actual360, 30E360ISDA, actualActualISDA, 30360ICMA, actualActualICMA, bus252, 30360US, actual360Exp, 30360ICMAExp, bus252Exp

Traded Date

FALSE

FALSE

date

Traded User

FALSE

FALSE

Traded User

FALSE

FALSE

Entered Date

date

Classic User IntegerID (Entered User)

integer

Core User IntegerID (Entered User)

integer

IncomingChannel

string

Changed Date

date

Classic User IntegerID (Changed User)

integer

Core User IntegerID (Changed User)

integer

IC Dealing Id

number

Approved

string

Approved, Rejected, Unapproved

Approved Date

date

Classic User IntegerID (Approved User)

integer

Core User IntegerID (Approved User)

integer

Confirmation Sent

string

Confirmation not sent, Rejected, Confirmation sent

Confirmation Sent Date

date

Classic User IntegerID (Confirmation Sent User)

integer

Core User IntegerID (Confirmation Sent User)

integer

Confirmation Received

string

Confirmation not received, Rejected, Confirmation received

Confirmation Received Date

date

Classic User IntegerID (Confirmation Received User)

integer

Core User IntegerID (Confirmation Received User)

integer