8 lines
571 B
SQL
8 lines
571 B
SQL
-- Add VAT accounts to Chart of Accounts
|
|
INSERT IGNORE INTO acc_accounts (code, name_en, name_ar, type) VALUES
|
|
('1500', 'VAT Input', 'ضريبة القيمة المضافة - مدخلات', 'asset'),
|
|
('2300', 'VAT Payable', 'ضريبة القيمة المضافة - مستحقة', 'liability');
|
|
|
|
UPDATE acc_accounts SET parent_id = (SELECT id FROM (SELECT id FROM acc_accounts AS x WHERE x.code='1000') AS t) WHERE code IN ('1500');
|
|
UPDATE acc_accounts SET parent_id = (SELECT id FROM (SELECT id FROM acc_accounts AS x WHERE x.code='2000') AS t) WHERE code IN ('2300');
|