Inventory Locations - Intergraph Smart Materials - Version 10.1 - Help - Hexagon

Intergraph Smart Materials Web Help (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Web
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.1

You can use this report to display the inventory locations of items that were scanned by Mobile Scan and posted. This report can be launched from the Site dashboard, to display all available inventory items. Alternatively, launch the report from the Inventory List report by clicking the pin in the Inventory Locations cell. In this case, only the inventory locations for the selected inventory item are displayed.

Click the pin in the View On Map cell to open a map service provider page where the inventory locations of the selected item are displayed.

Because the report fetches the ident description from the ident data in BIR, the ident data needs to be synchronized before running this report.

  • This is an interactive report.

  • Click SearchColumn and select the column where you want to search, type the search criterion in the Search box, and click Go to apply the search.

  • To change the number of displayed rows, select a value from the Rows list.

Additionally, you can customize the report to meet your requirements, save the report, and download the result in csv or html format (see Use Actions menu).

Data Sources

The table below shows the Smart Materials screen(s) where the data is entered that is displayed in this report. Additionally, this table shows the synchronization table and the CIPs used by the report, and the name of the log file created by the sync job or the report.

Screen

Mobile Scan

Table

CIP

m_pck_bir_custom.get_maps_url

Log File

The following table shows all values displayed in the report, with the related Smart Materials screen and field where the value is displayed, the database table and column where the value is stored, and CIPs, functions, or procedures that are used to retrieve the value. Optionally, additional comment on the value is entered in the last column.

Value

Screen

Field

Database Column

Other Source/Comment

Project

Mobile Scan

Project

m_gps.proj_id

Project from Mobile Scan

Ident Code

Mobile Scan

Ident Code

m_gps.ident -> m_idents.ident_code

Ident Code of the inventory item recorded by Mobile Scan

Quantity

Mobile Scan

Quantity

m_gps.quantity

The recorded quantity in Mobile Scan

Quantity Unit

Mobile Scan

Quantity Unit

m_gps.ident -> m_inv_items.unit_id -> m_units.unit_code

The unit code from the Inventory Item

Ident Description

m_pck_std_custom.ident_desc

The Ident’s description from the synchronized Ident data in Smart Materials Web

Document Type

Mobile Scan

m_gps.report_source_type

The source type of Mobile Scan (can be MRR, MTR, MTRO, MTRI, OITO, OITI, PickItem, MIR, PICS)

Document Number

Mobile Scan

The corresponding number based on the document type, For example, MRR number if the type is MRR.

Receipt Status

Mobile Scan

The site material receipt status (status fetched form the corresponding document type)

View On Map

Map service provider URL returned from the CIP function m_pck_bir_custom.get_gps_url().

By default, the CIP returns the Google Maps page URL, followed by the GPS coordinates of the selected inventory item.

Warehouse

Mobile Scan

Warehouse

m_gps.ident -> m_inv_items.wh_id -> m_warehouses.wh_code

Warehouse of the inventory item

Location

Mobile Scan

Location

m_gps.ident -> m_inv_items.loc_id -> m_locations.loc_code

Location of the inventory item

Date Reported

Mobile Scan

m_gps.date_reported

The date reported by Mobile Scan