Arrangement of Data Elements

The following sections discuss the arrangement of data elements in the EGSF:

1. File Header Record (TFH)

DATA ELEMENT

GLOSSARY NUMBER

OPTIONAL CONDITIONAL MANDATORY

ALPHA NUMERIC

NO. OF CHARACTERS

FIELD LIMITS

RECORD TYPE IDENTIFIER

R15

M

A-N

3

1-3

RECORD NUMBER

R10

M

N

9

4-12

CREATION DATE AND TIME

C115

M

N

10

13-22

FILE IDENTIFICATION

F10

M

A-N

6

23-28

FILE TRANMISSION DATE

F20

M

N

6

29-34

FILE RECEIVER

F15

M

A-N

8

35-42

PROCESSOR ID

P70

O

A-N

9

43-51

PROCESSOR NAME

P75

O

A-N

20

52-71

PROCESSOR BUILDING NUMBER

P50

O

A-N

20

72-91

PROCESSOR STREET NAME

P85

O

A-N

20

92-111

PROCESSOR CITY

P55

O

A-N

20

112-131

PROCESSOR COUNTRY

P60

O

A-N

20

132-151

PROCESSOR ZIP CODE

P90

O

A-N

9

152-160

PROCESSOR PHONE NUMBER

P80

O

A-N

20

161-180

PROCESSOR FAX NUMBER

P65

O

A-N

20

181-200

SITA TELEX NUMBER

S45

O

A-N

10

201-210

E-MAIL ADDRESS

E20

O

A-N

160

211-370

VERSION

V25

M

N

4

371-374

FILLER

F25

M

A-N

130

375-500

2. Batch Header Record (TBH)

DATA ELEMENT

GLOSSARY NUMBER

OPTIONAL CONDITIONAL MANDATORY

ALPHA NUMERIC

NO. OF CHARACTERS

FIELD LIMITS

RECORD TYPE IDENTIFIER

R15

M

A-N

3

1-3

RECORD NUMBER

R10

M

N

9

4-12

MERCHANT IDENTIFICATION

M25

M

A-N

15

13-27

SETTLEMENT IDENTIFIER

S35

M

N

6

28-33

INVOICE NUMBER

I35

C

A-N

14

34-47

INVOICE DATE

I30

M

N

6

48-53

CURRENCY INDICATOR CODE

C135

M

N

3

54-56

SE NUMBER

S20

M

N

17

57-73

SETTLEMENT CURRENCY

S30

M

N

3

74-76

MERCHANT NAME

M30

M

A-N

20

77-96

PROCESSOR BUILDING NUMBER

P50

O

A-N

20

97-116

PROCESSOR STREET NAME

P85

O

A-N

20

117-136

PROCESSOR CITY

P55

O

A-N

20

137-156

PROCESSOR COUNTRY

P60

O

A-N

20

157-176

PROCESSOR ZIP CODE

P90

O

A-N

9

177-185

PROCESSOR PHONE NUMBER

P80

O

A-N

20

186-205

PROCESSOR FAX NUMBER

P65

O

A-N

20

206-225

SITA TELEX NUMBER

S45

O

A-N

10

226-235

FILLER

F25

M

A-N

265

236-500

3. Transaction Header Record (THR)

DATA ELEMENT

GLOSSARY NUMBER

OPTIONAL CONDITIONAL MANDATORY

ALPHA NUMERIC

NO. OF CHARACTERS

FIELD LIMITS

RECORD TYPE IDENTIFIER

R15

M

A-N

3

1-3

RECORD NUMBER

R10

M

N

9

4-12

DATA RECORD SEQUENCE NO

D10

M

N

9

13-21

SOC NUMBER

S55

M

N

8

22-29

SOC TEXT

S50

M

A-N

30

30-59

FILLER

F25

M

A-N

441

60-500

4. Transaction Advice Basic Record (TAB)

DATA ELEMENT

GLOSSARY NUMBER

OPTIONAL CONDITIONAL MANDATORY

ALPHA NUMERIC

NO. OF CHARACTERS

FIELD LIMITS

RECORD TYPE IDENTIFIER

R15

M

A-N

3

1-3

RECORD NUMBER

R10

M

N

9

4-12

TRANSACTION RECORD COUNT

T170

M

N

2

13-14

ACCOUNT NUMBER

A10

M

A-N

19

15-33

POS ENTRY MODE

P40

M

N

2

34-35

CARDHOLDER ID METHOD

C65

M

A-N

1

36

TRANSACTION TYPE IDENTIFIER

T195

M

N

2

37-38

TRANSACTION AMOUNT

T140

M

N

13

39-51

POS TERMINAL CAPABILITY

P45

M

A-N

1

52

FILLER

F25

M

A-N

1

53

DEBT REPAYMENT INDICATOR

D50

M

A-N

1

53

CURRENCY INDICATOR CODE

C140

M

N

3

54-56

ELAVON CURRENT TOKEN TYPE

E10

O

A-N

2

57-58

UNIQUE TRANSACTION REFERENCE NUMBER

U25

O

A-N

11

59-69

APPROVAL CODE

A80

M

A-N

6

70-75

AUTHORIZATION SOURCE

A150

O

N

2

76-77

TRANSACTION CURRENCY CODE

T150

M

N

3

78-80

COUNTRY CODE

C110

O

A-N

3

81-83

TRANSACTION DATE

T155

M

N

6

84-89

TRANSACTION TIME

T185

O

N

6

90-95

TRANSACTION REFERENCE (ROC)

T175

O

A-N

30

96-125

STATE/PROVINCE CODE

S70

O

A-N

2

126-127

MCC

M20

M

A-N

4

128-131

REFERENCE CODE

R20

O

A-N

15

132-146

EXPIRATION DATE

E25

O

N

4

>147-150

POINT OF SALE NAME

P35

C

A-N

25

151-175

AGENCY CODE NUMBER

A25

C

A-N

8

176-183

DE22 POINT OF SERVICE DATA CODE

D20

C

A-N

12

184-195

PRODUCT ID

P95

M

A-N

2

196-197

CVV2 RESULTS CODE

C165

C

A-N

1

198

DYNAMIC CVV2 RESULT CODE

D135

C

A-N

1

199

CAT CODE

C45

C

A-N

1

200

ECI OR MOTO INDICATOR

E05

C

A-N

2

201-202

UCAF COLLECTION INDICATOR

U05

C

A-N

1

203

TRANSACTION IDENTIFIER

T160

C

A-N

15

204-218

VALIDATION CODE

V05

C

A-N

4

219-222

BANKNET REFERENCE NUMBER

B10

C

A-N

9

223-231

BANKNET DATE

B05

C

N

4

232-235

SYSTEM TRACE AUDIT NUMBER

S95

C

N

6

236-241

TRANSACTION DATA CONDITION CODE

T135

C

N

2

242-243

NETWORK REFERENCE ID

N35

C

A-N

15

244-258

AUTHORIZATION RESPONSE CODE

A95

O

A-N

2

259-260

ACI

A20

M

A-N

1

261

AVS RESPONSE CODE

A110

C

A-N

2

262-263

AUTHORIZED AMOUNT

A155

M

N

13

264-276

CONDITION CODE

C95

O

A-N

4

277-280

CASH BACK AMOUNT

C80

O

N

9

281-289

FILLER

F25

O

N

4

290-293

CARDHOLDER AMOUNT

C50

M

N

13

294-306

CARDHOLDER CURRENCY CODE

C60

M

N

3

307-309

CONVERSION RATE

C100

C

N

8

310-317

CUSTOMER FILE REFERENCE #

C150

O

A-N

27

318-344

PURCHASE ID FORMAT

P110

O

A-N

1

345

PURCHASE IDENTIFIER

P115

O

A-N

25

346-370

SALES TAX INDICATOR

S10

O

N

1

371

SALES TAX AMOUNT

S05

O

N

9

372-380

DCC EXPONENT

D130

C

N

1

381

SURCHARGE AMOUNT

S85

O

N

13

382-394

TERMINAL ID

T40

O

A-N

8

395-402

CARD TYPE IDENTIFIER

C40

O

A-N

2

403-404

DEBIT NETWORK ID

D35

O

A-N

2

405-406

DEBIT SETTLEMENT DATE

D45

O

A-N

4

407-410

DEBIT INTERCHANGE INDICATOR

D30

O

A-N

1

411

SPEND QUALIFIED INDICATOR

S60

O

A-N

1

412

MULTIPLE CLEARING SEQUENCE NUMBER & COUNT

M100

O

N

4

413-416

ACCOUNT STATUS

A15

O

A-N

1

417

TOKEN ASSURANCE LEVEL

T80

O

A-N

2

418-419

PAN ACCOUNT RANGE

P05

O

N

9

420-428

RETRIEVAL REFERENCE NUMBER

R50

O

A-N

12

429-440

TOTAL AUTHORIZED AMOUNT

T90

O

N

13

441-453

TOKEN REQUESTOR ID

T85

O

A-N

11

454-464

MSADI

M05

O

A-N

1

465

CUSTOMER SERVICE PHONE #

C155

O

N

10

466-475

NUMBER OF PAYMENT FORMS

N55

O

A-N

1

476

DIGITAL ENTITY IDENTIFIER

D85

C

A-N

5

477-481

WALLET IDENTIFIER

W05

C

A-N

4

482-485

MASTERCARD ASSIGNED ID

M15

O

A-N

6

486-491

IN-APP ECOMMERCE INDICATOR

I05

O

A-N

1

492

STORED CREDENTIAL INDICATOR

S75

C

A-N

1

493

INCREMENTAL AUTHORIZATION INDICATOR

I10

C

N

2

494-495

SECURITY PROTOCOL

S15

M

A

1

496

CARDHOLDER AUTHENTICATION

C55

C

A-N

1

497

TRANSACTION INTEGRITY CLASS

T165

M

A-N

2

498-499

MPOS ACCEPTANCE DEVICE INDICATOR

M90

C

N

1

500

5. Transaction Auxilary Record (TAR)

DATA ELEMENT

GLOSSARY NUMBER

OPTIONAL CONDITIONAL MANDATORY

ALPHA NUMERIC

NO. OF CHARACTERS

FIELD LIMITS

RECORD TYPE IDENTIFIER

R15

M

A-N

3

1-3

RECORD NUMBER

R10

M

N

9

4-12

HOST DCC REFERENCE NUMBER

H25

C

N

14

13-26

ACCOUNTABLE AUTHENTICATION VALUE

A05

C

A-N

32

27-58

DIRECTORY SERVER TRANSACTION ID

D90

C

A-N

36

59-94

PROGRAM PROTOCOL

P105

C

A-N

1

95

PAYMENT ACCOUNT REFERENCE NUMBER (PAR Value)

P10

C

A-N

35

96 - 130

FILLER

F25

M

A-N

370

131-500

6. Transaction Airline Addendum Record (TAA)

Note: The optional/conditional/mandatory column for this record (TAA) has been split into two types of transaction columns, Ticket and Ancillary. In addition, an asterisk (*) has been added next to the M for any field which is required for a credit/refund transaction.

DATA ELEMENT

GLOSSARY NUMBER

OPTIONAL CONDITIONAL MANDATORY

ALPHA NUMERIC

NO. OF CHARACTERS

FIELD LIMITS

 

 

Ticket

Ancillary

 

 

 

RECORD TYPE IDENTIFIER

R15

M*

M*

A-N

3

1-3

RECORD NUMBER

R10

M*

M*

N

9

4-12

ACCOUNT NUMBER

A10

M*

M*

A-N

19

13-31

PASSENGER NAME

P25

M*

M*

A-N

20

32-51

ROUTING

R55

 

A-N

20

52-71

— Stop over code #1

 

M

O

a-n

1

 

— Airport / city code #1

 

M

O

a-n

3

 

— Stop over code #2

 

O

O

a-n

1

 

— Airport / city code #2

 

O

O

a-n

3

 

— Stop over code #3

 

O

O

a-n

1

 

— Airport / city code #3

 

O

O

a-n

3

 

— Stop over code #4

 

O

O

a-n

1

 

— Airport / city code #4

 

O

O

a-n

3

 

— Stop over code #5

 

O

O

a-n

1

 

— Airport / city code #5

 

O

O

a-n

3

 

CARRIER CODE(S)

C75

 

A-N

8

72-79

— Carrier – coupon #1

 

M

O

a-n

2

 

— Carrier – coupon #2

 

O

O

a-n

2

 

— Carrier – coupon #3

 

O

O

a-n

2

 

— Carrier – coupon #4

 

O

O

a-n

2

 

FARE BASIS

F05

 

A-N

24

80-103

— Fare Basis/Ticket Designator – coupon #1

 

M

O

a-n

6

 

— Fare Basis/Ticket Designator – coupon #2

 

O

O

a-n

6

 

— Fare Basis/Ticket Designator – coupon #3

 

O

O

a-n

6

 

— Fare Basis/Ticket Designator – coupon #4

 

O

O

a-n

6

 

DOCUMENT TYPE

D110

M*

M*

A-N

2

104-105

MULTIPLE CLEARING SEQUENCE NUMBER & COUNT

M100

C

O

N

4

106-109

DEPARTURE DATE

D60

M

M

N

6

110-115

FILLER

F25

M*

M*

A-N

18

116-133

TICKET IDENTIFIER (TICKET NUMBER)

T65

M*

n/a

A-N

14

134-147

TICKET / DOCUMENT AMOUNT

T70

M*

O

N

13

148-160

TRANSACTION TYPE

T190

M*

M*

A-N

3

161-163

RECORD LOCATOR

R05

M

O

A-N

6

164-169

PLACE OF ISSUE

P30

M*

M*

A-N

15

170-184

TICKETING CARRIER

T75

M

O

N

3

185-187

CLASS OF SERVICE

C90

 

A-N

4

188-191

— Class of Service coupon 1

 

M

O

a-n

1

 

— Class of Service coupon 2

 

O

O

a-n

1

 

— Class of Service coupon 3

 

O

O

a-n

1

 

— Class of Service coupon 4

 

O

O

a-n

1

 

FLIGHT DATE

F35

 

A-N

24

192-215

— Flight Date coupon 1

 

M

O

a-n

6

 

— Flight Date coupon 2

 

O

O

a-n

6

 

— Flight Date coupon 3

 

O

O

a-n

6

 

— Flight Date coupon 4

 

O

O

a-n

6

 

FLIGHT NUMBER

F45

 

A-N

20

216-235

— Flight Number coupon 1

 

C

O

a-n

5

 

— Flight Number coupon 2

 

O

O

a-n

5

 

— Flight Number coupon 3

 

O

O

a-n

5

 

— Flight Number coupon 4

 

O

O

a-n

5

 

FLIGHT DEPARTURE TIME

F40

 

A-N

20

236-255

— Flight departure time coupon 1

 

C

O

a-n

5

 

— Flight departure time coupon 2

 

O

O

a-n

5

 

— Flight departure time coupon 3

 

O

O

a-n

5

 

— Flight departure time coupon 4

 

O

O

a-n

5

 

RESTRICTED TICKET

R45

O

O

N

1

256

START STATION

S65

O

O

A-N

30

257-286

DESTINATION STATION

D75

O

O

A-N

30

287-316

PASSENGER DESCRIPTION

 

 

 

 

 

NUMBER OF ADULTS

P15

O

O

N

2

317-318

PASSENGER DESCRIPTION

 

O

O

 

 

 

NUMBER OF CHILDREN

P20

O

O

N

2

319-320

ELECTRONIC TICKET INDICATOR

E15

O

O

A-N

1

321

ANCILLARY TICKET DOCUMENT NUMBER

A55

O

M*

A-N

14

322-335

ANCILLARY SERVICE CATEGORY / ANCILLARY FEE CODE

A45

 

A-N

16

336-351

— Ancillary Service / Fee Code Category 1

 

O

M*

A-N

4

 

— Ancillary Service / Fee Code Category 2

 

O

O

A-N

4

 

— Ancillary Service / Fee Code Category 3

 

O

O

A-N

4

 

— Ancillary Service / Fee Code Category 4

 

O

O

A-N

4

 

ANCILLARY FEE DESCRIPTION

A40

O

O

A-N

13

352-364

ANCILLARY SUB CATEGORY

A50

 

A-N

16

365-380

— Ancillary Sub Category 1

 

O

O

A-N

4

 

— Ancillary Sub Category 2

 

O

O

A-N

4

 

— Ancillary Sub Category 3

 

O

O

A-N

4

 

— Ancillary Sub Category 4

 

O

O

A-N

4

 

ISSUED in CONNECTION with TICKET NUMBER

I40

O

M*

A-N

14

381-394

CREDIT REASON INDICATOR

C120

O

O

A-N

1

395

TICKET CHANGE INDICATOR

T60

O

O

A-N

1

396

ANCILLARY FEE AMOUNT

A35

O

O

N

48

397-444

— Ancillary Fee Amount Category 1

 

O

M*

N

12

 

— Ancillary Fee Amount Category 2

 

O

O

N

12

 

— Ancillary Fee Amount Category 3

 

O

O

N

12

 

— Ancillary Fee Amount Category 4

 

O

O

N

12

 

FILLER

F25

M*

M*

A-N

56

445-500

7. Transaction Car Rental Addendum Record (TCR)

DATA ELEMENT

GLOSSARY NUMBER

OPTIONAL CONDITIONAL MANDATORY

ALPHA NUMERIC

NO. OF CHARACTERS

FIELD LIMITS

RECORD TYPE IDENTIFIER

R15

M

A-N

3

1-3

RECORD NUMBER

R10

M

N

9

4-12

MSADI

M05

M

A-N

1

13

BUSINESS FORMAT CODE

B30

M

A-N

2

14-15

CAR CHECK OUT DATE

C05

M

N

6

16-21

CAR RETURN DATE

C30

M

N

6

22-27

CAR RENTAL CUSTOMER SERVICE TELEPHONE NUMBER

C15

M

A-N

10

28-37

CAR RENTAL PROPERTY TELEPHONE NUMBER

C20

M

A-N

10

38-47

CAR RENTAL RETURN LOCATION ID

C25

M

A-N

10

48-57

RENTER NAME

R40

O

A-N

20

58-77

RENTAL RETURN CITY

R25

O

A-N

18

78-95

RENTAL RETURN STATE

R35

O

A-N

2

96-97

RENTAL RETURN COUNTRY CODE

R30

O

A-N

3

98-100

DAYS RENTED

D15

O

N

2

101-102

DAILY RENTAL RATE

D05

O

N

12

103-114

WEEKLY RENTAL RATE

W10

O

N

12

115-126

CAR CLASS CODE

C10

O

A-N

2

127-128

NO SHOW INDICATOR

N40

O

A-N

1

129

EXTRA CHARGES INDICATOR

E35

O

A-N

6

130-135

FILLER

F25

M

A-N

365

136-500

8. Transaction Hotel/Lodging Addendum Record (THL)

DATA ELEMENT

GLOSSARY NUMBER

OPTIONAL CONDITIONAL MANDATORY

ALPHA NUMERIC

NO. OF CHARACTERS

FIELD LIMITS

RECORD TYPE IDENTIFIER

R15

M

A-N

3

1-3

RECORD NUMBER

R10

M

N

9

4-12

MSADI

M05

M

A-N

1

13

BUSINESS FORMAT CODE

B30

M

A-N

2

14-15

HOTEL CHECK IN DATE

H25

M

N

6

16-21

HOTEL CHECK OUT DATE

H30

M

N

6

22-27

HOTEL CUSTOMER SERVICE TELEPHONE NUMBER

H35

M

A-N

10

28-37

HOTEL PROPERTY TELEPHONE NUMBER

H40

M

A-N

10

38-47

GIFT SHOP PURCHASES

G05

O

N

12

48-59

MOVIE CHARGES

M95

O

N

12

60-71

BUSINESS CENTER CHARGES

B25

O

N

12

72-83

HEALTH CLUB CHARGES

H20

O

N

12

84-95

OTHER CHARGES

O15

O

N

12

96-107

TOTAL NON-ROOM CHARGES

T125

O

N

12

108-119

NO SHOW INDICATOR

N40

O

A-N

1

120

EXTRA CHARGES INDICATOR

E35

O

A-N

6

121-126

FILLER

F25

M

A-N

374

127-500

9. Transaction Chip Card Addendum Record (TCC)

DATA ELEMENT

GLOSSARY NUMBER

OPTIONAL CONDITIONAL MANDATORY

ALPHA NUMERIC

NO. OF CHARACTERS

FIELD LIMITS

RECORD TYPE IDENTIFIER

R15

M

A-N

3

1-3

RECORD NUMBER

R10

M

N

9

4-12

CHIP CONDITION CODE

C80

M

A-N

1

13

APPLICATION REQUEST

 

 

 

 

 

CRYPTOGRAM

A70

M

A-N

16

14-29

CRYPTOGRAM INFORMATION DATA

C130

M

A-N

2

30-31

ISSUER APPLICATION DATA

I45

M

A-N

64

32-95

UNPREDICTABLE NUMBER

U30

M

A-N

8

96-103

APPLICATION TRANSACTION COUNTER

A75

M

A-N

4

104-107

TERMINAL VERIFICATION RESULTS

T55

M

A-N

10

108-117

AUTHORIZATION DATE

A90

M

N

6

118-123

CRYPTOGRAM TRANSACTION TYPE

C135

M

A-N

2

124-125

AUTHORIZED AMOUNT

A155

M

N

13

126-138

AUTHORIZATION CURRENCY CODE

A85

M

A-N

4

139-142

APPLICATION INTERCHANGE

 

 

 

 

 

PROFILE

A65

M

A-N

4

143-146

TERMINAL COUNTRY CODE

T35

M

A-N

4

147-150

CASH BACK AMOUNT

C75

C

N

9

151-159

FILLER

F25

M

N

4

160-163

TERMINAL CAPABILITIES PROFILE

T30

M

A-N

6

164-169

CVM RESULTS

C70

M

A-N

6

170-175

TERMINAL TYPE

T50

M

A-N

2

176-177

INTERFACE DEVICE SERIAL NO

I25

M

A-N

16

178-193

APPLICATION EXPIRATION DATE

A60

M

N

6

194-199

TRANSACTION CATEGORY CODE

T145

M

A-N

2

200-201

DEDICATED FILE NAME

D55

M

A-N

32

202-233

TERMINAL APPLICATION

 

 

 

 

 

VERSION NO

T25

M

A-N

4

234-237

TERMINAL TRANSMISSION DATE

T45

M

N

6

238-243

TRANSACTION SEQUENCE COUNTER

T180

M

A-N

8

244-251

CARD SEQUENCE NUMBER

C35

M

N

3

252-254

ISSUER SCRIPT RESULTS part 1

I50

M

A-N

24

255-278

ISSUER SCRIPT RESULTS part 2

I55

M

A-N

18

279-296

DEVICE TYPE

D80

C

A-N

2

297-298

FORM FACTOR

F50

C

A-N

8

299-306

FILLER

F25

M

A-N

194

307-500

10. Transaction Installment Addendum Record (TIL)

DATA ELEMENT

GLOSSARY NUMBER

OPTIONAL CONDITIONAL MANDATORY

ALPHA NUMERIC

NO. OF CHARACTERS

FIELD LIMITS

RECORD TYPE IDENTIFIER

R15

M

A-N

3

1-3

RECORD NUMBER

R10

M

N

9

4-12

TYPE OF INSTALLMENT

T200

M

A-N

3

13-15

NUMBER OF INSTALLMENTS

N50

M

N

2

16-17

TOTAL INSTALLMENT AMOUNT

T115

M

N

13

18-30

BOARDING FEE AMOUNT

B20

C

N

13

31-43

DOWN PAYMENT AMOUNT

D115

C

N

13

44-56

INSTALLMENT DEFERRAL INDICATOR

I20

C

N

2

57-58

TYPE OF PLAN

T205

M

N

2

59-60

FIRST PAYMENT DATE

F30

C

N

6

61-66

INDICATOR OF DEFERRED PAYMENT

I15

O

A-N

6

67-72

SUBSEQUENT INSTALLMENT AMOUNT

S80

O

N

13

73-85

FILLER

F25

M

A-N

415

86-500

11. Dynamic Merchant Address Addendum Record (TMA)

DATA ELEMENT

GLOSSARY NUMBER

OPTIONAL CONDITIONAL MANDATORY

ALPHA NUMERIC

NO. OF CHARACTERS

FIELD LIMITS

RECORD TYPE IDENTIFIER

R15

M

A-N

3

1-3

RECORD NUMBER

R10

M

N

9

4-12

DYNAMIC MERCHANT DBA NAME

D155

M

A-N

25

13-37

DYNAMIC MERCHANT CITY

D145

C

A-N

13

38-50

DYNAMIC MERCHANT STATE

D170

C

A-N

2

51-52

DYNAMIC MERCHANT ZIP CODE

D180

C

A-N

9

53-61

DYNAMIC MERCHANT COUNTRY CODE

D150

C

A-N

3

62-64

DYNAMIC MERCHANT STREET ADDRESS

D175

C

A-N

30

65-94

DYNAMIC MERCHANT PHONE NUMBER

D165

C

A-N

20

95-114

DYNAMIC MERCHANT EMAIL ADDRESS

D160

C

A-N

40

115-154

DYNAMIC MERCHANT CATEGORY CODE (MCC)

D140

C

N

4

155-158

DYNAMIC SUB-MERCHANT ID

D185

C

N

15

159-173

DYNAMIC SUB-MERCHANT TAX ID

D190

C

A-N

14

174-187

FILLER

F25

M

A-N

313

188-500

12. Transaction Visa Fleet Card Addendum Record (TVF)

DATA ELEMENT

GLOSSARY NUMBER

OPTIONAL CONDITIONAL MANDATORY

ALPHA NUMERIC

NO. OF CHARACTERS

FIELD LIMITS

RECORD TYPE IDENTIFIER

R15

M

A-N

3

1-3

RECORD NUMBER

R10

M

N

9

4-12

TYPE OF PURCHASE

T210

M

A-N

1

13

FUEL TYPE

F65

C

A-N

2

14-15

MOTOR FUEL UNIT OF MEASURE

M80

C

A-N

1

16

FUEL QUANTITY

F60

C

N

13

17-29

GROSS FUEL PRICE

G10

C

N

13

30-42

MISC FUEL TAX EXEMPTION STATUS

M45

O

A-N

1

43

CUSTOMER CODE

C145

M

A-N

17

44-60

MOTOR FUEL SERVICE TYPE

M75

O

A-N

1

61

ODOMETER

O05

O

A-N

7

62-68

NON-FUEL PRODUCT CODE 1

N45

O

A-N

3

69-71

NON-FUEL PRODUCT CODE 2

N45

O

A-N

3

72-74

NON-FUEL PRODUCT CODE 3

N45

O

A-N

3

75-77

NON-FUEL PRODUCT CODE 4

N45

O

A-N

3

78-80

NON-FUEL PRODUCT CODE 5

N45

O

A-N

3

81-83

NON-FUEL PRODUCT CODE 6

N45

O

A-N

3

84-86

NON-FUEL PRODUCT CODE 7

N45

O

A-N

3

87-89

NON-FUEL PRODUCT CODE 8

N45

O

A-N

3

90-92

NET FUEL PRICE

N20

O

N

13

93-105

GROSS NON FUEL PRICE

G15

O

N

13

106-118

NET NON FUEL PRICE

N30

O

N

13

119-131

PURCHASE TIME

P120

O

N

4

132-135

UNIT COST

U15

O

N

13

136-148

MISC FUEL TAX

M40

O

N

13

149-161

MISC NON FUEL TAX

M50

O

N

13

162-174

MISC NON FUEL TAX EXEMPTION STATUS

M55

O

A-N

1

175

VAT/TAX RATE

V15

O

N

4

176-179

PRODUCT TYPE CODE

P100

M

A-N

1

180

BUSINESS FORMAT CODE

B30

M

A-N

2

181-182

DRIVER ID

D120

C

A-N

17

183-199

VAT TAX AMOUNT

V10

O

N

13

200-212

FILLER

F25

M

A-N

288

213-500

Note: Conditional indicates needed if fuel information is sent and attempting to qualify for best rate. Whereas optional indicates send if available.

13. Transaction MasterCard Fleet Card Addendum Record (TMF)

DATA ELEMENT

GLOSSARY NUMBER

OPTIONAL CONDITIONAL MANDATORY

ALPHA NUMERIC

NO. OF CHARACTERS

FIELD LIMITS

RECORD TYPE IDENTIFIER

R15

M

A/N

3

1-3

RECORD NUMBER

R10

M

N

9

4-12

MOTOR FUEL UNIT OF MEASURE

M80

C

A/N

1

13

MOTOR FUEL QUANTITY

M65

C

N

6

14-19

MC OIL COMPANY BRAND NAME

M10

M

N

4

20-23

MOTOR FUEL SERVICE TYPE

M75

M

A/N

1

24

MOTOR FUEL PRODUCT CODE

M60

C

N

3

25-27

MOTOR FUEL UNIT PRICE

M85

C

N

13

28-40

MOTOR FUEL SALE AMOUNT

M70

C

N

13

41-53

ODOMETER

O05

C

A/N

7

54-60

VEHICLE NUMBER

V20

C

A/N

17

61-77

DRIVER ID

D120

C

A/N

17

78-94

COUPON DISCOUNT AMOUNT

C110

O

N

13

95-107

TAX AMOUNT 1

T10

O

A/N

13

108-120

TAX AMOUNT 2

T15

O

A/N

13

121-133

NON-FUEL PRODUCT CODE 1

N45

C

A/N

3

134-136

PURCHASE TIME

P120

M

N

4

137-140

NET GROSS INDICATOR

N25

O

A/N

1

141

TAX AMOUNT

T05

O

A/N

13

142-154

DEBIT/CREDIT IDENTIFIER

D25

C

A/N

1

155

ITEM DESCRIPTION

I65

C

A/N

35

156-190

ITEM QUANTITY

I75

C

A/N

5

191-195

ITEM UNIT OF MEASURE

I80

C

A/N

3

196-198

EXTENDED ITEM AMOUNT

E30

C

N

13

199-211

DISCOUNT INDICATOR

D100

O

A/N

1

212

DISCOUNT AMOUNT

D95

O

N

13

213-225

PRODUCT TYPE CODE

P100

M

A/N

1

226

FILLER

F25

M

A/N

274

227-500

Note: Conditional indicates needed if fuel information is sent and attempting to qualify for best rate. Whereas optional indicates send if available.

14. Transaction Visa Line Item Detail Addedum Record (TVL)

DATA ELEMENT

GLOSSARY NUMBER

OPTIONAL CONDITIONAL MANDATORY

ALPHA NUMERIC

NO. OF CHARACTERS

FIELD LIMITS

RECORD TYPE IDENTIFIER

R15

M

A-N

3

1-3

RECORD NUMBER

R10

M

N

9

4-12

DISCOUNT AMOUNT

D95

M

N

13

13-25

FREIGHT/SHIPPING AMOUNT

F55

M

N

13

26-38

DUTY AMOUNT

D125

M

N

13

39-51

ITEM COMMODITY CODE

I60

M

A-N

12

52-63

ITEM DESCRIPTOR

I65

M

A-N

35

64-98-

ITEM PRODUCT CODE

I70

M

A-N

12

99-110

ITEM QUANTITY

I75

M

A-N

5

111-115

UNIT OF MEASURE

U20

M

A-N

12

116-127

UNIT COST

U15

M

N

13

128-140

DISCOUNT PER LINE ITEM

D105

M

N

13

141-153

LINE ITEM TOTAL

L05

M

N

13

154-166

SALES TAX INDICATOR

S10

M

N

1

167

SALES TAX AMOUNT

S05

M

N

9

168-176

CUSTOMER CODE

C145

M

A-N

17

177-193

DESTINATION POSTAL/ZIP CODE

D70

O

A-N

10

194-203

SHIP FROM POSTAL/ZIP CODE

S40

O

A-N

10

204-213

DESTINATION COUNTRY CODE

D65

O

A-N

3

214-216

ORDER DATE

O10

O

N

6

217-222

SUMMARY COMMODITY CODE

S85

O

A-N

4

223-226

MERCHANT VAT REG/SINGLE BUSINESS REFERENCE NUMBER

M35

O

A-N

20

227-246

CUSTOMER VAT REGISTRATION NUMBER

C160

O

A-N

15

247-261

UNIQUE VAT INVOICE REFERENCE NUMBER

U10

O

A-N

15

262-276

NATIONAL TAX

N05

O

N

13

277-289

NATIONAL TAX INDICATOR

N10

O

N

1

290

VAT/TAX AMOUNT

V10

O

N

13

291-303

VAT TAX RATE

V15

O

N

4

304-307

OTHER TAX

O20

O

N

12

308-319

FILLER

F25

M

A-N

181

320-500

15. Transaction MasterCard Line Item Detail Addendum Record (TML)

DATA ELEMENT

GLOSSARY NUMBER

OPTIONAL CONDITIONAL MANDATORY

ALPHA NUMERIC

NO. OF CHARACTERS

FIELD LIMITS

RECORD TYPE IDENTIFIER

R15

M

A-N

3

1-3

RECORD NUMBER

R10

M

N

9

4-12

ITEM PRODUCT CODE

I70

M

A/N

12

13-24

ITEM DESCRIPTION

I65

M

A/N

35

25-59

ITEM QUANTITY

I75

M

A/N

5

60-64

ITEM UNIT OF MEASURE

I80

M

A/N

3

65-67

EXTENDED ITEM AMOUNT

E30

M

N

13

68-80

DEBIT OR CREDIT INDICATOR

D25

M

A/N

1

81

DISCOUNT INDICATOR

D100

O

A/N

1

82

DISCOUNT AMOUNT

D95

O

N

13

83-95

NET/GROSS INDICATOR FOR EXTENDED ITEM AMOUNT

N25

O

A/N

1

96

SALES TAX INDICATOR

S10

M

A/N

1

97

SALES TAX AMOUNT

S05

M

N

9

98-106

CUSTOMER CODE

C145

M

A/N

17

107-123

TAX RATE APPLIED

T15

O

N

5

124-128

TAX TYPE APPLIED

T20

O

A/N

4

129-132

TAX AMOUNT

T05

O

A/N

13

133-145

ALTERNATE TAX IDENTIFIER

A30

O

A/N

15

146-160

FILLER

F25

M

A-N

340

161-500

16. Batch Trailer Record (TBT)

DATA ELEMENT

GLOSSARY NUMBER

OPTIONAL CONDITIONAL MANDATORY

ALPHA NUMERIC

NO. OF CHARACTERS

FIELD LIMITS

RECORD TYPE IDENTIFIER

R15

M

A-N

3

1-3

RECORD NUMBER

R10

M

N

9

4-12

MERCHANT IDENTIFICATION

M25

M

A-N

15

13-27

SETTLEMENT IDENTIFIER

S35

M

N

6

28-33

INVOICE NUMBER

I35

M

A-N

14

34-47

INVOICE DATE

I30

M

N

6

48-53

TOTAL DEBIT ITEMS

T110

M

N

6

54-59

TOTAL DEBIT AMOUNT

T105

M

N

13

60-72

TOTAL CREDIT ITEMS

T100

M

N

6

73-78

TOTAL CREDIT AMOUNT

T95

M

N

13

79-91

TOTAL ITEM COUNT

T120

M

N

6

92-97

NET AMOUNT

N15

M

N

13

98-110

SETTLEMENT AMOUNT

S25

M

N

13

111-123

FILLER

F25

M

A-N

377

124-500

17. File Summary Record (TFS)

DATA ELEMENT

GLOSSARY NUMBER

OPTIONAL CONDITIONAL MANDATORY

ALPHA NUMERIC

NO. OF CHARACTERS

FIELD LIMITS

RECORD TYPE IDENTIFIER

R15

M

A-N

3

1-3

RECORD NUMBER

R10

M

N

9

4-12

CREDIT RECORD COUNT

C125

M

N

9

13-21

DEBIT RECORD COUNT

D40

M

N

9

22-30

HASH CREDIT VALUE

H05

M

N

15

31-45

HASH DEBIT VALUE

H10

M

N

15

46-60

HASH NET VALUE

H15

M

N

15

61-75

TOTAL RECORD COUNT

T130

M

N

9

76-84

BATCH COUNT

B15

M

N

4

85-88

FILLER

F25

M

A-N

412

89-500