ALTER TABLE GI_USERGROUP ADD UG_SHELL_CODE VARCHAR(50) 
ALTER TABLE gi_users add USR_SHELL_USR_ID varchar(40) 
ALTER TABLE GL_PRODUCT DROP CONSTRAINT FK_GL_PRD_REF3
ALTER TABLE GL_PRODUCT DROP CONSTRAINT FK_GL_PRD_REF4
ALTER TABLE GL_PRODUCT DROP CONSTRAINT FK_GL_PRD_REF5
ALTER TABLE GL_PRODUCT DROP CONSTRAINT FK_USER120
ALTER TABLE GL_PRODUCT DROP CONSTRAINT FK_USER121
ALTER TABLE GL_PRODUCT DROP CONSTRAINT FK_USER122
ALTER TABLE GL_PRODUCT DROP CONSTRAINT FK_USER123
ALTER TABLE GL_PRODUCT DROP CONSTRAINT FK_USER186
ALTER TABLE GL_PRODUCT DROP CONSTRAINT FK_USER187
ALTER TABLE GL_PRODUCT DROP CONSTRAINT FK_USER188
ALTER TABLE GL_PRODUCT DROP CONSTRAINT FK_USER189
ALTER TABLE GL_PRODUCT DROP CONSTRAINT FK_USER57
ALTER TABLE GL_PROTECACC DROP CONSTRAINT FK_USER210
ALTER TABLE GL_RECEIPTS DROP CONSTRAINT FK_USER216
ALTER TABLE GL_SUPPLIER DROP CONSTRAINT FK_CEDACC
ALTER TABLE GL_SUPPLIER DROP CONSTRAINT FK_SALTAXACC
ALTER TABLE GL_SUPPLIER DROP CONSTRAINT FK_SUPPCOA_ACCCODE
ALTER TABLE GL_SUPPLIER DROP CONSTRAINT FK_USER114
ALTER TABLE GL_VCHRDETAIL DROP CONSTRAINT FK_USER129
ALTER TABLE PF_ADJUSTMENTDTL DROP CONSTRAINT FK_DTLGL
ALTER TABLE PF_ADJUSTMENTMST DROP CONSTRAINT FK_ADJMSTGL
ALTER TABLE PF_EMPLOYEE DROP CONSTRAINT FK_EMPCOA
ALTER TABLE PF_EMPLOYEE DROP CONSTRAINT FK_GLCOACC
ALTER TABLE PF_GROUP DROP CONSTRAINT FK_PF_GROUP_ACC
ALTER TABLE PF_GROUP DROP CONSTRAINT FK_PFGRP_DEBIT_CODE
ALTER TABLE PF_GROUP DROP CONSTRAINT FK_PFGRP_DEDUCT_CODE
ALTER TABLE PKG_CARRIAGECONT DROP CONSTRAINT FK_CARCOA
ALTER TABLE PKG_CHQMST DROP CONSTRAINT FK_CHQMST_COA_BANK
ALTER TABLE PKG_CHQMST DROP CONSTRAINT FK_CHQMST_COA_DRACC
ALTER TABLE PKG_CHQMST DROP CONSTRAINT FK_CHQMST_COA_WHT
ALTER TABLE PKG_CHQOTHERTR DROP CONSTRAINT FK_CHQOTHERTR_COA
ALTER TABLE PKG_COMMISSION_TYPES DROP CONSTRAINT FK_AC_CODE
ALTER TABLE PKG_DRCRNOTESUPDTL DROP CONSTRAINT FK_DRCR_SUPP_CHART
ALTER TABLE PKG_POSTDT_CHQ DROP CONSTRAINT FK_ACCOUNT_CODE
ALTER TABLE PKG_RCPTOTHERTR DROP CONSTRAINT FK_RCPTOTHERTR_COA
ALTER TABLE AP_PAYMENTDTL DROP CONSTRAINT FK_DTLWHTACCACP
ALTER TABLE AP_PAYMENTMST DROP CONSTRAINT FK_BANKACCACPMST
ALTER TABLE AP_PAYMENTMST DROP CONSTRAINT FK_WHTACCACPMST
ALTER TABLE AP_PAYOTHERTR DROP CONSTRAINT FK_PAYOTHERTR_COA
ALTER TABLE AR_RECPOTHERTR DROP CONSTRAINT FK_RECPOTHERTR_COA
ALTER TABLE GL_CHEQUES DROP CONSTRAINT FK_CHARTOFACC
ALTER TABLE GL_CHEQUES DROP CONSTRAINT FK_CHQCOA_STSPCODE
ALTER TABLE GL_CHEQUES DROP CONSTRAINT FK_USER154
ALTER TABLE GL_CUSTOMER DROP CONSTRAINT FK_USER119
ALTER TABLE GL_CUSTOMER DROP CONSTRAINT FK_USER167
ALTER TABLE GL_CUSTOMER DROP CONSTRAINT FK_USER180
ALTER TABLE GL_DFLTACCVCHR DROP CONSTRAINT FK_USER106
ALTER TABLE GL_KNOCKOFFOPEN DROP CONSTRAINT FK_USER211
ALTER TABLE GL_PCHALANDEATIL DROP CONSTRAINT FK_USER177
ALTER TABLE GL_PODETAIL DROP CONSTRAINT FK_USER209
ALTER TABLE GL_CUSTOMER DROP CONSTRAINT FK_USER116
ALTER TABLE GL_SUPP_WHT DROP CONSTRAINT FK_USER115
ALTER TABLE GL_SUPPLIER DROP CONSTRAINT FK_USER112
ALTER TABLE GL_BANKACC DROP CONSTRAINT FK_USER41
ALTER TABLE GL_PROTECACC DROP CONSTRAINT FK_USER103
ALTER TABLE PKG_DRCRNOTECUSTDTL DROP CONSTRAINT FK_DRCR_CUST_CHART
ALTER TABLE GL_COARELATIONS DROP CONSTRAINT FK_USER226
ALTER TABLE GL_RECEIPTS DROP CONSTRAINT FK_USER215
ALTER TABLE GL_CHARTOFACC DROP CONSTRAINT PKGL_CHARTOFACC
ALTER TABLE GL_CHARTOFACC ALTER COLUMN CA_ACC_CODE VARCHAR(30) NOT NULL
ALTER TABLE GL_CHARTOFACC ADD CA_SITE_CODE VARCHAR(4)
UPDATE GL_CHARTOFACC SET CA_SITE_CODE = '0001', CA_CO_CODE = '0001'
ALTER TABLE GL_CHARTOFACC ALTER COLUMN CA_SITE_CODE VARCHAR(4) NOT NULL;
ALTER TABLE GL_CHARTOFACC  ADD CONSTRAINT PKGL_CHARTOFACC PRIMARY KEY (CA_CO_CODE, CA_SITE_CODE, CA_ACC_CODE);
ALTER TABLE GL_COARELATIONS DROP CONSTRAINT FK_USER227
ALTER TABLE GL_SECDETAIL ALTER COLUMN SD_SECACC_CODE VARCHAR(30) NOT NULL
ALTER TABLE GL_COARELATIONS DROP CONSTRAINT PKGL_COARELATIONS
ALTER TABLE GL_COARELATIONS ALTER COLUMN CR_ACC_CODE VARCHAR(30) NOT NULL
ALTER TABLE GL_COARELATIONS ALTER COLUMN CR_SECACC_CODE VARCHAR(30) NOT NULL
ALTER TABLE GL_COARELATIONS ADD CR_SITE_CODE VARCHAR(4), CR_SECSITE_CODE VARCHAR(4)
UPDATE GL_COARELATIONS SET CR_SITE_CODE = '0001', CR_SECSITE_CODE = '0001'
ALTER TABLE GL_COARELATIONS ALTER COLUMN CR_SITE_CODE VARCHAR(4) NOT NULL
ALTER TABLE GL_COARELATIONS ALTER COLUMN CR_SECSITE_CODE VARCHAR(4) NOT NULL
ALTER TABLE GL_COARELATIONS ADD CONSTRAINT FK_USER227 FOREIGN KEY (CR_SECCOA_CODE,CR_SECACC_CODE) REFERENCES GL_SECDETAIL(SD_SECCOA_CODE,SD_SECACC_CODE)
ALTER TABLE GL_COARELATIONS ADD CONSTRAINT PKGL_COARELATIONS PRIMARY KEY (CR_CO_CODE, CR_SITE_CODE, CR_ACC_CODE, CR_SECCOA_CODE, CR_SECACC_CODE, CR_SECSITE_CODE);
ALTER TABLE GL_PARAMETERS ADD PAR_CO_CODE VARCHAR(4),PAR_SITE_CODE  VARCHAR(4),PAR_LVL23_SIZE DECIMAL(25,8),PAR_LVL24_SIZE DECIMAL(25,8),PAR_LVL25_SIZE DECIMAL(25,8),PAR_LVL26_SIZE DECIMAL(25,8),PAR_LVL27_SIZE DECIMAL(25,8),PAR_LVL28_SIZE DECIMAL(25,8),PAR_LVL29_SIZE DECIMAL(25,8),PAR_LVL30_SIZE DECIMAL(25,8),PAR_CC_LVL11SIZE DECIMAL(25,8),PAR_CC_LVL12SIZE DECIMAL(25,8),PAR_CC_LVL13SIZE DECIMAL(25,8),PAR_CC_LVL14SIZE DECIMAL(25,8),PAR_CC_LVL15SIZE DECIMAL(25,8),PAR_CC_LVL16SIZE DECIMAL(25,8),PAR_CC_LVL17SIZE DECIMAL(25,8),PAR_CC_LVL18SIZE DECIMAL(25,8),PAR_CC_LVL19SIZE DECIMAL(25,8),PAR_CC_LVL20SIZE DECIMAL(25,8)UPDATE GL_PARAMETERS SET PAR_SITE_CODE = '0001',PAR_CO_CODE = '0001'
ALTER TABLE GL_PARAMETERS ALTER COLUMN PAR_CO_CODE VARCHAR(4) NOT NULLALTER TABLE GL_PARAMETERS ALTER COLUMN PAR_SITE_CODE  VARCHAR(4) NOT NULL
ALTER TABLE PKG_PRODCHALLANDTL DROP CONSTRAINT FK_COSTCNTR
ALTER TABLE PKG_MINDTL DROP CONSTRAINT FK_PKG_MINDTL_COSTCNTR
ALTER TABLE PKG_CHQMST DROP CONSTRAINT FK_CHQMST_COSTCNTR_WHT
ALTER TABLE PKG_DRCRNOTECUST DROP CONSTRAINT FK_DRCRNOTE_COSTCNTR
ALTER TABLE AP_DRCRNOTE_MST DROP CONSTRAINT FK_APDRNOTE_CC
ALTER TABLE PKG_MRSDTL DROP CONSTRAINT FK_PKG_MRSDTL_COSTCNTR
ALTER TABLE PKG_CHQOTHERTR DROP CONSTRAINT FK_CHQOTHERTR_COSTCNTR
ALTER TABLE PKG_DRCRNOTECUSTDTL DROP CONSTRAINT FK_DRCRNOTEDTL_COSTCNTR
ALTER TABLE FA_ASSET DROP CONSTRAINT FK_ASSET_COSTCNTR
ALTER TABLE AP_DRCRNOTE_DTL DROP CONSTRAINT FK_APDRDTL_CC
ALTER TABLE PKG_DRCRNOTESUP DROP CONSTRAINT FK_DRCRNOTE_COSTCNTRSUPP
ALTER TABLE AR_DRCRNOTE_MST DROP CONSTRAINT FK_ARDRNOTE_CC
ALTER TABLE PKG_SANDTL DROP CONSTRAINT FK_PKG_SANDTL_COSTCNTR
ALTER TABLE GL_INVCDETAIL DROP CONSTRAINT FK_USER145
ALTER TABLE AP_PAYOTHERTR DROP CONSTRAINT FK_PAYOTHERTR_COSTCNTR
ALTER TABLE PKG_DRCRNOTESUPDTL DROP CONSTRAINT FK_DRCRNOTEDTL_COSTCNTRSUPP
ALTER TABLE GL_PODETAIL DROP CONSTRAINT FK_USER150
ALTER TABLE AR_DRCRNOTE_DTL DROP CONSTRAINT FK_ARDRDTL_CC
ALTER TABLE GL_CHEQUEDETAIL DROP CONSTRAINT FK_USER156
ALTER TABLE PKG_REQFRPURMST DROP CONSTRAINT FK_RQPURMST_CC
ALTER TABLE PKG_CUSTOMER DROP CONSTRAINT FK_COSTCNTR_CUST
ALTER TABLE AP_PAYMENTMST DROP CONSTRAINT FK_BNKCSTCNTR
ALTER TABLE AP_PAYMENTMST DROP CONSTRAINT FK_SUPPCSTCNTR
ALTER TABLE AP_PAYMENTMST DROP CONSTRAINT FK_WHTCSTAPMST
ALTER TABLE PKG_PURCHREQDTL DROP CONSTRAINT FK_PKG_PURCHREQDTL_CNTR
ALTER TABLE PKG_RCPTOTHERTR DROP CONSTRAINT FK_RCPTOTHERTR_COSTCNTR
ALTER TABLE PKG_PURCHORDERMST DROP CONSTRAINT FK_POMST_COSTCNTR
ALTER TABLE PKG_PURCHORDERDTL DROP CONSTRAINT FK_PODTL_COSTCNTR
ALTER TABLE PKG_DELCHALLANMST DROP CONSTRAINT FK_DELCHLNMST_COSTCNTR
ALTER TABLE PKG_GRNMST DROP CONSTRAINT FK_GRNMST_COSTCNTR
ALTER TABLE PKG_DELCHALLANDTL DROP CONSTRAINT FK_DELCHLNDTL_COSTCNTR
ALTER TABLE PKG_GRNDTL DROP CONSTRAINT FK_GRNDTL_COSTCNTR
ALTER TABLE PKG_INVMST DROP CONSTRAINT FK_INVMST_COSTCNTR
ALTER TABLE PKG_INVDTL DROP CONSTRAINT FK_INVDTL_COSTCNTR
ALTER TABLE PKG_BILLMST DROP CONSTRAINT FK_BILLMST_COSTCNTR
ALTER TABLE PKG_BILLDTL DROP CONSTRAINT FK_BILLDTL_COSTCNTR
ALTER TABLE ROPS_BILLMST DROP CONSTRAINT FK_GL_COSTCNTR_ROPS
ALTER TABLE ACR_INVMST DROP CONSTRAINT FK_ACR_GL_COSTCNTR
ALTER TABLE ROPS_BILLDTL DROP CONSTRAINT FK_GL_COSTC_RBILL
ALTER TABLE ROPS_INVMST DROP CONSTRAINT FK_ROPS_COSTCNTR
ALTER TABLE ACR_INVDTL DROP CONSTRAINT FK_ACRD_GL_COSTCNTR
ALTER TABLE PKG_PURCHRETMST DROP CONSTRAINT FK_PURCHRETMST_COSTCNTR
ALTER TABLE PKG_PURCHRETDTL DROP CONSTRAINT FK_PURCHRETDTL_COSTCNTR
ALTER TABLE AR_RECEIPTMST DROP CONSTRAINT FK_AR_COSTCNTR
ALTER TABLE PKG_SALESRTNMST DROP CONSTRAINT FK_SALESRTNMST_COSTCNTR
ALTER TABLE ROPS_INVDTL DROP CONSTRAINT FK_GL_COSTC_RINV
ALTER TABLE PKG_SALESRTNDTL DROP CONSTRAINT FK_SALESRTNDTL_COSTCNTR
ALTER TABLE PKG_RECEIPTMST DROP CONSTRAINT FK_RECEIPTMST_COSTCNTR
ALTER TABLE PKG_RECEIPTDTL DROP CONSTRAINT FK_RECEIPTDTL_COSTCNTR
ALTER TABLE FA_ASSET_TEMP DROP CONSTRAINT FK_ASSET_COSTCNTR1
ALTER TABLE AR_RECEIPTDTL DROP CONSTRAINT FK_AR_RECCOSTCNTR
ALTER TABLE AP_BILLMST DROP CONSTRAINT FK_AP_GL_COSTCNTR
ALTER TABLE AP_BILLDTL DROP CONSTRAINT FK_ACP_GL_COSTCNTR
ALTER TABLE AR_RECPOTHERTR DROP CONSTRAINT FK_RECPOTHERTR_COSTCNTR
ALTER TABLE PKG_DELIVORDERDTL DROP CONSTRAINT FK_PKG_DELIVORDDTL_COSTCNTR
ALTER TABLE PKG_QTPURCHDTL DROP CONSTRAINT FK_PKG_QTPURCHDTL_COSTCNTR
ALTER TABLE PKG_SALESORDERDTL DROP CONSTRAINT FK_PKG_SALESORDERDTL_COSTCNTR
ALTER TABLE PKG_SALESQTDTL DROP CONSTRAINT FK_PKG_SALESQTDTL_COSTCNTR
ALTER TABLE PKG_DEPARTMENT DROP CONSTRAINT FK_COSTCNTR_DEPT
ALTER TABLE PKG_MRNDTL DROP CONSTRAINT FK_PKG_MRNDTL_COSTCNTR
ALTER TABLE PKG_MRNMST DROP CONSTRAINT FK_COSTCNTR_CODE
ALTER TABLE PKG_CHQMST DROP CONSTRAINT FK_CHQMST_COSTCNTR_BANK
ALTER TABLE PKG_CHQMST DROP CONSTRAINT FK_CHQMST_COSTCNTR_SUPP
ALTER TABLE GL_VCHRDETAIL DROP CONSTRAINT FK_USER130
ALTER TABLE GL_COSTCNTR DROP CONSTRAINT PKGL_COSTCNTR
ALTER TABLE GL_COSTCNTR ALTER COLUMN CC_COSTCNTR_CODE VARCHAR(20) NOT NULL
ALTER TABLE GL_COSTCNTR ADD CC_SITE_CODE VARCHAR(4)
UPDATE GL_COSTCNTR SET 	CC_SITE_CODE = '0001',CC_CO_CODE = '0001'
ALTER TABLE GL_COSTCNTR ALTER COLUMN CC_SITE_CODE VARCHAR(4) NOT NULL;
ALTER TABLE GL_COSTCNTR ALTER COLUMN CC_CO_CODE VARCHAR(4) NOT NULL;
ALTER TABLE GL_COSTCNTR ADD CONSTRAINT PKGL_COSTCNTR PRIMARY KEY (CC_CO_CODE, CC_SITE_CODE, CC_COSTCNTR_CODE)
ALTER TABLE GL_VCHRTYPE ADD VT_SITE_CODE VARCHAR(4)
UPDATE GL_VCHRTYPE SET 	VT_SITE_CODE = '0001', 	VT_CO_CODE = '0001';

ALTER TABLE GL_VCHRTYPE ALTER COLUMN VT_SITE_CODE VARCHAR(4) NOT NULL


ALTER TABLE GL_PROTECACC ADD PA_SITE_CODE VARCHAR(4)

UPDATE GL_PROTECACC SET 	PA_SITE_CODE = '0001',	PA_CO_CODE = '0001'

ALTER TABLE GL_PROTECACC ALTER COLUMN PA_SITE_CODE VARCHAR(4) NOT NULL

ALTER TABLE GL_VCHRTYPEUSER ADD VTU_CO_CODE VARCHAR(4), VTU_SITE_CODE  VARCHAR(4)

UPDATE GL_VCHRTYPEUSER SET 	VTU_SITE_CODE = '0001', VTU_CO_CODE = '0001'

ALTER TABLE GL_VCHRTYPEUSER ALTER COLUMN VTU_CO_CODE VARCHAR(4) NOT NULL
 
ALTER TABLE GL_VCHRTYPEUSER ALTER COLUMN VTU_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE GL_VCHRPRNSETUP ADD VP_CO_CODE VARCHAR(4), VP_SITE_CODE  VARCHAR(4)

UPDATE GL_VCHRPRNSETUP SET 	VP_SITE_CODE = '0001', 	VP_CO_CODE = '0001'

ALTER TABLE GL_VCHRPRNSETUP ALTER COLUMN VP_CO_CODE VARCHAR(4) NOT NULL

ALTER TABLE GL_VCHRPRNSETUP ALTER COLUMN VP_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE GL_CURRRATE ADD CR_CO_CODE VARCHAR(4), CR_SITE_CODE  VARCHAR(4)

UPDATE GL_CURRRATE SET 	CR_SITE_CODE = '0001',	CR_CO_CODE = '0001'

ALTER TABLE GL_CURRRATE ALTER COLUMN CR_CO_CODE VARCHAR(4) NOT NULL
 
ALTER TABLE GL_CURRRATE ALTER COLUMN CR_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE GL_CURRPERIODWISE ADD CP_CO_CODE VARCHAR(4), CP_SITE_CODE  VARCHAR(4)

UPDATE GL_CURRPERIODWISE SET 	CP_SITE_CODE = '0001',CP_CO_CODE = '0001'

ALTER TABLE GL_CURRPERIODWISE ALTER COLUMN CP_CO_CODE VARCHAR(4) NOT NULL

ALTER TABLE GL_CURRPERIODWISE ALTER COLUMN CP_SITE_CODE  VARCHAR(4) NOT NULL 

ALTER TABLE GL_CURRDATEWISE ADD CD_CO_CODE VARCHAR(4),CD_SITE_CODE  VARCHAR(4)

UPDATE GL_CURRDATEWISE SET 	CD_SITE_CODE = '0001',	CD_CO_CODE = '0001'

ALTER TABLE GL_CURRDATEWISE ALTER COLUMN CD_CO_CODE VARCHAR(4) NOT NULL
 
ALTER TABLE GL_CURRDATEWISE ALTER COLUMN CD_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE GL_CITYCOUNTRY ADD CC_CO_CODE VARCHAR(4), CC_SITE_CODE  VARCHAR(4)

UPDATE GL_CITYCOUNTRY SET 	CC_SITE_CODE = '0001',CC_CO_CODE = '0001'

ALTER TABLE GL_CITYCOUNTRY ALTER COLUMN CC_CO_CODE VARCHAR(4) NOT NULL
 
ALTER TABLE GL_CITYCOUNTRY ALTER COLUMN CC_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE GL_BANKACC ADD BA_SITE_CODE  VARCHAR(4)

ALTER TABLE GL_CHEQBOOKMST DROP CONSTRAINT FK_GL_CHEQBOOK_BANK
ALTER TABLE GL_CHEQUES DROP CONSTRAINT FK_USER153
ALTER TABLE GL_CHEQUESPRN DROP CONSTRAINT FK_USER138
ALTER TABLE GL_IMPORTRECEIPT_MST DROP CONSTRAINT FK_USER_6951_A

ALTER TABLE GL_BANKACC DROP CONSTRAINT PKGL_BANKACC

ALTER TABLE GL_BANKACC ALTER COLUMN BA_GL_BANK_CODE VARCHAR(30) NOT NULL

ALTER TABLE GL_BANKACC ADD CONSTRAINT PKGL_BANKACC PRIMARY KEY (BA_CO_CODE, BA_GL_BANK_CODE)

UPDATE GL_BANKACC SET 	BA_SITE_CODE = '0001',	BA_CO_CODE = '0001'

ALTER TABLE GL_BANKACC ALTER COLUMN BA_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE PKG_MEASUNIT ADD MU_CO_CODE  VARCHAR(4),MU_SITE_CODE  VARCHAR(4)

UPDATE PKG_MEASUNIT SET MU_SITE_CODE = '0001',	MU_CO_CODE = '0001'

ALTER TABLE PKG_MEASUNIT ALTER COLUMN MU_CO_CODE  VARCHAR(4) NOT NULL

ALTER TABLE PKG_MEASUNIT ALTER COLUMN MU_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE GL_DFLTACCVCHR ADD DAC_SITE_CODE VARCHAR(4)

UPDATE GL_DFLTACCVCHR SET  DAC_SITE_CODE = '0001'

ALTER TABLE GL_DFLTACCVCHR ALTER COLUMN DAC_SITE_CODE VARCHAR(4) NOT NULL

ALTER TABLE GL_SUPPTYPE ADD ST_CO_CODE VARCHAR(4), ST_SITE_CODE  VARCHAR(4)

UPDATE GL_SUPPTYPE SET 	ST_SITE_CODE = '0001',	ST_CO_CODE = '0001'

ALTER TABLE GL_SUPPTYPE ALTER COLUMN ST_CO_CODE VARCHAR(4) NOT NULL

ALTER TABLE GL_SUPPTYPE ALTER COLUMN ST_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE GL_PARTYSTP ADD PS_SITE_CODE  VARCHAR(4) 

UPDATE GL_PARTYSTP SET 	PS_SITE_CODE = '0001',	PS_CO_CODE = '0001'

ALTER TABLE GL_PARTYSTP ALTER COLUMN PS_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE PKG_DEPARTMENT ADD DEP_SITE_CODE  VARCHAR(4)

UPDATE PKG_DEPARTMENT SET DEP_SITE_CODE = '0001',	DEP_CO_CODE = '0001'
 
ALTER TABLE PKG_DEPARTMENT ALTER COLUMN DEP_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE GL_SITES ADD SI_CO_CODE VARCHAR(4)

UPDATE GL_SITES SET SI_CO_CODE = '0001'

ALTER TABLE GL_SITES ALTER COLUMN SI_CO_CODE VARCHAR(4) NOT NULL

ALTER TABLE GL_FC_RATE_TYPE ADD FCT_CO_CODE VARCHAR(4), FCT_SITE_CODE  VARCHAR(4)

UPDATE GL_FC_RATE_TYPE SET FCT_SITE_CODE = '0001',FCT_CO_CODE = '0001'

ALTER TABLE GL_FC_RATE_TYPE ALTER COLUMN FCT_CO_CODE VARCHAR(4) NOT NULL

ALTER TABLE GL_FC_RATE_TYPE ALTER COLUMN FCT_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE PR_DESIGNATION ADD DG_CO_CODE VARCHAR(4), DG_SITE_CODE  VARCHAR(4)

UPDATE PR_DESIGNATION SET 	DG_SITE_CODE = '0001',	DG_CO_CODE = '0001'

ALTER TABLE PR_DESIGNATION ALTER COLUMN DG_CO_CODE VARCHAR(4) NOT NULL

ALTER TABLE PR_DESIGNATION ALTER COLUMN DG_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE PKG_FREIGHTZONE ADD FZ_CO_CODE VARCHAR(4), FZ_SITE_CODE  VARCHAR(4)

UPDATE PKG_FREIGHTZONE SET 	FZ_SITE_CODE = '0001',	FZ_CO_CODE = '0001'

ALTER TABLE PKG_FREIGHTZONE ALTER COLUMN FZ_CO_CODE VARCHAR(4) NOT NULL

ALTER TABLE PKG_FREIGHTZONE ALTER COLUMN FZ_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE PKG_DRCRNOTECUST DROP CONSTRAINT FK_DRCRNOTE_CALENDER
ALTER TABLE PKG_MRSMST DROP CONSTRAINT FK_PKG_MRSMST_CAL
ALTER TABLE GL_VCHRMASTER DROP CONSTRAINT FK_USER125
ALTER TABLE AP_DRCRNOTE_MST DROP CONSTRAINT FK_APDRNOTE_CALDR
ALTER TABLE GL_USERS DROP CONSTRAINT FK_USER137
ALTER TABLE PKG_DRCRNOTESUP DROP CONSTRAINT FK_DRCRNOTE_CALNDR
ALTER TABLE PKG_SANMST DROP CONSTRAINT FK_PKG_SANMST_CAL
ALTER TABLE AR_DRCRNOTE_MST DROP CONSTRAINT FK_ARDRNOTE_CALDR
ALTER TABLE PKG_STNMST DROP CONSTRAINT FK_PKG_STNMST_CAL
ALTER TABLE PKG_PURCHREQMST DROP CONSTRAINT FK_PKG_PURCHREQMST_PER
ALTER TABLE GL_TRACKPROCESS DROP CONSTRAINT FK_USER160
ALTER TABLE PKG_SALESQTMST DROP CONSTRAINT FK_PKG_SALESQTMST_PER
ALTER TABLE AP_PAYMENTMST DROP CONSTRAINT FK_YRPERACPMST
ALTER TABLE PKG_QTPURCHMST DROP CONSTRAINT FK_PKG_QTPURCHMST_PER
ALTER TABLE FA_VOUCHERTRACK DROP CONSTRAINT FK_FA70
ALTER TABLE PKG_SALESORDERMST DROP CONSTRAINT FK_PKG_SALESORDERMST_PER
ALTER TABLE PKG_PURCHORDERMST DROP CONSTRAINT FK_PKG_PURCHORDERMST_PER
ALTER TABLE ROPS_BILLMST DROP CONSTRAINT FK_GL_CALENDAR_ROPS
ALTER TABLE GL_CURRPERIODWISE DROP CONSTRAINT FK_USER221
ALTER TABLE PKG_DELIVORDERMST DROP CONSTRAINT FK_PKG_DELIVORDERMST_PER
ALTER TABLE ACR_INVMST DROP CONSTRAINT FK_ACR_GL_CALENDAR
ALTER TABLE ROPS_INVMST DROP CONSTRAINT FK_ROPS_CALENDAR
ALTER TABLE PKG_GRNMST DROP CONSTRAINT FK_PKG_GRNMST_PER
ALTER TABLE AR_RECEIPTMST DROP CONSTRAINT FK_AR_RECEIPTMST_PER
ALTER TABLE PKG_DELCHALLANMST DROP CONSTRAINT FK_PKG_DELCHALLANMST_PER
ALTER TABLE PKG_BILLMST DROP CONSTRAINT FK_PKG_BILLMST_PER
ALTER TABLE AP_BILLMST DROP CONSTRAINT FK_AP_GL_CALENDAR
ALTER TABLE PKG_INVMST DROP CONSTRAINT FK_PKG_INVMST_PER
ALTER TABLE PKG_PURCHRETMST DROP CONSTRAINT FK_PKG_PURCHRETMST_PER
ALTER TABLE PKG_SALESRTNMST DROP CONSTRAINT FK_PKG_SALESRTNMST_PER
ALTER TABLE PKG_MRNMST DROP CONSTRAINT FK_PKG_MRNMST_CAL
ALTER TABLE PKG_PRODCHALLANMST DROP CONSTRAINT FK_CALENDAR
ALTER TABLE GL_BUDGET DROP CONSTRAINT FK_USER111
ALTER TABLE PKG_CHQMST DROP CONSTRAINT FK_CHQMST_CALENDAR
ALTER TABLE PKG_RECEIPTMST DROP CONSTRAINT FK_PKG_RECEIPTMST_PER
ALTER TABLE PKG_MINMST DROP CONSTRAINT FK_PKG_MINMST_CAL


ALTER TABLE GL_CALENDAR DROP CONSTRAINT PKGL_CALENDAR

ALTER TABLE GL_CALENDAR ADD CL_SITE_CODE VARCHAR(4), CL_CO_CODE VARCHAR(4), CL_DISPLAY_YEAR VARCHAR(10)

UPDATE GL_CALENDAR SET 	CL_SITE_CODE = '0001',CL_CO_CODE = '0001'

ALTER TABLE GL_CALENDAR ALTER COLUMN CL_SITE_CODE VARCHAR(4) NOT NULL
		
ALTER TABLE GL_CALENDAR ALTER COLUMN CL_CO_CODE VARCHAR(4) NOT NULL

ALTER TABLE GL_CALENDAR ADD CONSTRAINT PKGL_CALENDAR PRIMARY KEY (CL_CO_CODE, CL_SITE_CODE, CL_YEAR, CL_PER);


ALTER TABLE GL_PAYSECTION ADD PSC_CO_CODE VARCHAR(4), PSC_SITE_CODE  VARCHAR(4)

UPDATE GL_PAYSECTION SET 	PSC_SITE_CODE = '0001',PSC_CO_CODE = '0001'

ALTER TABLE GL_PAYSECTION ALTER COLUMN PSC_CO_CODE VARCHAR(4) NOT NULL
 
ALTER TABLE GL_PAYSECTION ALTER COLUMN PSC_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE GL_BUDGET DROP CONSTRAINT PK__GL_BUDGE__7102CEE386A1E753

ALTER TABLE GL_BUDGET ALTER COLUMN BGT_ACC_CODE VARCHAR(30) NOT NULL

ALTER TABLE GL_BUDGET ADD CONSTRAINT PK__GL_BUDGE__7102CEE386A1E753 PRIMARY KEY (BGT_CO_CODE, BGT_ACC_CODE, BGT_PER, BGT_YEAR, BGT_TYPE, BGT_SITECODE, BGT_SEQNO)

ALTER TABLE GL_BUDGET ALTER COLUMN BGT_COSTCNTR_CODE VARCHAR(20)

ALTER TABLE GL_PREFMASTER ADD PF_CO_CODE VARCHAR(4), PF_SITE_CODE  VARCHAR(4)

UPDATE GL_PREFMASTER SET 	PF_SITE_CODE = '0001',	PF_CO_CODE = '0001'

ALTER TABLE GL_PREFMASTER ALTER COLUMN PF_CO_CODE VARCHAR(4) NOT NULL
 
ALTER TABLE GL_PREFMASTER ALTER COLUMN PF_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE GL_PREFDETAIL ADD PD_CO_CODE VARCHAR(4),  PD_SITE_CODE  VARCHAR(4)

UPDATE GL_PREFDETAIL SET 	PD_SITE_CODE = '0001',	PD_CO_CODE = '0001'

ALTER TABLE GL_PREFDETAIL ALTER COLUMN PD_CO_CODE VARCHAR(4) NOT NULL

ALTER TABLE GL_PREFDETAIL ALTER COLUMN PD_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE GL_ANALYSIS1 ADD AN1_CO_CODE VARCHAR(4), AN1_SITE_CODE  VARCHAR(4)

UPDATE GL_ANALYSIS1 SET AN1_SITE_CODE = '0001',	AN1_CO_CODE = '0001'

ALTER TABLE GL_ANALYSIS1 ALTER COLUMN AN1_CO_CODE VARCHAR(4) NOT NULL

ALTER TABLE GL_ANALYSIS1 ALTER COLUMN AN1_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE GL_ANALYSIS2 ADD AN2_CO_CODE VARCHAR(4), AN2_SITE_CODE  VARCHAR(4)

UPDATE GL_ANALYSIS2 SET 	AN2_SITE_CODE = '0001',	AN2_CO_CODE = '0001'

ALTER TABLE GL_ANALYSIS2 ALTER COLUMN AN2_CO_CODE VARCHAR(4) NOT NULL 

ALTER TABLE GL_ANALYSIS2 ALTER COLUMN AN2_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE GL_ANALYSIS3 ADD AN3_CO_CODE VARCHAR(4), AN3_SITE_CODE  VARCHAR(4)

UPDATE GL_ANALYSIS3 SET AN3_SITE_CODE = '0001',	AN3_CO_CODE = '0001'

ALTER TABLE GL_ANALYSIS3 ALTER COLUMN AN3_CO_CODE VARCHAR(4) NOT NULL

ALTER TABLE GL_ANALYSIS3 ALTER COLUMN AN3_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE GL_ANALYSIS4 ADD AN4_CO_CODE VARCHAR(4), AN4_SITE_CODE  VARCHAR(4)

UPDATE GL_ANALYSIS4 SET AN4_SITE_CODE = '0001', 	AN4_CO_CODE = '0001'

ALTER TABLE GL_ANALYSIS4 ALTER COLUMN AN4_CO_CODE VARCHAR(4) NOT NULL

ALTER TABLE GL_ANALYSIS4 ALTER COLUMN AN4_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE GL_ANALYSIS5 ADD AN5_CO_CODE VARCHAR(4), AN5_SITE_CODE  VARCHAR(4)

UPDATE GL_ANALYSIS5 SET 	AN5_SITE_CODE = '0001',	AN5_CO_CODE = '0001'

ALTER TABLE GL_ANALYSIS5 ALTER COLUMN AN5_CO_CODE VARCHAR(4) NOT NULL

ALTER TABLE GL_ANALYSIS5 ALTER COLUMN AN5_SITE_CODE  VARCHAR(4) NOT NULL

ALTER TABLE gl_recurringent ADD  REC_SITE_CODE  VARCHAR(4)

UPDATE gl_recurringent SET 	REC_SITE_CODE = '0001';

ALTER TABLE gl_recurringent ALTER COLUMN REC_SITE_CODE  VARCHAR(4) NOT NULL;

ALTER TABLE GL_VCHRTYPE ADD VT_DATE_TAG  VARCHAR(1);

ALTER TABLE GL_VCHRDETAIL ADD VD_SR_NO   decimal(20,6) ;

ALTER TABLE GL_SITES ADD SI_SITE_CODE VARCHAR(4);