dodil/erp-brick-expenses

DODIL ERP brick: expenses

src/brick_expenses/migrations/00002_default_categories/up.sql

-- 00002_default_categories - data only: the categories every company starts with (company_code '*' = all companies; a company's own row of the
-- same code wins). gl_purpose is a PURPOSE gl maps to an account. Plain INSERTs: the migration journal runs this once.

INSERT INTO exp_category (company_code, category_code, valid_from, name, gl_purpose, tax_category, receipt_required, kind, created_at, updated_at) VALUES
    ('*', 'TRAVEL_RAIL', DATE '2000-01-01', 'Train and bus', 'travel', 'zero', TRUE, 'receipt', NOW(), NOW()),
    ('*', 'TRAVEL_AIR', DATE '2000-01-01', 'Flights', 'travel', 'standard', TRUE, 'receipt', NOW(), NOW()),
    ('*', 'ACCOMMODATION', DATE '2000-01-01', 'Hotels', 'accommodation', 'standard', TRUE, 'receipt', NOW(), NOW()),
    ('*', 'MEALS_CLIENT', DATE '2000-01-01', 'Meals with clients', 'entertainment', 'standard', TRUE, 'receipt', NOW(), NOW()),
    ('*', 'MEALS_STAFF', DATE '2000-01-01', 'Meals while travelling', 'meals', 'standard', TRUE, 'receipt', NOW(), NOW()),
    ('*', 'OFFICE', DATE '2000-01-01', 'Office supplies', 'office_supplies', 'standard', TRUE, 'receipt', NOW(), NOW());