-- order 502868
  
      /*
      CHANGE REPORT for Table EMBLEMTEMPLATE
          - Adding column EMBROIDERY
      ACTION is ALTER or modify Table EMBLEMTEMPLATE
      */

ALTER TABLE EMBLEMTEMPLATE ADD (EMBROIDERY           VARCHAR2(1) DEFAULT 'N' 
    NOT NULL
                                   CONSTRAINT YN_ValidationField11
                                          CHECK (EMBROIDERY IN ('Y', 'N')));

      
      /*
      CHANGE REPORT for Table EMBLEMTEMPLATELINE
          - Adding column EMBROIDERYLETTERING
          - Adding column EMBROIDERYLETTERINGLINE1
          - Adding column EMBROIDERYLETTERINGLINE2
          - Adding column EMBROIDERYLETTERINGLINE3
      ACTION is ALTER or modify Table EMBLEMTEMPLATELINE
      */

ALTER TABLE EMBLEMTEMPLATELINE ADD (EMBROIDERYLETTERING  VARCHAR2(1) DEFAULT 
    'N' NOT NULL
                                   CONSTRAINT YN_ValidationField12
                                          CHECK (EMBROIDERYLETTERING IN ('Y', 
    'N')));


ALTER TABLE EMBLEMTEMPLATELINE ADD (EMBROIDERYLETTERINGLINE1 VARCHAR2(35) NULL);


ALTER TABLE EMBLEMTEMPLATELINE ADD (EMBROIDERYLETTERINGLINE2 VARCHAR2(35) NULL);


ALTER TABLE EMBLEMTEMPLATELINE ADD (EMBROIDERYLETTERINGLINE3 VARCHAR2(35) NULL);

      
      /*
      CHANGE REPORT for Table UNIQUEITEMEMBLEM
          - Adding column EMBROIDERYLETTERING
          - Adding column EMBROIDERYLETTERINGLINE1
          - Adding column EMBROIDERYLETTERINGLINE2
          - Adding column EMBROIDERYLETTERINGLINE3
      ACTION is ALTER or modify Table UNIQUEITEMEMBLEM
      */

ALTER TABLE UNIQUEITEMEMBLEM ADD (EMBROIDERYLETTERING  VARCHAR2(1) DEFAULT 'N' 
    NOT NULL
                                   CONSTRAINT YN_ValidationField13
                                          CHECK (EMBROIDERYLETTERING IN ('Y', 
    'N')));


ALTER TABLE UNIQUEITEMEMBLEM ADD (EMBROIDERYLETTERINGLINE1 VARCHAR2(35) NULL);


ALTER TABLE UNIQUEITEMEMBLEM ADD (EMBROIDERYLETTERINGLINE2 VARCHAR2(35) NULL);


ALTER TABLE UNIQUEITEMEMBLEM ADD (EMBROIDERYLETTERINGLINE3 VARCHAR2(35) NULL);

      
      /*
      CHANGE REPORT for Table WEAREREMPLOYMENT
          - Adding column EMBROIDERYLETTERINGLINE1
          - Adding column EMBROIDERYLETTERINGLINE2
          - Adding column EMBROIDERYLETTERINGLINE3
      ACTION is ALTER or modify Table WEAREREMPLOYMENT
      */

ALTER TABLE WEAREREMPLOYMENT ADD (EMBROIDERYLETTERINGLINE1 VARCHAR2(35) NULL);


ALTER TABLE WEAREREMPLOYMENT ADD (EMBROIDERYLETTERINGLINE2 VARCHAR2(35) NULL);


ALTER TABLE WEAREREMPLOYMENT ADD (EMBROIDERYLETTERINGLINE3 VARCHAR2(35) NULL);

      
      /*
      CHANGE REPORT for Table WORKORDERLINEEMBLEM
          - Adding column EMBROIDERYLETTERING
          - Adding column EMBROIDERYLETTERINGLINE1
          - Adding column EMBROIDERYLETTERINGLINE2
          - Adding column EMBROIDERYLETTERINGLINE3
      ACTION is ALTER or modify Table WORKORDERLINEEMBLEM
      */

ALTER TABLE WORKORDERLINEEMBLEM ADD (EMBROIDERYLETTERING  VARCHAR2(1) DEFAULT 
    'N' NOT NULL
                                   CONSTRAINT YN_ValidationField14
                                          CHECK (EMBROIDERYLETTERING IN ('Y', 
    'N')));


ALTER TABLE WORKORDERLINEEMBLEM ADD (EMBROIDERYLETTERINGLINE1 VARCHAR2(35) NULL);


ALTER TABLE WORKORDERLINEEMBLEM ADD (EMBROIDERYLETTERINGLINE2 VARCHAR2(35) NULL);


ALTER TABLE WORKORDERLINEEMBLEM ADD (EMBROIDERYLETTERINGLINE3 VARCHAR2(35) NULL);


-- todo 9840

create index XSPEEDPACKINGNOTELINE on PACKINGNOTELINE (NVL(INVOICEHEADER_ID, 0), PACKINGNOTE_ID);

