Tax Sale Redemption Datasource
The tax sale redemption datasource HTML file, used in the Create Tax Sale Redemption Notices task, offers the following fields. When you create the Word® document , you embed these datasource fields into the document.
IMPORTANT: To use the latest Tax Sale Redemption_datasource.htm, you must download the file. To copy Tax Sale Redemption_datasource.htm from Manage Correspondence Files to your local work area, right click on the file name and use Save As. Be sure to remember where you save the file.
|
ID |
ID |
|
BidderNumber |
Buyer Number |
|
BidderName |
Buyer Name |
|
BidderAddr |
Buyer Address |
|
BidderCity |
Buyer City |
|
BidderState |
Buyer State |
|
BidderZip |
Buyer Zip |
|
BidderEmail |
Buyer Email Address |
|
TotalFaceAmount |
Total Amount |
|
TotalOtherFees |
Total of Other Fees |
|
TotalInterest |
Total Interest |
|
TotalPayable |
Total Amount Due |
|
TotalCount |
Total Count |
|
Field1 |
Value entered on notice screen for Field 1. Limit for the field is 30 characters. |
|
Field2 |
Value entered on notice screen for Field 2. Limit for the field is 30 characters. |
|
Field3 |
Value entered on notice screen for Field 3. Limit for the field is 30 characters. |
|
Field4 |
Value entered on notice screen for Field 4. Limit for the field is 30 characters. |
|
Field5 |
Value entered on notice screen for Field 5. Limit for the field is 30 characters. |
|
Identifier |
|
|
AdditionalCertName |
This field will hold the additional name to print along with the Buyer name on Certificate documents. |
|
TempBiddingNo |
The temporary bidding number (paddle number) used by some jurisdictions. This will be used for importing Buyer and Tax Sale Payment information in some jurisdictions. |
|
InternetUserName |
User Name assigned to the Buyer when registered in the internet provider site. - Informational |
|
CompanyName |
Company Name of the person who registered on the internet. – informational |
|
TaxReturnName |
Name of the entity responsible for paying taxes on interest |
|
BusinessName |
Business Name of the entity responsible to pay taxes on interest. |
|
Safekeeping |
Indicator to determine whether the certificates are being held by the county (safekeeping = True) or if the certificates are held by Buyer (safekeeping = False). |
|
ACHIndicator |
True or False – set to true if the ACH Use Code in the import file is 1, otherwise false. |
|
EffectiveDate |
|
|
EffectiveMonth |
|
|
EffectiveYear |
|
|
PaidByName |
|
|
PaidByAddr |
|
|
PaidByCity |
|
|
PaidByState |
|
|
PaidByPostalCd |
|
|
Phone |
|
|
RedeemAmount |
|
|
RedeemAmountText |
|
|
EndorsedPmtDate |
|
|
TotEndorsedPmtAmount |
|
|
TotEndorsedRedeemInterest |
|
|
TableStart:Detail |
|
|
BuyerID |
Buyer ID number |
|
PIN |
Parcel Identification Number for the Tax Sale Item |
|
TaxYear |
Tax year of the bills included in the correspondence. |
|
BillNumber |
Tax bill number |
|
SaleYear |
Year of the Tax Sale |
|
SaleDate |
Date of the Tax Sale |
|
SaleDescr |
Description of the Tax Sale |
|
CertificateNumber |
Certificate Number |
|
MinBidAmt |
Minimum bid amount |
|
RedemptEndPeriod |
End of Redemption Period |
|
IsAssignAgency |
Indicates if the tax sale item is assigned to the Agency for Unbid items |
|
BuyerAmount |
Amount the Buyer paid |
|
IntRate |
Interest rate |
|
BidderNumber |
Buyer Number |
|
OwnerName |
Jan 1st owner for the tax year of the bill included in the notice. |
|
OwnerAddr |
Jan 1st owner address for the tax year of the bill included in the notice. |
|
OwnerCity |
Jan 1st owner city for the tax year of the bill included in the notice. |
|
OwnerState |
Jan 1st owner state for the tax year of the bill included in the notice. |
|
OwnerZip |
Jan 1st owner zip for the tax year of the bill included in the notice. |
|
RedemptDate |
Date the item was redeemed |
|
IsRedeemed |
True or False if the Item is redeemed |
|
CollectorName |
Name of the tax collector |
|
GEOCode |
GEO code of the revenue object |
|
LegalDescr |
Legal description of the revenue object. Or, if it exists, the Tax Sale Description for Bundled Items. |
|
LegalDescrAddtl |
Additional characters for legal description |
|
LevyTaxYear |
Levy tax year |
|
SaleDayOrdinal |
Day (number) of sale |
|
SaleMonthDescr |
Month of sale |
|
ReceiptNumber |
Receipt Number |
|
FaceAmount |
The Amount of the Item |
|
OtherFees |
Any Fees |
|
Interest |
Any Interest |
|
Payable |
Amount Due |
|
EndorsedPaidDate |
Date endorsement paid |
|
EndorsedPaidMonth |
Month endorsement paid |
|
EndorsedPaidDay |
Day endorsement paid |
|
EndorsedPaidYear |
Year endorsement paid |
|
EndorsedPaidAmount |
Amount of endorsement paid |
|
EndorsedTaxYear |
Tax year of endorsement |
|
EndorsedPIN |
Endorsed PIN |
|
EndorsedRedeemAmount |
Endorsed redemption amount |
|
EndorsedRedeemInt |
Endorsed redemption interest |
|
EndorsedRedeemFee |
Endorsed redemption fee |
|
Identifier |
Identifier |
|
TableEnd:Detail |
|
Tips
See Correspondence Files for more information on creating a mail merge document.