The Inventory History Information is taken from your inventory history file and records all of your center’s daily inventory activity. To generate this file during End of Day, Inventory Information must be set to Y in getdata (see Setting Up Data Sharing) and there must be inventory activity (e.g. sale, transfer, receipt) for a date prior to today.
The following table explains the naming conventions of the inventory history data share file: #####n[md].shr
| Field | Definition | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ##### | Store Number | ||||||||||||||||||||||||||||||||
| n | This character denotes that the file contains inventory history. | ||||||||||||||||||||||||||||||||
| 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.
“10/30″,1,”11/05/2004″,11,51,0,0,”Automatic Cost Adjustment”,1,0,5111,0,1.1125,”OIL”,”MB”,”N”,95,””,””,””,””,””,””,04110500123456,12345,1,12,01,30,””,””,””,””,””,””,Y”
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 | 14 |
| “1” | “10/30” | 1 | “11/05/2004” | 11 | 51 | 0 | 0 | “Automatic Cost Adjustment” | 1 | 0 | 5111 | 0 | 1.1125 |
| 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 |
| “OIL” | “MB” | “N” | 95 | “” | “” | “” | “” | “” | “” | 04110500123456 | 12345 | 1 | 12 | 01 | 30 |
| 31 | 32 | 33 | 34 | 35 | 36 | 37 |
| “” | “” | “” | “” | “” | “” | “Y” |
The following chart lists and describes the contents of the (n) inventory history file.
| Num. | Description | Definition | ISI Field Name | Output Format* | Quoted? | Example Value | General Release Version When Added |
|---|---|---|---|---|---|---|---|
| 1 | Store Number | Number of the store. | inf0.store_nbr | X(5) | X | 1 | 6.725 |
| 2 | Inventory ID | ID of the inventory item. | ivf3.id | X(15) | X | 10/30 | 6.725 |
| 3 | Location | Location number where the transaction took place. | ivf3.loc | #(2) | 1 | 6.725 | |
| 4 | Transaction Date | Date of the transaction. | ivf3.trndate | ##/##/#### | 01/02/2006 | 6.725 | |
| 5 | Accounting Period | The accounting period in the POS system for the transaction. | ivf3.acctper | #(2) | 11 | 6.725 | |
| 6 | Transaction Code | The transaction code used for the item. See Transaction Types for details. | ivf3.trncode | #(2) | 51 | 6.725 | |
| 7 | Amount | The amount of the item used in the transaction. | ivf3.amount | #(6).#(2) | 0 | 6.725 | |
| 8 | QOH, for change of cost (Tran 51) | The quantity on hand, for change of cost transactions. | ivf3.chgoord | #(6).#(2) | 0 | 6.725 | |
| 9 | Description | Description of the transaction. | ivf3.desc | X(25) | X | Adjustment | 6.725 |
| 10 | Prefix 1 | Prefix1 (From Set Up Accounting Options). | ivf3.prefix1 | #(4) | 1 | 6.725 | |
| 11 | Prefix 2 | Prefix2 (From Set Up Accounting Options). | ivf3.prefix2 | #(4).#(2) | 0 | 6.725 | |
| 12 | Account Number | Account used for the transaction. | ivf3.account | #(4).#(2) | 5111 | 6.725 | |
| 13 | Price | Price of the item. | ivf3.price | #(6).#(2) | 0 | 6.725 | |
| 14 | Cost | Cost of the item. | ivf3.cost | #(6).#(4) | 1.1125 | 6.725 | |
| 15 | Category | Category of the item. | ivf3.cat | X(3) | X | OIL | 6.725 |
| 16 | Employee | Employee that performed the transaction. | ivf3.employee | X(6) | X | MB | 6.725 |
| 17 | Out of Stock? | Indicates whether this item was out of stock. | ivf3.oostock | X(1) | X | N | 6.725 |
| 18 | Tran type | Used internally by Lubesoft. | ivf3.pseq | #(2) | X | 95 | 6.725 |
| 19 | Unused | Unused. | ivf3.ctime | #(4) | 6.725 | ||
| 20 | Unused | Unused. | ivf3.rcv_session | #(2) | 6.725 | ||
| 21 | Unused | Unused. | ivf3.rcv_seq | #(4) | 6.725 | ||
| 22 | Unused | Unused. | ivf3.bay | #(2) | 6.725 | ||
| 23 | Invoice or Reference Identifier | Reference# value entered when receiving inventory or selling wildcards. Also, the PO# value when ordering parts in the Purchase Order Module. | ivf3.invoice# | X(20) | X | 6.725 | |
| 24 | Unused | Unused. | ivf3.used_flag | X(1) | X | 6.725 | |
| 25 | Transaction Number | Transaction number of the sale or void. (Not for consolidated daily sale transactions.) | ivf3.trannumber | #(14) | 04110500123456 | 6.725 | |
| 26 | Invoice Record Number | Internal dataflex record number of invoice. (Not for consolidated daily sale transactions.) | ivf3.inf1_rec# | #(6) | 12345 | 6.725 | |
| 27 | Invoice Detail Line Number | Line number of this item from the invoice. (Not for consolidated daily sale transactions.) | ivf3.inf1a_line# | #(2) | 1 | 6.725 | |
| 28 | Hour | Hour portion of the time the transaction was entered in the system. (Not for consolidated daily sale transactions.) | ivf3.hh | #(2) | 12 | 6.725 | |
| 29 | Minute | Minute portion of the time the transaction was entered in the system. (Not for consolidated daily sale transactions.) | ivf3.mm | #(2) | 01 | 6.725 | |
| 30 | Second | Second portion of the time the transaction was entered in the system. (Not for consolidated daily sale transactions.) | ivf3.ss | #(2) | 30 | 6.725 | |
| 31 | Employee Unique ID | The unique ID of the employee that performed the transaction | hrfp.uid | X(20) | X | 11.2 | |
| 32 | Transfer ID | The transfer ID created and/or collected for transfers of inventory into and out of the system. | ivf3.uid | X(15) | X | 15.3 | |
| 33 | Vendor Receipt | The ID of the vendor collected during receipt of inventory. | ivf3.vendor | X(10) | X | 15.15 | |
| 34 | Vendor Part | The item identifier filled in for vendor wildcards during invoicing. | ivf3.vendor_part | X(20) | X | 15.20 | |
| 35 | Events API Unique ID | The unique ID for inventory activity records. | ivf3.uuid | X(40) | X | 15.25 | |
| 36 | Cart UIDs | Pipe delimited list of Cart Unique ID values attached to the history. | ivf3a.cart_uid | X(Unlimited) | X | 15.29 | |
| 37 | Event Created Flag | This flag signals a successful publish of that event | evt_created | X(1) | X | 22.8 |
* 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.
