GET_SHIPPING_STATUS - Intergraph Smart Materials - Version 2020 (10.0) - Customization & Programming - Hexagon PPM

Intergraph Smart Materials Customization (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
2020 (10.0)

Description:

This function determines the shipping status of an item shipment. The function returns:

0 - if the material is already shipped, that is, ATD (actual time of departure) lies in the past,

1 - if the material has not been shipped, that is, no carrier has been assigned,

2 - if the material is next to be shipped, that is, the ETD (estimated time of departure) lies in the future,

9 - in all other cases.

Type:

Function

Usage:

P.70.62

Event:

This sample CIP can be integrated in the configuration that is set up on P.10.74 for P.70.62. When you execute a query on P.70.62, the software calls this CIP.

Default:

1, if m_item_ships.csh_id is NULL (carrier not assigned, material not shipped)

0, if m_item_ships.csh_id is not NULL and m_cargo_ships.atd_date<sysdate

2, if m_item_ships.csh_id is not NULL and m_cargo_ships.etd_date>sysdate

Else 9