Expediting - Intergraph Smart Materials - 10.2 - Help - Hexagon

Intergraph Smart Materials Web Help (10.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Web
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2

You can view item shipments with expediting information using the Expediting report.

Before you run this report, you must run a database job (assigned to the Expediting report) that prepares the data for this report. We recommend that you run this job at least once a day. For more details see Manage Synchronization Jobs.

  • This is an interactive report.

  • Click SearchColumn 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 an agreement number to open the Details - Agreements and Line Items page, where the line items of the selected agreement appear. For more information, see Agreements and Line Items.

Click a requisition number to open the Requisitions page, where the line items of the selected requisition appear. For more information, see Requisitions.

You can click the Ident Code values to open the Ident Information page. For more information, see Ident Information.

All displayed data is retrieved from the P.70.72 Expediting Details screen in Smart Materials, except the following:

  • On-time Qty = Item Ship Qty – Delayed Qty.

  • Delayed Qty = Item Ship Qty with Delayed MRR Receive Days > 0.

  • Supplier Promised (CIP) – Is fetched by the m_pck_bir_custom.get_planned_ship_date CIP function. By default, the function returns the promised contract date (Prom Contract field on P.70.72 screen)

  • Supplier Actual (CIP) – Is fetched by the m_pck_bir_custom.get_actual_contract_date CIP function. By default, the function returns the actual contract date (PO Actual field on P.70.72 screen).

  • Delayed Supplier Delivery Days = Supplier Actual (CIP) – Supplier Promised (CIP).

  • Latest Item Receipt Date = Inventory Item Receiving Date (Recv Date field on Receiving screen).

  • Latest MRR Receipt Date = Material Receipt Date on MRR header (Matl Recv Date field on Receiving screen)

  • Latest MRR Post Date = The latest post date of an MRR related to the selected item shipment.

  • Delayed Supplier Qty = The quantity with Supplier Actual (CIP) later than Supplier Promised (CIP). If the Supplier Promised (CIP) is in the past, and the Supplier Actual (CIP) is empty (NULL), the item shipment is considered as delayed.

  • On-time Supplier Qty = The quantity with Supplier Actual (CIP) not later than Supplier Promised (CIP).

  • Delayed MRR Receive Days = Latest Item Receipt Date – Req On Site. If Req On Site is in the past the Latest Item Receipt Date is not available, the Delayed MRR Receive Days are calculated as Synchronization Job Run date – Req On Site.

  • Actual Ship Date = Is fetched by the m_pck_bir_custom.get_actual_ship_date CIP function. By default, the function returns the actual ship date (Actual Ship field on P.70.72 screen).

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

P.70.72 Expediting Details

Table

P170_IR_DATA

CIP

m_pck_bir_custom.get_planned_ship_date (-> Supplier Promised (CIP))

m_pck_bir_custom.get_actual_contract_date (-> Supplier Actual (CIP))

m_pck_bir_custom.get_actual_ship_date (-> Actual Ship Date)

m_pck_bir_custom.get_exp_cip1(to 10)_header (-> CIP1 to 10 label)

m_pck_bir_custom.get_exp_cip1 to 10 (-> CIP1 to 10 value)

Log File

sync_p170_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

P.70.71

Project

m_req_to_pos.proj_id

Agreement Number

P.70.71

Order Number

m_po_headers.po_number

Original Order Type

P.70.71

Type

m_pck_mscm.fetch_po_type(poh_id)

Order type of supplement 0

Engineering Requisition

P.70.71

Engineering Requisition

m_req_to_pos.r_id (-> m_reqs.r_code)

Supplier

P.70.71

Supplier

m_po_headers.sup_id (-> m_suppliers.sup_code)

Expediter

P.70.71

Expediter

m_pck_exped_workload.get_expediter(base_poh_id,r_code,origin_code)

Inspector

P.70.71

Inspector

m_pck_exped_workload.get_inspector(base_poh_id,r_code,origin_code)

Company

P.70.71

m_po_headers.sup_id (-> m_suppliers.company_id -> m_companies.company_name)

Buyer

P.70.71

Buyer

m_po_headers.buyer

Origin

P.70.71

Origin

m_po_headers.origin_id (-> m_origins.origin_code)

Pos

P.70.72

Pos

m_po_line_items.poli_pos

Sub Pos

P.70.72

Sub Pos

m_po_line_items.poli_sub_pos

IS Pos

P.70.72

IS Pos

m_item_ships.item_ship_pos

IS Sub

P.70.72

IS Sub

m_item_ships.item_ship_sub_pos

Item Type

P.70.72

Item Type

m_item_ships.ident (-> m_idents.commodity_id -> m_commodity_codes.ity_id -> m_item_types.ity_code)

Commodity Code

P.70.72

Commodity Code

m_item_ships.ident (-> m_idents.commodity_id -> m_commodity_codes.commodity_code)

Ident Code

P.70.72

Ident Code

m_item_ships.ident

m_pck_mscm.get_ident_code(ident)

Short Description

P.70.72

Ident Short Description

m_pck_std_custom.ident_desc

Tag Number

P.70.72

Tag Number

m_item_ships.tag_number

Incoterm

P.70.72

Incoterm

m_item_ships.frt_id (-> m_freight_terms.frt.code)

Delivery Place

P.70.72

Delivery Place

m_po_line_items.freight_value

Delivery Type

P.70.72

Delivery Type

m_item_ships.dd_id (-> m_delv_desigs.dtp_id -> m_delv_types.dtp_code)

Delivery Designation

P.70.72

Delivery Designation

m_item_ships.dd_id (-> m_delv_desigs.dd_code)

Routing Method

P.70.72

Routing Method

m_item_ships.rm_id (-> m_routing_methods.rm_code)

Order Quantity

P.70.72

Order Quantity

m_po_line_items.poli_qty

Item Ship Quantity

P.70.72

Item Ship Quantity

m_item_ships.item_ship_qty

Received Quantity

P.70.72

Received Quantity

m_pck_expediting.get_rec_qty_ship(item_ship_id)

Latest MRR Receipt Date

P.70.72

Material Receipt Date on MRR header (Matl Recv Date field on Receiving screen)

Quantity Unit

P.70.72

Quantity Unit

m_item_ships.ish_qty_unit (-> m_units.unit_code)

Supplier Promised (CIP)

P.70.72

m_pck_bir_custom.get_planned_ship_date

Supplier Actual (CIP)

P.70.72

m_pck_bir_custom.get_actual_contract_date

Delayed Supplier Delivery Days

P.70.72

Supplier Actual (CIP) - Supplier Promised (CIP). If Supplier Actual (CIP) is not available, the Delayed Supplier Delivery Days are calculated as Synchronization Job Run date – Supplier Promised (CIP).

On-time Supplier Quantity

P.70.72

The quantity with Supplier Actual (CIP) not later than Supplier Promised (CIP)

Delayed Supplier Quantity

P.70.72

The quantity with Supplier Actual (CIP) later than Supplier Promised (CIP). If the Supplier Promised (CIP) is in the past, and the Supplier Actual (CIP) is empty (NULL), the item shipment is considered as delayed

Req On Site

P.70.72

Req On Site

m_item_ships.req_site_date

Latest Item Receipt Date

P.70.72

Inventory Item Receiving Date (Recv Date field on Receiving screen)

Delayed MRR Receive Days

P.70.72

Latest Item Receipt Date – Req On Site. If Req On Site is in the past the Latest Item Receipt Date is not available, the Delayed MRR Receive Days are calculated as Synchronization Job Run date – Req On Site

On-time Quantity

P.70.72

Item Ship Qty – Delayed Qty

Delayed Quantity

P.70.72

Item Ship Qty with Delayed MRR Receive Days > 0

Latest MRR Post Date

P.70.72

Latest MRR Post Date

The latest post date of an MRR related to the selected item shipment

Item Ship Weight

P.70.72

Item Ship Weight

m_item_ships.item_ship_weight

Weight Unit

P.70.72

Weight Unit

m_item_ships.weight_unit_id (-> m_units.unit_code)

Forecasted Delivery Date

P.70.72

Forecasted Delivery Date

m_item_ships.delv_date

Prom Ship Date

P.70.72

Prom Ship

m_item_ships.prom_ship_date

Curr/Rev Prom Ship

P.70.72

Curr/Rev Prom Ship

m_item_ships.rev_prom_ship_date

Prom On Site

P.70.72

Prom On Site

m_item_ships.forecast_eta_site_date

Pred On Site

P.70.72

Pred On Site

m_item_ships.pred_on_site_date

Actual On Site

P.70.72

Actual On Site

m_item_ships.actual_on_site_date

Actual Ship Date

P.70.72

Actual Ship

m_pck_bir_custom.get_actual_ship_date

Order Type

P.70.71

Order Type

m_pck_mscm.fetch_po_type(poh_id)

CIP1

m_pck_bir_custom.get_exp_cip1_header

m_pck_bir_custom.get_exp_cip1

CIP2

m_pck_bir_custom.get_exp_cip2_header

m_pck_bir_custom.get_exp_cip2

CIP3

m_pck_bir_custom.get_exp_cip3_header

m_pck_bir_custom.get_exp_cip3

CIP4

m_pck_bir_custom.get_exp_cip4_header

m_pck_bir_custom.get_exp_cip4

CIP5

m_pck_bir_custom.get_exp_cip5_header

m_pck_bir_custom.get_exp_cip5

CIP6

m_pck_bir_custom.get_exp_cip6_header

m_pck_bir_custom.get_exp_cip6

CIP7

m_pck_bir_custom.get_exp_cip7_header

m_pck_bir_custom.get_exp_cip7

CIP8

m_pck_bir_custom.get_exp_cip8_header

m_pck_bir_custom.get_exp_cip8

CIP9

m_pck_bir_custom.get_exp_cip9_header

m_pck_bir_custom.get_exp_cip9

CIP10

m_pck_bir_custom.get_exp_cip10_header

m_pck_bir_custom.get_exp_cip10