A.6 Table: m_item_ships, Package: m_api_ish - Intergraph Smart Materials - Version 2020 (10.0) - Customization & Programming - Hexagon

Intergraph Smart Materials Classic API Configuration (2020)

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

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’