-
Make the import file a flat ASCII file with .dat as the extension.
-
All physical columns must be on one single line, forming a physical record.
-
Separate each column with a semicolon (';').
-
Terminate each physical record with a new line character. The new line character is different depending on the platform:
Unix |
single line feed character |
ASCII |
code 10 |
Windows |
line feed and a carriage return #10+#13 |
Provide the following data in the import file:
Origin
Order number
Order type ('PO', 'NC', or 'CO')
Supplement of the order
Position of the order line item
Sub-position of the order line item
Position of the item shipment
Sub-position of the item shipment
Comment
Part number
Drawing number
Quantity
Case number (or package number or name of goods)
Routing method
Forecasted delivery date
For example, one line in such a file could look like this:
HOME;PO-100;PO;0;1;1;1;1;Comment 1;Part A;Drawing A;10;1;RM-100;24-JAN-2003
Use the following format for the forecasted delivery date: DD-MON-YYYY.
Pay attention to the following information for the supplement:
-
Generally, the supplement and revision of an order are identical. However, the supplement and revision may be not identical in the case of change orders if the ZP_SUM_CO project default is set to Y.
-
The value of the po_supp database field is required, not the value of the database field revision_id. This is not to be confused because on most screens, the revision_id column is displayed in the 'Suppl' field.