-- ABS-58152 / ABS-58172

--------------------- CONTRACTPRODUCTADDBILLING ------------------------------

ALTER TABLE CONTRACTPRODUCTADDBILLING
	ADD (IMAGECARE NUMBER NULL CONSTRAINT IMAGECARE_VALID1_1 CHECK (IMAGECARE BETWEEN 0 AND 7) );

COMMENT ON COLUMN CONTRACTPRODUCTADDBILLING.IMAGECARE IS '0 = Not charged
1 = For repairs
2 = For Loss Charges
3 = For Repairs and Loss Charges
4 = For Residual Value
5 = For Repair and Residual Value
6 = For Residual Value and Loss Charge
7 = For Repairs and Loss Charges and Residual Value';

--------------------- CONTRACTPRODUCTBILLING ------------------------------
COMMENT ON COLUMN CONTRACTPRODUCTBILLING.COMPLIANCYRULE IS '0 = Contract suggested, can be overruled
1 = Contract enforced, can only be overruled by maintenance user
2 = Contract enforced
No default (Null = no compliancy rule)';

COMMENT ON COLUMN CONTRACTPRODUCTBILLING.COMPLIANCYRULEPRICING IS '0 = Contract suggested, can be overruled 
1 = Contract enforced, can only be overruled by maintenance user
2 = Contract enforced
No default (Null = no compliancy rule)';

-----------------------------------CONTRACTPRODUCTORDERDELIVERY---------------------------


COMMENT ON COLUMN CONTRACTPRODUCTORDERDELIVERY.COMPLIANCYRULE  IS '0 = Contract suggested, can be overruled
1 = Contract enforced, can only be overruled by maintenance user
2 = Contract enforced
No default (Null = no compliancy rule)';

----------------------------CONTRACTPRODUCTMISCELLANEOUS-----------------------------------


COMMENT ON COLUMN CONTRACTPRODUCTMISCELLANEOUS.COMPLIANCYRULE IS '0 = Contract suggested, can be overruled
1 = Contract enforced, can only be overruled by maintenance user
2 = Contract enforced
No default (Null = no compliancy rule)';

---------------------------------CONTRACTPRODUCTBGPROTECTION---------------------------------------
COMMENT ON COLUMN CONTRACTPRODUCTBGPROTECTION.COMPLIANCYRULE IS '0 = Contract suggested, can be overruled
1 = Contract enforced, can only be overruled by maintenance user
2 = Contract enforced
No default (Null = no compliancy rule)';


