insert into _ref_business_type (ID, industryID, name, createdBy) values 
(28,3,'Bekalan Air',1); 

insert into _ref_chart_of_acct (businessTypeID,acctCode,acctname,acctGroupID,createdBy) values	 
(28,'101001000','Freehold Land-PPE-Costs	',	2	,1),
(28,'101005000','Buildings-PPE-Costs	',	2	,1),
(28,'101006000','Plant-PPE-Costs	',	2	,1),
(28,'101008000','Office Equipment, Furniture & Fittings-PPE-Costs	',	2	,1),
(28,'101009000','Other Plant & Equipment-PPE-Costs	',	2	,1),
(28,'101010000','Computer Software & Hardware-PPE-Costs	',	2	,1),
(28,'101011000','Motor Vehicles-PPE-Costs	',	2	,1),
(28,'101505000','Buildings-PPE-Acc Dep & Impairment Loss	',	2	,1),
(28,'101506000','Plant-PPE-Acc Dep & Impairment Loss	',	2	,1),
(28,'101508000','Off Equip,Furniture&Fit-PPE-Acc Dep&Impairmnt Loss	',	2	,1),
(28,'101509000','Oth Plant & Equipment-PPE-Acc Dep&Impairment Loss	',	2	,1),
(28,'101511000','Motor vehicles-PPE-Acc Dep & Impairment Loss	',	2	,1),
(28,'101804000','Oil & Gas Ppty-PPE-PIP-Accumulated Impairment Loss	',	2	,1),
(28,'101899000','Other Projects-PPE-PIP-Accumulated Impairment Loss	',	2	,1),
(28,'103510000','Freehold Land- Properties-Acc Dep & Impairmnt Loss	',	2	,1),
(28,'119610000','Deposits Rec (Ctrl)-Othr Rec - Long Term	',	3	,1),
(28,'119610300','Utilities-Deposits Rec - Long Term	',	3	,1),
(28,'119610400','Telephone,Telex,Telefax-Deposits Rec - Long Term	',	3	,1),
(28,'119619900','Others-Deposits Rec - Long Term	',	3	,1),
(28,'119630000','Prepayment (Ctrl)-Long Term	',	3	,1),
(28,'119639900','Prepayment-Others-Long Term	',	3	,1),
(28,'119690000','Other Receivable (Ctrl)-Others-Long Term	',	3	,1),
(28,'119691000','Other Receivable-Others-Long Term	',	3	,1),
(28,'125100000','Unused Tax Losses-Deferred Tax Assets	',	2	,1),
(28,'125200000','Unabsorbed Capital Allowances-Deferred Tax Assets	',	2	,1),
(28,'125300000','Unused Reinvestment Allowances-Deferred Tax Assets	',	2	,1),
(28,'125400000','Unused Invsmnt Tax Allowances-Deferred Tax Assets	',	2	,1),
(28,'125900000','Other Items-Deferred Tax Assets	',	2	,1),
(28,'136010000','Trade Receivable - Billed	',	3	,1),
(28,'136100000','Trade Receivable - Unbilled	',	3	,1),
(28,'136120000','Trade Receivable - Unbilled - Accrual	',	3	,1),
(28,'136190000','Trade Receivable - Provision for Forex	',	3	,1),
(28,'136750100','Accrued interest - Fund investment	',	3	,1),
(28,'136759900','Accrued Income - Others	',	3	,1),
(28,'136770000','Deposits Rec (Ctrl)-Short Term	',	3	,1),
(28,'136774000','Deposits Rec-ST-Utilities	',	3	,1),
(28,'136779000','Deposits Rec-ST-Others	',	3	,1),
(28,'136799000','Prepayment - Others - ST	',	3	,1),
(28,'136840000','Input Tax (VAT/GST)	',	3	,1),
(28,'136845000','GST - Non Payment AP	',	3	,1),
(28,'136900000','Oth Rec - Billed Customers (Ctrl)	',	3	,1),
(28,'136902000','Oth Rec - Duties & Taxes Recoverables	',	3	,1),
(28,'136908000','Oth Rec - Due from Alliance Partner	',	3	,1),
(28,'136990000','Oth Rec - Others	',	3	,1),
(28,'137190000','Provision for Forex Gain/Loss - Due from Subs	',	3	,1),
(28,'137400000','Amount due from Related Companies - Trade	',	3	,1),
(28,'137410000','Amount due from Related Companies - Non Trade	',	3	,1),
(28,'137500000','Amount due from Holding Company - Trade	',	3	,1),
(28,'137510000','Amount due from Holding Company - Non Trade	',	3	,1),
(28,'137520000','Amount due frm GST Representative Company-NonTrade	',	3	,1),
(28,'137600000','Amount due from PETRONAS Holding Company - Trade	',	3	,1),
(28,'137610000','Amount due from PETRONAS HC - Non Trade	',	3	,1),
(28,'147010000','Cash in IFSSC - In House Accounts 1	',	3	,1),
(28,'147020000','Cash in IFSSC - Incoming Clearing 1	',	3	,1),
(28,'147030000','Cash in IFSSC - Outgoing Clearing 1	',	3	,1),
(28,'147104950','Cash in Bank-BAKIPC-	',	3	,1),
(28,'147430000','Accounts Payable - Petty Cash	',	3	,1),
(28,'147510000','Investment-ST-Deposits-Licensed Banks-Local	',	3	,1),
(28,'147610000','Investment-ST-Deposits-Licensed Finance Co-Local	',	3	,1),
(28,'147710000','Investment-ST-Deposits-Other Corporations-Local	',	3	,1),
(28,'150100000','Issued & Fully Paid-Ordinary Shares-Share Capital	',	1	,1),
(28,'151081000','Capital Reserves	',	1	,1),
(28,'151500000','Retained Profits C/F	',	1	,1),
(28,'151511000','Distributable Reserve-General	',	1	,1),
(28,'165100000','Deferred Tax Liabilities-Prpty, Plant and Equip	',	6	,1),
(28,'179990000','Other Long Term Liabilities	',	6	,1),
(28,'180000000','Accounts Payable -Trade	',	4	,1),
(28,'180010000','Accrued Payable -Trade (Ctrl)	',	4	,1),
(28,'180012000','Accrued Payable -Trade	',	4	,1),
(28,'181000000','Accounts Payable - Non-Trade	',	4	,1),
(28,'181190000','Other Payable-Others	',	4	,1),
(28,'181200000','Accrued Payable - Non-Trade	',	4	,1),
(28,'181210000','Accrued Payable - GST	',	4	,1),
(28,'181390000','Accrued Payables - Others	',	4	,1),
(28,'181410000','Accrued Interest on Borrowings	',	4	,1),
(28,'181710000','Income Taxes Payable-Real Property Gain Tax	',	4	,1),
(28,'181720000','Income Taxes Payable-Foreign Tax	',	4	,1),
(28,'181790000','Income Taxes Payable-Others	',	4	,1),
(28,'182010000','Output Tax (VAT/GST)	',	4	,1),
(28,'182020000','VAT/GST Control  I	',	4	,1),
(28,'182020010','VAT/GST Control  II	',	4	,1),
(28,'182030000','Accounts Payable - Govt - VAT/GST	',	4	,1),
(28,'182031000','GST - Bad Debt Relief	',	4	,1),
(28,'182502000','Other Provisions - Others	',	4	,1),
(28,'183510000','Amount due to PETRONAS Holding Company - Trade	',	4	,1),
(28,'183520000','Amount due to PETRONAS Holding Company - Non Trade	',	4	,1),
(28,'183530000','Amount due to GST Representative Company- NonTrade	',	4	,1),
(28,'183610000','Amount due to Holding Company- Trade	',	4	,1),
(28,'183620000','Amount due to Holding Company- Non Trade	',	4	,1),
(28,'183710000','Amount due to Subsidaries- Trade	',	4	,1),
(28,'183720000','Amount due to Subsidaries- Non Trade	',	4	,1),
(28,'183730000','Amount due to Subsidaries- GST - Non-Trade	',	4	,1),
(28,'183810000','Amount due to Related Companies- Trade	',	4	,1),
(28,'183820000','Amount due to Related Companies- Non Trade	',	4	,1),
(28,'183890000','Provision for Forex Gain/Loss - Due to related Co	',	4	,1),
(28,'197010000','Dividend Payable - Third Party	',	4	,1),
(28,'197020000','Dividend Payable - Interco	',	4	,1),
(28,'205210000','Domestic Sales-Third Prty-Utilities	',	7	,1),
(28,'205220000','Domestic Sales-Interco-Utilities	',	7	,1),
(28,'240010000','Product Cost - Domestic - Third Party	',	8	,1),
(28,'240030000','Product Cost - Domestic - Interco	',	8	,1),
(28,'270330000','Dividend Income-Outside M\'sia-Quoted-Investment	',	9	,1),
(28,'270511000','Fund Invest-L&R-Local-Interest Income-Deposits	',	36	,1),
(28,'270511100','Fund Invest-L&R-Local-Interest Inc-Deposits-IFSSC	',	36	,1),
(28,'270512000','Fund Invest-L&R-Local-Interest Income-Securities	',	36	,1),
(28,'270519000','Fund Invest-L&R-Local-Expense	',	44	,1),
(28,'270529000','Fund Invest-AFS-Local-Expense	',	44	,1),
(28,'290010000','Gain on Disposal of PPE	',	9	,1),
(28,'298901000','Other Income - Third Parties	',	32	,1),
(28,'298902000','Other Income - Inter-Company	',	32	,1),
(28,'298903000','Other Income - Penalty Income - Third Party	',	32	,1),

(28,'299500000','Adjustments to Prior Years P & L	',	1	,1),
(28,'299920000','Appropriations-Final-Dividends-Intercompany	',		1,1),
(28,'299940000','Trnfr-ShCap/CapRsrv	',		1,1),

(28,'313010000','Staff Medical/Dental Exp-Dir,Snr Mgt&Permannt Exec	',	10	,1),
(28,'321052000','Awards, Gifts & Donations to Staff - In-kind	',	10	,1),
(28,'321990000','Other Staff Relations Expenses	',	10	,1),
(28,'322210000','Local-Courses, Conferences & Seminar	',	10	,1),
(28,'322220000','Local-On-The-Job Training	',	10	,1),
(28,'401200000','SWEC-Offce/Residential/Operational Eqpmnt&Supplies	',	10	,1),
(28,'401500000','SWEC-Safety And Protection System	',	10	,1),
(28,'401600000','SWEC-Structural	',	10	,1),
(28,'402000000','SWEC-Miscellaneous	',	10	,1),
(28,'500040000','SWEC-Consultancy Services	',	10	,1),
(28,'500260000','SWEC-Quality Assurance	',	10	,1),
(28,'520100000','Acctg/Legal/Secretarial-Audit Fees	',	10	,1),
(28,'520200000','Acctg/Legal/Secretarial-Oth Audit Chrgs	',	10	,1),
(28,'520400000','Acctg/Legal/Secretarial-Taxation Fees & Charges	',	10	,1),
(28,'520500000','Acctg/Legal/Secretarial-Legal Fees & Chrg	',	10	,1),
(28,'520600000','Acctg/Legal/Secretarial-Secretarial Fees & Charges	',	10	,1),
(28,'522100000','Management Fees & Charges	',	10	,1),
(28,'522900000','Other Management Services	',	10	,1),
(28,'529999000','Oth Prof Services-Others	',	10	,1),
(28,'590100000','Cater & Refresh-Staff	',	10	,1),
(28,'590500000','Repair & Maintenance	',	10	,1),
(28,'599900000','Oth Purchased Services - Others	',	10	,1),
(28,'601005000','Depn - PPE - Buildings	',	10	,1),
(28,'601006000','Depn - Plant	',	10	,1),
(28,'601008000','Depn - Office equipment, furniture & fittings	',	10	,1),
(28,'601009000','Depn - Other plant & equipment	',	10	,1),
(28,'601010000','Depn - Computer software & hardware	',	10	,1),
(28,'601011000','Depn - Motor vehicles	',	10	,1),
(28,'619020000','Amortisation - Other intangible assets	',	10	,1),
(28,'623011000','Impairment losses - PPE	',	10	,1),
(28,'623012000','Impairment losses written back - PPE	',	10	,1),
(28,'701020000','Insurances-Fixed Assets/Property Damage & Loss	',	10	,1),
(28,'702201000','Prpty Taxes-Assessment	',	10	,1),
(28,'702203000','Prpty Taxes-Others	',	10	,1),
(28,'702551000','Licence & Permit Fees - Others - Initial	',	10	,1),
(28,'703001000','Royalty Expense	',	10	,1),
(28,'704003000','Other Fin Exp-Bank Charges	',	10	,1),
(28,'704007000','Other Fin Exp-Miscellaneous Expenses	',	10	,1),
(28,'705990000','Bad debts written off - others	',	10	,1),
(28,'708001000','Company Meetings - Expenses	',	10	,1),
(28,'709001000','Motor Vehicle Expenses	',	10	,1),
(28,'710002000','Local Travel Expenses	',	10	,1),
(28,'711214000','Entertainment Expenses-Local-Related Parties	',	10	,1),
(28,'714002000','Utility Expenses - Electricity	',	10	,1),
(28,'715002000','Telecommunication Exp-Telecom Rental/Usage Charges	',	10	,1),
(28,'716001000','Postage/Parcel/Courier/Oth Mail Chg & Fees	',	10	,1),
(28,'811001000','Loss on Disposal of PPE	',	10	,1),
(28,'849991000','Other Expenses-Miscellaneous - Third party	',	10	,1),
(28,'849992000','Other Expenses-Miscellaneous - Interco	',	10	,1),
(28,'870011000','Inc Tax Exp-Current Yr-Corporate Inc Tax-M\'sia	',	12	,1),
(28,'880011000','IncTax Exp-Current Yr-Dfrrd Corp Inc Tax-M\'sia	',	12	,1),
(28,'907010000','Interco Clearing - Trade	',	10	,1),
(28,'907020000','Interco Clearing - Non Trade	',	10	,1),
(28,'907030000','Interco Clearing - Financing	',	10	,1),
(28,'920020000','Charge-out/In - IT Services	',	10	,1),
(28,'920080000','Charge-out/In - Security	',	10	,1),
(28,'920090000','Charge-out/In - Legal & Corp Affairs Dept	',	10	,1),
(28,'920120000','Charge-out/In - GSCM	',	10	,1),
(28,'920140000','Charge-out/In - T&E	',	10	,1),
(28,'920150000','Charge-out/In - IFSSC	',	10	,1),
(28,'920160000','Charge-out/In - Finance Shared Services	',	10	,1),
(28,'920240000','Charge-out/In - Centralised Head Office Services	',	10	,1),
(28,'120000000','Retained Earnings-Prior Year	',	1	,1),
(28,'130000000','Current Year Earnings	',	1	,1),
(28,'211000000','Goods No Bill/(Bill No Goods)	',	2	,1),
(28,'220000000','Cash and Bank Balances	',	3	,1),
(28,'230000000','Inventories	',	3	,1),
(28,'260010000','GST Input Tax	',	3	,1),
(28,'310000000','Invoice/(Goods) not receive	',	4	,1),
(28,'400000000','Sales	',	7	,1);

INSERT INTO `_ref_chart_of_acct` ( `businessTypeID`, `acctGroupID`, `acctCode`, `parentID`, `acctName`, `updatedBy`, `createdBy`) VALUES
( 28,3, '210000000', 0, 'Trade Receivable', NULL, 1 ),
( 28,3, '220010000', 0, 'Bank', NULL, 1 ),
( 28,3, '260000000', 0, 'Tax Claimable', NULL, 1 ),
( 28,3, '260010000', 0, 'GST Input Tax', NULL, 1 ),
( 28,3, '260011000', 0, 'Provision for GST Non-Claimable', NULL, 1 ),
( 28,3, '260020000', 0, 'Suspense GST - Input Tax', NULL, 1 ),
( 28,4, '300000000', 0, 'Trade Payable', NULL, 1 ),
( 28,4, '330000000', 0, 'Tax Payable', NULL, 1 ),
( 28,4, '330010000', 0, 'GST Output Tax', NULL, 1 ),
( 28,4, '330020000', 0, 'Suspense GST - Output Tax', NULL, 1 ),
( 28,4, '330030000', 0, 'Import Duty Payable', NULL, 1 ),
( 28,4, '330040000', 0, 'Sales Tax Payable', NULL, 1 ),
( 28,4, '330050000', 0, 'Service Tax Payable', NULL, 1 ),
( 28,8, '500000000', 0, 'Cost of Goods Sold', NULL, 1 ),
( 28,8, '570000000', 0, 'Inventory Adjustment Account', NULL, 1 ),
( 28,4, '340000000', 0, 'Accruals', NULL, 1 ),
( 28,4, '340010000', 0, 'Accrued Payroll', NULL, 1 ),
( 28,4, '340020000', 0, 'Payroll Deductions Payable', NULL, 1 ),
( 28,4, '340030000', 0, 'PAYE Tax Payable', NULL, 1 ),
( 28,4, '340040000', 0, 'Commission Payable', NULL, 1 ),
( 28,4, '340050000', 0, 'Accrual Waqaf', NULL, 1 ),
( 28,4, '340060000', 0, 'Zakat Payable', NULL, 1 ),
( 28,4, '350000000', 0, 'Client Deposits', NULL, 1 ),
( 28,9, '710000000', 0, 'Other Operating Income', NULL, 1 ),
( 28,9, '710011000', 0, 'Discount Received', NULL, 1 ),
( 28,9, '710012000', 0, 'Late Fees Collected', NULL, 1 ),
( 28,9, '710013000', 0, 'Freight Collected', NULL, 1 ),
( 28,10, '810000000', 0, 'Administration Expenses', NULL, 1 ),
( 28,10, '810011000', 0, 'Legal & Accounting', NULL, 1 ),
( 28,10, '810012000', 0, 'Commissions', NULL, 1 ),
( 28,10, '810013000', 0, 'Freight', NULL, 1 ),
( 28,10, '810014000', 0, 'Insurance', NULL, 1 ),
( 28,10, '810015000', 0, 'Late Payment Charges', NULL, 1 ),
( 28,10, '810016000', 0, 'Rent', NULL, 1 ),
( 28,10, '810016010', 0, 'Machinery & Equipment', NULL, 1 ),
( 28,10, '810016050', 0, 'Other Business Property', NULL, 1 ),
( 28,10, '810017000', 0, 'Advertising', NULL, 1 ),
( 28,10, '810018000', 0, 'Office Supplies', NULL, 1 ),
( 28,10, '810020000', 0, 'Maintenance & Repairs', NULL, 1 ),
( 28,10, '810021000', 0, 'Shrinkage/Spoilage', NULL, 1 ),
( 28,10, '810022000', 0, 'Telephone', NULL, 1 ),
( 28,10, '810023010', 0, 'Electricity', NULL, 1 ),
( 28,10, '810023020', 0, 'Gas', NULL, 1 ),
( 28,10, '810023030', 0, 'Water', NULL, 1 ),
( 28,10, '810023000', 0, 'Electricity & water', NULL, 1 ),
( 28,10, '810024000', 0, 'Travel, Meals & Entertainment', NULL, 1 ),
( 28,10, '810024010', 0, 'Travel', NULL, 1 ),
( 28,10, '810024020', 0, 'Meals & Entertainment', NULL, 1 ),
( 28,10, '810025000', 0, 'Depreciation Expense', NULL, 1 ),
( 28,10, '810040000', 0, 'GST- Non Claimable', NULL, 1 ),
( 28,10, '810050000', 0, 'Bad Debt Expense', NULL, 1 ),
( 28,10, '810060000', 0, 'Discounts Given', NULL, 1 ),
( 28,10, '810060010', 0, 'Prompt Payment Discount', NULL, 1 ),
( 28,10, '810070000', 0, 'Zakat Expense', NULL, 1 ),
( 28,10, '810080000', 0, 'Waqaf Expense', NULL, 1 ),
( 28,44, '850000000', 0, 'Finance cost', NULL, 1 ),
( 28,44, '850010000', 0, 'Bank Charges', NULL, 1 ),
( 28,44, '850020000', 0, 'Interest on loan', NULL, 1 ),
( 28,12, '860000000', 0, 'Income Tax Expense', NULL, 1 ),
( 28,32, '870000000', 0, 'Other Comprehensive  Income', NULL, 1 ),
( 28,32, '870010000', 0, 'Gain/(loss) on exchange', NULL, 1 );