...
| Field Name | Field Type | Field Length | Description | Notes | UCI Comments | ||
|---|---|---|---|---|---|---|---|
| Record Type | varchar2 | 3 | Constant “004” | The 004 record will provide transaction detail for card types that are processed through First Data but not funded by First Data. There will be a 004 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). | ||
| Card Type | varchar2 | 10 | Association that the transaction is sent to for processing. Ex. Visa, MC, etc. | Appendix 2 | Corresponds to uPay postback card_type. | ||
| 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 | |||
| 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 | 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 | ||||
| Transaction Amount Sign | varchar2 | 1 | +/- | ('+) = Sale (-) = Refund | Corresponds to uPay postback pmt_amt. | ||
| 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 | |||
| 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 |
| ||
| Authorization Amount | Number | 15 | Amount verified as available on a card for a transaction to occur | Formatted as 999999999.99 |
| ||
| 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 | |||
| Product Amount Sign 2 | varchar2 | 1 | +/- | ('+) = Sale (-) = Refund | |||
| Product Amount 2 | Number | 15 | Transaction Amount for Petroleum purchase | Formatted as 999999999999.99 | |||
| 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 | +/- | ('+) = 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 | |||
| 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 | |||
| 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. | 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 | 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 | |||||
| Merchant Reference Number | varchar2 | 9 | 8 digit Discretionary field sent by merchant | Available on all Front Ends PTS 'D' record (this # is used as part of the 23 digit Reference Number) | 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 | ||||
| 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 | |||
| Assessments Sign | varchar2 | 1 | *Client specific field not available for use* | +/- | |||
| Assessments | Number | 17 | *Client specific field not available for use* | Formatted as 999999999999.9999 | |||
| Service Charges Sign | varchar2 | 1 | *Client specific field not available for use* | +/- | |||
| Service Charges | Number | 17 | *Client specific field not available for use* | Formatted as 999999999999.9999 | |||
| Interchange Rate Sign | varchar2 | 1 | *Client specific field not available for use* | +/- | |||
| Interchange Rate | Number | 20 | *Client specific field not available for use* | Formatted as 9999999999.999999999 | |||
| Per Tran Fee Sign | varchar2 | 1 | *Client specific field not available for use* | +/- | |||
| Per Tran Fee | Number | 15 | *Client specific field not available for use* | Formatted as 999999999999.99 | |||
| 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 | |||
| Filler | 1092 | 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. |
...