HUBDTAIL: HUB Purchasing Detail Report

Report Series Name
C-U-PS-Hub-Rpt

Report Name
Hub Purchasing Detail Report

Library
Source code is located in PSPUBLIC

Use
This report series is used to report the Historically Underutilized Business (HUB) statistics each quarter that are required by law. The purchasing manager should generate this report more frequently to monitor the volume of purchases from HUB vendors. HUB vendors include female-owned businesses, minority-owned businesses, handicapped-owned businesses, disabled business enterprises, and the non-profit work centers for the blind and severely disabled.

Content
This report is a detail listing of purchases used to support the Quarterly Historically Underutilized Business Purchasing Report (HUB Summary Report) which is also run as a part of this report series.

Totals
This report gives totals for HUB category, purchase type(contract, purchases and services) and report total.

Column Headings

  • ENTITY - buying entity
  • PO NUMBER- purchase order number
  • BLKT # - a unique number that identifies a release against a blanket purchase order.
  • LINE # - purchase order line number, identifies a particular line on a purchase order. This number is unique within each purchase order.
  • PO DATE - Purchase Order date
  • BUYER -buyer ID code. This code is unique within a buying entity.
  • VENDOR NUMBER - the NCAS vendor number (Tax Identification Number)
  • DESCRIPTION OF GOODS OR SERVICES -description of the item ordered.
  • QUANTITY- quantity ordered measured in the ordered items unit of purchase.
  • UNIT PRICE - price of each unit of purchase for the ordered item.
  • FREIGHT - amount of additional cost incurred for this PO line.
  • TAX- the amount of tax pro-rated to the PO line.
  • EXTENDED VALUE - quantity times price plus additional cost and tax.

Run Statements
The run statement member name is C-U-PS-Hub-Rpt-Run

000010 Option Library(Pspublic)
000020 Run C-U-Ps-Hub-Rpt
000100 Into Library Xxxxxxxx
000200 Variable Report-From-Date
000300 '07/01/95'
000400 Variable Report-To-Date
000500 '09/30/95'
000600 Select Pur-Po-Buying-Entity
000700 ('14BE' '14PS')

Type over the displayed variable values with your agency’s values.