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 |