ALTER TABLE CONSTDEMONEW.ACCOUNTS MODIFY ADD_TERM CHAR(15)  
ALTER TABLE CONSTDEMONEW.ACCOUNTS MODIFY CHG_TERM CHAR(15)  
ALTER TABLE CONSTDEMONEW.ACCOUNTS MODIFY CURR_CODE CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.ACCOUNTS MODIFY UDF_STR1 VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.ACCOUNTS_ANALYSIS MODIFY CHG_TERM CHAR(15)  
ALTER TABLE CONSTDEMONEW.ACCOUNTS_CCTR MODIFY CHG_TERM CHAR(15)  
ALTER TABLE CONSTDEMONEW.ACCOUNTS_CCTR MODIFY CHG_USER CHAR(15)  
ALTER TABLE CONSTDEMONEW.ACCOUNTS_DEPT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ACCTBAL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ACCTBUDGET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ACCT_CONS_INFO MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ACTIONSET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ACTIVITY ADD EXEC_TYPE CHAR(1)  
ALTER TABLE CONSTDEMONEW.ADJ_ISSRCP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ADJ_ISSRCPDET ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.ADM_ENV MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ADVBKING MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ADVBKING_CLOSE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ADV_LICENCE MODIFY AL_DATE DATE NULL 
ALTER TABLE CONSTDEMONEW.ADV_LICENCE MODIFY CHG_DATE DATE NULL 
ALTER TABLE CONSTDEMONEW.ADV_LICENCE MODIFY CHG_TERM VARCHAR2(15) NULL 
ALTER TABLE CONSTDEMONEW.ADV_LICENCE MODIFY CHG_USER CHAR(15) NULL 
ALTER TABLE CONSTDEMONEW.ADV_LICENCE_EXP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ADV_RCP_TAX MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ADV_RCP_TAX MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.AGREEMENT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ALLOWDEDN_BAL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ALLOWDEDN_DROP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ANALYSIS MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ANALYSIS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.API_CALL_LOG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.API_CALL_LOG MODIFY REF_ID VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.API_CALL_LOG ADD TEST CLOB  
ALTER TABLE CONSTDEMONEW.APPLICATION ADD CANDIDATE_ID CHAR(10)  
ALTER TABLE CONSTDEMONEW.APPLICATION MODIFY CAND_FNAME VARCHAR2(15) NULL 
ALTER TABLE CONSTDEMONEW.APPLICATION MODIFY CAND_LNAME VARCHAR2(15) NULL 
ALTER TABLE CONSTDEMONEW.APPLICATION MODIFY CAND_MNAME VARCHAR2(15) NULL 
ALTER TABLE CONSTDEMONEW.APPLICATION_EMPDET ADD CANDIDATE_ID CHAR(10)  
ALTER TABLE CONSTDEMONEW.APPRAISAL MODIFY APPR_NO CHAR(20)  
ALTER TABLE CONSTDEMONEW.APPRAISAL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.APPRAISAL_PAYDET MODIFY APPR_NO CHAR(20)  
ALTER TABLE CONSTDEMONEW.APPRAISAL_PAYDET ADD PAY_MODE CHAR(1)  
ALTER TABLE CONSTDEMONEW.APPRAISAL_SPEC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.APPRAISAL_SPEC ADD GRADE_CODE__APPR CHAR(5)  
ALTER TABLE CONSTDEMONEW.APPRAISAL_SPEC_TABLE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.APPR_GROUP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.APPR_GROUP_TABLE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.APPR_KRANEXT MODIFY APPR_NO CHAR(20)  
ALTER TABLE CONSTDEMONEW.APPR_KRAPREV MODIFY APPR_NO CHAR(20)  
ALTER TABLE CONSTDEMONEW.APPR_RATING MODIFY APPR_NO CHAR(20)  
ALTER TABLE CONSTDEMONEW.APPR_TRAINING MODIFY APPR_NO CHAR(20)  
ALTER TABLE CONSTDEMONEW.APRLEV MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ARREARS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ASN_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ASN_LOT_STAT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ASSET_CLASS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ASSET_DELETION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ASSET_DEPR MODIFY DEPR_TYPE CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.ASSET_INSTALL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ASSET_INSTALLDET ADD PROJ_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.ASSET_LOCATION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ASSET_REGISTER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ASSET_REGISTER ADD END_DATE__WARRANTY DATE  
ALTER TABLE CONSTDEMONEW.ASSET_REGISTER ADD START_DATE__WARRANTY DATE  
ALTER TABLE CONSTDEMONEW.ASSET_REGISTER ADD SUPP_CODE__WARRANTY CHAR(10)  
ALTER TABLE CONSTDEMONEW.ASSET_REGISTER ADD TRAN_ID__ASSIGN CHAR(10)  
ALTER TABLE CONSTDEMONEW.ASSET_REVALUE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ASSET_REVALUE ADD SITE_CODE CHAR(5)  
ALTER TABLE CONSTDEMONEW.ASSET_SALES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ASSET_SALES_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ASSET_SALES_HDR ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.ASSET_SALES_HDR ADD SITE_CODE CHAR(5)  
ALTER TABLE CONSTDEMONEW.ASSET_SHIFT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ASSET_TRANSFER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ASSET_TRANSFER_HDR ADD ASSIGNED_TO CHAR(10)  
ALTER TABLE CONSTDEMONEW.ASSET_TRANSFER_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ASSET_TRFEMP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ATTD_REG MODIFY CHG_TERM CHAR(15)  
ALTER TABLE CONSTDEMONEW.ATTD_REGULARIZE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ATTENDANCE_ABSENT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ATTENDANCE_DAY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ATTENDANCE_MON MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ATTENDANCE_MON_SPLIT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.B17_BOND MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BANK MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BANK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BANKER MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BANKER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BANK_CHARGES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BANK_EPAY_STATUS MODIFY ERROR_DET VARCHAR2(2000)  
ALTER TABLE CONSTDEMONEW.BANK_INTEGRATION_LOG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BANK_SIGN MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BANK_SIGN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BANK_STAN_SERV MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BANK_STATEMENT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BATCHLOAD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BATCHLOAD MODIFY DEPENDENCY CHAR(20)  
ALTER TABLE CONSTDEMONEW.BATCHLOAD MODIFY TRAN_ID__REF VARCHAR2(150)  
ALTER TABLE CONSTDEMONEW.BATCHSIZE_APRV MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BENEFIT_TRACE MODIFY BENEFIT_NO CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.BENEFIT_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BILLING_MTHD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BILL_TEMPL_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BIS_ACCESS_LOG ADD NLP_AGENT VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.BIS_ACCESS_LOG ADD NLP_REQ VARCHAR2(500)  
ALTER TABLE CONSTDEMONEW.BIS_ACCESS_LOG ADD NLP_REQ_TIME DATE  
ALTER TABLE CONSTDEMONEW.BIS_ACCESS_LOG ADD NLP_RESPONSE VARCHAR2(1000)  
ALTER TABLE CONSTDEMONEW.BIS_ACCESS_LOG ADD NLP_RESP_TIME DATE  
ALTER TABLE CONSTDEMONEW.BI_OBJ_RESOURCE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BI_OBJ_RESOURCE_HIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BI_OBJ_USERS MODIFY OBJ_NAME VARCHAR2(75) NULL 
ALTER TABLE CONSTDEMONEW.BI_OBJ_USERS MODIFY USR_CODE VARCHAR2(10) NULL 
ALTER TABLE CONSTDEMONEW.BI_PROFILE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BMR_REVIEW_FEEDBACK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BMR_REVIEW_OBSRV MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BMR_TEMPLATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BOL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BOM ADD BMR_EFF_DATE DATE  
ALTER TABLE CONSTDEMONEW.BOM ADD CCTR_CODE__INV CHAR(4)  
ALTER TABLE CONSTDEMONEW.BOM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BOM ADD EFF_DATE DATE  
ALTER TABLE CONSTDEMONEW.BOM ADD MMF_NO VARCHAR2(25)  
ALTER TABLE CONSTDEMONEW.BOM ADD SH_SITE_NAME CHAR(3)  
ALTER TABLE CONSTDEMONEW.BOMAMD_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BOM_ALT MODIFY CHG_DATE DATE NULL 
ALTER TABLE CONSTDEMONEW.BOM_ALT MODIFY CHG_TERM VARCHAR2(15) NULL 
ALTER TABLE CONSTDEMONEW.BOM_ALT MODIFY CHG_USER CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.BOM_ALT_AMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BOM_ALT_DEACTIVATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BOM_DEACTIVATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BOQHDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BRACKET_GROUP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BRAND MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BRAND ADD SUPP_CODE__PREF CHAR(10)  
ALTER TABLE CONSTDEMONEW.BUDGETS ADD BUDGET_PRD VARCHAR2(1)  
ALTER TABLE CONSTDEMONEW.BUDGETS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BUDGET_ALLOC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BUDGET_ALLOC MODIFY PRD_CODE CHAR(6) NULL 
ALTER TABLE CONSTDEMONEW.BUDGRP_ALLO_AMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BUD_GROUP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BUD_GRP_ALLO MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BUGLIST MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BUGLIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BUSINESS_LOGIC_CHECK MODIFY FAILED_INFO CLOB  
ALTER TABLE CONSTDEMONEW.BUSINESS_UNITS MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BUSINESS_UNITS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BUSI_FUNCTIONS MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BUSI_FUNCTIONS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BUSI_SECTOR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BUSI_SECTOR_PROD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BUSI_SECTOR_PROD_FEA MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.BYPRODUCT MODIFY CONSIDER_YIELD CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.CADRE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CADRE_AD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CADRE_MTHAD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CADRE_PERK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CADRE_SITE_LVETBL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CALC_METHOD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CALL_NOTE_TYPE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD ADD_DATE DATE  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD ADD_TERM CHAR(15)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD ADD_USER CHAR(10)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD BU_CODE CHAR(5)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD CAST_CATEGORY CHAR(5)  
ALTER TABLE CONSTDEMONEW.CANDIDATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD COUNT_CODE__BIRTH CHAR(5)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD DOC_SET VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD EMP_CODE__1_INT1 CHAR(10)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD EMP_CODE__1_INT2 CHAR(10)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD EMP_CODE__1_INT3 CHAR(10)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD EMP_CODE__2_INT1 CHAR(10)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD EMP_CODE__2_INT2 CHAR(10)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD EMP_CODE__2_INT3 CHAR(10)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD EMP_CODE__AUTH CHAR(10)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD EMP_CODE__AUTH_ALT1 CHAR(10)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD EMP_CODE__AUTH_ALT2 CHAR(10)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD EMP_CODE__FUNCHEAD CHAR(10)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD EMP_CODE__ORG CHAR(10)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD EMP_ID_EXTERNAL VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD INT1_COMMENT1 VARCHAR2(200)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD INT1_COMMENT2 VARCHAR2(200)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD INT1_COMMENT3 VARCHAR2(200)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD INT1_PANEL_NAME1 VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD INT1_PANEL_NAME2 VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD INT1_PANEL_NAME3 VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD INT1_STATUS1 CHAR(1)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD INT2_COMMENT1 VARCHAR2(200)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD INT2_COMMENT2 VARCHAR2(200)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD INT2_COMMENT3 VARCHAR2(200)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD INT2_PANEL_NAME1 VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD INT2_PANEL_NAME2 VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD INT2_PANEL_NAME3 VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD INT2_STATUS2 CHAR(1)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD INT_DATE1 DATE  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD INT_DATE2 DATE  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD JOB_TITLE VARCHAR2(200)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD MOTHER_TONGUE VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD MPR_NO VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD MPR_NO_ORG VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD REMARKS VARCHAR2(1500)  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD RETIREMENT_DATE DATE  
ALTER TABLE CONSTDEMONEW.CANDIDATE ADD SAME_ADDRESS VARCHAR2(5)  
ALTER TABLE CONSTDEMONEW.CANDIDATE_EXPERIENCE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CANDIDATE_EXPERIENCE ADD COUNT_CODE__WORK CHAR(5)  
ALTER TABLE CONSTDEMONEW.CANDIDATE_EXPERIENCE ADD LINE_NO VARCHAR2(3)  
ALTER TABLE CONSTDEMONEW.CANDIDATE_FAMILY ADD IS_ALIVE CHAR(1)  
ALTER TABLE CONSTDEMONEW.CANDIDATE_QUAL ADD COUNT_CODE__QUAL CHAR(5)  
ALTER TABLE CONSTDEMONEW.CANDIDATE_QUAL ADD COURSE_TYPE CHAR(5)  
ALTER TABLE CONSTDEMONEW.CARTON_MASTER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CASE_LABEL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CASH_VOUCHER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CCTR_ANAL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CENVAT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CENVAT_CR_CAPITAL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CENVAT_EXT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CHANGE_HOLIDAY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CHANGE_HOLIDAY MODIFY HOL_TBLNO CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.CHARGE_BACK MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CHARGE_BACK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CHARGE_BACK_DET ADD LOT_SL CHAR(15)  
ALTER TABLE CONSTDEMONEW.CHARGE_BACK_FORM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CHARGE_MST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CHECKLIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CHECKLIST_HISTORY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CHECKLIST_MST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CHECKLIST_REV MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CHEMIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CHG_COVERAGE ADD ADD_TERM CHAR(20)  
ALTER TABLE CONSTDEMONEW.CHG_COVERAGE MODIFY ADD_TERMINAL CHAR(20) NULL 
ALTER TABLE CONSTDEMONEW.CHG_COVERAGE ADD CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.CHG_COVERAGE ADD CHG_TERM CHAR(15)  
ALTER TABLE CONSTDEMONEW.CHG_COVERAGE ADD CHG_USER CHAR(10)  
ALTER TABLE CONSTDEMONEW.CHG_COVERAGE MODIFY POS_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.CHG_COVER_STP MODIFY DIST_EVDNCE CHAR(60)  
ALTER TABLE CONSTDEMONEW.CHG_COVER_STP ADD ROUTE_TYPE CHAR(1)  
ALTER TABLE CONSTDEMONEW.CHG_COVER_STRGSER ADD LOCALITY_CODE__TO CHAR(10)  
ALTER TABLE CONSTDEMONEW.CHQCANC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CHQCANC ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.CIRCLE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CIRCLE_ENTITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CNF_COMM_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.COLLAB_ENTITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.COLLAB_GROUPS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.COLLAB_POSTS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.COLLAB_POST_RESPONSE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.COLLAB_TAGS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.COMMENTS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.COMM_GROUP MODIFY CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.COMM_GROUP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.COMM_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.COMPETETOR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.COMPETITION_MASTER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.COMPLEXITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CONDN_ACC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CONSK_ACK_STATUS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CONST_CONFIG_EST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CONST_CONFIG_EST ADD EFF_DATE DATE  
ALTER TABLE CONSTDEMONEW.CONST_CONFIG_EST ADD PROJ_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.CONST_CONFIG_EST ADD SITE_CODE CHAR(5)  
ALTER TABLE CONSTDEMONEW.CONST_CONFIG_EST ADD TRAN_DATE DATE  
ALTER TABLE CONSTDEMONEW.CONST_CONFIG_EST ADD WING_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.CONST_CONFIG_EST_DET ADD UOM CHAR(3)  
ALTER TABLE CONSTDEMONEW.CONST_CONFIG_UNIT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CONSUME_ISS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CONSUME_ISS ADD SUPP_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.CONSUME_ISS_AMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CONSUME_ISS_AMD MODIFY LR_DATE DATE NULL 
ALTER TABLE CONSTDEMONEW.CONSUME_ISS_DET ADD EXP_DLV_DATE DATE  
ALTER TABLE CONSTDEMONEW.CONSUME_ISS_DET ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.CONSUME_ORD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CONSUME_ORD_DET ADD REAS_CODE VARCHAR2(5)  
ALTER TABLE CONSTDEMONEW.CONS_EXCH_RATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CONS_ORD_REQ MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CONTACT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CONTACT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CONTACT_COMM MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CONTACT_COMM MODIFY CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.CONTACT_COMM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CONTACT_COMM MODIFY COMM_DATE DATE  
ALTER TABLE CONSTDEMONEW.CONTACT_COMM MODIFY MAIL_DESCR VARCHAR2(300)  
ALTER TABLE CONSTDEMONEW.CONTACT_COMM ADD OPPR_ID VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.CONTACT_COMM ADD STAGE_CODE CHAR(3)  
ALTER TABLE CONSTDEMONEW.CONTACT_COMM_EXP MODIFY CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.CONTACT_COMM_EXP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CONTACT_COMM_PLAN MODIFY CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.CONTACT_COMM_PLAN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CONTACT_COMM_PLAN MODIFY COMM_DATE DATE  
ALTER TABLE CONSTDEMONEW.CONTACT_COMM_PLAN MODIFY PLAN_DATE DATE  
ALTER TABLE CONSTDEMONEW.CONVRATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CORP_LOAN MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CORP_LOAN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CORP_LOAN_PAYRCP MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CORP_LOAN_PAYRCP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CORP_LOAN_SCHEDULE MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CORP_LOAN_SCHEDULE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CORP_LOAN_VOUCHER MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CORP_LOAN_VOUCHER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.COSTALLOC_BAS MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.COSTALLOC_BAS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.COSTCTR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.COURSE MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.COURSE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.COURSE ADD COURSE_CLASS VARCHAR2(5)  
ALTER TABLE CONSTDEMONEW.COURSE ADD COURSE_TYPE CHAR(1)  
ALTER TABLE CONSTDEMONEW.COURSE ADD SITE_CODE CHAR(5)  
ALTER TABLE CONSTDEMONEW.COURSE_CONTENT MODIFY CONTENT_DESCR VARCHAR2(1000)  
ALTER TABLE CONSTDEMONEW.COURSE_CONTENT MODIFY CONTENT_NAME VARCHAR2(60) NULL 
ALTER TABLE CONSTDEMONEW.COURSE_CONTENT ADD COURSE_CHAPTER CHAR(10)  
ALTER TABLE CONSTDEMONEW.COURSE_TEST_QUES ADD COURSE_CHAPTER CHAR(10)  
ALTER TABLE CONSTDEMONEW.CPP_FORMULA_MST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CRM_CONTACTS MODIFY CONTACT_ID CHAR(10) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.CROSS_DOCK_ALLOC MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CROSS_DOCK_ALLOC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CRTERM_REL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CR_LIMIT_OVRRIDE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CSD_EVAL MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CSD_EVAL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CT3FORM_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUSTOMER MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUSTOMER ADD APPROVED CHAR(1)  
ALTER TABLE CONSTDEMONEW.CUSTOMER ADD APPROVED_FROM CHAR(15)  
ALTER TABLE CONSTDEMONEW.CUSTOMER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUSTOMER MODIFY CONTACT_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.CUSTOMER MODIFY CURR_CODE__FRT CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.CUSTOMER ADD REPL_PERIOD VARCHAR2(3)  
ALTER TABLE CONSTDEMONEW.CUSTOMER MODIFY ROUND CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.CUSTOMER MODIFY SH_NAME VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.CUSTOMER MODIFY WORK_PIN VARCHAR2(6)  
ALTER TABLE CONSTDEMONEW.CUSTOMERITEM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUSTOMER_BANK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUSTOMER_BILL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUSTOMER_BILL MODIFY CUST_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.CUSTOMER_BILL MODIFY CUST_CODE__BIL CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.CUSTOMER_DEFAULT MODIFY RCP_MODE VARCHAR2(1) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.CUSTOMER_DET MODIFY CUST_NAME VARCHAR2(40) NULL 
ALTER TABLE CONSTDEMONEW.CUSTOMER_DET MODIFY CUST_TYPE CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.CUSTOMER_DET MODIFY NAME_PREFIX CHAR(6)  
ALTER TABLE CONSTDEMONEW.CUSTOMER_DET MODIFY NATIONALITY CHAR(5)  
ALTER TABLE CONSTDEMONEW.CUSTOMER_DET MODIFY ORG_PIN VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUSTOMER_DET MODIFY PAN_NO VARCHAR2(20) NULL 
ALTER TABLE CONSTDEMONEW.CUSTOMER_DET MODIFY PIN VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUSTOMER_EDIT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUSTOMER_EDIT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUSTOMER_PRODUCT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUSTOMER_SERIES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUSTOMER_SERIES ADD LEVEL_CODE__HIER CHAR(5)  
ALTER TABLE CONSTDEMONEW.CUSTOMER_SERIES ADD REPL_PERIOD VARCHAR2(3)  
ALTER TABLE CONSTDEMONEW.CUSTOMER_SERIES_UPLOAD ADD AGE_BRACKET CHAR(3)  
ALTER TABLE CONSTDEMONEW.CUSTOMER_SERIES_UPLOAD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUSTOMER_SERIES_UPLOAD ADD RX_MODE CHAR(3)  
ALTER TABLE CONSTDEMONEW.CUSTOMER_SPE MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUSTOMER_SPE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUST_BANK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUST_BYPASS_CRCHK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUST_CREDIT_HIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUST_ITEM_TYPE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUST_PLIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUST_STOCK MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUST_STOCK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUST_STOCK_AMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.CUST_STOCK_DET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DAILY_EXCH_RATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DAILY_EXCH_RATE_SELL_BUY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DB_SQL_EXEC MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DB_SQL_EXEC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DEALLOC_ART MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DEPB MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DEPB_APPLICATION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DEPB_RATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DEPR_ITEMGRP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DEPR_ITEMSER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DESIGNATION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DESPATCH MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DESPATCH MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DESPATCH ADD CUST_PO_REF VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.DESPATCH ADD HS_CODE VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.DESPATCH MODIFY TRANS_MODE CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.DESPATCH MODIFY UDF__STR1 CHAR(50)  
ALTER TABLE CONSTDEMONEW.DESPATCHDET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DESPATCHDET ADD FROM_DATE DATE  
ALTER TABLE CONSTDEMONEW.DESPATCHDET ADD TO_DATE DATE  
ALTER TABLE CONSTDEMONEW.DESPATCH_SCAN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DEVICE_AUTH MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISC_APR_STRG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISC_LIST MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISC_LIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISC_LIST_APPL MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISC_LIST_APPL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISPLAY_TYPE MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISPLAY_TYPE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISPUTED_RECV MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISTANCE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISTORDAMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISTORDER MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISTORDER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISTORDER ADD STAN__CODE_NOTIFY CHAR(5)  
ALTER TABLE CONSTDEMONEW.DISTORDER_CLOSE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISTORD_ISS MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISTORD_ISS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISTORD_ISSDET MODIFY UNIT CHAR(3) NULL 
ALTER TABLE CONSTDEMONEW.DISTORD_RCP MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISTORD_RCP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISTORD_RCPDET MODIFY LOT_SL CHAR(15) NULL 
ALTER TABLE CONSTDEMONEW.DISTRCP_EXSH_HDR MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISTRCP_EXSH_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISTROUTE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DISTROUTEDET MODIFY PIN__FR VARCHAR2(15) NULL 
ALTER TABLE CONSTDEMONEW.DISTROUTEDET MODIFY PIN__TO VARCHAR2(15) NULL 
ALTER TABLE CONSTDEMONEW.DISTROUTEDET MODIFY STATE_CODE__FR CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.DISTROUTEDET MODIFY STATE_CODE__TO CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.DISTROUTEDET MODIFY TRANS_MODE CHAR(5)  
ALTER TABLE CONSTDEMONEW.DIST_DEMAND MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DIST_INTERSITE_OPTIONS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DND_DEAL MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DND_DEAL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DOCK_TRAN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DOC_CONTENTS MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DOC_CONTENTS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DOC_FOLDER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DOC_TRANSACTION_LINK ADD MIGRATION_STATUS CHAR(1)  
ALTER TABLE CONSTDEMONEW.DOC_TRANSACTION_LINK MODIFY REF_COL VARCHAR2(100) NULL 
ALTER TABLE CONSTDEMONEW.DOC_TYPE MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DOC_TYPE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DOC_TYPE ADD PROC_MTD VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.DOC_TYPE_PROC MODIFY FILE_TYPE VARCHAR2(50) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.DORD_TERM ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.DRAWBACK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DRAWBACK_ENCASH MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DRCR_INV MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DRCR_INVDET ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.DRCR_PAY MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DRCR_PAY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DRCR_RCP MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DRCR_RCP MODIFY CCTR_CODE CHAR(4) NULL 
ALTER TABLE CONSTDEMONEW.DRCR_RCP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DRCR_RCP MODIFY CUST_REF_NO VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.DR_CHEMIST_VISIT MODIFY CHEMIST_NAME VARCHAR2(77)  
ALTER TABLE CONSTDEMONEW.DR_CHEMIST_VISIT MODIFY VISITED_WITH_OTHER_NAME VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.DR_DOCTOR_VISIT MODIFY VISITED_WITH_OTHER_NAME VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.DR_MAIN ADD ACTIVITY_INFO VARCHAR2(500)  
ALTER TABLE CONSTDEMONEW.DR_MAIN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DR_MAIN ADD REPORT_SRC CHAR(5)  
ALTER TABLE CONSTDEMONEW.DR_SAMPLE_DISTRIBUTED MODIFY SC_TYPE VARCHAR2(1) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.DR_TRAVEL_DETAILS ADD ROUTE_TYPE CHAR(1)  
ALTER TABLE CONSTDEMONEW.DWH_PRODUCTION_ITEM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DWH_PRODUCTION_PLAN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.DWH_REPL_TAR_LOG MODIFY REF_ID VARCHAR2(30)  
ALTER TABLE CONSTDEMONEW.DWH_REPL_TAR_LOG MODIFY REF_SER CHAR(6)  
ALTER TABLE CONSTDEMONEW.DWH_SALES_SUM ADD ITEM_SERIES VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.DWH_SALES_SUM ADD TRAN_CODE VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.DWH_TIME ADD FY VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.ECMPARM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ECM_CATEGORY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ECM_ITEM_RATING MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ECM_ORDER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ECM_SUB_CATEGORY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EDI_CONTROL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EDI_ERROR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMAIL_LOG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPEXPERIENCE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPFAMILY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPINDUCTION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPLEAVE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPLEAVE_CANCEL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPLEAVE_ENCH_ARR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPLEAVE_SUMMARY MODIFY USE_FLAG CHAR(6)  
ALTER TABLE CONSTDEMONEW.EMPLOAN_ADD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPLOAN_SANCTION MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPLOAN_SANCTION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE MODIFY CHG_DATE DATE NULL 
ALTER TABLE CONSTDEMONEW.EMPLOYEE MODIFY CHG_TERM VARCHAR2(15) NULL 
ALTER TABLE CONSTDEMONEW.EMPLOYEE MODIFY CHG_USER CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.EMPLOYEE MODIFY EMP_FNAME_LONG VARCHAR2(30) NULL 
ALTER TABLE CONSTDEMONEW.EMPLOYEE MODIFY EMP_LNAME_LONG VARCHAR2(30) NULL 
ALTER TABLE CONSTDEMONEW.EMPLOYEE MODIFY EMP_MNAME_LONG VARCHAR2(30) NULL 
ALTER TABLE CONSTDEMONEW.EMPLOYEE ADD IMAGE BLOB  
ALTER TABLE CONSTDEMONEW.EMPLOYEE ADD SIGN BLOB  
ALTER TABLE CONSTDEMONEW.EMPLOYEEEVENTS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_AD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_AD MODIFY TRAN_ID CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.EMPLOYEE_ADD_CHANGE ADD ADHAR_ATTACH_PROOF VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_ADD_CHANGE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_ADD_CHANGE ADD CURR_ADDR_PROOF VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_ADD_CHANGE ADD DRIVING_ATTACH_PROOF VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_ADD_CHANGE ADD ELECTION_ATTACH_PROOF VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_ADD_CHANGE ADD IFSC_ATTACH_PROOF VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_ADD_CHANGE ADD IT_ATTACH_PROOF VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_ADD_CHANGE ADD PER_ADDR_PROOF VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_ADD_CHANGE ADD UAN_ATTACH_PROOF VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_APRV_AUTH MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_BANK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_BOND ADD AD_CODE CHAR(5)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_BOND ADD BOND_LINE_ID CHAR(10)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_BOND MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_BOND ADD EFF_DATE DATE  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_BOND ADD TRAN_ID CHAR(10)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_BOND ADD TRAN_ID__PVOUCH CHAR(10)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_BOND ADD TRAN_TYPE CHAR(3)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_BOND_DEF ADD AD_CODE CHAR(5)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_BOND_DEF MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_BOND_DEF ADD EFF_DATE DATE  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_BOND_DEF ADD TRAN_ID__BOND CHAR(10)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_BOND_DEF ADD TRAN_ID__PVOUCH CHAR(10)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_BOND_DEF ADD TRAN_TYPE CHAR(3)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_DET_CHANGE ADD ADHAR_ATTACH_PROOF VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_DET_CHANGE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_DET_CHANGE ADD DRIVING_ATTACH_PROOF VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_DET_CHANGE ADD ELECTION_ATTACH_PROOF VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_DET_CHANGE MODIFY EMP_FNAME_LONG VARCHAR2(30) NULL 
ALTER TABLE CONSTDEMONEW.EMPLOYEE_DET_CHANGE MODIFY EMP_FNAME_LONG_O VARCHAR2(30) NULL 
ALTER TABLE CONSTDEMONEW.EMPLOYEE_DET_CHANGE MODIFY EMP_LNAME_LONG VARCHAR2(30) NULL 
ALTER TABLE CONSTDEMONEW.EMPLOYEE_DET_CHANGE MODIFY EMP_LNAME_LONG_O VARCHAR2(30) NULL 
ALTER TABLE CONSTDEMONEW.EMPLOYEE_DET_CHANGE MODIFY EMP_MNAME_LONG VARCHAR2(30) NULL 
ALTER TABLE CONSTDEMONEW.EMPLOYEE_DET_CHANGE MODIFY EMP_MNAME_LONG_O VARCHAR2(30) NULL 
ALTER TABLE CONSTDEMONEW.EMPLOYEE_DET_CHANGE ADD IFSC_ATTACH_PROOF VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_DET_CHANGE ADD IT_ATTACH_PROOF VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_DET_CHANGE ADD UAN_ATTACH_PROOF VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_MTHAD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPLOYEE_PERK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPLVE_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPL_CLAIM_CATG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPOTIME MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPPROMOTION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPREDESIGN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPSKILLS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPTRAINING MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPTRANPROM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPTRANPROM MODIFY DEPT_CODE__FROM CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.EMPTRANPROM MODIFY DEPT_CODE__TO CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.EMPTRANSFER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMPTRANSFER MODIFY WORK_CTR__FR CHAR(10)  
ALTER TABLE CONSTDEMONEW.EMPTRANSFER MODIFY WORK_CTR__TO CHAR(10)  
ALTER TABLE CONSTDEMONEW.EMPTRANSFERSQL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_ADCLAIM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_ADCLAIMHDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_ALLOW MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_ALLOW ADD CLAIM_PRD_REQ CHAR(1)  
ALTER TABLE CONSTDEMONEW.EMP_ALLOW ADD PROOF_REQ CHAR(1)  
ALTER TABLE CONSTDEMONEW.EMP_ALLOW ADD PROP_ON CHAR(1)  
ALTER TABLE CONSTDEMONEW.EMP_APRSL_FORM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_APRSL_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_APRSL_SPEC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_DELIGATION_HIS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_EMPLOY_EVENTS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_EXIT_CLEARANCE_CHECKLIST MODIFY CLEARANCE_ID CHAR(10) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.EMP_EXIT_CLEARANCE_CHECKLIST MODIFY LINE_NO CHAR(3) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.EMP_ITDECL_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_ITDECL_HDR ADD ITAX_POLICY CHAR(10)  
ALTER TABLE CONSTDEMONEW.EMP_IT_DECLARATION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_IT_DECL_QTR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_LVEBAL_TRF_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_LVE_CARD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG ADD ADD_DATE DATE  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG ADD ADD_TERM VARCHAR2(300)  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG ADD ADD_USER VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG ADD CANC_REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG ADD EMP_FNAME__O VARCHAR2(30)  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG ADD EMP_LNAME__O VARCHAR2(30)  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG ADD EMP_MNAME__O VARCHAR2(30)  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG ADD GENERATE_VOUCHER CHAR(1)  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG ADD REJ_BY CHAR(10)  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG ADD REJ_DATE DATE  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG ADD REJ_REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG ADD REVS_VOUCHER_NO CHAR(10)  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG ADD SHORT_NAME__O VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG ADD STATUS_DATE__O DATE  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG ADD TRANS_MODE CHAR(1)  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG ADD TRAN_ID CHAR(10)  
ALTER TABLE CONSTDEMONEW.EMP_MARITALCHG ADD WF_STATUS CHAR(1)  
ALTER TABLE CONSTDEMONEW.EMP_PERKBAL_TRF_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_PO_LIMIT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_REIMB_CLAIM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_REPCHG_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_SKIP_MONTH MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_STATUSCHG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_STATUSCHG_FIELD MODIFY TRAN_ID CHAR(10) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.EMP_TRAVEL_INFO MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EMP_WITH_HELD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ENQ_HDR MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ENQ_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EPCG_DET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EPCG_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ERC_CATG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EVENTS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EVENT_EXE_BRAND MODIFY BRAND_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.EVENT_EXE_BRAND ADD ITEM_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.EVENT_EXE_REQ ADD ITEM_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.EVENT_PLAN_REQ ADD ITEM_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.EVENT_STRG MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EVENT_STRG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EVENT_TYPE MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EVENT_TYPE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EXCH_RATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EXPORT_FUND MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EXPORT_FUNDET MODIFY REF_NO CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.EXPORT_FUNDET MODIFY REF_SER CHAR(6) NULL 
ALTER TABLE CONSTDEMONEW.EXPR_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EXPR_HDR_AMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EXPR_ISS_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EXPR_LEAR_DET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EXPR_PROCESS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EXPR_STAB_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EXP_ALLOWANCE_BAL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EXP_CATEGORY MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EXP_CATEGORY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EXP_CATEGORY ADD ENTITY_OPT CHAR(1)  
ALTER TABLE CONSTDEMONEW.EXP_WALLET MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EXP_WALLET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EXP_WALLET_ENTITY MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EXP_WALLET_ENTITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.EXT_SERVICE_LOG MODIFY TOKEN_ID VARCHAR2(3500)  
ALTER TABLE CONSTDEMONEW.E_INVOICE_UPDATE MODIFY REF_ID CHAR(10) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.E_INVOICE_UPDATE MODIFY REF_SER CHAR(6) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.E_INVOICE_UPDATE MODIFY TRAN_TYPE CHAR(1) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.FACILITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FAQ MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FIELDACTIVITY ADD ACTIVITY_PLACE CHAR(1)  
ALTER TABLE CONSTDEMONEW.FIELDACTIVITY ADD ACTIVITY_SEL CHAR(1)  
ALTER TABLE CONSTDEMONEW.FIELDACTIVITY ADD ALLOW_CHG_VISITTIME CHAR(1)  
ALTER TABLE CONSTDEMONEW.FIELDACTIVITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FIELDACTIVITY ADD EMAIL_NOTIFY CHAR(1)  
ALTER TABLE CONSTDEMONEW.FIELDACTIVITY ADD INT_OPTION CHAR(1)  
ALTER TABLE CONSTDEMONEW.FIELDACTIVITY ADD LOC_REQ CHAR(1)  
ALTER TABLE CONSTDEMONEW.FIELDACTIVITY ADD MULTI_OPT CHAR(1)  
ALTER TABLE CONSTDEMONEW.FIELDACTIVITY ADD PARENT_ACT_CODE CHAR(2)  
ALTER TABLE CONSTDEMONEW.FIELDACTIVITY ADD PITCH_OPTION CHAR(1)  
ALTER TABLE CONSTDEMONEW.FINENT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FINENT ADD CIN_NO VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.FINENT_ACCTPRD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FIN_CTRL_EXCP MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FIN_CTRL_EXCP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FIN_PROVISION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FLATBOOK_AMD_HDR MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FLATBOOK_AMD_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FLOOR_MST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FLOOR_MST MODIFY SITE_CODE CHAR(5) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.FORECAST_INDICATOR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FORECAST_TECH MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FOREX_REQ_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FOREX_SURR_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FORM16_ACKNOWLEDGE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FORM16_PAYMENT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FOUNDITEMHDR_CD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FOUNDITEM_CD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FREIGHT_CHARGES_TABLE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FREIGHT_LIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FREIGHT_RATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FREIGHT_RATE_DET MODIFY CHARGE_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.FREIGHT_RATE_DET ADD DIST_FROM CHAR(5)  
ALTER TABLE CONSTDEMONEW.FREIGHT_RATE_DET ADD DIST_TO CHAR(5)  
ALTER TABLE CONSTDEMONEW.FREIGHT_RATE_DET ADD LINE_NO CHAR(3)  
ALTER TABLE CONSTDEMONEW.FREIGHT_RATE_DET MODIFY LOAD_TYPE CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.FREIGHT_RATE_DET MODIFY STAN_CODE__FROM CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.FREIGHT_RATE_DET MODIFY STAN_CODE__TO CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.FT_BENEFIT_APPL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FT_BENEFIT_GRP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FT_BENEFIT_LINK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FT_BENEFIT_SCH MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FULLFINAL_DET MODIFY CCTR_CODE CHAR(4) NULL 
ALTER TABLE CONSTDEMONEW.FULLFINAL_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FUNDTRANSFER MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FUNDTRANSFER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FUNDTRANSFER_CTRL MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FUNDTRANSFER_CTRL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FUNDTRANSFER_DET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FUNDTRANSFER_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.FUNDTRANSFER_HDR ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.FUNDTRAN_CONS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GATE_REGISTER MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GATE_REGISTER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GATE_REGISTER ADD INVOICE_DATE DATE  
ALTER TABLE CONSTDEMONEW.GATE_REGISTER ADD INVOICE_NO VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.GATE_REGISTER MODIFY LORRY_NO VARCHAR2(20) NULL 
ALTER TABLE CONSTDEMONEW.GATE_REGISTER ADD STATUS CHAR(1)  
ALTER TABLE CONSTDEMONEW.GATE_REGISTER ADD STATUS_DATE DATE  
ALTER TABLE CONSTDEMONEW.GENCODES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GLTRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GLTRACE MODIFY SUNDRY_TYPE CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.GLTRACE_PREVIEW MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GLTRAN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GL_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GPROC_DESIGN ADD LAYOUT_DATA CLOB  
ALTER TABLE CONSTDEMONEW.GPROC_DESIGN_CALC MODIFY CALC_EXPRESSION VARCHAR2(500)  
ALTER TABLE CONSTDEMONEW.GRADE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GRADE_AD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GRADE_ALLOW MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GRADE_ALLOW ADD CLAIM_PRD_REQ CHAR(1)  
ALTER TABLE CONSTDEMONEW.GRADE_ALLOW ADD PROOF_REQ CHAR(1)  
ALTER TABLE CONSTDEMONEW.GRADE_ALLOW ADD PROP_ON CHAR(1)  
ALTER TABLE CONSTDEMONEW.GRADE_APPR_CS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GRADE_APPR_CS ADD REF_SER CHAR(6)  
ALTER TABLE CONSTDEMONEW.GRADE_EXPENSE_LIMIT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GRADE_KRA MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GRADE_MTHAD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GRADE_PERK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GRADE_SITE_LVETBL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GRADE_SITE_OT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GRADE_SITE_OT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GROUP_PRICELIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GST_DATA_HDR MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GST_DATA_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.GST_DATA_HDR MODIFY TRAN_ID__REF CHAR(12)  
ALTER TABLE CONSTDEMONEW.HIERARCHY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.HIERARCHY_COPY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.HIERARCHY_DET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.HOLIDAY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.HTL_BILL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.HTL_BOOK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.HTL_BOOK_AMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.HTL_CANCEL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.HTL_PAX_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.HTL_REQ MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.HTL_REQ_AMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.HUNDI_PAY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.IBCA_CONSOLE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.IBCA_PAY_CTRL MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.IBCA_PAY_CTRL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.IBCA_RCP_CTRL MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.IBCA_RCP_CTRL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.IDLEMESSAGE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INCIDENT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INCIDENT ADD EQUIP_NAME VARCHAR2(60)  
ALTER TABLE CONSTDEMONEW.INCIDENTTYPE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INCPARM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INC_CHARGES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INDENT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INDENT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INDENT_AMD MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INDENT_AMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INDENT_AMD ADD TEST_REMARKS VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.INDENT_CLOSE MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INDENT_CLOSE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INDENT_HDR MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INDENT_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INDEPENDENT_DEMAND ADD BOM_CODE_UML CHAR(10)  
ALTER TABLE CONSTDEMONEW.INDEPENDENT_DEMAND MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INDUCTION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INSTITUTE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INSURANCE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INSURANCE_DET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INSURANCE_DET ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.INS_AGENT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INTERCOMP_RECO_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INTERESTTERM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INVALLOC_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INVDET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INVOICE MODIFY CHG_TERM CHAR(15) NULL 
ALTER TABLE CONSTDEMONEW.INVOICEMEMO MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INVOICE_AMENDMENT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INVOICE_AMENDMENT ADD ARE1_NO CHAR(20)  
ALTER TABLE CONSTDEMONEW.INVOICE_AMENDMENT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INVOICE_AMENDMENT ADD CLG_AGENT VARCHAR2(30)  
ALTER TABLE CONSTDEMONEW.INVOICE_AMENDMENT ADD VEHICLE_NO CHAR(20)  
ALTER TABLE CONSTDEMONEW.INVOICE_SRNOHDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INVOICE_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INVTRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INV_ALLOCATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INV_DEM_SUPP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INV_DEM_SUPP_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INV_DEM_SUPP_TRACE MODIFY REF_SER CHAR(6) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.INV_DISC_DET MODIFY ACCT_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.INV_DISC_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INV_FREEZE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INV_HOLD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INV_HOLD_REL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INV_LOCK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INV_PACK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.INV_PACK_RCP MODIFY PACK_CODE CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.INV_RESTR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEM MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEM MODIFY ISS_CRITERIA CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.ITEM MODIFY ITEM_USAGE CHAR(3) NULL 
ALTER TABLE CONSTDEMONEW.ITEM MODIFY QC_REQD CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.ITEM MODIFY QC_REQD_TYPE CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.ITEM MODIFY TECH_DESCR VARCHAR2(900)  
ALTER TABLE CONSTDEMONEW.ITEM MODIFY TRACK_SHELF_LIFE CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.ITEM MODIFY UNIT__PUR CHAR(3) NULL 
ALTER TABLE CONSTDEMONEW.ITEM MODIFY UNIT__RATE CHAR(3) NULL 
ALTER TABLE CONSTDEMONEW.ITEMDIS_GRP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEMMNFR MODIFY APPRV_LEVEL CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.ITEMMNFR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEMMNFR MODIFY VALID_UPTO DATE NULL 
ALTER TABLE CONSTDEMONEW.ITEMMNFR_DET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEMMNFR_DET MODIFY DOC_RECEIVED CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.ITEMMNFR_DET MODIFY EFF_FROM DATE NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.ITEMMNFR_DET MODIFY ITEM_CODE CHAR(10) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.ITEMMNFR_DET MODIFY MANDATORY CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.ITEMMNFR_DET MODIFY SUPP_CODE__MNFR CHAR(10) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.ITEMREGNO MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEMSER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEMSER_CHANGE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEMSER_CR_POLICY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEM_ACCTDETR_PROV MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEM_ACCT_ANALYSIS MODIFY CHG_DATE DATE NULL 
ALTER TABLE CONSTDEMONEW.ITEM_ACCT_ANALYSIS MODIFY CHG_TERM VARCHAR2(15) NULL 
ALTER TABLE CONSTDEMONEW.ITEM_ACCT_ANALYSIS MODIFY CHG_USER CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.ITEM_ACCT_DETR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEM_ACCT_DETR_DIST MODIFY ACCT_CODE__INV CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.ITEM_ACCT_DETR_DIST MODIFY ACCT_CODE__ISS CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.ITEM_ACCT_DETR_DIST MODIFY ACCT_CODE__RCP CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.ITEM_ACCT_DETR_DIST MODIFY CCTR_CODE__INV CHAR(4) NULL 
ALTER TABLE CONSTDEMONEW.ITEM_ACCT_DETR_DIST MODIFY CCTR_CODE__ISS CHAR(4) NULL 
ALTER TABLE CONSTDEMONEW.ITEM_ACCT_DETR_DIST MODIFY CCTR_CODE__RCP CHAR(4) NULL 
ALTER TABLE CONSTDEMONEW.ITEM_ACCT_DETR_DIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEM_ATTRIBUTE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEM_CREDIT_PERC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEM_LOT_INFO MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEM_LOT_INFO ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.ITEM_LOT_OWN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEM_LOT_PACKSIZE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEM_OVERHEAD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEM_OWN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEM_OWN_VALIDITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEM_STD_SIZE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITEM_TYPE ADD ATTRIB_FORMAT_1 VARCHAR2(500)  
ALTER TABLE CONSTDEMONEW.ITEM_TYPE ADD ATTRIB_FORMAT_2 VARCHAR2(500)  
ALTER TABLE CONSTDEMONEW.ITEM_TYPE ADD ATTRIB_FORMAT_3 VARCHAR2(500)  
ALTER TABLE CONSTDEMONEW.ITEM_TYPE ADD ATTRIB_FORMAT_4 VARCHAR2(500)  
ALTER TABLE CONSTDEMONEW.ITEM_TYPE ADD ATTRIB_FORMAT_5 VARCHAR2(500)  
ALTER TABLE CONSTDEMONEW.ITEM_TYPE ADD ATTRIB_FORMAT_6 VARCHAR2(500)  
ALTER TABLE CONSTDEMONEW.ITEM_TYPE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITM_ACCESS_LOG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITM_ACCESS_LOG MODIFY USER_ID CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.ITM_ATTRIB_VAL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITM_EXT_PROC MODIFY CHG_TERM CHAR(20)  
ALTER TABLE CONSTDEMONEW.ITPROJ_CALCHDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ITPROJ_CALCHDR MODIFY FIN_ENTITY CHAR(10)  
ALTER TABLE CONSTDEMONEW.IT_CALCDET_SPLIT MODIFY ACCT_PRD CHAR(6) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.IT_CALCDET_SPLIT MODIFY AD_CODE CHAR(5) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.IT_CALCDET_SPLIT MODIFY EMP_CODE CHAR(10) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.IT_CALCDET_SPLIT MODIFY PRD_CODE__FR CHAR(6) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.IT_CALCDET_SPLIT MODIFY PRD_CODE__TO CHAR(6) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.IT_CALCHDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.IT_CALCHDR MODIFY FIN_ENTITY CHAR(10)  
ALTER TABLE CONSTDEMONEW.JMS_LOGS ADD MESSAGE_SERVICE_NAME VARCHAR2(100)  
ALTER TABLE CONSTDEMONEW.JMS_LOGS MODIFY REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.JOURNAL MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.JOURNAL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.KRA MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.KRATABLE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LAB_BOOKING MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LAB_BOOKING_AMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LANDING_RATE_MST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LC_VOUCHER MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LC_VOUCHER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LC_VOUCHER_AMEND MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LEAD_ASSIGNMENT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LEAD_ASSIGNMENT MODIFY STRG_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.LEAVEBAL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LEAVEBAL_FORECAST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LEAVES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LEGAL_AGR_EXT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LEGAL_AGR_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LGST_CONTRACT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LGST_CONTRACT_DET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LGST_SERVICE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LGST_SRV_DET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LICENCE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LICENCE_AUTH_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LICENCE_ISS_RET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOANPARTY MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOANPARTY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOANPARTY_BANK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOANS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOANS_INTEREST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOANS_INTEREST_DET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOANS_SCHEDULE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOANS_SCHEDULE_DET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOAN_ADJ MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOAN_DET ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.LOAN_HDR MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOAN_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOAN_INST_CHANGE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOAN_INT_REG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOAN_PARTY_BANK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOAN_RECO MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOAN_REG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOAN_SCHEME MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOAN_SCHEME_GRADE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOCALITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOCALITY MODIFY COUNT_CODE CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.LOCALITY ADD PRICE_LIST__DISC CHAR(5)  
ALTER TABLE CONSTDEMONEW.LOCALITY ADD PRICE_LIST__PAYDIS CHAR(5)  
ALTER TABLE CONSTDEMONEW.LOCALITY ADD QC_TEST1 VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.LOCALITY ADD QC_TEST2 VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.LOCATION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOCK_GROUP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LOT_STAT_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.LVETABLE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MACHINEITEM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MACHINES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MACHINETOOLS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MACHINE_LOG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MAC_OBSERV MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MAILING_LIST MODIFY MAIL_LIST_ID CHAR(10) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.MAINTENANCE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MAINTENANCE_ADH MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MAINTENANCE_SCH MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MAINT_SCH MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MARKET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MASTER_GEN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MASTER_GEN_COLS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MASTER_GEN_TABLE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MCPARTS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MC_SLOT_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MERGE1 MODIFY OBJ_NAME CHAR(10) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.MERGE1 MODIFY WIN_NAME CHAR(10) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.MFG_LAYOUT_ITEM MODIFY ITEM_CODE VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.MFG_NOTE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MIN_RATE_HISTORY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MIN_STATUSCHGSCORE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MISC_DRCR_RCP MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MISC_DRCR_RCP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MISC_DRCR_RCP MODIFY CUST_REF_NO VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.MISC_PAYABLES MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MISC_PAYABLES ADD BATCH_NO VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MISC_PAYABLES ADD TRAN_ID__LC CHAR(10)  
ALTER TABLE CONSTDEMONEW.MISC_PAYDET MODIFY CCTR_CODE__AP CHAR(4) NULL 
ALTER TABLE CONSTDEMONEW.MISC_PAYDET ADD ITEM_SER VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.MISC_PAYDET ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.MISC_PAYMENT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MISC_PAYMENT MODIFY CCTR_CODE__BAL CHAR(4) NULL 
ALTER TABLE CONSTDEMONEW.MISC_PAYMENT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MISC_PAYMENT MODIFY REMARKS VARCHAR2(100)  
ALTER TABLE CONSTDEMONEW.MISC_PAYMENT MODIFY SUNDRY_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.MISC_PAYMENT_CANC MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MISC_PAYMENT_CANC MODIFY CCTR_CODE__BAL CHAR(4) NULL 
ALTER TABLE CONSTDEMONEW.MISC_PAYMENT_CANC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MISC_PAYMENT_CANCDET ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.MISC_PAY_RCP_TRACE MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MISC_PAY_RCP_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MISC_PAY_RCP_TRACE ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.MISC_PAY_RCP_TRACE ADD SITE_CODE CHAR(5)  
ALTER TABLE CONSTDEMONEW.MISC_RECEIPT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MISC_RECEIPT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MISC_VCH_EMP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MISC_VOUCHACCT MODIFY REMARKS CHAR(200)  
ALTER TABLE CONSTDEMONEW.MISC_VOUCHER MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MISC_VOUCHER ADD AUTO_ADJ_ADV CHAR(1)  
ALTER TABLE CONSTDEMONEW.MISC_VOUCHER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MISC_VOUCHER MODIFY PAY_MODE CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.MISC_VOUCHER MODIFY TRAN_MODE CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.MISC_VOUCHER_TRACE MODIFY LINE_NO CHAR(3) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.MISC_VOUCH_GEN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MKTG_CAMPAIGN MODIFY CAMPAIGN_ID CHAR(10) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.MODULEATTRIB MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MODULES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MODULESOBJ MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MODULE_MASTER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MPL_SUB_BU_LINK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MPR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MPRBUDGET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MPREQ MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MPREQ ADD TRAN_ID__REF CHAR(10)  
ALTER TABLE CONSTDEMONEW.MPREQ ADD TRAN_SER__REF CHAR(10)  
ALTER TABLE CONSTDEMONEW.MPREQ ADD TRAN_TYPE__REF CHAR(1)  
ALTER TABLE CONSTDEMONEW.MPS_ORDER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MULTI_PICK_ISS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MY_EXPENSE MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MY_EXPENSE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.MY_EXPENSE ADD CLAIM_STAT CHAR(1)  
ALTER TABLE CONSTDEMONEW.MY_EXPENSE ADD ENTITY_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.MY_EXPENSE ADD ENTITY_TYPE CHAR(1)  
ALTER TABLE CONSTDEMONEW.NCL_STRG_CUSTOMER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.NCL_STRG_QUALIFICATION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.NCL_STRG_SPECIALITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.NET_PRINTERS ADD PROTOCOL_TYPE CHAR(1)  
ALTER TABLE CONSTDEMONEW.NOTESNCOINS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.OBJECT_ATTRIB MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.OBJ_ATTRIBUTE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.OBJ_FILE_TEMPLATE MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.OBJ_FILE_TEMPLATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.OBJ_SIGN_TRANS MODIFY USER_ID__SIGN VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.OBJ_SMART_FILTER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.OBJ_USER_PREF MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.OBJ_USER_PREF MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ODL_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.OLE_FORMATS MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.OLE_FORMATS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.OPPORTUNITY MODIFY CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.OPPORTUNITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.OPPORTUNITY MODIFY FORECAST_CLOSE_DATE DATE  
ALTER TABLE CONSTDEMONEW.OPPORTUNITY MODIFY OPPR_DATE DATE  
ALTER TABLE CONSTDEMONEW.OPPORTUNITY ADD STATUS_DATE DATE  
ALTER TABLE CONSTDEMONEW.OPPR_ASSESMENT MODIFY ASS_DATE DATE  
ALTER TABLE CONSTDEMONEW.OPPR_ASSESMENT MODIFY CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.OPPR_ASSESMENT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.OPPR_ASS_USP MODIFY CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.OPPR_ASS_USP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.OPPR_TYPE MODIFY CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.OPPR_TYPE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ORG_CUST_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ORG_STRUCTURE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ORG_STRUCTURE_CUST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ORG_STRUC_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.OVERHEAD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PACKING MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PACKING_DET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PACK_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PALLETMERGE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PALLETMERGE_DET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PALLET_HDR MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PALLET_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PALLET_REQ_HDR MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PALLET_REQ_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PAYABLES_DTL MODIFY CCTR_CODE CHAR(4) NULL 
ALTER TABLE CONSTDEMONEW.PAYABLES_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PAYABLES_TRF MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PAYARR_TO_PROC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PAYARR_TO_PROC_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PAYMENT_EXP MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PAYMENT_EXP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PAYRENV MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PAYROLL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PAYROLL_GEN_LOG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PAYROLL_PROJHDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PAYR_VOUCHDET MODIFY CCTR_CODE CHAR(4) NULL 
ALTER TABLE CONSTDEMONEW.PAYR_VOUCHER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PAYR_VOUCHER MODIFY TRAN_TYPE CHAR(3) NULL 
ALTER TABLE CONSTDEMONEW.PAYTABLE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PAY_3WAY_STAT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PAY_3WAY_STAT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PAY_IBCA MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PAY_IBCA MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PAY_IBCA MODIFY REMARKS VARCHAR2(100)  
ALTER TABLE CONSTDEMONEW.PAY_IBCA_DET MODIFY CCTR_CODE CHAR(4) NULL 
ALTER TABLE CONSTDEMONEW.PBCATCOL MODIFY PBC_CMNT VARCHAR2(500)  
ALTER TABLE CONSTDEMONEW.PBCATTBL ADD MOD_NAME VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PBCATTBL MODIFY PBT_CMNT VARCHAR2(500)  
ALTER TABLE CONSTDEMONEW.PCONTRACTAMD_HDR MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PCONTRACTAMD_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PCONTRACT_HDR MODIFY ACCEPT_CRITERIA CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.PCONTRACT_HDR MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PCONTRACT_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PDC_GIVEN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PDC_GIVENDET ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.PDC_RECEIVED MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PERIOD_APPL MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PERIOD_APPL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PERIOD_STAT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PERIOD_STAT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PERIOD_TBL MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PERIOD_TBL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PERK_PROCESS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PFNO_CHANGE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PFNO_CHANGE ADD CHG_TYPE CHAR(1)  
ALTER TABLE CONSTDEMONEW.PFNO_CHANGE ADD UAN_NO VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.PHYSCAN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PICK_ISS_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PICK_ORD_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PLACE_TIME_ENT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PLACE_TIME_ENT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PLAN_COLLAB MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PLIST_CHKLIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PLIST_ITEM_OPTION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PL_FORMAT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PMS_TYPES ADD AMT_VAL_REQ CHAR(1)  
ALTER TABLE CONSTDEMONEW.PMS_TYPES ADD ATTACH_VAL_REQ CHAR(1)  
ALTER TABLE CONSTDEMONEW.PMS_TYPES ADD BILL_NO_VAL_REQ CHAR(1)  
ALTER TABLE CONSTDEMONEW.PMS_TYPES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PM_FEEDBACK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PM_ORDER MODIFY AUTO_GENERATE CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.PM_ORDER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PM_ORDER MODIFY MAINT_TYPE CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.PM_ORDER_REASS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.POAMD_DET MODIFY ACCT_CODE__CR CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.POAMD_DET MODIFY ACCT_CODE__DR CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.POAMD_DET MODIFY CCTR_CODE__CR CHAR(4) NULL 
ALTER TABLE CONSTDEMONEW.POAMD_DLV_TERM ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.POAMD_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.POAMD_HDR MODIFY CR_TERM CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.POAMD_HDR MODIFY CR_TERM__O CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.POAMD_HDR MODIFY DLV_TERM CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.POAMD_HDR MODIFY DLV_TERM__O CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.POAMD_TERM ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.POB_HDR MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.POB_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PODTRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.POLICYMST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.POOLMASTER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PORCP MODIFY ACCEPT_CRITERIA CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.PORCP MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PORCP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PORCP ADD SHEL_LIFE__TYPE CHAR(1)  
ALTER TABLE CONSTDEMONEW.PORCPDET MODIFY LOT_SL CHAR(15) NULL 
ALTER TABLE CONSTDEMONEW.PORCPDET MODIFY PURC_ORDER CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.PORCP_AMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PORDDET MODIFY ACCT_CODE__CR CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.PORDDET MODIFY CCTR_CODE__CR CHAR(4) NULL 
ALTER TABLE CONSTDEMONEW.PORDDET ADD CUST_ITEM__RFC VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.PORDER MODIFY ACCEPT_CRITERIA CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.PORDER MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PORDER ADD AUTO_CLOSE_DATE DATE  
ALTER TABLE CONSTDEMONEW.PORDER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PORDER MODIFY CR_TERM CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.PORDER MODIFY DLV_TERM CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.PORDER ADD FREIGHT_STATUS CHAR(1)  
ALTER TABLE CONSTDEMONEW.PORDER_STAT_CHG MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PORDER_STAT_CHG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PORDER_TEMP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PORD_PAY_TERM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PORD_STAT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PORTAL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.POS ADD LR_DATE DATE  
ALTER TABLE CONSTDEMONEW.POS ADD LR_NO VARCHAR2(25)  
ALTER TABLE CONSTDEMONEW.POS ADD TRANS_MODE CHAR(1)  
ALTER TABLE CONSTDEMONEW.POS ADD TRAN_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.POSSESSION_INFO MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.POSSESSION_INFO MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.POST_MARKETING_STUDY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.POWER_ATT_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PO_CLOSE MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PO_CLOSE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PO_CLOSE ADD REAS_PO_CLOSE VARCHAR2(100)  
ALTER TABLE CONSTDEMONEW.PO_CLOSE ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.PQUOT_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PRD_SCHEME_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PRICELIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PRICELIST_GEN_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PRICELIST_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PRICELIST_HDR MODIFY REF_NO VARCHAR2(20) NULL 
ALTER TABLE CONSTDEMONEW.PRICELIST_HDR MODIFY REF_NO_OLD VARCHAR2(20) NULL 
ALTER TABLE CONSTDEMONEW.PRICING_MANAGE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PRICING_MANAGE_LIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PRINT_LOG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PRJCUSTOMER ADD ACTIVE CHAR(1)  
ALTER TABLE CONSTDEMONEW.PRJCUSTOMER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROCESS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROCESSTOOL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROCESS_ACTIONS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROCESS_CONDN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROCESS_MTH MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROCESS_OVERHEAD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROCROUTE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROCROUTE ADD CREATE_GATEPASS CHAR(1)  
ALTER TABLE CONSTDEMONEW.PROCROUTE ADD GATE_PASS_SITE CHAR(1)  
ALTER TABLE CONSTDEMONEW.PROCROUTE ADD SITE_CODE__GP CHAR(5)  
ALTER TABLE CONSTDEMONEW.PROCROUTE_DET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROCROUTE_OPER_INSTR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROC_CTRL_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROC_ERR_LOG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROC_TOOL_COUSAGE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PRODUCT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PRODUCT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PRODUCT ADD MKT_ARR CHAR(1)  
ALTER TABLE CONSTDEMONEW.PRODUCT_FEATURE MODIFY CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.PRODUCT_FEATURE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROF_ACCOUNTS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROF_WSHEET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROF_WSHEET_COMP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROF_WSHEET_MSTDET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROF_WSHEET_MSTSEQ MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROJECT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROJECT MODIFY PROJ_STATUS VARCHAR2(1) NULL 
ALTER TABLE CONSTDEMONEW.PROJECT_TEAM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROJ_ACT_MILESTONE MODIFY PROJ_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.PROJ_ACT_MILESTONE MODIFY TRAN_ID CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.PROJ_ACT_MILESTONE MODIFY WING_ID CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.PROJ_BUD_GRP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROJ_CONST_CONFIG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROJ_CONST_CONFIG ADD CONFIG_UNIT CHAR(10)  
ALTER TABLE CONSTDEMONEW.PROJ_CONST_CONFIG ADD EFF_DATE DATE  
ALTER TABLE CONSTDEMONEW.PROJ_CONST_CONFIG ADD FLOOR_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.PROJ_CONST_CONFIG ADD SITE_CODE CHAR(5)  
ALTER TABLE CONSTDEMONEW.PROJ_CONST_CONFIG ADD WING_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.PROJ_EST_BASELINE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROJ_EST_BSL_ITEM MODIFY ACCT_CODE__EXP VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.PROJ_EST_BSL_ITEM MODIFY ACTIVITY_CODE__PARENT VARCHAR2(10) NULL 
ALTER TABLE CONSTDEMONEW.PROJ_EST_BSL_ITEM MODIFY ACT_UOM VARCHAR2(5)  
ALTER TABLE CONSTDEMONEW.PROJ_EST_BSL_ITEM MODIFY CCTR_CODE__EXP VARCHAR2(4)  
ALTER TABLE CONSTDEMONEW.PROJ_EST_BSL_ITEM MODIFY IND_NO VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.PROJ_EST_BSL_ITEM MODIFY PURC_ORDER VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.PROJ_EST_BSL_ITEM ADD TASK_STATUS CHAR(1)  
ALTER TABLE CONSTDEMONEW.PROJ_EST_BSL_ITEM MODIFY WORK_ORDER VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.PROJ_EST_MILESTONE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROJ_EVAL_GRP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROJ_EVAL_PAR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROJ_EVAL_TABLE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROJ_FEAS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROJ_INIT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROJ_TEAM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROJ_TEMPLATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROJ_TYPE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROOF_OF_EXP_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PROPERTIES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PURCCTRL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PUR_EXP_RECO MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.PUR_TERM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QCITEM_SPEC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QCITEM_SPEC_DET ADD CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.QCITEM_SPEC_DET ADD CHG_TERM VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.QCITEM_SPEC_DET ADD CHG_USER VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.QCITEM_SPEC_DET ADD ENT_OBSERV CHAR(1)  
ALTER TABLE CONSTDEMONEW.QCITEM_SPEC_DET ADD EOLS_EXPECTED_RESULT VARCHAR2(600)  
ALTER TABLE CONSTDEMONEW.QCITEM_SPEC_DET ADD PRINT_OBSERV VARCHAR2(350)  
ALTER TABLE CONSTDEMONEW.QCITEM_SPEC_DET ADD SPEC_UOM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QCITEM_SPEC_DET ADD UNIT CHAR(15)  
ALTER TABLE CONSTDEMONEW.QCORDER_AMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QC_METHOD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QC_ORDER MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QC_ORDER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QC_ORDER MODIFY DEPT_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.QC_ORDER ADD RELEASED CHAR(1)  
ALTER TABLE CONSTDEMONEW.QC_ORDER ADD SHELF_LIFE__TYPE CHAR(1)  
ALTER TABLE CONSTDEMONEW.QC_ORD_PROC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QC_ORD_RES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QC_ORD_SPEC ADD ACTUAL_RESULT_APPROVER VARCHAR2(350)  
ALTER TABLE CONSTDEMONEW.QC_ORD_SPEC ADD APPROVER_CHG_TIME DATE  
ALTER TABLE CONSTDEMONEW.QC_ORD_SPEC ADD CHEMIST_CHG_TIME DATE  
ALTER TABLE CONSTDEMONEW.QC_ORD_SPEC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QC_ORD_SPEC ADD CONDITIONAL_REL VARCHAR2(1)  
ALTER TABLE CONSTDEMONEW.QC_ORD_SPEC ADD ENT_OBSERV CHAR(1)  
ALTER TABLE CONSTDEMONEW.QC_ORD_SPEC ADD OOS_RESULT VARCHAR2(12)  
ALTER TABLE CONSTDEMONEW.QC_ORD_SPEC ADD PRINT_OBSERV VARCHAR2(350)  
ALTER TABLE CONSTDEMONEW.QC_ORD_SPEC ADD REVIEWER_CHG_TIME DATE  
ALTER TABLE CONSTDEMONEW.QC_ORD_SPEC ADD REVIEWER_REMARK VARCHAR2(500)  
ALTER TABLE CONSTDEMONEW.QC_ORD_SPEC ADD SPEC_UOM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QC_ORD_SPEC ADD SUBMIT_REMARK VARCHAR2(500)  
ALTER TABLE CONSTDEMONEW.QC_ORD_SPEC ADD SUBMIT_REMARKS VARCHAR2(500)  
ALTER TABLE CONSTDEMONEW.QC_ORD_SPEC ADD UNIT CHAR(15)  
ALTER TABLE CONSTDEMONEW.QC_SAMPLE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QC_SAMPLE ADD CONSISTANCY_CHK CHAR(1)  
ALTER TABLE CONSTDEMONEW.QC_SAMPLE MODIFY QORDER_NO CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.QC_STABILITY_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QC_STAB_TEST_PATTERN_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QC_TABLES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QC_TRANSFER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QC_TYPE_SPEC MODIFY SPEC_REF CHAR(15)  
ALTER TABLE CONSTDEMONEW.QC_XFR_CTRL MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QC_XFR_CTRL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QLTY_SPECS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.QLTY_SPECS ADD TEST_CODE VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.QLTY_SPECS ADD TREND_ANAL CHAR(1)  
ALTER TABLE CONSTDEMONEW.QUALIFICATION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RCPDET ADD SALE_ORDER CHAR(10)  
ALTER TABLE CONSTDEMONEW.RCPDISHNR MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RCPDISHNR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RCP_IBCA MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RCP_IBCA MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RCP_IBCA_DET MODIFY CCTR_CODE CHAR(4) NULL 
ALTER TABLE CONSTDEMONEW.RECEIPT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RECEIPT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RECEIPT_BACKFLUSH MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RECEIPT_BACKFLUSH MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RECEIPT_BACKFLUSH ADD EMP_CODE__CHEKR CHAR(10)  
ALTER TABLE CONSTDEMONEW.RECEIPT_BACKFLUSH ADD RATING CHAR(1)  
ALTER TABLE CONSTDEMONEW.RECEIPT_BACKFLUSH_DET ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.RECEIPT_BCR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RECEIPT_FORM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RECEIPT_PAY_IN_SLIP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RECEIVABLES_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RECRSL MODIFY CAND_FNAME VARCHAR2(15) NULL 
ALTER TABLE CONSTDEMONEW.RECRSL MODIFY CAND_LNAME VARCHAR2(15) NULL 
ALTER TABLE CONSTDEMONEW.RECRSL MODIFY CAND_MNAME VARCHAR2(15) NULL 
ALTER TABLE CONSTDEMONEW.RECRSL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.REC_PAY_TRF MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.REFSEQ MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.REG_REQUIREMENTS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RELA_PARTY_APPL MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RELA_PARTY_APPL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RELA_PARTY_HDR MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RELA_PARTY_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.REL_PARTY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.REPL_DLV_SCH MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.REPL_DLV_SCH_DET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.REPL_ISS_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.REPL_ORD_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.REPORT_LOG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.REP_SPECIFIC_AD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RESOURCE MODIFY CHG_USER VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.RESOURCE_BASIS MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RESOURCE_BASIS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RESOURCE_CONS MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RESOURCE_CONS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RESTR_PRC_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RESTR_TMPL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RETAILER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RETAILER_DOCTOR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RETAILER_SERIES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RETAIL_BRAND MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RETAINER_CONTRACT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RETAINER_CONTRACT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RE_STRUC_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.RG23API MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ROADPERMIT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ROADPERMIT ADD COUNTRY_NAME VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.ROADPERMIT_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ROLE_PROFILE MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ROLE_PROFILE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ROLE_SPEC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ROUTE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.ROUTE_DEACTIVATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SAFETY_NORM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALESFORECAST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALESFORECAST_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALES_ACTIVITY MODIFY CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.SALES_ACTIVITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALES_BUDGET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALES_BUDGET_CUST MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALES_BUDGET_CUST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALES_COMM_DET ADD ANAL_CODE CHAR(5)  
ALTER TABLE CONSTDEMONEW.SALES_COMM_DET ADD DEDUCT_TDS CHAR(1)  
ALTER TABLE CONSTDEMONEW.SALES_COMM_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALES_LC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALES_ORDERTYPE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALES_PERS MODIFY ACCT_CODE__AP CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.SALES_PERS MODIFY ACCT_CODE__AP_ADV CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.SALES_PERS MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALES_PERS MODIFY CCTR_CODE__AP CHAR(4) NULL 
ALTER TABLE CONSTDEMONEW.SALES_PERS MODIFY CCTR_CODE__AP_ADV CHAR(4) NULL 
ALTER TABLE CONSTDEMONEW.SALES_PERS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALES_PERS MODIFY CONTACT_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.SALES_PERS MODIFY CR_TERM CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.SALES_PERS_BANK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALES_PROD_GRP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALES_QUOT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALES_QUOT MODIFY ITEM_SER CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.SALES_QUOTDET ADD FROM_DATE DATE  
ALTER TABLE CONSTDEMONEW.SALES_QUOTDET ADD TO_DATE DATE  
ALTER TABLE CONSTDEMONEW.SALES_QUOT_AMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALES_QUOT_AMD_ITEM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALES_STAGE MODIFY CHG_DATE DATE NULL 
ALTER TABLE CONSTDEMONEW.SALES_STAGE MODIFY CHG_TERM VARCHAR2(15) NULL 
ALTER TABLE CONSTDEMONEW.SALES_STAGE MODIFY CHG_USER CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.SALES_STAGE MODIFY DESCR VARCHAR2(60)  
ALTER TABLE CONSTDEMONEW.SALES_TEAM MODIFY CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.SALES_TEAM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALES_TEAM MODIFY SALES_PERS_LEAD CHAR(10)  
ALTER TABLE CONSTDEMONEW.SALES_TEAM MODIFY SALES_TEAM CHAR(10)  
ALTER TABLE CONSTDEMONEW.SALES_TEAM_MEMBER MODIFY CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.SALES_TEAM_MEMBER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALES_TEAM_MEMBER MODIFY SALES_PERS CHAR(10)  
ALTER TABLE CONSTDEMONEW.SALES_TEAM_MEMBER MODIFY SALES_TEAM CHAR(10)  
ALTER TABLE CONSTDEMONEW.SALES_USP MODIFY CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.SALES_USP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALE_DIST_JV MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALE_TERM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SALE_TERM_TABLE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SAL_CANCLE_DTLS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SAL_ENQ_DTL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SAL_ENQ_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SAL_TFR_DTLS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SAMPLE_DIST_TEMPL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SAMPLE_INVTRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SAMPLE_ISS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SAMPLE_RCP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SAMPLE_STOCK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SCHEMEVALUE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SCHEME_APPLICABILITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SCHEME_APPRV MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SCHEME_BALANCE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SCHEME_DEF_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SCHEME_DEF_HDR MODIFY CUST_CODE VARCHAR2(500)  
ALTER TABLE CONSTDEMONEW.SCHEME_DEF_HDR ADD ORDER_TYPE VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.SCHEME_DEF_HDR ADD SCHEME_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.SCHEME_DEF_HDR ADD SITE_CRITERIA CHAR(1)  
ALTER TABLE CONSTDEMONEW.SCHEME_DISCOUNT_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SCHEME_HISTORY MODIFY CHG_DATE DATE NULL 
ALTER TABLE CONSTDEMONEW.SCHEME_HISTORY MODIFY CHG_TERM VARCHAR2(15) NULL 
ALTER TABLE CONSTDEMONEW.SCHEME_HISTORY MODIFY CHG_USER CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.SCHEME_HISTORY ADD CUST_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.SCHEME_HISTORY ADD DOC_KEY VARCHAR2(60)  
ALTER TABLE CONSTDEMONEW.SCHEME_HISTORY ADD INVOICE_DATE DATE  
ALTER TABLE CONSTDEMONEW.SCHEME_HISTORY ADD INVOICE_ID CHAR(10)  
ALTER TABLE CONSTDEMONEW.SCHEME_HISTORY MODIFY ITEM_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.SCHEME_HISTORY MODIFY LOT_NO CHAR(15) NULL 
ALTER TABLE CONSTDEMONEW.SCHEME_HISTORY MODIFY SITE_CODE CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.SCHEME_MASTER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SCH_GROUP_DEF MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SCH_GROUP_DEF MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SCONTACT_CUST MODIFY DRUG_LIC_NO CHAR(30)  
ALTER TABLE CONSTDEMONEW.SCONTRACT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SCONTRACT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SCONTRACTAMD MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SCONTRACTAMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SCONTRACTAMDDET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SCONTRACTDET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SCOPE_TYPE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SCOPE_TYPE MODIFY SCOPE_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.SEPARATION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SEPARATION_CLOSE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SERVICE_COMPLAINT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SERVICE_COMPLAINT MODIFY CUST_CONTACT VARCHAR2(60)  
ALTER TABLE CONSTDEMONEW.SERVICE_COMPLAINT MODIFY MODULE_CODE CHAR(3) NULL 
ALTER TABLE CONSTDEMONEW.SERVICE_COMPLAINT ADD SER_REQUEST_ID CHAR(10)  
ALTER TABLE CONSTDEMONEW.SERVICE_COMPLAINT MODIFY SUBMITTED_BY CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.SER_BILL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SER_COMPLAINT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SER_COMPLAINT_FB MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SER_COMPL_ASSIGN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SER_COMPL_ASSIGN ADD CONSIDER_ITEMSER CHAR(1)  
ALTER TABLE CONSTDEMONEW.SER_COMP_ANS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SER_COMP_MST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SER_COMP_RES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SER_COMP_TYPE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SER_CONTRACT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SER_EXPENCES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SER_REQUEST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SER_REQUEST MODIFY CUST_CONTACT VARCHAR2(60)  
ALTER TABLE CONSTDEMONEW.SER_REQUEST ADD SERIAL_NO CHAR(15)  
ALTER TABLE CONSTDEMONEW.SER_REQ_ACT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SER_REQ_FEEDBK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SER_REQ_FEEDBK_ITEM MODIFY UDF_STR1 VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.SER_REQ_FEEDBK_ITEM MODIFY UDF_STR2 VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.SER_REQ_FEEDBK_ITEM MODIFY UDF_STR3 VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.SER_REQ_FEEDBK_ITEM MODIFY UDF_STR5 VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.SER_REQ_TYP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SER_REQ_TYP ADD DOC_TYPE VARCHAR2(30)  
ALTER TABLE CONSTDEMONEW.SER_REQ_TYP ADD FILE_TYPE VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.SER_REQ_TYP ADD IS_SERIAL_NO_REQ CHAR(1)  
ALTER TABLE CONSTDEMONEW.SER_REQ_TYP ADD ROLE_CODE__ASSIGN CHAR(10)  
ALTER TABLE CONSTDEMONEW.SER_SCHDL_TIME MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SESS_PLAN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SFAPARM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SF_PLAN_PARAM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SHIFT_PATTERN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SHIFT_PATTERN ADD SHIFT_PATTEN VARCHAR2(100)  
ALTER TABLE CONSTDEMONEW.SHIPMENT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SHIPMENT ADD SHIP_END_DATE DATE  
ALTER TABLE CONSTDEMONEW.SHIPMENT ADD SHIP_START_DATE DATE  
ALTER TABLE CONSTDEMONEW.SHIPMENT_CHGS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SHIP_DOC_HRD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SHIP_DOC_LIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SHIP_TRACK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE ADD DIV_ID__OLD VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.SITEITEM ADD ASCERTAIN_ATTENDANCE CHAR(1)  
ALTER TABLE CONSTDEMONEW.SITEITEM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITEITEM ADD COA_FORMAT VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.SITEITEM MODIFY QC_REQD CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.SITEITEM ADD SAMPLING_PROC CHAR(1)  
ALTER TABLE CONSTDEMONEW.SITEITEMREGNO MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITEITEM_PUR_LMT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITEITEM_PUR_LMT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITEREGNO MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_ACCOUNT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_BANK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_CCTR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_CUSTOMER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_CUSTOMER MODIFY CURR_CODE__FRT CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.SITE_CUSTOMER MODIFY CURR_CODE__INS CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.SITE_DEPT__HOD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_ENV MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_HOLTBL_MAP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_ITDECL_APRVR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_LOANPARTY MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_LOANPARTY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_REPL_PREF MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_REPL_PREF MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_SALES_PERS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_SPEC_REPORT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_STAN_PAYTBL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_STRG_CUSTOMER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_SUPPLIER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_TAX_AUTHORITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SITE_TRANSPORTER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SMSPARAM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SMS_FORMAT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SMS_INTERCEPT_MTH MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SMS_INTERCEPT_MTH MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SMS_LOG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SOC_CALENDAR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SOD_RISK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SOD_RULE_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SORDAMD MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SORDAMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SORDAMDDET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SORDAMDDET ADD FROM_DATE DATE  
ALTER TABLE CONSTDEMONEW.SORDAMDDET ADD TO_DATE DATE  
ALTER TABLE CONSTDEMONEW.SORDDET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SORDDET ADD CUST_SPEC__NO_O VARCHAR2(25)  
ALTER TABLE CONSTDEMONEW.SORDDET ADD FROM_DATE DATE  
ALTER TABLE CONSTDEMONEW.SORDDET ADD FULLFILL_METHOD CHAR(3)  
ALTER TABLE CONSTDEMONEW.SORDDET ADD PRD_CODE_RFC CHAR(6)  
ALTER TABLE CONSTDEMONEW.SORDDET ADD PROM_DATE DATE  
ALTER TABLE CONSTDEMONEW.SORDDET ADD REF_NO_GCGV VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.SORDDET ADD TO_DATE DATE  
ALTER TABLE CONSTDEMONEW.SORDER MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SORDER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SORDER ADD FROM_DATE DATE  
ALTER TABLE CONSTDEMONEW.SORDER MODIFY ORDER_TYPE VARCHAR2(3) NULL 
ALTER TABLE CONSTDEMONEW.SORDER MODIFY PL_DATE DATE NULL 
ALTER TABLE CONSTDEMONEW.SORDER MODIFY TAX_DATE DATE NULL 
ALTER TABLE CONSTDEMONEW.SORDER ADD TO_DATE DATE  
ALTER TABLE CONSTDEMONEW.SORDER_CLOSE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SORDER_CLOSE MODIFY CHG_USER CHAR(14)  
ALTER TABLE CONSTDEMONEW.SORDER_STAT_LOG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SORDER_TEMP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SORDFORM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SORDFORM MODIFY STATUS CHAR(10)  
ALTER TABLE CONSTDEMONEW.SORDFORMDET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SORD_ALLOC MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SORD_ALLOC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SORD_CR_TERMS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SORD_TERM_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SO_TERM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SO_TERM_TBL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPECIALITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPECIALITY_SERIES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPECIFICATION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPEC_CODES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPLITSTOCK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPLITSTOCK_RCP MODIFY LOT_SL__ORG CHAR(15)  
ALTER TABLE CONSTDEMONEW.SPL_SALES_POR_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPRS_ACTIVITY MODIFY ACTIVITY_CODE CHAR(12)  
ALTER TABLE CONSTDEMONEW.SPRS_ACTIVITY ADD DCR_ID CHAR(10)  
ALTER TABLE CONSTDEMONEW.SPRS_ACTIVITY ADD EVENT_DATE DATE  
ALTER TABLE CONSTDEMONEW.SPRS_ACTIVITY ADD REMARK VARCHAR2(160)  
ALTER TABLE CONSTDEMONEW.SPRS_ACTIVITY ADD VISIT_TIME_FR VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.SPRS_ACTIVITY ADD VISIT_TIME_TO VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.SPRS_ACT_TRAN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPRS_ACT_TRAN ADD ROUTE_DESCR__START VARCHAR2(60)  
ALTER TABLE CONSTDEMONEW.SPRS_ACT_TRAN MODIFY SPRS_CODE__WW VARCHAR2(100)  
ALTER TABLE CONSTDEMONEW.SPRS_ACT_TRAN ADD SUBMISSION_DATE DATE  
ALTER TABLE CONSTDEMONEW.SPRS_ACT_TRAN ADD USE_SUB_DATA CHAR(1)  
ALTER TABLE CONSTDEMONEW.SPRS_CHEMIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPRS_INV_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPRS_ITEM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPRS_ITEM MODIFY STATUS CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.SPRS_PLAN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPRS_PLAN MODIFY SHORT_ID CHAR(5)  
ALTER TABLE CONSTDEMONEW.SPRS_PLAN_FROZEN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPRS_PLAN_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPRS_PLAN_PLACE ADD CUSTOMER_SELECTION CHAR(1)  
ALTER TABLE CONSTDEMONEW.SPRS_RETAILER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPRS_ROUTE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPRS_ROUTE ADD INVOICE_SR_NO CHAR(10)  
ALTER TABLE CONSTDEMONEW.SPRS_ROUTE MODIFY LOCALITY_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.SPRS_ROUTE ADD PLAN_DAYS VARCHAR2(200)  
ALTER TABLE CONSTDEMONEW.SPRS_ROUTE ADD REMARKS VARCHAR2(100)  
ALTER TABLE CONSTDEMONEW.SPRS_ROUTE ADD ROUTE_PATH VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.SPRS_ROUTE MODIFY STATUS CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.SPRS_STOCKIST ADD CATEGORY CHAR(5)  
ALTER TABLE CONSTDEMONEW.SPRS_STOCKIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPRS_TOUR_PLAN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPRS_TOUR_PLAN MODIFY POS_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.SPRS_TOUR_PLANDET ADD ROUTE_TYPE CHAR(1)  
ALTER TABLE CONSTDEMONEW.SPRS_TRAVEL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SPRS_TRAVEL ADD ROUTE_TYPE CHAR(1)  
ALTER TABLE CONSTDEMONEW.SQL_CHANGES ADD APPL_DB CHAR(1)  
ALTER TABLE CONSTDEMONEW.SQL_CHANGES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SQL_CHANGES ADD CONFIRMED CHAR(1)  
ALTER TABLE CONSTDEMONEW.SQL_CHANGES ADD CONF_DATE DATE  
ALTER TABLE CONSTDEMONEW.SQL_CHANGES ADD EMP_CODE_APRV CHAR(10)  
ALTER TABLE CONSTDEMONEW.SQL_CHANGES ADD ENTERPRISES VARCHAR2(100)  
ALTER TABLE CONSTDEMONEW.SQL_CHANGES MODIFY ITM_VER CHAR(5)  
ALTER TABLE CONSTDEMONEW.SRETAMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SRETURN MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SRETURN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SRETURNDET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SRETURNDET MODIFY REAS_CODE CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.SRETURN_AMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SRETURN_FORM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SRETURN_FORM_DET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SRETURN_NORMS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SRETURN_REASON MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SRL_CONTAINER MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SRL_CONTAINER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SRV_ORDER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SSCBARCODE_TRAN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STANTYPE MODIFY CHG_TERM CHAR(15)  
ALTER TABLE CONSTDEMONEW.STAN_COST_ANAL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STAN_TYPE_MST MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STAN_TYPE_MST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STATUTORY_FILING MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STATUTORY_OBJS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STATUTORY_STAT_UPD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STATU_LIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STATU_LIST_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STD_ALL_OBJECTS MODIFY OBJECT_NAME VARCHAR2(30)  
ALTER TABLE CONSTDEMONEW.STD_ALL_OBJECTS MODIFY OBJECT_TYPE VARCHAR2(19)  
ALTER TABLE CONSTDEMONEW.STD_ALL_OBJECTS MODIFY OWNER VARCHAR2(30)  
ALTER TABLE CONSTDEMONEW.STD_COMPLAINTS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STD_PAYSTRU MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STD_TAB_COLUMNS MODIFY COLUMN_NAME VARCHAR2(30)  
ALTER TABLE CONSTDEMONEW.STD_TAB_COLUMNS MODIFY DATA_TYPE VARCHAR2(106)  
ALTER TABLE CONSTDEMONEW.STD_TAB_COLUMNS MODIFY OWNER VARCHAR2(30)  
ALTER TABLE CONSTDEMONEW.STD_TAB_COLUMNS MODIFY TABLE_NAME VARCHAR2(30)  
ALTER TABLE CONSTDEMONEW.STK_WEIGHING MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STN_AMD MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STN_AMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STN_AMD ADD LOGIN_SITE CHAR(5)  
ALTER TABLE CONSTDEMONEW.STOCK ADD ACCT_CODE_INV CHAR(10)  
ALTER TABLE CONSTDEMONEW.STOCK ADD CCTR_CODE_INV CHAR(4)  
ALTER TABLE CONSTDEMONEW.STOCK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STOCK ADD COND_REL CHAR(1)  
ALTER TABLE CONSTDEMONEW.STOCK_AMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STOCK_AMD ADD LOGIN_SITE CHAR(5)  
ALTER TABLE CONSTDEMONEW.STOCK_DIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STOCK_EXTRA MODIFY CHG_TERM CHAR(15)  
ALTER TABLE CONSTDEMONEW.STOCK_SUMMARY MODIFY INV_STAT CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.STOCK_TRANSFER ADD BOM_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.STOCK_TRANSFER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STOCK_TRANSFER ADD CONSISTANCY_CHK CHAR(1)  
ALTER TABLE CONSTDEMONEW.STOCK_TRANSFER ADD ITEM_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.STOCK_TRANSFER ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.STOCK_VAL_ADJ MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STOCK_VAL_ADJ_DET ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.STOPPAGES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRGCUST_DEACTIVE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRGCUST_UPLOAD ADD CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.STRGCUST_UPLOAD ADD CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRGCUST_UPLOAD ADD CHG_USER CHAR(10)  
ALTER TABLE CONSTDEMONEW.STRG_BRAND_ACT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_CLASS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_CONTACT MODIFY BIRTH_DATE DATE  
ALTER TABLE CONSTDEMONEW.STRG_CONTACT MODIFY CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.STRG_CONTACT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_CUSTOMER MODIFY ADDRESS_AS NVARCHAR2(150) NULL 
ALTER TABLE CONSTDEMONEW.STRG_CUSTOMER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_CUSTOMER ADD CONTACT_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.STRG_CUSTOMER ADD DLV_GEO_POS VARCHAR2(60)  
ALTER TABLE CONSTDEMONEW.STRG_CUSTOMER ADD EMAIL_NOTIFY CHAR(1)  
ALTER TABLE CONSTDEMONEW.STRG_CUSTOMER ADD PRICE_LIST__DISC CHAR(5)  
ALTER TABLE CONSTDEMONEW.STRG_CUSTOMER ADD PRICE_LIST__PAYDIS CHAR(5)  
ALTER TABLE CONSTDEMONEW.STRG_CUSTOMER ADD SALES_TYPE CHAR(1)  
ALTER TABLE CONSTDEMONEW.STRG_CUSTOMER ADD SURVEY_TEMPL CHAR(10)  
ALTER TABLE CONSTDEMONEW.STRG_CUSTOMER_AMD MODIFY ADDRESS_AS VARCHAR2(25)  
ALTER TABLE CONSTDEMONEW.STRG_CUSTOMER_AMD MODIFY CHG_TERM CHAR(15)  
ALTER TABLE CONSTDEMONEW.STRG_CUSTOMER_RETAIL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_CUST_ADD MODIFY ADDRESS_AS VARCHAR2(25) NULL 
ALTER TABLE CONSTDEMONEW.STRG_CUST_ADD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_CUST_ADD ADD CONTACT_PERS CHAR(20)  
ALTER TABLE CONSTDEMONEW.STRG_CUST_ADD ADD CONTACT_PERS_NAME VARCHAR2(60)  
ALTER TABLE CONSTDEMONEW.STRG_CUST_ADD MODIFY GENDER CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.STRG_CUST_ADD ADD QUALIFICATION VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.STRG_CUST_ADD ADD REG_NO VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.STRG_CUST_ADD ADD STRG_EVENT_INFO VARCHAR2(250)  
ALTER TABLE CONSTDEMONEW.STRG_CUST_ADD MODIFY STRG_NAME VARCHAR2(77)  
ALTER TABLE CONSTDEMONEW.STRG_CUST_BANK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_CUST_CLASS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_CUST_TYPE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_CUST_TYPE ADD SURVEY_OPT CHAR(1)  
ALTER TABLE CONSTDEMONEW.STRG_CUST_TYPE ADD SURVEY_TEMPL CHAR(10)  
ALTER TABLE CONSTDEMONEW.STRG_EVENT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_EVENTS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_EVENTS MODIFY SEND_COMM CHAR(1) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.STRG_EVENT_EXE MODIFY CHG_TERM CHAR(15)  
ALTER TABLE CONSTDEMONEW.STRG_EVENT_EXE ADD REMARKS VARCHAR2(60)  
ALTER TABLE CONSTDEMONEW.STRG_EVENT_PLAN MODIFY CHG_TERM CHAR(15)  
ALTER TABLE CONSTDEMONEW.STRG_EVENT_PLAN MODIFY EVENT_TYPE CHAR(5)  
ALTER TABLE CONSTDEMONEW.STRG_EVENT_PLAN MODIFY VEN_COUNT_CODE CHAR(5)  
ALTER TABLE CONSTDEMONEW.STRG_EVENT_PLAN MODIFY VEN_STATE_CODE CHAR(5)  
ALTER TABLE CONSTDEMONEW.STRG_FAMILY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_INSTITUTE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_MEET MODIFY ADDRESS_AS NVARCHAR2(150)  
ALTER TABLE CONSTDEMONEW.STRG_MEET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_MEET ADD CONTACT_PERS CHAR(20)  
ALTER TABLE CONSTDEMONEW.STRG_MEET ADD CONTACT_PERS_NAME VARCHAR2(60)  
ALTER TABLE CONSTDEMONEW.STRG_MEET ADD CUST_CONF CHAR(1)  
ALTER TABLE CONSTDEMONEW.STRG_MEET ADD CUST_CONF_PROOF VARCHAR2(200)  
ALTER TABLE CONSTDEMONEW.STRG_MEET MODIFY EVENT_TIME_START VARCHAR2(10) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.STRG_MEET MODIFY GEO_POS_NAME VARCHAR2(300)  
ALTER TABLE CONSTDEMONEW.STRG_MEET ADD NEXT_PLAN_DATE DATE  
ALTER TABLE CONSTDEMONEW.STRG_MEET ADD PAY_MODE CHAR(1)  
ALTER TABLE CONSTDEMONEW.STRG_MEET ADD PLAN_CHG_REAS VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.STRG_MEET ADD PRICE_LIST CHAR(5)  
ALTER TABLE CONSTDEMONEW.STRG_MEET ADD PRICE_LIST__DISC CHAR(5)  
ALTER TABLE CONSTDEMONEW.STRG_MEET ADD PRICE_LIST__PAYDIS CHAR(5)  
ALTER TABLE CONSTDEMONEW.STRG_MEET ADD QUALIFICATION VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.STRG_MEET ADD REG_NO VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.STRG_MEET ADD SALES_TYPE CHAR(1)  
ALTER TABLE CONSTDEMONEW.STRG_MEET MODIFY SHORT_ID CHAR(5)  
ALTER TABLE CONSTDEMONEW.STRG_MEET ADD STRG_EVENT_INFO VARCHAR2(250)  
ALTER TABLE CONSTDEMONEW.STRG_MEET MODIFY STRG_NAME VARCHAR2(77)  
ALTER TABLE CONSTDEMONEW.STRG_MEET ADD SURVEY_TEMPL CHAR(10)  
ALTER TABLE CONSTDEMONEW.STRG_MEET ADD TAG_GEOPOS VARCHAR2(50)  
ALTER TABLE CONSTDEMONEW.STRG_MEET ADD TAG_GEOPOS_ADDR VARCHAR2(250)  
ALTER TABLE CONSTDEMONEW.STRG_MEET_ORDER ADD FOCUS_DEVI_REAS VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.STRG_MEET_ORDER ADD REMARKS_ORD VARCHAR2(100)  
ALTER TABLE CONSTDEMONEW.STRG_MEET_ORDER ADD SPECIFIC_INSTR VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.STRG_MEET_TEAM ADD MEMBER_NAME VARCHAR2(60)  
ALTER TABLE CONSTDEMONEW.STRG_MEET_TEAM ADD MEMBER_TYPE CHAR(1)  
ALTER TABLE CONSTDEMONEW.STRG_MEET_TEAM ADD MEM_CODE CHAR(20)  
ALTER TABLE CONSTDEMONEW.STRG_MEET_TEAM ADD TEAM_MOBILE_NO VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_MEMBERSHIP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_ORG MODIFY ADDED_DATE DATE  
ALTER TABLE CONSTDEMONEW.STRG_ORG MODIFY CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.STRG_ORG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_ORG MODIFY DEACT_DATE DATE  
ALTER TABLE CONSTDEMONEW.STRG_ORG_PRODUCT MODIFY CHG_DATE DATE  
ALTER TABLE CONSTDEMONEW.STRG_ORG_PRODUCT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_PREF_SELL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_PRODUCT MODIFY BRAND_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.STRG_PRODUCT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_PRODUCT ADD LAST_ORDER_DATE DATE  
ALTER TABLE CONSTDEMONEW.STRG_PRODUCT ADD PRODUCT_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.STRG_PRODUCT MODIFY VALID_FROM DATE NULL 
ALTER TABLE CONSTDEMONEW.STRG_PRODUCT MODIFY VALID_TO DATE NULL 
ALTER TABLE CONSTDEMONEW.STRG_QUALIFICATION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_SERIES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_SERIES ADD LAST_MEET_DATE DATE  
ALTER TABLE CONSTDEMONEW.STRG_SERIES ADD LAST_MEET_SUMM VARCHAR2(160)  
ALTER TABLE CONSTDEMONEW.STRG_SERIES ADD LAST_ORDER_DATE DATE  
ALTER TABLE CONSTDEMONEW.STRG_SERIES ADD LOCALITY_CODE__TO CHAR(10)  
ALTER TABLE CONSTDEMONEW.STRG_SERIES MODIFY STATUS CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.STRG_SERIES_DUP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_SER_CLASS ADD ACTIVE CHAR(1)  
ALTER TABLE CONSTDEMONEW.STRG_SER_CLASS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_SER_VISIT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_SER_VISIT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_SPECIALITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_SPON_REQ MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_STATUS_HIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_SURV_RES ADD DOC_ID VARCHAR2(200)  
ALTER TABLE CONSTDEMONEW.STRG_SURV_RES ADD SURV_STATUS CHAR(1)  
ALTER TABLE CONSTDEMONEW.STRG_VISIT_HOURS MODIFY ADDR1 VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.STRG_VISIT_HOURS MODIFY ADDR2 VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.STRG_VISIT_HOURS ADD AVAIL_ON_DAY VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.STRG_VISIT_HOURS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.STRG_VISIT_HOURS ADD CITY VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.STRG_VISIT_HOURS MODIFY FROM_TIME DATE NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.STRG_VISIT_HOURS ADD GEO_POS VARCHAR2(60)  
ALTER TABLE CONSTDEMONEW.STRG_VISIT_HOURS ADD STATE VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.STRG_VISIT_HOURS ADD STATE_CODE CHAR(5)  
ALTER TABLE CONSTDEMONEW.STRG_VISIT_HOURS ADD STATUS CHAR(1)  
ALTER TABLE CONSTDEMONEW.STRG_VISIT_HOURS MODIFY TO_TIME DATE NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.STRG_VISIT_HOURS MODIFY VISIT_PLACE VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.SUBCONGOODMATERIAL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SUBMIT_SRETURN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SUBMIT_SRETURNDET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SUB_BU_MASTER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SUB_BU_VALIDITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SUNDRYBAL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SUNDRYBAL_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SUNDRY_BANK_DETAILS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SUPPLIER MODIFY CONTACT_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.SUPPLIER MODIFY CR_TERM CHAR(5) NULL 
ALTER TABLE CONSTDEMONEW.SUPPLIERITEM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SUPPLIER_BANK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SUPPLIER_BILL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SUPPLIER_DEFAULT ADD SUPP_CODE__PAY CHAR(10)  
ALTER TABLE CONSTDEMONEW.SUPPLY_SITES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SUPP_APPRV MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SUPP_APPRV_DOC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SUPP_APPRV_ITEM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SUPP_APPRV_SITE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SUPP_BANK_DEACTIVE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SUPP_EVAL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SURVEYOR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SURVEY_FORM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SURVEY_GROUP ADD ADDL_GROUP VARCHAR2(40)  
ALTER TABLE CONSTDEMONEW.SURVEY_GROUP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SURVEY_GROUP ADD CONF_TYPE CHAR(1)  
ALTER TABLE CONSTDEMONEW.SURVEY_MASTER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SURVEY_MASTER ADD CORRECT_ANS VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.SURVEY_TEMPLATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.SURVEY_TEMPLATE ADD CONF_TYPE CHAR(1)  
ALTER TABLE CONSTDEMONEW.SYNC_TRANS_LOG MODIFY REF_ID VARCHAR2(60)  
ALTER TABLE CONSTDEMONEW.SYSBASE_MSG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TAG_TRANS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TASK ADD TASK_DOMAIN CHAR(5)  
ALTER TABLE CONSTDEMONEW.TAXTRAN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TAX_AUTHORITY MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TAX_AUTHORITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TAX_BALANCE_GRP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TAX_DEFERMENT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TAX_FORM_INFO MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TAX_ITEM_STAN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TAX_OTH_CREDITS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TAX_PROCESSED MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TAX_PROCESS_BAL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TAX_PROCESS_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TDESKBOOK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TDESK_CANCEL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TDESK_RATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TDESK_RATEAMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TDESK_RATE_GRP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TECH_SPECS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TERRITORY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TEST11 MODIFY NAME CHAR(10) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.TNC_ACCEPT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TNC_DOC_MST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TNT_TRAN_HIST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TNT_TRAN_INFO MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TOOL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TOOLDET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TOOLITEM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TOOLUSAGE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TOUR ADD ADD_DATE DATE  
ALTER TABLE CONSTDEMONEW.TOUR ADD ADD_TERM CHAR(15)  
ALTER TABLE CONSTDEMONEW.TOUR ADD ADD_USER CHAR(10)  
ALTER TABLE CONSTDEMONEW.TOUR ADD BILL_DATE DATE  
ALTER TABLE CONSTDEMONEW.TOUR ADD CCTR_CODE CHAR(4)  
ALTER TABLE CONSTDEMONEW.TOUR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TOUR ADD EFF_DATE DATE  
ALTER TABLE CONSTDEMONEW.TOUR ADD ITEM_SER CHAR(5)  
ALTER TABLE CONSTDEMONEW.TOUR ADD SITE_CODE CHAR(5)  
ALTER TABLE CONSTDEMONEW.TOUR ADD TOUR_DATE DATE  
ALTER TABLE CONSTDEMONEW.TOUR ADD TRANS_MODE CHAR(1)  
ALTER TABLE CONSTDEMONEW.TOURDET ADD EXCESS_VISIT_ALLOW CHAR(1)  
ALTER TABLE CONSTDEMONEW.TOUREXPDET ADD CLAIM_DATE_FROM DATE  
ALTER TABLE CONSTDEMONEW.TOUREXPDET ADD CLAIM_DATE_TO DATE  
ALTER TABLE CONSTDEMONEW.TOUREXPDET ADD PRD_FROM_DATE DATE  
ALTER TABLE CONSTDEMONEW.TOUREXPDET ADD PRD_TO_DATE DATE  
ALTER TABLE CONSTDEMONEW.TOUR_SUMMARY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRADE_PAR_PARM MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRAINDET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRAINEXEC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRAINING MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRANSACTION_CAT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRANSACTION_CAT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRANSPORTER MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRANSPORTER ADD BANK_REF VARCHAR2(60)  
ALTER TABLE CONSTDEMONEW.TRANSPORTER ADD BUSINESS VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.TRANSPORTER MODIFY CCTR_CODE__AP CHAR(10)  
ALTER TABLE CONSTDEMONEW.TRANSPORTER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRANSPORTER MODIFY CONTACT_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.TRANSPORTER_BANK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRANSPORTER_DEFAULT MODIFY TAX_ENV CHAR(10)  
ALTER TABLE CONSTDEMONEW.TRANSPORTER_MODE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRAN_DOC_OBJECTS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRAN_TRACK_ACTS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRAN_TRACK_SET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRAN_TRACK_STATUS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRAN_TRACK_UPDATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRAN_TYPE_MASTER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRAN_TYPE_MASTER ADD GRADE_APPL VARCHAR2(200)  
ALTER TABLE CONSTDEMONEW.TRAN_TYPE_MASTER MODIFY MOD_NAME CHAR(3) NULL 
ALTER TABLE CONSTDEMONEW.TRAVEL_MODE_MASTER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRAV_COUP_PURCH MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRAV_COUP_REQ MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRAV_COUP_UTLZ MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRAV_PROF MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TREQUEST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TREQUESTAMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TREQUEST_CANCEL_PRC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TREQUEST_GRP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TREQUEST_TICKET_CLOSE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRV_ALLOWANCE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRV_ALLOWANCE ADD PROP_ON CHAR(1)  
ALTER TABLE CONSTDEMONEW.TRV_ALLOW_BASIS MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRV_ALLOW_BASIS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRV_ALLOW_LMT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRV_DISTANCE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRV_FARE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.TRV_FARE ADD CONDT_BASIS CHAR(1)  
ALTER TABLE CONSTDEMONEW.TRV_FARE MODIFY GRADE_CODE CHAR(5) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.TRV_FARE MODIFY ITEM_SER CHAR(5) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.TRV_FARE ADD PROOF_REQ CHAR(1)  
ALTER TABLE CONSTDEMONEW.TRV_FARE MODIFY SITE_CODE CHAR(5) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.UDF_ACCTMETHOD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.UDF_ACCTPOST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.UNDO_REC_ADJ MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.UNDO_REC_ADJ MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.UOMTMP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.UPTIME_LOG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.URL_ACC_RIGHTS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.USERS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.USERS MODIFY TAG CHAR(1)  
ALTER TABLE CONSTDEMONEW.USERS MODIFY USER_CLASS VARCHAR2(5)  
ALTER TABLE CONSTDEMONEW.USER_DEDUCTIONHDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.USER_OBJ_FAV MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.USER_PRES MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.USER_PRES MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.USER_RIGHTS_ADHOC MODIFY CHG_TERM CHAR(15)  
ALTER TABLE CONSTDEMONEW.USER_RIGHTS_TRACE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.USER_SITE MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.USER_SITE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.USER_TAG_SETTING MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.VACAGENCY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.VEN_QUAL_HISTORY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.VERSION MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.VOUCHER MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.VOUCHER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.VOUCHRCP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WASHRCPHDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WAVE_STATUS_ORG MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WAVE_TASK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WF_ACTIONS_REASONS MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WF_ACTIONS_REASONS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WF_ACTIVITY MODIFY ACTIVITY_CODE VARCHAR2(20)  
ALTER TABLE CONSTDEMONEW.WF_ACTIVITY MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WF_ACTIVITY MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WF_AUDIT_DATA MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WF_CONTROL MODIFY REF_ID CHAR(20)  
ALTER TABLE CONSTDEMONEW.WF_CONTROL MODIFY REF_NO CHAR(20) NULL 
ALTER TABLE CONSTDEMONEW.WF_CONTROL MODIFY WIN_NAME CHAR(20) NULL 
ALTER TABLE CONSTDEMONEW.WF_DELIGATION_HIS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WF_OBJECT_ACTION MODIFY REF_ID CHAR(20) NULL 
ALTER TABLE CONSTDEMONEW.WF_OBJECT_ACTION MODIFY WIN_NAME CHAR(20) NULL 
ALTER TABLE CONSTDEMONEW.WF_PRC_ACT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WF_PRC_ACT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WF_ROLE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WF_ROLE_USERS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WF_ROLE_USERS_CTX MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WING_MST MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WING_MST MODIFY END_DATE DATE  
ALTER TABLE CONSTDEMONEW.WING_MST MODIFY PROJ_CODE CHAR(10) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.WING_MST MODIFY SITE_CODE CHAR(5) NOT NULL NOVALIDATE 
ALTER TABLE CONSTDEMONEW.WING_MST MODIFY START_DATE DATE  
ALTER TABLE CONSTDEMONEW.WING_MST MODIFY STATUS_DATE DATE  
ALTER TABLE CONSTDEMONEW.WIP_SCANNING_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WOI_LOTCHANGE_DET MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WOI_LOTCHANGE_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WOI_SCAN_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORDER_AMD MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORDER_AMD MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORDER_CAMPAIGN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORDER_ISS_RND MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORDER_MOVEMENT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORDER_ROUTE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORDER_ROUTE ADD EMP_CODE__PREF CHAR(10)  
ALTER TABLE CONSTDEMONEW.WORDER_ROUTE ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.WORDER_ROUTE_ALT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORDER_ROUTE_ALT MODIFY ITEM_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.WORDER_ROUTE_ALT MODIFY PROC_CODE CHAR(10) NULL 
ALTER TABLE CONSTDEMONEW.WORDER_UNDOFIRMPLAN MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORDER_UNDOFIRMPLAN ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.WORDER_WIPHOLDREL MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORDER_WIPHOLDREL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORKCNTR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORKCNTRSHFT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORKORDER MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORKORDER MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORKORDER_BILL MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORKORDER_BILL ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.WORKORDER_BILL MODIFY UNIT CHAR(3) NULL 
ALTER TABLE CONSTDEMONEW.WORKORDER_BILL MODIFY UNIT__REF CHAR(3) NULL 
ALTER TABLE CONSTDEMONEW.WORKORDER_BILL_CHANGE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORKORDER_BILL_CHANGE ADD REMARKS VARCHAR2(120)  
ALTER TABLE CONSTDEMONEW.WORKORDER_ENHANC MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORKORDER_ENHANC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORKORDER_FEEDBACK MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORKORDER_FEEDBACK MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORKORDER_FEEDBACK ADD GATE_REGISTER_ID VARCHAR2(10)  
ALTER TABLE CONSTDEMONEW.WORKORDER_FEEDBACK ADD REAS_IDLE_HOURS VARCHAR2(200)  
ALTER TABLE CONSTDEMONEW.WORKORDER_FEEDBACK ADD REMARKS VARCHAR2(300)  
ALTER TABLE CONSTDEMONEW.WORKORDER_FEEDBACK MODIFY TRAN_SER CHAR(6) NULL 
ALTER TABLE CONSTDEMONEW.WORKORDER_ISS MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORKORDER_ISS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORKORDER_ISS_REQ MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORKORDER_ISS_REQ MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORKORDER_RECEIPT MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORKORDER_RECEIPT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORKORDER_RECEIPT MODIFY LOT_SL CHAR(15) NULL 
ALTER TABLE CONSTDEMONEW.WORKORDER_RECEIPT MODIFY QC_REQD CHAR(1) NULL 
ALTER TABLE CONSTDEMONEW.WORKSHFT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORK_BALANCE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORK_CALENDAR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORK_LOCATIONS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORK_SHIFT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORK_TABLE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WORK_TEAM_HDR MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WO_CLOSE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WO_CLOSE MODIFY CHG_USER CHAR(15)  
ALTER TABLE CONSTDEMONEW.WO_CLOSE MODIFY EMP_CODE__APRV CHAR(15)  
ALTER TABLE CONSTDEMONEW.WO_CONTRACT MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WO_ISS_REQ_CANC MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WO_OBSRV_HDR MODIFY CHG_TERM CHAR(15)  
ALTER TABLE CONSTDEMONEW.WO_OBSRV_HDR ADD TEMPLATE_CODE CHAR(10)  
ALTER TABLE CONSTDEMONEW.WO_OBSRV_HDR ADD TRAN_ID__REF CHAR(10)  
ALTER TABLE CONSTDEMONEW.WO_OBSRV_STEP MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WO_TRACK_STATUS MODIFY ADD_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WO_TRACK_STATUS MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.WO_TRACK_UPDATE MODIFY CHG_TERM VARCHAR2(15)  
ALTER TABLE CONSTDEMONEW.YEARLY_RM_REQ MODIFY CHG_TERM VARCHAR2(15)  

-- No of Rows = 1960
