Query Name M_AM_GBL_ASSET_STATUS_A Description List of assets with a Status of not in Service). “A”, (Received Uses This Status should only be applied to assets that are recently received and awaiting payment. If an asset record has not been updated to “In an appropriate period of time, Asset Managers need to Service” after review the records for issues. Refer to the (Not in “Resolving “Received topic in the for instructions. Service)” Prompts Prompt for Business Unit. Fields Many fields in this query can be found on the Basic Add page tabs (Refer to topic. ” General Info tab: Business Unit, Asset ID, Tag Number, Description, Short Description, Asset Status, Acq Date (Acquisition Date). Book page Link on General Info tab In Service Date Asset Acquisition Detail tab System Source, all Purchase Order, Receipt, and Vendor fields, Amount, Quantity and ChartFields. Notes Results only include assets with Status of (Not in Service). “Received M_AM_GENUSER_INFO_CAFR_NULL. Query Name M_AM_GENUSER_INFO_CAFR_NULL Description List of assets with Asset Status that do not have a complete “In Service” cost record. Assets not included in CAFR. Uses Identify assets with incomplete cost records. All assets in SWIFT should have cost records. When cost records are missing, the asset should be reviewed to determine the reason for the missing records. Refer to the (Not in topic for assistance. “Resolving “Received Service)” Prompts Prompt for Business Unit.
Query Name M_AM_GBL_ASSET_STATUS_A Description List of assets with a Status of “A”, (Received not in Service). Uses This Status should only be applied to assets that are recently received and awaiting payment. If an asset record has not been updated to “In Service” after an appropriate period of time, Asset Managers need to review the records for issues. Refer to the “Resolving “Received (Not in Service)” topic in the for instructions. Prompts Prompt for Business Unit. Fields Many fields in this query can be found on the Basic Add page tabs (Refer to ” topic. General Info tab: Business Unit, Asset ID, Tag Number, Description, Short Description, Asset Status, Acq Date (Acquisition Date). Book page Link on General Info tab In Service Date Asset Acquisition Detail tab System Source, all Purchase Order, Receipt, and Vendor fields, Amount, Quantity and ChartFields. Notes Results only include assets with Status of “Received (Not in Service). M_AM_GENUSER_INFO_CAFR_NULL. Query Name M_AM_GENUSER_INFO_CAFR_NULL Description List of assets with Asset Status “In Service” that do not have a complete cost record. Assets not included in CAFR. Uses Identify assets with incomplete cost records. All assets in SWIFT should have cost records. When cost records are missing, the asset should be reviewed to determine the reason for the missing records. Refer to the “Resolving “Received (Not in Service)” topic for assistance. Prompts Prompt for Business Unit.
swift-am-swift-queries-qrg.docx