/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\AR_table.sql **/
 --第一次字段加在了暂估分录上，超过80个字段了，现在移动到扩展表--
 --- drop column --------- 不允许删除表T_AR_BUSBILLENTRY的字段FINVOICEDNOTAXAMT，请恢复pdm中的字段 ------------------- 
 --- drop column --------- 不允许删除表T_AR_BUSBILLENTRY的字段FINVNOTAXLOCALAMT，请恢复pdm中的字段 ------------------- 
 --- drop column --------- 不允许删除表T_AR_BUSBILLENTRY的字段FUNINVNOTAXAMT，请恢复pdm中的字段 ------------------- 
 --- drop column --------- 不允许删除表T_AR_BUSBILLENTRY的字段FUNINVNOTAXLOCALAMT，请恢复pdm中的字段 ------------------- 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_AR_BUSBILLENTRY_E' AND KSQL_COL_NAME ='FINVOICEDNOTAXAMT') 
 ALTER TABLE T_AR_BUSBILLENTRY_E ADD (FINVOICEDNOTAXAMT DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_AR_BUSBILLENTRY_E' AND KSQL_COL_NAME ='FINVNOTAXLOCALAMT') 
 ALTER TABLE T_AR_BUSBILLENTRY_E ADD (FINVNOTAXLOCALAMT DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_AR_BUSBILLENTRY_E' AND KSQL_COL_NAME ='FUNINVNOTAXAMT') 
 ALTER TABLE T_AR_BUSBILLENTRY_E ADD (FUNINVNOTAXAMT DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_AR_BUSBILLENTRY_E' AND KSQL_COL_NAME ='FUNINVNOTAXLOCALAMT') 
 ALTER TABLE T_AR_BUSBILLENTRY_E ADD (FUNINVNOTAXLOCALAMT DECIMAL(23,10) DEFAULT 0 NOT NULL );

/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\AR_table.sql **/
