The Invoice Detail information is taken from your invoicing files and shows your daily invoicing activities in detail. 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.
The following table explains the naming conventions of invoice detail information data share file: #####c[md].shr
| Field | Definition | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ##### | Store Number | ||||||||||||||||||||||||||||||||
| c | This character denotes that the file contains invoice detail 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”,”98012300087933″,”1″,”FS1″,”FULL SERVICE”,…
We have numbered the fields in the following record in order to explain them more clearly to you. Each bold 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 |
| “1” | “98012300087933” | “1” | “FS1” | “FULL SERVICE” | “24.99” | “0” | “” | “1” | “24.99” | “0” |
| 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| “0” | “0” | “FS” | “1” | “” | “” | “FS” | “75695” | “” | “” | “12345678911234” | “24.99” | “0” |
| 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 43 | 44 |
| “JD” | “ISI” | “QA” | “” | “” | “” | “” | “” | “” | “” | “29.99” | “ISI” | “” | “Price Match” | “MIGHTY” | “00012456” | “” | “” | “” | “” | “” |
| Num. | Description | Definition | ISI Field Name | Output Format* | Quoted? | Example Value | General Release Version When Added |
||
|---|---|---|---|---|---|---|---|---|---|
| 1 | Store Number | Store number that generated the detailed information on the invoice. | inf0.store_nbr | #(5) | X | 1 | 6.798 | ||
| 2 | Invoice Transaction Number | The transaction number of the invoice on which the detail information was created. | inf1.trannnumber | #(16) | X | 98012300087933 | 6.798 | ||
| 3 | Invoice Line Number | The line number associated with an invoice detail item. | inf1a.line# | #(2) | X | 1 | 6.798 | ||
| 4 | Item ID | The ID of the inventory item sold during invoicing. | inf1a.item | X(15) | X | FS1 | 6.798 | ||
| 5 | Description | The description of an inventory item associated with invoice detail. | inf1a.desc | X(30) | X | FULL SERVICE | 6.798 | ||
| 6 | Price | The price of an inventory item associated with invoice detail. | inf1a.price | #(4).#(2) | X | 24.99 | 6.798 | ||
| 7 | Include Quantity | The quantity of the inventory item to include for each sale of that item. | inf1a.include | #(4).#(2) | X | 0 | 6.798 | ||
| 8 | Invoice Detail Code | Indicates whether an item is warrantied, nontaxable, or taxable. | inf1a.code | X(1) | X | 6.798 | |||
| 9 | Quantity Sold | The number of units of an inventory item sold associated with invoice detail. | inf1a.qty | #(4).#(2) | X | 1 | 6.798 | ||
| 10 | Amount | The amount invoiced for an associated detailed invoice item. Calculated by multiplying quantity sold minus include quantity and price. | inf1a.amount | #(4).#(2) | X | 24.99 | 6.798 | ||
| 11 | Report Sequence Number | A number to place categories or items in order on reports. | inf1a.seq | #(6) | X | 0 | 6.798 | ||
| 12 | Commission | Unused | inf1a.comm | #(6).#(2) | X | 0 | 6.798 | ||
| 13 | Cost | The cost associated with an inventory item in invoice detail. | inf1a.cost | #(4).#(4) | X | 0 | 6.798 | ||
| 14 | Item Service Code | The service code of an item. | inf1a.servcode | X(3) | X | FS | 6.798 | ||
| 15 | Invoice Detail Service Group | The group number associated with an invoiced item. | inf1a.group | #(2) | X | 1 | 6.798 | ||
| 16 | Invoice Detail Type | The type code (taken from inventory) for a particular item on the invoice. | inf1a.type | X(1) | X | 6.798 | |||
| 17 | Employee | Unused | inf1a.empl | X(6) | X | 6.798 | |||
| 18 | Category | Inventory item category. | inf1a.cat | X(3) | X | FS | 6.798 | ||
| 19 | Invoice Workorder Number | The number of the workorder as generated by the POS system. | inf1.wo# | #(8) | X | 75695 | 6.798 | ||
| 20 | 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
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 | |||
| 21 | GC Item sold is “P” or “C” | Indicates whether GC item sold on invoice is “P”aper gift certificate or Gift “C”ard for Fifth Third Bank customers only. | inf1a.gc_type | X(1) | X | 6.798 | |||
| 22 | ISE Tracking Number | ISE tracking number for item imported from Activant. | inf1a.ise_estimate | #(14) | X | 12345678911234 | 6.798 | ||
| 23 | Taxable amount | Indicates the taxable amount of this item as calculated against the first tax basis setup in LubeSoft (before subtracting coupons/discounts.)
|
inf1a.gross_taxbl | #(6.2) | X | 24.99 | 6.798 | ||
| 24 | Nontaxable amount | Indicates the nontaxable amount of this item as calculated against the first tax basis setup in LubeSoft (before subtracting coupons/discounts).
|
inf1a.gross_nontx | #(6.2) | X | 0 | 6.798 | ||
| 25 | Employee ID | Line item tracking position 1 employee ID | hrf10.emp | X(10) | X | JD | 11.1 | ||
| 26 | Employee ID | Line item tracking position 2 employee ID | hrf10.emp | X(10) | X | ISI | 11.1 | ||
| 27 | Employee ID | Line item tracking position 3 employee ID | hrf10.emp | X(10) | X | QA | 11.1 | ||
| 28 | Unique ID | Line item tracking position 1 Unique ID | hrfp.uid | X(20) | X | 11.2 | |||
| 29 | Unique ID | Line item tracking position 2 Unique ID | hrfp.uid | X(20) | X | 11.2 | |||
| 30 | Unique ID | Line item tracking position 3 Unique ID | hrfp.uid | X(20) | X | 11.2 | |||
| 31 | Extended Description | Inventory description line 2. | inf1a.desc2 | X(40) | X | 11.13 | |||
| 32 | Extended Description | Inventory description line 3. | inf1a.desc3 | X(40) | X | 11.13 | |||
| 33 | Extended Description | Inventory description line 4. | inf1a.desc4 | X(40) | X | 11.13 | |||
| 34 | Extended Description | Inventory description line 5. | inf1a.desc5 | X(40) | X | 11.13 | |||
| 35 | Original Price | Original price before price change. | inf1pc.original_price | #(4.2) | X | 29.99 | 15.3 | ||
| 36 | Employee ID | Employee ID used for price change. | inf1pc.emp_id | X(10) | X | ISI | 15.3 | ||
| 37 | Employee Unique ID | The Unique ID for an Employee | hrfp.uid | X(20) | X | 15.3 | |||
| 38 | Reason | Reason for price change. | inf1pc.reason | X(20) | X | Price Match | 15.3 | ||
| 39 | Wildcard Vendor | The ID of the Vendor the wildcard part was purchased from. | inf1a.vendor | X(10) | X | MIGHTY | 15.15 | ||
| 40 | Wildcard Reference | A reference number or other identifier filled in for vendor wildcards during invoicing to reconcile with a vendor invoice. | inf1a.reference | X(20) | X | 00012456 | 15.15 | ||
| 41 | Vendor Part | The item identifier filled in for vendor wildcards during invoicing. | inf1a.vendor_part | X(20) | X | 15.20 | |||
| 42 | Invoice Line Item Identifier | Universal unique identifier for the invoice line item, if a cart item is attached to a vendor wildcard. | inf1a.uuid | X(40) | X | 15.20 | |||
| 43 | Vendor Part Match | The Vendor Part without spaces, dashes, or other non-alphanumeric characters. Used to reconcile cart items to vendor wildcards. | inf1a.vend_part_match | X(20) | X | 15.24 | |||
| 44 | Quantity of Inventory to Return | Quantity entered when returning a line item to inventory during a refund | inf1a.return_qty | #(4).#(2) | X | 1 | 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.
