A.6 Table: m_item_ships, Package: m_api_ish - Intergraph Smart Materials - Version 10.4 - Customization & Programming

A.6.1 Procedure: upd_ish

Argument Name	Type	In/Out
P_US_ID	NUMBER(12)	IN
P_ISH_ID	NUMBER(12)	IN
P_COL_ARR	RECORD	IN
COL_NAME	TABLE OF VARCHAR2(255)	IN
COL_VALUE	TABLE OF VARCHAR2(255)	IN
P_RESULT	VARCHAR2	OUT
P_COMMIT_IND	VARCHAR2	IN; DEFAULT ‘Y’

Column Name	Prompt on P.70.72	Allowable values
ACTUAL_CONTRACT_DATE	PO Actual	Any valid date
ACTUAL_FAB_COMP_DATE	Actual Fab Comp	Any valid date
ACTUAL_FAB_START_DATE	Actual Fab Start	Any valid date
ACTUAL_ON_SITE_DATE	Actual On Site	Any valid date
ACTUAL_SHIP_DATE	Actual Ship	Any valid date
COMMENTS	Comment
DD_CODE	Delivery Designation	All delivery designations of A.10.39
EXPORT_LICENSE_REQ_IND	Exp Lic Req	‘Y’, ‘N’
FAB_COMPLETE_PERCENT	Comp %	0 – 100
FAB_LOCATION	Fab Location
FAB_SHOP_CNTRL_NUMBER	Fab Ctrl Number
FIFTY_PERCENT_FAB_COMP	50% Comp	Any valid date
FINAL_INSPECT_DATE	Final Inspect	Any valid date
ITEM_SHIP_DIMENSIONS	Dimension
ITEM_SHIP_QTY	Quantity	0 – 999999999999.999
ITEM_SHIP_VOLUME	Item Ship Volume	0 – 999999999999.999
ITEM_SHIP_WEIGHT	Item Ship Weight	0 – 999999999999.999
MAJ_MATL_ORDER_DATE	Maj Matl Order	Any valid date
MAJ_MATL_RECV_DATE	Maj Matl Recv	Any valid date
PRED_ON_SITE_DATE	Pred On Site	Any valid date
PRED_SHIP_DATE	Pred Ship	Any valid date
PROM_CONTRACT_DATE	Prom Contract	Any valid date
PROM_FAB_COMP_DATE	Prom Fab Comp	Any valid date
PROM_INSPECT_DATE	Prom Inspect	Any valid date
PROM_SHIP_DATE	Prom Ship	Any valid date
QTY_CODE	Qty Unit	All units in the ‘weight’, ‘volume’, and ‘quantity’ unit groups; Update only allowed for detail tags
READY_ACTUAL	Ready Actual	Any valid date
READY_PREDICTED	Ready Predicted	Any valid date
REQ_SITE_DATE	Req On Site	Any valid date
REV_PROM_SHIP_DATE	Curr/Rev Prom Ship	Any valid date
RM_CODE	Routing Method	All routing methods of P.10.53
VOL_CODE	Vol Unit	All units in the ‘volume’ unit group
WEIGHT_CODE	Weight Unit	All units in the ‘weight’ unit group

A.6.2 Procedure: ins_ish

You can only insert item shipments if the order has been approved.

Argument Name	Type	In/Out
P_US_ID	NUMBER(12)	IN
P_POLI_ID	NUMBER(12)	IN
P_COL_ARR	RECORD	IN
COL_NAME	TABLE OF VARCHAR2(255)	IN
COL_VALUE	TABLE OF VARCHAR2(255)	IN
P_RESULT	VARCHAR2	OUT
P_ITEM_SHIP_ID	NUMBER(12)	OUT
P_COMMIT_IND	VARCHAR2	IN; DEFAULT ‘Y’

Column Name	Prompt on P.70.72	Allowable values
ACTUAL_CONTRACT_DATE	PO Actual	Any valid date
ACTUAL_FAB_COMP_DATE	Actual Fab Comp	Any valid date
ACTUAL_FAB_START_DATE	Actual Fab Start	Any valid date
ACTUAL_ON_SITE_DATE	Actual On Site	Any valid date
ACTUAL_SHIP_DATE	Actual Ship	Any valid date
COMMENTS	Comment
DD_CODE	Delivery Designation	All delivery designations of A.10.39
EXPORT_LICENSE_REQ_IND	Exp Lic Req	‘Y’, ‘N’
FAB_COMPLETE_PERCENT	Comp %	0 – 100
FAB_LOCATION	Fab Location
FAB_SHOP_CNTRL_NUMBER	Fab Ctrl Number
FIFTY_PERCENT_FAB_COMP	50% Comp	Any valid date
FINAL_INSPECT_DATE	Final Inspect	Any valid date
ITEM_SHIP_DIMENSIONS	Dimension
ITEM_SHIP_POS	Pos	1 – 9999999
ITEM_SHIP_SUB_POS	Sub	0 – 99999
ITEM_SHIP_QTY	Quantity	0 – 999999999999.999
ITEM_SHIP_VOLUME	Item Ship Volume	0 – 999999999999.999
ITEM_SHIP_WEIGHT	Item Ship Weight	0 – 999999999999.999
MAJ_MATL_ORDER_DATE	Maj Matl Order	Any valid date
MAJ_MATL_RECV_DATE	Maj Matl Recv	Any valid date
PRED_ON_SITE_DATE	Pred On Site	Any valid date
PRED_SHIP_DATE	Pred Ship	Any valid date
PROM_CONTRACT_DATE	Prom Contract	Any valid date
PROM_FAB_COMP_DATE	Prom Fab Comp	Any valid date
PROM_INSPECT_DATE	Prom Inspect	Any valid date
PROM_SHIP_DATE	Prom Ship	Any valid date
READY_ACTUAL	Ready Actual	Any valid date
READY_PREDICTED	Ready Predicted	Any valid date
REV_PROM_SHIP_DATE	Curr/Rev Prom Ship	Any valid date
RM_CODE	Routing Method	All routing methods of P.10.53
VOL_CODE	Vol Unit	All units in the ‘volume’ unit group
WEIGHT_CODE	Weight Unit	All units in the ‘weight’ unit group

A.6.3 Procedure: ins_detail_ish

This procedure can be used for creating a detail tag for a tagged item (functionality provided in the procurement, expediting, traffic, and site screens via the ‘Split Tag’ button).

A detail tag can only be created on the item shipment level if the following conditions are met:

The item rule of the item type for the ident on this item shipment is ‘TAB’, ‘TFM’, ‘TOM’, ‘TWM’, or ‘SWT’.
The tag number is unlike ‘---‘ and unlike ‘UNTAGGED’.
The item shipment is not a detail tag.
Additional splits are created for the corresponding order line item (not as a detail tag but as ‘normal’ splits).
No split is occurred on the order line item level.

To create a detail tag using this procedure, you must connect to the project in which you want to create the split.

The p_ish_id parameter must be filled with the primary key of the item shipment that represents the master tag.

Argument Name	Type	In/Out
P_US_ID	NUMBER(12)	IN
P_ISH_ID	NUMBER(12)	IN
P_RESULT	VARCHAR2	OUT
P_COMMIT_IND	VARCHAR2	IN; DEFAULT ‘Y’

A.6 Table: m_item_ships, Package: m_api_ish - Intergraph Smart Materials - Version 10.4 - Customization & Programming - Hexagon

Intergraph Smart Materials Classic API Configuration (10.4)