Show TOC

Background documentationMix Match Table Update

 

File: MIXMTXN.ASC

Field Number and Name

Field Type or Mask

Possible Values

1 Update Type *

Decimal 2.0

1 - Add

2 - Modify

3 - Delete

99 - Delete File

2 Mix Match ID

String 12

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

3 Alt.1 Qty

Decimal 3.0

4 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.

5 Alt. 1 Sell Price

Decimal 3.2

6 Alt. 1 Match Price

Decimal 3.2

7 Alt. 1 Operator

String 2

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

8 Mix Match Desc.

String 20

9 Alt. 2 Qty

Decimal 3.0

10 Alt. 2 Sell Price

Decimal 3.2

11 Alt. 2 $ Off

Decimal 3.2

12 Alt. 2 % Off

Decimal 2.0

Up to 100%

13 Alt. 2 Match Price

Decimal 3.2

14 Alt. 2 Operator

String 1

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

15 Match SKU

String 1

Y/N or 1/0

16 Filler

String 1

Y/N or 1/0

17 Unique SKU

String 1

Y/N or 1/0

18 Filler

String 1

19 Filler

String 1

20 Alt. 3 Qty

Decimal 3.0

21 Alt. 3 Sell Price

Decimal 3.2

22 Alt. 3 $ Off

Decimal 3.2

23 Alt. 3 % Off

Decimal 2.0

Up to 100%

24 Alt. 3 Match Price

Decimal 3.2

25 Alt. 3 Operator

String 1

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

26 Alt. 4 Qty

Decimal 3.0

27 Alt. 4 Sell Price

Decimal 3.2

28 Alt. 4 $ Off

Decimal 3.2

29 Alt. 4 % Off

Decimal 2.0

Up to 100%

30 Alt. 4 Match Price

Decimal 3.2

31 Alt. 4 Operator

String 1

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

32 Alt. 5 Qty

Decimal 3.0

33 Alt. 5 Sell Price

Decimal 3.2

34 Alt. 5 $ Off

Decimal 3.2

35 Alt. 5 % Off

Decimal 2.0

Up to 100%

36 Alt. 5 Match Price

Decimal 3.2

37 Alt. 5 Operator

String 1

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

38 Alt. 6 Qty

Decimal 3.0

39 Alt. 6 Sell Price

Decimal 3.2

40 Alt. 6 $ Off

Decimal 3.2

41 Alt. 6 % Off

Decimal 2.0

Up to 100%

42 Alt. 6 Match Price

Decimal 3.2

43 Alt. 6 Operator

String 1

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

44 Alt. 7 Qty

Decimal 3.0

45 Alt. 7 Sell Price

Decimal 3.2

46 Alt. 7 $ Off

Decimal 3.2

47 Alt. 7 % Off

Decimal 2.0

Up to 100%

48 Alt. 7 Match Price

Decimal 3.2

49 Alt. 7 Operator

String 1

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

50 Alt. 8 Qty

Decimal 3.0

51 Alt. 8 Sell Price

Decimal 3.2

52 Alt. 8 $ Off

Decimal 3.2

53 Alt. 8 % Off

Decimal 2.0

Up to 100%

54 Alt. 8 Match Price

Decimal 3.2

55 Alt. 8 Operator

String 1

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

56 Alt. 9 Qty

Decimal 3.0

57 Alt. 9 Sell Price

Decimal 3.2

58 Alt. 9 $ Off

Decimal 3.2

59 Alt. 9 % Off

Decimal 2.0

Up to 100%

60 Alt. 9 Match Price

Decimal 3.2

61 Alt. 9 Operator

String 1

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

62 Start Date

String 8

yy/mm/dd

63 Stop Date

String 8

yy/mm/dd

64 Apply Discount to Alt.#

Decimal 1

65 Filler

String 1

66 Complete Mix Match

String 1

Y/N or 1/0

67 Alt. 1 % Off

Decimal 2.0

68 Store I.D. $

Decimal 4.0

69 Filler

Decimal 2.0

70 Filler

Decimal 2.0

71 MM Discount Desc.

String 20

72 MMGRPQTY1

Decimal 2.0

73 MMGRPQTY2

Decimal 2.0

74 MMGRPQTY3

Decimal 2.0

75 MMGRPQTY4

Decimal 2.0

76 Match User Flag

String 1

Y/N or 1/0

77 Unique User Flag

String 1

Y/N or 1/0

78 Policy ID

Decimal 2.0

0 - 99

79 Unused

String 1

Not used

80 At Total

String 1

Y/N or 1/0

81 Disc On Lower Price

String 1

Y/N or 1/0

82 By Merch Type

String 1

Y/N or 1/0

83 Vendor

String 9

84 User Flag 1

String 10

85 Department Number

Decimal 4.0

86 Department Group Number

Decimal 4.0

87 Category

Decimal 4.0

88 Global Inclusion/Exclusion Id

String 13

ID for Inclusion/Exclusion rules.

89 Inclusion/Exclusion Id for “Alt Level #1”

String 13

ID for Inclusion/Exclusion rules.

90 Inclusion/Exclusion Id for “Alt Level #2”

String 13

ID for Inclusion/Exclusion rules.

91 Inclusion/Exclusion Id for “Alt Level #3”

String 13

ID for Inclusion/Exclusion rules.

92 Inclusion/Exclusion Id for “Alt Level #4”

String 13

ID for Inclusion/Exclusion rules.

93 Inclusion/Exclusion Id for “Alt Level #5”

String 13

ID for Inclusion/Exclusion rules.

94 Inclusion/Exclusion Id for “Alt Level #6”

String 13

ID for Inclusion/Exclusion rules.

95 Inclusion/Exclusion Id for “Alt Level #7”

String 13

ID for Inclusion/Exclusion rules.

96 Inclusion/Exclusion Id for “Alt Level #8

String 13

ID for Inclusion/Exclusion rules.

97 Inclusion/Exclusion Id for “Alt Level #9”

String 13

ID for Inclusion/Exclusion rules.

98 Start Time

String 5

hh:mm (24 hour)

99 Stop Time

String 5

hh:mm (24 hour)

100 Recalculate Item Discounts

String 1

Y/N

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

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

101 Pricing Target Type

Decimal 1.0

0 - All

# - Pricing Target Type

102 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.

103 Used by Transaction Level Pricing Rules

String 1

Y/N

Y - This indicates that the mix match will be processed during the processing of Transaction Level Pricing Rules only and is part of the Pricing Rules process. It indicates that the mix match will not be processed as items are scanned and not with the other field 79 - At Total mix matches. 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, depending on the value of field 79 - At Total.

104 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 for when field 66 - Complete Mix Match is set to Y. This option does not work with the Or More type of mix match. 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.

105 Alt. 1 $ Off

Decimal 3.2

Money off