Outbound Asset Physical Inventory CSV File Extract (AMI004)
  • 12 Jul 2024
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Outbound Asset Physical Inventory CSV File Extract (AMI004)

  • Dark
    Light
  • PDF

Article summary

Interface Description

The Florida PALM Physical Inventory process extracts the Asset data into a sequential file from the database. This file is generated and saved for the agency to perform the physical inventory. The physical inventory results are then loaded into Florida PALM. The physical inventory results are reviewed and verified to generate results that compare the inventoried data to asset data within Florida PALM. Based on the Inventory result, assets are added, retired, transferred, updated, etc. in Florida PALM.

This outbound interface extracts only Asset Physical Inventory details such as Asset IDs, tag numbers, serial numbers, manufacturers, models, descriptions, departments, locations, etc., required to perform the actual Physical Inventory of assets. The AMI004 interface will extract Asset Physical Inventory details in a CSV file.

Click below to view the interface file layout and sample data file.

Business Process Model

This interface can be found in the following business processes:

Selection Criteria

The interface data selection criteria includes the following:

Data Field

Data Field Details

Physical Inventory ID (Required)

A search list of the available Physical Inventory IDs for selection.

Format (Required) 

A dropdown of the available file formats.

Export File Name (Required) 

A free text field where the file path and name of the extract are specified.

File Layout

Field names and descriptions from the interface layout are provided below. 

Data Field Name

Record Type

Data Field Description

TAG_NUMBER

Detail

The user defined tag number that has been assigned to the asset.

SERIAL_ID

Detail

Serial number of asset being recorded in Florida PALM.

ASSET_ID

Detail

Florida PALM generated Asset ID.

DEPTID

Detail

BU Organization that manages and safeguards the asset. Organization ChartField allows agencies to manage and report asset according to agency's operational/hierarchical structure.

MODEL

Detail

Model of the Asset.

LOCATION

Detail

The current location of this asset (usually BU main location or primary safe-keeping address). The value entered must be a valid Florida PALM location code.

AREA ID

Detail

Agency administered field that identifies a more specific area within the location that houses the asset.

DESCR

Detail

Long description of the asset (30-character).

CUSTODIAN

Detail

Individual Authorized to Manage and Safeguard the Asset

EMPLID

Detail

The Employee ID of the custodian responsible for this asset.

CUSTODIAN_DEPTID

Detail

Identifies the Asset Custodian Organization.

MANUFACTURER

Detail

Identifies the Manufacturer of the asset.

MATCH_STATUS

Detail

Identifies the Physical Inventory Match Status.

REVIEW_SW

Detail

Indicates if Manual Review of Asset Record is Required.

IP_ADDRESS

Detail

Indicates the Internet Protocol Address.

IP_ALIAS

Detail

Indicates the Internet Address Alias.

SOFTWARE_VERSION

Detail

This field is used for processing purpose and may not have target record.

IT_ASSET_ID

Detail

Indicates the IT Asset ID

SCAN_BUSINESS_UNIT

Detail

Used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions for AM.
Assets are recorded and updated in this Business Unit.

HAND_HELD_OPERATOR

Detail

Identifies the Hand Held Operator.

COMMENTS

Detail

The comments associated with the assets that appear on the asset record. This is a free text field (8529-character).

Version History

Date

Revision Description

03/12/2024

Original Version


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.