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