--ABS-75642 / ABS-81174

UPDATE PRODUCTLISTPERCUSTOMER
SET PRODUCTLISTPERCUSTOMER.INVENTORYBILLINGTYPE=0
WHERE PRODUCTLISTPERCUSTOMER.INVENTORYBILLINGTYPE NOT IN (0, 1, 2, 3, 4);
COMMIT;

ALTER TABLE PRODUCTLISTPERCUSTOMER DROP CONSTRAINT INVENTORYBILLINGTYP;

ALTER TABLE PRODUCTLISTPERCUSTOMER
	 ADD CONSTRAINT INVENTORYBILLINGTYP  CHECK (INVENTORYBILLINGTYPE IN (0, 1, 2, 3, 4));
	 
COMMENT ON COLUMN PRODUCTLISTPERCUSTOMER.INVENTORYBILLINGTYPE IS 'For Billing Method 2:
0 - Based on Circulating Inventory
1 - Based on Real Quantity
2 - Based on Max Inventory(3, 4 not used)
For billingmethod 3:
0 - circulating inventory
1 - real quantity
2 - max inventory qty
3 - on-site inventory qty
4 - Rent for Non-returned items after n weeks';