/*
-- Query: select * from aemposinst.app_acct_chart_of_account
LIMIT 0, 1000

-- Date: 2024-07-05 03:53
*/
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (1,'112','ACCOUNT RECEIVABLE','ACCOUNT RECEIVABLE',1,-1,1,1,NULL,NULL,NULL,NULL,0);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (2,'210','ACCOUNT PAYABLE','ACCOUNT PAYABLE',2,-1,1,1,NULL,NULL,NULL,NULL,0);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (3,'110','CASH','CASH',1,-1,1,1,'2024-07-01 09:24:29',NULL,NULL,1,5455);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (4,'111','NOTES RECEIVABLE','NOTES RECEIVABLE',1,-1,1,1,'2024-07-01 09:30:37',NULL,NULL,1,0);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (5,'113','INTEREST RECEIVABLE','INTEREST RECEIVABLE',1,-1,1,1,'2024-07-03 10:29:26',NULL,NULL,1,0);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (6,'115','MERCHANDISE INVENTORY','MERCHANDISE INVENTORY',1,-1,1,1,'2024-07-03 10:45:34',NULL,NULL,1,0);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (7,'116','OFFICE SUPPLIES','OFFICE SUPPLIES',1,-1,1,1,NULL,NULL,NULL,1,0);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (8,'117','PREPAID INSURANCE','PREPAID INSURANCE',1,-1,1,1,NULL,NULL,NULL,1,0);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (9,'120','LAND','LAND',1,-1,1,1,NULL,NULL,NULL,1,0);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (10,'123','STORE EQUIPMENT','STORE EQUIPMENT',1,-1,1,1,NULL,NULL,NULL,1,0);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (11,'124','ACCOUMULATED DEPRECIATION-STORE EQUIPMENT','ACCOUMULATED DEPRECIATION-STORE EQUIPMENT',1,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (12,'125','OFFICE EQUIPMENT','OFFICE EQUIPMENT',1,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (13,'126','ACCUMULATED DEPRECIATION-OFFICE EQUIPMENT','ACCUMULATED DEPRECIATION-OFFICE EQUIPMENT',1,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (14,'211','SALARIES PAYABLE','SALARIES PAYABLE',2,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (15,'212','UNEARNED RENT','UNEARNED RENT',2,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (16,'215','NOTES PAYABLE','NOTES PAYABLE',2,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (17,'310','CAPITAL STOCK','CAPITAL STOCK',3,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (18,'311','RETAINED EARNINGS','RETAINED EARNINGS',3,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (19,'312','DIVIDENDS','DIVIDENDS',3,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (20,'313','INCOME SUMMARY','INCOME SUMMARY',3,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (21,'410','SALES','SALES',4,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (22,'411','SALES RETURN AND ALLOWANCES','SALES RETURN AND ALLOWANCES',4,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (23,'412','SALES DISCOUNT','SALES DISCOUNT',4,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (24,'510','COST OF GOODS SOLD','COST OF GOODS SOLD',5,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (25,'520','SALES SALARIES EXPENSES','SALES SALARIES EXPENSES',5,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (26,'521','ADVERTISING EXPENSE','ADVERTISING EXPENSE',5,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (27,'522','DEPRECIATION EXPENSE-STORE EQUIPMENT','DEPRECIATION EXPENSE-STORE EQUIPMENT',5,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (28,'529','MISCELLANEOUS SELLING EXPENSE','MISCELLANEOUS SELLING EXPENSE',5,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (29,'530','OFFICE SALARIES EXPENSE','OFFICE SALARIES EXPENSE',5,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (30,'531','RENT EXPENSE','RENT EXPENSE',5,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (31,'532','DEPRECIATION EXPENSE-OFFICE EQUIPMENT','DEPRECIATION EXPENSE-OFFICE EQUIPMENT',5,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (32,'533','INSURANCE EXPENSE','INSURANCE EXPENSE',5,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (33,'534','OFFICE SUPPLIES EXPENSE','OFFICE SUPPLIES EXPENSE',5,-1,1,1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `app_acct_chart_of_account` (`Id`,`Code`,`Name`,`Description`,`AccountNatureId`,`ParentAccountId`,`Status`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`,`AllowReconciliation`,`OpeningBalance`) VALUES (34,'539','MISCELLANEOUS ADMIN  EXPENSE','MISCELLANEOUS ADMIN  EXPENSE',5,-1,1,1,NULL,NULL,NULL,NULL,NULL);