Search Posts

Daily Revenue Reconciliation Activities (i.shr file)

Print Friendly, PDF & Email

This information is taken from your revenue reconciliation files and records all of your center’s daily revenue reconciliation activities. The (i) Data Share file and the (b)-(d) files will contain all the raw data the Revenue Reconciliation Report uses to calculate its figures. To generate this file during End of Day, Invoice Information must be set to Y in getdata (see Setting Up Data Sharing).

Note: All transactions in these files (A, D, H, M, N, O, Q, R, V, and ““) are exported if you type Y in the Revenue Reconciliation Information field on the Set Up Data Sharing screen. See the Invoice Information article for more information on process codes.

 

File Naming Convention

The following table explains the naming conventions of the daily revenue reconciliation activities data share file: #####i[md].shr

Field Definition
##### Store Number
i This character denotes that the file contains daily revenue reconciliation activities.
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.

“1”,”03/29/2005″,”1″,”1″,”MJ”,”0.00″,”0.00″,…

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
“1” “03/29/2005” “1” “1” “MJ” “0.00” “0.00” “0.00” “0.00” “0.00” “0.00” “0.00”
13 14 15 16 17 18 19 20 21 22 23
“0.00” “0.00” “0.00” “MJ” “0.00” “0.00” “0.00” “0.00” “0.00” “0.00” “0.00”
24 25 26 27 28 29 30 31 32 33 34 35 36 37
“0.00” “0.00” “0.00” “0.00” “A” “A” “A” “A” “A” “A” “A” “A” “0.00” “0.00”
38 39 40 41 42 43 44 45 46 47 48 49 50 51
“0.00” “0.00” “0.00” “0.00” “0.00” “0.00” “0.00” “0.00” “0.00” “0.00” “0.00” “0” “0” “0”
52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
“0” “0” “0” “0” “0” “0” “0” “0” “0” “0” “0” “0” “0” “0.00” “TB3JRE” “TB3JRE”

The following chart lists and describes the contents of the (i) Data Share file.

Num. Description Definition ISI Field Name Output Format* Quoted? Example Value General Release Version When Added
1 Store Number Store number that generated the revenue reconciliation. inf0.store_nbr #(5)   1 6.705
2 Date The date of the reconciliation. inf2.date ##/##/##   03/29/2005 6.705
3 Loc The location number. inf2.loc #(2)   1 6.705
4 Till The till being reconciled. inf2.till #(2)   1 6.705
5 Begempl The employee ID doing start of day. inf2.begempl X(6)   MJ 6.705
6 Begcash The total till count from start of day. inf2.begcash #(4).#(2)   0.00 6.705
7 Slscash The total cash sales computed. inf2.slscash #(6).#(2)   0.00 6.705
8 Slspo The total cash paid outs computed. inf2.slspo #(6).#(2)   0.00 6.705
9 Slspi The total cash paid ins computed. inf2.slspi #(6).#(2)   0.00 6.705
10 Slschk The total computed check sales. inf2.slschk #(6).#(2)   0.00 6.705
11 Slschk2 The total computed traveler’s checks. inf2.slschk2 #(6).#(2)   0.00 6.705
12 Slspichk The total computed paid ins by check. inf2.slspichk #(6).#(2)   0.00 6.705
13 Slscc The total computed credit card sales. inf2.slscc #(6).#(2)   0.00 6.705
14 Slsgc The total computed gift certificate sales. inf2.slsgc #(6).#(2)   0.00 6.705
15 Slschg The total computed charge sales. inf2.slschg #(6).#(2)   0.00 6.705
16 Endempl The closing count for the Employee ID. inf2.endempl X(6)   MJ 6.705
17 End1cash The initial ending cash count with money pulls. inf2.end1cash #(6).#(2)   0.00 6.705
18 End1chk The initial ending check count. inf2.end1chk #(6).#(2)   0.00 6.705
19 End1cc The initial ending credit card count. inf2.end1cc #(6).#(2)   0.00 6.705
20 End1gc The initial ending gift certificate count. inf2.end1gc #(6).#(2)   0.00 6.705
21 End1chk2 The initial ending travelers check count. inf2.end1chk2 #(6).#(2)   0.00 6.705
22 End2cash The second ending cash count without money pulls. inf2.end2cash #(6).#(2)   0.00 6.705
23 End2chk The second ending check count. inf2.end2chk #(6).#(2)   0.00 6.705
24 End2cc The second ending credit card count. inf2.end2cc #(6).#(2)   0.00 6.705
25 End2gc The second ending gift certificate count. inf2.end2gc #(6).#(2)   0.00 6.705
26 End2chk2 The second ending travelers check count. inf2.end2chk2 #(6).#(2)   0.00 6.705
27 Imprint This is not currently being used. inf2.imprint #(4).#(2)   0.00 6.705
28 Crtype Credit card type code. inf2.crtype X(4)   A 6.705
29 Crtype1 Credit card type code. inf2.crtype1 X(4)   A 6.705
30 Crtype2 Credit card type code. inf2.crtype2 X(4)   A 6.705
31 Crtype3 Credit card type code. inf2.crtype3 X(4)   A 6.705
32 Crtype4 Credit card type code. inf2.crtype4 X(4)   A 6.705
33 Crtype5 Credit card type code. inf2.crtype5 X(4)   A 6.705
34 Crtype6 Credit card type code. inf2.crtype6 X(4)   A 6.705
35 Crtype7 Credit card type code. inf2.crtype7 X(4)   A 6.705
36 End1po The initial cash paid out count. inf2.end1po #(6).#(2)   0.00 6.705
37 End1pi The initial cash paid in count. inf2.end1pi #(6).#(2)   0.00 6.705
38 End1chg The initial charge amount count. inf2.end1chg #(6).#(2)   0.00 6.705
39 End2po The second cash paid out count. inf2.end2po #(6).#(2)   0.00 6.705
40 End2pi The second cash paid in count. inf2.end2pi #(6).#(2)   0.00 6.705
41 End2chg The second charge amount count. inf2.end2chg #(6).#(2)   0.00 6.705
42 Startinv The starting invoice number for the day. inf2.startinv #(4)   0 6.705
43 Nextinv The next invoice number. inf2.nextinv #(4)   0 6.705
44 Endinv The ending invoice number for the day. inf2.endinv #(4)   0 6.705
45 Pull_cash The total of all the cash money pulls. inf2p.cash #(6).#(2)   0.00 6.705
46 Pull_check The total of all the check money pulls. inf2p.check #(6).#(2)   0.00 6.705
47 Pull_crcard The total of all the credit card money pulls. inf2p.creditcard #(6).#(2)   0.00 6.705
48 Pull_chk2 The total of all travelers’ checks money pulls. inf2p.tcheck #(6).#(2)   0.00 6.705
49 Count The till count for pennies. inf2.count #(4)   0 6.705
50 Count1 The till count for nickels. inf2.count1 #(4)   0 6.705
51 Count2 The till count for dimes. inf2.count2 #(4)   0 6.705
52 Count3 The till count for quarters. inf2.count3 #(4)   0 6.705
53 Count4 The till count for halves. inf2.count4 #(4)   0 6.705
54 Count5 The till count for ones. inf2.count5 #(4)   0 6.705
55 Count6 The till count for twos. inf2.count6 #(4)   0 6.705
56 Count7 The till count for fives. inf2.count7 #(4)   0 6.705
57 Count8 The till count for tens. inf2.count8 #(4)   0 6.705
58 Count9 The till count for twenties. inf2.count9 #(4)   0 6.705
59 Count10 The till count for fifties. inf2.count10 #(4)   0 6.705
60 Count11 The till count for hundreds. inf2.count11 #(4)   0 6.705
61 Open_hh The hour the store was opened. inf2.open_hh #(2)   0 6.705
62 Open_mm The minute the store was opened. inf2.open_mm #(2)   0 6.705
63 Close_hh The hour the store was closed. inf2.close_hh #(2)   0 6.705
64 Close_mm The minute the store was closed. inf2.close_mm #(2)   0 6.705
65 slspicc The total credit card paid-ins computed. inf2.slspicc #(6).#(2)   0.00 6.705
66 Employee Unique ID Start of Day hrfp.uid X(20) X  TB3JRE 11.2
67 Employee Unique ID End of Day hrfp.uid X(20) X  TB3JRE 11.2

* 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.