Purchasing Commodity and Service Code List

ctcLink Commodity and Service Codes

Purpose:    Provide query navigation to access the list of preloaded ctcLink PeopleSoft Commodity and Services Codes and link to review the National Institute of Governmental Purchasing (NIGP) Commodity and Service Codes.  

Audience:   Finance Purchasing Staff.

You must have at least one of these local college managed security roles:

  • ZD_DS_QUERY_VIEWER

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

Note: the QFS_PO_COMMODITY_CODES query contains both the Comm Code item number and the associated GL Account number.

Purchasing Commodity and Service Code List

Navigation: Reporting Tools > Query > Query Viewer

  1. Navigate to Query Viewer.
  2. Enter the field Search by Query Name begins with QFS_PO_COMMODITY_CODES.
  3. Select Search.
  4. Select the link Run to HTML (for a preview of the query) or Run to Excel to open in an Excel Spreadsheet.
  5. The results will display.
  6. Select the desired format to download results.

The following example uses the selection Run to HTML link. Notice there is many items available.

Image of the commodity codes query in ctcLink.

Example of a Purchase Requisition or Purchase Order Lines is listed below. DO NOT USE the Item Search hyperlink.

Requisition or Purchase Order page with the Item Search hyperlink and Item field crossed out with a circle with a line through it. The Category field is highlighted.

The Category field is a required field within the Lines section under the Details tab. The Category field will populate the Account field on the Distributions page under the Distributions section on the Chartfields tab. The Account field can be edited, if necessary.

Distributions for Schedule 1 page with the Account field highlighted within the Distribution section on the chartfields tab.
  1. Process complete.

National Institute of Governmental Purchasing (NIGP) Commodity and Service Code List

The National Institute of Governmental Purchasing (NIGP) Commodity and Service Codes are a 5 digit code in PeopleSoft. Specific codes have been preloaded for end users to search and utilize as needed for purchasing acquisition, tracking and monitoring.

The link below provides access to a pdf list to the National Institute of Governmental Purchasing (NIGP) Commodity/Services Codes. Some of the document formatting may be lost in the preview mode. To view document in its entirety, select the download icon (down arrow with a line underneath) on the right side of the document to download and/or edit the processing guide.

National Institute of Governmental Purchasing Commodity/Services Code List

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.