This report is only available if Mobile Scan is installed.
You can use this report to display the key performance indicators which were written into the m_kpi_event table by Smart Materials Mobile Scan. All events for material receiving reports, material transfer reports, physical inventory counts, and material issue reports are tracked in this event table.
-
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).
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 |
Mobile Scan |
Table |
|
CIP |
|
Log File |
|
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 |
Mobile Scan |
Project |
m_kpi_event.proj_id |
Project from Mobile Scan |
Document Type |
Mobile Scan |
n/a |
m_kpi_event.pk_type |
The source type of Mobile Scan (can be MRR, MTR, MTRO, MTRI, OITO, OITI, PickItem, MIR, PICS) |
Document Number |
Mobile Scan |
n/a |
Fetched from the corresponding source table based on m_kpi_event.pk_type and m_kpi_event.pk_id |
The corresponding document number based on the document type, For example, MRR number if the type is MRR. |
Origin Document Type |
Mobile Scan |
n/a |
m_kpi_event.sub_pk_type |
Can be either IIS_ID, POH_ID, RELN_ID, ITEM_SHIP_ID, or PIC_ID |
Origin Document Number |
Mobile Scan |
n/a |
Fetched from the corresponding source table based on m_kpi_event.sub_pk_type and m_kpi_event.sub_pk_id |
The corresponding document number based on the document type, For example, Agreement number if the type is POH_ID. NULL for ITEM_SHIP_ID and PIC_ID as they do not have a straight forward number. |
Origin |
Mobile Scan |
n/a |
Can represent the details from the Origin based on the Origin Document Type:
|
|
Event |
Mobile Scan |
n/a |
m_kpi_event.event |
The action performed by Mobile Scan |
Action |
Mobile Scan |
n/a |
m_kpi_event.text |
Additional details about the event |
Scan Date |
Mobile Scan |
n/a |
m_kpi_event.date_reported |
The date the item was scanned by Mobile Scan |