The utility CVSPD
creates the Salesperson Productivity ASCII
file from the *SPD
binary files. The name of the ASCII
file is user-defined.
Field | Columns | Size | Values |
---|---|---|---|
1 StoreNumber | 1 - 4 | 4 n | |
2 Salesperson | 5 - 10 | 6 n | |
3 Business Date | 11 - 16 | 6 n | YYMMDD |
4 Positive Flag | 17 - 17 | 1 a/n | ' ' ' - ' |
5 Gross Merch Sales $ | 18 - 27 | 8.2 n | |
6 Positive Flag | 28 - 28 | 1 a/n | ' ' ' - ' |
7 Gross Non-Merch Sales $ | 29 - 38 | 8.2 n | |
8 Positive Flag | 39 - 39 | 1 a/n | ' ' ' - ' |
9 Return Amount $ | 40 - 49 | 8.2 n | Merch and Non-Merch |
10 Positive Flag | 50 - 50 | 1 a/n | ' ' ' - ' |
11 Discount Amount $ | 51 - 60 | 8.2 n | Merch and Non-Merch |
12 Positive Flag | 61 - 61 | 1 a/n | ' ' ' - ' |
13 Net Merch Sales $ | 62 - 71 | 8.2 n | |
14 Positive Flag | 72 - 72 | 1 a/n | ' ' ' - ' |
15 Net Non-Merch Sales $ | 73 - 82 | 8.2 n | |
16 Customer Count | 83 - 92 | 10 n | |
17 One Item Sales Count | 93 - 102 | 10 n | |
18 Two Item Sales Count | 103 - 112 | 10 n | |
19 Two+ Item Sales Count | 113 - 122 | 10 n | |
20 Positive Flag | 123 - 123 | 1 a/n | ' ' ' - ' |
21 Loyalty Program 1 Sales $ | 124 - 133 | 8.2 n | |
22 Positive Flag | 134 - 134 | 1 a/n | ' ' ' - ' |
23 Loyalty Program 2 Sales $ | 135 - 144 | 8.2 n | |
24 Positive Flag | 145 - 145 | 1 a/n | ' ' ' - ' |
25 Loyalty Program 3 Sales $ | 146 - 155 | 8.2 n | |
26 Positive Flag | 156 - 156 | 1 a/n | ' ' ' - ' |
27 Loyalty Program 4 Sales $ | 157 - 166 | 8.2 n | |
28 Positive Flag | 167 - 167 | 1 a/n | ' ' ' - ' |
29 Loyalty Program 5 Sales $ | 168 - 177 | 8.2 n | |
30 Positive Flag | 178 - 178 | 1 a/n | ' ' ' - ' |
31 Loyalty Program 6 Sales $ | 179 - 188 | 8.2 n | |
32 Positive Flag | 189 - 189 | 1 a/n | ' ' ' - ' |
33 Loyalty Program 7 Sales $ | 190 - 199 | 8.2 n | |
34 Positive Flag | 200 - 200 | 1 a/n | ' ' ' - ' |
35 Loyalty Program 8 Sales $ | 201 - 210 | 8.2 n | |
36 Positive Flag | 211 - 211 | 1 a/n | ' ' ' - ' |
37 Loyalty Program 9 Sales $ | 212 - 221 | 8.2 n | |
38 Positive Flag | 222 - 222 | 1 a/n | ' ' ' - ' |
39 Loyalty Program 10 Sales $ | 223 - 232 | 8.2 n | |
40 Positive Flag | 233 - 233 | 1 a/n | ' ' ' - ' |
41 Loyalty Program 11 Sales $ | 234 - 243 | 8.2 n | |
42 Positive Flag | 244 - 244 | 1 a/n | ' ' ' - ' |
43 Loyalty Program 12 Sales $ | 245 - 254 | 8.2 n | |
44 Positive Flag | 255 - 255 | 1 a/n | ' ' ' - ' |
45 Loyalty Program 13 Sales $ | 256 - 265 | 8.2 n | |
46 Positive Flag | 266 - 266 | 1 a/n | ' ' ' - ' |
47 Loyalty Program 14 Sales $ | 267 - 276 | 8.2 n | |
48 Positive Flag | 277 - 277 | 1 a/n | ' ' ' - ' |
49 Loyalty Program 15 Sales $ | 278 - 287 | 8.2 n | |
50 Positive Flag | 288 - 288 | 1 a/n | ' ' ' - ' |
51 Loyalty Program 16 Sales $ | 289 - 298 | 8.2 n | |
52 Positive Flag | 299 - 299 | 1 a/n | ' ' ' - ' |
53 Loyalty Program 17 Sales $ | 300 - 309 | 8.2 n | |
54 Positive Flag | 310 - 310 | 1 a/n | ' ' ' - ' |
55 Loyalty Program 18 Sales $ | 311 - 320 | 8.2 n | |
56 Positive Flag | 321 - 321 | 1 a/n | ' ' ' - ' |
57 Loyalty Program 19 Sales $ | 322 - 331 | 8.2 n | |
58 Positive Flag | 332 - 332 | 1 a/n | ' ' ' - ' |
59 Loyalty Program 20 Sales $ | 333 - 342 | 8.2 n | |
60 Store group ID | 343 - 362 | 20 a/n | The last field contains the store group ID specified in |
61 Business Date (Y2K) | 363 – 370 | YYYYMMDD | |
62 Store ID Extension | 371 – 374 | 4 n | High order digits for Store ID Extension with leading zeros. |
63 Salesperson Id Extension | 375 – 376 | 2 n | High order digits for Salesperson ID Extension with leading zeros. |
Total bytes: 376