Search Posts

Inventory Setup Information (m .shr file)

Print Friendly, PDF & Email

The Inventory Setup Information is taken from your inventory file and shows all setup fields. To generate this file during End of Day, Inventory Information must be set to Y in getdata (see Setting Up Data Sharing) and at least one inventory item must exist in inventory setups.

File Naming Convention

The following table explains the naming conventions of the inventory setup data share file: #####m[md].shr

Field Definition
##### Store Number
m This character denotes that the file contains inventory setup information.
m This character denotes the month. The characters range from a to l and are as follows:

a = January d = April g = July j = October
b = February e = May h = August k = November
c = March f = June i = September l = December
d This character denotes the day. The characters range from a to z and 1 to 5 and are as follows:

a = 1 e = 5 i = 9 m = 13 q = 17 u = 21 y = 25 3 = 29
b = 2 f = 6 j = 10 n = 14 r = 18 v = 22 z = 26 4 = 30
c = 3 g = 7 k = 11 o = 15 s = 19 w = 23 1 = 27 5 = 31
d = 4 h = 8 l = 12 p = 16 t = 20 x = 24 2 = 28

File Contents

The following is an example of an actual record in what is known as “comma-delimited” format. This means that the information you entered in each field in this POS system record is separated by a comma.

“10/30″,”OIL”,”MOBIL 10/30 MOTOR OIL”,”11030″,”L”,”OIL”,”Y”…

We have numbered the fields in the following record in order to explain them more clearly to you. Each bolded number indicates one field.

Note: Some of the fields contained in this file are for internal system processing only and may not be useful to you.

 

1 2 3 4 5 6 7 8 9 10 11
“1” “10/30” “OIL” “MOBIL 10/30 MOTOR OIL” “11030” “L” “OIL” “Y” “1.85” “” “0”
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
“0” “1.1125” “01/02/2006” “MOBIL” “10/30” “” “” “” “” “EA” “0” “GA” “4” “” “1”
27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
“” “Y” “0” “OF” “OIL” “CRI” “AB” “BA” “ABC” “FL” “HU” “ORG” “OC” “1” “5.0”
42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
“1” “0” “0” “0” “0” “0” “0” “0” “M” “” “Y” “” “02/03/2006” “N” “0” “0” “0” “N”
60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
“” “04/01/2006” “ISI” “” “” “N” “Y” “123456” “789789” “ABC” “1” “” “” “” “10.00”
75 76 77 78 79 80 81 82 83 84 85 86 87 88 89
“” “10” “100” “” “5” “05/01/2007” “10.00” “05/01/2007” “” “” “” “1.00” “1.50” “0.50” “”
90 91 92 93 94 95 96 97 98 99 100 101
“04/30/2007” “20” “2” “05/01/2007” “20” “2” “300” “9.99” “50” “0” “0” “0”
102 103 104 105 106 107 108 109 110 111 112 113 114 115
“01/01/2014” “” “” “” “” “CONVENTIONAL OIL” “” “” “T” “Y” “2156515 “ “TOY” “215” “65”
116 117 118 119 120 121 122 123 124  125 126 127  128  129
 “15”  “P”  “R”  “SL”  “215/65R15”  “50”  “T”  “600”  “A”  “B”  “97” “1350”  “BW”  “5”
130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147
“S” “B” “N” “4” “1” “1” “Y” “1” “15” “5” “15” “A” “P” “Y” “” “N” “N” “Y”

The following chart lists and describes the contents of the (m) inventory setup file.

Num. Description Definition ISI Field Name Output Format* Quoted? Example Value General Release Version When Added
1 Store Number The number of the store. inf0.store_nbr X(5) X 1 6.705
2 Inventory ID The part number of the inventory item. ivfm.id X(15) X 10/30 6.705
3 Category Category of the inventory item. ivfm.cat X(3) X OIL 6.705
4 Description Description of the inventory item. ivfm.desc X(25) X MOBIL 10/30 MOTOR OIL 6.705
5 Count Sequence # A 6-digit number to specify the order in which this item will be printed on the Inventory Count Worksheet. ivfm.seq #(6) 11030 6.705
6 Inventory Type The type of the inventory item. ivfm.type X(1) X L 6.705
7 Service Code The service code for the inventory item. ivfm.servcode X(3) X OIL 6.705
8 Taxable? Indicates whether this inventory item is taxable. ivfm.taxable X(1) X Y 6.705
9 Price The retail price of the inventory item. ivfm.price #(4).#(4) 1.85 6.705
10 Unused Unused. ivfm.price1 #(4).#(4) 6.705
11 Reorder point The point at which you want to be reminded to order more of this item. ivfm.reorder #(4).#(2) 0 6.705
12 Reorder quantity The amount you want to reorder when the reorder point is reached. ivfm.eoq #(4).#(2) 0 6.705
13 Agreed cost Agreed cost of the item. ivfm.agree_cost #(4).#(4) 1.1125 6.705
14 Agreed cost date Date of the agreed cost. ivfm.agree_cost_date ##/##/#### 01/02/2006 6.705
15 Vendor 1 1st Vendor for this item. ivfm.avend1 X(21) X MOBIL 6.705
16 Part ID for Vendor 1 The part ID the vendor uses. ivfm.apart1 X(10) X 10/30 6.705
17 Vendor 2 2nd Vendor for this item. ivfm.avend2 X(21) X 6.705
18 Part ID for Vendor 2 The part ID the 2nd vendor uses. ivfm.apart2 X(10) X 6.705
19 Vendor 3 3rd Vendor for this item. ivfm.avend3 X(21) X 6.705
20 Part ID for Vendor 3 The part ID the 3rd vendor uses. ivfm.apart3 X(10) X 6.705
21 Sales unit The sales unit for this item. ivfm.sls_unit X(3) X EA 6.705
22 Sales quantity The default sales quantity for this item. ivfm.sls_qty #(4).#(2) 0 6.705
23 Purchase unit The purchase unit for this item. ivfm.pkg_unit X(3) X GA 6.705
24 Purchase quantity The ratio of sales unit to purchase unit. ivfm.pkg_qty #(4).#(2) 4 6.705
25 Checkpoint # None Used Field ivfm.cckpoint #(2) 1 6.705
26 Change checkpoint to: Response number to change the checkpoint to. ivfm.cckchoice #(2) 1 6.705
27 Unused Unused. ivfm.unused26 #(4).#(2) 6.705
28 Include in help? Indicates whether this item is included in the help pop-ups. ivfm.help_code X(1) X Y 6.705
29 Report Sequence # Sequence number to use for reports. ivfm.ss_rpt_seq #(6) 0 6.705
30 Job item 1 ID The inventory ID of the first included job item. ivfm.ciitem1 X(13) X OF 6.705
31 Job item 2 ID The inventory ID of the second included job item. ivfm.ciitem2 X(13) X OIL 6.705
32 Job item 3 ID The inventory ID of the third included job item. ivfm.ciitem3 X(13) X CRI 6.705
33 Job item 4 ID The inventory ID of the fourth included job item. ivfm.ciitem4 X(13) X AB 6.705
34 Job item 5 ID The inventory ID of the fifth included job item. ivfm.ciitem5 X(13) X BA 6.705
35 Job item 6 ID The inventory ID of the sixth included job item. ivfm.ciitem6 X(13) X ABC 6.705
36 Job item 7 ID The inventory ID of the seventh included job item. ivfm.ciitem7 X(13) X FL 6.705
37 Job item 8 ID The inventory ID of the eighth included job item. ivfm.ciitem8 X(13) X HU 6.705
38 Job item 9 ID The inventory ID of the ninth included job item. ivfm.ciitem9 X(13) X ORG 6.705
39 Job item 10 ID The inventory ID of the tenth included job item. ivfm.ciitem10 X(13) X OC 6.705
40 Job item 1 quantity The quantity of the first item to be included for free in the job. ivfm.ciqty1 #(4).#(2) 1 6.705
41 Job item 2 quantity The quantity of the second item to be included for free in the job. ivfm.ciqty2 #(4).#(2) 5.0 6.705
42 Job item 3 quantity The quantity of the third item to be included for free in the job. ivfm.ciqty3 #(4).#(2) 1 6.705
43 Job item 4 quantity The quantity of the fourth item to be included for free in the job. ivfm.ciqty4 #(4).#(2) 0 6.705
44 Job item 5 quantity The quantity of the fifth item to be included for free in the job. ivfm.ciqty5 #(4).#(2) 0 6.705
45 Job item 6 quantity The quantity of the sixth item to be included for free in the job. ivfm.ciqty6 #(4).#(2) 0 6.705
46 Job item 7 quantity The quantity of the seventh item to be included for free in the job. ivfm.ciqty7 #(4).#(2) 0 6.705
47 Job item 8 quantity The quantity of the eighth item to be included for free in the job. ivfm.ciqty8 #(4).#(2) 0 6.705
48 Job item 9 quantity The quantity of the ninth item to be included for free in the job. ivfm.ciqty9 #(4).#(2) 0 6.705
49 Job item 10 quantity The quantity of the tenth item to be included for free in the job. ivfm.ciqty10 #(4).#(2) 0 6.705
50 Count period Indicates how often this item is to be counted. ivfm.count_per X(1) X M 6.705
51 Unused Unused. ivfm.meter_per X(1) X 6.705
52 Count daily? Indicates whether this item should be counted daily. ivfm.cdaily X(1) X Y 6.705
53 Unused Unused. ivfm.mdaily X(1) X 6.705
54 Inventory price/cost last changed by system or user The date on which the inventory item cost/price was last changed. ivfm.chgdate ##/##/#### 02/03/2006 6.705
55 include in history? Indicates whether this item’s service code should be included in the service history in Maintain Vehicle History. ivfm.shflag X(1) X N 6.705
56 Agreed cost for vendor 2 The cost that vendor 2 has agreed to sell you this item at. ivfm.acost2 #(4).#(2) 0 6.705
57 Agreed cost for vendor 3 The cost that vendor 3 has agreed to sell you this item at. ivfm.acost3 #(4).#(2) 0 6.705
58 Number of employees for tracking The number of employees you want to track for this inventory item. ivfm.num_emp #(2) 0 6.705
59 Count in store ticket average? Indicates whether invoices containing this item should be included in the store ticket average. ivfm.stats_flag_st X(1) X N 6.705
60 Unused Unused. ivfm.cost_status X(1) X 6.705
61 Date last updated The date on which the inventory item was last changed. ivfm.last_date ##/##/#### 04/01/2006 6.705
62 Updated by The employee ID of the last person to change this inventory item. ivfm.last_id X(6) X ISI 6.705
63 Unused Unused. ivfm.status X(1) X 6.705
64 Unused Unused. ivfm.dept #(2) 6.705
65 Employee tracking? Indicates whether to show the Employee Tracking popup during invoicing. ivfm.emp_flag X(1) X N 6.705
66 Include in handheld help? Indicates whether this item will be shown in the handheld help. ivfm.handheld X(1) X Y 6.705
67 Barcode 1 The barcode for this inventory item. ivfm.bcode1 X(16) X 123456 6.705
68 Barcode 2 The barcode for this inventory item. ivfm.bcode2 X(16) X 789789 6.705
69 Inventory ID The part number of the inventory item as stored in ivfmx. ivfmx.id X(15) X ABC 6.705
70 Location The location number for the store tracking the inventory. ivfmx.loc #(2) 1 6.705
71 Unused Unused. ivfmx.unused4 #(4).#(2) 6.705
72 Unused Unused. ivfmx.unused5 #(6).#(2) 6.705
73 Unused Unused. ivfmx.unused6 #(4).#(4) 6.705
74 Standard cost Cost for the part when using Standard Cost Method. ivfmx.stdcost #(4).#(4) 10.00 6.705
75 Unused Unused. ivfmx.unused8 #(4).#(2) 6.705
76 Reorder point Inventory reorder point. ivfmx.reorder #(4).#(2) 10 6.705
77 Reorder quantity Quantity of item to reorder when reorder point is reached. ivfmx.eoq #(4).#(2) 100 6.705
78 Unused Unused. ivfmx.unused11 ##/##/#### 6.705
79 Last sold quantity Quantity of item last sold. ivfmx.last_sold #(4).#(2) 5 6.705
80 Last sold date Last date the item was sold. ivfmx.last_sold_date ##//##/#### 05/01/2007 6.705
81 Last cost amount Last amount the item was received at. ivfmx.last_cost #(4).#(4) 10.00 6.705
82 Last cost date Last date the item was received. ivfmx.last_cost_date ##/##/#### 05/01/2007 6.705
83 Unused Unused. ivfmx.dy_beg_cnt #(6).#(2) 6.705
84 Unused Unused. ivfmx.unused17 #(6).#(2) 6.705
85 Unused Unused. ivfmx.unused18 #(6).#(2) 6.705
86  Commission Setups  Commission Setups Field 1 ivfmx.comm1 #(2).#(2)  1.00 6.705
87 Commission Setups Commission Setups Field 2 ivfmx.comm2 #(2).#(2) 1.50 6.705
88 Commission Setups Commission Setups Field 3 ivfmx.comm3 #(2).#(2) 0.50 6.705
89 Unused Unused. ivfmx.unused22 #(6).#(2) 6.705
90 Initial date Temporary data field used during counting of inventory. ivfmx.init_count_date ##/##/#### 04/30/2007 6.705
91 Initial count Temporary count field used during counting of inventory. ivfmx.init_count #(6).#(2) 20 6.705
92 Initial variance Temporary variance field used during counting of inventory. ivfmx.init_var #(6).#(2) 2 6.705
93 Last inventory count date Last date the inventory was counted. ivfmx.last_count_date ##/##/#### 05/01/2007 6.705
94 Last inventory count amount The amount of inventory when it was last counted. ivfmx.last_count #(6).#(2) 20 6.705
95 Last inventory count variance The variance from the last inventory count. ivfmx.last_var #(6).#(2) 2 6.705
96 Quantity on hand Quantity of item on hand. ivfmx.qoh #(6).#(2) 300 6.705
97 Item cost The cost of the inventory item. ivfmx.cost #(4).#(8) 9.99 6.705
98 Quantity on order Quantity of the item on order. ivfmx.qoo #(6).#(2) 50 6.705
99 Quantity on hand scratchpad Temporary field. Should be 0 at end of day. ivfmx.qohscr #(6).#(2) 0 6.705
100 Quantity on order scratchpad Temporary field. Should be 0 at end of day. ivfmx.qooscr #(6).#(2) 0 6.705
101 Handheld processed field Used with handheld. Will be 0 or 1. ivfmx.processed #(2) 0 6.705
102 File creation date System Date System date ##/##/#### X 01/01/2014 11.3
103 Extended Description Inventory description line 2. ivfm.desc2 X(40) X 11.13
104 Extended Description Inventory description line 3. ivfm.desc3 X(40) X 11.13
105 Extended Description Inventory description line 4. ivfm.desc4 X(40) X 11.13
106 Extended Description Inventory description line 5. ivfm.desc5 X(40) X 11.13
107 Inventory oil type The oil classification for type “L” items. ivfm.oil_type X(40) X CONVENTIONAL OIL 11.13
108 Business Line Line of business the inventory item belongs to. ivfm.business_line X(40) X 11.13
109 Sub-Category Inventory item sub-category ivfm.subcategory X(3) X 11.13
110 Inventory item sub-type Only valid values are <blank> and “T”. ivfm.subtype X(1) X T 11.14
111 Inventory Stock Y/N value to denote if an item is intended to be stocked by a particular store location ivfm.stock X(1) X Y 11.14
112 Tire item tire search field Value used as a search filter on the tire help display. ivfm.tr_search X(20) X 2156515 11.14
113 Tire item brand Value comes from a selection list of tire manufacturer/brands. ivfm.brand_code X(3) X TOY 11.14
114 Tire item size 1 This is width for Standard and diameter for Flotation tires. ivfm.tr_size1 X(5) X 215 11.14
115 Tire item size 2 This is ratio for Standard and width for Flotation tires. ivfm.tr_size2 X(5) X 65 11.14
116 Tire item wheel diameter Tire item wheel diameter ivfm.tr_wheel_dia X(5) X 15 11.14
117 Tire item vehicle class Values such as LT and P. ivfm.tr_class X(2) X P 11.14
118 Tire item construction Tire item construction ivfm.tr_construction X(2) X R 11.14
119 Tire item load range Tire item load range ivfm.tr_load_range X(2) X SL 11.14
120 Tire item tire display field Value is used as a tire description display field for the tire help results screen. ivfm.tr_display X(20) X 215/65R15 11.14
121 Tire item warranty Field is meant to hold the tire mileage warranty value in thousandth. i.e. 60 would be a 60,000 mile or km warranty. ivfm.tr_warranty #(4).#(0) 50 11.14
122 Tire item speed rating Tire item speed rating ivfm.tr_speed X(3) X T 11.14
123 Tire item treadwear grade Tire item treadwear grade ivfm.tr_tread #(4).#(0) 600 11.14
124 Tire item traction grade Tire item traction grade ivfm.tr_traction X(2) X A 11.14
125 Tire item temperature grade Tire item temperature grade ivfm.tr_temp X(1) X B 11.14
126 Tire item load index Tire item load index ivfm.tr_load_idx #(4).#(0) 97 11.14
127 Tire item load capacity Tire item load capacity ivfm.tr_load_cap #(6).#(0) 1350 11.14
128 Tire item sidewall code Tire item sidewall code ivfm.tr_sidewall X(4) X BW 11.14
129 Tire item tire ply Tire item tire ply ivfm.tr_ply #(2).#(0) 5 11.14
130 Tire item tread pattern Values are “S” for Symmetric, “D” for Directional, “A” for Asymmetric, and “B” for both Directional and Asymmetric. ivfm.tr_pattern X(1) X S 11.14
131 Tire item tire rating Values are “G” for (G)ood, “B” for (B)etter, and “E” for B(e)st. ivfm.tr_rating X(1) X B 11.14
132 Tire item flotation identifier Flag set to “Y” if the tire size is setup as a Flotation tire instead of a Standard tire. ivfm.tr_float X(1) X N 11.14
133 Tire item temporary quantity on hand Temporary value used internally within the software for the tire help display. ivfm.tr_tmp_qoh #(6).#(2) 4 11.14
134 Tire item temporary quantity on hand flag Temporary value used internally within the software for the tire help display. ivfm.tr_tmp_qoh_flag #(2).#(0) 1 11.14
135 Checkpoint group ID The checkpoint group that this item applies to. (Previously ivfm.cckpoint) ivfm.cckgroup X(5) X 1 15.1
136 Price Change Flag Flag that allows the changing of a price during invoicing. ivfm.price_chng_flag X(1) X Y 15.3
137 Available Quantity Available quantity of an item. available quantity #(7).#(2) 1 15.3
138 Shop Supply % Percentage of a shop supply charge. ivfm.supply_percent #(4).#(2) 15 15.6
139 Min. SS charge Minimum shop supply charge. ivfm.supply_min #(4).#(2) 5 15.6
140 Max. SS charge Maximum shop supply charge. ivfm.supply_max #(4).#(2) 15 15.6
141 SS Basis Shop supply basis. ivfm.supply_basis X(1) X A 15.6
142 Inv. Item Types for SS Basis Inventory item types that apply to shop supply basis. ivfm.supply_types X(10) X P 15.6
143 Shop supply charge method. Shop supply charge method. ivfm.supply_method X(1) X Y 15.8
144 Allowed Oil Types for Jobs List of allowed oil classifications for type “J” items. allowed oil types X(510) X 15.8
145 Vendor Tracking Flag Value is “Y” if the wildcard will capture Vendor and Reference values during invoicing.  “N” or blank will not capture vendor and reference values during invoicing. ivfm.capture_vendor X(1) X 15.15
146 Require Input Flag If “Y”, then vendor wildcard requires input in the vendor fields during invoicing. ivfm.require_input X(1) X 15.20
147 Allow Fractional Quantity Sales If “Y” then we will allow fractional quantity sales, and “N” means that we will not. Field defaults to “Y” ivfm.frac_qty X(1) X Y 22.9

* The Output Format column uses X to represent string fields and # to represent numeric fields. E.g. X(5) represents a string up to five characters in length.  #(14) represents a number up to 14 digits in length.