The following tables list the format for importing material confirmation data from a WMS. Each record is a caret-delimited row in the import file.
Position |
Field Name |
Required |
Description |
1 |
MFGHDR |
Yes |
This is MFGHDR to indicate the record is a header record. |
2 |
Location Prefix |
Yes |
This is the location prefix. |
3 |
Work Order Number |
Yes |
This is the work order number. |
4 |
Operation Sequence |
No |
This is the operation sequence number. If it is blank, it indicates the record is for all sequence numbers. |
5 |
Confirm Date |
No |
This defaults to the current date. |
6 |
Adjust Option |
No |
This is the inventory adjust option. It defaults to NO. |
7 |
As Is Option |
No |
If this is YES, confirm as is. |
8 |
WMS Transaction Date |
No |
This is the date the transaction occurred in the WMS. This defaults to the current date. |
9 |
WMS Transaction Time |
No |
This is the time the transaction occurred in the WMS. This defaults to the current time. |
10 |
WMS Import Key |
No |
This is a key value used to differentiate between WMS transactions. If this is imported, it must be a unique value that was not previously associated with a WMS transaction. |
Position |
Field Name |
Required |
Description |
1 |
MFGTRL |
Yes |
This is MFGTRL to indicate the record is a trailer record. |
2 |
Operation Sequence |
Yes |
This is the operation sequence number. |
3 |
Product Code |
Yes |
This is the product code. |
4 |
Phantom Assembly Product Code |
No |
This is the phantom assembly product code. |
5 |
Selected Quantity |
Yes |
This is the confirmed issued quantity. |
6 |
Unit of Measure |
No |
If this is blank, it defaults to the recommended unit of measure. |
7 |
Break-From Unit of Measure Code |
No |
This is the break-from unit of measure code. |
8 |
Recommended Bin |
Yes |
This is the recommended bin. |
9 |
Recommended Lot |
No |
This is the recommended lot for products tracked by lot. |
10 |
Recommended Serial Number |
No |
This is the recommended serial number for products tracked by serial number. |
11 |
Bin |
No |
If this is blank, it defaults to the recommended bin. |
12 |
Lot |
No |
If this is blank, it defaults to the recommended lot. |
13 |
Serial Number |
No |
If this is blank, it defaults to the recommended serial number. |