Department File Update Records
File: [DEPTTXN.ASC]
POS Filename: DEPT.DEPT
Empty fields in the DEPTTXN.ASC file
When a field is left empty in the DPTTXN.ASC file, the corresponding store's data field (held within binary files or in the store's databases) will not be updated. This provides a way for the head office to update only certain fields without changing others. A field in the download file is empty when there is no data or characters between the comma separators (for example: “,,”) To clear out a string field or zero out numeric fields at the store, use the following conventions:
String fields: Use double quotation marks “”
Numeric fields: Use 0 (zero)
Field Number and Name | Field Type or Mask | Possible Values |
|---|---|---|
1 Update Type | Decimal 2.0 | 1 - Add 2 - Modify 3 - Delete 6 - Add-Only 99 - Delete existing departments before applying new transactions |
2 Department/Class * | Decimal 4.0 | |
3 Department Group | Decimal 3.0 | |
4 Description * | String 20 | |
5 Deposit | Decimal 5.2 | |
6 Allow Quantity | String 1 | Y/N or 1/0 |
7 Force Preset | String 1 | Y/N or 1/0 |
8 Positive Department | String 1 | Y/N or 1/0 |
9 Tax Table 1 | String 1 | Y/N or 1/0 |
10 Tax Table 2 | String 1 | Y/N or 1/0 |
11 Quantity Required | String 1 | Y/N or 1/0 |
12 Allow Decimal Quantity | String 1 | Y/N or 1/0 |
13 Future | String 1 | Y/N or 1/0 |
14 Future | String 1 | Y/N or 1/0 |
15 Cost Prompt Required | String 1 | C - Code D - Dollar |
16 Quantity Description | String 5 | |
17 Preset Department Amt. | Decimal 4.2 | |
18 Allow Returns | String 1 | Y/N or 1/0 |
19 Allow Discounts | String 1 | Y/N or 1/0 |
20 Deposit Description | String 12 | |
21 Tax Table 3 | String 1 | Y/N or 1/0 |
22 Tax Table 4 | String 1 | Y/N or 1/0 |
23 Scale Item | String 1 | Y/N or 1/0 |
24 Future | Decimal 3.0 | |
25 Future | String 3.0 | |
26 Future | String 1 | Y/N or 1/0 |
27 Allow Zero Price | String 1 | Y/N or 1/0 |
28 Authority Level | Decimal 1.0 | |
29 Maximum Unit Price | Decimal 5.2 | |
30 Print Slip | String 1 | Y/N or 1/0 |
31 Slip Advance | Decimal 2.0 | |
32 Slip Lines | Decimal 2.0 | |
33 # of Validations | Decimal 1.0 | 0 - 9 |
34 Tare Weight | Decimal 3.0 | |
35 Menu Number | Decimal 1.0 | |
36 Profile ID | Decimal 3.0 | Up to 250 ID's |
37 Mix/Match Number | String 12 | |
38 Mix/Match 2 | String 12 | |
39 Mix/Match 3 | String 12 | |
40 Mix/Match 4 | String 12 | |
41 Itemizer 1 | String 1 | Y/N or 1/0 |
42 Itemizer 1 Tax 1 | String 1 | Y/N or 1/0 |
43 Itemizer 1 Tax 2 | String 1 | Y/N or 1/0 |
44 Itemizer 1 Tax 3 | String 1 | Y/N or 1/0 |
45 Itemizer 1 Tax 4 | String 1 | Y/N or 1/0 |
46 Itemizer 2 | String 1 | Y/N or 1/0 |
47 Itemizer 2 Tax 1 | String 1 | Y/N or 1/0 |
48 Itemizer 2 Tax 2 | String 1 | Y/N or 1/0 |
49 Itemizer 2 Tax 3 | String 1 | Y/N or 1/0 |
50 Itemizer 2 Tax 4 | String 1 | Y/N or 1/0 |
51 Itemizer 3 | String 1 | Y/N or 1/0 |
52 Itemizer 3 Tax 1 | String 1 | Y/N or 1/0 |
53 Itemizer 3 Tax 2 | String 1 | Y/N or 1/0 |
54 Itemizer 3 Tax 3 | String 1 | Y/N or 1/0 |
55 Itemizer 3 Tax 4 | String 1 | Y/N or 1/0 |
56 Itemizer 4 | String 1 | Y/N or 1/0 |
57 Itemizer 4 Tax 1 | String 1 | Y/N or 1/0 |
58 Itemizer 4 Tax 2 | String 1 | Y/N or 1/0 |
59 Itemizer 4 Tax 3 | String 1 | Y/N or 1/0 |
60 Itemizer 4 Tax 4 | String 1 | Y/N or 1/0 |
61 Allow Employee Disc. | String 1 | Y/N or 1/0 |
62 Generate Coupon | String 1 | Y/N or 1/0 |
63 Auto Discount I.D. | Decimal 3.0 | Up to 999 |
64 Future | Decimal 2.0 | |
65 Minimum Price | Decimal 3.2 | |
66 PLU Required | String 1 | Y/N or 1/0 |
67 Allow in Layaway | String 1 | Y/N or 1/0 |
68 Print Regular Price | String 1 | Y/N or 1/0 |
69 Print Suggested Retail | String 1 | Y/N or 1/0 |
70 Tax Table 5 | String 1 | Y/N or 1/0 |
71 Tax Table 6 | String 1 | Y/N or 1/0 |
72 Tax Table 7 | String 1 | Y/N or 1/0 |
73 Tax Table 8 | String 1 | Y/N or 1/0 |
74 Tax Table 9 | String 1 | Y/N or 1/0 |
75 Tax Table 10 | String 1 | Y/N or 1/0 |
76 Tax Table 11 | String 1 | Y/N or 1/0 |
77 Tax Table 12 | String 1 | Y/N or 1/0 |
78 Tax Table 13 | String 1 | Y/N or 1/0 |
79 Tax Table 14 | String 1 | Y/N or 1/0 |
80 Tax Table 15 | String 1 | Y/N or 1/0 |
81 Tax Table 16 | String 1 | Y/N or 1/0 |
82 Remote Printer Number | Decimal 2.0 | 0 - 99 |
83 Remote Print Control | String 1 | Y/N or 1/0 Default N Y/1 if print entire transaction N/0 if print item only |
84 Employee Disc % | Decimal 3.3 | Percentage discount rate |
85 Loyalty Program ID 1 | Decimal 2.0 | 1 - 20 |
86 Loyalty Program ID 2 | Decimal 2.0 | 1 - 20 |
87 Loyalty Program ID 3 | Decimal 2.0 | 1 - 20 |
88 Loyalty Program ID 4 | Decimal 2.0 | 1 - 20 |
89 Allow Returns (WO Rcpt) | String 1 | Y/N or 1/0 |
90 Disallow Selling | String 1 | Y/N or 1/0 |
91 Disallow Exchanges | String 1 | Y/N or 1/0 |
92 Receipt Group ID | Decimal 3.0 | |
93 Receipt Group Description | String 20 |