Variables and commands list

This section contains the headings, variables, and commands that you can use in the application. A heading is a title that is located at the beginning of a section. A variable is a symbol that represents a value. A command is an order that controls or activates a feature or tool.

The items are listed in alphabetical order. The first line is the heading/variable/command name. The second line is the name of the field as it appears in the database. The third row is the variable type: general for text fields, number for numeric values, date for date fields, and so on. The fourth, and last row, includes additional explanation that describes the purpose or function of the heading/variable/command.  

Headings

You can use these variables to format column headings that appear in each sec­tion on the financial statement.

Address1

Organization Address 1
General

Address2

Organization Address 2
General

AmtTitle

Title for Amount Col­umns
General
The title for trend analysis amount columns of MM/YY, PartQtr, PartSum, or PartYr. This title is based on the amount type.

AmtType

Amount Type Title
General
The trend analysis amount type title of Monthly, Quarterly, Semi-Annual, Annual, or Range.

BegPeriod

Beginning Period
General
The beginning report period in the format MM/YY

CityStZip

Organization City, State, and Zip Code
General

EndPeriod

Ending Period
General
The ending report period in the format MM/YY.

FiscalDate

Fiscal Year Date Date
Fiscal year date for the selected year. This is a combination of two dates. The format must use the dash (-) to separate the for­mat.

FSName

Financial Statement Name
General
The saved name of the finan­cial statement definition.

GrantNo

Grant Number Number
The grant number.

GrantTitle

Grant Title or Description
General
The grant title or description.

Months

Number of months. Number
Number of months printing in the format MONTHS.

Name1

Organization Name 1
General

Name2

Organization Name 2
General

PageNo

Current Page Number
Number

PerDate­Cur

Current Period Date
Date
Current period date for the selected year.

PerDate­Fut

Future Period Date
Date
Future period date for the selected year.

PerDatePri

Prior Period Date
Date
Prior period date for the selected year.

SecHead

Section Heading
General

System­Date

System Date
Date
Current system date.

System­Time

System Time
Date
Current system time.

Total

Total Value
Amount
The total value for the speci­fied total level and column.

TrendDate

Trend Analysis Period Date. Date
Trend period date for the selected period.

YearPcnt

Percent of Year
Number
Percent of year that has elapsed based on the report ending date.

Data Variables

You can insert a data variable to define the type of data that appears in a column on the financial statement.

AcctNo

Formatted GL account
General
GL account with formatting mask as specified in the Con­trol table.

Acct­NoUnfr

Unformatted GL account
General
GL account without the for­matting mask.

AcctTitle

GL Account Title
General
GL account title.

Blank

Blank Column
General
A blank column for creating space between columns or col­umn for manually entered val­ues. A heading may be specified.

Calculated

Calculated Value
Amount
The calculated value that has been selected.

ChgAmt

Changed Amount
Amount
The change in the account bal­ance for the selected value.

ChgBgt

Changed Budget
Amount
The change in the account bal­ance for the selected year.

ChgEnc

Changed Encumbrance
Amount
The change in the encum­brance balance for the selected year.

EstBgt

Estimated Budget
Amount
The estimated (annualized) budget amount for the selected year.

ExpTitle

GL Expanded Account Title
General
The General Ledger expanded titles.

GrntPer­Amt

Grant Period Amount Amount
The period amount for the grant for the report date range specified.

GrntPer­Bgt

Grant Period Budget Amount
The period budget amount for the grant for the report date range specified.

GrntPer­Enc

Grant Period Encum­brance Amount
The period encumbrance amount for the grant for the report date range specified.

Grnt-TDAmt

Grant-to-Date Amount Amount
The account balance for the grant as the ending report date since the inception of the grant.

GrntTD­Bgt

Grant-to-Date Budget Amount
The budget balance for the grant as the ending report date since the inception of the grant.

Grnt-TDEnc

Grant-to-Date Encum­brance Amount
The encumbrance balance for the grant as the ending report date since the inception of the grant.

GrntTot­Amt

Grant Total (Annual) Amount Amount
The annualized account amount for the grant.

GrntTot­Bgt

Grant Total (Annual) Budget Amount
The annual budget amount for the grant.

Grnt­TotEnc

Grant Total (Annual) Encumbrance Amount
The annualized encumbrance amount for the grant.

PerBgtLlv

Period Budget Level Amount
The budget level amount for the report period range speci­fied for the selected year and budget level.

PeriodAct

Period Actual Amount Amount
The actual account amount for the report period range speci­fied for the selected year. (Does not include Report Only transactions.)

PeriodAmt

Period Amount Amount
The account amount for the report period range specified for the selected year.

PeriodBgt

Period Budget Amount
The budget amount for the report period range specified for the selected year.

PeriodEnc

Period Encumbrance Amount The encumbrance amount for the report period range speci­fied for the selected year.

PropBgt

Proposed Budget Amount
The proposed budget amount for the year selected.

SegNo

Segment Number Number
The segment number of the selected segment.

SegTitle

Segment Title General
The title of the selected seg­ment.

Stored

Stored Value General
The stored value selected.

TotalAct

Total Actual Amount Amount
The total actual account amount for the selected year. (Does not include Report Only transactions.)

TotalAmt

Total Amount Amount
The total account amount for the selected year.

TotalBgt

Total (Annual) Budget Amount
The total budget amount for the selected year.

TotalEnc

Total (Annual) Encum­brance Amount
The total encumbrance amount for the selected year.

TotBgtLvl

Total (Annual) Budget Level Amount
The total budget level amount for the selected year and bud­get level.

TrendAmt

Trend Analysis Period Amount Amount
The account amount for the period selected based on the report period range.

TrendBgt

Trend Analysis Period Budget Amount
The budget amount for the period selected based on the report period range.

TrendEnc

Trend Analysis Period Encumbrance Amount
The encumbrance amount for the period selected based on the period range.

YearBeg-Amt

Year Beginning Amount. Amount
The beginning account bal­ance for the selected year.

YearBeg­Bgt

Year Beginning Budget
Amount
The beginning budget balance for the selected year.

YearBe­gEnc

Year Beginning Encum­brance
Amount
The beginning encumbrance balance for the selected year.

YTDAct

Year-to-Date Actual Amount
Amount
The year-to-date actual amount for the selected year through the report ending date. (Does not include Report Only transactions.)

YTDAmt

Year-to-Date Amount
Amount
The year-to-date account amount for the selected year through the report ending date.

YTDBgt

Year-to-Date Budget
Amount
The year-to-date budget amount for the selected year through the report ending date.

YTDB­gtLvl

Year-to-Date Budget Level
Amount
The year-to-date budget level amount through the report end­ing date for the selected year and budget level.

YTDEnc

Year-to-Date Encum­brance
Amount
The year-to-date encumbrance amount for the selected year through the report ending date.

Commands

You can insert a command to perform an action.

/Loop AcctCode=L

Find all liability accounts

/Loop AcctCode=Q

Find all equity accounts.

/Loop AcctCode=E

Find all revenue accounts.

/Loop AcctCode=R

Find the net revenue.

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.