Fixed column positions, no decimals in numeric, automatically converted to 2 decimal places.
Column |
Field |
Alphanumeric |
1-14 |
Part Number |
A |
15-22 |
Description |
A |
23-31 |
Price 1 |
N |
32-40 |
Price 2 |
N |
41-49 |
Price 3 |
N |
50-58 |
Price 4 |
N |
59-67 |
Price 5/Cost |
N |
69-77 |
Core Value |
N |
Fixed column positions, decimals in the numeric values are found, and handled. Values to 2 decimal places.
Column |
Field |
Alphanumeric |
1-28 |
Part Number |
A |
29-69 |
Description |
A |
70-77 |
Price 1 |
N |
Fixed column positions, decimals in the numeric values are found, and handled. Values to 2 decimal places.
Column |
Field |
Alphanumeric |
1-18 |
Part Number |
A |
19-25 |
Price 1 |
N |
26-64 |
Description |
A |
Column |
Field |
Alphanumeric |
Notes |
1-28 |
Part Number |
A - 28 char |
Upper case |
29-69 |
Part Description |
A - 41 char |
Upper case |
70-77 |
Price 1 |
N - 8.0 |
No decimals; assumption is that last 2 digits are after the decimal; e.g. $100.00 would be 00010000 |