banking_payment_tracking_add_matching_fields.sql 447 B

123456
  1. ALTER TABLE banking_payment_tracking
  2. ADD COLUMN customerAccountNo VARCHAR(255) DEFAULT NULL COMMENT '收款账号' AFTER payment_account_no,
  3. ADD COLUMN customerName VARCHAR(255) DEFAULT NULL COMMENT '收款方名称' AFTER customerAccountNo,
  4. ADD COLUMN customerBank VARCHAR(255) DEFAULT NULL COMMENT '收款方银行名称' AFTER customerName,
  5. ADD COLUMN remark VARCHAR(500) DEFAULT NULL COMMENT '付款说明' AFTER customerBank;