Mark-Off File (First National Bank)

Name

Type(Length)

Offset

Description

Header

Record Type

N(1)

1-1

Value of 0

Chain Name Code

ANS(5)

2-6

The code associated with the chain. Left-justified, space padded. Eg. 'ECOM'

Merchant Number

N(6)

7-12

FNB Merchant number - will always be zero on the header record.

Settlement Batch Date

N(6)

13-18

The settlement batch date for the file in YYMMDD format.

File Generation

N(5)

19-23

File generation number (Number that is incremented daily by 1).

Filler

NS(303)

24-326

Filler. To be used for future use. Left-justified, space padded.

Detail

Record Type

N(1)

1-1

Value of 1

Chain ID

AN(5)

2-6

Chain ID code. Left-justified, space padded. Eg. 'ECOM'

Merchant ID

ANS(15)

7-21

The Merchant ID. Left-justified, space-padded.

Terminal ID

NS(12)

22-33

The Terminal ID. Right-justified, zero-padded. Eg. '000000123456'

Account ID

ANS(15)

34-48

Account ID Code - The store number. Only populated when requested. Space padded.

Card Category

AN(2)

49-50

Indicates the card type. CC - Credit; DR - Debit; AC - Amex; DC - Diners; PC - Petrol; FC - Fleet

Process Code

N(6)

51-56

Indicates type of transaction. First 2 digits: 00 purchase, 20 refund. Last 4 digits: 1000/2000 debit, 3000 credit, 4000 fleet, 5000 petrol, 9000 private label.

Shift Number

AN(3)

57-59

Shift category of transaction.

Batch Number

N(6)

60-65

Batch number of transaction.

Sequence Number

AN(6)

66-71

System-generated sequence number.

Retrieval Number

AN(12)

72-83

Reference number of service provider.

Transaction Date

N(8)

84-91

Transaction date (CCYYMMDD).

Transaction Time

N(6)

92-97

Transaction time (HHMMSS).

Filler

N(8)

98-105

For future use. Padded with zeros. Eg. '00000000'.

Card Number

NS(19)

106-124

The masked plastic card number. Right-justified, zero-padded. First 6 and last 4 digits displayed (excluding masking), with the rest being masked.

Expiry Date

N(4)

125-128

Expiry date on card (YYMM).

Currency Code

AN(3)

129-131

The transaction currency code. Default value - 710 (SA).

Transaction Amount

N(12)

132-143

Transaction value in cents.

Cashback Transaction Amount

N(12)

144-155

Cashback transaction value in cents - applicable to certain debit card transactions.

POS Code

N(3)

156-158

Indicates manual, swiped or EMV.

Reason Code

N(3)

159-161

Reason code - default value zero for accepted transactions; non-zero indicates rejected transaction.

Auth Code

AN(6)

162-167

Authorization code.

Cashier Number

N(4)

168-171

The cashier/operator ID. For future use. Represented by zeros when value not present.

Supervisor Number

N(6)

172-177

The supervisor ID. For future use

Budget Plan

N(2)

178-179

For future use. Represented by zeros when value not present.

Usage Number

ANS(1)

180-180

This field is used to indicate if the card is a special private label card when required.

Unique Reference Number

ANS(30)

181-210

Populated where required. Left-justified, space-padded.

System Trace Audit Number

AN(6)

211-216

System trace audit number

GUID

ANS(36)

217-252

Globally unique identifier. Obtained from the QK Token.

Filler

ANS(83)

253-335

For future use. Represented by Spaces

Trailer

Record Type

N(1)

1-1

Value 9

Chain ID

ANS(5)

2-6

The code associated with the chain. Left-justified, space padded. Eg. 'ECOM'

Merchant Number

N(6)

7-12

All 9's in trailer record

Record Count

N(8)

13-20

Number of records, including header and trailer records

Amount total 1

N(13)

21-33

Total value (in cents) of the transaction records where the Reason Code field is zero

Amount total 2

N(13)

34-46

Total value (in cents) of the transaction records where the Reason Code field is not zero

Filler

ANS(280)

47-326

Filler. Represented by Spaces