--Order 20013936.100


----REASONCODE table----

ALTER TABLE REASONCODE ADD (REASONFORMAINORDER VARCHAR2(1) DEFAULT 'N' NOT NULL
                                               CONSTRAINT YN_VALIDATIONFIELD102 CHECK (REASONFORMAINORDER IN ('Y', 'N')));

COMMENT ON COLUMN REASONCODE.REASONFORMAINORDER
  IS 'When set to ‘Y’ a garment order that is created via a web portal with this reason code is considered to be a main order. Only for module BKLINTERNETMAINORDERS.';


----CUSTOMER table----

ALTER TABLE CUSTOMER ADD (MAINORDEREXPECTEDDELIVERYDATE DATE NULL);

COMMENT ON COLUMN CUSTOMER.MAINORDEREXPECTEDDELIVERYDATE
  IS 'Field that indicates the expected delivery date for all garment web orders that will be created for this customer when entered before the defined main order cutoff date.';

ALTER TABLE CUSTOMER ADD (MAINORDERCUTOFFDATE DATE NULL);

COMMENT ON COLUMN CUSTOMER.MAINORDERCUTOFFDATE
  IS 'Field that indicates until which date the garment web orders for this customer will be created using the specified expected delivery date. Optional, so may be left empty.';