This data object currently only pulls in the current year and the previous 2 years and next 2 years for a max total of 5 years of data.

URL

/frw/GeneralLedgerBalance

Field Details…

SQL Field Name Column Description
AccountType This Field Displays the Account type of the General Ledger number.
AccountingCategory This Field Displays the Accounting Category Assigned to the General Ledger Number. Accounting Categories are user defined.
AccountingPeriodBeginningDate This Field Displays the date the accounting period began.
AprilActivity This field displays April’s General Ledger Activity for the given branch, GL account, department, and fiscal year.
AprilBudget This field displays April’s Budget Amount for the given branch, GL account, department, and fiscal year.
AprilPriorActivity This field displays April’s Prior year General Ledger Activity for the given branch, GL account, department, and fiscal year.
AugustActivity This field displays August’s General Ledger Activity for the given branch, GL account, department, and fiscal year.
AugustBudget This field displays August’s Budget Amount for the given branch, GL account, department, and fiscal year.
AugustPriorActivity This field displays August’s Prior year General Ledger Activity for the given branch, GL account, department, and fiscal year.
BalanceForward This field displays the balance forward of the GL account for the given branch and fiscal year.
BalanceForwardPriorYear This field displays the prior year balance forward of the GL accoung for the given branch and fiscal year.
DecemberActivity This field displays December’s General Ledger Activity for the given branch, GL account, department, and fiscal year.
DecemberBudget This field displays December’s Budget Amount for the given branch, GL account, department, and fiscal year.
DecemberPriorActivity This field displays December’s Prior year General Ledger Activity for the given branch, GL account, department, and fiscal year.
Department This field displays the department we are displaying the data for.
DepartmentNumericCode This field displays the numeric code of the department we are displaying the data for.
Description This field displays the Long Description of a general ledger account number.
Division This field displays the division the a branch is associated with.
FebruaryActivity This field displays February’s General Ledger Activity for the given branch, GL account, department, and fiscal year.
FebruaryBudget This field displays February’s Budget Amount for the given branch, GL account, department, and fiscal year.
FebruaryPriorActivity This field displays February’s Prior year General Ledger Activity for the given branch, GL account, department, and fiscal year.
FiscalYear This field displays the fiscal year we are displaying the data for.
Branch This field displays the branch we are displaying the data for.
GLNumber This field display a General Ledger account number.
JanuaryActivity This field displays January’s General Ledger Activity for the given branch, GL account, department, and fiscal year.
JanuaryBudget This field displays January’s Budget Amount for the given branch, GL account, department, and fiscal year.
JanuaryPriorActivity This field displays January’sPrior year General Ledger Activity for the given branch, GL account, department, and fiscal year.
JulyActivity This field displays July’s General Ledger Activity for the given branch, GL account, department, and fiscal year.
JulyBudget This field displays July’s Budget Amount for the given branch, GL account, department, and fiscal year.
JulyPriorActivity This field displays July’s Prior year General Ledger Activity for the given branch, GL account, department, and fiscal year.
JuneActivity This field displays June’s General Ledger Activity for the given branch, GL account, department, and fiscal year.
JuneBudget This field displays June’s Budget Amount for the given branch, GL account, department, and fiscal year.
JunePriorActivity This field displays June’s Prior year General Ledger Activity for the given branch, GL account, department, and fiscal year.
MarchActivity This field displays March’s General Ledger Activity for the given branch, GL account, department, and fiscal year.
MarchBudget This field displays March’s Budget Amount for the given branch, GL account, department, and fiscal year.
MarchPriorActivity This field displays March’s Prior year General Ledger Activity for the given branch, GL account, department, and fiscal year.
MayActivity This field displays May’s General Ledger Activity for the given branch, GL account, department, and fiscal year.
MayBudget This field displays May’s Budget Amount for the given branch, GL account, department, and fiscal year.
MayPriorActivity This field displays May’s Prior year General Ledger Activity for the given branch, GL account, department, and fiscal year.
MTDActivity This field displays the Month to Date activity of a branch/GL number/Department combination for the given fiscal year.
MTDActivityPriorYear This field displays the Prior year Month to Date activity of a branch/GL number/department combination for the given fiscal year.
MTDActivityVariance This field displays the variance between MTD activity for the given fiscal year and the prior fiscal year.
MTDBudget This field displays the Month to date budget figure of a branch/GL number combination/department for the given fiscal year.
MTDBudgetVariance This field displays the variance between the MTD budget and the MTD activity of the given fiscal year.
NovemberActivity This field displays November’s General Ledger Activity for the given branch, GL account, department, and fiscal year.
NovemberBudget This field displays November’s Budget Amount for the given branch, GL account, department, and fiscal year.
NovemberPriorActivity This field displays November’s Prior year General Ledger Activity for the given branch, GL account, department, and fiscal year.
OctoberActivity This field displays October’s General Ledger Activity for the given branch, GL account, department, and fiscal year.
OctoberBudget This field displays October’s Budget Amount for the given branch, GL account, department, and fiscal year.
OctoberPriorActivity This field displays October’s Prior year General Ledger Activity for the given branch, GL account, department, and fiscal year.
SeptemberActivity This field displays September’s General Ledger Activity for the given branch, GL account, department, and fiscal year.
SeptemberBudget This field displays September’s Budget Amount for the given branch, GL account, department, and fiscal year.
SeptemberPriorActivity This field displays September’s Prior year General Ledger Activity for the given branch, GL account, department, and fiscal year.
YTDActivity This field displays the Year to Date activity of a branch/GL number/Department combination for the given fiscal year.
YTDActivityPriorYear This field displays the Prior year YTD activity of a branch/GL number/department combination for the given fiscal year.
YTDActivityVariance This field displays the variance between YTD activity for the given fiscal year and the prior fiscal year.
YTDBudget This field displays the Year to date budget figure of a branch/GL number combination/department for the given fiscal year.
YTDBudgetVariance This field displays the variance between the YTD budget and the YTD activity of the given fiscal year.