Demographics Import File Email Record

Fixed record type =AEML

Excel worksheet name =EmailRecord

Latitude	Position	Column	Column Name	Format	Length	Comment
Record Type	1-4	1	Record_Type	String(4)	4	Value = AEML
File Number	5-13	2	File_Number	Integer(9)	9	Unique number assigned to each account placed.
Debtor Number	14-22	3	Debtor_Number	Integer(9)	9	Unique number debtor on the account
Preferred Method of Communication	23-23	4	PreferredMethod	String(1)	1	1=Letter, 2=Phone, 3=Email, 4=SMS
E-mail Address	24-73	5	emailAddress	String(50)	50	For Liquid is Primary email;
E-mail Type	74-83	6	emailType	String(10)	10	Blank in V10
Consent to E-mail	84-84	7	Consenttoemail	String(1)	1	Y or N;
Method	85-85	8	Method	String(1)	1	1 = Written, 0 = Verbal
Obtained From	86-185	9	ObtainedFrom	String(100)	100	Name of party providing consent
Effective Date	186-193	10	EffectiveDate	DateTime(CCYYMMDD)	8	Date of consent change
Comment	194-313	11	Comment	String(120)	120	Comment
Work Email Address	314-314	12	Workemail	String(1)	1	Y or N;
Filler	315-3000	13	Filler	String(2686)	2686