M_CG_GBL_CATEGORIES_ASSETS. Query Name M_CG_GBL_CATEGORIES_ASSETS Description List of current Purchasing Category Codes which are associated with Asset Profile ID’s. Uses Identify Purchasing Category Codes that are linked to an Asset Profile ID. When these Purchase Category Codes are entered for a Purchase Order (PO) Line item, a default Asset Profile ID is automatically entered for the Line. When a Profile ID is entered, an asset will be created in the Asset Management module from the Receipt and Voucher records. Prompts This query does not have any prompts and will generate the complete list when run. Fields SetID (Share); Category Code (Purchasing), Asset Profile, Descript (Purchasing Category Description). Queries to Run Regularly to Manage your Assets M_AM_GENERAL_INF0 Query Name M_AM_GENERAL_INFO Description List of assets with summary (total) cost, summary (total) quantity, and Location. (To view detailed asset information, view the M_AM_GENUSER_INFO query.) Uses For assets with Status use the fields listed below to identify issues: “In Service”, Cost: Review assets with small costs and verify that they should be assets. Quantity: Normally, the asset Quantity should be any other Quantity. “1”. Verify Tag Numbers: If your agency requires Tag Numbers, review for missing Tag Numbers. Location: Review for invalid Locations. Profile Profile should relate to the cost of the asset. You can select ID’s: ID’s each Profile ID (or Group of Profile and review the associated costs to find ID’s) any anomalies. If you find issues, you will need to verify that the Asset Type, Category, Profile ID and Useful Life are correct for the asset. Refer to the “” topic for assistance. Blank Profile All assets should have a Profile ID. When using the Wildcard ID’s: (%) for the Profile ID, assets with blank Profile will be included in the list ID’s and will need to be verified. Please enter missing Profile ID’s. Prompts Business Unit, Profile ID or Wildcard (%), Asset Status or Wildcard (%).
M_CG_GBL_CATEGORIES_ASSETS. Query Name M_CG_GBL_CATEGORIES_ASSETS Description List of current Purchasing Category Codes which are associated with Asset Profile ID’s. Uses Identify Purchasing Category Codes that are linked to an Asset Profile ID. When these Purchase Category Codes are entered for a Purchase Order (PO) Line item, a default Asset Profile ID is automatically entered for the Line. When a Profile ID is entered, an asset will be created in the Asset Management module from the Receipt and Voucher records. Prompts This query does not have any prompts and will generate the complete list when run. Fields SetID (Share); Category Code (Purchasing), Asset Profile, Descript (Purchasing Category Description). Queries to Run Regularly to Manage your Assets M_AM_GENERAL_INF0 Query Name M_AM_GENERAL_INFO Description List of assets with summary (total) cost, summary (total) quantity, and Location. (To view detailed asset information, view the M_AM_GENUSER_INFO query.) Uses For assets with Status “In Service”, use the fields listed below to identify issues: Cost: Review assets with small costs and verify that they should be assets. Quantity: Normally, the asset Quantity should be “1”. Verify any other Quantity. Tag Numbers: If your agency requires Tag Numbers, review for missing Tag Numbers. Location: Review for invalid Locations. Profile ID’s: Profile ID’s should relate to the cost of the asset. You can select each Profile ID (or Group of Profile ID’s) and review the associated costs to find any anomalies. If you find issues, you will need to verify that the Asset Type, Category, Profile ID and Useful Life are correct for the asset. Refer to the “” topic for assistance. Blank Profile ID’s: All assets should have a Profile ID. When using the Wildcard (%) for the Profile ID, assets with blank Profile ID’s will be included in the list and will need to be verified. Please enter missing Profile ID’s. Prompts Business Unit, Profile ID or Wildcard (%), Asset Status or Wildcard (%).
swift-am-swift-queries-qrg.docx