General File Format - Intergraph Smart Materials - Version 2020 (10.0) - Help - Hexagon PPM

Intergraph Smart Materials Classic Help (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
2020 (10.0)
  • 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.