The Calendar Setup Information is taken from your Calendar setup file and includes the setup information for all the months that have been set up in your system. To generate this file during End of Day, Calendar Information must be set to Y in getdata (see Setting Up Data Sharing) and at least one calendar month must be set up.
The following table explains the naming conventions of the calendar setup data share file: #####r[md].shr
| Field | Definition | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ##### | Store Number | ||||||||||||||||||||||||||||||||
| r | This character denotes that the file contains calendar 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″,”08/01/2011″,””,””,…
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 | 12 | 13 |
| “06/20/2011” | “08/01/2011” | “” | “” | “” | “” | “” | “” | “W” | “” | “” | “” | “” |
| 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |
| “” | “” | “W” | “P” | “” | “” | “” | “” | “” | “W” | “” | “” | “” | “” | “” |
| 29 | 30 | 31 | 32 | 33 | 34 | 35 |
| “” | “W” | “” | “” | “MP” | “N” | “1” |
The following chart lists and describes the contents of the (r) calendar 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 | First Day of Month | Indicates what month the file is for | lscal.month | ##/##/#### | X | 08/01/2011 | 11.1 |
| 3-33 | Day 1 to Day 31 | Indicates the type of closing for that day:
(blank) Daily W Weekly M Monthly P Payroll Q Quarterly Y Yearly O Skip monthly/quarterly/yearly closing for the month Z Days that do not exist, such as April 31st S Start of LubeSoft operations |
lscal.day1 – lscal.day31 | X(10) | X | D | 11.1 |
| 34 | Month Change Flag | Y or N to indicate if month was set up by OIL Central | lscal.change_flag | X(1) | X | N | 11.1 |
| 35 | Store Number | Number of the store. | inf0.store_nbr | X(5) | X | 1 | 15.3 |
* 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.
