Treasury Liquidity Plan Data 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 of the liquidity plan data entry |
integer |
|||
|
IntegerID (Entity) |
Id |
intinteger |
|||
|
Abbreviation (Entity) |
Title |
string |
|||
|
IntegerID (Liquidity Plan) |
IntegerID of the liquidity plan |
intinteger |
|||
|
Name (Liquidity Plan) |
Name of the liquidity plan |
string(200) |
|||
|
Amount |
Amount of the liquidity plan data entry |
decimal |
|||
|
Currency |
Currency of the liquidity plan data entry |
string(9) |
|||
|
Value Date |
Value Date of the liquidity plan data entry |
DateTime |
|||
|
Rate |
Rate by which the amount in entity currency is calculated |
decimal |
|||
|
Is Reciprocal |
Indicates whether the rate is reciprocal or not |
boolean |
|||
|
Is Rate Fixed |
Indicates whether the rate is fixed (cannot be overwritten by applying rates to a plan) or not |
boolean |
|||
|
UniqueID (Category) |
UniqueID (Category) |
GuIDentifier |
|||
|
Abbreviation (Category) |
Abbreviation (Category) |
string |
|||
|
Name (Category) |
Name (Category) |
string |
|||
|
IntegerID (Counterparty) |
Id |
integer |
|||
|
Abbreviation (Counterparty) |
Title |
string |
|||
|
Is Active |
Indicates whether the data entry is active (taken into account) or not |
boolean |
|||
|
IntegerID (Hegde Name) |
Id |
integer |
|||
|
Underlying (Hegde Name) |
Name |
string |
|||
|
Currency (Hegde Name) |
CurrencyIsoCode |
string |
|||
|
UniqueID (Project) |
GuID given by the system |
||||
|
IntegerID (Project) |
Integer ID given by the system |
integer |
|||
|
Abbreviation (Project) |
Abbreviation of the project |
string |
|||
|
UniqueID (Portfolio) |
GuID given by the system |
||||
|
IntegerID (Portfolio) |
Integer ID given by the system |
integer |
|||
|
Abbreviation (Portfolio) |
Abbreviation of the portfolio |
Yes |
Yes |
string |
|
|
ID (Account) |
ID of the account |
integer |
|||
|
Name (Account) |
Name of the account |
string(50) |
|||
|
Currency (Account) |
Currency of the account |
string(9) |
|||
|
Probability |
Probability of the liquidity plan data entry |
double |
|||
|
Remark |
Remark of the liquidity plan data entry |
string(400) |
|||
|
Classic User IntegerID (Entered User) |
Classic User IntegerID (Entered User) |
integer |
|||
|
Core User IntegerID (Entered User) |
Core User IntegerID (Entered User) |
integer |
|||
|
Entered |
Date and time when the liquidity plan data entry was entered |
Datetime |
|||
|
Classic User IntegerID (Changed User) |
Classic User IntegerID (Changed User) |
integer |
|||
|
Core User IntegerID (Changed User) |
Core User IntegerID (Changed User) |
integer |
|||
|
Changed |
Date and time when the liquidity plan data entry was changed the last time |
Datetime |