1. General Transactions
Field |
Type |
Description |
Site Number |
Integer |
Site Number |
Site Name |
String |
Site Name |
Date Time |
Date Time |
Transaction Date Time |
Map Code |
Integer |
Transaction Map Code |
MOP |
String |
EFTPOS or LOCAL |
Card Type |
String |
Access ID (Card) Type |
Card Number |
String |
Access ID (Card) Number |
Card Number Full PAN |
String |
Access ID (Card) Full PAN |
Card Number By Type |
String |
Access ID (Card) Number by Type |
Card Prefix |
Integer |
Access ID (Card) Prefix |
Card Number By Prefix |
String |
Access ID (Card) Number by Prefix (Eg. Blank for empty prefix) |
Card Name |
String |
Access ID (Card) Name |
Card Number 8 |
String |
Access ID (Card) Number (8 Digits Only) |
Merchant Card Number |
String |
Access ID (Card) Number (9 Digits Only) |
Street 1 |
String |
Access ID (Card) Street Line 1 |
Street 2 |
String |
Access ID (Card) Street Line 2 |
City |
String |
Access ID (Card) City |
State |
String |
Access ID (Card) State |
Phone |
String |
Access ID (Card) Phone |
Facsimile |
String |
Access ID (Card) Facsimile |
Notes |
String |
Notes |
Sub Account Number |
String |
Sub Account Number |
User Id |
String |
User ID |
User Name |
String |
User ID Name |
Memo |
String |
Transaction Memo |
Account Number |
String |
Account Number |
Account Name |
String |
Account Name |
Activity Card Number |
String |
Activity Card Number |
Product Grade |
Integer |
Product Grade Number |
Product Name |
String |
Product Name |
Product Code |
String |
Product Code |
Reference |
Integer |
Transaction Reference Number |
Transaction Type |
Integer |
0 = Controller, 1 = Manual, 2 = Import, 3 - RTP |
Transaction Source |
Integer |
0 = Input, 1 = System |
Quantity |
Decimal |
Transaction Quantity (Eg. Litre) |
Quantity Opposite |
Decimal |
Transaction Quantity * -1 |
Quantity Sign |
String |
+ or - |
Unit Price |
Decimal |
Transaction Unit Price (Eg. Price per Litre) |
Unit Price Ex GST |
Decimal |
Transaction Unit Price exclude GST |
Amount |
Decimal |
Transaction Amount (Eg Dollar) |
Amount Opposite |
Decimal |
Transaction Amount * -1 |
Amount Sign |
String |
+ or - |
Amount Ex GST |
Decimal |
Transaction Amount exclude GST |
GST |
Decimal |
GST (Eg. Tax Amount) |
GST Sign |
String |
+ or - |
Discount Rate |
Decimal |
Discount Rate |
Discount Type |
Integer |
0 = Cents Per Unit, 1= Percentage |
Discount |
Decimal |
Discount Amount |
Discount Ex GST |
Decimal |
Discount Amount exclude GST |
Surcharge Rage |
Decimal |
Surcharge Rage |
Surcharge Type |
Integer |
0 = Percentage, 1 = Amount |
Surcharge |
Decimal |
Surcharge Amount |
Discom Card Format |
Integer |
0 |
Pump |
Integer |
Pump Number |
Hose |
Integer |
Hose Number |
Voucher Number |
String |
Voucher Number |
Odometer |
Integer |
Odometer |
Total Engine Hours |
Decimal |
Total Engine Hours |
Under Load Hours |
Decimal |
Under Load Hours |
PLU |
String |
PLU (Price Look Up) Code |
SKU |
String |
SKU (Stock Keeping Unit) Number |
Cost Centre |
String |
Cost Centre |
Engine Hours Counter |
Integer |
Engine Hours Counter |
Customer Reference Number |
String |
Customer Reference Number |
Location Code |
String |
Location Code |
Location ID |
String |
Location ID |
Vehicle Name |
String |
Vehicle Name |
Vehicle Asset Number |
String |
Vehicle Asset Number |
Vehicle Fleet Number |
String |
Vehicle Fleet Number |
Vehicle Registration |
String |
Vehicle Registration Number |