Treasury Guarantees 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.
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 |