Treasury Guarantees Export
Export of these records is included as a Standard CSV Export.
Guarantees Export
Exports all outstanding guarantees (return date today or in the future).
|
Column Name |
Description |
Req'd |
Unique |
Type |
Allowable Values |
|---|---|---|---|---|---|
|
IntegerID |
integer |
||||
|
UniqueID |
string |
||||
|
UniqueID (Type) |
UniqueID of deal type |
|
|||
|
Abbreviation (Type) |
Abbreviation of deal type |
|
|||
|
Guarantee Type |
string |
Bank Guarantee, Group Guarantee, Received Guarantee, Insurance Bonds, Guarantee on behalf |
|||
|
Issuing Date |
date |
||||
|
Open Item Until |
date |
||||
|
Validity Date |
date |
||||
|
IntegerID (Applicant) |
Id |
int |
|||
|
Abbreviation (Applicant) |
Abbreviation of the Participant |
string |
|||
|
CoreID (Applicant) |
ID of the legal entity / financial counterparty in Coupa Core |
||||
|
Internal Participant (Applicant) |
Internal Participant |
boolean |
|||
|
IntegerID (Beneficiary) |
integer |
||||
|
UniqueID (Beneficiary) |
string |
||||
|
Abbreviation (Beneficiary) |
string |
||||
|
Name (Beneficiary) |
string |
||||
|
Status (Beneficiary) |
boolean |
||||
|
IntegerID (Issuer) |
Id |
int |
|||
|
Abbreviation (Issuer) |
Abbreviation of the Participant |
string |
|||
|
CoreID (Issuer) |
ID of the legal entity / financial counterparty in Coupa Core |
||||
|
Internal Participant (Issuer) |
Internal Participant |
boolean |
|||
|
Currency |
string |
||||
|
Amount |
decimal |
||||
|
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 |
|
|||
|
Changed (Financial Status Category) |
Date and time when the portfolio was changed the last time |
|
|||
|
Number of Guarantee |
string |
||||
|
IntegerID (Credit Line) |
Integer ID given by the system |
|
|||
|
UniqueID (Credit Line) |
GuID given by the system |
||||
|
Class |
|
Concluded, Projected, Benchmark |
|||
|
Return Date |
date |
||||
|
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 |
|
|
SRO Value |
decimal |
||||
|
Trade Date |
date |
||||
|
Classic User IntegerID (Dealer) |
integer |
||||
|
Core User IntegerID (Dealer) |
integer |
||||
|
Entered |
date |
||||
|
Classic User IntegerID (Entered by) |
integer |
||||
|
Core User IntegerID (Entered by) |
integer |
||||
|
Changed |
date |
||||
|
Classic User IntegerID (Changed by) |
integer |
||||
|
Core User IntegerID (Changed by) |
integer |
||||
|
Approved |
|||||
|
Approved date |
|||||
|
Classic User IntegerID (Approved by) |
integer |
||||
|
Core User IntegerID (Approved by) |
integer |
||||
|
Confirmation Sent |
|||||
|
Confirmation Sent Date |
date |
||||
|
Classic User IntegerID (Confirmation Sent by) |
integer |
||||
|
Core User IntegerID (Confirmation Sent by) |
integer |
||||
|
Confirmation Received |
|||||
|
Confirmation Received date |
date |
||||
|
Classic User IntegerID (Confirmation Received by) |
integer |
||||
|
Core User IntegerID (Confirmation Received by) |
integer |
||||
|
L/C Number |
|||||
|
Internal Limit Date |
|||||
|
Contract Value |
|||||
|
ID (Wording) |
|||||
|
Wording (Wording) |
|||||
|
Foreign bank |
|||||
|
ALNo. |
|||||
|
Comments |
|||||
|
Documents attached |