Home > PAN Updates > Formatting a Request File


Formatting a Request File

Account Updater request files must be in CSV format with a maximum file size of 10 MB.

The format for a request file consists of:

nA header record.

nA detail record with one or more data records, each on a separate line.

nA footer record, which indicates the end of the file.

Header Record

The header record consists of comma-separated values and uses the fields listed in the following table:

Table 1 Header Record Fields

Field Name

Description

Required or Optional

Data Type (length|)

Record Identifier

Constant value indicating the record type.

Format: H

Required

Alpha (1)

File Classification

Indicates whether this is a request or response file.

Format: cybs.au.request.pan

Required

Alpha (30)

merchantID

Your CyberSource merchant ID.

Format: sampleID2

Required

Alphanumeric (30)

batchID

File (batch) identifier that you assign. The batch ID must be unique. If you send a file that contains a previously submitted batch ID, the file is rejected.

Format: 12345

Required

Numeric (30)

recordCount

The number of detail records in the file.

Format: 12345

Required

Numeric

statusEmail

Email address to which status emails for the request are sent.

Format: aaa@aaa.aaa

Required

Alphanumeric (100)

creationDate

Optional field that you can pass for reference. If present, it appears in the Business Center Account Updater View Status window.

Format: YYYY-MM-DD

Optional

(10)

Batch Info

Optional field that you can pass for reference.

Format: sample12

Optional

Alphanumeric (50)

Detail Record

Each file must contain at least one detail record.

Table 2Detail Record Fields

Field Name

Description

Required or Optional

Data Type (length)

Record Identifier

Constant value indicating the record type.

Format: D

Required

Alpha (1)

Card Number

Card number to process.

Format: Numeric

Required

Numeric (19)

Card Expiration Month

Expiration month of the card.

Format: MM

Required

Alphanumeric (2)

Card Expiration Year

Expiration year of the card.

Format: YY

Required

Numeric (2)

Merchant Reference ID

You can use this field to track your Account Updater request records. If this field is populated, the same value is returned in the Account Updater response file.

Format: sampleID2

Optional

Alphanumeric (50)

BA Sub Merchant ID

This field is required for billing aggregator merchants only.

Format: sampleID2

Optional

Alphanumeric (10)

Footer Record

Each file should contain only one footer record.

Table 3Footer Record Field

Field Name

Description

Required or Optional

Data Type (length)

Record Identifier

Constant value indicating the record type.

Format: F

Required

Alpha (1)

Request File Examples

Example 1Request File for Non-Billing Aggregator Merchants

H,cybs.au.request.pan,merchant1,001,2,notify@yourcompany.com,2009-03-23,My Jan Batch

D,1111222233334444,11,09,0001

D,2222333344445555,11,09,0002

F

Example 2Request File for Billing Aggregator Merchants

H,cybs.au.request.pan,merchant1,001,2,notify@yourcompany.com,2009-03-23,My Jan Batch

D,1111222233334444,11,09,0001,subId01

D,2222333344445555,11,09,0002,subId02

F