T2551 Exhibit 3 - Inbound Daily File for Credit Cards 1.14.26.xls
XLS spreadsheet 51 KB Posted
- Attached to
- T2551 Credit Card Payment Processing
- Solicitation number
- 26DPP01223
- Issued by
- New Jersey
About this file
This file is a technical specification document for the inbound daily file format used by the New Jersey Division of Revenue for Bid Solicitation #26DPP01223, which concerns Credit Card Payment Processing. The document defines the data structure and field requirements for processing credit card payments, including both header and detail records. The specification establishes the record layout requirements for vendors submitting daily payment files to the state, with records formatted to a fixed length of 1,500 characters. Header records contain aggregate payment information such as total payment amounts, convenience fees, transmission dates and times, and record counts. Detail records capture individual credit card transaction information including taxpayer identification, payment amounts, settlement dates, card types, billing address information, confirmation numbers, email addresses, phone numbers, and deposit codes.
The technical specification accommodates multiple payment methods including Visa/Mastercard, American Express, and Discover cards, with the file structure designed to support various payment scenarios such as prenotes, failed prenotes, and notices of change. The format requires vendors to populate specific character positions with alphanumeric data and includes dedicated fields for source indicators distinguishing between web-based and phone-based payments. The document establishes mandatory field designations, data type requirements (alphanumeric fields), and filler sections within the fixed-length record structure. This specification serves as the operational standard for vendors selected to process credit card payments on behalf of New Jersey's Division of Revenue, ensuring consistent data formatting and accurate reconciliation of payment transactions and associated convenience fees.
View the file
Other files
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Inbound Daily File - Header
| New Jersey Division of Revenue | ||||||
| Inbound Daily File - Header | ||||||
| Exhibit 3 (Bid Solicitation Section 4.16) | ||||||
| Credit Card Payment Processing: State Of New Jersey | ||||||
| Bid Solicitation # 26DPP01223 | ||||||
| Start | End | Field | Data | Field | ||
| Position | Position | Length | Type | Description | Comments | Edit Rules/Notes |
| R means Required Field | ||||||
| 1 | 5 | 5 | A/N | HDR - Sort Key | Value blanks | |
| 6 | 13 | 8 | A/N | HDR - Record Count | ||
| 14 | 23 | 10 | A/N | HDR - Total Payment Amt | ||
| 24 | 33 | 10 | A/N | HDR - Total Convenience Fee Amt | ||
| 34 | 43 | 10 | A/N | HDR - Charged Amt | ||
| 44 | 51 | 8 | A/N | HDR - Transmit Date | CCYYMMDD | |
| 52 | 57 | 6 | A/N | HDR - Transmit Time | HHMMSS | |
| 58 | 65 | 8 | A/N | HDR - Extract Date | ||
| 66 | 1499 | 1434 | A/N | Filler | ||
| 1500 | 1500 | 1 | A/N | HDR - End of Record |
Inbound Daily File - Detail
| New Jersey Division of Revenue | |||||
| Inbound Daily File - Detail Record | |||||
| Exhibit 3 (Bid Solicitation Section 4.16) | |||||
| T2551 Credit Card Payment Processing | |||||
| Bid Solicitation # 26DPP01223 | |||||
| Start | End | Field | Data | Field | |
| Position | Position | Length | Type | Description | Comments |
| 1 | 5 | 5 | A/N | CCR- Payment Type Code | |
| 6 | 30 | 25 | A/N | CCR- Taxpayer ID | I followed by 9 digit Social Security number and 3 zeroes if Individual; B followed by 12 digit Taxpayer ID number if any other |
| 31 | 34 | 4 | A/N | NCTL | |
| 35 | 104 | 70 | A/N | Name | |
| 105 | 114 | 10 | A/N | CCR - Payment Amount | Prenote, Failed Prenote, NOC always zero |
| 115 | 122 | 8 | A/N | CCR- Settlement Date | CCYYMMDD |
| 123 | 130 | 8 | A/N | CCR - Transmit Date | CCYYMMDD |
| 131 | 134 | 4 | A/N | CCR- Return Year | |
| 135 | 136 | 2 | A/N | Return Month | |
| 137 | 138 | 2 | A/N | Return Day | |
| 139 | 141 | 3 | A/N | Payment Method | V = Visa/Mastercard; A = American Express; D = Discover |
| 142 | 142 | 1 | A/N | Bill Indicator | 1 if a payment for a bill, else spaces |
| 143 | 152 | 10 | A/N | CCR - Convenience Fee Amt | |
| 153 | 162 | 10 | A/N | CCR - Total Charged Amt | |
| 163 | 165 | 3 | A/N | CCR - Vendor ID | |
| 166 | 166 | 1 | A/N | CCR - Filing Type | R, N or F for Individual (Reg or Est or Ext) Income Tax; Spaces for any other |
| 167 | 170 | 4 | A/N | CCR - Card Type | V = Visa/Mastercard; A = American Express; D = Discover |
| 171 | 220 | 50 | A/N | CCR - Billing Name | |
| 221 | 260 | 40 | A/N | CCR - Billling Street Address 1 | |
| 261 | 300 | 40 | A/N | CCR - Billling Street Address 2 | |
| 301 | 330 | 30 | A/N | CCR - Billing City | |
| 331 | 332 | 2 | A/N | CCR - Billing State | |
| 333 | 341 | 9 | A/N | CCR - Billing Zip Code | |
| 342 | 356 | 15 | A/N | CCR - Confirmation Number | |
| 357 | 365 | 9 | A/N | Filler | |
| 366 | 382 | 17 | A/N | Filler | |
| 383 | 383 | 1 | A/N | Filler | |
| 384 | 431 | 48 | A/N | CCR - Customer Transaction ID | |
| 432 | 501 | 70 | A/N | CCR - Email | E-mail address if Internet filing, else spaces |
| 502 | 511 | 10 | A/N | CCR - Deposit Code Number | |
| 512 | 512 | 1 | A/N | CCR - Source Indicator | W if Web; P if Phone |
| 513 | 522 | 10 | A/N | CCR - Phone Number | |
| 523 | 538 | 16 | A/N | CCR - Last 4 Numbers | |
| 539 | 544 | 6 | A/N | CRAS Sub Acct Code | |
| 545 | 594 | 50 | A/N | Misc Info - 01 | |
| 595 | 644 | 50 | A/N | Misc Info - 02 | |
| 645 | 694 | 50 | A/N | Misc Info - 03 | |
| 695 | 744 | 50 | A/N | Misc Info - 04 | |
| 745 | 794 | 50 | A/N | Misc Info - 05 | |
| 795 | 844 | 50 | A/N | Misc Info - 06 | |
| 845 | 894 | 50 | A/N | Misc Info - 07 | |
| 895 | 944 | 50 | A/N | Misc Info - 08 | |
| 945 | 994 | 50 | A/N | Misc Info - 09 | |
| 995 | 1044 | 50 | A/N | Misc Info - 10 | |
| 1045 | 1094 | 50 | A/N | Misc Info - 11 | |
| 1095 | 1144 | 50 | A/N | Misc Info - 12 | |
| 1145 | 1496 | 352 | A/N | Filler | |
| 1497 | 1499 | 3 | A/N | Deposit Code | |
| 1500 | 1500 | 1 | A/N | End of Record |
File details come from the government source that posted it. Updated .