The Statistics information is taken from your statistics files and records all of your center’s daily activities. To generate this file during End of Day, Statistics Information must be set to Y in getdata (see Setting Up Data Sharing).
The following table explains the naming conventions of the statistics information data share file: #####f[md].shr
| Field | Definition | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ##### | Store Number | ||||||||||||||||||||||||||||||||
| f | This character denotes that the file contains statistics information. | ||||||||||||||||||||||||||||||||
| m | This character denotes the month. The characters range from a to l and are as follows:
|
||||||||||||||||||||||||||||||||
| d | This character denotes the day. The characters range from a to z and 1 to 5 and are as follows:
|
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.
“1”,”01/23/1998″,”1″,”40″,”40″,”1362.85″,”0″,
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 |
| “1” | “01/23/1998” | “1” | “40” | “40” | “1362.85” | “0” |
| Num. | Description | Definition | ISI Field Name | Output Format* | Quoted? | Example Value | General Release Version When Modified |
|---|---|---|---|---|---|---|---|
| 1 | Store Number | Store number that generated the statistics. | inf0.store_nbr | #(5) | X | 1 | 6.705 |
| 2 | Date | The date of the statistics. | infs.date | ##/##/#### | 01/23/1998 | 6.705 | |
| 3 | Report Sequence Number | A number to place categories or items in order on reports. | infs.seq | #(6) | 1 | 6.705 | |
| 4 | Times Sold | The total number of times an item sold appears as a line on an invoice. | infs.times_sold | #(6) | 40 | 6.705 | |
| 5 | Units Sold | The total number of items sold. | infs.units_sold | #(4).#(2) | 40 | 6.705 | |
| 6 | Dollars | The dollar amount of the items sold. | infs.dollars | #(8).#(2) | 13620000.85 | 22.4 | |
| 7 | Cost | The cost of the items sold. | infs.cost | #(4).#(2) | 0 | 6.705 | |
| 8 | Print Order
|
A number to place categories or items in order on reports. | ivfs.print_order | #(6) | 15.12 |
* 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.
