Treasury Commodities 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 |
IntegerID |
integer |
|||
|
UniqueID |
UniqueID |
GUIDentifier |
|||
|
Instrument Category |
Instrument Category |
Enum |
Forward, Swap, Future, FutureSwap |
||
|
IntegerID (Entity) |
Id |
int |
|||
|
Abbreviation (Entity) |
Abbreviation of the Participant |
string |
|||
|
CoreID (Entity) |
ID of the legal entity / financial counterparty in Coupa Core |
|
|||
|
ReportingClassification (Entity) |
ReportingClassification of the Participant (Internal or External) |
|
Internal, External |
||
|
IntegerID (Counterparty) |
Id |
int |
|||
|
Abbreviation (Counterparty) |
Abbreviation of the Participant |
string |
|||
|
CoreID (Counterparty) |
ID of the legal entity / financial counterparty in Coupa Core |
||||
|
ReportingClassification (Counterparty) |
ReportingClassification of the Participant (Internal or External) |
Internal, External |
|||
|
UniqueID (Deal Type) |
UniqueID of deal type |
||||
|
Abbreviation (Deal Type) |
Abbreviation of deal type |
||||
|
Buy/Sell |
Buy/Sell |
Buy, Sell |
|||
|
Contract Name |
Contract Name |
string |
|||
|
Contract Size |
Contract Size |
decimal |
|||
|
P-UTI |
P-UTI |
string |
|||
|
Cut-off Date |
Cut-off Date |
date |
|||
|
Volume |
Volume |
decimal |
|||
|
Quantity |
Quantity |
decimal |
|||
|
Commodity |
Commodity |
string |
|||
|
Equivalent Amount |
Equivalent Amount |
decimal |
|||
|
Currency |
Currency |
string |
|||
|
Rate |
Rate |
decimal |
|||
|
Spot Rate |
Spot Rate |
decimal |
|||
|
Settlement Rate |
Settlement Rate |
decimal |
|||
|
Settlement |
Settlement |
Cash, Deal, Open |
|||
|
Settlement Type |
Settlement Type |
ClosingRate, AverageRatePeriod |
|||
|
Comments |
Comments |
string |
|||
|
Unique Trade Identifier (UTI) |
Unique Trade Identifier (UTI) |
string |
|||
|
External Reference |
External Reference |
string |
|||
|
IntegerID (Classic Credit Line) |
Integer ID given by the system |
||||
|
UniqueID (Classic Credit Line) |
GuID given by the system |
||||
|
UniqueID (Classic Credit Line) |
GuID given by the system |
||||
|
IntegerID (Classic Credit Line) |
Integer ID given by the system |
int |
|||
|
Class |
Class |
Concluded, Projected, Benchmark |
|||
|
UniqueID (Project) |
GuID given by the system |
||||
|
IntegerID (Project) |
Integer ID given by the system |
int |
|||
|
Abbreviation (Project) |
Abbreviation of the project |
Yes |
string |
||
|
UniqueID (Portfolio) |
GuID given by the system |
|
|||
|
IntegerID (Portfolio) |
Integer ID given by the system |
int |
|||
|
Abbreviation (Portfolio) |
Abbreviation of the portfolio |
Yes | Yes |
string |
|
|
UniqueID (IFRS Class) |
UniqueID (IFRS Class) |
||||
|
IntegerID (IFRS Class) |
IntegerID (IFRS Class) |
||||
|
Abbreviation (IFRS Class) |
Abbreviation (IFRS Class) |
||||
|
Commission |
Commission |
decimal |
|||
|
In Funding |
In Funding |
boolean |
|||
|
Traded Date |
Date and time the deal was concluded |
|
|||
|
Classic User IntegerID (Traded User) |
Classic User IntegerID (Traded User) |
integer |
|||
|
Core User IntegerID (Traded User) |
Core User IntegerID (Traded User) |
integer |
|||
|
Entered Date |
Date and time the deal was entered in the system |
|
|||
|
Classic User IntegerID (Entered User) |
Classic User IntegerID (Entered User) |
integer |
|||
|
Core User IntegerID (Entered User) |
Core User IntegerID (Entered User) |
integer |
|||
|
Changed Date |
Date and time the deal was changed the last time |
|
|||
|
Classic User IntegerID (Changed User) |
Classic User IntegerID (Changed User) |
integer |
|||
|
Core User IntegerID (Changed User) |
Core User IntegerID (Changed User) |
integer |
|||
|
Approved |
Indicates whether the deal was approved |
||||
|
Approved Date |
Date and time the deal was approved |
||||
|
Classic User IntegerID (Approved User) |
Classic User IntegerID (Approved User) |
integer |
|||
|
Core User IntegerID (Approved User) |
Core User IntegerID (Approved User) |
integer |