Ident Information - 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

You can view detailed information about the status of an ident on the Ident Information page.

Select one or more project(s) to restrict the result accordingly.

SHARED Tip To select multiple values, press and hold CTRL while selecting values from the list.

Enter the ident code you are looking for in the Ident Code field, and click Go to display the information for that ident.

In the Filter box, you can see the ident code with its description and the associated commodity code.

Information by Ident

The first report shows the ident quantity information by project.

  • 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).

You can click any quantity to open a detail page. Click Back on the detail page to return to the Ident Information page.

Click a BOM Total quantity to view the associated BOM positions.

Click a Req Total quantity to view the associated requisition line items.

Click an Order Total quantity to view the associated agreement (purchase order) line items.

Click a Received Total quantity to view the associated inventory receipts (MRRs).

Click a Reserved Total quantity to view the associated BOM positions for the reserved quantity.

Inventory by Ident

The second report displays the inventory information for the selected ident.

Click a Received Total value to view the latest revision of the associated material receipts (MRRs). Click Back on the detail page to return to the Ident Information page.

  • 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).

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.40.01 Information by Commodity

Table

BIR_SPMAT_IDENTDATA

CIP

m_sys.m_pck_std_custom

m_pck_bir_custom.get_bir_converted_value

Log File

BIR_IDENT_SYNC_......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.40.01

Ident Code

C.40.01

Ident Code

m_idents.ident_code

Description

C.40.01

Ident Short Description

m_pck_std_custom.ident_desc

Commodity Code

C.40.01

Commodity Code

m_idents.ident (-> m_commodity_codes.commodity_code)

(Information by Ident)

Project

C.40.01

BOM Total

C.40.01

BOM Total

Req Total

C.40.01

Req Total

Order Total

C.40.01

Order Total

Received Total

C.40.01

Received Total

Reserved Total

C.40.01

Reserved Total

Provisional Reserved

C.40.01

Provisional Reserved

Onhand Qty

C.40.01

On Hand Qty

Unit Code

C.40.01

(Inventory)

Project

C.20.14

Project

m_inv_items.proj_id

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)

Status

C.20.14

Recv Status

m_inv_items.smst_id (-> m_site_matl_status.smst_code)

Received Total

C.20.14

Stock Receipt

total(m_inv_items.recv_qty)

Onhand Qty

C.20.14

On Hand Quantity

Reserved Total

C.20.14

Reserved Quantity

total(m_inv_items.resv_qty)

Issued Quantity

C.20.14

Issued Quantity

total(m_inv_items.issue_qty)