--ABSN-3274
ALTER TABLE ERP_I_CUSTOMER ADD
(CHARGEREPAIRS NUMBER(1) DEFAULT 0 CONSTRAINT CHK_ERP_I_CUSTOMER_CHARGEREPAIRS CHECK (CHARGEREPAIRS IN (0, 1, 2)),
CHARGEREPAIRSCOG NUMBER(1) DEFAULT 0 CONSTRAINT CHK_ERP_I_CUSTOMER_CHARGEREPAIRSCOG CHECK (CHARGEREPAIRSCOG IN (0, 1, 2)),
CONSIGNMENTNOTELEVEL NUMBER(1) DEFAULT 0 CONSTRAINT CHK_ERP_I_CUSTOMER_CONSIGNMENTNOTELEVEL CHECK (CONSIGNMENTNOTELEVEL IN (0, 1, 2, 3, 4)),
CONSIGNMENTNOTELAYOUT VARCHAR2(6),
BOXDELIVERYDOCUMENT VARCHAR2(1) DEFAULT 'N' CONSTRAINT CHK_ERP_I_CUSTOMER_BOXDELIVERYDOCUMENT CHECK (BOXDELIVERYDOCUMENT IN ('N','Y')),
GARMENTBATCHSORTING NUMBER(1) DEFAULT 0 CONSTRAINT CHK_ERP_I_CUSTOMER_GARMENTBATCHSORTING CHECK (GARMENTBATCHSORTING IN (0, 1, 2, 3, 4, 5, 6, 7)));
COMMENT ON COLUMN ERP_I_CUSTOMER.CHARGEREPAIRS IS '0=Allow N/Charge N 
1=Allow Y/Charge N
2=Allow Y/Charge Y';
COMMENT ON COLUMN ERP_I_CUSTOMER.CHARGEREPAIRSCOG IS '0=Allow N/Charge N 
1=Allow Y/Charge N
2=Allow Y/Charge Y';
COMMENT ON COLUMN ERP_I_CUSTOMER.CONSIGNMENTNOTELEVEL IS '0=No Consignment Note 
1=Consignment Note on Customer level 
2=Consignment Note on Department level 
3=Consignment Note on DeliveryPoint level 
4=Consignment Note on Customer reference level';
COMMENT ON COLUMN ERP_I_CUSTOMER.CONSIGNMENTNOTELAYOUT IS 'link to formlayout type CN';
COMMENT ON COLUMN ERP_I_CUSTOMER.GARMENTBATCHSORTING IS '0=No sorting / customer is not accepted in a batch 
1=Department 
2=Delivery point 
3=Cupboard / Locker 
4=Wearer Number 
5=Product / Size 
6=Product 
7=Size';
