dodil/erp-brick-payments

DODIL ERP brick: payments

src/brick_payments/migrations/00005_slice_c/up.sql

-- 00005_slice_c - additive only (payments v4, slice C: PAY-33..PAY-36, PAY-45..PAY-48): the FX difference posted per allocation row,
-- open-banking feed consents.

CREATE TABLE IF NOT EXISTS pay_fx_posting (
    payment_id      VARCHAR NOT NULL,
    invoice_id      VARCHAR NOT NULL,
    seq             INTEGER NOT NULL,
    event           VARCHAR,
    direction       VARCHAR,
    source_document VARCHAR,
    journal_id      VARCHAR,
    amount          NUMERIC(18,2),
    currency        VARCHAR,
    receipt_rate    NUMERIC(19,4),
    invoice_rate    NUMERIC(19,4),
    posted_on       DATE,
    created_at      TIMESTAMP,
    updated_at      TIMESTAMP,
    PRIMARY KEY (payment_id, invoice_id, seq)
);

CREATE TABLE IF NOT EXISTS pay_feed_consent (
    bank_account_id VARCHAR NOT NULL,
    granted_on      DATE NOT NULL,
    provider        VARCHAR,
    expires_on      DATE,
    recorded_by     VARCHAR,
    created_at      TIMESTAMP,
    updated_at      TIMESTAMP,
    PRIMARY KEY (bank_account_id, granted_on)
);