Alter table credit_note Add PRoject_name   varchar  ( 255 ) NOT NULL After company_id ; 

Alter table credit_note Add mail_pdf   varchar  ( 255 ) NOT NULL After PRoject_name ; 

Alter table credit_note Add creditnote_template   varchar  ( 255 ) NOT NULL After mail_pdf ; 

Alter table credit_note Add org_cd   varchar  ( 255 ) NOT NULL After creditnote_template ; 

Alter table credit_note Add OA_BRAND_LOGO   varchar  ( 255 ) NOT NULL After org_cd ; 

Alter table credit_note Add org_id   int  ( 10 ) NOT NULL After OA_BRAND_LOGO ; 

Alter table credit_note Add credit_note_StatusNm   varchar  ( 255 ) NOT NULL After org_id ; 

Alter table credit_note Add Company_name   varchar  ( 255 ) NOT NULL After credit_note_StatusNm ; 

Alter table credit_note Add total_amt   varchar  ( 200 ) NOT NULL After vat_amount ; 

Alter table credit_note Add OA_CD   varchar  ( 6 ) NOT NULL After OA_BRAND_ID ; 

Alter table credit_note Add GENERATED_PATH   varchar  ( 100 ) NOT NULL After FY_ID ; 

Alter table credit_note_item Add item_amt   varchar  ( 200 ) NOT NULL After item_rate ; 

Alter table emp_attendance_record Add PROCESS_ATTEND_REGISTER   tinyint  ( 3 ) NOT NULL After ATTND_STATUS_ID ; 

Alter table emp_attendance_record Add SYNCED_TO_PM   tinyint  ( 3 ) NOT NULL After DEVICE ;