PLU File Update Records
File: [PLUTXN.ASC or NNNNRR00.PAT]
POS Filename: PLUDATA.PLU
Empty fields in the PLUTXN.ASC file
When a field is left empty in the PLUTXN.ASC file, the corresponding store's data field (held within binary files or in the store's database) 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)
Fields after Tax Table #2 may be omitted if they are not used. Default NO unless otherwise noted. To delete a PLU record, only field #1 and field #2 are required.
Field Number and Name | Field Type or Mask | Possible Values |
|---|---|---|
1 Update Type * | Decimal 2.0 | 1 - Add 2 - Modify 3 - Delete 4 - Modify all fields except retail price. 5 - Modify the retail price if it has not been changed at store. 6 - Add only. The record is not updated if a record already exists. 7 - Price update only. If the item already exists and Update Type 7 is used to update the price along with other fields, such as PLU description or department, only the price will be changed and all the other fields will remain unchanged. If the item does not already exist, then Update Type 7 functions as Update Type 1 and adds the record to the database along with all the other fields that were provided in the 10 - Add a record without pre-checking if it already exists. If it already exists, update, otherwise add. 98 - Reset the mix match ID in all PLU records to zero for a specified mix match ID. If Update Type 98 is used, the next field contains the mix match ID. This is used to remove mix matches from all PLU records (instead of having to create one record for each PLU). 99 - Delete the existing PLU file and rebuild it from transactions. |
2 PLU * | String 18 | PLU If the Update Type is 98; this second field contains the mix match ID. If the mix match ID is set to zero all mix match ID fields in all PLU records will be set to zero. |
3 Old PLU | String 18 | Used when changing PLU number. |
4 Department | Decimal 4.0 | |
5 PLU Description | String 40 | |
6 Retail Price | Decimal 6.2 | |
7 Mix Match ID | String 12 | |
8 Tax Table 1 | String 1 | Y/N or 1/0 |
9 Tax Table 2 | String 1 | Y/N or 1/0 |
10 Link Item Flag | String 1 | Y/N or 1/0 |
11 Discountable | String 1 | Y/N or 1/0 Default Y |
12 Commission ID $ | Decimal 1.0 | |
13 Vendor ID | String 9 | |
14 User Flag 1 | String 10 | |
15 Prompt ID | Decimal 3.0 | Up to 250 ID's |
16 Family Code | Decimal 3.0 | |
17 Frequent Buyer Code $ | Decimal 3.0 | |
18 Use Department Flags | String 1 | Y/N or 1/0 (See Below) |
19 Scale Item | String 1 | Y/N or 1/0 |
20 Returnable | String 1 | Y/N or 1/0 Default Y |
21 Coupon Item | String 1 | |
22 Tax Table 3 | String 1 | Y/N or 1/0 |
23 Tax Table 4 | String 1 | Y/N or 1/0 |
24 Itemizer 1 | String 1 | Y/N or 1/0 |
25 Itemizer Tax 1 | String 1 | Y/N or 1/0 |
26 Itemizer Tax 2 | String 1 | Y/N or 1/0 |
27 Itemizer Tax 3 | String 1 | Y/N or 1/0 |
28 Itemizer Tax 4 | String 1 | Y/N or 1/0 |
29 Activation Date | String 8 | yy/mm/dd |
30 Tare Weight | Decimal 3.0 | |
31 Has Cross Ref. PLU | String 1 | Y/N or 1/0 |
32 Has Quantity Price | String 1 | Y/N or 1/0 |
33 Has Level Price | String 1 | Y/N or 1/0 |
34 Mix/Match 2 | String 12 | |
35 Mix/Match 3 | String 12 | |
36 Mix/Match 4 | String 12 | |
37 Itemizer 2 | String 1 | Y/N or 1/0 |
38 Itemizer 2 Tax 1 | String 1 | Y/N or 1/0 |
39 Itemizer 2 Tax 2 | String 1 | Y/N or 1/0 |
40 Itemizer 2 Tax 3 | String 1 | Y/N or 1/0 |
41 Itemizer 2 Tax 4 | String 1 | Y/N or 1/0 |
42 Itemizer 3 | String 1 | Y/N or 1/0 |
43 Itemizer 3 Tax 1 | String 1 | Y/N or 1/0 |
44 Itemizer 3 Tax 2 | String 1 | Y/N or 1/0 |
45 Itemizer 3 Tax 3 | String 1 | Y/N or 1/0 |
46 Itemizer 3 Tax 4 | String 1 | Y/N or 1/0 |
47 Itemizer 4 | String 1 | Y/N or 1/0 |
48 Itemizer 4 Tax 1 | String 1 | Y/N or 1/0 |
49 Itemizer 4 Tax 2 | String 1 | Y/N or 1/0 |
50 Itemizer 4 Tax 3 | String 1 | Y/N or 1/0 |
51 Itemizer 4 Tax 4 | String 1 | Y/N or 1/0 |
52 Verify Price When Sold | String 1 | Y/N or 1/0 |
53 Quantity Description | String 10 | |
54 Limited Quantity | Decimal 3.0 | |
55 Item Size | Decimal 4.3 | |
56 Employee Disc. Allowed | String 1 | Y/N or 1/0 |
57 Suggested Retail (SRP) | Decimal 6.2 | |
58 User Flag 2 $ | String 10 | |
59 User Flag 3 $ | String 10 | |
60 User Flag 4 $ | String 10 | |
61 User Flag 5 $ | String 10 | |
62 User Flag 6 $ | String 10 | |
63 Generate Coupon ID# | Decimal 2 | |
64 Auto Disc. ID# | Decimal 3.0 | |
65 Filler $ | Decimal 4.0 | |
66 Filler $ | Decimal 2.0 | |
67 Filler $ | Decimal 2.0 | |
68 Quantity Mode | String 1 | 0 - Allowed 1 - Required 2 - Not Allowed |
69 Selling Quantity | Decimal 3.0 | |
70 Allow in Layaways | String 1 | Y/N or 1/0 |
71 Match MFG Code | String 1 | Y/N or 1/0 |
72 Tax Table 5 | String 1 | Y/N or 1/0 |
73 Tax Table 6 | String 1 | Y/N or 1/0 |
74 Tax Table 7 | String 1 | Y/N or 1/0 |
75 Tax Table 8 | String 1 | Y/N or 1/0 |
76 Tax Table 9 | String 1 | Y/N or 1/0 |
77 Tax Table 10 | String 1 | Y/N or 1/0 |
78 Tax Table 11 | String 1 | Y/N or 1/0 |
79 Tax Table 12 | String 1 | Y/N or 1/0 |
80 Tax Table 13 | String 1 | Y/N or 1/0 |
81 Tax Table 14 | String 1 | Y/N or 1/0 |
82 Tax Table 15 | String 1 | Y/N or 1/0 |
83 Tax Table 16 | String 1 | Y/N or 1/0 |
84 Cost | Decimal 6.2 | |
85 Competitive Price 1 | Decimal 6.2 | |
86 Competitive Price 2 | Decimal 6.2 | |
87 Alternate Vendor 1 | String 9 | |
88 Alternate Vendor 2 | String 9 | |
89 Price Label Format ID | Decimal 3 | |
90 Shelf Label Format ID | Decimal 3 | |
91 Inventory Group ID | String 18 | |
92 Supplemental Length | Decimal 2.0 | 1 - 20 |
93 Loyalty Program ID 1 | Decimal 2.0 | 1 - 20 |
94 Loyalty Program ID 2 | Decimal 2.0 | 1 - 20 |
95 Loyalty Program ID 3 | Decimal 2.0 | 1 - 20 |
96 Loyalty Program ID 4 | Decimal 2.0 | 1 - 20 |
97 Allow Returns (WO Rcpt) | String 1 | Y/N or 1/0 |
98 Disallow Selling | String 1 | Y/N or 1/0 |
99 Disallow Exchanges | String 1 | Y/N or 1/0 |
100 Ordering Number | String 18 | |
101 Allow PLU Update | Decimal 1.0 | 0 - Allow 1 - Disallow |
102 Allow Price Update | Decimal 1.0 | 0 - Allow 1 - Disallow |
103 Measurement ID | String 1 | |
104 Used by Days | String 10 | |
105 Original Price | Decimal 6.2 | |
106 Non-merchandise ID | String 2 | 0 - 20 |
107 Non-merchandise selling quantity | Decimal 3.0 | |
108 Allow in Merchandise Type Mix Match | String 1 | Y/N or 1/0 |
109 Allow Department Update | Decimal 1.0 | 0 - Allow 1 - Disallow |
110 Size | Decimal 6.3 | The size (that is, the weight or volume) of the item |
111 Size Type | String 4 | Indicates the type of format of “Size” used for this item. For example, ML or GM |
112 Inventory Controlled | String 1 | Y/N or 1/0 Y – item is inventory controlled N – item is not inventory controlled Empty – If this field is left empty, the inventory control setting is unchanged from its previous value. |
113 Price Change Batch Identifier | See the Note below. | |
114 Use Deposit Fee | String 1 | Y/N or 1/0 |
115 Use Quantity from Parent PLU | String 1 | Y/N or 1/0 When the PLU is a linked item it uses the quantity from the parent PLU. |
116 MRP Controlled | Y/N | Maximum Retail Price: This option is used for pricing of items in India. |
117 Service Code | Decimal 5.0 | 0 - 99999 |
Note
Records in the PLU transaction file which are not yet effective are stored in the file PLUPOST.PLU
for reprocessing when the next transaction update is performed, after polling or if manager code 909 is performed.