Treasury Letters of Credit 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.
Letters of Credit Export
Exports all outstanding letters of credit (settlement date of today or in the future).
|
Column Name |
Description |
Req'd |
Unique |
Type |
Allowable Values |
|---|---|---|---|---|---|
|
IntegerID |
integer |
||||
|
UniqueID |
string |
||||
|
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 (Remitter/Beneficiary) |
integer |
||||
|
UniqueID (Remitter/Beneficiary) |
string |
||||
|
Abbreviation (Remitter/Beneficiary) |
string |
||||
|
Name (Remitter/Beneficiary) |
string |
||||
|
Status (Remitter/Beneficiary) |
boolean |
||||
|
Country/Region |
string |
||||
|
IntegerID (Advising Bank) |
Id |
int |
|||
|
Abbreviation (Advising Bank) |
Abbreviation of the Participant |
string |
|||
|
CoreID (Advising Bank) |
ID of the legal entity / financial counterparty in Coupa Core |
||||
|
Internal Participant (Advising Bank) |
Internal Participant |
boolean |
|||
|
IntegerID (Issuing Bank) |
Id |
int |
|||
|
Abbreviation (Issuing Bank) |
Abbreviation of the Participant |
string |
|||
|
CoreID (Issuing Bank) |
ID of the legal entity / financial counterparty in Coupa Core |
||||
|
Internal Participant (Issuing Bank) |
Internal Participant |
boolean |
|||
|
IntegerID (Bank) |
Id |
int |
|||
|
Abbreviation (Bank) |
Abbreviation of the Participant |
string |
|||
|
CoreID (Bank) |
ID of the legal entity / financial counterparty in Coupa Core |
||||
|
Internal Participant (Bank) |
Internal Participant |
boolean |
|||
|
Issuing Date |
date |
||||
|
Latest Shipment |
date |
||||
|
Date of Expiry |
date |
||||
|
Place of Expiry |
string |
||||
|
Settlement Date |
date |
||||
|
Confirmation |
General Confirmation |
boolean |
|||
|
Commitment Date |
Commitment Date |
date |
|||
|
Currency |
string |
||||
|
Amount |
decimal |
||||
|
Outstanding |
decimal |
||||
|
Open |
decimal |
||||
|
L/C No. |
string |
||||
|
Reference No. |
string |
||||
|
RefNo (Commitment) |
string |
||||
|
RefNo (Counterparty) |
string |
||||
|
ALNo. |
string |
||||
|
UniqueID (Deal Type) |
UniqueID of deal type |
|
|||
|
Abbreviation (Deal Type) |
Abbreviation of deal type |
|
|||
|
Document Status |
|
Complete, Incomplete |
|||
|
Delivery Terms |
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 |
|
|||
|
IntegerID (Credit Line) |
Integer ID given by the system |
|
|||
|
UniqueID (Credit Line) |
GuID given by the system |
|
|||
|
Class |
|
Concluded, Projected, Benchmark |
|||
|
Inactive |
|
||||
|
Inactive date |
date |
||||
|
Classic User IntegerID (Inactive by) |
integer |
||||
|
Core User IntegerID (Inactive by) |
integer |
||||
|
Trade Date |
date |
||||
|
Classic User IntegerID (Dealer) |
integer |
||||
|
Core User IntegerID (Dealer) |
integer |
||||
|
Entered |
|
||||
|
Classic User IntegerID (Entered by) |
integer |
||||
|
Core User IntegerID (Entered by) |
integer |
||||
|
Changed |
|
||||
|
Classic User IntegerID (Changed by) |
integer |
||||
|
Core User IntegerID (Changed by) |
integer |
||||
|
Approved |
|
||||
|
Approved date |
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 |