-- 应收流水表.业务描述 升级
-- 建索引
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_AR_JOURNAL_BIZDESCSRCTYPE') CREATE INDEX IDX_AR_JOURNAL_BIZDESCSRCTYPE ON T_AR_JOURNAL ( FSourceBillType, FBizDescription );

-- 1、sql执行 单据类型 为 暂估、应收
-- 2、plugin 执行 单据类型 为 应收应付结算记录、收款单
UPDATE T_AR_JOURNAL SET FBizDescription = 'bus' WHERE FSourceBillType = 'ar_busbill' AND FBizDescription = ' ';
UPDATE T_AR_JOURNAL SET FBizDescription = 'fin' WHERE FSourceBillType = 'ar_finarbill' AND FBizDescription = ' ';