Transaction Transaction

Field Order

Field Name

Data Type

Maximum Data Length

Required

Remarks

1

Member Number

String

10

Yes

 (1)(2)

2

Transaction ID

String

50

Uniquely identifies a purchase transaction. It is assigned by the POS system.

3

Store Number

String

10

Yes

4

Invoice Number

String

50

Yes

5

Invoice Line Item Number

Integer

Yes

Line item number of an item on invoice.  The default value is 1.     (3) (4)

6

Invoice Date

DateTime

Yes

Invoice date and time billed out.

7

Invoice Total

Numeric

(9,2)

Invoice total.

8

Product Quantity

Numeric

(9,2)

Yes

Quantity of qualifying part purchased.

9

Product Type

String

10

Yes

The unit of measure for the part.  Accepted types are “GALLONS”, “QUART” and “EACH”.  All other types will be rejected as “Invalid Product Type”.

10

Part Code

String

20

Yes

Part code of the qualifying part.

11

Truck Make

String

50

12

Model Year

Integer

Model year of the truck.

13

VIN

String

18

14

License Plate Number

String

50

15

Service Mileage

Integer

Truck Odometer reading at time of service.

16

Unit Number

String

50

Truck unit number (route number xxxx).

17

DOT

String

10

DOT number of Truck.  It is used for fleet incentives.