dodil/erp-brick-ar

DODIL ERP brick: accounts receivable

src/brick_ar/migrations/00005_v6/up.sql

-- 00005_v6 (v0.1.4): spec v6: the partner functions on an invoice (sold-to, ship-to, bill-to) and the pricing quantity and unit on a line. ADD COLUMN is DISRUPTIVE: migrate the test copy first, the live one at a quiet hour.

ALTER TABLE ar_invoices ADD COLUMN sold_to_bp_id BIGINT;

ALTER TABLE ar_invoices ADD COLUMN ship_to_bp_id BIGINT;

ALTER TABLE ar_invoices ADD COLUMN bill_to_bp_id BIGINT;

ALTER TABLE ar_invoice_lines ADD COLUMN pricing_quantity NUMERIC(19,4);

ALTER TABLE ar_invoice_lines ADD COLUMN pricing_unit_code VARCHAR;