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.