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.
Liquidity Plan Data Export
Exports all records created or updated since the last business day (ultimo) of 2 months ago.
|
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 |