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 Auxiliary 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 |