ISH sheet (item shipments) - Intergraph Smart Materials - Version 2016 R4 (8.4.0) - Help - Hexagon PPM

Intergraph Smart Materials Help (2016)

PPMProduct
Intergraph Smart Materials
PPMCategory_custom
Help
Version_SPMat
2016 R4 (8.4)

The following identifiers must be used in the ISH sheet:

#ORDER# - the rows/columns following the field containing this value display the order data.

#ISH# - must be defined in column 256 in the row above the rows containing item shipment information (item shipment start identifier).

#END_ISH# - must be defined in column 256 in the row following the rows containing item shipment information (item shipment end identifier).

#END_TEMPLATE# - Processing of the sheet stops at this identifier. It is strongly recommended to keep this identifier in the row following the last row with the #END_ISH# identifier, to enhance the performance.

Name

Description

Mandatory?

Imported?

#SPLIT#

Split

Y

Y

#ISH_POLI_POS#

Pos

Y

Y

#ISH_POLI_SUB_POS#

Sub

Y

Y

#ISH_POS#

Is Pos

Y

Y

#ISH_SUB_POS#

IS Sub

Y

Y

#ISH_REVISION_ID#

Suppl

Y

Y

#ISH_ACKNOWLEDGE_IND#

Acknow

Y

Y

#ISH_IDENT_CODE#

Ident Code

N

Y

#ISH_TAG_NUMBER#

Tag Number

Y

Y

#TAG_SHORT_DESC#

Tag Short Description (only for import)

N

Y

#TAG_LONG_DESC#

Tag Description (only for import)

N

Y

#ISH_COMMODITY_CODE#

Commodity Code

N

#ISH_ITY_CODE#

Item Type

N

#ISH_INPUT_1#

Size 1

N

#ISH_INPUT_2#

Size 2

N

#ISH_INPUT_3#

Size 3

N

#ISH_INPUT_4#

Size 4

N

#ISH_INPUT_5#

Size 5

N

#ISH_R_CODE#

Engineering Requisition

N

#ISH_R_SUPP#

ER Suppl

N

#ISH_RLI_POS#

RLI Pos

N

#ISH_RLI_SUB_POS#

RLI Sub

N

#ISH_PROC_ORDER_SEQ#

Proc Seq

N

#ISH_REV_FRT_CODE#

Incoterm

Y

Y

#ISH_REV_FREIGHT_VALUE#

Delivery Place

Y

Y

#ISH_DTP_CODE#

Delivery Type

Y

Y

#ISH_DD_CODE#

Delivery Designation

Y

Y

#ISH_RM_CODE#

Routing Method

Y

Y

#ISH_SEL_CODE#

Selection Code

Y

Y

#ISH_EXPED_PAR_CODE#

Pertinent Area(Exp.)

Y

Y

#ISH_INSP_PAR_CODE#

Pertinent Area(Insp.)

Y

Y

#ISH_EXPED_SF_CODE#

N

Y

#ISH_INSP_SF_CODE#

N

Y

#ISH_REQ_QTY#

Requisition Quantity

N

#ISH_RELEASED_QTY#

Released Quantity

N

#ISH_POLI_QTY#

Order Quantity

N

#ISH_POLI_VARIATION#

Order Variation

N

#ISH_ITEM_SHIP_QTY#

Item Ship Quantity

Y

Y

#ISH_REQ_DELTA#

ISH-Req Delta

N

#ISH_PO_DELTA#

ISH-PO Delta

N

#ISH_PO_REQ_DELTA#

PO-Req Delta

N

#ISH_APPROVED_QTY#

Approved Quantity

N

#ISH_TOTAL_APPROVED_QTY#

Total Approved Quantity

N

#ISH_RECEIVED_QTY#

Received Quantity

N

#ISH_QUANTITY_UNIT#

Quantity Unit

N

Y

#ISH_ITEM_SHIP_WEIGHT#

Item Ship Weight

Y

Y

#ISH_TOTAL_ISH_WEIGHT#

Total ISH Weight

N

#ISH_WEIGHT_UNIT#

Weight Unit

Y

Y

#ISH_HEAT_IND#

Heat

N

#ISH_HEAT_COMP_IND#

Heat Comp

N

#ISH_MCS_REQUIRED_IND#

MCS Required

N

Y

#ISH_MCS_NUMBER#

MCS Number

N

Y

#ISH_MCS_DATE#

MCS Date

N

#ISH_MCS_QTY#

MCS Quantity

N

Y

#ISH_MCS_WEIGHT#

MCS Weight

N

Y

#ISH_TOTAL_MCS_WEIGHT#

Total MCS Weight

N

#ISH_IRC_REQUIRED_IND#

IRC Required

N

Y

#ISH_IRCT_NUMBER#

IRC Number

N

Y

#ISH_IRCT_DATE#

IRC Date

N

#ISH_IRC_QTY#

IRC Quantity

N

Y

#ISH_IRC_WEIGHT#

IRC Weight

N

Y

#ISH_TOTAL_IRC_WEIGHT#

Total IRC Weight

N

#ISH_RELN_NUMBER#

Release Note Number

N

Y

#ISH_RELN_DATE#

Release Note Date

N

#ISH_RELN_QTY#

Release Note Quantity

N

Y

#ISH_RELN_WEIGHT#

Release Note Weight

N

Y

#ISH_TOTAL_RELN_WEIGHT#

Total RN Weight

N

#ISH_RELN_WEIGHT_UNIT#

RN Weight Unit

N

#ISH_DELV_DATE#

Delivery Date

N

Y

#ISH_PROM_CONTRACT_DATE#

Prom Contract

N

Y

#ISH_ACTUAL_CONTRACT_DATE#

PO Actual

N

Y

#ISH_PROM_INSPECT_DATE#

Prom Inspect

N

Y

#ISH_FINAL_INSPECT_DATE#

Final Inspect

N

Y

#ISH_READY_PREDICTED#

Ready Predicted

N

Y

#ISH_READY_ACTUAL#

Ready Actual

N

Y

#ISH_PROM_SHIP_DATE#

Prom Ship

N

Y

#ISH_REV_PROM_SHIP_DATE#

Curr/Rev Prom Ship

N

Y

#ISH_PRED_SHIP_DATE#

Pred Ship

N

Y

#ISH_ACTUAL_SHIP_DATE#

Actual Ship

N

Y

#ISH_PRED_TRAFFIC_ARRIVAL#

Pred Traffic Arrival

N

Y

#ISH_ACTUAL_TRAFFIC_ARRIVAL#

Actual Traffic Arrival

N

Y

#ISH_FORECAST_ETA_SITE_DATE#

Prom On Site

N

Y

#ISH_PRED_ON_SITE_DATE#

Pred On Site

N

Y

#ISH_ACTUAL_ON_SITE_DATE#

Actual On Site

N

Y

#ISH_REQ_SITE_DATE#

Req On Site

N

Y

#ISH_MAJ_MATL_ORDER_DATE#

Maj Matl Order

N

Y

#ISH_MAJ_MATL_RECV_DATE#

Maj Matl Recv

N

Y

#ISH_ACTUAL_FAB_START_DATE#

Actual Fab Start

N

Y

#ISH_FAB_COMPLETE_PERCENT#

Comp %

N

Y

#ISH_FIFTY_PERCENT_FAB_COMP#

50% Comp

N

Y

#ISH_PROM_FAB_COMP_DATE#

Prom Fab Comp

N

Y

#ISH_ACTUAL_FAB_COMP_DATE#

Actual Fab Comp

N

Y

#ISH_FAB_LOCATION#

Fab Location

N

Y

#ISH_FAB_SHOP_CNTRL_NUMBER#

Fab Ctrl Number

N

Y

#ISH_INSP_LOCATION#

Inspection Location

N

Y

#ISH_MANUFACTURER#

Manufacturer

N

Y

#ISH_ITEM_SHIP_DIMENSIONS#

Dimensions

N

Y

#ISH_INSPECTABLE_IND#

Inspectable

N

Y

#ISH_INSP_RELEASE_NOTE_IND#

Release Note

N

Y

#ISH_INSP_WAIVER_IND#

Waiver

N

Y

#ISH_INSP_REL_WAIVER_DATE#

Release/Waiver Date

N

Y

#ISH_INSP_NCR_DATE#

NCR Date

N

Y

#ISH_INSP_NCR_RELEASE_DATE#

NCR Release Date

N

Y

#ISH_INSP_NCR_REMARKS#

NCR Remarks

N

Y

#ISH_ITEM_SHIP_VOLUME#

Volume

N

Y

#ISH_TOTAL_VOLUME#

Total Volume

N

#ISH_VOLUME_UNIT#

Volume Unit

N

Y

#ISH_X_DIM#

x Dimension

N

Y

#ISH_Y_DIM#

y Dimension

N

Y

#ISH_Z_DIM#

z Dimension

N

Y

#ISH_DIM_UNIT#

Dim Unit

N

Y

#ISH_CALC_VOLUME#

Calculated Volume

N

#ISH_TOTAL_CALC_VOLUME#

Total Calculated Volume

N

#ISH_DEFAULT_VOLUME#

Def. Volume Unit

N

#ISH_EXPORT_LICENSE_REQ_IND#

Exp Lic Req

N

Y

#ISH_ACTUAL_IND#

Actual

N

Y

#ISH_COMMENTS#

Comment

N

Y

#ISH_PACKAGE_IND#

Package

N

#ISH_LAST_INFO_DATE#

Last Info Date

N

Y

#ISH_IE_CODE#

Info Type

N

Y

#ISH_DES_CODE_INSP#

Inspection Destination

N

#ISH_PLANNED_DATE_INSP#

Inspection Planned

N

#ISH_FORECASTED_DATE_INSP#

Inspection Forecasted

N

Y

#ISH_ACTUAL_DATE_INSP#

Inspection Actual

N

#ISH_DES_CODE_IRC#

IRC Destination

N

#ISH_PLANNED_DATE_IRC#

IRC Planned

N

#ISH_FORECASTED_DATE_IRC#

IRC Forecasted

N

Y

#ISH_ACTUAL_DATE_IRC#

IRC Actual

N

#ISH_DES_CODE_EXWO#

Hand-Over Destination

N

#ISH_PLANNED_DATE_EXWO#

Hand-Over Planned

N

#ISH_FORECASTED_DATE_EXWO#

Hand-Over Forecasted

N

Y

#ISH_ACTUAL_DATE_EXWO#

Hand-Over Actual

N

Y

#ISH_DES_CODE_SHIP_1#

1st Shipping Destination

N

#ISH_PLANNED_DATE_SHIP_1#

1st Shipping Planned

N

#ISH_FORECASTED_DATE_SHIP_1#

1st Shipping Forecasted

N

Y

#ISH_ACTUAL_DATE_SHIP_1#

1st Shipping Actual

N

Y

#ISH_DES_CODE_SHIP_2#

2nd Shipping Destination

N

#ISH_PLANNED_DATE_SHIP_2#

2nd Shipping Planned

N

#ISH_FORECASTED_DATE_SHIP_2#

2nd Shipping Forecasted

N

Y

#ISH_ACTUAL_DATE_SHIP_2#

2nd Shipping Actual

N

Y

#ISH_DES_CODE_SHIP_3#

3rd Shipping Destination

N

#ISH_PLANNED_DATE_SHIP_3#

3rd Shipping Planned

N

#ISH_FORECASTED_DATE_SHIP_3#

3rd Shipping Forecasted

N

Y

#ISH_ACTUAL_DATE_SHIP_3#

3rd Shipping Actual

N

Y

#ISH_DES_CODE_TA#

Traffic Arrival Destination

N

#ISH_PLANNED_DATE_TA#

Traffic Arrival Planned

N

#ISH_FORECASTED_DATE_TA#

Traffic Arrival Forecasted

N

Y

#ISH_ACTUAL_DATE_TA#

Traffic Arrival Actual

N

Y

#ISH_DES_CODE_AOS#

Arrival On Site Destination

N

#ISH_PLANNED_DATE_AOS#

Arrival On Site Planned

N

#ISH_FORECASTED_DATE_AOS#

Arrival On Site Forecasted

N

Y

#ISH_ACTUAL_DATE_AOS#

Arrival On Site Actual

N

Y

Starting with the first empty column up to column 255, you can add item shipment properties to the template. The Name must be defined using this rule:

#<Property Group Code>.<Property Code>#

Replace <Property Group Code> with the name of the property group, and <Property Code> with the name of the property. For example, the property MAX_TEMP defined under property group OTHERS would be specified in the Excel template as:

#OTHERS.MAX_TEMP#

For the description, you might use the property name or label text.

All property values are optional (not mandatory) and will be imported.