/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\AR_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_AR_JOURNAL' AND KSQL_COL_NAME ='FBIZDESCRIPTION') 
 ALTER TABLE T_AR_JOURNAL ADD (FBIZDESCRIPTION VARCHAR(30) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_AR_VERIFYRECORDENTRY' AND KSQL_COL_NAME ='FISWRITTENOFF')
 ALTER TABLE T_AR_VERIFYRECORDENTRY ADD (FISWRITTENOFF CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_AR_VERIFYRECORDENTRY' AND KSQL_COL_NAME ='FHADWRITTENOFF')
 ALTER TABLE T_AR_VERIFYRECORDENTRY ADD (FHADWRITTENOFF CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_AR_VERIFYRECORDENTRY' AND KSQL_COL_NAME ='FWRITTENOFFREMARK')
 ALTER TABLE T_AR_VERIFYRECORDENTRY ADD (FWRITTENOFFREMARK NVARCHAR(512) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_AR_VERIFYRECORD' AND KSQL_COL_NAME ='FVERIFYDATE')
 ALTER TABLE T_AR_VERIFYRECORD ADD (FVERIFYDATE DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_AR_REVCFMBILL' AND KSQL_COL_NAME ='FISWRITTENOFF')
 ALTER TABLE T_AR_REVCFMBILL ADD (FISWRITTENOFF CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_AR_REVCFMBILL' AND KSQL_COL_NAME ='FHADWRITTENOFF')
 ALTER TABLE T_AR_REVCFMBILL ADD (FHADWRITTENOFF CHAR(1) DEFAULT '0' NOT NULL );
/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\AR_table.sql **/
