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.
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 |