Crear reportes utilizando las Vistas de Opera Simple Report Writer

En el vídeo se muestra la creación de reportes desde el Opera. Para crear estos reportes no es necesario conocer de programación en Transact-SQL de Oracle, solo se debe conocer las columnas de las vistas asociadas al asistente:

View View en Base de datos
Reservations RESERVATION_GENERAL_VIEW
Profiles PROFILE_VIEW
Financial Transactions FINANCIAL_TRANSACTIONS_VIEW
Business Blocks EXP_SCBUSBLOCK_VIEW
Events EXP_SCEVENT_VIEW
Activities ACTIVITY_VIEW

El mejor canal de videos para aprender Opera a un nivel avanzado https://www.youtube.com/channel/UC4Dqw00Dn8_89k52YmnraHA

El detalle de las columnas de las Vistas de Opera Simple Report (OSR) se muestran a continuación:

Se muestran en un listado simple para permitir la búsqueda rápida de los campos que se requiere para la realización de reportes

OWNER TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LENGTH NULLABLE
OPERA RESERVATION_GENERAL_VIEW ACCOMPANYING_NAMES VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW ACCOMPANYING_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW ACTUAL_CHECK_IN_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW ACTUAL_CHECK_OUT_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW ADDRESSEE_NAME VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW ADDRESSEE_NAME_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW ADDRESS_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW ADULTS NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW ADULTS_TAX_FREE NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW ALIEN_REGISTRATION_NO VARCHAR2 30 Y
OPERA RESERVATION_GENERAL_VIEW ALLOTMENT_HEADER_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW ALLOTMENT_RECORD_TYPE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW AMENITY_ELIGIBLE_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW AMENITY_LEVEL_CODE VARCHAR2 40 Y
OPERA RESERVATION_GENERAL_VIEW AMOUNT_PERCENT NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW ANONYMIZATION_STATUS VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW APPROVAL_AMOUNT_CALC_METHOD NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW ARRIVAL DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW ARRIVAL_CARRIER_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW ARRIVAL_COMMENTS VARCHAR2 2000 Y
OPERA RESERVATION_GENERAL_VIEW ARRIVAL_DATE_TIME DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW ARRIVAL_ESTIMATE_TIME DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW ARRIVAL_STATION_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW ARRIVAL_SYSTEM_DATE_TIME DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW ARRIVAL_TIME VARCHAR2 10 Y
OPERA RESERVATION_GENERAL_VIEW ARRIVAL_TRANPORTATION_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW ARRIVAL_TRANSPORT_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW ARRIVAL_TRANSPORT_TYPE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW ASB_PRORATED_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW ATTACH_CC_TO_PROFILE CHAR 1 Y
OPERA RESERVATION_GENERAL_VIEW AUTHORISED_BILLING_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW AUTHORIZER_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW AUTO_CHECKIN_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW AUTO_SETTLE_DAYS NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW AUTO_SETTLE_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW AWARD_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW AWARD_CODE_1 VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW AWARD_CODE_2 VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW AWARD_CODE_3 VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW AWARD_CODE_4 VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW AWARD_CODE_5 VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW AWARD_MEMBERSHIP_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW AWARD_VOUCHER_1 VARCHAR2 80 Y
OPERA RESERVATION_GENERAL_VIEW AWARD_VOUCHER_2 VARCHAR2 80 Y
OPERA RESERVATION_GENERAL_VIEW AWARD_VOUCHER_3 VARCHAR2 80 Y
OPERA RESERVATION_GENERAL_VIEW AWARD_VOUCHER_4 VARCHAR2 80 Y
OPERA RESERVATION_GENERAL_VIEW AWARD_VOUCHER_5 VARCHAR2 80 Y
OPERA RESERVATION_GENERAL_VIEW AWD_UPGR_FROM VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW AWD_UPGR_TO VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW BALANCE NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW BASE_RATE_AMOUNT NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW BASE_RATE_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW BASE_RATE_CURRENCY_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW BILLING_CONTACT_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW BILLING_CONTACT_NAME VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW BIRTH_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW BIRTH_DATE_STR VARCHAR2 80 Y
OPERA RESERVATION_GENERAL_VIEW BLOCK_CODE VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW BLOCK_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW BLOCK_RESORT VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW BONUS_CHECK_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW BONUS_CHECK_NUMBER VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW BOOKED_ROOM_CATEGORY VARCHAR2 20 N
OPERA RESERVATION_GENERAL_VIEW BOOKED_ROOM_CATEGORY_LABEL VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW BREAK_TO_EMPTY_ROOM_YN VARCHAR2 0 Y
OPERA RESERVATION_GENERAL_VIEW BUSINESS_DATE_CREATED DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW BUSINESS_TITLE VARCHAR2 80 Y
OPERA RESERVATION_GENERAL_VIEW BXGY_DISCOUNT_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW CANCELLATION_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW CANCELLATION_NO VARCHAR2 50 Y
OPERA RESERVATION_GENERAL_VIEW CANCELLATION_REASON_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW CANCELLATION_REASON_DESC VARCHAR2 2000 Y
OPERA RESERVATION_GENERAL_VIEW CARD_USAGE NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW CHANNEL VARCHAR2 40 Y
OPERA RESERVATION_GENERAL_VIEW CHECKIN_DURATION NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW CHILDREN NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW CHILDREN_TAX_FREE NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW CHILDREN1 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW CHILDREN2 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW CHILDREN3 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW CHILDREN4 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW CHILDREN5 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW COMMENTS VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW COMMISSIONABLE_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW COMMISSION_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW COMMISSION_PAID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW COMMISSION_PAYOUT_TO VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW COMPANY_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW COMPANY_NAME VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW COMPLIMENTARY_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW COMP_TYPE_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW COMPUTED_RESV_STATUS VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW CONFIRMATION_LEG_NO NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW CONFIRMATION_LETTER VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW CONFIRMATION_LETTER_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW CONFIRMATION_NO VARCHAR2 50 Y
OPERA RESERVATION_GENERAL_VIEW CONSUMER_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW CONTACT_NAME_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW CREDIT_CARD_EXP_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW CREDIT_CARD_EXP_DATE_STR VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW CREDIT_CARD_HOLDER_NAME VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW CREDIT_CARD_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW CREDIT_CARD_NUMBER VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW CREDIT_CARD_NUMBER_STR VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW CREDIT_CARD_NUMBER_4_DIGITS VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW CREDIT_CARD_PURGED_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW CREDIT_CARD_TYPE VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW CREDIT_CARD_VAULT_ID VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW CREDIT_LIMIT NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW CRIBS NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW CURRENCY_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW CUSTOM_REFERENCE VARCHAR2 50 Y
OPERA RESERVATION_GENERAL_VIEW DATE_OF_ARRIVAL_IN_COUNTRY DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW DEPARTURE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW DEPARTURE_CARRIER_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW DEPARTURE_COMMENTS VARCHAR2 2000 Y
OPERA RESERVATION_GENERAL_VIEW DEPARTURE_DATE_TIME DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW DEPARTURE_ESTIMATE_TIME DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW DEPARTURE_STATION_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW DEPARTURE_TIME VARCHAR2 10 Y
OPERA RESERVATION_GENERAL_VIEW DEPARTURE_TRANSPORTATION_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW DEPARTURE_TRANSPORT_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW DEPARTURE_TRANSPORT_TYPE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW DIRECT_BILL_VERIFY_RESPONSE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW DISCOUNT_AMT NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW DISCOUNT_PRCNT NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW DISCOUNT_REASON_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW DISPLAY_COLOR VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW DO_NOT_MOVE_ROOM VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW DO_NOT_MOVE_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW DO_NOT_UPDATE_PROFILE VARCHAR2 0 Y
OPERA RESERVATION_GENERAL_VIEW EFFECTIVE_RATE_AMOUNT NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW ELIGIBLE_FOR_UPGRADE_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW EMAIL_ADDRESS VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW EMAIL_FOLIO_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW ENTRY_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW ENTRY_POINT VARCHAR2 40 Y
OPERA RESERVATION_GENERAL_VIEW EVENT_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW EXCHANGE_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW EXCHANGE_POSTING_TYPE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW EXCHANGE_RATE VARCHAR2 0 Y
OPERA RESERVATION_GENERAL_VIEW EXTENSION_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW EXTERNAL_EFOLIO_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW EXTERNAL_LEG_NO NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW EXTERNAL_REFERENCE VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW EXTERNAL_REFERENCE_TYPE VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW EXTN_NUMBER VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW EXTN_TYPE VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW EXTRA_BEDS NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW EXT_SEG_NO NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW EXT_SEQ_NO NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW FB_REVENUE NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW FINANCIALLY_RESPONSIBLE_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW FIRST_NIGHT_UPSELL NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW FIXED_CHARGE NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW FIXED_RATE_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW FOLIO_CLOSE_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW FOLIO_TEXT1 VARCHAR2 2000 Y
OPERA RESERVATION_GENERAL_VIEW FOLIO_TEXT2 VARCHAR2 2000 Y
OPERA RESERVATION_GENERAL_VIEW FOLIO_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW FREE_NIGHTS_STAY_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW GDS_RECORD_LOCATOR VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW GROUP_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW GROUP_NAME VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW GUARANTEE_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW GUARANTEE_CODE_DESC VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_COUNTRY VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_COUNTRY_DESC VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_EMAIL VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_FIRST_NAME VARCHAR2 80 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_FIRST_NAME_SDX VARCHAR2 80 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_LANGUAGE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_LANGUAGE_DESC VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_LAST_NAME_SDX VARCHAR2 80 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_MIDDLE_NAME VARCHAR2 40 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_NAME VARCHAR2 80 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_NAME_ID NUMBER 22 N
OPERA RESERVATION_GENERAL_VIEW GUEST_PHONE VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_PRIV_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_SIGNATURE VARCHAR2 3000 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_STATUS VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_TITLE VARCHAR2 40 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_TITLE_DESC VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_TYPE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW GUEST_VIP_DESC VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW HAS_ANY_SHARE_FIXED_RATE_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW HK_EXPECTED_SERVICE_TIME VARCHAR2 11 Y
OPERA RESERVATION_GENERAL_VIEW HK_YCHOICE_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW HOUSE_USE_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW HURDLE NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW HURDLE_OVERRIDE VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW IMMIGRATION_STATUS VARCHAR2 40 Y
OPERA RESERVATION_GENERAL_VIEW IN_PERSON_TO_SHARE_WITH VARCHAR2 0 Y
OPERA RESERVATION_GENERAL_VIEW INSERT_DATE DATE 7 N
OPERA RESERVATION_GENERAL_VIEW INSERT_USER NUMBER 22 N
OPERA RESERVATION_GENERAL_VIEW INTERMEDIARY_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW INV_ITEM_CODES VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW INV_ITEM_IDS VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW IS_UPSOLD_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW KEY_OPTIONS VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW KEY_VALID_UNTIL DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW LAST_DIRECT_BILL_BATCH_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW LAST_ONLINE_PRINT_SEQ NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW LAST_PERIODIC_FOLIO_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW LAST_ROOM VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW LAST_SETTLE_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW LOCAL_BASE_RATE_AMOUNT NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW LOCATOR_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MAINTAIN_ROOM_FEATURES CHAR 1 Y
OPERA RESERVATION_GENERAL_VIEW MARKET_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW MARKET_DESC VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MASTER_SHARE VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW MEALPLAN_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MEMBERSHIP_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW MEMBERSHIP_LEVEL VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MEMBERSHIP_NUMBER VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MEMBERSHIP_RANK NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW MEMBERSHIP_TYPE VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MESSAGE_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MOBILE_AUDIO_KEY_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW MOBILE_CHKIN_ALLOWED VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MOBILE_CHKOUT_ALLOWED VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MOBILE_PREFERRED_CURRENCY VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MOBILE_VIEW_FOLIO_ALLOWED VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_ADULTS_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_BILLING_CONTACT_ID_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_BLOCKS_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_BOOKED_ROOM_CAT_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_CHILDREN_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_COMM_CODE_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_COMMENTS_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_COMPANY_ID_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_CRIBS_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_CURRENCY_CODE_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_DISCOUNT_AMT_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_DISCOUNT_PRCNT_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_EXTENSIONS_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_FIXED_RATE VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_GROUP_ID_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_MARKET_CODE_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_MEMBERSHIPS_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_ORIGIN_OF_BOOKING_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_PTS_ELIGIBILITY_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_RATE_CODE_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_RESV_CONTACT_ID_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_ROOM_CATEGORY_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_ROOM_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_SEGMENTS_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_SHARE_AMOUNT_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_SOURCE_ID_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_TRAVEL_AGENT_ID_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_XBEDS_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MULTIPLE_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW MY_ROOM_RATE NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW NAME_TAX_DESCRIPTION VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW NAME_TAX_TYPE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW NAME_TYPE VARCHAR2 20 N
OPERA RESERVATION_GENERAL_VIEW NAME_USAGE_TYPE VARCHAR2 20 N
OPERA RESERVATION_GENERAL_VIEW NATIONALITY VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW NEXT_DESTINATION VARCHAR2 300 Y
OPERA RESERVATION_GENERAL_VIEW NIGHTS NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW NO_OF_ROOMS NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW OPT_IN_BATCH_FOL_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW ORG_ROOM_CATEGORY VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW ORG_ROOM_CATEGORY_LABEL VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW ORG_STAY_COST NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW ORIGINAL_ARRIVAL DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW ORIGINAL_BASE_RATE NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW ORIGINAL_END_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW ORIGIN_OF_BOOKING VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW ORIGIN_OF_BOOKING_DESC VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW OVERRIDE_INVENTORY_YN VARCHAR2 0 Y
OPERA RESERVATION_GENERAL_VIEW OVERRIDE_TURNDOWN_FLAG_YN CHAR 1 Y
OPERA RESERVATION_GENERAL_VIEW OWNER_FF_FLAG VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW PARENT_RESV_NAME_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW PARTY_CODE VARCHAR2 50 Y
OPERA RESERVATION_GENERAL_VIEW PASSPORT VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW PASSPORT_STR VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW PAYMENT_AMOUNT NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW PAYMENT_METHOD VARCHAR2 50 Y
OPERA RESERVATION_GENERAL_VIEW PAYMENT_METHOD_DESC VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW PERIODIC_FOLIO_FREQ NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW PHONE_DISPLAY_NAME_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW PHONE_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW PHYSICAL_QUANTITY NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW POINTS NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW POINTS_ELIGIBILITY_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW POINTS_ELIGIBILITY_DESC VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW POST_CHARGING_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW POST_CO_FLAG VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW POSTING_ALLOWED_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW PRE_CHARGING_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW PREFERRED_ROOM_TYPE VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW PRE_REGISTERED_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW PRINT_RATE_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW PRODUCTS VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW PROF_LOYALTY_SEGMENT_CODES VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW PROMOTIONS VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW PSUEDO_ROOM_TYPE VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW PURGE_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW PURPOSE_OF_STAY VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW QUOTE_ID VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW RATEABLE_VALUE NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW RATE_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW RDEN_BILLING_CONTACT_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW RDEN_RESERVATION_DATE DATE 7 N
OPERA RESERVATION_GENERAL_VIEW RDEN_RESORT VARCHAR2 20 N
OPERA RESERVATION_GENERAL_VIEW RDEN_RESV_CONTACT_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW RECALCULATE_RATE_YN VARCHAR2 0 Y
OPERA RESERVATION_GENERAL_VIEW REFERRAL_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW REGISTRATION_CARD_NO VARCHAR2 40 Y
OPERA RESERVATION_GENERAL_VIEW REINSTATE_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW REINSTATE_YN VARCHAR2 0 Y
OPERA RESERVATION_GENERAL_VIEW RESERVATION_DATE DATE 7 N
OPERA RESERVATION_GENERAL_VIEW RESERVATION_PREFERENCES VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW RES_INSERT_SOURCE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW RES_INSERT_SOURCE_TYPE VARCHAR2 40 Y
OPERA RESERVATION_GENERAL_VIEW RESORT VARCHAR2 20 N
OPERA RESERVATION_GENERAL_VIEW RESTRICTION_OVERRIDE VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW RESV_CL_DESTINATION VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW RESV_CL_DESTINATION_ID VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW RESV_CONF_LETTER_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW RESV_CONF_LETTER_LTA DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW RESV_CONF_LETTER_STATUS VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW RESV_CONTACT_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW RESV_CONTACT_NAME VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW RESV_LOYALTY_SEGMENT_CODES VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW RESV_NAME_ID NUMBER 22 N
OPERA RESERVATION_GENERAL_VIEW RESV_NO NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW RESV_STATUS VARCHAR2 20 N
OPERA RESERVATION_GENERAL_VIEW REVENUE_TYPE_CODE VARCHAR2 2000 Y
OPERA RESERVATION_GENERAL_VIEW RN_BILLING_CONTACT_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW RN_RESV_CONTACT_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW ROOM VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW ROOM_CATEGORY VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW ROOM_CATEGORY_LABEL VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW ROOM_CLASS VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW ROOM_COST NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW ROOM_FEATURES VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW ROOM_INSTRUCTIONS VARCHAR2 2000 Y
OPERA RESERVATION_GENERAL_VIEW ROOM_RESORT VARCHAR2 20 N
OPERA RESERVATION_GENERAL_VIEW ROOM_REVENUE NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW ROOM_SERVICE_TIME VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW ROUTING_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW SCHEDULE_CHECKOUT_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW SFIRST_GUEST_NAME VARCHAR2 80 Y
OPERA RESERVATION_GENERAL_VIEW SGUEST_NAME VARCHAR2 80 Y
OPERA RESERVATION_GENERAL_VIEW SHARE_AMOUNT NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW SHARED_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW SHARE_ID NUMBER 22 N
OPERA RESERVATION_GENERAL_VIEW SHARE_PRCNT NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW SHARE_SEQ_NO NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW SNAME VARCHAR2 80 N
OPERA RESERVATION_GENERAL_VIEW SOURCE_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW SOURCE_NAME VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW SPECIAL_REQUESTS VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW SPG_DISCLOSE_ROOM_TYPE_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW SPG_SUITE_NIGHT_AWARD_STATUS VARCHAR2 40 Y
OPERA RESERVATION_GENERAL_VIEW SPG_UPGRADE_CONFIRMED_ROOMTYPE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW SPG_UPGRADE_REASON_CODE VARCHAR2 40 Y
OPERA RESERVATION_GENERAL_VIEW SPLIT_FROM_RESV_NAME_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW STATISTICAL_RATE_TIER NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW STATISTICAL_ROOM_LABEL VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW STATISTICAL_ROOM_TYPE NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW SUITE_WITH VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW SUPER_SEARCH_INDEX_TEXT VARCHAR2 100 Y
OPERA RESERVATION_GENERAL_VIEW SWCARD_ISSUE_NUMBER VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW SWCARD_START_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW SXFIRST_NAME VARCHAR2 80 Y
OPERA RESERVATION_GENERAL_VIEW SXNAME VARCHAR2 80 Y
OPERA RESERVATION_GENERAL_VIEW SYS_STATUS VARCHAR2 7 Y
OPERA RESERVATION_GENERAL_VIEW TA_RECORD_LOCATOR VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW TAX_EXEMPT_NO VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW TAX_NO_OF_STAYS NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW TAX_REGISTRATION_NO NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW TIAD VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW TOTAL_REVENUE NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW TOTAL_STAY_COST_AFTER_UPSELL NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW TOTAL_UPSELL_CHARGE NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW TRACE_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW TRAVEL_AGENT_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW TRAVEL_AGENT_NAME VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW TRUNC_ACTUAL_CHECK_OUT_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW TRUNC_ARRIVAL DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW TRUNC_DEPARTURE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW TURNDOWN_STATUS VARCHAR2 2 Y
OPERA RESERVATION_GENERAL_VIEW TURNDOWN_YN VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW UDFC01 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC02 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC03 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC04 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC05 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC06 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC07 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC08 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC09 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC10 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC11 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC12 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC13 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC14 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC15 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC16 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC17 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC18 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC19 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC20 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC21 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC22 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC23 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC24 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC25 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC26 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC27 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC28 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC29 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC30 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC31 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC32 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC33 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC34 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC35 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC36 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC37 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC38 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC39 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFC40 VARCHAR2 200 Y
OPERA RESERVATION_GENERAL_VIEW UDFD01 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD02 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD03 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD04 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD05 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD06 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD07 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD08 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD09 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD10 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD11 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD12 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD13 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD14 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD15 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD16 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD17 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD18 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD19 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFD20 DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW UDFN01 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN02 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN03 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN04 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN05 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN06 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN07 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN08 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN09 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN10 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN11 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN12 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN13 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN14 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN15 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN16 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN17 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN18 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN19 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN20 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN21 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN22 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN23 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN24 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN25 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN26 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN27 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN28 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN29 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN30 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN31 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN32 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN33 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN34 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN35 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN36 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN37 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN38 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN39 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UDFN40 NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UNI_CARD_ID VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW UPDATE_DATE DATE 7 N
OPERA RESERVATION_GENERAL_VIEW UPDATE_USER NUMBER 22 N
OPERA RESERVATION_GENERAL_VIEW UPSELL_CHARGE NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UPSELL_RULE_CODE VARCHAR2 4000 Y
OPERA RESERVATION_GENERAL_VIEW UPSELL_RULE_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW UPSOLD_BY_USER_ID NUMBER 22 Y
OPERA RESERVATION_GENERAL_VIEW VIDEO_CHECKOUT_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW VIP VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW VISA_EXPIRATION_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW VISA_ISSUE_DATE DATE 7 Y
OPERA RESERVATION_GENERAL_VIEW VISA_NUMBER VARCHAR2 40 Y
OPERA RESERVATION_GENERAL_VIEW VISA_VALIDITY_TYPE VARCHAR2 40 Y
OPERA RESERVATION_GENERAL_VIEW WALKIN_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW WL_PRIORITY VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW WL_REASON_CODE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW WL_REASON_DESCRIPTION VARCHAR2 2000 Y
OPERA RESERVATION_GENERAL_VIEW WL_TELEPHONE_NO VARCHAR2 40 Y
OPERA RESERVATION_GENERAL_VIEW XCOMPANY_NAME VARCHAR2 80 Y
OPERA RESERVATION_GENERAL_VIEW XFIRST_NAME VARCHAR2 40 Y
OPERA RESERVATION_GENERAL_VIEW XLANGUAGE VARCHAR2 20 Y
OPERA RESERVATION_GENERAL_VIEW XLAST_NAME VARCHAR2 40 Y
OPERA RESERVATION_GENERAL_VIEW XSALUTATION VARCHAR2 60 Y
OPERA RESERVATION_GENERAL_VIEW XTITLE VARCHAR2 40 Y
OPERA RESERVATION_GENERAL_VIEW YIELDABLE_YN VARCHAR2 1 Y
OPERA RESERVATION_GENERAL_VIEW YM_CODE VARCHAR2 20 Y
OWNER TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LENGTH NULLABLE
OPERA PROFILE_VIEW F_BILLINST VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_COMMISSION VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_CURRENCY VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_DEFADDRTYPE VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_EDITACCOUNTTYPE VARCHAR2 20 Y
OPERA PROFILE_VIEW F_EDITACCTCONTACT VARCHAR2 40 Y
OPERA PROFILE_VIEW F_EDITADDRESS_ID NUMBER 22 Y
OPERA PROFILE_VIEW F_EDITADDRESS11 VARCHAR2 80 Y
OPERA PROFILE_VIEW F_EDITADDRESS12 VARCHAR2 80 Y
OPERA PROFILE_VIEW F_EDITADDRTYPE VARCHAR2 20 Y
OPERA PROFILE_VIEW F_EDITARNO VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_EDITAVOV VARCHAR2 1 Y
OPERA PROFILE_VIEW F_EDITBLMSG VARCHAR2 2000 Y
OPERA PROFILE_VIEW F_EDITCITY VARCHAR2 40 Y
OPERA PROFILE_VIEW F_EDITCOMM_PAY_CENTRAL VARCHAR2 1 Y
OPERA PROFILE_VIEW F_EDITCONTRACTNO VARCHAR2 40 Y
OPERA PROFILE_VIEW F_EDITCOUNTRY VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_EDITCOUNTRY_CODE VARCHAR2 20 Y
OPERA PROFILE_VIEW F_EDITCREATED DATE 7 N
OPERA PROFILE_VIEW F_EDITCRS_NAMEID NUMBER 22 Y
OPERA PROFILE_VIEW F_EDITDATEOFBIRTH1 DATE 7 Y
OPERA PROFILE_VIEW F_EDITFAX VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_EDITFAX_ID NUMBER 22 Y
OPERA PROFILE_VIEW F_EDITFIRSTNAME1 VARCHAR2 40 Y
OPERA PROFILE_VIEW F_EDITIATATYPE VARCHAR2 20 Y
OPERA PROFILE_VIEW F_EDITINDUSTRYCODE VARCHAR2 2000 Y
OPERA PROFILE_VIEW F_EDITLANGUAGE VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_EDITLANGUAGE_CODE VARCHAR2 20 Y
OPERA PROFILE_VIEW F_EDITLONGNAME VARCHAR2 60 Y
OPERA PROFILE_VIEW F_EDITMEMBER VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_EDITMEMBERLEVEL VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_EDITMEMBERTYPE VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_EDITNAME1 VARCHAR2 80 Y
OPERA PROFILE_VIEW F_EDITNATIONALITY VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_EDITNATIONALITY_CODE VARCHAR2 20 Y
OPERA PROFILE_VIEW F_EDITNOTICE VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_EDITPASSPORT VARCHAR2 200 Y
OPERA PROFILE_VIEW F_EDITPHONE_ID NUMBER 22 Y
OPERA PROFILE_VIEW F_EDITPOSTALCODE VARCHAR2 15 Y
OPERA PROFILE_VIEW F_EDITPOTREV NUMBER 22 Y
OPERA PROFILE_VIEW F_EDITPOTRMNTS NUMBER 22 Y
OPERA PROFILE_VIEW F_EDITPROFILENO VARCHAR2 20 Y
OPERA PROFILE_VIEW F_EDITRECEIVED DATE 7 Y
OPERA PROFILE_VIEW F_EDITSALESREP VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_EDITSAVEHISTORY VARCHAR2 1 Y
OPERA PROFILE_VIEW F_EDITSHORTNAME VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_EDITSHORTNAME_CODE VARCHAR2 40 Y
OPERA PROFILE_VIEW F_EDITSTATE VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_EDITSTATE_CODE VARCHAR2 40 Y
OPERA PROFILE_VIEW F_EDITSUMMREFCC VARCHAR2 20 Y
OPERA PROFILE_VIEW F_EDITTAX1_NO VARCHAR2 40 Y
OPERA PROFILE_VIEW F_EDITTAX2_NO VARCHAR2 40 Y
OPERA PROFILE_VIEW F_EDITTELEPHONE1 VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_EDITTITLE VARCHAR2 80 Y
OPERA PROFILE_VIEW F_EDITTYPE VARCHAR2 20 N
OPERA PROFILE_VIEW F_EDITUPDATED DATE 7 N
OPERA PROFILE_VIEW F_EDITUPDATEID VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_EDITUSERID VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_EDITVIP VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_EDITVIP_CODE VARCHAR2 20 Y
OPERA PROFILE_VIEW F_INTEREST VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_MAILING VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_MAILING_FLAG VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_PROTECTED VARCHAR2 20 Y
OPERA PROFILE_VIEW F_RATECODE VARCHAR2 4000 Y
OPERA PROFILE_VIEW F_RGSPECIAL VARCHAR2 1 Y
OPERA PROFILE_VIEW NAME_ID NUMBER 22 N
OPERA PROFILE_VIEW UDFC01 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC02 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC03 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC04 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC05 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC06 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC07 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC08 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC09 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC10 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC11 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC12 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC13 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC14 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC15 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC16 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC17 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC18 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC19 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC20 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC21 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC22 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC23 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC24 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC25 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC26 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC27 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC28 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC29 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC30 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC31 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC32 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC33 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC34 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC35 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC36 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC37 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC38 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC39 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFC40 VARCHAR2 200 Y
OPERA PROFILE_VIEW UDFD01 DATE 7 Y
OPERA PROFILE_VIEW UDFD02 DATE 7 Y
OPERA PROFILE_VIEW UDFD03 DATE 7 Y
OPERA PROFILE_VIEW UDFD04 DATE 7 Y
OPERA PROFILE_VIEW UDFD05 DATE 7 Y
OPERA PROFILE_VIEW UDFD06 DATE 7 Y
OPERA PROFILE_VIEW UDFD07 DATE 7 Y
OPERA PROFILE_VIEW UDFD08 DATE 7 Y
OPERA PROFILE_VIEW UDFD09 DATE 7 Y
OPERA PROFILE_VIEW UDFD10 DATE 7 Y
OPERA PROFILE_VIEW UDFD11 DATE 7 Y
OPERA PROFILE_VIEW UDFD12 DATE 7 Y
OPERA PROFILE_VIEW UDFD13 DATE 7 Y
OPERA PROFILE_VIEW UDFD14 DATE 7 Y
OPERA PROFILE_VIEW UDFD15 DATE 7 Y
OPERA PROFILE_VIEW UDFD16 DATE 7 Y
OPERA PROFILE_VIEW UDFD17 DATE 7 Y
OPERA PROFILE_VIEW UDFD18 DATE 7 Y
OPERA PROFILE_VIEW UDFD19 DATE 7 Y
OPERA PROFILE_VIEW UDFD20 DATE 7 Y
OPERA PROFILE_VIEW UDFN01 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN02 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN03 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN04 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN05 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN06 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN07 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN08 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN09 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN10 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN11 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN12 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN13 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN14 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN15 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN16 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN17 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN18 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN19 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN20 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN21 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN22 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN23 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN24 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN25 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN26 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN27 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN28 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN29 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN30 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN31 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN32 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN33 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN34 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN35 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN36 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN37 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN38 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN39 NUMBER 22 Y
OPERA PROFILE_VIEW UDFN40 NUMBER 22 Y
OWNER TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LENGTH NULLABLE
OPERA FINANCIAL_TRANSACTIONS_VIEW ACCOUNTING_CODE VARCHAR2 40 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ACC_TYPE_FLAG VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ACTUAL_EXCHANGE_RATE NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ACTUAL_POSTING_DATE_TIME VARCHAR2 75 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ADVANCE_BILL_REVERSED_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ADVANCE_BILL_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ADV_GENERATE_ADJUSTMENT VARCHAR2 10 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ADV_GENERATE_TRX_CODE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW APPROVAL_CODE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW APPROVAL_DATE DATE 7 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW APPROVAL_STATUS VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW APPROVAL_STATUS_DESC VARCHAR2 4000 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW APP_USER VARCHAR2 40 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW AR_LED_CREDIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW AR_LED_DEBIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW AR_NUMBER NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ARRANGEMENT_CODE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ARRANGEMENT_ID NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ARRANGEMENT_TYPE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW AR_STATE VARCHAR2 2 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ARTICLE_CODE VARCHAR2 4000 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ARTICLE_ID NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW AR_TRANSFER_DATE DATE 7 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ASB_FLAG VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ASB_ONLY_POST_TAXES_ONCE_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ASB_TAX_FLAG VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ASSOCIATED_TRX_NO NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW AUTHORIZER_ID NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW AUTO_CREDITBILL_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW AUTO_SETTLE_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW BILL_NO NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW BONUS_CHECK_ID NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW BUSINESS_DATE DATE 7 N
OPERA FINANCIAL_TRANSACTIONS_VIEW CASHIER_CREDIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW CASHIER_DEBIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW CASHIER_ID NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW CASHIER_NAME VARCHAR2 2000 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW CC_CODE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW CC_REFUND_POSTING VARCHAR2 30 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW CC_TYPE VARCHAR2 2 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW CHANGE_DUE NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW CHEQUE_NUMBER VARCHAR2 200 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW CLOSURE_NO NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW COMP_LINK_TRX_CODE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW COMP_LINK_TRX_NO NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW COMPRESSED_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW COMP_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW CORRECTION_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW COVERS VARCHAR2 10 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW CREDIT_CARD_ID NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW CURRENCY VARCHAR2 20 N
OPERA FINANCIAL_TRANSACTIONS_VIEW DEFERRED_TAXES_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW DEFERRED_YN VARCHAR2 1 N
OPERA FINANCIAL_TRANSACTIONS_VIEW DEP_GROSS_AMOUNT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW DEP_LED_CREDIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW DEP_LED_DEBIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW DEP_NET_AMOUNT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW DEP_NET_TAX_AMT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW DEPOSIT_TRANSACTION_ID VARCHAR2 40 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW DEP_POSTING_FLAG VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW DEP_TAX_TRANSFERED_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW DISPLAY_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ELECTRONIC_VOUCHER_NO NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW EURO_EXCHANGE_RATE NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW EXCHANGE_DIFFERENCE_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW EXCHANGE_RATE NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW FBA_CERTIFICATE_NUMBER VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW FIN_DML_SEQ_NO NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW FISCAL_BILL_NO VARCHAR2 40 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW FIXED_CHARGES_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW FOLIO_NO NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW FOLIO_TYPE VARCHAR2 100 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW FOLIO_VIEW NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW FOOD_REVENUE NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW FOOD_REVENUE_TAX NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW FOREX_COMM_AMOUNT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW FOREX_COMM_PERC NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW FOREX_TYPE VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW FROM_RESV_ID NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW FT_SUBTYPE CHAR 5 N
OPERA FINANCIAL_TRANSACTIONS_VIEW GP_AWARD_CANCEL_CODE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW GP_AWARD_CODE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW GROSS_AMOUNT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW GUEST_ACCOUNT_CREDIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW GUEST_ACCOUNT_DEBIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW INC_TAX_DEDUCTED_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IND_ADJUSTMENT_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IND_CASH VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW INH_CREDIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW INH_DEBIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW INSERT_DATE DATE 7 N
OPERA FINANCIAL_TRANSACTIONS_VIEW INSERT_USER NUMBER 22 N
OPERA FINANCIAL_TRANSACTIONS_VIEW INSTALLMENTS NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW INTERNAL_DB_PAYMENTS NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW INTERNAL_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW INVOICE_CLOSE_DATE DATE 7 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW INVOICE_NO NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW INVOICE_TYPE VARCHAR2 2 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IS_CREDIT_01 NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IS_DEBIT_01 NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IS_EXCL_PROFIT_LOSS_YN CHAR 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IS_FOOD_GENERATE_01 NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IS_FOOD_01 NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IS_INTERNAL_PKG_TAX_YN VARCHAR2 4000 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IS_INTERNAL_YN CHAR 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IS_NON_REVENUE_GENERATE_01 NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IS_NON_REVENUE_01 NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IS_OTHER_GENERATE_01 NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IS_OTHER_01 NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IS_PACKAGE_01 NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IS_REVENUE_01 NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IS_ROOM_GENERATE_01 NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IS_ROOM_01 NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW IS_TAX_01 NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW LINK_TRX_NO NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW MARKET_CODE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW MEMBERSHIP_ID NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW NAME_ID NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW NAME_TAX_TYPE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW NET_AMOUNT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW NON_REVENUE NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW NON_REVENUE_AMOUNT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW NON_REVENUE_TAX NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW NUMBER_DIALED VARCHAR2 40 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ORG_AR_LED_DEBIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ORG_POSTED_AMOUNT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ORIGINAL_RESV_NAME_ID NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW OTHER_REVENUE NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW OTHER_REVENUE_TAX NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW OWNER_LED_CREDIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW OWNER_LED_DEBIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW PACKAGE_ALLOWANCE NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW PACKAGE_ARRANGEMENT_CODE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW PACKAGE_CREDIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW PACKAGE_DEBIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW PARALLEL_CURRENCY VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW PARALLEL_GUEST_CREDIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW PARALLEL_GUEST_DEBIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW PASSERBY_NAME VARCHAR2 4000 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW POSTED_AMOUNT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW POSTING_DATE DATE 7 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW POSTING_RHYTHM VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW POSTING_TYPE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW POSTIT_NO NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW POSTIT_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW PRICE_PER_UNIT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW PRODUCT VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW PROFIT_LOSS_FLAG VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW PROPERTY_BILL_PREFIX VARCHAR2 30 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW QUANTITY NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW QUANTITY_CODE VARCHAR2 40 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW RATE_CODE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW REASON_CODE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW RECPT_NO NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW RECPT_TYPE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW REFERENCE VARCHAR2 2000 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW REMARK VARCHAR2 2000 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW RESORT VARCHAR2 20 N
OPERA FINANCIAL_TRANSACTIONS_VIEW RESV_NAME_ID NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW REVENUE_AMT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW REVERSE_PAYMENT_TRX_NO NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW REVISION_NO NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ROOM VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ROOM_CLASS VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ROOM_NTS_EFFECTIVE NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ROOM_REVENUE NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ROOM_REVENUE_TAX NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ROOM_TYPE VARCHAR2 4000 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ROUTED_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW ROUTING_INSTRN_ID NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW SETTLEMENT_FLAG VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW SOURCE_CODE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW SUMM_REF_CODE VARCHAR2 4000 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TA_COMMISSIONABLE_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TARGET_RESORT VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TAX_ELEMENTS VARCHAR2 300 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TAX_GENERATED_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TAX_INCLUSIVE_YN VARCHAR2 1 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TAX_RATE NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TAX_RATE_TYPE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TB_AMOUNT_GROSS NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TB_AMOUNT_NET NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TC_GROUP VARCHAR2 20 N
OPERA FINANCIAL_TRANSACTIONS_VIEW TC_SUBGROUP VARCHAR2 20 N
OPERA FINANCIAL_TRANSACTIONS_VIEW TC_TRANSACTION_TYPE CHAR 5 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW THRESHOLD_DIVERSION_ID NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW THRESHOLD_ENTITY_QTY NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW THRESHOLD_ENTITY_TYPE VARCHAR2 30 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW THRESHOLD_TREATMENT_FLAG VARCHAR2 30 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TOTAL_REVENUE NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TOTAL_REVENUE_TAX NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TRAN_ACTION_ID NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TRANSACTION_DESCRIPTION VARCHAR2 2000 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TRNS_ACTIVITY_DATE DATE 7 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TRNS_FROM_ACCT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TRNS_TO_ACCT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TRX_AMOUNT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TRX_CODE VARCHAR2 20 N
OPERA FINANCIAL_TRANSACTIONS_VIEW TRX_CODE_ADDED_BY VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TRX_CODE_TYPE VARCHAR2 2 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TRX_CODE_TYPE_ADDED_BY VARCHAR2 2 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TRX_DATE DATE 7 N
OPERA FINANCIAL_TRANSACTIONS_VIEW TRX_NO NUMBER 22 N
OPERA FINANCIAL_TRANSACTIONS_VIEW TRX_NO_ADDED_BY NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TRX_NO_ADJUST NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TRX_NO_AGAINST_PACKAGE NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TRX_SERVICE_TYPE VARCHAR2 20 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TRX_TYPE VARCHAR2 11 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TRX_TYPE_DESCRIPTION VARCHAR2 4000 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TRX_TYPE_SORT NUMBER 22 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW TZ_INSERT_DATE DATE 7 Y
OPERA FINANCIAL_TRANSACTIONS_VIEW UPDATE_DATE DATE 7 N
OPERA FINANCIAL_TRANSACTIONS_VIEW UPDATE_USER NUMBER 22 N
OPERA FINANCIAL_TRANSACTIONS_VIEW VAT_OFFSET_YN VARCHAR2 1 Y
OWNER TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LENGTH NULLABLE
OPERA EXP_SCBUSBLOCK_VIEW ACC_ADDRESS1 VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW ACC_ADDRESS2 VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW ACC_CITY VARCHAR2 40 Y
OPERA EXP_SCBUSBLOCK_VIEW ACC_CITY_EXT VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW ACC_COUNTRY VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW ACC_EMAIL VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW ACC_FAX VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW ACC_ID NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW ACC_NAME VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW ACC_NAME2 VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW ACC_NAME3 VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW ACC_PHONE VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW ACC_RELATIONSHIP VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW ACC_RELATIONSHIP_DESC VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW ACC_STATE VARCHAR2 40 Y
OPERA EXP_SCBUSBLOCK_VIEW ACC_ZIPCODE VARCHAR2 15 Y
OPERA EXP_SCBUSBLOCK_VIEW ACTION_ID NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW ACTUAL_AVG_RATE NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW ACTUAL_REVENUE NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW ACTUAL_ROOMS NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW AGENT_ADDRESS1 VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW AGENT_ADDRESS2 VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW AGENT_CITY VARCHAR2 40 Y
OPERA EXP_SCBUSBLOCK_VIEW AGENT_CITY_EXT VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW AGENT_COUNTRY VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW AGENT_EMAIL VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW AGENT_FAX VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW AGENT_ID NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW AGENT_NAME VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW AGENT_NAME_ID NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW AGENT_NAME2 VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW AGENT_NAME3 VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW AGENT_PHONE VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW AGENT_RELATIONSHIP VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW AGENT_RELATIONSHIP_DESC VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW AGENT_STATE VARCHAR2 40 Y
OPERA EXP_SCBUSBLOCK_VIEW AGENT_ZIPCODE VARCHAR2 15 Y
OPERA EXP_SCBUSBLOCK_VIEW ALLOTMENT_CODE VARCHAR2 20 N
OPERA EXP_SCBUSBLOCK_VIEW ALLOTMENT_ORIGION VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW ALLOTMENT_TYPE VARCHAR2 20 N
OPERA EXP_SCBUSBLOCK_VIEW ALL_OWNERS VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW ARRIVAL_TIME DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW ATTENDEES NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW AVAILABLE_REVENUE NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW AVAILABLE_ROOMS NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW AVG_PEOPLE_PER_ROOM NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW AVG_RATE NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW BEGIN_DATE DATE 7 N
OPERA EXP_SCBUSBLOCK_VIEW BFST_DESC VARCHAR2 40 Y
OPERA EXP_SCBUSBLOCK_VIEW BFST_PRICE NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW BFST_YN VARCHAR2 1 Y
OPERA EXP_SCBUSBLOCK_VIEW BOOKINGMETHOD VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW BOOKINGMETHODDESC VARCHAR2 2000 Y
OPERA EXP_SCBUSBLOCK_VIEW BOOKING_STATUS VARCHAR2 10 N
OPERA EXP_SCBUSBLOCK_VIEW BOOKING_STATUS_TYPE VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW BOOKINGTYPE VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW BUSBLOCK_ID NUMBER 22 N
OPERA EXP_SCBUSBLOCK_VIEW CANCELLATION_CODE VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW CANCELLATION_DATE DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW CANCELLATION_DESCRIPTION VARCHAR2 2000 Y
OPERA EXP_SCBUSBLOCK_VIEW CANCELLATION_NO NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW CANCEL_RULE VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_CANX_CODE VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_CANX_DATE DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_CANX_DESC VARCHAR2 2000 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_CANX_NO NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_CURRENCY VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_CUTOFF DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_DECISION DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW CATERINGONLY_YN VARCHAR2 1 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_EXCHANGE NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_FOLLOWUP DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_OWNER NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_OWNER_CODE VARCHAR2 10 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_OWNER_EMAIL VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_OWNER_FAX VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_OWNER_PHONE VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_OWNER_RESORT VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_OWNERS VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_OWNER_SREPNAME VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_OWNER_TITLE VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_QUOTE_CURR VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_REVENUE NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_STATUS VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW CAT_STATUS_TYPE VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW CHANNEL VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW COMMISSION VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW COMPANY_NAME_ID NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW COMP_PER_STAY_YN VARCHAR2 1 Y
OPERA EXP_SCBUSBLOCK_VIEW COMP_ROOMS NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW COMP_ROOMS_FIXED_YN VARCHAR2 1 Y
OPERA EXP_SCBUSBLOCK_VIEW COMP_ROOM_VALUE NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_ADDRESS1 VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_ADDRESS2 VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_ADDRESS3 VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_ADDRESS4 VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_BUSINESS_GREETING VARCHAR2 100 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_CITY VARCHAR2 40 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_CITY_EXT VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_COUNTRY VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_DEPARTMENT VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_FIRST VARCHAR2 40 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_ID NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_LAST VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_LETTER_GREETING VARCHAR2 60 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_MIDDLE VARCHAR2 40 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_NAME VARCHAR2 162 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_POSITION VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_RELATIONSHIP VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_RELATIONSHIP_DESC VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW CON_STATE VARCHAR2 40 Y
OPERA EXP_SCBUSBLOCK_VIEW CONTACT_EMAIL VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW CONTACT_FAX VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW CONTACT_NAME_ID NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW CONTACT_PHONE VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW CONTACT_ZIPCODE VARCHAR2 15 Y
OPERA EXP_SCBUSBLOCK_VIEW CONTRACT_NR VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW CREDIT_CARD_EXP_DATE DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW CREDIT_CARD_NUMBER VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW CREDIT_CARD_TYPE VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW CURRENCY_CODE VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW DATE_OPENED_FOR_PICKUP DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW DEFAULT_PM_RESV_NAME_ID NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW DEPARTURE_TIME DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW DESCRIPTION VARCHAR2 2000 N
OPERA EXP_SCBUSBLOCK_VIEW DESTINATION VARCHAR2 100 Y
OPERA EXP_SCBUSBLOCK_VIEW DETAILS_OK_YN VARCHAR2 1 Y
OPERA EXP_SCBUSBLOCK_VIEW DISTRIBUTED_YN VARCHAR2 1 Y
OPERA EXP_SCBUSBLOCK_VIEW ELASTIC NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW END_DATE DATE 7 N
OPERA EXP_SCBUSBLOCK_VIEW EVENTS_GUARANTEED_YN VARCHAR2 1 Y
OPERA EXP_SCBUSBLOCK_VIEW EXCHANGE_POSTING_TYPE VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW EXCHANGE_RATE NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW FB_REVENUE NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW FUNCTIONTYPE VARCHAR2 60 Y
OPERA EXP_SCBUSBLOCK_VIEW GUARANTEE_CODE VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW IATA_CORP_NO VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW INACTIVE_DATE DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW INFO VARCHAR2 2000 Y
OPERA EXP_SCBUSBLOCK_VIEW INFOBOARD VARCHAR2 50 Y
OPERA EXP_SCBUSBLOCK_VIEW INSERT_DATE DATE 7 N
OPERA EXP_SCBUSBLOCK_VIEW INSERT_USER NUMBER 22 N
OPERA EXP_SCBUSBLOCK_VIEW INV_CUTOFF_DATE DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW INV_CUTOFF_DAYS NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW MAINMARKET VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW MARKET_CODE VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW MASTER_NAME_ID NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW METHOD_DUE DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW ORIGINAL_RATE_CODE VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW OTHER_REVENUE NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW OWNER NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW OWNER_CODE VARCHAR2 10 N
OPERA EXP_SCBUSBLOCK_VIEW OWNER_CODE_SREPNAME VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW OWNER_EMAIL VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW OWNER_FAX VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW OWNER_PHONE VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW OWNER_RESORT VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW OWNER_TITLE VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW PAYMENT_METHOD VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW PEAK_ROOMS NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW PORTERAGE_PRICE NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW PORTERAGE_YN VARCHAR2 1 Y
OPERA EXP_SCBUSBLOCK_VIEW PROFILE_DESC VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW PROFILE_ID NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW RATE_CODE VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW RELATED_RESORTS VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW REPRESENTATIVE VARCHAR2 40 Y
OPERA EXP_SCBUSBLOCK_VIEW RESERVE_INVENTORY_YN VARCHAR2 1 Y
OPERA EXP_SCBUSBLOCK_VIEW RESORT_BOOKED VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW REV_BLOCKED NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW RIV_MARKET_SEGMENT VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW RMS_BLOCKED NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW RMS_CURRENCY VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW RMS_DECISION DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW RMS_EXCHANGE NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW RMS_FOLLOWUP DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW RMS_OWNER NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW RMS_OWNER_CODE VARCHAR2 10 Y
OPERA EXP_SCBUSBLOCK_VIEW RMS_OWNER_EMAIL VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW RMS_OWNER_FAX VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW RMS_OWNER_PHONE VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW RMS_OWNER_RESORT VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW RMS_OWNERS VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW RMS_OWNER_SREPNAME VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW RMS_OWNER_TITLE VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW RMS_QUOTE_CURR VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW ROOMS_PER_DAY NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW SALES_ID VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW SERVICE_CHARGE NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_ADDRESS1 VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_ADDRESS2 VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_BUSINESS_GREETING VARCHAR2 60 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_CITY VARCHAR2 40 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_CITY_EXT VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_COUNTRY VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_EMAIL VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_FAX VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_ID NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_NAME VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_NAME_ID NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_NAME2 VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_NAME3 VARCHAR2 80 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_PHONE VARCHAR2 4000 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_RELATIONSHIP VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_RELATIONSHIP_DESC VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_STATE VARCHAR2 40 Y
OPERA EXP_SCBUSBLOCK_VIEW SOURCE_ZIPCODE VARCHAR2 15 Y
OPERA EXP_SCBUSBLOCK_VIEW STATUS VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW SUPER_BLOCK_ID NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW SUPER_BLOCK_RESORT VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW TAX_AMOUNT NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW TENTATIVE_LEVEL NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW TOTAL_COMPLIMENTARY_ROOMS NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW TOTAL_REVENUE NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW TRACECODE VARCHAR2 20 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC01 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC02 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC03 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC04 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC05 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC06 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC07 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC08 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC09 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC10 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC11 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC12 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC13 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC14 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC15 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC16 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC17 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC18 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC19 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC20 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC21 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC22 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC23 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC24 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC25 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC26 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC27 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC28 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC29 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC30 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC31 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC32 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC33 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC34 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC35 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC36 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC37 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC38 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC39 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFC40 VARCHAR2 200 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD01 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD02 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD03 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD04 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD05 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD06 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD07 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD08 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD09 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD10 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD11 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD12 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD13 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD14 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD15 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD16 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD17 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD18 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD19 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFD20 DATE 7 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN01 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN02 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN03 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN04 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN05 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN06 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN07 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN08 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN09 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN10 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN11 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN12 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN13 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN14 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN15 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN16 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN17 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN18 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN19 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN20 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN21 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN22 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN23 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN24 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN25 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN26 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN27 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN28 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN29 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN30 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN31 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN32 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN33 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN34 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN35 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN36 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN37 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN38 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN39 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UDFN40 NUMBER 22 Y
OPERA EXP_SCBUSBLOCK_VIEW UPDATE_DATE DATE 7 N
OPERA EXP_SCBUSBLOCK_VIEW UPDATE_USER NUMBER 22 N
OWNER TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LENGTH NULLABLE
OPERA EXP_SCEVENT_VIEW ACTUAL_REVENUE NUMBER 22 Y
OPERA EXP_SCEVENT_VIEW ATTENDEES NUMBER 22 Y
OPERA EXP_SCEVENT_VIEW BILLED_REVENUE NUMBER 22 Y
OPERA EXP_SCEVENT_VIEW BOOK_ID NUMBER 22 N
OPERA EXP_SCEVENT_VIEW DISCOUNT_PERCENTAGE NUMBER 22 Y
OPERA EXP_SCEVENT_VIEW DOORCARD VARCHAR2 50 Y
OPERA EXP_SCEVENT_VIEW END_DATE DATE 7 N
OPERA EXP_SCEVENT_VIEW END_TIME DATE 7 N
OPERA EXP_SCEVENT_VIEW EVENT_END_DATE VARCHAR2 75 Y
OPERA EXP_SCEVENT_VIEW EVENT_END_TIME VARCHAR2 75 Y
OPERA EXP_SCEVENT_VIEW EVENT_ID VARCHAR2 40 Y
OPERA EXP_SCEVENT_VIEW EVENT_NAME VARCHAR2 60 N
OPERA EXP_SCEVENT_VIEW EVENT_START_DATE VARCHAR2 75 Y
OPERA EXP_SCEVENT_VIEW EVENT_START_TIME VARCHAR2 75 Y
OPERA EXP_SCEVENT_VIEW EVENT_STATUS VARCHAR2 10 N
OPERA EXP_SCEVENT_VIEW EVENT_TIME VARCHAR2 153 Y
OPERA EXP_SCEVENT_VIEW EVENT_TYPE VARCHAR2 20 N
OPERA EXP_SCEVENT_VIEW EV_RESORT VARCHAR2 20 N
OPERA EXP_SCEVENT_VIEW EXPECTED_REVENUE NUMBER 22 Y
OPERA EXP_SCEVENT_VIEW FORECAST_REVENUE NUMBER 22 Y
OPERA EXP_SCEVENT_VIEW GUARANTEED NUMBER 22 Y
OPERA EXP_SCEVENT_VIEW GUARANTEED_REVENUE NUMBER 22 Y
OPERA EXP_SCEVENT_VIEW MASTER_EVENT_ID NUMBER 22 Y
OPERA EXP_SCEVENT_VIEW PKG_CODE VARCHAR2 10 Y
OPERA EXP_SCEVENT_VIEW PKG_ID NUMBER 22 Y
OPERA EXP_SCEVENT_VIEW PKG_NAME VARCHAR2 200 Y
OPERA EXP_SCEVENT_VIEW RATE_AMOUNT NUMBER 22 Y
OPERA EXP_SCEVENT_VIEW RATECODE VARCHAR2 20 Y
OPERA EXP_SCEVENT_VIEW ROOM VARCHAR2 20 Y
OPERA EXP_SCEVENT_VIEW ROOM_NAME VARCHAR2 2000 Y
OPERA EXP_SCEVENT_VIEW ROOM_SETUP VARCHAR2 20 Y
OPERA EXP_SCEVENT_VIEW SETDOWN_TIME NUMBER 22 Y
OPERA EXP_SCEVENT_VIEW SETUP_SETDWN_TIME VARCHAR2 176 Y
OPERA EXP_SCEVENT_VIEW SETUP_TIME NUMBER 22 Y
OPERA EXP_SCEVENT_VIEW START_DATE DATE 7 N
OPERA EXP_SCEVENT_VIEW START_TIME DATE 7 N
OWNER TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LENGTH NULLABLE
OPERA ACTIVITY_VIEW ACT_CLASS VARCHAR2 20 Y
OPERA ACTIVITY_VIEW ACT_ID NUMBER 22 N
OPERA ACTIVITY_VIEW ACT_TYPE VARCHAR2 20 Y
OPERA ACTIVITY_VIEW ASSIGNED_BY NUMBER 22 Y
OPERA ACTIVITY_VIEW ASSIGNED_BY_USER VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW ASSIGNED_ON_DATE DATE 7 Y
OPERA ACTIVITY_VIEW ASSIGNED_TO NUMBER 22 Y
OPERA ACTIVITY_VIEW ASSIGNED_TO_USER VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW AUTHOR NUMBER 22 Y
OPERA ACTIVITY_VIEW CAMPAIGN_ID NUMBER 22 Y
OPERA ACTIVITY_VIEW CATEGORY_CODE VARCHAR2 20 Y
OPERA ACTIVITY_VIEW COLOR_CODE VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW COMPLETED_BY NUMBER 22 Y
OPERA ACTIVITY_VIEW COMPLETED_BY_USER VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW COMPLETED_DATE DATE 7 Y
OPERA ACTIVITY_VIEW CREATED_BY NUMBER 22 N
OPERA ACTIVITY_VIEW CREATED_BY_USER VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW CREATED_DATE DATE 7 Y
OPERA ACTIVITY_VIEW DEPENDING_ON_ACT_ID NUMBER 22 Y
OPERA ACTIVITY_VIEW DEPT_OF_ACTION VARCHAR2 20 Y
OPERA ACTIVITY_VIEW DONE VARCHAR2 1 Y
OPERA ACTIVITY_VIEW DUE_DATE DATE 7 Y
OPERA ACTIVITY_VIEW DURATION NUMBER 22 Y
OPERA ACTIVITY_VIEW DURATION_TIME_CODE VARCHAR2 20 Y
OPERA ACTIVITY_VIEW DURATION_TIME_DESC VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW DURATION_WORKED NUMBER 22 Y
OPERA ACTIVITY_VIEW DURATION_WORKED_UOT VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW DURATION_WORKED_UOT_DESC VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW END_DATE DATE 7 Y
OPERA ACTIVITY_VIEW END_DATE_COLUMN DATE 7 Y
OPERA ACTIVITY_VIEW EST_TIME_TO_COMPLETE NUMBER 22 Y
OPERA ACTIVITY_VIEW EST_UOT_CODE VARCHAR2 20 Y
OPERA ACTIVITY_VIEW EXTERNAL_SYSTEM VARCHAR2 40 Y
OPERA ACTIVITY_VIEW EXTERNAL_SYSTEM_ID VARCHAR2 100 Y
OPERA ACTIVITY_VIEW GENERATED_BY_CAMPAIGN VARCHAR2 1 Y
OPERA ACTIVITY_VIEW GUEST_ORIGINATED_YN VARCHAR2 1 Y
OPERA ACTIVITY_VIEW GUEST_ROOM_YN VARCHAR2 1 Y
OPERA ACTIVITY_VIEW INACTIVE_DATE DATE 7 Y
OPERA ACTIVITY_VIEW INSERT_DATE DATE 7 Y
OPERA ACTIVITY_VIEW INSERT_USER NUMBER 22 N
OPERA ACTIVITY_VIEW INTERNAL_YN VARCHAR2 1 Y
OPERA ACTIVITY_VIEW LOCATION_CODE VARCHAR2 20 Y
OPERA ACTIVITY_VIEW LOCATION_DESC VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW MASTER_SUB VARCHAR2 1 Y
OPERA ACTIVITY_VIEW MINUTES_BEFORE_ALERT NUMBER 22 Y
OPERA ACTIVITY_VIEW MULTI_ACCOUNT VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW MULTI_BBLOCKS VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW MULTI_CONTACT VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW MULTI_CONTRACT VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW MULTI_PROFILES VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW NOTES VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW NOTIFIED_YN VARCHAR2 1 Y
OPERA ACTIVITY_VIEW PARENT_ACT_ID NUMBER 22 Y
OPERA ACTIVITY_VIEW PLANT_ITEM_CODE VARCHAR2 20 Y
OPERA ACTIVITY_VIEW PLANT_ITEM_DESC VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW PP_STATUS_CODE NUMBER 22 Y
OPERA ACTIVITY_VIEW PRIORITY_CHANGED_YN VARCHAR2 1 Y
OPERA ACTIVITY_VIEW PRIORITY_CODE VARCHAR2 20 Y
OPERA ACTIVITY_VIEW PRIORITY_DESC VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW PRIORITY_SEQ_NUMBER NUMBER 22 Y
OPERA ACTIVITY_VIEW PRIVATE_YN VARCHAR2 1 Y
OPERA ACTIVITY_VIEW PROBLEM_DESC VARCHAR2 2000 Y
OPERA ACTIVITY_VIEW PROPOSAL_SENT_DATE DATE 7 Y
OPERA ACTIVITY_VIEW PROPOSAL_VIEW_TOKEN VARCHAR2 2000 Y
OPERA ACTIVITY_VIEW PURPOSE VARCHAR2 2000 Y
OPERA ACTIVITY_VIEW REASON_CODE VARCHAR2 20 Y
OPERA ACTIVITY_VIEW REASON_DESC VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW RELEASED_BY NUMBER 22 Y
OPERA ACTIVITY_VIEW RELEASED_BY_USER VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW RELEASED_DATE DATE 7 Y
OPERA ACTIVITY_VIEW RESORT VARCHAR2 20 N
OPERA ACTIVITY_VIEW RESULT VARCHAR2 2000 Y
OPERA ACTIVITY_VIEW ROOM VARCHAR2 20 Y
OPERA ACTIVITY_VIEW START_DATE DATE 7 Y
OPERA ACTIVITY_VIEW START_DATE_COLUMN DATE 7 Y
OPERA ACTIVITY_VIEW STATUS_CODE VARCHAR2 20 Y
OPERA ACTIVITY_VIEW STATUS_DESC VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW SURVEY_ID NUMBER 22 Y
OPERA ACTIVITY_VIEW TAKEN_BY NUMBER 22 Y
OPERA ACTIVITY_VIEW TAKEN_BY_USER VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW TAKEN_DATE DATE 7 Y
OPERA ACTIVITY_VIEW TASK_CODE NUMBER 22 Y
OPERA ACTIVITY_VIEW TASK_DESC VARCHAR2 4000 Y
OPERA ACTIVITY_VIEW TASKITEM_NUMBER NUMBER 22 Y
OPERA ACTIVITY_VIEW TIMEZONE_CONVERTED_YN VARCHAR2 1 Y
OPERA ACTIVITY_VIEW TOTAL_LABOR_COST NUMBER 22 Y
OPERA ACTIVITY_VIEW TOTAL_PARTS_COST NUMBER 22 Y
OPERA ACTIVITY_VIEW TRACECODE VARCHAR2 20 Y
OPERA ACTIVITY_VIEW TYPE_CODE VARCHAR2 20 N
OPERA ACTIVITY_VIEW UPDATE_DATE DATE 7 Y
OPERA ACTIVITY_VIEW UPDATE_USER NUMBER 22 Y
OPERA ACTIVITY_VIEW USER_EXT VARCHAR2 20 Y
OPERA ACTIVITY_VIEW WORK_CATEGORY_DESC VARCHAR2 4000 Y