Page Comparison

...

Field Name	Field Type	Field Length	Description	Notes	UCI Comments
Record Type	varchar2	3	Constant value "001"	Record 001 indicates the beginning of the file and is mandatory.	Use to determine how to parse the record.
Hierarchy ID	varchar2	20	Hierarchy Merchant Number in which the file is created		Merchant ID number for the school/division.
Hierarchy Level No.	varchar2	5	ClientLine Hierarchy Level that the file is being created for.	Refer to Appendix 1
Date	varchar2	8	YYYYMMDD	Displays prior day's date.
Merchant Name	varchar2	65	Merchant Name for the Hierarchy ID the file is being generated for
Filler	varchar2	2399	Spaces	Files will be 1000 character or 2500 fixed length records depending on how many fields are selected. File is padded on the right with spaces.	2500 characters.

...

If there are no funded card type transactions, then report will not contain 003 records.

value MIDYYYYMMDD

YYYYMMDD

numbernumbernumber indicating atnumberFormatted as 999999999.99 YYYYMMDD HH:MM:SS Verification number number

Formatted as 999999999999.99

pertains to Fuel transactionsnumberFormatted as Only pertains to Fuel transactionsOnly pertains to Fuel transactionsnumberOnly pertains to Fuel transactions pertains to Fuel transactionsnumberOnly pertains to Fuel transactionsnumber pertains to Fuel transactionsnumberOnly pertains to Fuel transactionsOnly pertains to Fuel transactions pertains to Fuel transactionsnumberOnly pertains to Fuel transactionsnumberOnly pertains to Fuel transactions pertains to Fuel transactionsnumberOnly pertains to Fuel transactionsOnly pertains to Fuel transactionsnumber pertains to Fuel transactions pertains to Fuel transactions pertains to Fuel transactions Only available for merchants processing with Compass Only available for merchants processing with Compass)numberFormatted as 999999.99 on Compass FE on Compass FENot available for all clients. Project would be required. Pulled from PTS D Record Indentifier Indentifier 497

Field Name

Field Type

Field Length

Description

Notes

UCI Comments

Record Type

varchar2

3

Constant

“003”

The 003 record will provide transaction detail for First Data funded card types. There will be a 003 record for each of the transactions included in the prior day's funding.

Use to determine how to parse the record.

Hierarchy ID

varchar2

20

Hierarchy Merchant Number in which the file is created.

Hierarchy Level No.

varchar2

5

ClientLine Hierarchy Level that the file is being created for.

Refer to Appendix 1

Location ID

varchar2

20

Outlet level MID

Merchant ID number for the school/division.

Location DBA Name

varchar2

80

Doing Business Address Name assigned to the Outlet MID

"UCI MARKETPLACE <highest school/division KFS org code>"

Displayed on customer credit card statement.

Store Number

varchar2

10

Discretionary number setup on the Merchant Master

External ID

varchar2

25

Discretionary Number assigned to Outlet Level

MID

Client Correspondence Flag must be set to a Y

Funded Date/Load Date

varchar2

8

Funded Date is when the settled transaction amount was sent to your bank for payment. Load Date is when the settled transaction are loaded to the database for reporting.

YYYYMMDD
This field will represent Funded Date by default, unless you select to receive this record by Load Date, then this field will display that Load Date.
Load Date doe not indicate that the transactions have been funded

Utilizing Loaded Date (settlement date).

Anchor

	Card Type
	Card Type

Card Type

varchar2

10

Association that the transaction is sent to for processing. Ex. Visa, MC, etc.

Refer to Appendix 2

Corresponds to uPay postback card_type.

Anchor

	Card Number
	Card Number

Card Number

varchar2

25

Unique number assigned to cardholder

Card masking is determined by the Masking Flag attribute in Business Track portal for the user.

Displays first 6, last 4 digits of credit card number.

Terminal ID

varchar2

15

Discretionary POS Identification number

**Currently Clientline Database only stores 5 digits

Batch Number

varchar2

20

Number assigned to each group of settled transactions

Bank of America's ID number for the submitted transaction batch.

Should be the same for all transactions in the same report.

Batch Date

varchar2

8

Date group of transactions was settled

YYYYMMDD

Batch date.

Anchor

	Authorization Code
	Authorization Code

Authorization Code

varchar2

8

6 digit code assigned at the time card was authorized

Authorization/approval code.

Invoice/Trace ID

varchar2

20

Discretionary 12 digit number sent on transaction by merchant

PTS 'S' record

Does not map to TouchNet.

Reference Number

varchar2

30

23 byte Number assigned to each settled transaction prior to sending to the Association

aka ARN

Does not map to TouchNet.

Transaction ID

varchar2

20

Number assigned by the Association

Visa Tran ID or MasterCard Banknet Reference Number

Does not map to TouchNet.

Transaction Date

varchar2

8

Date transactions was processed at POS

Authorization date.

Transaction Amount Sign

varchar2

1

+/-

('+) = Sale (-) = Refund

Corresponds to uPay postback pmt_amt.

Anchor

	Transaction Amount
	Transaction Amount

Transaction Amount

Number

15

Amount of the processed transaction

Processed Currency Code

varchar2

3

ISO 4217 3 digit code representing the Currency the transaction was funded in

Refer to Appendix 3

Submitted Currency Amount Sign

varchar2

1

+/-

('+) = Sale (-) = Refund
Only available merchants setup as multi-currency

Submitted Currency Amount

Number

15

The transaction amount in the currency the transaction was processed in at the POS

Formatted as 999999999999.99
Only available merchants setup as multi-currency

Submitted Currency Code

varchar2

3

ISO 4217 3 digit code representing the Currency the transaction was processed in at the POS

Refer to Appendix 3

Currency Conversion Rate

Number

20

The rate applied to convert a transaction between submitted and processed currency

Formatted as 9999999999.999999999

Anchor

	Transaction Status
	Transaction Status

Transaction Status

varchar2

2

Code

indicating if the transaction was processed (P) or rejected (R)

Refer to Appendix 4

May want to verify that transaction went through.

Reject Indicator

varchar2

1

1 digit code indicating if the transaction was rejected (Y) or accepted (N)

Refer to Appendix 5

May want to verify that transaction went through.

Reject Reason

varchar2

80

Description why a transaction was rejected

Refer to Appendix 6

Entry Mode

varchar2

2

How the transaction was originally performed (ex. Terminal, POS, Chip)

Refer to Appendix 7

PC Terminal Capability

varchar2

1

Code indicating if the card was Present or Not Present

Refer to Appendix 8

Pinless Debit

varchar2

1

Code indicating if the debit card was processed without a PIN

Plan Code

varchar2

4

Interchange Plan Code that the transaction should qualify at

Refer to Appendix 9

Billback Reason

varchar2

10

The code that indicates why a transaction did not clear at the expected rate

Refer to Appendix 10

Reclass Code

varchar2

4

Final plan code that the transaction qualified

at

Refer to Appendix 9

Partial Auth Indicator

varchar2

1

1 digit code indicating if Partial Authorization is supported

Refer to Appendix 11

Transaction Type

varchar2

6

Code indicating the action taken on the card (ex. Sale, Credit, Void)

Refer to Appendix 12

Transaction Mode

varchar2

6

The manor in which a transaction was processed (ex. Electronic, Manual, Swiped)

Refer to Appendix 13

Transaction Source

varchar2

2

How the transaction was sent to us for processing

Refer to Appendix 14

Health Care Card

varchar2

2

Indicator identifying if the card is or isn't a Health Care Card

Refer to Appendix 15

AFD Completion Code

varchar2

2

Automated Fuel Dispenser code. Will only apply to Petroleum clients

Refer to Appendix 16

Authorization Amount Sign

varchar2

1

+/-

('+) = Sale (-) = Refund

Info
As of 27 Oct 2015, Authorization Amount matches Transaction Amount.

Authorization Amount

Number

15

Amount verified as available on a card for a transaction to occur

Formatted as 999999999.99

Anchor

	BAMS Authorization Date
	BAMS Authorization Date

Authorization Date

varchar2

8

Date the verification occurred on a card for a transaction

YYYYMMDD

Transaction Time

varchar2

10

The hour, minute and second when the transaction was performed

HH:MM:SS
Some FE default this value. You need to check with you account management team if this information is available on your processing platform.

Does not correspond to actual transaction time; set to 00:00:00.

Expiration Date

varchar2

4

2 digit month & 2 digit year when a card becomes invalid

Does not correspond to actual expiration date of the card.

Authorization SIC Code

varchar2

4

Standard Industry Code at the time the card was authorized that corresponds
to the client’s Visa Merchant Category Code

AVS Flag

varchar2

1

Code indicating the level of Address

Verification

Refer to Appendix 17

Response Code

varchar2

1

Same as Authorization Response Code

CVC2 Result

varchar2

1

Indicator if Card Verification Code is present for Visa transaction

Refer to Appendix 19

CVV2 Result

varchar2

1

Indicator if Card Verification Value is present for MasterCard transaction

Refer to Appendix 19

Sales Tax Amount Sign

varchar2

1

+/-

('+) = Sale (-) = Refund

Sales Tax Amount

Number

15

Sales Tax Amount on a petroleum transaction

Invoice Amount Sign

varchar2

1

+/-

('+) = Sale (-) = Refund

Invoice Amount

Number

15

Total Amount of all the Product Code Amounts for a Petroleum transaction

Formatted as 999999999999.99

Product Code 1

varchar2

6

NACS Code for the goods purchased
Only

applies to Petroleum

Product Gallons 1

Number

11

Gallons of petroleum associated with the transaction

Formatted as 999999.9999

Product Amount Sign 1

varchar2

1

+/-

('+) = Sale (-) = Refund

Product Amount 1

Number

15

Transaction Amount for Petroleum purchase

Formatted as 999999999999.99

Product Code 2

varchar2

6

NACS Code for multiple goods purchased in a single transaction
Only

applies to Petroleum

Product Gallons2

Number

11

Gallons of petroleum associated with the transaction

Formatted as 999999.9999

Only pertains to Fuel transactions

Product Amount Sign 2

varchar2

1

+/-

('+) = Sale (-) = Refund

Product Amount 2

Number

15

Transaction Amount for Petroleum purchase

Formatted as 999999999999.99

Only pertains to Fuel transactions

Product Code 3

varchar2

6

NACS Code for multiple goods purchased in a single transaction
Only

applies to Petroleum

Product Gallons 3

Number

11

Gallons of petroleum associated with the transaction

Formatted as 999999.9999

Product Amount Sign 3

varchar2

1

+/-

Only pertains to Fuel transactions

Product Amount 3

number

15

('+) = Sale (-) = Refund

Product Amount 3

Number

15

Transaction Amount for Petroleum purchase

Formatted as 999999999999.99

Product Code 4

varchar2

6

NACS Code for multiple goods purchased in a single transaction
Only

applies to Petroleum

Product Gallons 4

Number

11

Gallons of petroleum associated with the transaction

Formatted as 999999.9999

Only pertains to Fuel transactions

Product Amount Sign 4

varchar2

1

+/-

('+) = Sale (-) = Refund

Product Amount 4

Number

15

Transaction Amount for Petroleum purchase

Formatted as 999999999999.99

Product Code 5

varchar2

6

NACS Code for multiple goods purchased in a single transaction
Only

applies to Petroleum

Product Gallons 5

Number

11

Gallons of petroleum associated with the transaction

Formatted as 999999.9999

Product Amount Sign 5

varchar2

1

+/-

('+) = Sale (-) = Refund

Product Amount 5

Number

15

Transaction Amount for Petroleum purchase

Formatted as 999999999999.99

Only pertains to Fuel transactions

Vehicle Number

varchar2

17

VIN associated with Fleet Card
Only

applies to Petroleum

Odometer

varchar2

10

Odometer Number associated with Fleet Card
Only

applies to Petroleum

Driver ID

varchar2

20

Drivers License Number associated with Fleet Card
Only

applies to Petroleum

Special Reference #1

varchar2

25

Discretionary field sent by merchant

PTS XN07-Merchant Order Number -

Compass FE only

Special Reference #2

varchar2

25

Discretionary field sent by merchant

PTS XN08- Tracking Number -

Compass & Omnipay FE only

Authorization Response Code

varchar2

2

Code that indicates the response on an attempted transaction. (ex. Approval, decline, etc.

Refer to Appendix 18

Convenience Fee Amount Sign

varchar2

1

Available for merchants participating in Convenience Fee program

Convenience Fee Amount

Number

9

Available for merchants participating in Convenience Fee program

Formatted as 999999.99

SubMerchant ID

varchar2

20

Available for PSPs

only

Soft Descriptor

varchar2

32

Available for PSPs

only

Bank Reference Number

varchar2

20

*Client specific field not available for use*

Auth Source

varchar2

1

How the transaction was sent for authorization

CAT Level

varchar2

1

Indicator if it is a Card Holder Activated terminal

Cardholder ID Method

varchar2

1

Indicates how the Cardholder was identified by the Merchant. This field is only required for VISA transactions

Card Presence Indicator

varchar2

1

Anchor

	Merchant Reference Number
	Merchant Reference Number

Merchant Reference Number

varchar2

9

Discretionary field sent by merchant

Available on all Front Ends
PTS 'D' record

Appears to be sequential ID number that starts at 1. May loosely tie to uPay postback tpg_trans_id, but reliability questionable.

Total Auth Amount Sign

varchar2

1

+/-

('+) = Sale (-) = Refund

Do NOT use for matching. Does not necessarily match uPay postback pmt_amt.

Total Auth Amount

varchar2

15

Total Amount authorized for a transaction

Market Specific Indicator

varchar2

1

Indicates the industry for which market-specific authorization data was included in the transaction

Space No market-specific authorization data supplied
A Valid Auto Rental market-specific authorization data received
B Valid Bill Payment market-specific authorization data received
E Valid Electronic Commerce Transaction Aggregation data received
H Valid Hotel market-specific authorization data received
M Valid Healthcare market-specific authorization data received
N Invalid or not applicable market-specific authorization data received
T Valid Transit market-specific authorization data received

Visa Service Develop

varchar2

1

Indicates type of commerce

1 Electronic Commerce
2 In-Flight Commerce
5 Transponder-Initiated
6 Relationship Participant
7 Deferred Billing Indicator

Visa Purchase

Identifier Format

varchar2

1

Specifies the format/type of additional identifying information for purchases, e.g. order or invoice number, free text

Do NOT use for matching. May see partial value for "sys_tracking_id", but unreliable.

Visa Purchase

Identifier

varchar2

25

The Purchase Identifier information.

Visa Chip Condition Code

varchar2

1

Code provides information about magnetic stripe-read transactions of VSDC cards at VSDC ATMs

It does not apply to VSDC transactions where the chip is read

MC Security Protocol

varchar2

1

Indicates the presence and type of security protocol present in the authorization process in support of UCAF

2 Channel Encrypted
9 No Security Protocol

MC Cardholder Authentication

varchar2

1

Visa Product ID

varchar2

2

Authentication indicates the type of Cardholder authentication used in the authorization process in support of UCAF

0 UCAF data collection is not supported by the Merchant
1 UCAF data collection is supported by the Merchant, but UCAF data was not populated
2 UCAF data collection is supported by the Merchant, and UCAF data must be present
3 UCAF data collection is supported by the Merchant, and UCAF (MasterCard assigned Static Accountholder
Authentication Value) data must be present

Visa Product ID

varchar2

2

the Card-Level Results value received in the authorization response

For Custom Payment Service original purchase transactions and their reversals. This field is required for interchange qualifications

Transaction Country

varchar2

3

Country the card is issued

2500 characters.

Transaction Charges Sign

varchar2

1

+/-

('+) = Sale (-) = Refund

Transaction Charges

Number

21

*Omnipay only* Interchange charges per transaction

Formatted as 999999999999999999.99

Capture Method

varchar2

3

Product Code 6

varchar2

6

NACS Code for multiple goods purchased in a single transaction
Only applies to Petroleum

Product Gallons 6

Number

11

Gallons of petroleum associated with the transaction

Formatted as 999999.9999

Product Amount Sign 6

varchar2

1

+/-

('+) = Sale (-) = Refund

Product Amount 6

Number

15

Transaction Amount for Petroleum purchase

Formatted as 999999999999.99

Product Code 7

varchar2

6

NACS Code for multiple goods purchased in a single transaction
Only applies to Petroleum

Product Gallons 7

Number

11

Gallons of petroleum associated with the transaction

Formatted as 999999.9999

Product Amount Sign 7

varchar2

1

+/-

('+) = Sale (-) = Refund

Product Amount 7

Number

15

Transaction Amount for Petroleum purchase

Formatted as 999999999999.99

Product Code 8

varchar2

6

NACS Code for multiple goods purchased in a single transaction
Only applies to Petroleum

Product Gallons 8

Number

11

Gallons of petroleum associated with the transaction

Formatted as 999999.9999

Product Amount Sign 8

varchar2

1

+/-

('+) = Sale (-) = Refund

Product Amount 8

Number

15

Transaction Amount for Petroleum purchase

Formatted as 999999999999.99

Product Code 9

varchar2

6

NACS Code for multiple goods purchased in a single transaction
Only applies to Petroleum

Product Gallons 9

Number

11

Gallons of petroleum associated with the transaction

Formatted as 999999.9999

Product Amount Sign 9

varchar2

1

+/-

('+) = Sale (-) = Refund

Product Amount 9

Number

15

Transaction Amount for Petroleum purchase

Formatted as 999999999999.99

Product Code 10

varchar2

6

NACS Code for multiple goods purchased in a single transaction
Only applies to Petroleum

Product Gallons 10

Number

11

Gallons of petroleum associated with the transaction

Formatted as 999999.9999

Product Amount Sign 10

varchar2

1

+/-

('+) = Sale (-) = Refund

Product Amount 10

Number

15

Transaction Amount for Petroleum purchase

Formatted as 999999999999.99

Usage Indicator

varchar2

1

Indicator to identify if credit transaction is Credit ('C) or Signature Debit (D)

Airline Ticket Number

varchar2

20

Airline Industry only

User Data

varchar2

32

*Note* use the User Data 2 field instead of User Data

Comprised of the XN02-XN06 PTS records

Transaction Integrity Class

varchar2

2

Associated with MasterCard transactions where the card brand is assigning a rating to the transaction based on the security and integrity of the transaction.

Assessments Sign

varchar2

1

*Client specific field not available for use*

Assessments

Number

17

Formatted as 999999999999.9999

*Client specific field not available for use*

Service Charges Sign

varchar2

1

*Client specific field not available for use*

Service Charges

Number

17

Formatted as 999999999999.9999

*Client specific field not available for use*

Interchange Rate Sign

varchar2

1

*Client specific field not available for use*

Interchange Rate

Number

20

Formatted as 9999999999.999999999

*Client specific field not available for use*

Per Tran Fee Sign

varchar2

1

*Client specific field not available for use*

Per Tran Fee

Number

15

Formatted as 999999999999.99

*Client specific field not available for use*

Mobile Indicator

varchar2

2

Indicator that a transaction originated from the Ucomm Gateway

*Client specific field not available for use*

User Data 2

varchar2

145

Discretionary data sent on transaction by the merchant

Comprised of the XN02-XN06 PTS records

Posting Charge Description 1

varchar2

65