Asset Physical Inventory Report (AMR020)
-
Print
-
DarkLight
-
PDF
Asset Physical Inventory Report (AMR020)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
This detail report includes asset physical information with key chart of accounts fields for analyses by targeted areas or the entire agency. This on-demand report is intended to support agency users with physical inventory activities.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Report Navigation
Coming Soon!
Report Audience
- Florida PALM Subject Matter Experts (SME’s)
- Reporting Team
- Key enterprise partners
Suggested Report Frequency
- Ad Hoc
Business Process Models
This report can be found in the following business processes:
Report Prompts
The report data can be filtered by the following report prompts:
Parameter Name | Default Value | Column in Subject Area | Required (Y/N) | User Input |
|---|---|---|---|---|
Business Unit | N | W_GL_ACCOUNT.COMPANY_CODE | Y | Y |
Physical Inventory ID & Name | N | WC_ASSET_SUP_D.X_PI_ID || ‘ – ‘ || WC_ASSET_SUP_D.X_NAME | Y | Y |
Asset Location | N | W_ASSET_LOCATION_D.CONCATENATED_SEGMENT_VALUE | N | Y |
Custodian Name | N | W_FIXED_ASSET_D.X_CUSTODIAN | N | Y |
Organization | N | W_GL_ACCOUNT.COST_CENTER_NUM | N | Y |
Report Columns
The layout of the report is listed below.
Column Name | Column in Subject Area or TableName.ColumnName |
|---|---|
Business Unit | |
Organization | |
Asset ID | |
Asset Description | W_FIXED_ASSET_D_TL.ASSET_DESCR |
Tag Number | W_FIXED_ASSET_D.TAG_NUMBER |
Asset Category Description | W_FIXED_ASSET_D_TL.CATEGORY_DESCR |
Asset Status | W_FIXED_ASSET_D.XLATSHORTNAME |
Asset Condition | W_FIXED_ASSET_D.X_ASSET_CRITICALITY |
Asset Location | |
Area ID | W_ASSET_LOCATION_D.AREA_ID |
Manufacturer | |
Serial ID | W_FIXED_ASSET_D.SERIAL_NUMBER |
Model | W_FIXED_ASSET_D.MODEL |
Assigned Employee Name | W_FIXED_ASSET_D.X_FULL_NAME |
Agency 1 | W_FIXED_ASSET_D.X_VALUE_AGN1 |
Agency 2 | W_FIXED_ASSET_D.X_VALUE_AGN2 |
Physical Inventory ID | |
Last Inventory Date | WC_ASSET_SUP_D.X_INVENTORY_DT |
Last Scan Date | WC_ASSET_SUP_D.X_LAST_SCAN_DT |
Match Status | WC_ASSET_SUP_D.X_MATCH_STATUS |
Custodian Name | |
Delivered Date | WC_ASSET_SUP_D.X_DELIVERED_DT |
Acquisition Cost | WC_FA_ACQ_F.X_ORIGINAL_COST |
Data
More information about the data fields, including business definition and key values, is included as part of the Interface Catalog and applicable interface file layouts.
More information about the data values is included here: Configured Data Values.
More information about the ChartFields and related values is included in the Chart of Accounts Design.
Version History
Date | Revision Description |
|---|---|
01/31/2025 | Original Version |
Was this article helpful?
