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