Queries
06/20/2008 - New Query
-
0BD027_PBCR_W_REVEST_BD_TREE
-
0BD027A_PBCR_W_REVEST_BD_TREE (without Project for Large Agencies)
How to find transactions listed from PBCR Pivot v2 042408.pdf
0BD027_PBCR_W_REVEST pivot instructions v2 042408.pdf
08/09/2002 - New Query
The List of Budget Queries now includes:
-
0BD021_DTAE_ALL_SCHOOLS
05/10/2002 - New Queries
The List of Budget Queries now includes:
-
0BD020_BDxxx045_Expense_Detail
04/12/2002 - New Queries
The List of Budget Queries now includes:
-
0BD019_ANY_TREE_NO_DESC
-
0BD019A_BCM_ORG_TREE
-
0BD019B_BCM_PROGRAM_TREE
-
0BD019C_BCM_PROJECT_TREE
-
0BD019D_RPT_ORG_TREE
-
0BD019E_RPT_PROGRAM_TREE
-
0BD019F_RPT_PROJECT
04/08/2002 - New Queries
The List of Budget Queries now includes:
-
0BD019_ANY_TREE_NO_DESC
-
Query returns nodes in tree order without descriptions. Prompts for SetID, and tree name.
-
-
0BD019A_BCM_ORG_TREE
-
Query returns nodes with descriptions for the tree named BCM_ORG. Prompts for SetID.
-
-
0BD019B_BCM_PROGRAM_TREE
-
Query returns nodes with descriptions for the tree named BCM_PROGRAM. Prompts for SetID.
-
-
0BD019C_BCM_PROJECT_TREE
-
Query returns nodes with descriptions for the tree named BCM_PROJECT. Prompts for SetID.
-
-
0BD019D_RPT_ORG_TREE
-
Query returns nodes with descriptions for the tree named RPT_ORG. Prompts for SetID.
-
-
0BD019E_RPT_PROGRAM_TREE
-
Query returns nodes with descriptions for the tree named RPT_PROGRAM Prompts for SetID.
-
-
0BD019F_RPT_PROJECT
-
Query returns nodes with descriptions for the tree named RPT_PROJECT Prompts for SetID
-
01/11/2002 - New Query
The List of Budget Queries now includes:
-
0BD016A_PO_NOTBUDCKED
01/07/2002 - New Queries
-
Query 0BD012B_ProgramExpense_PrdProg
-
Query 0BD012B_ProgramExpense_PrdProg returns expenses for a selected program for any range of periods. Each period is presented with chartfield detail.
-
-
Query 0B018_Projecttree_Comparison
-
Query 0BD018_Projecttree_Comparison returns project chartfields that are on the latest effective dated tree named BCM_PROJECT but are not on the latest effective dated tree named RPT_PROJECT.
-
-
Query 0B018A_Programtree_Comparison
-
Query 0BD018A_Programtree_Comparison returns program chartfields that are on the latest effective dated tree named BCM_PROGRAM but are not on the latest effective dated tree named RPT_PROGRAM
-
-
Query 0BD018B_ORGtree_Comparison
-
Query 0BD018B_ORGtree_Comparison returns ORG chartfields that are on the latest effective dated tree named BCM_ORG but are not on the latest effective dated tree named RPT_ORG.
-
01/04/2002 - New Queries
-
Query 0BD014A_AP_NOBCMCK
-
Query 0BD014A returns vouchers that have a header status of "Not Budget Checked" and it also includes all the lines associated with that voucher.
-
-
Query 0BD16A_PO_NOTBUDCKED
-
Query 0BD16A_PO_NOTBUDCKED identifies the dollar amount of purchase orders that have a header status of "NOT Budget Checked" and it includes all the lines associated with that purchase order.
-
12/19/2001 - New Query
Query 0BD017_EXP_CFY_PBY. It returns expenses entered in the current fiscal year but spent from the prior budget year.
11/09/2001 - New Queries
-
0BD012_ProgramExpense_YTD_Agg
-
Query 0BD012 returns expenses by program year-to-date with chart fields aggregated.
-
-
0BD012A_ProgramExpense_Period
-
Query 0B012A returns expenses by program for any range of periods. Each period is presented with chart field detail.
-