up Version >= 2.3.0

Export Fields Description

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