dodil/erp-brick-timesheets

DODIL ERP brick: timesheets

src/brick_timesheets/migrations/00003_billing_run/up.sql

-- 00003_billing_run - slice B item 1 (TS-13, TS-14): the billing run through ar, and what its claims bill. Additive only.

CREATE TABLE IF NOT EXISTS ts_billing_run (
    run_id        VARCHAR NOT NULL,
    project_id    VARCHAR,
    period_id     VARCHAR,
    run_no        INTEGER,
    company_code  VARCHAR,
    bp_id         BIGINT,
    currency      VARCHAR,
    status        VARCHAR,
    source_id     VARCHAR,
    lines_json    VARCHAR,
    total_amount  NUMERIC(18,2),
    claim_count   INTEGER,
    invoice_id    VARCHAR,
    reason        VARCHAR,
    created_by    VARCHAR,
    released_by   VARCHAR,
    released_sub  VARCHAR,
    released_at   TIMESTAMP,
    released_on   DATE,
    ended_by      VARCHAR,
    ended_at      TIMESTAMP,
    created_at    TIMESTAMP,
    updated_at    TIMESTAMP,
    PRIMARY KEY (run_id)
);

ALTER TABLE ts_billing_claim ADD COLUMN product_id VARCHAR;
ALTER TABLE ts_billing_claim ADD COLUMN tax_category VARCHAR;