--THIS FILE IS NEEDED ONLY FOR THE ONLINE UPDATE!!!

--UPDATE FROM 8.6.4.6 TO 8.7.0.0

/************************************************************************************************************************
*
*
*  Date: August 27, 2007  15:57:31
*
*  This upgrade script was automatically generated by DBDiff for Oracle (www.dbdiff.com)
*
*  SOURCE DATABASE:  VERSION_8_7_0_0@V8
*  TARGET DATABASE:  VERSION_8_6_4_0@V8
*
*  This script should be executed as VERSION_8_6_4_0 in database VERSION_8_6_4_0@V8 except where otherwise noted.
*
*  IMPORTANT:  As with any script, you should always perform a sanity check before executing it in your target database.
*
*
************************************************************************************************************************/




/************************************************************************************************************************
*
*  sequences
*
*  The following statements will upgrade the sequences
*
************************************************************************************************************************/


DROP SEQUENCE PK_YPKS;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

COMMIT;


/************************************************************************************************************************
*
*  tables
*
*  644 tables were found in VERSION_8_7_0_0@V8
*  625 tables were found in VERSION_8_6_4_0@V8
*
************************************************************************************************************************/




/************************************************************************************************************************
*
*  The following statements will drop tables that DO NOT exist in VERSION_8_7_0_0@V8
*
************************************************************************************************************************/


DROP TABLE VERSION_8_6_4_0;

DROP TABLE VERSION_8_6_4_2;

DROP TABLE WFFO CASCADE CONSTRAINTS;

DROP TABLE WFFQ CASCADE CONSTRAINTS;

DROP TABLE WQRG CASCADE CONSTRAINTS;

DROP TABLE WQRY CASCADE CONSTRAINTS;

DROP TABLE YPKS CASCADE CONSTRAINTS;

COMMIT;


/************************************************************************************************************************
*
*  The following statements will create tables that DO NOT exist in VERSION_8_6_4_0@V8
*
************************************************************************************************************************/


/*  ADET  */
CREATE TABLE ADET (
	 ADET_ID	NUMBER(30)	NOT NULL
	,ADET_AHDR_ID	NUMBER(30)	NOT NULL
	,ADET_DESCRIPTION	VARCHAR2(120)	    NULL
	,ADET_AMOUNT	NUMBER(30,4)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE ADET ADD (
	CONSTRAINT ADET_PK
	PRIMARY KEY
	            (
	             ADET_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX ADET_AHDR_ID ON ADET
	(
	  ADET_AHDR_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  AHDR  */
CREATE TABLE AHDR (
	 AHDR_ID	NUMBER(30)	NOT NULL
	,AHDR_INVOICEDATE	DATE	    NULL
	,AHDR_ORIGINALINVOICENO	VARCHAR2(60)	    NULL
	,AHDR_VOUCHERNO	VARCHAR2(60)	    NULL
	,AHDR_FOLIONO	VARCHAR2(60)	    NULL
	,AHDR_ARNO	VARCHAR2(20)	    NULL
	,AHDR_MEALS	VARCHAR2(100)	    NULL
	,AHDR_GUEST_XCMS_ID	NUMBER(30)	    NULL
	,AHDR_AACC_ID	NUMBER(30)	    NULL
	,AHDR_AINV_ID	NUMBER(30)	    NULL
	,AHDR_CHECKIN	DATE	    NULL
	,AHDR_CHECKOUT	DATE	    NULL
	,AHDR_DUEDATE	DATE	    NULL
	,AHDR_ZCUR_ID	NUMBER(30)	    NULL
	,AHDR_AMOUNT	NUMBER(30,4)	    NULL
	,AHDR_EXCHANGERATE	NUMBER(30,4)	    NULL
	,AHDR_FOREIGNAMOUNT	NUMBER(30,4)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE AHDR ADD (
	CONSTRAINT AHDR_PK
	PRIMARY KEY
	            (
	             AHDR_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX AHDR_AACC_ID ON AHDR
	(
	  AHDR_AACC_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX AHDR_AINV_ID ON AHDR
	(
	  AHDR_AINV_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX AHDR_GUEST_XCMS_ID ON AHDR
	(
	  AHDR_GUEST_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX AHDR_ZCUR_ID ON AHDR
	(
	  AHDR_ZCUR_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  QNRA  */
CREATE TABLE QNRA (
	 QNRA_ID	NUMBER(30)	NOT NULL
	,QNRA_QNRF_ID	NUMBER(30)	NOT NULL
	,QNRA_WQUE_ID	NUMBER(30)	    NULL
	,QNRA_WQAN_ID	NUMBER(30)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE QNRA ADD (
	CONSTRAINT QNRA_PK
	PRIMARY KEY
	            (
	             QNRA_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX QNRA_QNRF_ID ON QNRA
	(
	  QNRA_QNRF_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX QNRA_WQAN_ID ON QNRA
	(
	  QNRA_WQAN_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX QNRA_WQUE_ID ON QNRA
	(
	  QNRA_WQUE_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  QNRF  */
CREATE TABLE QNRF (
	 QNRF_ID	NUMBER(30)	NOT NULL
	,QNRF_WQNR_ID	NUMBER(30)	NOT NULL
	,QNRF_GUEST_XCMS_ID	NUMBER(30)	    NULL
	,QNRF_YRES_ID	NUMBER(30)	    NULL
	,QNRF_COMMENT	VARCHAR2(2000)	    NULL
	,QNRF_XCMS_ID	NUMBER(30)	    NULL
	,QNRF_ENTERED	DATE	    NULL
	,QNRF_LASTMODIFIED	DATE	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE QNRF ADD (
	CONSTRAINT QNRF_PK
	PRIMARY KEY
	            (
	             QNRF_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX QNRF_GUEST_XCMS_ID ON QNRF
	(
	  QNRF_GUEST_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX QNRF_WQNR_ID ON QNRF
	(
	  QNRF_WQNR_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX QNRF_XCMS_ID ON QNRF
	(
	  QNRF_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX QNRF_YRES_ID ON QNRF
	(
	  QNRF_YRES_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  SAAR  */
CREATE TABLE SAAR (
	 SAAR_ID	NUMBER(30)	NOT NULL
	,SAAR_AACC_ID	NUMBER(30)	NOT NULL
	,SAAR_XCMS_ID	NUMBER(30)	NOT NULL
	,SAAR_AACC_ATYP_ID	NUMBER(30)	    NOT NULL 
	,SAAR_XCMS_GLOBALID	NUMBER(30)	    NULL
	,SAAR_ACCOUNTNAME	VARCHAR2(100)	    NULL
	,SAAR_ACCOUNTNUMBER	VARCHAR2(60)	    NULL
	,SAAR_DATE	DATE	    NULL
	,SAAR_OPENAMOUNT	NUMBER(30,4)	    NULL
	,SAAR_CREATEDDATE	DATE	    NULL
	,SAAR_IMPORTED	NUMBER(1)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE SAAR ADD (
	CONSTRAINT SAAR_PK
	PRIMARY KEY
	            (
	             SAAR_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX SAAR_AACC_ID ON SAAR
	(
	  SAAR_AACC_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SAAR_XCMS_GLOBALID ON SAAR
	(
	  SAAR_XCMS_GLOBALID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SAAR_XCMS_ID ON SAAR
	(
	  SAAR_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  SHIB  */
CREATE TABLE SHIB (
	 SHIB_ID	NUMBER(30)	NOT NULL
	,SHIB_WDAT_DATE	DATE	NOT NULL
	,SHIB_YBOM_ID	NUMBER(30)	    NULL
	,SHIB_ZFAC_ID	NUMBER(30)	    NULL
	,SHIB_YBOM_ARRIVAL	DATE	    NULL
	,SHIB_YBOM_DEPARTURE	DATE	    NULL
	,SHIB_YBOM_ARRIVAL_F	NUMBER(3)	    NULL
	,SHIB_YBOM_DEPARTURE_F	NUMBER(3)	    NULL
	,SHIB_YBOM_CON_YEST_ID	NUMBER(30)	    NULL
	,SHIB_YBOM_CON_YEST_SHORTDESC	VARCHAR2(3)	    NULL
	,SHIB_YBOM_RMS_YEST_ID	NUMBER(30)	    NULL
	,SHIB_YBOM_RMS_YEST_SHORTDESC	VARCHAR2(3)	    NULL
	,SHIB_YBOM_XCMS_ID	NUMBER(30)	    NULL
	,SHIB_YBOM_COMPANY	VARCHAR2(35)	    NULL
	,SHIB_YBOM_IND_XCMS_ID	NUMBER(30)	    NULL
	,SHIB_YBOM_CONTACT	VARCHAR2(35)	    NULL
	,SHIB_YBOM_NOOFATTENDEES	NUMBER(4)	    NULL
	,SHIB_YBML_1_XCMS_ID	NUMBER(30)	    NULL
	,SHIB_COMPANYNAME	VARCHAR2(35)	    NULL
	,SHIB_YBML_2_XCMS_ID	NUMBER(30)	    NULL
	,SHIB_TAGENTNAME	VARCHAR2(35)	    NULL
	,SHIB_YBML_3_XCMS_ID	NUMBER(30)	    NULL
	,SHIB_SOURCENAME	VARCHAR2(35)	    NULL
	,SHIB_YBML_4_XCMS_ID	NUMBER(30)	    NULL
	,SHIB_INDNAME	VARCHAR2(35)	    NULL
	,SHIB_YBML_5_XCMS_ID	NUMBER(30)	    NULL
	,SHIB_VENDNAME	VARCHAR2(35)	    NULL
	,SHIB_YBML_6_XCMS_ID	NUMBER(30)	    NULL
	,SHIB_MPLANNAME	VARCHAR2(35)	    NULL
	,SHIB_YBML_7_XCMS_ID	NUMBER(30)	    NULL
	,SHIB_BOOKERNAME	VARCHAR2(35)	    NULL
	,SHIB_YGRP_ID	NUMBER(30)	    NULL
	,SHIB_YGRP_NAME	VARCHAR2(60)	    NULL
	,SHIB_YBLH_ID	NUMBER(30)	    NULL
	,SHIB_YBLH_SHORTDESC	VARCHAR2(10)	    NULL
	,SHIB_YBOM_YFTY_ID	NUMBER(30)	    NULL
	,SHIB_YFTY_SHORTDESC	VARCHAR2(3)	    NULL
	,SHIB_YFTY_LONGDESC	VARCHAR2(30)	    NULL
	,SHIB_YBOM_XCMA_ID	NUMBER(30)	    NULL
	,SHIB_XCMA_SHORTDESC	VARCHAR2(3)	    NULL
	,SHIB_XCMA_LONGDESC	VARCHAR2(30)	    NULL
	,SHIB_YBOM_YRAS_ID	NUMBER(30)	    NULL
	,SHIB_YRAS_SHORTDESC	VARCHAR2(3)	    NULL
	,SHIB_YRAS_LONGDESC	VARCHAR2(30)	    NULL
	,SHIB_XCED_ID_ACC	NUMBER(30)	    NULL
	,SHIB_XCED_INITIALS_ACC	VARCHAR2(3)	    NULL
	,SHIB_XCED_NAME_ACC	VARCHAR2(75)	    NULL
	,SHIB_XCED_ID_CONF	NUMBER(30)	    NULL
	,SHIB_XCED_INITIALS_CONF	VARCHAR2(3)	    NULL
	,SHIB_XCED_NAME_CONF	VARCHAR2(75)	    NULL
	,SHIB_XCED_ID_RMS	NUMBER(30)	    NULL
	,SHIB_XCED_INITIALS_RMS	VARCHAR2(3)	    NULL
	,SHIB_XCED_NAME_RMS	VARCHAR2(75)	    NULL
	,SHIB_EXPECTED_GROSSREV	NUMBER(30,4)	    NULL
	,SHIB_EXPECTED_NETREV	NUMBER(30,4)	    NULL
	,SHIB_FORECAST_GROSSREV	NUMBER(30,4)	    NULL
	,SHIB_FORECAST_NETREV	NUMBER(30,4)	    NULL
	,SHIB_POSTED_GROSSREV	NUMBER(30,4)	    NULL
	,SHIB_POSTED_NETREV	NUMBER(30,4)	    NULL
	,SHIB_GROSSROOMREV	NUMBER(30,4)	    NULL
	,SHIB_NETROOMREV	NUMBER(30,4)	    NULL
	,SHIB_GROSSFBREV	NUMBER(30,4)	    NULL
	,SHIB_NETFBREV	NUMBER(30,4)	    NULL
	,SHIB_GROSSMISCREV	NUMBER(30,4)	    NULL
	,SHIB_NETMISCREV	NUMBER(30,4)	    NULL
	,SHIB_GROSSMINIBARREV	NUMBER(30,4)	    NULL
	,SHIB_NETMINIBARREV	NUMBER(30,4)	    NULL
	,SHIB_GROSSTELEREV	NUMBER(30,4)	    NULL
	,SHIB_NETTELEREV	NUMBER(30,4)	    NULL
	,SHIB_XCOU_ID	NUMBER(30)	    NULL
	,SHIB_WPHS_ID	NUMBER(30)	    NULL
	,SHIB_PARTNER_ID	NUMBER(30)	    NULL
	,SHIB_IMPORTED	NUMBER(1)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE SHIB ADD (
	CONSTRAINT SHIB_PK
	PRIMARY KEY
	            (
	             SHIB_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX SHIB_PARTNER_ID ON SHIB
	(
	  SHIB_PARTNER_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_WDAT_DATE ON SHIB
	(
	  SHIB_WDAT_DATE
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_WPHS_ID ON SHIB
	(
	  SHIB_WPHS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_XCOU_ID ON SHIB
	(
	  SHIB_XCOU_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_YBLH_ID ON SHIB
	(
	  SHIB_YBLH_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_YBML_1_XCMS_ID ON SHIB
	(
	  SHIB_YBML_1_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_YBML_2_XCMS_ID ON SHIB
	(
	  SHIB_YBML_2_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_YBML_3_XCMS_ID ON SHIB
	(
	  SHIB_YBML_3_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_YBML_4_XCMS_ID ON SHIB
	(
	  SHIB_YBML_4_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_YBML_5_XCMS_ID ON SHIB
	(
	  SHIB_YBML_5_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_YBML_6_XCMS_ID ON SHIB
	(
	  SHIB_YBML_6_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_YBML_7_XCMS_ID ON SHIB
	(
	  SHIB_YBML_7_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_YBOM_CON_YEST_ID ON SHIB
	(
	  SHIB_YBOM_CON_YEST_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_YBOM_ID ON SHIB
	(
	  SHIB_YBOM_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_YBOM_IND_XCMS_ID ON SHIB
	(
	  SHIB_YBOM_IND_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_YBOM_RMS_YEST_ID ON SHIB
	(
	  SHIB_YBOM_RMS_YEST_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_YBOM_XCMA_ID ON SHIB
	(
	  SHIB_YBOM_XCMA_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_YBOM_XCMS_ID ON SHIB
	(
	  SHIB_YBOM_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_YBOM_YFTY_ID ON SHIB
	(
	  SHIB_YBOM_YFTY_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_YBOM_YRAS_ID ON SHIB
	(
	  SHIB_YBOM_YRAS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_YGRP_ID ON SHIB
	(
	  SHIB_YGRP_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIB_ZFAC_ID ON SHIB
	(
	  SHIB_ZFAC_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  SHIE  */
CREATE TABLE SHIE (
	 SHIE_ID	NUMBER(30)	NOT NULL
	,SHIE_WDAT_DATE	DATE	NOT NULL
	,SHIE_YBOM_ID	NUMBER(30)	    NULL
	,SHIE_YEVM_ID	NUMBER(30)	    NULL
	,SHIE_YBOM_ZFAC_ID	NUMBER(30)	    NULL
	,SHIE_YEVM_STARTTIME	DATE	    NULL
	,SHIE_YEVM_ENDTIME	DATE	    NULL
	,SHIE_YEVM_YEST_ID	NUMBER(30)	    NULL
	,SHIE_YEST_SHORTDESC	VARCHAR2(3)	    NULL
	,SHIE_YEVM_NOOFATTENDEES	NUMBER(4)	    NULL
	,SHIE_YEVM_YETY_ID	NUMBER(30)	    NULL
	,SHIE_YETY_SHORTDESC	VARCHAR2(3)	    NULL
	,SHIE_YETY_LONGDESC	VARCHAR2(30)	    NULL
	,SHIE_EXPECTED_GROSSREV	NUMBER(30,4)	    NULL
	,SHIE_EXPECTED_NETREV	NUMBER(30,4)	    NULL
	,SHIE_FORECAST_GROSSREV	NUMBER(30,4)	    NULL
	,SHIE_FORECAST_NETREV	NUMBER(30,4)	    NULL
	,SHIE_POSTED_GROSSREV	NUMBER(30,4)	    NULL
	,SHIE_POSTED_NETREV	NUMBER(30,4)	    NULL
	,SHIE_GROSSROOMREV	NUMBER(30,4)	    NULL
	,SHIE_NETROOMREV	NUMBER(30,4)	    NULL
	,SHIE_GROSSFBREV	NUMBER(30,4)	    NULL
	,SHIE_NETFBREV	NUMBER(30,4)	    NULL
	,SHIE_GROSSMISCREV	NUMBER(30,4)	    NULL
	,SHIE_NETMISCREV	NUMBER(30,4)	    NULL
	,SHIE_GROSSMINIBARREV	NUMBER(30,4)	    NULL
	,SHIE_NETMINIBARREV	NUMBER(30,4)	    NULL
	,SHIE_GROSSTELEREV	NUMBER(30,4)	    NULL
	,SHIE_NETTELEREV	NUMBER(30,4)	    NULL
	,SHIE_WPHS_ID	NUMBER(30)	    NULL
	,SHIE_PARTNER_ID	NUMBER(30)	    NULL
	,SHIE_IMPORTED	NUMBER(1)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE SHIE ADD (
	CONSTRAINT SHIE_PK
	PRIMARY KEY
	            (
	             SHIE_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX SHIE_PARTNER_ID ON SHIE
	(
	  SHIE_PARTNER_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIE_WDAT_DATE ON SHIE
	(
	  SHIE_WDAT_DATE
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIE_WPHS_ID ON SHIE
	(
	  SHIE_WPHS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIE_YBOM_ID ON SHIE
	(
	  SHIE_YBOM_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIE_YBOM_ZFAC_ID ON SHIE
	(
	  SHIE_YBOM_ZFAC_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIE_YEVM_ID ON SHIE
	(
	  SHIE_YEVM_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIE_YEVM_YEST_ID ON SHIE
	(
	  SHIE_YEVM_YEST_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SHIE_YEVM_YETY_ID ON SHIE
	(
	  SHIE_YEVM_YETY_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  VERSION_8_7_0_0  */
CREATE TABLE VERSION_8_7_0_0 (
	 DUMMY	NUMBER	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;


/*  WMAT  */
CREATE TABLE WMAT (
	 WMAT_ID	NUMBER(30)	NOT NULL
	,WMAT_WLAN_ID	NUMBER(30)	NOT NULL
	,WMAT_STRING	VARCHAR2(200)	NOT NULL
	,WMAT_VALUE	VARCHAR2(200)	NOT NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE WMAT ADD (
	CONSTRAINT WMAT_PK
	PRIMARY KEY
	            (
	             WMAT_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;

/*  WQAN  */
CREATE TABLE WQAN (
	 WQAN_ID	NUMBER(30)	NOT NULL
	,WQAN_WQUE_ID	NUMBER(30)	NOT NULL
	,WQAN_SHORTDESC	VARCHAR2(60)	    NULL
	,WQAN_LONGDESC	VARCHAR2(200)	    NULL
	,WQAN_VALUE	NUMBER(10)	    NULL
	,WQAN_DISPLORDER	NUMBER(4)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE WQAN ADD (
	CONSTRAINT WQAN_PK
	PRIMARY KEY
	            (
	             WQAN_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX WQAN_WQUE_ID ON WQAN
	(
	  WQAN_WQUE_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  WQNL  */
CREATE TABLE WQNL (
	 WQNL_ID	NUMBER(30)	NOT NULL
	,WQNL_WQNR_ID	NUMBER(30)	    NULL
	,WQNL_WQUE_ID	NUMBER(30)	    NULL
	,WQNL_MULTICHOICE	NUMBER(1)	    NULL
	,WQNL_DISPLORDER	NUMBER(4)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE WQNL ADD (
	CONSTRAINT WQNL_PK
	PRIMARY KEY
	            (
	             WQNL_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX WQNL_WQNR_ID ON WQNL
	(
	  WQNL_WQNR_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX WQNL_WQUE_ID ON WQNL
	(
	  WQNL_WQUE_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  WQNR  */
CREATE TABLE WQNR (
	 WQNR_ID	NUMBER(30)	NOT NULL
	,WQNR_SHORTDESC	VARCHAR2(10)	    NULL
	,WQNR_LONGDESC	VARCHAR2(30)	    NULL
	,WQNR_INACTIVE	NUMBER(1)	    NULL
	,WQNR_DISPLORDER	NUMBER(4)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE WQNR ADD (
	CONSTRAINT WQNR_PK
	PRIMARY KEY
	            (
	             WQNR_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;

/*  WQUE  */
CREATE TABLE WQUE (
	 WQUE_ID	NUMBER(30)	NOT NULL
	,WQUE_QUESTIONTEXT	VARCHAR2(100)	    NULL
	,WQUE_DESCRIPTION	VARCHAR2(300)	    NULL
	,WQUE_INACTIVE	NUMBER(1)	    NULL
	,WQUE_DISPLORDER	NUMBER(4)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE WQUE ADD (
	CONSTRAINT WQUE_PK
	PRIMARY KEY
	            (
	             WQUE_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;

/*  WRXP  */
CREATE TABLE WRXP (
	 WRXP_ID	NUMBER(30)	NOT NULL
	,WRXP_SHORTDESC	VARCHAR2(3)	NOT NULL
	,WRXP_LONGDESC	VARCHAR2(30)	NOT NULL
	,WRXP_REGEXP	VARCHAR2(1000)	NOT NULL
	,WRXP_EXAMPLE	VARCHAR2(50)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE WRXP ADD (
	CONSTRAINT WRXP_PK
	PRIMARY KEY
	            (
	             WRXP_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;

/*  XSCD  */
CREATE TABLE XSCD (
	 XSCD_ID	NUMBER(30)	NOT NULL
	,XSCD_NAME	VARCHAR2(30)	NOT NULL
	,XSCD_TYPE	NUMBER(1)	NOT NULL
	,XSCD_DESTINATION	NUMBER(1)	NOT NULL
	,XSCD_OBJ_ID	NUMBER(30)	    NULL
	,XSCD_HTML_NAME	VARCHAR2(30)	    NULL
	,XSCD_RECIPIENT_LIST	VARCHAR2(300)	    NULL
	,XSCD_EXPORT_FORMAT	NUMBER(1)	    NULL
	,XSCD_WRPT_SUBJ_ID	NUMBER(30)	    NULL
	,XSCD_WRPT_BODY_ID	NUMBER(30)	    NULL
	,XSCD_FTP	VARCHAR2(100)	    NULL
	,XSCD_FTP_PORT	NUMBER(4)	    NULL
	,XSCD_FTP_USERNAME	VARCHAR2(100)	    NULL
	,XSCD_FTP_PASSWORD	VARCHAR2(100)	    NULL
	,XSCD_EXPORT_PATH	VARCHAR2(100)	    NULL
	,XSCD_RHYTHM	NUMBER(1)	    NULL
	,XSCD_TIME	DATE	    NULL
	,XSCD_DAYSOFWEEK	VARCHAR2(7) DEFAULT '0000000'	    NULL
	,XSCD_DAYOFMONTH	NUMBER(2)	    NULL
	,XSCD_LASTRUN	DATE	    NULL
	,XSCD_NEXTRUN	DATE	    NULL
	,XSCD_INACTIVE	NUMBER(1)	    NULL
	,XSCD_CONDITION	VARCHAR2(1000)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE XSCD ADD (
	CONSTRAINT XSCD_PK
	PRIMARY KEY
	            (
	             XSCD_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX XSCD_WRPT_BODY_ID ON XSCD
	(
	  XSCD_WRPT_BODY_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX XSCD_WRPT_SUBJ_ID ON XSCD
	(
	  XSCD_WRPT_SUBJ_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YETS  */
CREATE TABLE YETS (
	 YETS_ID	NUMBER(30)	NOT NULL
	,YETS_YETY_ID	NUMBER(30)	NOT NULL
	,YETS_YFSC_ID	NUMBER(30)	NOT NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YETS ADD (
	CONSTRAINT YETS_PK
	PRIMARY KEY
	            (
	             YETS_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE UNIQUE INDEX YETS_PK ON YETS
	(
	  YETS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YETS_YETY_ID ON YETS
	(
	  YETS_YETY_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YETS_YFSC_ID ON YETS
	(
	  YETS_YFSC_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YHSP  */
CREATE TABLE YHSP (
	 YHSP_ID	NUMBER(30)	NOT NULL
	,YHSP_DATE	DATE	    NULL
	,YHSP_ROOM	VARCHAR2(10)	    NULL
	,YHSP_ROOMTYPE	VARCHAR2(5)	    NULL
	,YHSP_STATUS	VARCHAR2(30)	    NULL
	,YHSP_SECTION	VARCHAR2(100)	    NULL
	,YHSP_CONDITION	VARCHAR2(100)	    NULL
	,YHSP_LASTHSKCHANGE	DATE	    NULL
	,YHSP_YRMS_ID	NUMBER(30)	NOT NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YHSP ADD (
	CONSTRAINT YHSP_PK
	PRIMARY KEY
	            (
	             YHSP_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;

/*  YPCF  */
CREATE TABLE YPCF (
	 YPCF_ID	NUMBER(30)	NOT NULL
	,YPCF_XCMS_ID	NUMBER(30)	NOT NULL
	,YPCF_FREETEXT1	VARCHAR2(2000)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YPCF ADD (
	CONSTRAINT YPCF_PK
	PRIMARY KEY
	            (
	             YPCF_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;

/*  YPKS  */
CREATE TABLE YPKS (
	 YPKS_ID	NUMBER(30)	NOT NULL
	,YPKS_YPKE_ID	NUMBER(30)	NOT NULL
	,YPKS_YFSC_ID	NUMBER(30)	NOT NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YPKS ADD (
	CONSTRAINT YPKS_PK
	PRIMARY KEY
	            (
	             YPKS_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE UNIQUE INDEX YPKS_PK ON YPKS
	(
	  YPKS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YPKS_YPKE_ID ON YPKS
	(
	  YPKS_YPKE_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YPKS_YFSC_ID ON YPKS
	(
	  YPKS_YFSC_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YPRG  */
CREATE TABLE YPRG (
	 YPRG_ID	NUMBER(30)	NOT NULL
	,YPRG_SHORTDESC	VARCHAR2(3)	NOT NULL
	,YPRG_LONGDESC	VARCHAR2(30)	NOT NULL
	,YPRG_DISPLORDER	NUMBER(4)	    NULL
	,YPRG_INACTIVE	NUMBER(1)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YPRG ADD (
	CONSTRAINT YPRG_PK
	PRIMARY KEY
	            (
	             YPRG_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;

/*  YRHV  */
CREATE TABLE YRHV (
	 YRHV_ID	NUMBER(30)	NOT NULL
	,YRHV_YRCH_ID	NUMBER(30)	NOT NULL
	,YRHV_YCAT_ID	NUMBER(30)	NOT NULL
	,YRHV_RATEDATE	DATE	NOT NULL
	,YRHV_RATETIME	NUMBER(2)	NOT NULL
	,YRHV_VALUE	NUMBER(10,4)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YRHV ADD (
	CONSTRAINT YRHV_PK
	PRIMARY KEY
	            (
	             YRHV_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX YRHV_RATEDATE ON YRHV
	(
	  YRHV_RATEDATE
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YRHV_RATETIME ON YRHV
	(
	  YRHV_RATETIME
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YRHV_YCAT_ID ON YRHV
	(
	  YRHV_YCAT_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YRHV_YRCH_ID ON YRHV
	(
	  YRHV_YRCH_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YRHX  */
CREATE TABLE YRHX (
	 YRHX_ID	NUMBER(30)	NOT NULL
	,YRHX_YRHV_ID	NUMBER(30)	NOT NULL
	,YRHX_XCAC_ID	NUMBER(30)	NOT NULL
	,YRHX_VALUE	NUMBER(10,4)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YRHX ADD (
	CONSTRAINT YRHX_PK
	PRIMARY KEY
	            (
	             YRHX_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX YRHX_XCAC_ID ON YRHX
	(
	  YRHX_XCAC_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YRHX_YRHV_ID ON YRHX
	(
	  YRHX_YRHV_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  ZALK  */
CREATE TABLE ZALK (
	 ZALK_ID	NUMBER(30)	NOT NULL
	,ZALK_AHDR_ID	NUMBER(30)	NOT NULL
	,ZALK_ZINV_ID	NUMBER(30)	NOT NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE ZALK ADD (
	CONSTRAINT ZALK_PK
	PRIMARY KEY
	            (
	             ZALK_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX ZALK_AHDR_ID ON ZALK
	(
	  ZALK_AHDR_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX ZALK_ZINV_ID ON ZALK
	(
	  ZALK_ZINV_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  ZWTR  */
CREATE TABLE ZWTR (
	 ZWTR_ID	NUMBER(30)	NOT NULL
	,ZWTR_MSG	NUMBER(2)	NOT NULL
	,ZWTR_INTF	NUMBER(2)	NOT NULL
	,ZWTR_XCMS_ID	NUMBER(30)	    NULL
	,ZWTR_YRES_ID	NUMBER(30)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE ZWTR ADD (
	CONSTRAINT ZWTR_PK
	PRIMARY KEY
	            (
	             ZWTR_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;

COMMIT;


/************************************************************************************************************************
*
*  The following statements will upgrade the COMMON tables
*
************************************************************************************************************************/


ALTER TABLE MBIL ADD ( MBIL_BITYPE NUMBER(1) NULL  );

ALTER TABLE MCFG ADD ( MCFG_DEBUG_MODE NUMBER(1) NULL  );

ALTER TABLE MMOD ADD ( MMOD_BLOCK_INC_TENT NUMBER(1) NULL  );

ALTER TABLE MMOD ADD ( MMOD_BLOCK_BOOKER NUMBER(30) NULL  );

ALTER TABLE MMOD ADD ( MMOD_CHK_AVL_TENT NUMBER(1) NULL  );

ALTER TABLE MMOD ADD ( MMOD_XCAC_ID NUMBER(30) NULL  );

ALTER TABLE SBUD ADD ( SBUD_MONTHVALUE2 NUMBER(30,4) NULL  );

ALTER TABLE SBUD ADD ( SBUD_YEARVALUE NUMBER(30,4) NULL  );

ALTER TABLE SHIS ADD ( SHIS_YBOM_ID NUMBER(30) NULL  );

ALTER TABLE WACT ADD ( WACT_POPUP NUMBER(1) DEFAULT 0 NULL  );

ALTER TABLE WALA ADD ( WALA_READ NUMBER(1) DEFAULT 0 NULL  );

ALTER TABLE WFFD ADD ( WFFD_SYSTEM NUMBER(1) NULL  );

ALTER TABLE WMAI ADD ( WMAI_CC VARCHAR2(128) NULL  );

ALTER TABLE WMAI ADD ( WMAI_BCC VARCHAR2(128) NULL  );

ALTER TABLE WMAI ADD ( WMAI_BLOCKSEND NUMBER(1) NULL  );

ALTER TABLE WPCA ADD ( WPCA_ENABLETELEPHONY NUMBER(1) NULL  );

ALTER TABLE WPCA ADD ( WPCA_TAPIPREDIAL NUMBER(1) NULL  );

ALTER TABLE WPCA ADD ( WPCA_DEFAULTTAPIADDRESS VARCHAR2(100) NULL  );

ALTER TABLE WPCA ADD ( WPCA_ENABLESKYPE NUMBER(1) NULL  );

ALTER TABLE WPCA ADD ( WPCA_SILENTSKYPE NUMBER(1) NULL  );

ALTER TABLE WTRL MODIFY ( WTRL_VALUE VARCHAR2(1000)  );

ALTER TABLE WTXT ADD ( WTXT_SIZE NUMBER(30) NULL  );

ALTER TABLE WVFD ADD ( WVFD_SYSTEM NUMBER(1) NULL  );

ALTER TABLE XCID ADD ( XCID_FAMILYMAILING NUMBER(1) DEFAULT 0 NULL  );

ALTER TABLE XCMS MODIFY ( XCMS_WEBLOGIN VARCHAR2(60)  );

ALTER TABLE XCMT ADD ( XCMT_WRXP_ID NUMBER(30) NULL  );

ALTER TABLE XECT ADD ( XECT_WRXP_ID NUMBER(30) NULL  );

ALTER TABLE YBLH ADD ( YBLH_ONLINEINTERFACEENABLE NUMBER(1) NULL  );

ALTER TABLE YBLH ADD ( YBLH_ONLINEINTERFACEENABLED NUMBER(1) NULL  );

ALTER TABLE YBLR DROP COLUMN YBLR_YBLH_ID;

ALTER TABLE YBLR ADD ( YBLR_YBLD_ID NUMBER(30) NOT NULL  );

ALTER TABLE YBOS ADD ( YBOS_YBLD_ID NUMBER(30) NULL  );

ALTER TABLE YCIT MODIFY ( YCIT_QUANTITY NUMBER(5)  );

ALTER TABLE YDET ADD ( YDET_NODISCOUNTPACKAGE NUMBER(30,4) DEFAULT 0 NOT NULL  );

ALTER TABLE YDET ADD ( YDET_FOREIGNNODISCOUNTPACKAGE NUMBER(30,4) DEFAULT 0 NOT NULL  );

ALTER TABLE YEBR MODIFY ( YEBR_QUANTITY NUMBER(5)  );

ALTER TABLE YEBR ADD ( YEBR_PERHOUR NUMBER(1) NULL  );

ALTER TABLE YEBS ADD ( YEBS_PERHOUR NUMBER(1) NULL  );

ALTER TABLE YFSC ADD ( YFSC_OCCUPANCY NUMBER(4,2) NULL  );

ALTER TABLE YPAC ADD ( YPAC_NODISCOUNT NUMBER(1) DEFAULT 0 NOT NULL  );

ALTER TABLE YPAC ADD ( YPAC_YPRG_ID NUMBER(30) NULL  );

ALTER TABLE YPAC ADD ( YPAC_SINGLEPERRES NUMBER(1) NULL  );

ALTER TABLE YPKR MODIFY ( YPKR_QUANTITY NUMBER(5)  );

ALTER TABLE YRCH ADD ( YRCH_WEBINFO VARCHAR2(1000) NULL  );

ALTER TABLE YRCO MODIFY ( YRCO_TIME DATE NULL  );

ALTER TABLE YRCO ADD ( YRCO_ALLOWSEND NUMBER(1) NULL  );

ALTER TABLE YRCO ADD ( YRCO_FAX_XCMS_ID NUMBER(30) NULL  );

ALTER TABLE YRES ADD ( YRES_CHKOUTSHARESTATUS NUMBER(1) NULL  );

ALTER TABLE YRES ADD ( YRES_LOCKROOM NUMBER(1) DEFAULT 0 NOT NULL  );

ALTER TABLE YRGP ADD ( YRGP_MULTIPLIER NUMBER(2) DEFAULT 1 NULL  );

ALTER TABLE ZDGT ADD ( ZDGT_WCOL_ID NUMBER(30) NULL  );

ALTER TABLE ZDMP ADD ( ZDMP_WCOL_ID NUMBER(30) NULL  );

ALTER TABLE ZFAG ADD ( ZFAG_IGNOREFISCAL NUMBER(1) NULL  );

ALTER TABLE ZWIN MODIFY ( ZWIN_ZWIT_ID NUMBER(30)  );

ALTER TABLE WFFD DROP COLUMN WFFD_DISPLAYORDER;

ALTER TABLE WVFD DROP COLUMN WVFD_ORG_ID;

ALTER TABLE WFFD DROP COLUMN WFFD_ORG_ID;

ALTER TABLE WVFF DROP COLUMN WVFF_ORG_ID;

ALTER TABLE WRED DROP COLUMN WRED_ORG_ID;

COMMIT;


/************************************************************************************************************************
*
*  The following statements will upgrade the indexes for the COMMON tables
*
************************************************************************************************************************/


/*  MMOD  */

CREATE INDEX MMOD_XCAC_ID ON MMOD
	(
	  MMOD_XCAC_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  WFFD  */

CREATE INDEX WFFD_FIELDNAME ON WFFD
	(
	  WFFD_FIELDNAME
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  WVFD  */

CREATE INDEX WVFD_VIEWNAME ON WVFD
	(
	  WVFD_VIEWNAME
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  XECT  */

CREATE INDEX XECT_WRXP_ID ON XECT
	(
	  XECT_WRXP_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  YBLR  */

DROP INDEX YBLR_YBLH_ID;
CREATE INDEX YBLR_YBLD_ID ON YBLR
	(
	  YBLR_YBLD_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  YBOS  */

CREATE INDEX YBOS_YBLD_ID ON YBOS
	(
	  YBOS_YBLD_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  YFRE  */

DROP INDEX YFRE_XCMS_GLOBALOD;
CREATE INDEX YFRE_XCMS_GLOBALID ON YFRE
	(
	  YFRE_XCMS_GLOBALID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  YPAC  */

CREATE INDEX YPAC_YPRG_ID ON YPAC
	(
	  YPAC_YPRG_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  YRCO  */

CREATE INDEX YRCO_FAX_XCMS_ID ON YRCO
	(
	  YRCO_FAX_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

COMMIT;


/************************************************************************************************************************
*
*  The following statements will update the data
*
************************************************************************************************************************/


update wvfd set wvfd_type_id=5 where wvfd_viewname='V8_MAILING_BLOCKS';

update wvfd set wvfd_type_id=5 where wvfd_viewname='V8_MAILING_GROUPS';

update wvfd set wvfd_type_id=5 where wvfd_viewname='V8_MAILING_RESERVATION';

update wvfd set wvfd_type_id=5 where wvfd_viewname='V8_MAILING_RESERVATION_INFOS';

update wvfd set wvfd_system=1 where wvfd_viewname='V8_MAILING_ACTIVITIES';

update wvfd set wvfd_system=1 where wvfd_viewname='V8_MAILING_BLOCKS';

update wvfd set wvfd_system=1 where wvfd_viewname='V8_MAILING_CONFERENCEBOOKING';

update wvfd set wvfd_system=1 where wvfd_viewname='V8_MAILING_CUSTOMERS';

update wvfd set wvfd_system=1 where wvfd_viewname='V8_MAILING_CUSTOMERS_ADDRESSES';

update wvfd set wvfd_system=1 where wvfd_viewname='V8_MAILING_CUSTOMERS_COMM';

update wvfd set wvfd_system=1 where wvfd_viewname='V8_MAILING_GROUPS';

update wvfd set wvfd_system=1 where wvfd_viewname='V8_MAILING_RESERVATION';

update wvfd set wvfd_system=1 where wvfd_viewname='V8_MAILING_RESERVATION_INFOS';

update wvfd set wvfd_system=1 where wvfd_viewname='V8_MAILING_RESERVATION_PROF';

update wvfd set wvfd_system=1
where wvfd_id in (
select v2.wvfd_id
from wvfd v1, wffd f1, wffd f2, wvfd v2
where v1.wvfd_id=f1.wffd_wvfd_id and nvl(v1.wvfd_system, 0)=1
and f1.wffd_relatedfield=f2.wffd_id and f2.wffd_wvfd_id=v2.wvfd_id
union
select v2.wvfd_id
from wvfd v1, wffd f1, wffd f2, wvfd v2
where v1.wvfd_id=f1.wffd_wvfd_id and nvl(v1.wvfd_system, 0)=1
and f1.wffd_relateddescription=f2.wffd_id and f2.wffd_wvfd_id=v2.wvfd_id
);

update wffd set wffd_system=1
where wffd_wvfd_id in 
(select wvfd_id from wvfd where nvl(wvfd_system, 0)=1);

update xcid set xcid_familymailing=1 
where xcid_id in 
(select xiil_from_xcms_id 
 from xiil, xclr
 where xiil_xclr_id=xclr_id and xclr_type in (1,2,3,4, 5) );

update xcms set xcms_active=4 where xcms_active=0 and xcms_mergedto_xcms_id is not null;

update ybos set ybos_ybld_id=(select ybld_id from ybld where ybld_date=ybos_date and ybld_yblh_id=ybos_yblh_id and ybld_ycat_id=ybos_ycat_id);

delete from ybos where not exists (select 1 from ybld where ybld_date=ybos_date and ybld_yblh_id=ybos_yblh_id and ybld_ycat_id=ybos_ycat_id);

alter table ybos modify ybos_ybld_id not null;

update yebs set yebs_perhour=1 where yebs_yfsr_id in (select yfsr_id from yfsr where nvl(yfsr_perhour,0)=1);

update yebr set yebr_perhour=1 where yebr_ycir_id in (select ycir_id from ycir where nvl(ycir_perhour,0)=1);

update zfag set zfag_ignorefiscal=0 where zfag_ignorefiscal is null;

update wusr set wusr_name='ReservationNew' where wusr_name='ReservationInsert';

update wusr set wusr_name='ReservationCancel' where wusr_name='ReservationDelete';

delete from wuss where wuss_name in ('Reservation check out ','AR Invoice Transfer ');

COMMIT;


/************************************************************************************************************************
*
*  The following statements will update the comments
*
************************************************************************************************************************/


COMMENT ON COLUMN MCFG.MCFG_HTTP_STATUS_INTERVAL IS 'Interval for sending status to ORS or other CRS';

COMMENT ON COLUMN MMOD.MMOD_HTTP_PROXYSERVER IS 'IP address of the Proxy Server';

COMMENT ON COLUMN MMOD.MMOD_HTTP_STATUS_URL IS 'URL for status message send by listener';

COMMENT ON COLUMN MMOD.MMOD_HTTP_STATUS_PROXYSERVER IS 'IP address of the Status Proxy Server';

COMMENT ON COLUMN MMOD.MMOD_HTTP_STATUS_PROXYUSER IS 'Proxy user for status message send by listener';

COMMENT ON COLUMN MMOD.MMOD_HTTP_STATUS_PROXYPWD IS 'Proxy password for status message send by listener';

COMMENT ON COLUMN MMOD.MMOD_RES_DOWNLOAD IS 'Indicates whether the mapper accepts reservation download';

COMMENT ON COLUMN MMOD.MMOD_RATES_DOWNLOAD IS 'Indicates whether the mapper accepts rate code download';

COMMENT ON COLUMN MMOD.MMOD_RAVL_DOWNLOAD IS 'Indicates whether the mapper accepts rate availability restriction download';

COMMENT ON COLUMN MMOD.MMOD_BLOCK_DOWNLOAD IS 'Indicates whether the mapper accepts allotment download';

COMMENT ON COLUMN MMAP.MMAP_CRS_ITEM_NAME IS 'Name of the item. For XML message format it is the node name.';

COMMENT ON COLUMN MMAP.MMAP_CRS_ITEM_POS IS 'Position of the item in the request file. Used by MyTravel';

COMMENT ON COLUMN MMAP.MMAP_FIELD_NAME IS 'The name of the field in yrcf or yrdf';

COMMENT ON COLUMN MMAP.MMAP_TABLE_NAME IS 'The table name of the field. Either YRCF or YRDF';

COMMENT ON COLUMN MMAP.MMAP_FIELD_SIZE IS 'Field size or precision, depending on the field type';

COMMENT ON COLUMN MMAP.MMAP_FIELD_SCALE IS 'Scale of the field, if oracle field type is number';

COMMENT ON COLUMN MMAP.MMAP_FIELD_TYPE IS 'Field type of the customer field: 0=Boolean, 1=Float, 2=Date, 3=String, 4=Integer ';

COMMENT ON COLUMN MMAP.MMAP_DESCRIPTION IS 'Field description';

COMMENT ON COLUMN XCID.XCID_FAM_ADDRGREET IS 'Family Address Greeting';

COMMENT ON COLUMN XCID.XCID_FAM_LETTGREET IS 'Family Letter Greeting';

COMMENT ON COLUMN XCID.XCID_FAM_NAME IS 'Family Name';

COMMENT ON COLUMN XCAG.XCAG_FAMILY IS '1= Family Greeting';

COMMENT ON COLUMN YBLP.YBLP_RESOURCE_TYPE IS 'resource type of booking which has posted amount - 1=package events | 2=function spaces | 3=misc. items  |5=menu items | 8= Standard Menu Split';

COMMENT ON COLUMN YBLP.YBLP_RESOURCE_ID IS 'id of posted resource - package events=ybef | function spaces=yebs | misc. items=yebr | standard menu split=ymrd |menu items=yemi';

COMMENT ON COLUMN MMAP.MMAP_ISATTRIBUTE IS 'Indicates in case of XML, whether value comes from an attribute or from a node';

COMMENT ON COLUMN MMAP.MMAP_RECORD_TYPE IS 'Indicates for MyTravel from which record type the custom field comes';

COMMENT ON COLUMN ZCCA.ZCCA_CHIP_PIN IS 'Indicates if this Credit Card Payment type supports Chip and Pin';

COMMENT ON COLUMN YGRT.YGRT_ROLE IS '1=PMS Groups  2=CCM Groups  3=Block Template(for future purpose, not implemented yet)';

COMMENT ON COLUMN YGRT.YGRT_YRCH_ID IS 'ratecode';

COMMENT ON COLUMN YGRT.YGRT_XCMA_ID IS 'marketcode';

COMMENT ON COLUMN YGRT.YGRT_SOU_ID IS 'Source code';

COMMENT ON COLUMN YGRT.YGRT_CHA_ID IS 'Channel code';

COMMENT ON COLUMN ZINN.ZINN_TYPE IS ' 1 = Invoices 	2 = User definable number cycles 3 = Currency Exchange (ZFAG_TYPE 3) 4 = Autonumber for Booth telephone charges paid cash 11 = Autonumber ZFAG_TYPE 1 (ar postings) 12 = Autonumber ZFAG_TYPE 2 (ar payments) 13 = Void Invoice 14 = Fattura (for Italy) 15 = Nota di Credito (for Italy or Credit Note for Greece or Portugal) 16 = Proforma 17 = Fattura and Nota di Credito (for Italy) 21 = Registration Cards 31 = Automatic FA Numbers (zfac_autonumber) 32 Lost and Found';

COMMENT ON COLUMN ZINV.ZINV_ROLE IS ' 0 or null = regular invoice |	1 = Deposit Folio | 2 = City Ledger Folio (not yet implemented) | 3 = Credit Note | 10 = Fattura Riepilogativa (used for Italy)';

COMMENT ON COLUMN YBLD.YBLD_TENTATIVE IS 'Used mainly in runtime when user planing to pickup rooms but process not finished';

COMMENT ON COLUMN YOUT.YOUT_ID IS 'Unique ID';

COMMENT ON COLUMN YOUT.YOUT_SHORTDESC IS 'Outlet Code';

COMMENT ON COLUMN YOUT.YOUT_LONGDESC IS 'Outlet Description';

COMMENT ON COLUMN YOUT.YOUT_MC_ID IS 'Link to MC outlet';

COMMENT ON TABLE YOUT IS 'Outlets';

COMMENT ON COLUMN YCMI.YCMI_MC_LONGDESC IS 'MC Product name';

COMMENT ON COLUMN YCMI.YCMI_MC_POS_IFC IS 'Link to MC interface';

COMMENT ON COLUMN YCMI.YCMI_TYPE IS '0=CCM; 1 Materials Control';

COMMENT ON COLUMN YCMC.YCMC_MC_ID IS 'Link to MC category';

COMMENT ON COLUMN YCMR.YCMR_DEFAULT IS 'Default Rate';

COMMENT ON COLUMN YCMR.YCMR_YOUT_ID IS 'Link to Outlet';

COMMENT ON COLUMN YCMR.YCMR_ZDCO_ID IS 'Link to Department Code';

COMMENT ON COLUMN YSMR.YSMR_DEFAULT IS 'Default Rate';

COMMENT ON COLUMN YSMR.YSMR_YOUT_ID IS 'Link to Outlet';

COMMENT ON COLUMN YFSC.YFSC_YOUT_ID IS 'Link to Outlet';

COMMENT ON COLUMN YCMR.YCMR_COSTPRICE IS 'Cost price';

COMMENT ON COLUMN YCMR.YCMR_MC_PRO_ID IS 'Link to interface';

COMMENT ON COLUMN YEMI.yemi_yout_id IS 'Link with outlet';

COMMENT ON COLUMN YEMI.yemi_costprice IS 'Cost price';

COMMENT ON COLUMN YEMN.yemn_yout_id IS 'Link to outlets';

COMMENT ON TABLE YRBR IS 'Default block borrowing configuration';

COMMENT ON COLUMN YRBR.YRBR_ID IS 'YRBR Primary key';

COMMENT ON COLUMN YRBR.YRBR_ORG_YCAT_ID IS 'Original room type';

COMMENT ON COLUMN YRBR.YRBR_BORROW_YCAT_ID IS 'Room type to be borrowed from';

COMMENT ON COLUMN XCMS.XCMS_CONTACTPREF IS 'Contact Preference > 0 - individual, 1 - company ';

COMMENT ON COLUMN WQFD.WQFD_ROPT IS 'Options for birthdare field 1- inhouse reservations; 2- not inhouse reservations';

COMMENT ON COLUMN XCAP.XCAP_CRYPTOGRAM  IS 'Cryptogram Information for chip cards';

COMMENT ON TABLE YCRF  IS ' Cross reference details recieved from the EFT systems';

COMMENT ON COLUMN WBCF.WBCF_CATEGORY IS '0,null=bcNone, 1=bcBillingHistory, 2=bcGuestChecks, 3=bcUserlog, 4=bcCorrespondence, 5=bcCashierClosure, 6=bcMoveLog, 7=bcINvoiceLink, 8=bcPostingComment' ;

COMMENT ON COLUMN WBCF.WBCF_BACKUP_TYPE IS '1=MOVE TO BACKUP USER, 2=DELETE FROM DB';

COMMENT ON COLUMN WBCF.WBCF_BACKUP_DAYS IS 'OLDER THAN (SYSTEMDATE - DAY)   WILL BE PROCESSED';

COMMENT ON COLUMN WBCF.WBCF_DELETE IS 'DELETE FROM BACKUP USER';

COMMENT ON COLUMN WBCF.WBCF_DELETE_DAYS IS 'OLDER THAN (SYSTEMDATE - DAY)   WILL BE PROCESSED';

COMMENT ON COLUMN XADR.XADR_VERIFIED IS '0(null) Adress was not verified by Address Doctor;-1 - Address was verified and found valid; 2 - Has to verified manualy. Batch validation failed; 3 - Address is not valid';

COMMENT ON COLUMN YRCH.YRCH_XPDA_ID IS 'Interest Code';

COMMENT ON COLUMN ZFAG.ZFAG_TYPE IS '0 = Financial Account (Paymaster) | 1 = AR Revenue Charges | 2 = AR Payments | 3 = Foreign Currency Exchange | 4 = for Booth telephone charges paid cash | 5 = Internal Interface Type for POS Accounts or Lost Posting Account, these financial accounts are getting checked in automatically after check out. | 6 = Petty Cash accounts | 7 = Transponder reading | 8 = Deposits, Cancellation and NoShow | 9 = Personal (Staff) Accounts (TI) | 10 = type for Dont close folio ';

COMMENT ON COLUMN WPHS.WPHS_CONFERENCEDIARY IS 'Display in conference diary';

COMMENT ON COLUMN YOUT.YOUT_INACTIVE IS '1= inactive';

COMMENT ON COLUMN MMOD.MMOD_WDAYS_OFFSET IS 'weekend days offset. In V8 start the week with Monday=1. Other CRS starts with Sunday=1';

COMMENT ON COLUMN MMOD.MMOD_VAT IS 'in case we get net values from CRS but we need gross, you can set the VAT percentage';

COMMENT ON COLUMN ZPOS.ZPOS_LEDGERSTATUS IS '0= posting made in the guest ledger;   1= posting made in the PreArrival ledger;   2= posting made in the PreArrival ledger and transferred to the guest ledger (at check-in for reservations, manually for fin. acc.);   3= adjustment and payment posting made in the city ledger (accounts receivable);   4= internal negative payment when city ledger gets paid (accounts receivable);   5= advance posting;   6= when advance posting is moved to guest ledger;';

COMMENT ON COLUMN ZDMP.ZDMP_WCOL_ID IS 'Color for buttons';

COMMENT ON COLUMN ZDGT.ZDGT_WCOL_ID IS 'Color for buttons';

COMMENT ON COLUMN YPAC.YPAC_NODISCOUNT IS 'Discount is not allowed on package (only vavilable if not percentage package)'; 

COMMENT ON COLUMN YRES.YRES_CREDITSTAT IS 'Obsolete field, not used anymore';

COMMENT ON COLUMN ZCCA.ZCCA_AUTH_VALID_DAYS IS 'Validity Time Period (number of Days) of an old active Authorisation, 0 value indicate no timeframe is applicable ';

COMMENT ON COLUMN XCAP.XCAP_VALIDUNTIL IS 'The Validity End date';

COMMENT ON COLUMN TAPR.TAPR_PRC_SYSDATE IS 'Process systemdate';

COMMENT ON COLUMN TAPR.TAPR_PRC_DATETIME IS 'Process date and time';

COMMENT ON COLUMN TAPR.TAPR_BILLING IS 'Process is created by Billing Screen TAP Posting';

COMMENT ON COLUMN TACD.TACD_COMMTYPE IS 'null,0 = per department code, 1= per night, 2= per stay, 3=manual,  4=Prepaid';

COMMENT ON TABLE TAPD IS 'TAP PROCESS LINK TABLE TO TAP COMMISSION DETAILS TO PROCESS TABLE';

COMMENT ON COLUMN TAPD.TAPD_VOID IS 'Rollback flag';

COMMENT ON COLUMN TAPD.TAPD_VOID_SYSDATE IS 'Rollback systemdate';

COMMENT ON COLUMN TAPD.TAPD_VOID_DATETIME IS 'Rollback date and time';

COMMENT ON COLUMN TACD.TACD_NOTE IS 'REASON OF MANUAL COMMISSION AMOUNT';
 
COMMENT ON COLUMN TACC.TACC_WRPT_ID IS 'ACCOUNT CHEQUE REPORT';

COMMENT ON COLUMN TACO.TACO_ZFAC_ID IS 'Commissions calculated for FA';

COMMENT ON COLUMN TACD.TACD_DELETEDATE IS 'Datetime of TACD deletion flag';

COMMENT ON COLUMN TACD.TACD_CALCDATE IS 'Datetime of TACD record insertion';

COMMENT ON COLUMN TACD.TACD_PROCESSEDATCHECK IS 'Obsolete column, not used anymore';

COMMENT ON COLUMN XCMS.XCMS_AUTOMERGEERRORID IS '0= error 1=merged to other profile remotely 2=profile was not uploaded because it has a match point higher than configured max match point 3=unique xmnr conflict 4=manual merge needed';

COMMENT ON COLUMN XCMS.XCMS_NO_HC_TRANSFER IS 'Dont Upload and Synchronize this in HC installation';

COMMENT ON COLUMN ZDGT.ZDGT_BESTPRICEROLE IS 'defines a grouping for best price finding';

COMMENT ON COLUMN PTLG.PTLG_TYPE IS '1-checkin, 2-Movement, 3-checkout';

COMMENT ON TABLE PTIK IS 'Ticket Configuration Header';

COMMENT ON TABLE PTPL IS 'Ticket Header - Ticket Detail Link';

COMMENT ON TABLE PTSQ IS 'Processing queue for TI IFC';

COMMENT ON COLUMN MCFG.MCFG_HTTP_UPLOAD_INTERVAL IS 'Time interval for trigger upload';

COMMENT ON COLUMN MMOD.MMOD_DL_REQ_BACKUP IS 'Indicates whether download requests should be backed up';

COMMENT ON COLUMN MMOD.MMOD_DL_RESP_BACKUP IS 'Indicates whether download responses should be backed up. If yes only those indicating not success';

COMMENT ON COLUMN MMOD.MMOD_UL_REQ_BACKUP IS 'Indicates whether the V8 trigger xml should be backed up';

COMMENT ON COLUMN MMOD.MMOD_UL_RESP_BACKUP IS 'Indicates whether upload messages should be backed up';

COMMENT ON COLUMN YHRD.YHRD_DELTA IS 'variation of the hurdle rate each time a reservation is made';

COMMENT ON COLUMN YHRD.YHRD_MAXHURDLEAMOUNT IS 'maximal value of the hurdle rate';

COMMENT ON COLUMN YHRD.YHRD_ORIGIN IS 'System originated this record. 0- TLP 1-Hurdle rates XML Interface';

COMMENT ON COLUMN YOVB.YOVB_ORIGIN IS ' Overbooking source: 0=V8 User, 1=TLP  2=XML Interface';

COMMENT ON TABLE RPRF IS 'Profiles linked to the table reservations.';

COMMENT ON COLUMN RPRF.RPRF_ID IS 'Link ID';

COMMENT ON COLUMN RPRF.RPRF_RRES_ID IS 'Table reservation ID';

COMMENT ON COLUMN RPRF.RPRF_XCMS_ID IS 'Profile ID';

COMMENT ON COLUMN YFVT.YFVT_WATY_ACTION IS '0.New Task  1. Task resolved';

COMMENT ON COLUMN YFSC.YFSC_OCCUPANCY IS 'Function Space Occupancy';

COMMENT ON COLUMN XRPC.XRPC_HASDIFFERENCE IS '0=no   1=yes';

COMMENT ON TABLE WRXP IS 'Regular Expression setup';

COMMENT ON COLUMN XCLR.XCLR_TYPE IS '1-Spouse, 2-next geneneration (descendant), 3-prev gen (predecessor), 4-siblings, 5-partners | for parents should be 3, for children 2';

COMMENT ON TABLE ZPO2 IS ' Storage for removed postings';

comment on column zpo2.zpo2_proforma is 'PROFORMA INVOICE NUMBER';

comment on column zpo2.zpo2_reverseexchrate is '0 means amount*exchrate=foreignamount. 1 means amount=foreignamount/exchrate. in fact it tells in which direction the exchange rate was entered by the user';

comment on column zpo2.zpo2_ztcd_id is 'link to the corresponding tax detail';

comment on column zpo2.zpo2_internalgroup_id is 'Internally used grouping to ease reading and working with excluded taxes';

comment on column zpo2.zpo2_noreprint is '0-Posting is not on a vlid folio | 1-The posting is printed on an invoice | 2-Posting is on a void invoice';

comment on column zpo2.zpo2_manualpost is '1-posting was made manually';

comment on column zpo2.zpo2_foreignprice is ' Posted Amount in ForeignPrice';

comment on column zpo2.zpo2_zcas_id is ' Cashier Number';

comment on column zpo2.zpo2_user_xcms_id is ' UserId of the user who charged this posting.';

comment on column zpo2.zpo2_originated_xcms_id is ' zpo2_ORIGINATED_XCMS_ID is of zpo2';

comment on column zpo2.zpo2_originated_yres_id is ' zpo2_ORIGINATED_YRES_ID is of zpo2';

comment on column zpo2.zpo2_originated_zfac_id is ' zpo2_ORIGINATED_ZFAC_ID is of zpo2';

comment on column zpo2.zpo2_zarr_id is ' zpo2_ZARR_ID is of zpo2';

comment on column zpo2.zpo2_comment is ' zpo2_COMMENT is of zpo2';

comment on column zpo2.zpo2_zart_id is ' zpo2_ZART_ID is of zpo2';

comment on column zpo2.zpo2_covers is ' number of restaurant covers (people)';

comment on column zpo2.zpo2_taxlink_id is ' Link Id between related records';

comment on column zpo2.zpo2_sumupid is ' zpo2_SUMUPID is the link of several postings from rate codes which are set up as weekly or monthly';

comment on column zpo2.zpo2_internalsplit_zpo2_id is ' ID of main zpo2 record for internal split, as for rate code splitting.';

comment on column zpo2.zpo2_cdt is ' 1 = debit 	2 = tax 	5 = credit (payment)';

comment on column zpo2.zpo2_phonenr is ' Dialed Phone Number, duplicated information for invoice printing, actual link to call history is handled differently';

comment on column zpo2.zpo2_manualsplit_id is ' zpo2_MANUALSPLIT_ID is of zpo2';

comment on column zpo2.zpo2_paidout is ' Flag for paid out posting. 1 = true, anything else = false';

comment on column zpo2.zpo2_zwin_id is ' zpo2_ZWIN_ID is of zpo2';

comment on column zpo2.zpo2_zall_id is ' zpo2_ZALL_ID is of zpo2';

comment on column zpo2.zpo2_ihst_id is ' Link to interface call history table';

comment on column zpo2.zpo2_ledgerstatus is ' 0= posting made in the guest ledger;  	1= posting made in the PreArrival ledger;  	2= posting made in the PreArrival ledger and transferred to the guest ledger (at check-in for reservations, manually for fin. acc.);  	3= posting made in the city ledger (accounts receivable) 	4=internal negative payment when city ledger gets paid 	5=advance posting 	6=when advance posting is moved to guest ledger 	7=when advance posting is moved to pre arrival Ledger';

comment on column zpo2.zpo2_sumupamount is ' summed up amount from zpo2_INTERNALSPLIT_ID + Taxes of internal Splits + Allowances. Speeds up invoice printing.';

comment on column zpo2.zpo2_pack_loss is ' 3 = allowance consumption 	2 = revenue between value and allowance (overage) 	1 = LOSS (For MINUS loss Postings on package allowances. These records are not taken in calculation for remaining allowance. 	4 = revenue exceeding the allowance (allowance) 	5 = package profit';

comment on column zpo2.zpo2_poscheck_nr is ' POS Check Number';

comment on column zpo2.zpo2_grossunitprice is ' zpo2_GROSSUNITPRICE is of zpo2';

comment on column zpo2.zpo2_grossforeignprice is ' zpo2_GROSSFOREIGNPRICE is of zpo2';

comment on column zpo2.zpo2_zche_id is ' Link to ZCHE Guest Check';

comment on column zpo2.zpo2_deposit is ' Filled if posted as revenue or tax department on deposit payment. Implemented for Parameter ''Latin American Deposit Handling''';

comment on column zpo2.zpo2_orgdate is 'for advance postings';

comment on column zpo2.zpo2_hidden is '0 - normal; 1 - do not show on screen; 2 - do not show on reports; 3 - do not show anywhere';

comment on column zpo2.zpo2_foreignsumupamount is ' summed up amount in foreign currency from zpo2_INTERNALSPLIT_ID + Taxes of internal Splits + Allowances. Speeds up invoice printing.';

comment on column zpo2.zpo2_id is ' Unique identifier of zpo2';

comment on column zpo2.zpo2_xcms_id is ' Link to Customer';

comment on column zpo2.zpo2_yres_id is ' Link to reservation 	Not {not null} for ZFAC postings';

comment on column zpo2.zpo2_zfac_id is ' zpo2_ZFAC_ID is of zpo2';

comment on column zpo2.zpo2_zdco_id is ' Link to Department Code';

comment on column zpo2.zpo2_zdc2_id is ' zpo2_ZDC2_ID is of zpo2';

comment on column zpo2.zpo2_unitprice is ' Unit Price must be multiplied with zpo2_QUANTITY';

comment on column zpo2.zpo2_quantity is ' zpo2_QUANTITY is of zpo2';

comment on column zpo2.zpo2_descript is ' Description, usually taken from Department Code description. Can be overwritten manually.';

comment on column zpo2.zpo2_postdate is ' Posting date (Fidelio date)';

comment on column zpo2.zpo2_pcdate is ' PC Date';

comment on column zpo2.zpo2_thirdpartydate is ' zpo2_THIRDPARTYDATE is of zpo2';

comment on column zpo2.zpo2_zcur_id is ' Link to Currency Table';

comment on column zpo2.zpo2_exchangerate is ' Exchange rate value';

COMMENT ON COLUMN ZFAG.ZFAG_SEND_IFC IS 'Shows if Room Key commands are sent to the IFC for this FA group';

COMMENT ON COLUMN WPCA.WPCA_BARCODEREADERPORT IS 'Barcode Reader COM Port number';

COMMENT ON COLUMN WPCA.WPCA_BARCODEREADERBAUD IS 'Barcode Reader Baud, 1=300 2=1200 3=2400 4=4800 5=9600 6=19200 7=38400 8=57600';

COMMENT ON TABLE CART IS 'Certificate articles';

COMMENT ON COLUMN CART.CART_ID IS 'Article ID';

COMMENT ON COLUMN CART.CART_NAME IS 'Article name';

COMMENT ON COLUMN CART.CART_TYPE IS 'Article type (depends on redemption system)';

COMMENT ON COLUMN CART.CART_PRICE IS 'Article price';

COMMENT ON COLUMN CART.CART_COUPONTEXT IS 'Coupon text';

COMMENT ON COLUMN CART.CART_COUPONDESCR IS 'Coupon description';

COMMENT ON COLUMN CART.CART_PAYMENT_ZDCO_ID IS 'Department code for payments';

COMMENT ON TABLE CRVD IS 'Certificate''s revenue departments';

COMMENT ON COLUMN CRVD.CRVD_ID IS 'Primary key';

COMMENT ON COLUMN CRVD.CRVD_CART_ID IS 'Link to the certificate';

COMMENT ON COLUMN CRVD.CRVD_ZDCO_ID IS 'Link to the department';

COMMENT ON TABLE COUP IS 'Gift coupon info';

COMMENT ON COLUMN COUP.COUP_ID IS 'Coupon ID';

COMMENT ON COLUMN COUP.COUP_NUMBER IS 'Complete number of the gift certificate ';

COMMENT ON COLUMN COUP.COUP_DESCRIPTION IS 'gift certificate description';

COMMENT ON COLUMN COUP.COUP_TEXT IS 'Text for the gift certificate ';

COMMENT ON COLUMN COUP.COUP_ISSUE IS 'Date of issue of the gift certificate ';

COMMENT ON COLUMN COUP.COUP_VALIDFROM IS 'Start of date where the gift certificate is valid ';

COMMENT ON COLUMN COUP.COUP_VALIDUNTIL IS 'End of date where the gift certificate is valid ';

COMMENT ON COLUMN COUP.COUP_CLEARINGDATE IS 'Date of clearing ';

COMMENT ON COLUMN COUP.COUP_XCMS_ID IS 'Guest Link';

COMMENT ON COLUMN COUP.COUP_CART_ID IS 'Article Link';

COMMENT ON COLUMN COUP.COUP_AMOUNT IS 'Amount of gift certificates ';

COMMENT ON COLUMN COUP.COUP_AMOUNTREDEEMED IS 'Amount which has been redeemed';

COMMENT ON TABLE CPOS IS 'List of postings linked to the voucher';

COMMENT ON COLUMN CPOS.CPOS_ID IS 'Primary key';

COMMENT ON COLUMN CPOS.CPOS_COUP_ID IS 'Voucher link';

COMMENT ON COLUMN CPOS.CPOS_ZPOS_ID IS 'Posting link';

COMMENT ON COLUMN ZRDF.ZRDF_BARCODE IS 'String associated with barcode (full string will contain global rebate prefix)';

COMMENT ON TABLE CBCC IS 'Barcode prefixes configuration';

COMMENT ON COLUMN CBCC.CBCC_ID IS 'CBCC ID';

COMMENT ON COLUMN CBCC.CBCC_ROLE IS '1 = Voucher 2 = Rebate';

COMMENT ON COLUMN CBCC.CBCC_REGEXP IS 'Regular expression to test';

COMMENT ON COLUMN CBCC.CBCC_DESC IS 'Description';

COMMENT ON COLUMN ZINV.ZINV_CORRECTING_ZINV_ID IS 'invoice has been corrected with a correction invoice, which id stored here';

COMMENT ON COLUMN ZINV.ZINV_ROLE IS ' 0 or null = regular invoice |	1 = Deposit Folio | 2 = City Ledger Folio (not yet implemented) | 3 = Credit Note, 31=Faktura Korekta (polish credit note)| 10 = Fattura Riepilogativa (used for Italy)';

COMMENT ON TABLE ZINK IS 'Table for special polish invoice correction report';

COMMENT ON COLUMN MMOD.MMOD_LINK_GRP_CODES IS 'indicates whether the attributes like rate, source, channel, market code for a res should taken from block';

COMMENT ON COLUMN WPCA.WPCA_IFCBUSI_LAST_TIME IS 'Timestamp, when ifcbusi loaded last time in this workstation';

COMMENT ON COLUMN WPCA.WPCA_IFCBUSI_LAST_VERSION IS 'Version Number of the last IfcBusi dll';

COMMENT ON COLUMN ZFAG.zfag_type IS '0 = Financial Account (Paymaster) | 1 = AR Revenue Charges | 2 = AR Payments | 3 = Foreign Currency Exchange | 4 = for Booth telephone charges paid cash | 5 = Internal Interface Type for POS Accounts or Lost Posting Account, these financial accounts are getting checked in automatically after check out. | 6 = Petty Cash accounts | 7 = Transponder reading | 8 = Deposits, Cancellation and NoShow | 9 = Personal (Staff) Accounts (TI) | 10 = type for Dont close folio | 11= Financial Account for automatic creation';

COMMENT ON COLUMN WDCG.WDCG_UPLOAD IS '1 if should be uploaded to master hotel';

COMMENT ON COLUMN WDCL.WDCL_WPHS_ID IS 'Hotel where document was created';

COMMENT ON COLUMN MMOD.MMOD_HTTP_PROVIDER_ID IS 'provider id for HTML submit functionality';

COMMENT ON COLUMN MMOD.MMOD_THRESHOLD IS 'indicates whether inventory upload also use threshold settings of room types';

COMMENT ON COLUMN YBLH.YBLH_ONLINEINTERFACEENABLED IS 'Used by Online Interfaces to decide whether third party system should be notified about changes of this block';

COMMENT ON COLUMN WVFD.WVFD_TYPE_ID IS ' 1=Customer information | 2=Customer Addresses | 3=Activities |4= Booking | 5= Reservation';

COMMENT ON COLUMN WACT.WACT_FROMMASTER IS ' 1= Downloaded from Master Hotel (Hotel Connenctor)';

COMMENT ON TABLE XJET IS 'JetWeb interface configuration table';

COMMENT ON TABLE XJNB IS 'JetWeb interface. Allocated registartion card number slots';

COMMENT ON COLUMN XJNB.XJNB_ID IS 'XJNB primary key';

COMMENT ON COLUMN XJNB.XJNB_MELDEBLATT_FROM IS 'Number start';

COMMENT ON COLUMN XJNB.XJNB_MELDEBLATT_TO IS 'number end';

COMMENT ON TABLE WMAT IS 'Mailing Translation';

COMMENT ON COLUMN WMAT.WMAT_ID IS 'Unique ID';

COMMENT ON COLUMN WMAT.WMAT_WLAN_ID IS 'Link to Languages';

COMMENT ON COLUMN WMAT.WMAT_STRING IS 'String to be translated';

COMMENT ON COLUMN WMAT.WMAT_VALUE IS 'Translated string';

COMMENT ON TABLE ZADR  IS 'Copy of the data on the moment of printing folio (Polish legal requirements)';

COMMENT ON TABLE ZNCR  IS 'Nota correction details (Polish legal requirements)';

COMMENT ON COLUMN ZINN.ZINN_TYPE IS ' 1 = Invoices  2 = User definable number cycles  3 = Currency Exchange (ZFAG_TYPE 3)  4 = Autonumber for Booth telephone charges paid cash  11 = Autonumber ZFAG_TYPE 1 (AR Postings)  12 = Autonumber ZFAG_TYPE 2 (AR Payments)  13 = Void Invoice  14 = Fattura (for Italy)  15 = Nota di Credito (for Italy or Credit Note for Greece or Portugal)  16 = Proforma  17 = Fattura and Nota di Credito (for Italy)  18 = Nota Korekta (for Poland)  21 = Registration Cards  31 = Automatic FA Numbers (zfac_autonumber)  32 = Lost and Found  33 = Police Export  34 = Tourist Export  35 = JetWeb Interface';

COMMENT ON COLUMN WLFG.WLFG_NOOFDAYS IS 'Default number of days';

COMMENT ON COLUMN XCMT.XCMT_TYPE IS ' 1=EMAIL  2=HOMEPAGE  3=TELEFAX  4=TELEPHONE ';

COMMENT ON COLUMN WRXP.WRXP_ID IS 'Unique ID';

COMMENT ON COLUMN WRXP.WRXP_SHORTDESC IS 'Regular Expression Code';

COMMENT ON COLUMN WRXP.WRXP_LONGDESC IS 'Regular Expression Description';

COMMENT ON COLUMN WRXP.WRXP_REGEXP IS 'Regular Expression Definition';

COMMENT ON COLUMN ZFAG.ZFAG_SEND_IFC IS 'Flag to Notify Key card Interface. 0(null) : Do not Notify the IFC,   1: Notify Interface but do not show make key screen, 2: Show make key screen and then Notify Interface';

COMMENT ON COLUMN yrch.yrch_WebInfo IS 'Rate info for Myfidelio Homepage';

COMMENT ON COLUMN xjet.XJET_USE_COUNTRY_CODE IS '0 = use XCOU_CUSTSHORTDESC 1 = XCOU_GVMNT_ID';

COMMENT ON TABLE XJLG IS 'JetWeb export log';

COMMENT ON COLUMN WVFD.WVFD_SYSTEM IS '1 = V8 system view';

COMMENT ON COLUMN WFFD.WFFD_SYSTEM IS '1 = V8 system field';

COMMENT ON TABLE YCEP IS 'Link table: Profiles linked to Calendar events';

COMMENT ON COLUMN XCID.XCID_FAMILYMAILING IS '1= Family mailing contact. More than one family member can be a mailing contact.';  

COMMENT ON TABLE YETS IS 'Link Functions Spaces / Event Types ';

COMMENT ON COLUMN YETS.YETS_ID IS 'Unique ID';

COMMENT ON COLUMN YETS.YETS_YETY_ID IS 'Link to Event Types';

COMMENT ON COLUMN YETS.YETS_YFSC_ID IS 'Link to Function Spaces';

COMMENT ON TABLE YPKS IS 'Link Functions Spaces / Package Events ';

COMMENT ON COLUMN YPKS.YPKS_ID IS 'Unique ID';

COMMENT ON COLUMN YPKS.YPKS_YPKE_ID IS 'Link to Conference Package Events';

COMMENT ON COLUMN YPKS.YPKS_YFSC_ID IS 'Link to Function Spaces';

COMMENT ON COLUMN XCMS.XCMS_ACTIVE IS '	1 = Yes | 0 = No | 3 = Terminated (emplyoees) | 4 = Merged';

COMMENT ON COLUMN SHIS.SHIS_YBOM_ID IS 'Linked CCM Booking ID. If more than 1 booking is linked to a FA ONLY the last linked YBOM_ID is filled ';

COMMENT ON TABLE SHIB IS ' History Matrix for CCM Bookings';

COMMENT ON COLUMN SHIB.SHIB_ID IS 'Unique ID';

COMMENT ON COLUMN SHIB.SHIB_WDAT_DATE IS 'WDAT_DATE';

COMMENT ON COLUMN SHIB.SHIB_YBOM_ID IS 'Booking ID';

COMMENT ON COLUMN SHIB.SHIB_ZFAC_ID IS 'Financial Account ID';

COMMENT ON COLUMN SHIB.SHIB_YBOM_ARRIVAL IS 'Arrival Date';

COMMENT ON COLUMN SHIB.SHIB_YBOM_DEPARTURE IS 'Departure Date';

COMMENT ON COLUMN SHIB.SHIB_YBOM_ARRIVAL_F IS '1= First Day';

COMMENT ON COLUMN SHIB.SHIB_YBOM_DEPARTURE_F IS '1= Last Day';

COMMENT ON COLUMN SHIB.SHIB_YBOM_CON_YEST_ID IS 'Conference Status ID';

COMMENT ON COLUMN SHIB.SHIB_YBOM_RMS_YEST_ID IS 'Rooms Status ID';

COMMENT ON COLUMN SHIB.SHIB_YBOM_CON_YEST_SHORTDESC IS 'Conference Status Code';

COMMENT ON COLUMN SHIB.SHIB_YBOM_RMS_YEST_SHORTDESC IS 'Rooms Status Code';

COMMENT ON COLUMN SHIB.SHIB_YBOM_XCMS_ID IS 'Company ID';

COMMENT ON COLUMN SHIB.SHIB_YBOM_COMPANY IS 'Company Name';

COMMENT ON COLUMN SHIB.SHIB_YBOM_IND_XCMS_ID IS 'Contact ID';

COMMENT ON COLUMN SHIB.SHIB_YBOM_CONTACT IS 'Contact Name';

COMMENT ON COLUMN SHIB.SHIB_YBOM_NOOFATTENDEES IS 'No. of attendees';

COMMENT ON COLUMN SHIB.SHIB_YBML_1_XCMS_ID IS 'Linked Company Profile ID. If more than 1 company has been linked ONLY the first linked company will be considered.';

COMMENT ON COLUMN SHIB.SHIB_COMPANYNAME IS 'Linked Company Name. If more than 1 company has been linked ONLY the first linked company will be considered.';

COMMENT ON COLUMN SHIB.SHIB_YBML_2_XCMS_ID IS 'Linked Travel Agent Profile ID. If more than 1 travel agent has been linked ONLY the first linked travel agent will be considered.';

COMMENT ON COLUMN SHIB.SHIB_TAGENTNAME IS 'Linked Travel Agent Name. If more than 1 travel agent has been linked ONLY the first linked travel agent will be considered.';

COMMENT ON COLUMN SHIB.SHIB_YBML_3_XCMS_ID IS 'Linked Source Profile ID. If more than 1 source has been linked ONLY the first linked source will be considered.';

COMMENT ON COLUMN SHIB.SHIB_SOURCENAME IS 'Linked Source Name. If more than 1 source has been linked ONLY the first linked source will be considered.';

COMMENT ON COLUMN SHIB.SHIB_YBML_4_XCMS_ID IS 'Linked Individual Profile ID. If more than 1 individual has been linked ONLY the first linked individual will be considered.';

COMMENT ON COLUMN SHIB.SHIB_INDNAME IS 'Linked Individual Name. If more than 1 individual has been linked ONLY the first linked individual will be considered.';

COMMENT ON COLUMN SHIB.SHIB_YBML_5_XCMS_ID IS 'Linked Vendor Profile ID. If more than 1 vendor has been linked ONLY the first linked vendor will be considered.';

COMMENT ON COLUMN SHIB.SHIB_VENDNAME IS 'Linked Vendor Name. If more than 1 vendor has been linked ONLY the first linked vendor will be considered.';

COMMENT ON COLUMN SHIB.SHIB_YBML_6_XCMS_ID IS 'Linked Meeting Planner Profile ID';

COMMENT ON COLUMN SHIB.SHIB_MPLANNAME IS 'Linked Meeting Planner Name';

COMMENT ON COLUMN SHIB.SHIB_YBML_7_XCMS_ID IS 'Linked Booker Profile ID';

COMMENT ON COLUMN SHIB.SHIB_BOOKERNAME IS 'Linked Booker Profile Name';

COMMENT ON COLUMN SHIB.SHIB_YGRP_ID IS 'Linked Group ID';

COMMENT ON COLUMN SHIB.SHIB_YGRP_NAME IS 'Linked Group Name';

COMMENT ON COLUMN SHIB.SHIB_YBLH_ID IS 'Linked Block ID';

COMMENT ON COLUMN SHIB.SHIB_YBLH_SHORTDESC IS 'Linked Block Code';

COMMENT ON COLUMN SHIB.SHIB_YBOM_YFTY_ID IS 'Linked Function Type ID';

COMMENT ON COLUMN SHIB.SHIB_YFTY_SHORTDESC IS 'Linked Function Type Code';

COMMENT ON COLUMN SHIB.SHIB_YFTY_LONGDESC IS 'Linked Function Type Description';

COMMENT ON COLUMN SHIB.SHIB_YBOM_XCMA_ID IS 'Linked Market Segment ID';

COMMENT ON COLUMN SHIB.SHIB_XCMA_SHORTDESC IS 'Linked Market Segment Code';

COMMENT ON COLUMN SHIB.SHIB_XCMA_LONGDESC IS 'Linked Market Segment Description';

COMMENT ON COLUMN SHIB.SHIB_YBOM_YRAS_ID IS 'Linked Source ID';

COMMENT ON COLUMN SHIB.SHIB_YRAS_SHORTDESC IS 'Linked Source Code';

COMMENT ON COLUMN SHIB.SHIB_YRAS_LONGDESC IS 'Linked Source Description';

COMMENT ON COLUMN SHIB.SHIB_XCED_ID_ACC IS 'Linked Account Mgr. ID';

COMMENT ON COLUMN SHIB.SHIB_XCED_ID_CONF IS 'Linked Conference Mgr. ID';

COMMENT ON COLUMN SHIB.SHIB_XCED_ID_RMS IS 'Linked Rooms Mgr. ID';

COMMENT ON COLUMN SHIB.SHIB_XCED_INITIALS_ACC IS 'Linked Account Mgr. Initial';

COMMENT ON COLUMN SHIB.SHIB_XCED_INITIALS_CONF IS 'Linked Conference Mgr. Initial';

COMMENT ON COLUMN SHIB.SHIB_XCED_INITIALS_RMS IS 'Linked Rooms Mgr. Initial';

COMMENT ON COLUMN SHIB.SHIB_XCED_NAME_ACC IS 'Linked Account Mgr. Name';

COMMENT ON COLUMN SHIB.SHIB_XCED_NAME_CONF IS 'Linked Conference Mgr. Name';

COMMENT ON COLUMN SHIB.SHIB_XCED_NAME_RMS IS 'Linked Rooms Mgr. Name';

COMMENT ON COLUMN SHIB.SHIB_EXPECTED_NETREV IS 'Net Expected of booking';

COMMENT ON COLUMN SHIB.SHIB_EXPECTED_GROSSREV IS 'Gross Expected of booking';

COMMENT ON COLUMN SHIB.SHIB_FORECAST_NETREV IS 'Net Forecast of booking';

COMMENT ON COLUMN SHIB.SHIB_FORECAST_GROSSREV IS 'Gross Forecast of booking';

COMMENT ON COLUMN SHIB.SHIB_POSTED_NETREV IS 'Net Posted of booking';

COMMENT ON COLUMN SHIB.SHIB_POSTED_GROSSREV IS 'Gross Posted of booking';

COMMENT ON COLUMN SHIB.SHIB_GROSSROOMREV IS 'Gross Revenue Rooms (ZDCO_STATS_TYPE=1)';

COMMENT ON COLUMN SHIB.SHIB_NETROOMREV IS 'Net Revenue Rooms (ZDCO_STATS_TYPE=1)';

COMMENT ON COLUMN SHIB.SHIB_GROSSFBREV IS 'Gross Revenue Food and Beverage (ZDCO_STATS_TYPE=2)';

COMMENT ON COLUMN SHIB.SHIB_NETFBREV IS 'Net Revenue Food and Beverage (ZDCO_STATS_TYPE=2)';

COMMENT ON COLUMN SHIB.SHIB_GROSSMINIBARREV IS 'Gross Revenue Minibar (ZDCO_STATS_TYPE=3)';

COMMENT ON COLUMN SHIB.SHIB_NETMINIBARREV IS ' Net Revenue Food and Beverage (ZDCO_STATS_TYPE=3)';

COMMENT ON COLUMN SHIB.SHIB_GROSSTELEREV IS 'Gross Revenue Telephone (ZDCO_STATS_TYPE=4)';

COMMENT ON COLUMN SHIB.SHIB_NETTELEREV IS 'Net Revenue Telephone (ZDCO_STATS_TYPE=4)';

COMMENT ON COLUMN SHIB.SHIB_GROSSMISCREV IS 'Gross Revenue Miscellaneous (ZDCO_STATS_TYPE=5)';

COMMENT ON COLUMN SHIB.SHIB_NETMISCREV IS 'Gross Revenue Miscellaneous (ZDCO_STATS_TYPE=5)';

COMMENT ON COLUMN SHIB.SHIB_XCOU_ID IS 'Country ID of Booker';

COMMENT ON COLUMN SHIB.SHIB_WPHS_ID IS 'Unique ID of partner hotel (Hotel Connector)';

COMMENT ON COLUMN SHIB.SHIB_PARTNER_ID IS 'SHIB_ID of Partner Hotel (Hotel Connector)';

COMMENT ON COLUMN SHIB.SHIB_IMPORTED IS 'Import control flag';

COMMENT ON TABLE SHIE IS ' History Matrix for CCM Events';

COMMENT ON COLUMN SHIE.SHIE_ID IS 'Unique ID';

COMMENT ON COLUMN SHIE.SHIE_WDAT_DATE IS 'WDAT_DATE. Start date of event. Only 1 records for each event.';

COMMENT ON COLUMN SHIE.SHIE_YBOM_ID IS 'Booking ID';

COMMENT ON COLUMN SHIE.SHIE_YEVM_ID IS 'Event ID';

COMMENT ON COLUMN SHIE.SHIE_YBOM_ZFAC_ID IS 'Booking Financial Account ID'; 

COMMENT ON COLUMN SHIE.SHIE_YEVM_STARTTIME IS 'Event Start Date'; 

COMMENT ON COLUMN SHIE.SHIE_YEVM_ENDTIME IS 'Event Start Date';

COMMENT ON COLUMN SHIE.SHIE_YEVM_YEST_ID IS 'Event Status ID';

COMMENT ON COLUMN SHIE.SHIE_YEST_SHORTDESC IS 'Event Status Code';

COMMENT ON COLUMN SHIE.SHIE_YEVM_NOOFATTENDEES IS 'No. of attendees';

COMMENT ON COLUMN SHIE.SHIE_YEVM_YETY_ID IS 'Linked Event Type';

COMMENT ON COLUMN SHIE.SHIE_YETY_SHORTDESC IS 'Event Type Code';

COMMENT ON COLUMN SHIE.SHIE_YETY_LONGDESC IS 'Event Type Description';

COMMENT ON COLUMN SHIE.SHIE_EXPECTED_NETREV IS 'Net Expected of event';

COMMENT ON COLUMN SHIE.SHIE_EXPECTED_GROSSREV IS 'Gross Expected of event';

COMMENT ON COLUMN SHIE.SHIE_FORECAST_NETREV IS 'Net Forecast of event';

COMMENT ON COLUMN SHIE.SHIE_FORECAST_GROSSREV IS 'Gross Forecast of event';

COMMENT ON COLUMN SHIE.SHIE_POSTED_NETREV IS 'Net Posted of event';

COMMENT ON COLUMN SHIE.SHIE_POSTED_GROSSREV IS 'Gross Posted of event';

COMMENT ON COLUMN SHIE.SHIE_GROSSROOMREV IS 'Gross Revenue Rooms (ZDCO_STATS_TYPE=1)';

COMMENT ON COLUMN SHIE.SHIE_NETROOMREV IS 'Net Revenue Rooms (ZDCO_STATS_TYPE=1)';

COMMENT ON COLUMN SHIE.SHIE_GROSSFBREV IS 'Gross Revenue Food and Beverage (ZDCO_STATS_TYPE=2)';

COMMENT ON COLUMN SHIE.SHIE_NETFBREV IS 'Net Revenue Food and Beverage (ZDCO_STATS_TYPE=2)';

COMMENT ON COLUMN SHIE.SHIE_GROSSMISCREV IS 'Gross Revenue Miscellaneous (ZDCO_STATS_TYPE=5)';

COMMENT ON COLUMN SHIE.SHIE_NETMISCREV IS 'Gross Revenue Miscellaneous (ZDCO_STATS_TYPE=5)';

COMMENT ON COLUMN SHIE.SHIE_GROSSMINIBARREV IS 'Gross Revenue Minibar (ZDCO_STATS_TYPE=3)';

COMMENT ON COLUMN SHIE.SHIE_NETMINIBARREV IS 'Net Revenue Minibar (ZDCO_STATS_TYPE=3)';

COMMENT ON COLUMN SHIE.SHIE_GROSSTELEREV IS 'Gross Revenue Telephone (ZDCO_STATS_TYPE=4)';

COMMENT ON COLUMN SHIE.SHIE_NETTELEREV IS 'Net Revenue Telephone (ZDCO_STATS_TYPE=4)';

COMMENT ON COLUMN SHIE.SHIE_WPHS_ID IS 'Unique ID of partner hotel (Hotel Connector)';

COMMENT ON COLUMN SHIE.SHIE_PARTNER_ID IS 'SHIE_ID of Partner Hotel (Hotel Connector)';

COMMENT ON COLUMN SHIE.SHIE_IMPORTED IS 'Import control flag';

COMMENT ON COLUMN WATG.WATG_ROLE IS ' 0 = Task and Activity, 2 = Trace, 3 = Billing Authorization, 4 = Locator, 5 = Automatic Traces, 6 = Hotel Maintenance, 7 = Logbook';

COMMENT ON COLUMN WALA.WALA_READ IS '1= Logbook entry has been read';  

COMMENT ON COLUMN WACT.WACT_POPUP IS '1= Logbook entry will pop up';

COMMENT ON TABLE WQNR IS 'QUESTIONNAIRE FORM';

COMMENT ON TABLE WQNL IS 'QUESTIONNAIRE FORM LINKTABLE TO QUESTIONS';

COMMENT ON COLUMN WQNL.WQNL_WQNR_ID IS 'LINK TO QUESTIONNAIRE FORM';

COMMENT ON COLUMN WQNL.WQNL_WQUE_ID IS 'LINK TO QUESTIONS ';

COMMENT ON COLUMN WQNL.WQNL_MULTICHOICE IS 'USER CAN SELECT MULTIPLE ANSWERS';

COMMENT ON TABLE WQUE IS 'QUESTIONS';

COMMENT ON TABLE WQAN IS 'ANSWERS';

COMMENT ON COLUMN WQAN.WQAN_VALUE IS 'THE MEASURE OF THE ANSWER ';

COMMENT ON TABLE YPRG IS 'Package Report Groups';

COMMENT ON COLUMN YPAC.YPAC_YPRG_ID  IS 'Package Report Group link';

COMMENT ON TABLE YRHV IS 'Rate Hourly Price Setup Table'; 

COMMENT ON TABLE YRHV IS 'Rate Hourly Price Setup Table child age price link table';

comment on table XSCD is 'Scheduled report runs';
	
comment on column XSCD.XSCD_NAME is 'Task name';

comment on column XSCD.XSCD_TYPE is 'Task type. 0 = Report, 1 = HTML, 2 = Export';

comment on column XSCD.XSCD_DESTINATION is 'Export destination, 0 = ftp 1 = email, 2 = file';

comment on column XSCD.XSCD_OBJ_ID is 'Linked object which has to be ran (wrpt_id or wnae_id)';

comment on column XSCD.XSCD_html_name is 'html file name';

comment on column XSCD.XSCD_Recipient_List is 'List of the email addresses of recipients';

comment on column XSCD.XSCD_WRPT_SUBJ_ID is 'Report which has to be taken as a subject line';

comment on column XSCD.XSCD_WRPT_BODY_ID is 'Report which has to be sent as a body';

comment on column XSCD.XSCD_ftp is 'FTP URL';

comment on column XSCD.XSCD_ftp_username is 'FTP username';

comment on column XSCD.XSCD_ftp_password is 'FTP password';

comment on column XSCD.XSCD_ftp_port is 'FTP port';

comment on column XSCD.XSCD_export_path is 'Export path';

comment on column XSCD.XSCD_Export_Format is '0 = TXT 1 = RTF 2 = PDF 3 = RTF';

comment on column XSCD.XSCD_Rhythm is '0 = Daily 1 = Weekly 2 = Monthly';

comment on column XSCD.XSCD_Time is 'Run time';

comment on column XSCD.XSCD_DaysOfWeek is '7 chars string indication if it should run on speicied day of week';

comment on column XSCD.XSCD_DayOfMonth is 'Day of month in case of monthly rhythm';

comment on column XSCD.XSCD_LastRun is 'Time of last run';

comment on column XSCD.XSCD_NextRun is 'Time of next run';

comment on column yrco.yrco_allowsend is 'if user has no right to send letters but allowsend=1 then employee can send the letter, 2=denied ';

comment on column wmai.wmai_blocksend is 'if user has no right to send letters or denied the send request then blocksend=1 otherwise 0 or null';

comment on table ahdr is 'Table for Egyptian A/R Invoice printing';

comment on table adet is 'Invoice detail table for Egyptian A/R Invoice printing';

comment on column zinv.zinv_role is ' 0 or null = regular invoice |	1 = Deposit Folio | 2 = City Ledger Folio (not yet implemented) | 3 = Credit Note, 31=Faktura Korekta (polish credit note)| 10 = Fattura Riepilogativa (used for Italy)| 4 - Egyptian A/R Invoice';

comment on column zinn.zinn_type is ' 1 = invoices, 2 = user definable number cycles, 3 = currency exchange (zfag_type 3), 4 = autonumber for booth telephone charges paid cash, 11 = autonumber zfag_type 1 (ar postings), 12 = autonumber zfag_type 2 (ar payments), 13 = void invoice, 14 = fattura (for italy), 15 = nota di credito (for italy or credit note for greece or portugal), 16 = proforma, 17 = fattura and nota di credito (for italy), 18 = nota korekta (for poland), 19 = Egyptian AR Invoice, 21 = registration cards, 31 = automatic fa numbers (zfac_autonumber), 32 = lost and found, 33 = police export, 34 = tourist export, 35 = jetweb interface';

comment on table zalk is 'Invoice link table for Egyptian A/R Invoice printing';

COMMENT ON COLUMN YEBS.YEBS_PERHOUR IS '1= hourly charge of rate';

COMMENT ON COLUMN YEBR.YEBR_PERHOUR IS '1= hourly charge of rate';

comment on column ypac.ypac_singleperres is 'If set package is linkable only to one guestprofile otherwise all guestprofiles can have the package';

comment on table zwtr is 'Offline notification of wellness interfaces';  

comment on column zwtr.ZWTR_MSG is 'Message type. 1 - Reservation changed 2 - Profile Changed 3 - Reservation cancel / Delete FA';

comment on column zwtr.ZWTR_INTF is 'Interface to notify. 1 - Bellavita 2 - HIS';

comment on column zwtr.ZWTR_XCMS_ID is 'Profile ID';

comment on column zwtr.ZWTR_YRES_ID is 'Reservation ID';

comment on column mmod.mmod_block_inc_tent is 'indicates whether also tentative bocks should be uploaded';

comment on column mmod.mmod_block_booker is 'default booker for blocks';

comment on table saar is 'HCN - Central Aging Report';

COMMENT ON COLUMN WRPS.wrps_role IS '1=Confirmation Letter| 2=Folio Layout| 3=Message Print| 4=Shift report| 5=Conference Confirmation| 6=Registration Card| 7=Currency Exchange| 8=AR Reminders| 9=Paid Outs| 10=Activities| 11=Deposit Receipts| 12=Group Confirmation| 13=Special Reports| 14=AR Statements| 15=Mailing Hitlists| 16=CCM Participant Lists| 17=AR Compression| 18=Petty Cash | 19=Profile Letters (Correspondence) | 20=ProfileStatistic | 21=TableReservation | 22=TableReservationList | 23=TAP | 24=NotaCorrection | 25=EmailTemplate | 26=RoomKeyLabel | 27=Logbook | 28=AREgyptianInvoice';  

comment on column mcfg.mcfg_debug_mode is 'indicates, whether ifc runs with fidelio debug mode';

COMMENT ON COLUMN YBLR.YBLR_YBLD_ID IS ' Links to Room Block Detail Table';

COMMENT ON COLUMN MMOD.MMOD_CHK_AVL_TENT IS 'indicates whether tentative values for room type availability check is used';

COMMENT ON COLUMN MMOD.MMOD_XCAC_ID IS 'Default child categorie for rate code down and upload';

COMMENT ON COLUMN WHIN.WHIN_PROGRAMSTATE IS ' Defined where this hint is called. 1 = after departure date (PMS) | 2 = after rate code (PMS) | 3 = at Check In | 4 = at Check Out | 5 = CheckOutBeforePayment | 6 = CheckOutAfterPayment | 7 = Room Move |8 = after arrival date (CCM) | 9 = after departure date (CCM) | 10 = after conference status (CCM) | 11 = after rooms satus (CCM)  ';

COMMENT ON COLUMN MBIL.MBIL_BITYPE IS '1 = Same Room';

COMMENT ON COLUMN SHIB.SHIB_EXPECTED_NETREV IS 'Net Expected of booking';

COMMENT ON COLUMN SHIB.SHIB_EXPECTED_GROSSREV IS 'Gross Expected of booking';

COMMENT ON COLUMN SHIE.SHIE_EXPECTED_NETREV IS 'Net Expected of event';

COMMENT ON COLUMN SHIE.SHIE_EXPECTED_GROSSREV IS 'Gross Expected of event';

COMMENT ON COLUMN WTXT.WTXT_SIZE IS 'Size of the stored data';

COMMENT ON COLUMN WHIN.WHIN_PROGRAMSTATE IS ' Defined where this hint is called. 1 = after departure date (PMS) | 2 = after rate code (PMS) | 3 = at Check In | 4 = at Check Out | 5 = CheckOutBeforePayment | 6 = CheckOutAfterPayment | 7 = Room Move |8 = after arrival date (CCM) | 9 = after departure date (CCM) | 10 = after conference status (CCM) | 11 = after rooms satus (CCM) | 12 = when editing booking (CCM) | 13 = when closing booking (CCM) | 14 = after event status (CCM) | 15 = after event type (CCM) | 16 = after event type (CCM) | 17 = when editing event (CCM) | 18 = when closing event (CCM) | 19 = when editing profile (CRM) | 20 = when closing profile (CRM)';

COMMENT ON COLUMN WPCA.WPCA_ENABLETELEPHONY IS '1 - enable telephony for this workstation'; 

COMMENT ON COLUMN WPCA.WPCA_TAPIPREDIAL IS 'predial number for outgoing calls';

COMMENT ON COLUMN WPCA.WPCA_DEFAULTTAPIADDRESS IS 'default tapi address to use for outgoing calls';

COMMENT ON COLUMN WPCA.WPCA_ENABLESKYPE IS '1 - enable skype support on this workstation';

COMMENT ON COLUMN WPCA.WPCA_SILENTSKYPE IS '1 - set silent mode for skype'; 

COMMIT;


--- End of DBDiff for Oracle --- Elapsed Time: 00:47:03 ---
