Alter table asset_mst Add ACC_GROUP   varchar  ( 255 ) NULL After DEPRECIATE_AMOUNT ; 

Alter table asset_mst Add SUBACC_GROUP   varchar  ( 255 ) NULL After ACC_GROUP ; 

Alter table asset_mst Add ACC_GROUP   varchar  ( 255 ) NULL After DEPRECIATE_AMOUNT ; 

Alter table asset_mst Add SUBACC_GROUP   varchar  ( 255 ) NULL After ACC_GROUP ; 

Alter table asset_mst Add OPENING_BAL   varchar  ( 255 ) NULL After SUBACC_GROUP ; 

Alter table asset_mst Add PURCHASE_DATE   date  NULL After OPENING_BAL ; 

Alter table attendance_register Add NO_OF_PRESENT   varchar  ( 10 ) NULL After YEAR ; 

Alter table attendance_register Add NO_OF_ABSENT   int  ( 10 ) NULL After NO_OF_PRESENT ; 

Alter table attendance_register Add NO_OF_HALF_DAY   int  ( 10 ) NULL After NO_OF_ABSENT ; 

Alter table attendance_register Add OUTDOOR   int  ( 10 ) NULL After NO_OF_HALF_DAY ; 

Alter table attendance_register Add NO_OF_LATE_ENTRY   varchar  ( 10 ) NULL After OUTDOOR ; 

Alter table attendance_register Add NO_OF_EARLY_GOING   varchar  ( 10 ) NULL After NO_OF_LATE_ENTRY ; 

Alter table attendance_register Add NO_OF_HOLIDAY   varchar  ( 10 ) NULL After NO_OF_EARLY_GOING ; 

Alter table attendance_register Add NO_OF_COMP_OFF   varchar  ( 10 ) NULL After NO_OF_HOLIDAY ; 

Alter table attendance_register Add NO_OF_CASUAL_LEAVE   int  ( 10 ) NULL After NO_OF_COMP_OFF ; 

Alter table attendance_register Add NO_OF_SICK_LEAVE   int  ( 10 ) NULL After NO_OF_CASUAL_LEAVE ; 

Alter table attendance_register Add NO_OF_PAID_LEAVE   int  ( 10 ) NULL After NO_OF_SICK_LEAVE ; 

Alter table attendance_register Add LOSS_OF_PAY_DAYS   int  ( 10 ) NULL After NO_OF_PAID_LEAVE ; 

Alter table attendance_register Add SOURCE   varchar  ( 255 ) NULL After BATCH_NO ; 

Alter table bankdetails Add BANK_ACC_TYPE   int  ( 10 ) NOT NULL After BANK_NAME ; 

Alter table bankdetails Add ACC_GROUP   varchar  ( 200 ) NULL After MSTR_ID ; 

Alter table bankdetails Add SUBACC_GROUP   varchar  ( 200 ) NULL After ACC_GROUP ; 

Alter table bankdetails Add OPENING_BAL   varchar  ( 200 ) NOT NULL After SUBACC_GROUP ; 

Alter table bankdetails Add DEPOSITS   varchar  ( 200 ) NULL After OPENING_BAL ; 

Alter table bankdetails Add WITHDRAWALS   varchar  ( 200 ) NULL After DEPOSITS ; 

Alter table banksheet Add TRANSACTION_STATUS   int  ( 10 ) NOT NULL After TRANSACTION_DATE ; 

Alter table banksheet Add TYPE1   varchar  ( 100 ) NOT NULL After SOL ; 

Alter table banksheet Add CATAGORY   varchar  ( 100 ) NOT NULL After TYPE1 ; 

Alter table banksheet Add NOTES   varchar  ( 100 ) NOT NULL After CATAGORY ; 

Alter table banksheet Add ACCOUNT_ID   int  ( 10 ) NOT NULL After BANKID ; 

Alter table banksheet Add RECEIVED_ID   int  ( 10 ) NULL After ACCDESC ; 

Alter table banksheet Add RECEIVED_REASON   varchar  ( 1000 ) NULL After RECEIVED_ID ; 

Alter table banksheet Add ATTACHMENT   varchar  ( 200 ) NULL After RECEIVED_REASON ; 

Alter table banksheet Add ATTACHEMENT_DESC   varchar  ( 1000 ) NULL After ATTACHMENT ; 

Alter table billpayment Add USERID   int  ( 10 ) NOT NULL After USER_ID ; 

Alter table billpayment Add Project_name   varchar  ( 225 ) NULL After IS_DELETED ; 

Alter table billpayment Add item_amt   varchar  ( 200 ) NOT NULL After Project_name ; 

Alter table billpayment Add payout_no   varchar  ( 200 ) NOT NULL After payout_id ; 

Alter table billpayment Add payout_date   date  NOT NULL After payout_no ; 

Alter table bills_item Add item_amt   varchar  ( 250 ) NOT NULL After item_rate ; 

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

Alter table bills_mst Add PAID_INV   tinyint  ( 3 ) NOT NULL After total_amt ; 

Alter table bills_mst Add BALANCE   varchar  ( 200 ) NOT NULL After bills_amount ; 

Alter table bills_mst Add PAYMENT_PAID   varchar  ( 200 ) NOT NULL After BALANCE ; 

Alter table bills_mst Add OA_CD   varchar  ( 6 ) NOT NULL After USER_ID ; 

Alter table bills_mst Add Company_name   varchar  ( 225 ) NOT NULL After FY_ID ; 

Alter table bills_mst Add bills_Statusnm   varchar  ( 225 ) NOT NULL After Company_name ; 

Alter table bills_mst Add PRoject_name   varchar  ( 225 ) NOT NULL After bills_Statusnm ; 

Alter table bills_mst Add OA_BRAND_LOGO   char  ( 225 ) NOT NULL After PRoject_name ; 

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

Alter table bills_mst Add org_cd   int  ( 10 ) NOT NULL After org_id ; 

Alter table bills_mst Add org_template   varchar  ( 100 ) NOT NULL After org_cd ; 

Alter table bills_mst Add mail_pdf   varchar  ( 3 ) NOT NULL After org_template ; 

Alter table bills_mst Add GENERATED_PATH   varchar  ( 50 ) NOT NULL After mail_pdf ; 

Alter table bills_mst Add mark_sent   int  ( 10 ) NOT NULL After IS_DELETED ; 

Alter table bills_mst Add mark_recived   int  ( 10 ) NOT NULL After mark_sent ; 

Alter table bills_mst Add convert_to_creditmemo   int  ( 10 ) NOT NULL After mark_recived ; 

Alter table candidate_mst Add EMP_NBR   int  ( 10 ) NOT NULL After REF_EMP_ID ; 

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

Alter table credit_memo Add OA_CD   varchar  ( 6 ) NOT NULL After USER_ID ; 

Alter table credit_memo Add Company_name   varchar  ( 225 ) NOT NULL After FY_ID ; 

Alter table credit_memo Add org_id   int  ( 10 ) NOT NULL After Company_name ; 

Alter table credit_memo Add org_cd   varchar  ( 100 ) NOT NULL After org_id ; 

Alter table credit_memo Add creditnote_template   varchar  ( 225 ) NOT NULL After org_cd ; 

Alter table credit_memo Add mail_pdf   varchar  ( 225 ) NOT NULL After creditnote_template ; 

Alter table credit_memo Add PRoject_name   varchar  ( 225 ) NOT NULL After mail_pdf ; 

Alter table credit_memo Add OA_BRAND_LOGO   varchar  ( 225 ) NOT NULL After PRoject_name ; 

Alter table credit_memo Add GENERATED_PATH   varchar  ( 50 ) NOT NULL After IS_DELETED ; 

Alter table credit_memo Add bills_id   int  ( 10 ) NOT NULL After GENERATED_PATH ; 

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

Alter table credit_memo_item Add bills_id   int  ( 10 ) NOT NULL After toggle ; 

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 ; 

Alter table estimates_mst Add proposal_id   int  ( 10 ) NULL After convert_to_quotes ; 

Alter table estimates_mst Add ESTIMATE_NO   varchar  ( 30 ) NOT NULL After proposal_id ; 

Alter table estimates_mst Add est_unit   int  ( 10 ) NOT NULL After company_id ; 

Alter table estimates_mst Add estimate_date   date  NOT NULL After est_unit ; 

Alter table estimates_mst Add Company_name   varchar  ( 255 ) NOT NULL After vat_amount ; 

Alter table estimates_mst Add total_amt   varchar  ( 200 ) NOT NULL After Company_name ; 

Alter table estimates_mst Add PAID_EST   tinyint  ( 3 ) NOT NULL After total_amt ; 

Alter table estimates_mst Add estimate_amount   varchar  ( 200 ) NOT NULL After PAID_EST ; 

Alter table estimates_mst Add estimate_Status   varchar  ( 255 ) NOT NULL After estimate_amount ; 

Alter table estimates_mst Add org_id   int  ( 10 ) NOT NULL After estimate_Status ; 

Alter table estimates_mst Add org_cd   varchar  ( 255 ) NOT NULL After org_id ; 

Alter table estimates_mst Add mail_pdf   varchar  ( 255 ) NOT NULL After org_cd ; 

Alter table estimates_mst Add org_template   varchar  ( 255 ) NOT NULL After mail_pdf ; 

Alter table estimates_mst Add OA_BRAND_LOGO   varchar  ( 255 ) NOT NULL After org_template ; 

Alter table estimates_mst Add PRoject_name   varchar  ( 255 ) NOT NULL After OA_BRAND_LOGO ; 

Alter table estimates_mst Add est_status   int  ( 10 ) NULL After PRoject_name ; 

Alter table estimates_mst Add MARK_SEND   int  ( 10 ) NOT NULL After generated ; 

Alter table estimates_mst Add estimate_prefix   varchar  ( 10 ) NOT NULL After MARK_SEND ; 

Alter table estimates_mst Add balance   varchar  ( 200 ) NOT NULL After estimate_prefix ; 

Alter table estimates_mst Add payment_paid   varchar  ( 200 ) NOT NULL After balance ; 

Alter table estimates_mst Add OA_CD   varchar  ( 6 ) NOT NULL After OA_ID ; 

Alter table estimates_mst Add GENERATED_PATH   varchar  ( 50 ) NOT NULL After USER_ID ; 

Alter table expenses_mst Add EXP_PAID   tinyint  ( 3 ) NOT NULL After EXP_STATUS_ID ; 

Alter table family_detail Add FAMILY_ID   int  ( 10 ) NOT NULL  ; 

Alter table family_detail Add PATIENT_ID   int  ( 10 ) NOT NULL After FAMILY_ID ; 

Alter table family_detail Add RELATION   varchar  ( 250 ) NOT NULL After PATIENT_ID ; 

Alter table family_detail Add AGE   varchar  ( 255 ) NOT NULL After RELATION ; 

Alter table family_detail Add STATUS   varchar  ( 255 ) NOT NULL After AGE ; 

Alter table family_detail Add PROBLEM   varchar  ( 255 ) NOT NULL After STATUS ; 

Alter table family_detail Add F_NAME   varchar  ( 255 ) NOT NULL After PROBLEM ; 

Alter table family_detail Add L_NAME   varchar  ( 250 ) NOT NULL After F_NAME ; 

Alter table family_detail Add HOME_PHONE   varchar  ( 22 ) NOT NULL After L_NAME ; 

Alter table family_detail Add WORK_PHONE   varchar  ( 255 ) NOT NULL After HOME_PHONE ; 

Alter table family_detail Add MOB_PHONE   varchar  ( 255 ) NOT NULL After WORK_PHONE ; 

Alter table family_detail Add PRIMARY_CONTACT   varchar  ( 255 ) NOT NULL After MOB_PHONE ; 

Alter table family_detail Add CREATEDBY   varchar  ( 255 ) NOT NULL After USER_ID ; 

Alter table family_detail Add CREATEDON   date  NOT NULL After CREATEDBY ; 

Alter table family_detail Add UPDATEDON   date  NOT NULL After CREATEDON ; 

Alter table hier_level_config Add TOP_LEVEL_HIERARCHY   int  ( 10 ) NOT NULL After HIER_CHILD_ENTITY_TYPE_ID ; 

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

Alter table invoice_mst Add inv_unit   int  ( 10 ) NOT NULL After company_id ; 

Alter table invoice_mst Add Company_name   varchar  ( 255 ) NOT NULL After vat_amount ; 

Alter table invoice_mst Add total_amt   varchar  ( 200 ) NOT NULL After Company_name ; 

Alter table invoice_mst Add PAID_INV   tinyint  ( 3 ) NOT NULL After total_amt ; 

Alter table invoice_mst Add org_id   int  ( 10 ) NOT NULL After Invoice_Status ; 

Alter table invoice_mst Add org_cd   varchar  ( 255 ) NOT NULL After org_id ; 

Alter table invoice_mst Add mail_pdf   varchar  ( 255 ) NOT NULL After org_cd ; 

Alter table invoice_mst Add org_template   varchar  ( 255 ) NOT NULL After mail_pdf ; 

Alter table invoice_mst Add OA_BRAND_LOGO   varchar  ( 255 ) NOT NULL After org_template ; 

Alter table invoice_mst Add PRoject_name   varchar  ( 255 ) NOT NULL After OA_BRAND_LOGO ; 

Alter table invoice_mst Add inv_status   int  ( 10 ) NULL After PRoject_name ; 

Alter table invoice_mst Add MARK_SEND   int  ( 10 ) NOT NULL After generated ; 

Alter table invoice_mst Add balance   varchar  ( 200 ) NOT NULL After invoice_prefix ; 

Alter table invoice_mst Add payment_paid   varchar  ( 200 ) NOT NULL After balance ; 

Alter table invoice_mst Add OA_CD   varchar  ( 6 ) NOT NULL After OA_ID ; 

Alter table invoice_mst Add GENERATED_PATH   varchar  ( 50 ) NOT NULL After USER_ID ; 

Alter table leavetype_dtl Add LEAVE_IN_ONE_STRETCH   int  ( 10 ) NOT NULL After MONTHLY_LEAVE_ALLOWED ; 

Alter table loan_mst Add ACC_GROUP   varchar  ( 255 ) NULL After REMARK ; 

Alter table loan_mst Add SUBACC_GROUP   varchar  ( 255 ) NULL After ACC_GROUP ; 

Alter table loan_mst Add OPENING_BAL   varchar  ( 255 ) NULL After SUBACC_GROUP ; 

Alter table location_mst Add IS_DEFAULT   tinyint  ( 3 ) NOT NULL After PARENT_LOC_ID ; 

Alter table mileage_claim_details Add VEHICLE_ID   int  ( 10 ) NOT NULL After DATE_OF_EXPENSE ; 

Alter table mileage_claim_details Add VEHICLE_TYPE_ID   int  ( 10 ) NOT NULL After VEHICLE_ID ; 

Alter table outdrentr Add REASON   varchar  ( 250 ) NULL After OD_APPLIED ; 

Alter table pay_component_benefit_rules Add RULE_TYPE   int  ( 10 ) NULL After BENEFIT_RULES_ID ; 

Alter table pay_component_benefit_rules Add SECTION_ID   int  ( 10 ) NULL After RULE_TYPE ; 

Alter table pay_component_benefit_rules Add COMPONENT_CD   varchar  ( 100 ) NULL After COMPONENT_ID ; 

Alter table pay_component_benefit_rules Add CALCULATION_FACTOR_CD   varchar  ( 100 ) NULL After CALCULATION_FACTOR ; 

Alter table pay_component_benefit_rules Add DEPENDENT_ON_COMP_CD   varchar  ( 100 ) NULL After DEPENDENT_ON_COMP ; 

Alter table pay_component_benefit_rules Add SIGN_FACTOR_CD   varchar  ( 100 ) NULL After SIGN_FACTOR ; 

Alter table pay_component_benefit_rules Add GENDER_CD   varchar  ( 100 ) NULL After GENDER ; 

Alter table pay_component_benefit_rules Add MONTH   int  ( 10 ) NOT NULL After GENDER_CD ; 

Alter table payment Add remittance_no   varchar  ( 255 ) NOT NULL After remittance_id ; 

Alter table payment Add remittance_date   varchar  ( 255 ) NOT NULL After remittance_no ; 

Alter table payment Add Project_name   varchar  ( 255 ) NULL After payment_refrence ; 

Alter table payment Add item_amt   varchar  ( 200 ) NOT NULL After payment_amount ; 

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

Alter table payout_mst Add OA_CD   varchar  ( 6 ) NOT NULL After USER_ID ; 

Alter table payout_mst Add Company_name   varchar  ( 225 ) NOT NULL After FY_ID ; 

Alter table payout_mst Add PRoject_name   varchar  ( 225 ) NOT NULL After Company_name ; 

Alter table payout_mst Add org_id   int  ( 10 ) NOT NULL After PRoject_name ; 

Alter table payout_mst Add OA_BRAND_LOGO   varchar  ( 225 ) NOT NULL After org_id ; 

Alter table payout_mst Add org_cd   varchar  ( 225 ) NOT NULL After OA_BRAND_LOGO ; 

Alter table payout_mst Add org_template   varchar  ( 225 ) NOT NULL After org_cd ; 

Alter table payout_mst Add payment_template   varchar  ( 225 ) NOT NULL After org_template ; 

Alter table payout_mst Add mail_pdf   varchar  ( 225 ) NOT NULL After payment_template ; 

Alter table payout_mst Add GENERATED_PATH   text  ( 65535 ) NULL After IS_DELETED ; 

Alter table project_details Add project_name   varchar  ( 50 ) NOT NULL After company_id ; 

Alter table project_details Add project_code   varchar  ( 10 ) NOT NULL After project_name ; 

Alter table project_details Add service_tax   varchar  ( 255 ) NOT NULL After vat_tax ; 

Alter table project_details Add cst_tax   varchar  ( 255 ) NOT NULL After service_tax ; 

Alter table project_details Add octroi_tax   varchar  ( 255 ) NOT NULL After cst_tax ; 

Alter table project_details Add acc_group   varchar  ( 255 ) NULL After octroi_tax ; 

Alter table project_details Add subacc_group   varchar  ( 255 ) NULL After acc_group ; 

Alter table project_details Add opening_bal   varchar  ( 255 ) NULL After subacc_group ; 

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

Alter table quotes_mst Add ESTIMATE_ID   int  ( 10 ) NULL After CONVERT_TO_PROPOSAL ; 

Alter table quotes_mst Add Company_name   varchar  ( 255 ) NOT NULL After VAT_AMOUNT ; 

Alter table quotes_mst Add TOTAL_AMT   varchar  ( 200 ) NOT NULL After Company_name ; 

Alter table quotes_mst Add PAID_QUO   tinyint  ( 3 ) NOT NULL After TOTAL_AMT ; 

Alter table quotes_mst Add org_id   int  ( 10 ) NOT NULL After QUOTES_STATUS ; 

Alter table quotes_mst Add org_cd   varchar  ( 255 ) NOT NULL After org_id ; 

Alter table quotes_mst Add mail_pdf   varchar  ( 255 ) NOT NULL After org_cd ; 

Alter table quotes_mst Add org_template   varchar  ( 255 ) NOT NULL After mail_pdf ; 

Alter table quotes_mst Add OA_BRAND_LOGO   varchar  ( 255 ) NOT NULL After org_template ; 

Alter table quotes_mst Add PRoject_name   varchar  ( 255 ) NOT NULL After OA_BRAND_LOGO ; 

Alter table quotes_mst Add quo_status   int  ( 10 ) NULL After PRoject_name ; 

Alter table quotes_mst Add MARK_SEND   int  ( 10 ) NOT NULL After GENERATED ; 

Alter table quotes_mst Add balance   varchar  ( 200 ) NOT NULL After QUOTES_PREFIX ; 

Alter table quotes_mst Add payment_paid   varchar  ( 200 ) NOT NULL After balance ; 

Alter table quotes_mst Add OA_CD   varchar  ( 6 ) NOT NULL After OA_ID ; 

Alter table quotes_mst Add GENERATED_PATH   varchar  ( 50 ) NOT NULL After USER_ID ; 

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

Alter table remittance_mst Add remittance_amt   float  ( 50 ) NOT NULL After remittance_amount ; 

Alter table remittance_mst Add OA_CD   varchar  ( 6 ) NULL After USER_ID ; 

Alter table remittance_mst Add payment_paid   int  ( 10 ) NOT NULL After remittance_prefix ; 

Alter table remittance_mst Add balance   int  ( 10 ) NOT NULL After payment_paid ; 

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

Alter table remittance_mst Add ATTACHMENT   varchar  ( 500 ) NOT NULL After IS_DELETED ; 

Alter table salary_component_settings Add COMPONENT_CD   varchar  ( 100 ) NULL After COMPONENT_ID ; 

Alter table salary_component_settings Add COMPONENT_TYPE_CD   varchar  ( 100 ) NULL After COMPONENT_TYPE ; 

Alter table salary_component_settings Add PAY_GROUP_HEAD_CD   varchar  ( 100 ) NULL After PAY_GROUP_HEAD ; 

Alter table salary_component_settings Add PAYROLL_COMP_CALC_TYPE_CD   varchar  ( 100 ) NULL After PAYROLL_COMP_CALC_TYPE ; 

Alter table salary_component_settings Add TAXABLE_STATUS_CD   varchar  ( 100 ) NULL After TAXABLE_STATUS ; 

Alter table schedule_mst Add TYPE   int  ( 10 ) NOT NULL After DESCRIPTION ; 

Alter table schedule_mst Add USER_ID   int  ( 10 ) NOT NULL After UPDATEDON ; 

Alter table schedule_mst Add IS_DELETED   tinyint  ( 3 ) NOT NULL After USER_ID ; 

Alter table tax_mst Add ACC_GROUP   varchar  ( 255 ) NULL After TAX_COUNTRY_ID ; 

Alter table tax_mst Add SUBACC_GROUP   varchar  ( 255 ) NULL After ACC_GROUP ; 

Alter table tax_mst Add OPENING_BAL   varchar  ( 255 ) NULL After SUBACC_GROUP ; 

Alter table user_mst Add IS_ACCOUNT_ADMIN   tinyint  ( 3 ) NOT NULL After IS_ADMIN ; 

Alter table user_mst Add ACC_GROUP   int  ( 10 ) NOT NULL After BATCH_ID ; 

Alter table user_mst Add SUB_ACC_GROUP   int  ( 10 ) NOT NULL After ACC_GROUP ;