The supplied template can be modified according to the following rules:
-
It is not allowed to modify the names of the sheets (ISH, MCS, IRC, RN, HEAT, INTERNAL).
-
The display of data is controlled by identifiers in the following format:
#FIELD_NAME#
*FIELD_NAME* - Using this format (field name enclosed by * *) excludes the values in the field from the import. There is no difference in the created export file.
-
The start identifier of each data block (#ORDER#, #ISH#, #MCS#, #IRC#, #RN#, #HEAT#) cannot be omitted.
-
The end identifiers of each block (#END_ISH#, #END_MCS#, #END_IRC#, #END_RN#, #END_HEAT#) cannot be omitted.
-
Processing of each sheet of the template stops at the identifier #END_TEMPLATE#. It is strongly recommended not to remove this identifier, because this would result in a significant increase in processing time for the export.
-
The columns 250 – 255 are reserved for internal use.
-
Positions of the identifiers of the ORDER block can be changed horizontally or vertically.
-
All identifiers of the blocks ISH (Item Shipments), MCS, IRC, RN (Release Notes) and HEAT (Heat Numbers) must reside on one line.
-
The identifiers corresponding to the Pos, Sub, Is Pos, IS Sub, and Suppl fields are required for item shipments and heat numbers (ISH and HEAT sheets).
-
Data type formats of the identifier fields must correspond to the datatypes on P.70.72 (this is the case in the supplied template).
-
Color coding in the supplied template in general has the following meaning (although this is not a complete representation of the application logic of P.70.72).
Color
Meaning
Gray
Fields that cannot be modified by the import and thus should not be changed.
Green
Mandatory; input is required for these fields by the import.
White
Optional; input is not required for these fields.
Blue
Fields in the order block cannot be modified. For the identifier #SPLIT#, see the information about splitting tags.