dodil/erp-brick-ar

DODIL ERP brick: accounts receivable

src/brick_ar/migrations/00003_v4a/down.sql

-- 00003_v4a down: drops what the release added.
ALTER TABLE ar_invoices DROP COLUMN company_code;
ALTER TABLE ar_invoices DROP COLUMN trading_partner;
ALTER TABLE ar_invoices DROP COLUMN settlement_discount_pct;
ALTER TABLE ar_invoices DROP COLUMN settlement_discount_until;
ALTER TABLE ar_invoice_lines DROP COLUMN pinned_from;
ALTER TABLE ar_invoice_lines DROP COLUMN interest_on_invoice_id;
ALTER TABLE ar_invoice_lines DROP COLUMN interest_days;
ALTER TABLE ar_invoice_lines DROP COLUMN interest_rate_pct;
ALTER TABLE ar_credit_notes DROP COLUMN payment_id;
ALTER TABLE ar_credit_notes DROP COLUMN company_code;
ALTER TABLE ar_credit_note_lines DROP COLUMN pinned_from;
ALTER TABLE ar_customer DROP COLUMN intercompany_company_code;
ALTER TABLE ar_terms DROP COLUMN early_discount_days;
DROP TABLE IF EXISTS ar_payment_request;
DROP TABLE IF EXISTS ar_payment_request_versions;
DROP TABLE IF EXISTS ar_request_settlement;
DROP TABLE IF EXISTS ar_deposit_claim;
DROP TABLE IF EXISTS ar_settlement_discount;
DROP TABLE IF EXISTS ar_interest_rate;
DROP TABLE IF EXISTS ar_ic_handover;