--UPDATE FROM 8.8.3.2 TO 8.8.3.3


DROP TABLE VERSION_8_8_3_2;



/*  VERSION_8_8_3_3  */
CREATE TABLE VERSION_8_8_3_3 (
	 DUMMY	NUMBER	    NULL
)
;


ALTER TABLE YPKD ADD YPKD_DISPLORDER NUMBER(30);

COMMENT ON COLUMN YPKD.YPKD_DISPLORDER IS 'Package display order';

ALTER TABLE YETB ADD YETB_DISPLORDER NUMBER(30);

COMMENT ON COLUMN YETB.YETB_DISPLORDER IS 'Event group display order';

CREATE TABLE ZORG
(
  ZORG_ID                NUMBER(30)             NOT NULL,
  ZORG_ZPOS_ID           NUMBER(30)             NOT NULL,
  ZORG_ROLE              NUMBER(1),
  ZORG_TABLE_ID          NUMBER(30),
  CONSTRAINT ZORG_PK PRIMARY KEY (ZORG_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;
  
COMMENT ON TABLE ZORG IS 'Store for posting origination to ease translation in reports';

COMMENT ON COLUMN ZORG.ZORG_ROLE IS '1/Rate Code Posting (YRCH), 2/Article Posting (ZART), 3/Package Posting (YPAC), 4/Department Code Posting (ZDCO)  ';

CREATE SEQUENCE SEQ_ZORG INCREMENT BY 1 START WITH 1000 NOMAXVALUE NOCYCLE NOCACHE NOORDER;

ALTER TABLE WPCA ADD WPCA_SKIPMAKEKEYFORTRANSPONDER NUMBER(1) DEFAULT 0;

COMMENT ON COLUMN WPCA.WPCA_SKIPMAKEKEYFORTRANSPONDER IS '1. Makekey during Transponder check-in will be skiped in this workstation ';
