Show TOC

Background documentationSalesperson Productivity ASCII File

 

The utility CVSPD creates the Salesperson Productivity ASCII file from the *SPD binary files. The name of the ASCII file is user-defined.

Fixed Length ASCII Output

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 LOCAL.INI.It is filled up with spaces if no store group ID is specified.

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