ALTER TABLE SALES_QUOTDET_HIST ADD CONSTRAINT PK_SALES_QUOTDET_HIST PRIMARY KEY (QUOT_NO, LINE_NO, VERSION_NO)
   
ALTER TABLE POS_AMENDMENT ADD CONSTRAINT POS_AMENDMENT_X PRIMARY KEY (TRAN_ID)
   
ALTER TABLE QCITEM_SPEC_DET_CUSTOM ADD CONSTRAINT QCITEM_SPEC_DET_CUSTOM_X PRIMARY KEY (ITEM_CODE, SPEC_REF, LINE_NO)
   
ALTER TABLE SALES_QUOT_HIST ADD CONSTRAINT PK_SALES_QUOT_HIST PRIMARY KEY (QUOT_NO, VERSION_NO)
   
ALTER TABLE PERIOD ADD CONSTRAINT PERIOD_X PRIMARY KEY (CODE)
   
ALTER TABLE USER_ACC_CHANNEL_REG ADD CONSTRAINT PK_CONSTRAINT_NAME PRIMARY KEY (USER_ACC_CHANNEL, CHANNEL_ID, USER_ACC_ID)
   
ALTER TABLE CASH_COUNT_DTL ADD CONSTRAINT CASH_COUNT_DTL_PK PRIMARY KEY (TRAN_ID, LINE_NO)
   
ALTER TABLE CASH_COUNT_HDR ADD CONSTRAINT CASH_COUNT_HDR_PK PRIMARY KEY (TRAN_ID)
   
ALTER TABLE ICS_ITEM_DTL ADD CONSTRAINT ICS_ITEM_DTL_PK PRIMARY KEY (TRAN_ID, LINE_NO)
   
ALTER TABLE RECEIV_FOLLOWUP ADD CONSTRAINT REC_FOLLOWUP_PK PRIMARY KEY (TRAN_ID)
   
ALTER TABLE RECEIV_FOLLOWUP ADD CONSTRAINT FK_RECEIV_FOLLOWUP FOREIGN KEY (SITE_CODE)
	  REFERENCES SITE (SITE_CODE) ENABLE 
ALTER TABLE RECEIV_FOLLOWUP ADD CONSTRAINT FK_CUSTOMER FOREIGN KEY (CUST_CODE)
	  REFERENCES CUSTOMER (CUST_CODE) ENABLE 
ALTER TABLE RECEIV_FOLLOWUP ADD CONSTRAINT FK_EMPLOYEE FOREIGN KEY (EMP_CODE__APRV)
	  REFERENCES EMPLOYEE (EMP_CODE) ENABLE 
ALTER TABLE TRANSPORTER_BILL ADD CONSTRAINT TRANSPORTER_BILL_X PRIMARY KEY (TRAN_ID)
   
ALTER TABLE ENTERPRISE_CP_ACC ADD CONSTRAINT PK_ENTERPRISE PRIMARY KEY (ENTERPRISE, ENTERPRISE_ACC)
   
ALTER TABLE ICS_ITEM_HDR ADD CONSTRAINT ICS_ITEM_HDR_PK PRIMARY KEY (TRAN_ID)
   
ALTER TABLE ALLWDEDN_BKP ADD CONSTRAINT ALLWDEDN_X PRIMARY KEY (AD_CODE)
   
ALTER TABLE ALLWDEDN_BKP ADD CONSTRAINT FK_ALLWDEDN_TAUTH_CODE FOREIGN KEY (TAUTH_CODE)
	  REFERENCES TAX_AUTHORITY (TAUTH_CODE) ENABLE NOVALIDATE 
ALTER TABLE ALLWDEDN_BKP ADD CONSTRAINT FK_ALLWDEDN_ACCT FOREIGN KEY (ACCT_CODE__SAL)
	  REFERENCES ACCOUNTS (ACCT_CODE) ENABLE NOVALIDATE 
ALTER TABLE ALLWDEDN_BKP ADD CONSTRAINT FK_ALLWDEDN_CCTR_CODE__SAL FOREIGN KEY (CCTR_CODE__SAL)
	  REFERENCES COSTCTR (CCTR_CODE) ENABLE 
ALTER TABLE RECEIV_FOLLOWUP_DET ADD CONSTRAINT RCVFWUPDET_X PRIMARY KEY (TRAN_ID, LINE_NO)
   
ALTER TABLE GIFT_VOUCH_AMD ADD CONSTRAINT GIFT_VOUCH_AMD_PK PRIMARY KEY (AMD_NO)
   
ALTER TABLE ASSET_ASSIGN ADD CONSTRAINT PK_ASSET_ASSIGN PRIMARY KEY (TRAN_ID)
   
ALTER TABLE GST_AUTH_INFO ADD CONSTRAINT GST_AUTH_INFO_X PRIMARY KEY (GSTIN_NO)
   
ALTER TABLE GIFT_VOUCH_TRACE ADD CONSTRAINT GIFT_VOUCH_TRACE_PK PRIMARY KEY (TRAN_ID)
   
ALTER TABLE TIMESLOT_STOCK ADD CONSTRAINT TIMESLOT_STOCK_PK PRIMARY KEY (ITEM_CODE, INV_DATE)
   
ALTER TABLE WORDER_PRC_SCH ADD CONSTRAINT WORDER_PRC_SCH_X PRIMARY KEY (TRAN_ID)
   
ALTER TABLE APPLICANT_INFO ADD CONSTRAINT PK_APPLICANT_INFO PRIMARY KEY (TRAN_ID)
   
ALTER TABLE FREIGHT_RATE_DET_COMMENT ADD CONSTRAINT FREIGHT_RATE_DET_X PRIMARY KEY (FRT_LIST, LOAD_TYPE, STAN_CODE__FROM, STAN_CODE__TO, CHARGE_CODE)
   
ALTER TABLE FREIGHT_RATE_DET_COMMENT ADD CONSTRAINT FK_FREIGHT_RATE_DET FOREIGN KEY (FRT_LIST, LOAD_TYPE, STAN_CODE__FROM, STAN_CODE__TO)
	  REFERENCES FREIGHT_RATE (FRT_LIST, LOAD_TYPE, STAN_CODE__FROM, STAN_CODE__TO) ENABLE NOVALIDATE 
ALTER TABLE GIFT_VOUCH_REDEEM ADD CONSTRAINT GIFT_VOUCH_REDEEM_PK PRIMARY KEY (TRAN_ID)
   
ALTER TABLE TIMESLOT_INVTRACE ADD CONSTRAINT TIMESLOT_INVTRACE_PK PRIMARY KEY (TRAN_ID)
   
ALTER TABLE IMPORT_ORDER_ITEM_INFO ADD CONSTRAINT IMPORT_ORDER_ITEM_INFO_X PRIMARY KEY (TRAN_ID)
   
ALTER TABLE USERTYPE_LIC_CHRGS ADD CONSTRAINT USERTYPE_LIC_CHRGS_PK PRIMARY KEY (USER_LIC_TYPE)
   
ALTER TABLE CUSTOMER_ITEM_ATTRIBUTES ADD CONSTRAINT PK_ITEM_ATTRIBUTES PRIMARY KEY (HIS_REF, ITEM_TYPE, REF_SER, ATTRIB_NO)
   
ALTER TABLE EMP_EXIT_CLEARANCE ADD CONSTRAINT EMP_CLEARANCE_HDR_X PRIMARY KEY (CLEARANCE_ID)
   
ALTER TABLE RETAINER_CONTRACT_ASSET ADD CONSTRAINT PK_RETAILER_CONTRACT_ASSET PRIMARY KEY (CONTRACT_ID, LINE_NO)
   
ALTER TABLE GIFT_VOUCHER ADD CONSTRAINT GIFT_VOUCHER_PK PRIMARY KEY (TRAN_ID)
   
ALTER TABLE TRANSPORTER_BILL_CHGS ADD CONSTRAINT TRANSPORTER_BILL_CHGS_X PRIMARY KEY (TRAN_ID, LINE_NO)
   
ALTER TABLE ENTITY_ALIAS ADD CONSTRAINT PK_ENTITY_ALIAS PRIMARY KEY (TRAN_ID)
   

-- No of Rows = 40
