--ABS-57404/ ABS-57892

---CONTRACT table---
ALTER TABLE CONTRACT ADD (USEPRODSIZESURCHARGEPRICING VARCHAR2(1) DEFAULT 'N'
                           CONSTRAINT YN_VALIDATIONFIELD406 CHECK (USEPRODSIZESURCHARGEPRICING IN ('Y', 'N')));
                           
---CONTRACTCOMPONENTGRMCHARGES table---
ALTER TABLE CONTRACTCOMPONENTGRMCHARGES ADD (USEPRODSIZESURCHARGEPRICING VARCHAR2(1) DEFAULT 'N'
                                             CONSTRAINT YN_VALIDATIONFIELD407 CHECK (USEPRODSIZESURCHARGEPRICING IN ('Y', 'N')));

---CONTRACTATTRIBUTE table---                          
UPDATE CONTRACTATTRIBUTE CA SET CA.INTERNALNAME = 'Table_CONTRACTPRODUCTBGPROTECTION'
WHERE CA.CONTRACTATTRIBUTE_ID = 106;
COMMIT;

INSERT INTO CONTRACTATTRIBUTE
  (CONTRACTATTRIBUTE_ID, GROUPNUMBER, SEQUENCENUMBER, FACTORYNAME, INTERNALNAME, SYSTEMUSER_ID, TIMESTAMP, NOVALUERULE)
VALUES
  (172, 4, 14, 'UseProdSizeSurchargePricing', 'cbUseProdSizeSurchargePricing', GETMINSYSTEMUSER(), sysdate, 2);
COMMIT;

INSERT INTO CONTRACTATTRIBUTE
  (CONTRACTATTRIBUTE_ID, GROUPNUMBER, SEQUENCENUMBER, FACTORYNAME, INTERNALNAME, SYSTEMUSER_ID, TIMESTAMP, NOVALUERULE)
VALUES
  (173, 14, 1, 'BudgetProtection', 'PLPCBudgetProtection', GETMINSYSTEMUSER(), sysdate, 0);
COMMIT;
  
---GENERALDISCOUNTLIST table---
ALTER TABLE GENERALDISCOUNTLIST MODIFY (CODE VARCHAR2(15));
