Issue by Subcontractor - Intergraph Smart Materials - Version 2020 (10.0) - Help - Hexagon

Intergraph Smart Materials Web Help (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Web
Search by Category
Help
Smart Materials/Smart Reference Data Version
2020 (10.0)

The Issue by Subcontractor report provides an overview of the material issues from site warehouses to subcontractors.

Before running this report and to ensure that up-to-date Ident Description and BOM Path details 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.

Select a project from the Project list, and a subcontractor from the Issued To list, then click Go to query the material issue data for the selected project and subcontractor.

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

SHARED Tip Click an ident code to open the Ident Information page. For more information, see Ident Information.

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.27 Issue by Subcontractor

Table

n/a

CIP

n/a (no CIP)

Log File

n/a

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.27

m_matl_issue_rpts.proj_id

Project from the MIR

Issued To

C.20.27

Company

m_matl_issue_rpts.company_id > m_companies.company_code

Tag Number

C.20.27

Tag Number

m_matl_issue_rpts.mir_id > m_inv_issues.ivi_id > m_inv_items.tag_number

Commodity Code

C.20.27

Commodity Code

m_matl_issue_rpts.mir_id > m_inv_issues.ivi_id >

m_inv_items.ident >

m_idents.commodity_id

m_commodity_codes.commodity_code

Ident Code

C.20.27

Ident Code

m_matl_issue_rpts.mir_id > m_inv_issues.ivi_id > m_inv_items.ident m_idents.ident_code

Issued Quantity

C.20.27

Issued Quantity

m_matl_issue_rpts.mir_id > m_inv_issues.issue_qty

Unit

C.20.27

Unit

m_matl_issue_rpts.mir_id > m_inv_issues.ivi_id > m_inv_items.unit_id > m_units.unit_code

Ident Description

C.20.27

Ident Short Description

Ident description is based on the Ident synchronization data

MIR Number

C.20.27

MIR Number

m_matl_issue_rpts.mir_number

Rev

C.20.27

Rev

m_matl_issue_rpts.revision_id

Warehouse

C.20.27

Warehouse

m_matl_issue_rpts.wh_id > m_warehouses.wh_code

Location

C.20.27

Location

m_matl_issue_rpts.loc_id > m_locations.loc_code

Issue Type

C.20.27

Issue Type

m_matl_issue_rpts.mir_type

Issue Date

C.20.27

Issue Date

m_matl_issue_rpts.issue_date

Issued By

C.20.27

Issue By

m_matl_issue_rpts.issue_by

BOM Path

C.20.22.0x

BOM Path

m_matl_issue_rpts.mir_id > m_inv_issues.lp_id > bir_spmat_bomdata.list_node

BOM path is based on the Bill of Materials synchronization data

List Node

C.20.22.0x

List Node

m_matl_issue_rpts.mir_id > m_inv_issues.lp_id >

bir_spmat_bomdata

List Pos Quantity

C.20.22.0x

List Pos Quantity

m_matl_issue_rpts.mir_id > m_inv_issues.lp_id >

m_list_pos.quantity

Size 1

C.20.27

Size 1

m_matl_issue_rpts.mir_id > m_inv_issues.ivi_id > m_inv_items.ident > m_idents.input_1

Size 2

C.20.27

Size 2

m_matl_issue_rpts.mir_id > m_inv_issues.ivi_id > m_inv_items.ident > m_idents.input_2

Size 3

C.20.27

Size 3

m_matl_issue_rpts.mir_id > m_inv_issues.ivi_id > m_inv_items.ident > m_idents.input_3

Size 4

C.20.27

Size 4

m_matl_issue_rpts.mir_id > m_inv_issues.ivi_id > m_inv_items.ident > m_idents.input_4

Size 5

C.20.27

Size 5

m_matl_issue_rpts.mir_id > m_inv_issues.ivi_id > m_inv_items.ident > m_idents.input_5