Treasury GL Entry 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.
GL Entry Export
Exports GL entries that have not been exported.
|
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 |