Refund Writeoff Export

File Type: Fixed Length

File location: /dti/exchange/cm. The file name is specified when generating the export in REFUND WRITEOFF.

Record	L	Field
Holder Record	2	1 plus space (Holder record begins)
	8	00000001 (report ID)
	8	Sequence ID (will be zeros)
	9	Federal ID, as prompted for
	70	Holder (newspaper) name, as prompted for
	30	Holder street address, as prompted for
	30	Holder PO box, as prompted for
	35	Holder city, as prompted for
	2	Holder state, as prompted for
	9	Holder ZIP Code (ZIP plus Zip extension), as prompted for
	3	Holder county code (will be spaces)
	30	Contact name, as prompted for
	10	Contact phone, as prompted for
	5	Contact title, as prompted for
	6	Branch number (will be zeros)
	8	Report as of date (Cutoff Date from Refund Writeoff screen, format YYYYMMDD)
	8	Report due date (Cutoff Date from Refund Writeoff screen, format YYYYMMDD)
	2	Incorporated state (will be spaces)
	8	Incorporated date (will be zeros)
	4	SIC code, as prompted for
	1	Charter type ( will be space)
	8	Charter date (will be zeros)
	70	Former name (will be spaces)
	70	Agent name (will be spaces)
	30	Agent street address (will be spaces)
	35	Agent city (will be spaces)
	2	Agent state (will be spaces)
	9	Agent ZIP Code (will be spaces)
	3	Agent country code (will be spaces)
	10	Agent phone (will be spaces)
	75	Filler (spaces)
Property Detail Record	2	2 plus space (Property Detail record begins)
	8	00000001 (report ID)
	8	Sequence ID (will be zeros)
	30	Property street address (subscriber’s bill-to address)
	35	Property city (subscriber’s bill-to city)
	2	Property state (subscriber’s bill-to state)
	9	Property ZIP Code (subscriber’s bill-to ZIP plus Zip extension)
	3	Property county code (will be spaces)
	40	In Care of Name (will be spaces)
	8	DLC date (subscriber’s last stop date, format YYYYMMDD, or else zeros)
	9	Social security number (will be spaces)
	15	Reference number (subscription ID)
	2	79 (Property type)
	12	Refund writeoff amount (format 999999999.99)
	11	Service charge amount (will be 00000000.00)
	15	SDB Reported number (will be spaces)
	6	SDB Lean amount (will be 000.00)
	11	CUSIP ID (will be spaces)
	30	Issue name (will be spaces)
	1	Issue type (will be space)
	6	Series description (will be spaces)
	13	Reported share count (will be 0000000000.00)
	8	Maturity date (will be zeros)
	8	Begin Div Interest date (will be zeros)
	8	End Div Interest date (will be zeros)
	8	Frctnl Shrs Cash amount (will be 00000.00)
	12	Reported Div amount (will be 000000000.00)
	30	Original Issue Name (will be spaces)
	12	Original Shrs RDMD amount (will be 000000000.00)
	12	Original Share count (will be 00000000.000)
	233	Filler (spaces)
Owner Detail Record	2	3 plus space (Owner Detail record begins)
	8	00000001 (report ID)
	8	Sequence ID (will be zeros)
	2	01 (Owner Sequence number)
	1	Owner Type (will be space)
	60	Owner Name (subscriber last name and first name)
	20	Owner Last Name (subscriber last name)
	20	Owner First Name (subscriber first name)
	20	Owner Middle Name (will be spaces)
	5	Owner Title (will be spaces)
	9	Owner Code (will be spaces)
	8	Owner Date (will be zeros)
	497	Filler (spaces)
Cash Summary Record	2	4 plus space (Summary record begins)
	8	00000001 (report ID)
	8	Sequence ID (will be zeros)
	13	Filler (spaces)
	12	Subtotal of refund writeoffs with names of 50.00 and over (format 999999999.99)
	12	Subtotal of refund writeoffs without names of 50.00 and over (format 999999999.99)
	12	Subtotal of refund writeoffs with names of under 50.00 (format 999999999.99)
	13	Total amount remitted to the state (format 9999999999.99)
	524	Filler (spaces)