Transaction Transaction

Field Order

Field Name

Data Type

Maximum Data Length

Required

Remarks

 Rotella
Field		  

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.

    
 

 

Please let us know what info we can send you now and what are the areas that are of most important to your organization.
 


Please fill in below, or call us on (714) 228-5444 or fax us at (800) 531-2944...

First Name :
Last Name :
Title :
Organization :
Work Phone :
FAX :
E-mail :                                          
URL / Website:
Number of Concurrent Users:  

What info can we send you?

 

email us at sales@CougarMtnSupport.com  //  phone (714) 228-5444.

(We are not Cougar Mountain Software in Boise, we take their excellent product and make it better.   We offer software products, enhanced reports, services, training and hardware that maximize the value out of this powerful accounting program.  We have been customizing solutions for Cougar Mountain since 1990.  We are located in California.