With this report, you can check the availability of material in your inventory.
Before running this report and to ensure up-to-date Ident Description and inventory data 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.
-
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 |
C.20.14 Inventory by Ident |
Table |
P282_IR_DATA |
CIP |
n/a (no CIP) |
Log File |
sync_p282_ir_......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.20.14 |
m_inv_items.proj_id |
all projects accessible for the login user |
|
Tag Number |
C.20.14 |
Tag Number |
m_inv_items.tag_number |
|
Ident Code |
C.20.14 |
Ident Code |
m_inv_items.ident > m_idents.ident_code |
|
Ident Description |
C.20.14 |
Ident Short Description |
m_pck_std_custom.ident_desc |
|
Commodity Code |
C.20.14 |
Commodity Code |
m_inv_items.ident > m_idents.commodity_id > m_commodity_codes.commodity_code |
|
On-Hand Quantity |
C.20.14 |
On Hand Qty |
On Hand Quantity = (MRR Recv + Transfers + Phys. Count + Over Issue + Design Change + Subs./ Trans + Return Quantity) – (Reserved Quantity + Issued Quantity) |
|
Unit |
C.20.14 |
Unit |
m_inv_items.unit_id > m_units.unit_code |
|
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 |
|
Receipt Status |
C.20.14 |
Recv Status |
m_inv_items.smst_id > m_site_matl_status.smst_code |
|
Reserved Quantity |
C.20.14 |
Reserved Quantity |
m_inv_items.resv_qty |
|
Issued Quantity |
C.20.14 |
Issued Quantity |
m_inv_items.issue_qty |
|
Release Note Number |
C.20.04 |
Release Note Number |
m_matl_recv_rpts.reln_id > m_release_notes.reln_number |
Comma separated list of assigned release notes |
Agreement Number |
C.20.01 |
Order Number |
m_matl_recv_rpts.poh_id > m_po_headers.po_number |
Comma separated list of assigned agreements |
Supplier |
P.50.07 |
Supplier |
m_matl_recv_rpts.poh_id > m_po_headers.sup_id > m_suppliers.sup_code |
|
MTR Number |
C.20.15 |
MTR Number |
m_matl_transfer_rpts.mtr_number |
Comma separated list of MTR numbers by which the inventory items have been transfered (received) |
Heat Number |
C.20.14 |
Heat Number |
m_inv_items.heat_id > m_heats.heat_number |
|
Certificate Number |
C.10.04 |
Certificate Number |
m_inv_items.heat_id > m_heats.certificate_number |
|
MRR Number |
C.20.0x |
MRR Number |
m_matl_recv_rpts.mrr_number |
Comma separated list of all MRR numbers by which the inventory items have been received |
Last Modified |
m_inv_items.lmod |
The date when the inventory item was last modified. |
||
Days Since Last Modification |
sysdate - m_inv_items.lmod |
The difference in days between last modification and today. |
||
Size 1 |
C.20.14 |
Size 1 |
m_inv_items.ident > m_idents.input_1 |
|
Size 2 |
C.20.14 |
Size 2 |
m_inv_items.ident > m_idents.input_2 |
|
Size 3 |
C.20.14 |
Size 3 |
m_inv_items.ident > m_idents.input_3 |
|
Size 4 |
C.20.14 |
Size 4 |
m_inv_items.ident > m_idents.input_4 |
|
Size 5 |
C.20.14 |
Size 5 |
m_inv_items.ident > m_idents.input_5 |
|
Inventory Locations |
Mobile Scan |
A pin is displayed when Mobile Scan data is available to locate the inventory locations of the item. Click the pin to open the Inventory Locations report (see Inventory Locations). |