dodil/erp-brick-sales-order

DODIL ERP brick: sales order

src/brick_sales_order/migrations/00003_slice_a/up.sql

-- 00003_slice_a — additive only. A line priced per 100 keeps its pricing quantity and unit (SO-01, SO-27); a line's stocked flag
-- and what inventory holds for it (SO-25); a delivery's exact quantity in the base unit (SO-26).
ALTER TABLE so_line ADD COLUMN pricing_quantity BIGINT;
ALTER TABLE so_line ADD COLUMN pricing_unit_code VARCHAR;
ALTER TABLE so_line ADD COLUMN pricing_numerator BIGINT;
ALTER TABLE so_line ADD COLUMN pricing_denominator BIGINT;
ALTER TABLE so_line ADD COLUMN stocked BOOLEAN;
ALTER TABLE so_line ADD COLUMN reserved_base NUMERIC(19,4);
ALTER TABLE so_line ADD COLUMN short_base NUMERIC(19,4);
ALTER TABLE so_delivery ADD COLUMN quantity_base NUMERIC(19,4);