Array ( [MESTYPE] => Array ( [0] => LEASE ) [TENANT] => Array ( [0] => Eric Hart ) [PREMISES] => Array ( [0] => Car Space No. 34 ) [STARTDATE] => Array ( [0] => 2026-10-11 ) [PAYFREQ] => Array ( [0] => Weekly ) [RENT] => Array ( [0] => 30 ) [GST] => Array ( [0] => N ) [CONTACTNAME] => Array ( [0] => Eric Hart ) ) insert into lease_master (lm_lease_number,lm_premises,lm_leasee_name,lm_pay_freq,lm_bond,lm_status,lm_control,lm_contact_name) values ('A037','A06','Eric Hart', '0005',0,'Y','0064','Eric Hart') insert into lease_master (lm_lease_number,lm_premises,lm_leasee_name,lm_pay_freq,lm_bond,lm_status,lm_control,lm_contact_name) values ('A038','A06','Eric Hart', '0005',0,'Y','0064','Eric Hart') 2026-10-11 insert into lease_master (lm_lease_number,lm_premises,lm_leasee_name,lm_pay_freq,lm_bond,lm_status,lm_control,lm_contact_name) values ('A039','A06','Eric Hart', '0005',0,'Y','0064','Eric Hart') 2026-10-11 insert into lease_master (lm_lease_number,lm_premises,lm_leasee_name,lm_pay_freq,lm_bond,lm_status,lm_control,lm_contact_name) values ('A040','A06','Eric Hart', '0005',0,'Y','0064','Eric Hart') 2026-10-11 insert into lease_master (lm_lease_number,lm_premises,lm_leasee_name,lm_pay_freq,lm_bond,lm_status,lm_control,lm_contact_name) values ('A041','A06','Eric Hart', '0005',0,'Y','0064','Eric Hart') 2026-10-11 2026-10-11 2027-10-11 insert into lease_master (lm_lease_number,lm_premises,lm_leasee_name,lm_pay_freq,lm_bond,lm_status,lm_control,lm_contact_name) values ('A042','A06','Eric Hart', '0005',0,'Y','0064','Eric Hart') 2026-10-11 2026-10-11 2027-10-11 insert into lease_income_lines (LEASE_NUMBER,INCOME_TYPE,EFFECTIVE_DATE,INCREASE_AMOUNT,RENT_AMOUNT,NEXT_REVIEW_DATE) values ('A042','A001','2026-10-11',0,30,'2027-10-11') select a.lease_number,lm_leasee_name,rent_amount,effective_date,name, c.description,lm_bond,p.code,lm_status,b.tax_code,lm_contact_name from lease_income_lines a inner join lease_income_types b on a.lease_number = b.lease_number and a.income_type = b.income_type inner join lease_master on lm_lease_number = a.lease_number inner join properties p on p.code = lm_premises inner join payment_terms c on c.code = b.pay_freq where lm_status = 'Y' and effective_date = (select min(effective_date) effective_date from lease_income_lines where lease_number = lm_lease_number) Order by a.lease_number