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