CT_CORE_AR_EXP_IN_ITM_BUD_FUND
Purpose of Query
Open Items budgeted Funds - This will identify by Business Unit any Refund of Expenditure Open Items in Budgeted Funds. Agencies need to be aware that if they are closing out a Refund of Expenditure Item in a Budgeted Fund, they must manually re-bill it in the next fiscal year with prior year coding (Account 44410/SID 18010).
Folder
AR
Tables
A.CTW_POSTED_ITM - Posted Item Transaction Rpt
Join B.CTW_BI_ACCTENTR - Bill Account Entry Rpt
Note: A JOIN is an SQL command that is used to relate two or more data tables (Records in PeopleSoft) based on the use of related (key) fields from one table to the next. Once joined, data can be retrieved without repeating all of the data in every table.
Prompts
BUSINESS_UNIT - Unit Business Unit like (%) Wildcard enabled
ACCOUNTING_DT - Acctg Date >= please enter a date greater than or equal to 7-01 of the current fiscal year
Sample Results
Please note, due to page size limitations, sample results may be incomplete.
Criteria
Note: Runtime prompts are included as criteria.
ITEM_STATUS - Item Status = O (Open)
ACCT_ENTRY_TYPE - Account Entry Type = RR
FUND_CODE - Fund Code in list ('11000','12001','12003','12004','12006','12007','12009','12010','12013','12014')
ACCOUNT – Account like 5%
CLASS_FLD - Class Field not equal to 12037
Fields
Col / Record.Fieldname / Format / Ord / XLAT / Agg / Heading Text /1 / A.BUSINESS_UNIT - Business Unit / Char5 / Unit
2 / A.CUST_ID - Customer ID / Char15 / Customer
3 / A.NAME1 - Name 1 / Char50 / Name
4 / A.ITEM - Item ID / Char30 / Item ID
5 / A.ITEM_LINE - Item Line / Num6.0 / Line
6 / A.ITEM_STATUS - Item Status / Char1 / N / Status
7 / A.ACCOUNTING_DT - Accounting Date / Date / Acctg Date
8 / A.BUDGET_DT - Budget Date / Date / Budg Dt
9 / A.BAL_AMT - Customer Balance / SNm25.3 / Balance
10 / A.ORIG_ITEM_AMT - Original Item Amount / SNm25.3 / Orig Item Amt