Journal Column Return Values

Some methods return arrays of values that correspond to journals’ display columns; these are the columns listed in the Columns tab of the Filters And Sorting dialog box. The following table describes the array elements returned for these columns.

Tip:	For methods that take journal display columns, use the HFMConstants type library constants listed in Journal Column Display Constants.

Table 62. Journal Column Return Values

Column	Return Value (Subtype and Description)
Label	String. The journal label.
Status	Integer. The journal status. The valid return values are represented by the HFMConstants type library constants listed in Journal Status Constants.
Type	Integer. The journal type. The valid return values are represented by the HFMConstants type library constants listed in Journal Type Constants.
Balance Type	Integer. The balance type. The valid return values are represented by the HFMConstants type library constants listed in Balance Type Constants.
Group	String. The name of the journal group.
Description	String. The journal description.
Short Description	String. The truncated version of the journal description.
Created By	String. The fully qualified username of the journal creator.
Date Created	Double. The time and date on which the journal was created. This is returned as a Double that you can cast to a Date format.
Approved By	String. The fully qualified username of the journal approver. If a journal has not been approved, a blank String is returned.
Approved On	Double. The time and date on which the journal was approved. This is returned as a Double that you can cast to a Date format. If a journal has not been approved, 0 is returned.
Posted By	String. The fully qualified username of the journal poster. If a journal has not been posted, a blank String is returned.
Date Posted	Double. The time and date on which the journal was posted. This is returned as a Double that you can cast to a Date format. If a journal has not been posted, 0 is returned.
Security Class	Long. The ID number of the journal’s security class.
Entity	Long. The member ID of the journal’s entity.
Parent	Long. The member ID of the journal’s parent entity.