Search Posts

Extra Invoice Information (d .shr file)

Print Friendly, PDF & Email

This is extra information taken from your invoicing files that shows more of your daily invoicing activities. To generate this file during End of Day, Invoice Information must be set to Y in getdata (see Setting Up Data Sharing) and an invoice must be cashed out for today’s date.

File Naming Convention

The following table explains the naming conventions of the extra invoice information data share file: #####d[md].shr

Field Definition
##### Store Number
d This character denotes that the file contains extra invoice information.
m This character denotes the month. The characters range from 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”,”98012300087933″,”26.48″,”4.25″,”0″,”0″,”0″,”10.5″,”32.73″,”36.98″,”36.98″,”36.98″,”75695″,””

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
“1” “98012300087933” “26.48” “4.25” “0” “0” “0” “10.5” “32.73” “36.98”
11 12 13 14
“36.98” “36.98” “75695” “”

 

Num. Description Definition ISI Field Name Output Format* Quoted? Example Value General Release Version When Modified
1 Store Number Store number that generated the invoice to which the extra information was attached. inf0.store_nbr #(5) X 1 6.758
2 Invoice Transaction Number The transaction number of the invoice on which the extra information was created. inf1.trannnumber #(16) X 98012300087933 6.758
3 Taxable 1 The taxable amount under the user defined parameters for tax 1. inf1b.taxable #(6).#(2) X 26.48 22.4
4 Taxable 2 The taxable amount under the user defined parameters for tax 2. inf1b.taxable2 #(6).#(2) X 4.25 22.4
5 Taxable 3 The taxable amount under the user defined parameters for tax 3. inf1b.taxable3 #(6).#(2) X 0 22.4
6 Taxable 4 The taxable amount under the user defined parameters for tax 4. inf1b.taxable4 #(6).#(2) X 0 22.4
7 Taxable 5 The taxable amount under the user defined parameters for tax 5. inf1b.taxable5 #(6).#(2) X 0 22.4
8 Nontaxable 1 The nontaxable amount under the user defined parameters for tax 1. inf1b.nontaxable #(6).#(2) X 10.5 22.4
9 Nontaxable 2 The nontaxable amount under the user defined parameters for tax 2. inf1b.nontaxable2 #(6).#(2) X 32.73 22.4
10 Nontaxable 3 The nontaxable amount under the user defined parameters for tax 3. inf1b.nontaxable3 #(6).#(2) X 36.98 22.4
11 Nontaxable 4 The nontaxable amount under the user defined parameters for tax 4. inf1b.nontaxable4 #(6).#(2) X 36.98 22.4
12 Nontaxable 5 The nontaxable amount under the user defined parameters for tax 5. inf1b.nontaxable5 #(6).#(2) X 36.98 22.4
13 Invoice Workorder Number The number of the workorder as generated by the POS system. inf1.wo# #(8) X 75695 6.758
14 Process Code Codes for the processes shown in the chart below:

A Abort

D Delete

H Hold

M Midday Till Closing

N No Sale

O Work Order

Q Quick Sale

R Reprint

V Void

C Refund

(blank) Regular or manual invoice

Note: By default, the following codes will be available:

Q Quick Sale

V Void

(blank) Regular or manual invoice

If you wish to receive all codes, answer Y to Include all processed codes on the Data Sharing Setup screen.

inf1.processed X(1) X 22.6

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