General Ledger measures

Measure name Table name Source field
Begin Balance GLCONSOL DB_BEG_BAL, CR_BEG_BAL
Budget Amount Var Pct FBDETAIL,GLAMOUNTS (GL Budget Amount - GL Actual Amount) / GL Budget Amount
Budget Amount Var YTD FBDETAIL,GLAMOUNTS GL Budget Amount YTD-GL Actual Amount YTD
Budget Amount Var YTD Pct FBDETAIL,GLAMOUNTS (GL Budget Amount YTD-GL Actual Amount YTD)/GL Budget Amount YTD
Budget Units Var FBDETAIL,GLUNITS GL Budget Units-GL Actual Units
Budget Units Var Pct FBDETAIL,GLUNITS (GL Budget Units-GL Actual Units)/GL Budget Units
Budget Units Var YTD FBDETAIL,GLUNITS GL Budget Units YTD-GL Actual Units YTD
Budget Units Var YTD Pct FBDETAIL,GLUNITS (GL Budget Units YTD-GL Actual Units YTD)/GL Budget Units YTD
Entered UOM REQLINE ENTERED_UOM
Entered UOM Multiplier REQLINE ENT_UOM_MULT
GL Activity CUAMOUNT DB_AMOUNT_01 TO 13, CR_AMOUNT_01 TO 13
GL Actual Amount YTD GLAMOUNTS DB_AMOUNT_01, CR_AMOUNT_01, DB_AMOUNT_02, CR_AMOUNT_02, DB_AMOUNT_03, CR_AMOUNT_03, DB_AMOUNT_04, CR_AMOUNT_04
GL Actual Units GLUNITS DB_UNITS_1 TO 13,CR_UNITS_1 TO 13
GL Acutal Amount GLAMOUNTS DB_AMOUNT_03,CR_AMOUNT_03
GL Acutal Units YTD GLUNITS DB_UNITS_1 TO 13,CR_UNITS_1 TO 13
GL Base Activity CUAMOUNT BASE_DB_AMT_01 TO 13, BASE_CR_AMT_01 TO 13
GL Base Amount GLTRANS BASE_AMOUNT
GL Base Ending Balance CUAMOUNT BASE_DB_BBAL, BASE_CR_BBAL, BASE_DB_AMT_01 TO 13, BASE_CR_AMT_01 TO 13
GL Begin Amount GLAMOUNTS DB_BEG_BAL, CR_BEG_BAL, DB_AMOUNT_01, CR_AMOUNT_01, DB_AMOUNT_02, CR_AMOUNT_02
GL Begin Units GLUNITS DB_UNITS_1 TO 13,CR_UNITS_1 TO 13
GL Beginning Balance CUAMOUNT DB_BEG_BAL, CR_BEG_BAL, DB_AMOUNT_01 TO 13, CR_AMOUNT_01 TO 13
GL Beginning Balance Amount FBDETAIL DB_BEG_BAL,CR_BEG_BAL
GL Beginning Balance Factor FBDETAIL BEG_BAL_FACTOR
GL Beginning Balance Rate FBDETAIL BEG_BAL_RATE
GL Beginning Balance Units FBDETAIL DB_BEG_BAL_UNT, CR_BEG_BAL_UNT
GL Budget Amount FBDETAIL DB_AMOUNT_1 TO 13,CR_AMOUNT_1 TO 13
GL Budget Amount YTD FBDETAIL DB_AMOUNT_1 TO 13,CR_AMOUNT_1 TO 13
GL Budget Units FBDETAIL DB_UNITS_1 TO 13,CR_UNITS_1 TO 13
GL Budget Units YTD FBDETAIL DB_UNITS_1 TO 13,CR_UNITS_1 TO 13
GL End Amount GLAMOUNTS DB_BEG_BAL, CR_BEG_BAL, DB_AMOUNT_01, CR_AMOUNT_01, DB_AMOUNT_02, CR_AMOUNT_02, DB_AMOUNT_03, CR_AMOUNT_03
GL End Units GLUNITS DB_UNITS_1 TO 13,CR_UNITS_1 TO 13
GL Ending Balance CUAMOUNT DB_BEG_BAL, CR_BEG_BAL, DB_AMOUNT_01 TO 13, CR_AMOUNT_01 TO 13
GL Factor FBDETAIL FACTOR_01 TO 13
GL Rate FBDETAIL FACTOR_RATE_01 TO 13
GL Tran Amount GLTRANS TRAN_AMOUNT
GL Units Amount GLTRANS UNITS_AMOUNT
Period Amount GLCONSOL DB_AMOUNT_01, CR_AMOUNT_01
Return Cancel Quantity PORETURNLN ADJUSTMENT_QTY
Year to Date Amount GLCONSOL DB_BEG_BAL, CR_BEG_BAL, DB_AMOUNT_01, CR_AMOUNT_01