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