The Category Setup Information is taken from your category setup file and includes the setup information for all the categories set up in your system. To generate this file during End of Day, Category Setup Information must be set to Y in getdata (see Setting Up Data Sharing) and at least one category must exist in category setups.
The following table explains the naming conventions of the category setup data share file: #####l[md].shr
| Field | Definition | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ##### | Store Number | ||||||||||||||||||||||||||||||||
| l | This character denotes that the file contains category setup 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.
“06/20/2011″,”AF”,”Air Filter”,”4011″,…
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 |
| “06/20/2011” | “AF” | “Air Filter” | “4011” | “5112” | “1850” | “4250” |
| 8 | 9 | 10 | 11 | 12 | 13 | 14 |
| “2500” | “” | “” | “” | “” | “5250” | “1” |
The following chart lists and describes the contents of the (l) category setup file.
| Num. | Description | Definition | ISI Field Name | Output Format* | Quoted? | Example Value | General Release Version When Added |
|---|---|---|---|---|---|---|---|
| 1 | Date | File creation date | none | ##/##/#### | X | 06/20/2011 | 11.1 |
| 2 | ID | Category ID | ivf01.category | X(3) | X | AF | 11.1 |
| 3 | Description | Category Description | ivf01.desc | X(25) | X | Air Filter | 11.1 |
| 4 | Account Number | Sales Account Number | ivf01.sales_acct | #(6.2) | 4011 | 11.1 | |
| 5 | Account Number | Inventory Account Number | ivf01.inventory_acct | #(6.2) | 5112 | 11.1 | |
| 6 | Account Number | Shrinkage Account Number | ivf01.shrinkage_acct | #(6.2) | 1850 | 11.1 | |
| 7 | Account Number | Cost of Goods Account Number | ivf01.cog_acct | #(6.2) | 4250 | 11.1 | |
| 8 | Report Sequence Number | Category Report Sequence Number | ivf01.ss_rpt_seq | #(6.0) | 2500 | 11.1 | |
| 9 | Special Type | Indicates a special category type:
T – number Tickets A – cAsh D – creDit card O – cOmpany charge G – Gift certificate C – Coupon I – dIscounts W – Warranty R – Repeat business S – ticket $ F – traFfic periods L – Local fleet N – National fleet Q – Quick sales X – Store TT Y – Other TT 1..5 Tax 1..5 |
ivf01.special | X(1) | X | 11.1 | |
| 10 | Traffic Period | Traffic Period “From” Value | ivf01.from | #(4.0) | 11.1 | ||
| 11 | Traffic Period | Traffic Period “To” Value | ivf01.to | #(4.0) | 11.1 | ||
| 12 | Oil Send Flag | Only populated by OIL Central | ivf01.send_flag | X(1) | X | 11.1 | |
| 13 | Account Number | Purchase Order Account Number | ivf01.purchases_acct | #(6.2) | 5250 | 11.1 | |
| 14 | Store Number | Number of the store. | inf0.store_nbr | X(5) | X | 1 | 15.3 |
| 15 | Shop Supply Flag | Shop supply flag value. | ivf01.supply | X(1) | X | 15.6 | |
| 16 | Adjusted Store Ticket Exclusion Flag | Y/N flag for whether to exclude category from adjusted store ticket average. | ivf01.excl_ticket | X(1) | X | 15.14 |
* 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.
