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