Sample Data

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN
1	leaseID	lastModifiedBy	lastModifiedDateTime	createdBy	createdDateTime	idNumber	location	startDate	endDate	moveInDate	noticeGivenDate	publicAssistanceProgram	moveOutDate	scheduleMoveOutDate	comments	paymentRestriction	reasonForLeaving	tenantsOptsIntoAssetProtectionPlan	lateFeeRule	status	addendums	portfolioID	buildingID	unitID	active	leaseName	terminatedDate	leaseBalance	signedDate	searchTag	baseRent	arBalance	Letter of Demand Sent	Resident Promise to Pay by	File Sent to Attorney	Initial Hearing Date	Set-out Date	Enter Premises Date	Enter Premises Time	Enter Premises Reason	Projected Move-in Date	Renewal Date	Renewal Notice Sent	Rent Increase Start Date	Pro-rated Rent Due	Action Needed	Violation Date	Violation Type	Judgment Type	Case Number	Date to File Writ	Trial Date	leasePhase	Notes	Final Payment Date	contactID	firstName	lastName	company	email	homePhone	workPhone	mobilePhone	namedOnLease	primary	role
2	4034199563	auser	2024-11-06T08:14:48.000Z	madmin	2022-07-25T16:30:38.000Z	14293963	Test Portfolio \| 1234 Test St	2023-10-01	2025-10-31	2021-10-01		None				None			10.00% of rent balance after due day 11, then $0.00 per day	Active		1875116032	2761129985	2761129985	TRUE	Tenant - Tenant					1150							9/30/2023	between 12pm and 5pm	to supply necessary or agreed upon services	9/30/2023	9/30/2023	9/30/2023	9/30/2023	333	33333333	9/30/2023	Neighborhood disturbance	andlt; select andgt;				R2	RPA says $1,350 .. Pending TNT confirmation		5205819426	Test1	Tenant		tenant1@domain.com			(816) 517-1234	TRUE	TRUE	Primary
3	4034199563	auser	2024-11-06T08:14:48.000Z	madmin	2022-07-25T16:30:38.000Z	14293963	Test Portfolio \| 1234 Test St	2023-10-01	2025-10-31	2021-10-01		None				None			10.00% of rent balance after due day 11, then $0.00 per day	Active		1875116032	2761129985	2761129985	TRUE	Tenant - Tenant					1150							9/30/2023	between 12pm and 5pm	to supply necessary or agreed upon services	9/30/2023	9/30/2023	9/30/2023	9/30/2023	333	33333333	9/30/2023	Neighborhood disturbance	andlt; select andgt;				R2	RPA says $1,350 .. Pending TNT confirmation		6315868164	Test2	Tenant		tenant3@domain.com				TRUE		Other
4	4034199563	auser	2024-11-06T08:14:48.000Z	madmin	2022-07-25T16:30:38.000Z	14293963	Test Portfolio \| 1234 Test St	2023-10-01	2025-10-31	2021-10-01		None				None			10.00% of rent balance after due day 11, then $0.00 per day	Active		1875116032	2761129985	2761129985	TRUE	Tenant - Tenant					1150							9/30/2023	between 12pm and 5pm	to supply necessary or agreed upon services	9/30/2023	9/30/2023	9/30/2023	9/30/2023	333	33333333	9/30/2023	Neighborhood disturbance	andlt; select andgt;				R2	RPA says $1,350 .. Pending TNT confirmation		6315868176	Test3	Tenant		tenant3@domain.com				FALSE		Other
5	2418114562	p@domain.com	2023-02-01T14:41:20.000Z	mrentals	2019-09-27T13:26:55.000Z	12150883	Simpson, Homer \| 8430 Pine Ln	2019-10-01	2022-09-30	2019-10-01		None	2022-12-31			None			10.00% of rent balance after due day 6, then $0.00 per day	Terminated		1947500545	2092761128	2092761128		My Corp LLC		385.37											< select >	< select >	10/1/2019				0			< select >	< select >							3116793864	Homer	Simpson		homer@springfield.com			(913) 565-9999	TRUE	TRUE	Primary
6	2437611527	mrentals	2021-09-08T03:58:49.000Z	mrentals	2019-10-16T16:09:32.000Z	12186191	Flintstone, Fred \| 1008 Bedrock St	2019-02-25	2020-03-01	2019-10-16		None				None			10.00% of rent balance after due day 5, then $0.00 per day	Active		1972568066	2119139329	2119139329	TRUE	Flintstone, F												1/6/2020	between 8am and 12pm	to inspect the property					0			< select >	< select >							3133472790	Fred	Flintstone		fred@thequarry.com	(816) 377-9999		(816) 377-9111	TRUE	TRUE	Primary
7	2437611527	mrentals	2021-09-08T03:58:49.000Z	mrentals	2019-10-16T16:09:32.000Z	12186191	Flintstone, Fred \| 1008 Bedrock St	2019-02-25	2020-03-01	2019-10-16		None				None			10.00% of rent balance after due day 5, then $0.00 per day	Active		1972568066	2119139329	2119139329	TRUE	Flintstone, F												1/6/2020	between 8am and 12pm	to inspect the property					0			< select >	< select >							3133472791	Wilma	Flintstone		wilma@thequarry.com			(816) 377-9112	TRUE		Other
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100