programs_info/三资项目/删除前备份/流程不使用直接上级前的版本备份/doc/sql/2023/01/12/cf.sql

alter table acc_receivable
    add deliverymethod varchar(255) charset utf8 null comment '交割方式';

alter table acc_receivable
    add deliverydate datetime null comment '交割日期';

alter table acc_receivable
    add receiveuser varchar(100) charset utf8 null comment '接收人';

alter table acc_receivable
    add supplement varchar(255) charset utf8 null comment '补充说明';

alter table acc_receivable
    add paymentmethod varchar(100) charset utf8 null comment '收款方式';

alter table acc_receivable
    add othermethod varchar(255) charset utf8 null comment '其他收款方式';

alter table acc_receivable
    add cashamount double null comment '收款方式-现金金额';

alter table acc_receivable
    add telegraphicamount double null comment '收款方式-电汇金额';

alter table acc_receivable
    add otheramount double null comment '收款方式-其他金额';

alter table acc_receivable
    add paymentnotes varchar(255) charset utf8 null comment '收款登记备注';

alter table acc_receivable
    add adjustuser varchar(100) charset utf8 null comment '申请调整人';

alter table acc_receivable
    add adjustexplain varchar(255) charset utf8 null comment '调整说明';