Purchase Order File Format
File: [SSSSSSNNNN.ORR]
Store Manager application: Place files in the dnload
subdirectory of the Xpress Server.
This file may contain multiple documents. A document transaction consists of one header record (denoted by the record type H) and multiple detail records (denoted by the record type D).
Fields with an asterisk are required:
Field Number and Name | Type/Length | Column | Possible Values |
|---|---|---|---|
1 Record Type | String 1 | 1 - 1 | H |
2 Document No. (PO) | String 20 | 2 - 21 | |
3 Order Type | Decimal 2.0 | 22 - 23 | User defined |
4 Vendor #/Invoice | String 9 | 24 - 32 | |
5 Order Date | Decimal 8.0 | 33 - 40 | YYYYMMDD |
6 Vendor-SKU Flag | String 1 | 41 - 41 | |
7 Expected Delivery Date | Decimal 8.0 | 42 - 49 | YYYYMMDD |
8 Cancel Date | Decimal 8.0 | 50 - 57 | YYYYMMDD |
9 Note | String 40 | 58 - 97 | Not used. |
10 Status | String 1 | 98 - 98 | P (or blank) - Pending I - Issues entire PO. PO line items must be included in the download. V - Voids entire existing PO. No line items are required in download. D - Deletes entire existing PO. No line items are required in download. |
11 Allow Receive All $ | String 1 | 99 - 99 | Y/N |
Total Header Record bytes: 99
Field Number and Name | Type/Length | Column | Possible Values |
|---|---|---|---|
1 Record Type * | String 1 | 1 - 1 | D |
2 Item or Order * | String 18 | 2 - 19 | PLU, XREF. The package size and cost will be defaulted from the Vendor/SKU table if the value represents a Vendor/SKU, otherwise the package size and cost will be defaulted from the PLU table. |
3 Quantity | Decimal 6.3 | 20 - 28 | |
4 Cost | Decimal 4.2 | 29 - 34 | Not used. |
Total Detail Record bytes: 34