With this report, you can check the usage of commodity codes within a project.
Before you run this report, you must execute a database job that prepares the data for the report. It is recommended to run this job at least once a day. For more details see Manage Synchronization Jobs.
-
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).
The number of idents available for this commodity code is shown in the Idents column. Click this value to open the Idents report, where the idents appear. For more information, see Idents (Full Listing).
The number of specification items available for this commodity code is shown in the Specs column. Click this value to open the Specification Management report. For more information, see Specification Management.
The table below shows the Smart Reference Data 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 |
S.30.01 Commodity Codes S.80.01 Ident Management (-> number of idents) S.50.06 Specification Management (-> number of specification items) |
Table |
P20_IR_DATA |
CIP |
n/a (no CIP) |
Log File |
sync_p20_ir_data_......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 |
S.30.01 |
m_commodity_codes.proj_id |
||
Discipline |
S.30.01 |
m_commodity_codes.dp_id (m_disciplines.dp_code) |
||
Group Code |
S.30.01 |
Group |
m_commodity_groups.cg_group_code |
|
Part Code |
S.30.01 |
Part |
m_parts.part_code |
|
Commodity Code |
S.30.01 |
Commodity Code |
m_commodity_codes.commodity_code |
|
Short Description |
S.30.01 |
Short Desc |
m_commodity_code_nls.short_desc |
|
Description |
S.30.01 |
Description |
m_commodity_code_nls.description |
|
Idents |
S.30.06 |
Number of existing idents |
m_pck_std.count_existing_idents |
|
Specs |
BIR_P20.get_spec_count_for_cc |