PT File Layout Spec 2.0.3

Column

Requirement Name

Max

Length

Type

Description

1 - A

Site ID Number

6

N

 CFN site number

2 - B

Sequence Number

4

N

POS allocated transaction number

3 - C

Status Code

2

N

 

4 - D

Total amount (99999.99)

8

N

Total dollar amount

5 - E

Transaction Type

2

N

 

6 - F

Product Code

4

N

CFN product code. 

7 - G

Product Type

10

A

Describes the type of product sold.  Current values are FUEL, CSTORE

8 - H

Product Description

20

A

Describes Product in Prod code field

9 - I

Price (999.99999)

9

N

Price excluding taxes.

10 - J

Quantity (99999.999)

9

N

 

11 - K

Odometer (9999999)

7

N

 

12 - L

Pump number or register number

2

N

 

13 - M

Transaction number

4

N

 

14 - N

Date completed (yymmdd)

6

N

The transaction date, in YYMMDD format

15 - O

Time Completed (hhmm) 24-hour time

4

N

The transaction time in HHMM format.

16 - P

Error Code

2

N

 

17 - Q

Authorization Number

6

N

 

18 - R

Manual Entry

8

N

 

19 - S

Card-ID string

20

N

*Use Text Editor program for complete card-string view.

20 - T

Vehicle Identifier

8

A

New, unique vehicle identifier within customer (e.g license plate number)

21 - U

Site tax location

12

N

Tax location expanded to three digits

22 – 31

V - Z

Site tax codes

40

N

10 columns (each element max length 4)

32 – 41

AA - AO

Site tax amounts

100

N

10 columns (each element max length 10: S999.99999)

42 - AP

Transaction Location Indicator

1

A

R for remote

D for local domestics

F for foreign

N for network domestics,

E for Extended Network

C for Contract

43 - AQ

Network Indicator

 

2

A

CF for CFN transaction

TC for T-chek transaction

44 - AR

Network Rate (9.9999)

6

N

Network Discount Rate

45 - AS

Pump Price (999.99999)

9

N

This will be the Pump Unit Price.

46 - AT

Haul Rate (9.9999)

6

N

 

47 - AU

CFN Price (999.99999)

9

N

This is the price including all taxes not rounded. Previously called Cardlock Price.

48 - AV

Job Number

15

A

Job Number associated with Transaction

49 - AW

PO/Invoice Number

15

A

PO or Invoice Number associated with transaction

50 - AX

Custom Prompt 1

20

A

Card/Driver/Vehicle attribute prompt for transaction

51 - AY

Custom Prompt Value 1

15

A

Value for custom prompt 1

52 - AZ

Custom Prompt 2

20

A

Card/Driver/Vehicle attribute prompt for transaction

53 – BA

Custom Prompt Value 2

15

A

Value for custom prompt 1

54 – BB

Custom Prompt 3

20

A

Card/Driver/Vehicle attribute prompt for transaction

55 - BC

Custom Prompt Value 3

15

A

Value for custom prompt 1

 

Notes on Table:

Type:  Field value type can be N (Numerical) or A (AlphaNumeric)

Max Length:  How many characters does the field occupy in each record

Card-String:  Use Text Editor type program to get complete card-string information