Inventory List - Intergraph Smart Materials - 10.2 - Help - Hexagon

Intergraph Smart Materials Web Help (10.2)

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

With this report, you can check the availability of material in your inventory.

Before running this report and to ensure up-to-date Ident Description and inventory data are viewed, you must run database jobs (assigned to the Idents (Full Listing) and Inventory List reports) that prepare the data for this report. We recommend that you run these jobs at least once a day. For more details see Manage Synchronization Jobs.

  • 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

C.20.14 Inventory by Ident

Table

P282_IR_DATA

CIP

n/a (no CIP)

Log File

sync_p282_ir_......log

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

C.20.14

m_inv_items.proj_id

all projects accessible for the login user

Tag Number

C.20.14

Tag Number

m_inv_items.tag_number

Ident Code

C.20.14

Ident Code

m_inv_items.ident > m_idents.ident_code

Ident Description

C.20.14

Ident Short Description

m_pck_std_custom.ident_desc

Commodity Code

C.20.14

Commodity Code

m_inv_items.ident > m_idents.commodity_id > m_commodity_codes.commodity_code

On-Hand Quantity

C.20.14

On Hand Qty

On Hand Quantity = (MRR Recv + Transfers + Phys. Count + Over Issue + Design Change + Subs./ Trans + Return Quantity) – (Reserved Quantity + Issued Quantity)

Unit

C.20.14

Unit

m_inv_items.unit_id > m_units.unit_code

Warehouse

C.20.14

Warehouse

m_inv_items.wh_id > m_warehouses.wh_code

Location

C.20.14

Location

m_inv_items.loc_id > m_locations.loc_code

Receipt Status

C.20.14

Recv Status

m_inv_items.smst_id > m_site_matl_status.smst_code

Reserved Quantity

C.20.14

Reserved Quantity

m_inv_items.resv_qty

Issued Quantity

C.20.14

Issued Quantity

m_inv_items.issue_qty

Release Note Number

C.20.04

Release Note Number

m_matl_recv_rpts.reln_id > m_release_notes.reln_number

Comma separated list of assigned release notes

Agreement Number

C.20.01

Order Number

m_matl_recv_rpts.poh_id > m_po_headers.po_number

Comma separated list of assigned agreements

Supplier

P.50.07

Supplier

m_matl_recv_rpts.poh_id > m_po_headers.sup_id > m_suppliers.sup_code

MTR Number

C.20.15

MTR Number

m_matl_transfer_rpts.mtr_number

Comma separated list of MTR numbers by which the inventory items have been transfered (received)

Heat Number

C.20.14

Heat Number

m_inv_items.heat_id > m_heats.heat_number

Certificate Number

C.10.04

Certificate Number

m_inv_items.heat_id > m_heats.certificate_number

MRR Number

C.20.0x

MRR Number

m_matl_recv_rpts.mrr_number

Comma separated list of all MRR numbers by which the inventory items have been received

Last Modified

m_inv_items.lmod

The date when the inventory item was last modified.

Days Since Last Modification

sysdate - m_inv_items.lmod

The difference in days between last modification and today.

Size 1

C.20.14

Size 1

m_inv_items.ident > m_idents.input_1

Size 2

C.20.14

Size 2

m_inv_items.ident > m_idents.input_2

Size 3

C.20.14

Size 3

m_inv_items.ident > m_idents.input_3

Size 4

C.20.14

Size 4

m_inv_items.ident > m_idents.input_4

Size 5

C.20.14

Size 5

m_inv_items.ident > m_idents.input_5

Inventory Locations

Mobile Scan

A pin is displayed when Mobile Scan data is available to locate the inventory locations of the item. Click the pin to open the Inventory Locations report (see Inventory Locations).