PowerSchool ERP Purchasing

Security Reference Tables

This section summarizes the Security reference tables associated with procedures in Vendor Bidding: Location Codes and Resources.

Menu Path:  System Administration > All > Security > select an option

Security Tables Used in Vendor Bidding

Following is a synopsis of the tables used in Vendor Bidding that can be accessed from the Security menu:

Location Codes Table

This table defines the locations where requests can be entered. Its codes are assigned to users' security records. The system only allows users to access items for their assigned locations.

You may not need to add locations to accommodate Vendor Bidding, since the table should already identify your primary locations. However, if a building or site is not included in the table and you want to use it as a location for entering requests, you must create a record to identify it, and then assign it to users.

The locations in the Location Codes table may not be the same as those used for delivering the commodities ordered through Vendor Bidding process. These shipping locations are defined in Purchasing's Shipping Codes table.

To tie the types of locations together, Vendor Bidding provides a separate table. For details, refer to Default Location Crosswalk Table.

Resources Table

This table defines the resource codes that enable users to enter requests, run certain reports, close and purge bids, and access periodic processing options for converting requisitions to bids and bids to purchase orders. The codes that apply to these procedures are already defined in the Resources table. However, they must be assigned to Vendor Bidding users in Security's User Resource Access option.