Use FinalTenMan;

/* Sales for BK4U for Feb 2005 */
INSERT INTO TenantSales
VALUES ('BK4U', '2005-02-28', 100623);
INSERT INTO TenantSales
VALUES ('DP4U', '2005-02-28', 272500);
INSERT INTO TenantSales
VALUES ('WM4U', '2005-02-28', 1272500);
INSERT INTO TenantSales
VALUES ('AE4U', '2005-02-28', 85300);
INSERT INTO TenantSales
VALUES ('NV4U', '2005-02-28', 13100);
INSERT INTO TenantSales
VALUES ('TG4U', '2005-02-28', 489300);

/* AR Payments for WM4U for Mar 2005 */
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('I', 'WM4U','2005-03-31', -266.67);
INSERT INTO AccountsReceivable (Type, TenantNum, ARDate, Amount)
VALUES  ('R','WM4U','2005-03-31', -2000);

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

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

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

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