/**付款申请、预付、借款、对公、费用报销、出差申请、差旅报销添加字段“支付公司” **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_APPLYPAYBILL' AND KSQL_COL_NAME ='FPAYCOMPANYID') 
 ALTER TABLE T_ER_APPLYPAYBILL ADD (FPAYCOMPANYID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PREPAYBILL' AND KSQL_COL_NAME ='FPAYCOMPANYID') 
 ALTER TABLE T_ER_PREPAYBILL ADD (FPAYCOMPANYID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYLOANBILL' AND KSQL_COL_NAME ='FPAYCOMPANYID') 
 ALTER TABLE T_ER_DAILYLOANBILL ADD (FPAYCOMPANYID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PUBREIMBILL' AND KSQL_COL_NAME ='FPAYCOMPANYID') 
 ALTER TABLE T_ER_PUBREIMBILL ADD (FPAYCOMPANYID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYREIMBURSEBILL' AND KSQL_COL_NAME ='FPAYCOMPANYID') 
 ALTER TABLE T_ER_DAILYREIMBURSEBILL ADD (FPAYCOMPANYID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REQBILL' AND KSQL_COL_NAME ='FPAYCOMPANYID') 
 ALTER TABLE T_ER_REQBILL ADD (FPAYCOMPANYID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REIMBURSEBILL' AND KSQL_COL_NAME ='FPAYCOMPANYID') 
 ALTER TABLE T_ER_REIMBURSEBILL ADD (FPAYCOMPANYID BIGINT DEFAULT 0 NOT NULL );

