Treasury GL Entry Export
The Treasury GL Entry 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 |
|---|---|---|---|---|---|
| UniqueID | GuID of the GL Entry | FALSE | FALSE | GuID | |
| GLAccount | GL Number (either GL Account Number or GL Cash Flow Number) | FALSE | FALSE | string(50) | |
| Debit | Absolute amount in case this is a debit line | FALSE | FALSE | decimal | |
| Credit | Absolute amount in case this is a credit line | FALSE | FALSE | decimal | |
| IntegerID (Entity) | Id | FALSE | FALSE | integer | |
| Abbreviation (Entity) | Title | FALSE | FALSE | string | |
| Payment Reference | Payment Reference | FALSE | FALSE | string(400) | |
| UniqueID (Project) | GuID given by the system | FALSE | FALSE | ||
| IntegerID (Project) | Integer ID given by the system | FALSE | FALSE | integer | |
| Abbreviation (Project) | Abbreviation of the project | TRUE | FALSE | string | |
| UniqueID (Portofolio) | GuID given by the system | FALSE | FALSE | ||
| IntegerID (Portofolio) | Integer ID given by the system | FALSE | FALSE | integer | |
| Abbreviation (Portofolio) | Abbreviation (Portofolio) | TRUE | TRUE | string | |
| UniqueID (Category) | UniqueID (Category) | FALSE | FALSE | GuIDentifier | |
| Abbreviation (Category) | Abbreviation (Category) | FALSE | FALSE | string | |
| Name (Category) | Name (Category) | FALSE | FALSE | string | |
| Classic User IntegerID (Created User) | Classic User IntegerID (Created User) | FALSE | FALSE | integer | |
| Core User IntegerID (Created User) | Core User IntegerID (Created User) | FALSE | FALSE | integer | |
| Created | Date and time when the GL Entry was created | FALSE | FALSE | datetime | |
| Classic User IntegerID (Changed User) | Classic User IntegerID (Changed User) | FALSE | FALSE | integer | |
| Core User IntegerID (Changed User) | Core User IntegerID (Changed User) | FALSE | FALSE | integer | |
| Changed | Date and time when the GL Entry was modified the last time | FALSE | FALSE | datetime | |
| Is Exported | Indicates whether this line has been flagged as exported | FALSE | FALSE | boolean | |
| Classic User IntegerID (Exported User) | Classic User IntegerID (Exported User) | FALSE | FALSE | integer | |
| Core User IntegerID (Exported User) | Core User IntegerID (Exported User) | FALSE | FALSE | integer | |
| ExportedDate | Date and time when the GL Entry was exported | FALSE | FALSE | datetime |