A few quick questions on DMT and “combined” type templates…
As I understand it, when creating a new record that the system would normally generate the number for (OrderHed, ShipHead, etc…), you can set the OrderNum to zero to have it create a new record.
For example, the following would create 3 new Orders (only the OrderHed records created)
(not all required fields show)
Company OrderNum CustID MC 0 XYZ123 MC 0 PDQ999 MC 0 XYZ123
The above requires checking the “Add New” box in DMT
If I used the Sales Order Combined in DMT, it allows specifying line and release info in the same line. But this requires the OrderNum the for the line details. like:
(again, not all required fields show)
Company OrderNum CustID OrderDtl#OrderLine OrderDtl#PartNum MC 0 XYZ123 0 WIDGET-001 MC 0 XYZ123 0 WIDGET-002 MC 0 PDQ999 0 WIDGET-001 MC 0 XYZ123 0 WIDGET-001
What guarantees that the the first and second rows end up on the first order created, row 3 the second order, and row 4 the third? And that row 4 isn’t just added as the 3rd line of the first order created?
When updating existing records, the OrderDtl#OrderLine will be respected, but not so on Add New records.
Does DMT assume that if the OrderNum and CustomerID haven’t changed then these rows are apart of the same order?
What does the following input file create
Company OrderNum CustID OrderDtl#OrderLine OrderDtl#PartNum OrderRel#OrderRelNum MC 0 XYZ123 0 WIDGET-001 0 MC 0 XYZ123 0 WIDGET-001 0 MC 0 XYZ123 0 WIDGET-001 0 MC 0 XYZ123 0 WIDGET-001 0
Four orders with one line each, with just one release on that line?
One Order with four lines, with one release each?
One Order with one line, with four releases?