Show TOC

Background documentationMix Match Table

 

File: MIXMATCH.ASC or NNNNRR00.MXA

Field Number and Name

Field Type or Mask

Possible Values

1 Mix Match ID

String 12

12 digit alphanumeric - Maximum of 250 different mix match ID’s.

2 Alt.1 Qty

Decimal 3.0

3 Or More: Allow greater than Alt. 1

String 1

If set, indicates the Or More type of mix match (Buy 3 or more and get a discount).

Space - None

* – Or more extended price

% - Or more percent off specified

+ - Or more unit price specified

A – Or more (unit $ off). The $OFF field is applied to the unit price of items to be discounted.

4 Alt. 1 Sell Price

Decimal 3.2

5 Alt. 1 Match Price

Decimal 3.2

6 Alt. 1 Operator

String 2

EQ, GT, GE, LT, LE, ' '

7 Mix Match Desc.

String 20

8 Alt. 2 Qty

Decimal 3.0

9 Alt. 2 Sell Price

Decimal 3.2

10 Alt. 2 $ Off

Decimal 3.2

11 Alt. 2 % Off

Decimal 3.0

Up to 100%

12 Alt. 2 Match Price

Decimal 3.2

13 Alt. 2 Operator

String 1

EQ, GT, GE, LT, LE, ' '

14 Match SKU

String 1

Y/N or 1/0

15 Filler

Y/N or 1/0

16 Unique SKU

String 1

Y/N or 1/0

17 Filler

18 Filler

19 Alt. 3 Qty

Decimal 3.0

20 Alt. 3 Sell Price

Decimal 3.2

21 Alt. 3 $ Off

Decimal 3.2

22 Alt. 3 % Off

Decimal 3.0

Up to 100%

23 Alt. 3 Match Price

Decimal 3.2

24 Alt. 3 Operator

String 1

EQ, GT, GE, LT, LE, ' '

25 Alt. 4 Qty

Decimal 3.0

26 Alt. 4 Sell Price

Decimal 3.2

27 Alt. 4 $ Off

Decimal 3.2

28 Alt. 4 % Off

Decimal 3.0

Up to 100%

29 Alt. 4 Match Price

Decimal 3.2

30 Alt. 4 Operator

String 1

EQ, GT, GE, LT, LE, ' '

31 Alt. 5 Qty

Decimal 3.0

32 Alt. 5 Sell Price

Decimal 3.2

33 Alt. 5 $ Off

Decimal 3.2

34 Alt. 5 % Off

Decimal 3.0

Up to 100%

35 Alt. 5 Match Price

Decimal 3.2

36 Alt. 5 Operator

String 1

EQ, GT, GE, LT, LE, ' '

37 Alt. 6 Qty

Decimal 3.0

38 Alt. 6 Sell Price

Decimal 3.2

39 Alt. 6 $ Off

Decimal 3.2

40 Alt. 6 % Off

Decimal 3.0

Up to 100%

41 Alt. 6 Match Price

Decimal 3.2

42 Alt. 6 Operator

String 1

EQ, GT, GE, LT, LE, ' '

43 Alt. 7 Qty

Decimal 3.0

44 Alt. 7 Sell Price

Decimal 3.2

45 Alt. 7 $ Off

Decimal 3.2

46 Alt. 7 % Off

Decimal 3.0

Up to 100%

47 Alt. 7 Match Price

Decimal 3.2

48 Alt. 7 Operator

String 1

EQ, GT, GE, LT, LE, ' '

49 Alt. 8 Qty

Decimal 3.0

50 Alt. 8 Sell Price

Decimal 3.2

51 Alt. 8 $ Off

Decimal 3.2

52 Alt. 8 % Off

Decimal 3.0

Up to 100%

53 Alt. 8 Match Price

Decimal 3.2

54 Alt. 8 Operator

String 1

EQ, GT, GE, LT, LE, ' '

55 Alt. 9 Qty

Decimal 3.0

56 Alt. 9 Sell Price

Decimal 3.2

57 Alt. 9 $ Off

Decimal 3.2

58 Alt. 9 % Off

Decimal 3.0

Up to 100%

59 Alt. 9 Match Price

Decimal 3.2

60 Alt. 9 Operator

String 1

EQ, GT, GE, LT, LE, ' '

61 Start Date

String 8

yy/mm/dd

62 Stop Date

String 8

yy/mm/dd

63 Apply Discount to Alt.#

Decimal 1.0

64 Filler

65 Must Complete Mix Match

String 1

Y/N or 1/0

66 Alt. 1 % Off

Decimal 2.0

67 Store ID $

Decimal 4.0

68 Filler

Decimal 2.0

69 Filler

Decimal 2.0

70 MM Discount Desc.

String 20

71 MMGRPQTY1

Decimal 2

72 MMGRPQTY2

Decimal 2

73 MMGRPQTY3

Decimal 2

74 MMGRPQTY4

Decimal 2

75 Match User Flag

String 1

Y/N or 1/0

76 Unique User Flag

String 1

Y/N or 1/0

77 Policy ID

Decimal 2.0

0 - 99

78 Unused

String 1

Not used

79 At Total

String 1

Y/N or 1/0

80 Discount on Lower Price

String 1

Y/N or 1/0

81 By Merchandise Type

String 1

Y/N or 1/0

82 Vendor

String 9

83 User Flag 1

String 10

84 Department Number

Decimal 4.0

85 Department Group Number

Decimal 4.0

86 Category

Decimal 4.0

87 Global Inclusion/Exclusion ID

String 13

ID for Inclusion/Exclusion rules.

88 Inclusion/Exclusion ID for Alt. Level #1

String 13

ID for Inclusion/Exclusion rules.

89 Inclusion/Exclusion ID for Alt. Level #2

String 13

ID for Inclusion/Exclusion rules.

90 Inclusion/Exclusion ID for Alt. Level #3

String 13

ID for Inclusion/Exclusion rules.

91 Inclusion/Exclusion ID for Alt. Level #4

String 13

ID for Inclusion/Exclusion rules.

92 Inclusion/Exclusion ID for Alt. Level #5

String 13

ID for Inclusion/Exclusion rules.

93 Inclusion/Exclusion ID for Alt. Level #6

String 13

ID for Inclusion/Exclusion rules.

94 Inclusion/Exclusion ID for Alt. Level #7

String 13

ID for Inclusion/Exclusion rules.

95 Inclusion/Exclusion ID for Alt. Level #8

String 13

ID for Inclusion/Exclusion rules.

96 Inclusion/Exclusion ID for Alt. Level #9

String 13

hh:mm (24 hour)

97 Start Time

String 5

hh:mm (24 hour)

98 Stop Time

String 5

hh:mm (24 hour)

99 Recalculate Item Discounts

String 1

Y/N or 1/0

Y - Recalculate the item discounts after the mix match is applied.

N - The item discount remains the same after the mix match is applied.

100 Pricing Target Type

Decimal 1.0

0 - All

1 - 9 - Pricing Target Type

101 Threshold Amount

Decimal 7.2

If set with a threshold, then the transaction total must be greater than or equal to this amount for the mix match to be considered. If a threshold is specified, field 79 - At Total must be set to Y. The threshold is only considered once; that is if the transaction total is doubled, you do not get 2 occurrences of the mix match. If the threshold amount is met, then all occurrences of the mix match are realized or if field 103 - Repeat Count is set, this count determines the maximum number of occurrences that can be realized. If this is set to zero no threshold amount checking is done.

102 Used by Transaction Level Pricing Rules

String 1

Y/N

Y - This indicates that the mix match will be processed during the processing of Pricing Rules (Transaction Level). This mix match will not be processed during the Pricing Rules (Transaction Level) process If set, the field 79 - At Total option must be set to Y.

N - This indicates that the mix match will be processed when items are scanned or when the Total key is pressed. The mix match will not be part of the Pricing Rules (Transaction Level) process. See Pricing Rules in the Configurator on the Transaction Functions tab. Transaction Level Pricing Rules define a set of rules for applying mix match and transaction discounts at the end of a sale. Rules can be defined to compare the resulting discounts for a number of discounts and choose which one or ones to apply (for example, the better or worse discount).

103 Repeat Count

Decimal 5.0

0 - 32000

This number indicates the number of occurrences of the mix match that will be applied. This option is only applicable when field 65 - Complete Mix Match is set to Y. This option does not work with the Or More type of mix matches. If a number is specified here, field 79 - At Total must be set to Y. If set to zero all occurrences of the mix match will be realized.

104 Alt. 1 $ Off

Decimal 3.2

Money off