Tyler Technologies Account Balance Extract Import Specification
(updated July 30, 2015)
The file definition for importing balances from Tyler Technologies are as follows. The filename has a suffix of ".txt". The fixed-length extract file contains one account per record with no header record. The file may contain Account Numbers for both Treasurer and Assessor accounts. The Treasurer account numbers are all numeric and the Assessor account numbers contain at least one letter. When importing the file the only the appropriate account numbers are imported based on the name of the merchant as defined in CORE Payments. If the merchant name contains the word "Treasurer" only all numeric accounts will be imported and if the merchant name contains the word "Assessor" only account numbers that contain at least one letter will be imported. The fields in each record are fixed length as follows:
Account Balance Extract (fixed length) Used to provide a breakdown of charges outstanding on a set of accounts |
|||||
Field | Name | Len | Start | End | Description |
1 | ACCOUNT NUMBER | 14 | 1 | 14 | Account Number (Treasurer account numbers are all numeric, Assessor's contain at least one letter) |
2 | OWNER NAME | 34 | 15 | 48 | Owner Name |
3 | CARE OF | 34 | 49 | 82 | Owner Care Of |
4 | ADDRESS 1 | 34 | 83 | 116 | Owner Address Line 1 |
5 | ADDRESS 2 | 34 | 117 | 150 | Owner Address Line 2 |
6 | CITY | 20 | 151 | 170 | Owner City |
7 | STATE | 2 | 171 | 172 | Owner State |
8 | ZIPCODE | 5 | 173 | 177 | Owner Zip Code |
9 | ZIPCODE ADD ON | 4 | 178 | 181 | Owner Zip Code +4 |
10 | PRIOR YEAR DUE | 1 | 182 | 182 | "Y" if the account has unpaid prior year charges, "N" otherwise |
11 | TAX YEAR | 4 | 183 | 186 | The current tax year |
12 | FIRST HALF BILLED | 9 | 187 | 195 | First Half Principle Billed (Two decimal place assumed) |
13 | FIRST HALF PAID | 9 | 196 | 204 | First Half Principle Paid (Two decimal place assumed) |
14 | FIRST HALF LATE FEES | 9 | 205 | 213 | All first half interest, penalty, and miscellaneous charges (Two decimal place assumed) |
15 | DELINQUENT FIRST HALF DUE | 9 | 214 | 222 | Total delinquent charges due for the first half (Two decimal place assumed) |
16 | FIRST HALF TOTAL | 9 | 223 | 231 | Total due for the first half (Two decimal place assumed) |
17 | SECOND HALF BILLED | 9 | 232 | 240 | Second Half Principle Billed (Two decimal place assumed) |
18 | SECOND HALF PAID | 9 | 241 | 249 | Second Half Principle Paid (Two decimal place assumed) |
19 | SECOND HALF LATE FEES | 9 | 250 | 258 | All second half interest, penalty, and miscellaneous charges (Two decimal place assumed) |
20 | DELINQUENT SECOND HALF DUE | 9 | 259 | 267 | Total delinquent charges due for the second half (Two decimal place assumed) |
21 | SECOND HALF TOTAL | 9 | 268 | 276 | Total due for the second half (Two decimal place assumed) |
22 | TOTAL BILLED | 9 | 277 | 285 | Total Principle Billed (Two decimal place assumed) |
23 | TOTAL PAID | 9 | 286 | 294 | Total Principle Paid (Two decimal place assumed) |
24 | TOTAL LATE FEES | 9 | 295 | 303 | All interest, penalty, and miscellaneous charges (Two decimal place assumed) |
25 | DELINQUENT TOTAL DUE | 9 | 304 | 312 | Total delinquent charges due (Two decimal place assumed) |
26 | TOTAL DUE | 9 | 313 | 321 | Total due (Two decimal place assumed) |
27 | PARCEL NUMBER | 19 | 322 | 340 | The parcel number for the account |
28 | LEGAL | 175 | 341 | 515 | The account's legal description |
Tyler Technologies Easy File Payment Import Export Specification
The file definition for exporting payments to Tyler Technologies follows their Easy File Payment Import Specification. The filename has a suffix of ".txt". The tab delimited and contains one account per record with no header record. The fields in each record are tab delimited as follows:
Field | Name | Format | Description |
1 | Account Number | string | Account number used in Tyler Technologies software and CORE Payments |
2 | Amount Paid | fixed point number | Amount paid as a fixed point number with two decimal places - may be negative for returned payments |
3 | Type | char | (optional) Method of payment (C:Checking, S:Savings, B:Business checking, V:Visa, M:Mastercard, D:Discover, or A:Amex) |
4 | Memo | string | (optional) Memo provided by payor |
5 | Reference Number | string | Payment ID from CORE Payments to reference payment |
~ Our Solutions ~ Privacy Policy ~ Contact Us ~
CORE Payments Version 4.1.17016; (API: 2.22)