Show TOC

Background documentationDiscount File Update Records

 

File: [DISCTXN.ASC]

POS Filename: DISCOUNT.DSC

SQL Table: Discount

Field Number and Name

Field Type or Mask

Possible Values

1 Update Type*

Decimal 2.0

1 - Add

2 - Modify

3 - Delete

99 - Delete discount file and rebuild from transactions

2 Store

Decimal 6.0

1 - 999999

3 Reg. Group

Decimal 2.0

1 - 99

4 Region

Decimal 2.0

1 - 99

5 Discount ID

Decimal 3.0

1 - 999

6 Description

String 20

7 Discount Type

Decimal 2.0

One of the discount types

8 Auto Preset

String 1

Y/N

9 $ Preset

Decimal 7.2

10 % Preset

Decimal 3.3

11 Tax Table 1

String 1

Y/N

12 Tax Table 2

String 1

Y/N

13 Tax Table 3

String 1

Y/N

14 Tax Table 4

String 1

Y/N

15 Maximum Discount %

Decimal 3.3

16 Affect Net Sales

String 1

Y/N

17 Item On Item

String 1

Y/N

18 Transaction On Transaction

String 1

Y/N

19 Transaction On Item

String 1

Y/N

20 Choice Type ID

Decimal 2.0

21 Menu ID

Decimal 2.0

22 Supervisor Required

String 1

Y/N

23 Authority Level

Decimal 1.0

24 Password Required

String 1

Y/N

25 Signature Line 1 ID

Decimal 3.0

26 Dual Receipt

String 1

Y/N

27 Print Slip

String 1

Y/N

28 Buffer Slip

String 1

Y/N

29 Number of Lines to Advance

Decimal 2.0

30 Number of Lines to Print

Decimal 2.0

31 Validation Required

Blank

32 Validation Message 1 ID

Decimal 3.0

33 Validation Message 2 ID

Decimal 3.0

34 Validation Message 3 ID

Decimal 3.0

35 Validation Message 4 ID

Decimal 3.0

36 Ref. Prompt

String 20

37 Minimum Reference Number Length

Decimal 2.0

38 Maximum Reference Number Length

Decimal 2.0

39 Print Reference Prompt

String 1

Y/N

40 Check Digit ID

Decimal 2.0

41 Profile Prompt ID

Decimal 2.0

42 Family Code ID

Decimal 3.0

43 Discount Threshold

Decimal 7.2

44 Discount Limit

Decimal 3.0

45 Future Use $

Blank

46 Signature Line 2 ID

Decimal 3.0

47 Apply Rule/Promotion Rules

Decimal 2.0

48 Print Receipt

String 1

Y/N

49 Discount Extended Price

String 1

Y/N

50 Tax Table 5

String 1

Y/N

51 Tax Table 6

String 1

Y/N

52 Tax Table 7

String 1

Y/N

53 Tax Table 8

String 1

Y/N

54 Tax Table 9

String 1

Y/N

55 Tax Table 10

String 1

Y/N

56 Tax Table 11

String 1

Y/N

57 Tax Table 12

String 1

Y/N

58 Tax Table 13

String 1

Y/N

59 Tax Table 14

String 1

Y/N

60 Tax Table 15

String 1

Y/N

61 Tax Table 16

String 1

Y/N

62 Indent Spaces

Decimal 2.0

63 Apply Type

Decimal 2.0

64 Maximum Discount $

Decimal 7.2

65 Maximum Discount Override

Decimal 1.0

1/0

66 Itemizer 1

Decimal 1.0

1/0

67 Itemizer 2

Decimal 1.0

1/0

68 Itemizer 3

Decimal 1.0

1/0

69 Itemizer 4

Decimal 1.0

1/0

70 Apply Method

Decimal 2.0

0 – Discount on Previous Items

1 – Discount on Total of Transaction

2 – Discount at Item Entry

71 Quantity Threshold

Decimal 9.0

72 Linked Discount Number

Decimal 3.0

0 – 999

73 Threshold Apply Control

Decimal 1.0

1/0

74 Quantity Threshold Control

Decimal 1.0

1/0

75 Transaction Item Discount Control

Decimal 1.0

1/0

76 Discount on All Items

String 1

Y/N

77 Loyalty Threshold

Decimal 9.0

78 Loyalty Program ID

Decimal 9.0

79 Points Redeemed

Decimal 9.0

80 Use Discount Inclusion/ Exclusion ID

String 13

81 Start Date

String 10

yyyy/mm/dd (optional)

82 Stop Date

String 10

yyyy/mm/dd (optional)

83 Start Tme

String 5

hh:mm (optional)

84 Stop Time

String 5

hh:mm (optional)

85 Link Control

Decimal 1.0

0 – None

1 – Stop link when one discount applies

2 – Apply all discounts in link

86 On Items with Transaction Discount

String 1

Y/N

The Default is Y

When this option is set to Y, the transaction discount applies to all items in the transaction. When it is set to N, the transaction discount applies to those items not already having a transaction discount.

87 Prompt at the Beginning of TXN

String 1

Y/N

88 Print Description

String 1

Y/N

89 Item Best Price

Decimal 2.0

1 - Retail

2 - Original

3 - Suggested Retail

4 - Promotion

5 - Level

90 Affect Base Price

String 1

Y/N or 1/0

91 Allow Price Override

String 1

Y/N or 1/0

92 Point Redemption Minimum

Decimal

Minimum number or points that can be redeemed.

93 Point Dollar Value

Decimal 6.2

Money value of one point

94 Number of days before and after birthday that customer can receive a birthday gift

Decimal 3.0

Applicable only if field 95, Birthday Discount Method, is set to 0.

95 Birthday Discount Method

String 1

0 - By days

1 - By month

96 Pricing Target ID

This discount applies to this pricing target group

97 Free Membership Renewal

String 1

Y/N

98 Redeem All Available Points

String 1

Y/N

99 Language ID

Configured language ID

Optional

100 Language Parm/Directory Name

String 8

Optional

101 One Item Only

String 1

Y/N

Restricts a coupon or discount to a single quantity of an item even if the Qty key is used when the item is entered. This option is applicable to Item Discount only.

102 Criteria Set

String 13

Inclusion/Exclusion ID. This defines the set of items to be considered the Criteria Set for the discount. These items must be purchased to obtain the discount. Either use field 103, Use Threshold on Criteria Set, or field 104, Criteria Count, to determine how the criteria set is to be used. This option only applies to transaction discounts. Field 70, Apply Method, must be set to 1 - Discount on Total of Transaction.

103 Use Threshold on Criteria Set

String 1

Y/N

Y – If set indicates that field 43, Discount Threshold, is used on the Criteria Set, which must be specified in field 102

N – Indicates that the amount specified in field 43, Discount Threshold, applies to all the items in the transaction and not just the items specified in the Criteria Set. This option only applies to transaction discounts. Field 70, Apply Method, must be set to 1 - Discount on Total of Transaction.

104 Criteria Count

Decimal 5.0

1 – 3200

This count indicates the number of items that must be purchased from the Criteria Set to order to apply the discount. Zero indicates that no count checking is required. This option cannot be used if field 103, Use threshold on Criteria Set, is set to Y. This option only applies to transaction discounts. Field 70, Apply Method, must be set to 1 - Discount on Total of Transaction.

105 Discount Set

String 13

Inclusion/Exclusion ID. This option defines the set of items that can be discounted. This option only applies to transaction discounts. Field 70, Apply Method, must be set to 1 - Discount on Total of Transaction.

106 Discount Set Method

Decimal 1.0

This option indicates how the discount is to be applied to items in field 105, Discount Set.

0 – Not applicable

1 – Single Highest Priced Item The discount is to be applied to the highest priced item in the Discount Set.

2 – Single Lowest Priced Item The discount is to be applied to the lowest priced item in the Discount Set.

3 – The discount is to be applied to all items in the set. For % discounts each item in the discount set gets a % off. For $ discounts, the discount (only one $ discount) is applied over all the items. This option only applies to transaction discounts. Field 70, Apply Method, must be set to 1 - Discount on Total of Transaction.

107 Apply To Setting for an Exchange Transaction

Decimal 1.0

This option controls the application of a transaction discount in an exchange transaction. An exchange transaction is defined as one where the returned items have been recorded using either the Exchange function (Manager code 212) or the Multi-Exchange function (Manager code 213). It indicates whether the discount is applied to purchased items or all items.

0 – The discount is applied to purchased items only.

1 - The discount is applied to returned items only.

2 – The discount is applied to the net total of purchased items minus returned items. The net total amount and quantity of items are also used when checking whether any required discount threshold has been met.

3 – The discount is applied separately to the subtotal of purchased items and the subtotal of returned items. The separate subtotals (amounts and quantities) are also used when checking whether any required discount threshold has been met.

108 Apply To Setting for a Manual Return Transaction

Decimal 1.0

This option controls the application of a transaction discount in a manual return. It indicates whether the discount is applied to purchased items or all items.

0 - The discount is applied to purchased items only.

1 - The discount is applied to returned items only.

2 - The discount is applied to the net total of purchased items minus returned items. The net total amount and quantity of items are also used when checking whether any required discount threshold has been met.

3 - The discount is applied separately to the subtotal of purchased items and the subtotal of returned items. The separate subtotals (amounts and quantities) are also used when checking whether any required discount threshold has been met.