-- 借款单和预付单支持费用预提
-- 增加单头已预提金额、明细已预提金额、明细已预提金额（本位币）

---借款单---
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYLOANBILL' AND KSQL_COL_NAME ='FWITHHOLDINGAMOUNT')
ALTER TABLE T_ER_DAILYLOANBILL ADD (FWITHHOLDINGAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYLOANDETAIL' AND KSQL_COL_NAME ='FEXPORIWITHHOLDINGAMOUNT')
ALTER TABLE T_ER_DAILYLOANDETAIL ADD (FEXPORIWITHHOLDINGAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYLOANDETAIL' AND KSQL_COL_NAME ='FEXPWITHHOLDINGAMOUNT')
ALTER TABLE T_ER_DAILYLOANDETAIL ADD (FEXPWITHHOLDINGAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL);

---预付单---
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PREPAYBILL' AND KSQL_COL_NAME ='FWITHHOLDINGAMOUNT')
ALTER TABLE T_ER_PREPAYBILL ADD (FWITHHOLDINGAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PREPAYBILLENTRY' AND KSQL_COL_NAME ='FEXPORIWITHHOLDINGAMOUNT')
ALTER TABLE T_ER_PREPAYBILLENTRY ADD (FEXPORIWITHHOLDINGAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PREPAYBILLENTRY' AND KSQL_COL_NAME ='FEXPWITHHOLDINGAMOUNT')
ALTER TABLE T_ER_PREPAYBILLENTRY ADD (FEXPWITHHOLDINGAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL);
