Use FinalTenMan;

/* Sales for BK4U for Jan 2005 */
INSERT INTO TenantSales
VALUES ('BK4U', '2005-01-31', 100833);
INSERT INTO TenantSales
VALUES ('DP4U', '2005-01-31', 302300);
INSERT INTO TenantSales
VALUES ('AE4U', '2005-01-31', 145000);
INSERT INTO TenantSales
VALUES ('NV4U', '2005-01-31', 15000);
INSERT INTO TenantSales
VALUES ('TG4U', '2005-01-31', 583000); 

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

/* Payments AE4U Feb 2005 */
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('T', 'AE4U', '2005-02-28', -62.50);
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('P', 'AE4U', '2005-02-28', -10000);

/* Payments TG4U Feb 2005 */
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('I','TG4U', '2005-02-28', -1000);
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('R', 'TG4U', '2005-02-28', -6933.33);

/* AR Payments for BK4U for Feb 2005 */
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('I', 'BK4U', '2005-02-28', -166.67);
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('R','BK4U', '2005-02-28', -900);