/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\SBD_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_TRACKNUMBER' AND KSQL_COL_NAME ='FSOURCEBILLTYPE')
 ALTER TABLE T_BD_TRACKNUMBER ADD (FSOURCEBILLTYPE BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_TRACKNUMBER' AND KSQL_COL_NAME ='FSOURCEBILLNO')
 ALTER TABLE T_BD_TRACKNUMBER ADD (FSOURCEBILLNO NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_TRACKNUMBER' AND KSQL_COL_NAME ='FSOURCEBILLID')
 ALTER TABLE T_BD_TRACKNUMBER ADD (FSOURCEBILLID NVARCHAR(50) DEFAULT ' ' NOT NULL );
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_TRACKNUMBER' AND KSQL_COL_NAME ='FSOURCEBILLENTRYID')
 ALTER TABLE T_BD_TRACKNUMBER ADD (FSOURCEBILLENTRYID NVARCHAR(50) DEFAULT ' ' NOT NULL );
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_TRACKNUMBER' AND KSQL_COL_NAME ='FSOURCEBILLENTRYSEQ')
 ALTER TABLE T_BD_TRACKNUMBER ADD (FSOURCEBILLENTRYSEQ NVARCHAR(50) DEFAULT ' ' NOT NULL );
  IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_TRACKNUMBER' AND KSQL_COL_NAME ='FTRACKSTATUS')
 ALTER TABLE T_BD_TRACKNUMBER ADD (FTRACKSTATUS NVARCHAR(50) DEFAULT ' ' NOT NULL );

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