Updated UCD Receivables Aging Detail Report

This is an updated version of the existing UCD Receivables Aging Detail Report.

In addition to the information available from the original report, the new version will include the following changes:

• Rename report header name to UCD Receivables Aging Detail Report
• Rename Natural Account prompt to Account
• Rename Source prompt to Transaction Source
• Reorder prompts
  • Fund before Financial Department
  • Transaction Number before Transaction Type
• Remove Aging Bucket Method - since no longer a prompt from header
• Rename Header fields
  • Entity (COA) to Entity
  • Fund (COA) to Fund
  • Department (DFF) to Financial Department
  • Natural Account (COA) to Account
  • Source to Transaction Source
  • Transaction/ Receipt Number to Transaction Number
• Rename column fields in output
  • Customer Num to Customer Account Number
  • Trx Class to Transaction Class
  • Trx/Receipt Num to Transaction Number
  • Trx/Receipt Date to Transaction Date
  • Fin to Financial
  • Program Description in duplicate over what should be Project Description
• Remove column fields in output
  • Receipt Method Name, Inter Entity, Inter Entity Description, Future 1, Future 1 Description, Future 2, and Future 2 Description
• Reorder column fields in output
  • Bill Site Code and Bill To Address after Site Number
• Add new column fields in output - samples of output expected below
  • Transaction Type after Bill To Address
  • Transaction Source after Transaction Type
• Add new PPM fields in output at the end and after Activity Description - as seen on the existing UCD Payables Report
  • PPM Project
  • Project Expenditure Org
  • Project Expenditure Type
  • Project Task
  • Project Award
  • Project Funding Source

OCF-5632