Use FinalTenMan;

/* Tenant Sales for Dec 2004 */
INSERT INTO TenantSales
VALUES ('DP4U', '2004-12-31', 282300);
INSERT INTO TenantSales
VALUES ('AE4U', '2004-12-31', 162300);
INSERT INTO TenantSales
VALUES ('NV4U', '2004-12-31', 10000);
INSERT INTO TenantSales
VALUES ('TG4U', '2004-12-31', 362300);

/* AR Payments for BK4U for Jan 2005 */
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('I', 'BK4U', '2005-01-31', -166.67);
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('R','BK4U', '2005-01-31', -1000);

/* AR Payments for NV4U for Jan 2005 */
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('I', 'NV4U', '2005-01-31', -166.67);
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('R','NV4U', '2005-01-31', -1033.33);

/* AR Payments DP4U Jan 2005 */
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('I', 'DP4U', '2005-01-31', -200);		
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('R', 'DP4U', '2005-01-31', -2000);

/* Payments AE4U Jan 2005 */
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('T', 'AE4U', '2005-01-31', -62.50);
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('P', 'AE4U', '2005-01-31', -10000);

/* Payments TG4U Jan 2005 */
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('I','TG4U', '2005-01-31', -1000);
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('R', 'TG4U', '2005-01-31', -6933.33);