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