PA Expenditure Types

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Listing of project expenditure types with their category, type class, unit of measure, and active dates.
select
pet.expenditure_type,
pet.description,
pet.expenditure_category,
(select psl.meaning from pa_system_linkages psl where psl.function=pet.system_linkage_function) expenditure_type_class,
pet.system_linkage_function,
pet.revenue_category_code,
pet.unit_of_measure,
xxen_util.meaning(pet.cost_rate_flag,'YES_NO',0) cost_rate,
pet.start_date_active,
pet.end_date_active,
xxen_util.user_name(pet.created_by) created_by,
pet.creation_date,
xxen_util.user_name(pet.last_updated_by) last_updated_by,
pet.last_update_date
from
pa_expenditure_types pet
where
1=1
order by
pet.expenditure_type
Parameter NameSQL textValidation
Expenditure Category
pet.expenditure_category=:expenditure_category
LOV
Expenditure Type Class
pet.system_linkage_function=:expenditure_type_class
LOV
Download
Related Blitz Reports
PA Project Subledger: Detail by Project PA Project Expenditure Items with WIP and INV Detail PA Project Subledger: Detail by Expenditure Type PA Project Subledger Summary PA Transaction Sources PA AUD: Expenditure Batch Status SSS AR IC to PA Transaction Upload TB GL Account Analysis (Drilldown)v2 ECC Procurement, Purchase Orders
Blitz Report™