|
|
|
Contract (Merge document based on REP_CONT_MERGE.DOC with REP_CONT_MERGE.FMX)
The Sales & Catering contract is a sophisticated tool to communicate group booking and catering details to customers. Even though it is mainly used to produce group contracts, there is a much wider scope of possibilities related to it. It is possible to link multiple letter templates to the order form and select which template to merge to on a case-by-case basis.
The additional options to define which room grid and event template merge into the document and the possibility to merge deposit information and billing instructions make this a truly flexible communication tool.
When a workstation has an issue generating this report that requires the webutil.properties file to be deleted in the JInitiator directory, use the hidden option that has been added to report form. On the bottom left-hand corner of the screen, select Ctrl+Shift+Double Click and a message will notify that the webutil.properties file has been deleted. You must then log out of Opera, close the browser session and relaunch Opera S&C for the required files to download and this report to generate.
Note: When merging the Contract Merge Report (rep_cont_merge) from the main Reports screen, the merged document in word will be named based on the Opera Template Name. For instance, in the case of a document in Opera named 'Rooms Contract', the merged document in word will also be named 'Rooms Contract'.
Note: When printing this Report help topic, we recommend printing with Portrait page orientation.
Note: This report requires that the user be granted the BLOCK PRINT permission in the selected property to run the report. Also, the Property LOV in this report is further limited by the properties to which the user has the appropriate access granted.
Rms Property. Select the business block property(s) by which the results should be filtered.
Block ID. Select the business blocks by which the report should be filtered.
Note: When filtering this report by Block ID and selecting a Master Block, all Sub-Block IDs for that Master will also display in this field; regardless if this report is initiated from this form or from the Master Block directly.
Event Property. Select one or more event properties from the LOV.
Event Status. Select the event statuses by which the results should be filtered.
Print Account. Print Account will default to the Account marked as PT for the Business Block from the Name Select screen. If a different Account should be printed on the BEO, select the Print Account ellipsis and click the PT column to select another Account already linked to the business block.
Print Contact. Print Contact will default to the Contact marked as PT for the Business Block from the Name Select screen. If a different Contact should be printed on the BEO, select the Print Contact ellipsis to select another Contact already linked to the business block.
Note: When the Contract is printed for more than one Booking, the 'Print Account' and 'Print Contact' are pulled by default. No option will be provided to select a different Account or Contact for Printing. If no 'Print Account' or 'Print Contact' has been selected for a booking, the default hierarchy is used. Additionally, when no relationship exists between the 'Print Account' and the 'Print Contact', the Print Contact will display in red.
Grid Type. Select the grid type to print Current, Contract, Pickup.
Template. The arrow button allows the selection of an existing template. The ellipsis button allows access to template creation or modification if required. Please see separate section on templates below.
Event Template. Template 1 to template 7 can be selected. Please see the samples below.
Note: The Event Template LOV is hidden when the application function Catering Events is set to N. Also take note that Event Template #7 is hidden when any of the following conditions are met:
- The S&C License OPL_xxx is Active
- The S&C License OPM_xxx is Active
- The application function Event Resources is set to N.
Deposit. Indicate if the deposit information should print sorted by deposit type or by due date.
Note Types. Select one or more business block note types to print. If nothing is selected, no business block notes will print in the document.
Currency. Select the currency in which the revenues on this report will display.
Prompt to Attach Contract. Select this flag to attach the contract to the originating business block. Once the contract has generated and all changes to the merged document have been saved (using the Save option and not Save As in MS Word, so that the document retains the same name and directory as when it was opened by Opera.), answer Yes to the prompt to attach the document to the business block or No to continue without attaching the document.
Note: Access to this option is controlled by the application function General>File Attachments. When set to N, this flag is NOT visible.
Table Style. A list of standard Microsoft table styles is available for selection. This determines the framework for all grids that are part of the contract merge.
Revenue Types. This is only necessary (and mandatory) to select if event template style 4 has been selected.
Note: The Revenue Type LOV is hidden when the application function Catering Events is set to N.
Print Rooms with Rate and no Inventory. If checked the contract will also include room types for which no inventory has been booked, provided a rate amount has been assigned to the room type.
Print PMS Room Types. If checked, the PMS room types will print on the contract rather than the S&C room types.
Print Occupancy. If checked, number or rooms per room type per occupancy level per day will print (if occupancy split is on). If not checked, only total number of rooms per room type per day will print.
Print Rate. If checked, room rates will print. If not checked, room rates will not print.
Print Room and Rate separately. If checked, the room nights and room rates will print in separate grids. If unchecked, they will print in the same grid.
Inline Currency. Only accessible if Print Rate has been checked. If this flag is checked, the currency symbol will print along with the rate in the grid cells. If no currency symbol has been defined the currency code will print instead.
Show Decimals. Only accessible if Print Rate has been checked. If this flag is checked, the rates will print with decimals as set-up in the resort details. If the flag is not checked, the rate will print only in integers.
Print Resort Fee. This field will draw data from the Resort Fee Amount field of the Business Block More tab. Selecting this option will disable all other Room and Rate print options except for 'Print Rooms with Rate and no Inventory', 'Print Internal Notes' and 'Print External Notes'.
Print Internal Notes. Select to display internal business block notes on the report.
Print External Notes. Select to display external business block notes on the report.
Preview. Use the preview option to view the generated output of this report in PDF format.
Close. Closes this report screen.
Always use the contract_sample.doc of the current version as basis for template creation to be able to utilize all features that might have been added to the merge document and macros. The contract_sample.doc is delivered with the runtimes of each new version / patch.
<<GRID>>. Will print the room grid. Depending on the flag setting on the form, this can contain occupancy levels, rates, decimals in rates, currency symbol or code, or two grids can be printed separately for number of rooms and rates per room type per day.
<<EVENTS>>. Will print the event details. A selection of 7 different template styles is available for selection on the report form.
Note: When Events belonging to a Sub-Block are printed, all Events will print on one contract - as if they were one booking - not separate contracts.
Template1. Date, Time, Event Name, Space Name, Attendees
Template2. Date, Time, Event Name, Attendees, Function Space Rental
Template3. Date, Time, Event Name, Space Name, Attendees (Double Spaced)
Template4. Date, Time, Event Name, Space Name, Setup Style, Attendees, Food Revenue, Beverage Revenue, Rental Revenue, Other Revenue.
The amounts are calculated from the revenue types that have been selected on the report form for each column.
Template5. Date, Time, Event Name, Space Name, Setup Style, Attendees, Function Space Rental.
Template6. Date, Time, Event Name, Space Name, Setup Style, Attendees, F&B Minimum
Template7. Date, Time, Event Name, Space Name, Attendees, Resources, Price (expected revenue).
<<DEPOSIT>>. Will print deposit information. The sort order depends on the selection on the report form. If sorted by deposit type, a sub-total for each type will also print. Column included in this grid are Deposit Type, Percentage, Deposit Amount Requested, Deposit Due Date, Deposit Amount Paid, Deposit Amount Still Due after Payment, Description.
<<BILLINGS>>. Billing Instructions: The information that is printed in this grid comes from the entries made in Business Block Options Contract Billing. The instruction type, instructions for, Routing Code, and Comments will print.
<<NOTE>>. Notes can be placed anywhere within the document. Their tags are <xxx> where xxx is the note code of the note that should print where the tag is placed.
Fields available to merge are from the SC_BUSBLOCK_INFO view:
BUSBLOCK_PROPERTY |
Property |
ACC_ACTIVE_YN |
Account Active Flag Y/N |
ACC_ADDRESS1 |
Account Address 1 |
ACC_ADDRESS2 |
Account Address 2 |
ACC_AR_NO |
Account A/R Number |
ACC_AVAILOVER_YN |
Acc_Availover_Yn |
ACC_BL_MSG |
Account Restricted Message |
ACC_CBL_IND |
Account Restricted |
ACC_CITY |
Account City |
ACC_CITY_EXT |
Account City Extension |
ACC_COMMISSION_CODE |
Account Commission Code |
ACC_COMPETITION_CODE |
Account Competition Code |
ACC_COUNTRY |
Account Country |
ACC_COUNTRY_DESC |
Account Country Description |
ACC_EMAIL |
Account Email |
ACC_FAX |
Account Fax |
ACC_HISTORY_YN |
Account History Flag |
ACC_HOLD_CODE |
Account Hold Code (Commissions) |
ACC_IATA_COMP_TYPE |
Account IATA / Company Type |
ACC_ID |
Account ID |
ACC_INDUSTRY_CODE |
Account Industry Code |
ACC_KEYWORD |
Account Keyword (Default) |
ACC_LANGUAGE |
Account Language |
ACC_LANGUAGE_DESC |
Account Language Description |
ACC_MAIL_LIST |
N/A |
ACC_MAIL_TYPE |
N/A |
ACC_MARKETS |
Account Market |
ACC_NAME |
Account Name |
ACC_NAME_KEYWORDS |
Account Keyword(s) |
ACC_NAME_TYPE |
Account Profile Type |
ACC_NAME2 |
Account Name 2 |
ACC_NAME3 |
Account Name 3 |
ACC_PHONE |
Account Phone |
ACC_PHONE_ID |
Account Phone ID (Internal) |
ACC_PHONE_NO |
Account (Primary) Owner Phone |
ACC_PRIORITY |
Account Priority |
ACC_PRODUCT_INTEREST |
Account Profile Interest |
ACC_RATE_IND |
Acc_Rate_Ind |
ACC_RELATIONSHIP |
Account Relationship Type |
ACC_RELATIONSHIP_DESC |
Account Relationship Description |
ACC_ROOMS_POTENTIAL |
Account Rooms Potential |
ACC_SCOPE |
Account Scope |
ACC_SCOPE_CITY |
Account Scope City |
ACC_SNAME |
Account Name (CAPS) |
ACC_SOURCE |
Account Source Code |
ACC_SREP_CODE |
Account Owner Initials (Primary) |
ACC_STATE |
Account State |
ACC_STATE_DESC |
Account State Description |
ACC_SXNAME |
Account Alternate Name (CAPS) |
ACC_TERRITORY |
Account Territory |
ACC_TYPE |
Account Type |
ACC_XDISPLAY_NAME |
Account Alternate Full Name |
ACC_XENVELOPE_GREETING |
Account Alternate Envelope Greeting |
ACC_XFIRST_NAME |
Account Alternate First Name |
ACC_XLANGUAGE |
Account Alternate Language |
ACC_XLANGUAGE_DESC |
Account Alternate Language Description |
ACC_XSALUTATION |
Account Alternate Salutation |
ACC_XTITLE |
Account Alternate Title |
ACC_ZIPCODE |
Account Postal Code |
ACTION_ID |
Account Action ID |
ACTUAL_AVG_RATE |
Picked-Up Average Rate (Net)
|
ACTUAL_REVENUE |
Picked-Up Room Revenue (Net)
|
ACTUAL_ROOMS |
Actual Number of Rooms |
AGENT_ADDRESS1 |
Agent Address 1 |
AGENT_ADDRESS2 |
Agent Address 2 |
AGENT_CITY |
Agent City |
AGENT_CITY_EXT |
Agent City Extension |
AGENT_CON_ACTIONCODE |
Agent Contact Action Code |
AGENT_CON_ACTIVE_YN |
Agent Contact Active Flag |
AGENT_CON_ADDRESS1 |
Agent Contact Address 1 |
AGENT_CON_ADDRESS2 |
Agent Contact Address 2 |
AGENT_CON_ADDRESS3 |
Agent Contact Address 3 |
AGENT_CON_ADDRESS4 |
Agent Contact Address 4 |
AGENT_CON_BIRTH_DATE |
Agent Contact Birth Date |
AGENT_CON_BUSINESS_GREETING |
Agent Contact Business Greeting |
AGENT_CON_CASH_BL_IND |
Agent Contact Restrict Message |
AGENT_CON_CITY |
Agent Contact City |
AGENT_CON_CITY_EXT |
Agent Contact City Extension |
AGENT_CON_CONTACT_YN |
Agent Contact Flag |
AGENT_CON_COUNTRY |
Agent Contact Country |
AGENT_CON_COUNTRY_DESC |
Agent Contact Country Description |
AGENT_CON_DEPARTMENT |
Agent Contact Department |
AGENT_CON_EMAIL |
Agent Contact Email |
AGENT_CON_FAX |
Agent Contact Fax |
AGENT_CON_FIRST |
Agent Contact First Name |
AGENT_CON_ID |
Agent Contact ID |
AGENT_CON_INFLUENCE |
Agent Contact Influence |
AGENT_CON_LANGUAGE |
Agent Contact Language |
AGENT_CON_LANGUAGE_DESC |
Agent Contact Language Description |
AGENT_CON_LAST |
Agent Contact Last Name |
AGENT_CON_LETTER_GREETING |
Agent Contact Salutation |
AGENT_CON_MARKETS |
Agent Contact Market |
AGENT_CON_MIDDLE |
Agent Contact Middle Name |
AGENT_CON_NAME |
Agent Contact Full Name |
AGENT_CON_PHONE |
Agent Contact Phone |
AGENT_CON_POSITION |
Agent Contact Position |
AGENT_CON_PRIMARY_YN |
Agent Contact Primary Flag |
AGENT_CON_PRODUCT_INTEREST |
Agent Contact Profile Interest |
AGENT_CON_RELATIONSHIP |
Agent Contact Relationship Type |
AGENT_CON_RELATIONSHIP_DESC |
Agent Contact Relationship Description |
AGENT_CON_SCOPE |
Agent Contact Scope |
AGENT_CON_SCOPE_CITY |
Agent Contact Scope City |
AGENT_CON_SFIRST |
Agent Contact First Name (CAPS) |
AGENT_CON_SNAME |
Agent Contact Last name (CAPS_ |
AGENT_CON_SREP_ID |
Agent Contact Owner Initials (Primary) |
AGENT_CON_SREP_NAME |
Agent Contact Owner Full Name (Primary) |
AGENT_CON_STATE |
Agent Contact State |
AGENT_CON_SXFIRST_NAME |
Agent Contact Alternate First Name (CAPS) |
AGENT_CON_SXNAME |
Agent Contact Alternate Last Name (CAPS) |
AGENT_CON_TERRITORY |
Agent Contact Territory |
AGENT_CON_TITLE |
Agent Contact Title |
AGENT_CON_XFIRST |
Agent Contact Alternate First Name |
AGENT_CON_XLANGUAGE |
Agent Contact Alternate Language |
AGENT_CON_XLANGUAGE_DESC |
Agent Contact Alternate Language Description |
AGENT_CON_XLAST |
Agent Contact Alternate Last Name |
AGENT_CON_XLETTER_GREETING |
Agent Contact Alternate Envelope Greeting |
AGENT_CON_XNAME |
Agent Contact Alternate Full Name |
AGENT_CON_XSALUTATION |
Agent Contact Alternate Salutation |
AGENT_CON_XTITLE |
Agent Contact Alternate Title |
AGENT_CON_ZIPCODE |
Agent Contact Postal Code |
AGENT_COUNTRY |
Agent Country |
AGENT_COUNTRY_DESC |
Agent Country Description |
AGENT_EMAIL |
Agent Email |
AGENT_FAX |
Agent Fax |
AGENT_ID |
Agent ID |
AGENT_NAME |
Agent Name |
AGENT_NAME_ID |
Agent Name ID |
AGENT_NAME2 |
Agent Name 2 |
AGENT_NAME3 |
Agent Name 3 |
AGENT_PHONE |
Agent Phone |
AGENT_RELATIONSHIP |
Agent Relationship Type |
AGENT_RELATIONSHIP_DESC |
Agent Relationship Description |
AGENT_STATE |
Agent State |
AGENT_XDISPLAY_NAME |
Agent Alternate Full Name |
AGENT_XENVELOPE_GREETING |
Agent Alternate Envelope Greeting |
AGENT_XFIRST_NAME |
Agent Alternate First Name |
AGENT_XLANGUAGE |
Agent Alternate Language |
AGENT_XLANGUAGE_DESC |
Agent Alternate Language Description |
AGENT_XSALUTATION |
Agent Alternate Salutation |
AGENT_XTITLE |
Agent Alternate Title |
AGENT_ZIPCODE |
Agent Postal Code |
ALL_OWNERS |
All Block Owner Initials |
ALLOTMENT_CODE |
Block Code |
ALLOTMENT_ORIGIN |
Internal Code indicating where the business block was Created (i.e. SC, PMS) |
ALLOTMENT_TYPE |
Internal Code indicating what type of block the record is:
|
ARRIVAL_TIME |
Arrival Time |
ATTENDEES |
Attendees |
AVAILABLE_REVENUE |
Available Room Revenue (Available Rooms * Gross Average Rate) |
AVAILABLE_ROOMS |
Available Rooms |
AVG_PEOPLE_PER_ROOM |
Average Pax per Room |
AVG_RATE |
Avg Rate (gross) |
AVG_RATE_NET |
Average Rate - Net |
BEGIN_DATE |
Start Date |
BFST_DESC |
Breakfast Description |
BFST_PRICE |
Breakfast Price |
BFST_YN |
Breakfast Included Flag |
BOOKING_STATUS |
Rooms Status |
BOOKING_STATUS_ORDERBY |
N/A |
BOOKING_STATUS_TYPE |
N/A |
BOOKING_STATUSORDER |
N/A |
BOOKINGMETHOD |
Reservation Method |
BOOKINGMETHODDESC |
Reservation Method Description |
BOOKINGTYPE |
Booking Type |
BUSBLOCK_ID |
Business Block ID |
BUSBLOCK_PROPERTY |
Business Block Property |
CANCEL_RULE |
Cancellation Rule |
CANCELLATION_CODE |
Rooms Cancellation Code |
CANCELLATION_DATE |
Rooms Cancellation Date |
CANCELLATION_DESCRIPTION |
Rooms Cancellation Description |
CANCELLATION_NO |
Rooms Cancellation Number |
CAT_CANX_CODE |
Catering Cancellation Code |
CAT_CANX_DATE |
Catering Cancellation Date |
CAT_CANX_DESC |
Catering Cancellation Description |
CAT_CANX_NO |
Catering Cancellation Number |
CAT_CURRENCY |
Catering Reference Currency |
CAT_CUTOFF |
Catering Cutoff Date |
CAT_DECISION |
Catering Decision Date |
CAT_EXCHANGE |
Catering Exchange Rate |
CAT_FOLLOWUP |
Catering Follow Up Date |
CAT_OWNER |
Catering Owner ID (Primary) |
CAT_OWNER_CODE |
Catering Owner Initials (Primary) |
CAT_OWNER_EMAIL |
Catering Owner Email |
CAT_OWNER_FAX |
Catering Owner Fax |
CAT_OWNER_PHONE |
Catering Owner Phone |
CAT_OWNER_RESORT |
Catering Owner Default Resort |
CAT_OWNER_SREPNAME |
Catering Owner Name (Primary) |
CAT_OWNER_TITLE |
Catering Owner Title |
CAT_OWNERS |
All Catering Owner Initials |
CAT_QUOTE_CURR |
Catering Quoted Currency |
CAT_REVENUE |
Catering Revenue (F&B Revenue + Other Revenue) |
CAT_STATUS |
Catering Status |
CAT_STATUS_ORDERBY |
N/A |
CAT_STATUS_TYPE |
N/A |
CAT_STATUSORDER |
N/A |
CATERING_PKGS_YN |
Catering Pkgs/Tmpl Flag |
CATERINGONLY_YN |
Catering Only Flag |
CENTRAL_OWNER |
GSO Associate |
CHANNEL |
Business Block Origin Field |
COMMISSION |
Commission |
COMP_PER_STAY_YN |
Complimentary Rooms per Stay ? |
COMP_ROOM_VALUE |
Complimentary Rooms Value |
COMP_ROOMS |
Complimentary Rooms |
COMP_ROOMS_FIXED_YN |
Complimentary Rooms Fixed ? |
COMPANY_NAME_ID |
Company Name ID |
CON_ACTIONCODE |
Contact Action Code |
CON_ACTIVE_YN |
Contact Active Flag |
CON_ADDRESS1 |
Contact 1 Address 1 |
CON_ADDRESS2 |
Contact 1 Address 2 |
CON_ADDRESS3 |
Contact 1 Address 3 |
CON_ADDRESS4 |
Contact 1 Address 4 |
CON_BIRTH_DATE |
Contact 1 Birth Date |
CON_BUSINESS_GREETING |
Contact 1 Business Greeting |
CON_CASH_BL_IND |
Contact 1 Restricted Message |
CON_CITY |
Contact 1 City |
CON_CITY_EXT |
Contact 1 City Extension |
CON_CONTACT_YN |
Contact 1 Contact Flag |
CON_COUNTRY |
Contact 1 Country |
CON_COUNTRY_DESC |
Contact Country Description |
CON_DEPARTMENT |
Contact 1 Department |
CON_FIRST |
Contact 1 First Name |
CON_ID |
Contact 1 ID |
CON_INFLUENCE |
Contact 1 Influence |
CON_LANGUAGE |
Contact 1 Language |
CON_LANGUAGE_DESC |
Contact 1 Language Description |
CON_LAST |
Contact 1 Last Name |
CON_LETTER_GREETING |
Contact 1 Salutation |
CON_MARKETS |
Contact 1 Market |
CON_MIDDLE |
Contact 1 Middle Name |
CON_NAME |
Contact 1 Full Name |
CON_POSITION |
Contact 1 Position |
CON_PRODUCT_INTEREST |
Contact 1 Profile Interest |
CON_RELATIONSHIP |
Contact 1 Relationship Type |
CON_RELATIONSHIP_DESC |
Contact 1 Relationship Description |
CON_SCOPE |
Contact Scope |
CON_SCOPE_CITY |
Contact Scope City |
CON_SFIRST |
Contact 1 First Name (CAPS) |
CON_SNAME |
Contact 1 Last Name (CAPS) |
CON_SREP_ID |
Contact 1 Owner Initials (Primary) |
CON_SREP_NAME |
Contact 1 Owner Full Name (Primary) |
CON_STATE |
Contact 1 State |
CON_STATE_DESC |
Contact 1 State Description |
CON_SXFIRST_NAME |
Contact 1 Alternate First Name (CAPS) |
CON_SXNAME |
Contact 1 Alternate Last Name (CAPS) |
CON_TERRITORY |
Contact 1 Territory |
CON_TITLE |
Contact 1 Title |
CON_XFIRST |
Contact 1 Alternate First Name |
CON_XLANGUAGE |
Contact 1 Alternate Language |
CON_XLANGUAGE_DESC |
Contact 1 Alternate Language Description |
CON_XLAST |
Contact 1 Alternate Last Name |
CON_XLETTER_GREETING |
Contact 1 Alternate Envelope Greeting |
CON_XNAME |
Contact 1 Alternate Full Name |
CON_XSALUTATION |
Contact 1 Alternate Salutation |
CON_XTITLE |
Contact 1 Alternate Title |
CONTACT_EMAIL |
Contact 1 Email |
CONTACT_FAX |
Contact 1 Fax |
CONTACT_NAME_ID |
Contact 1 Name ID |
CONTACT_PHONE |
Contact 1 Phone |
CONTACT_ZIPCODE |
Contact 1 Postal Code |
CONTRACT_NR |
Contract Number |
CREDIT_CARD_EXP_DATE |
Credit Card Expiry Date |
CREDIT_CARD_NUMBER |
Credit Card Number |
CREDIT_CARD_TYPE |
Credit Card Type |
CURRENCY_CODE |
Currency Code |
DATE_OPENED_FOR_PICKUP |
Date BB Turned to an Open for Pick-up Status |
DEFAULT_PM_RESV_NAME_ID |
Default PM Reservation Name ID |
DEPARTURE_TIME |
Departure Time |
DESCRIPTION |
Business Block Name |
DESTINATION |
Lost To Destination |
DETAILS_OK_YN |
Track Changes Flag |
DISTRIBUTED_YN |
Distributed Flag |
DML_SEQ_NO |
DML SEQ NO |
DOWNLOAD_DATE |
Lead Download Date |
DOWNLOAD_RESORT |
Lead Download Resort |
DOWNLOAD_SREP |
Lead Download Owner |
DUE_DATE |
Lead Due Date |
ELASTIC |
Elastic Flag |
END_DATE |
End Date |
EVENTS_GUARANTEED_YN |
Events Guaranteed Flag |
EXCHANGE_POSTING_TYPE |
Exchange Posting Type |
EXCHANGE_RATE |
Exchange Rate |
EXTERNAL_LOCKED |
Locked Externally Flag |
FB_REVENUE |
F&B Revenue: Food & Beverage Revenue from the Catering Events. This figure is calculated to match the Event Forecast reports. For ACT events, the Billed revenue is used. Events in a return-to-inventory status are not included. |
FUNCTIONTYPE |
Function Type |
GUARANTEE_CODE |
Reservation Type |
IATA_CORP_NO |
IATA / CORP Number |
INACTIVE_CATERING_REVENUE |
Inactive Catering Revenue (Inactive F&B Revenue + Inactive Other Revenue). |
INACTIVE_DATE |
Date business Block deleted |
INACTIVE_F&B_REVENUE |
Food & Beverage Revenue from the Catering Events in a return-to-inventory status. This figure is calculated to match the Event Forecast reports. For ACT events, the Billed revenue is used. Only Events in a return-to-inventory status are included. |
INACTIVE_OTHER_REVENUE |
All Catering Revenue other than F&B from the Catering Events in a return-to-inventory status. This figure is calculated to match the Event Forecast reports. For ACT events, the Billed revenue is used. Only Events in a return-to-inventory status are included. |
INFO |
Lead Lost Info |
INFOBOARD |
Infoboard |
INSERT_DATE |
Creation Date |
INSERT_USER |
Creation User ID |
INV_CUTOFF_DATE |
Rooms Cutoff Date |
INV_CUTOFF_DAYS |
Rooms Cutoff Days |
ISAC_OPPTY_ID |
ISAC Opportunity ID |
ISAC_QUOTE_ID |
ISAC Quote ID |
LAPTOP_CHANGE |
N/A |
LEAD_ORIGIN |
GSO Sending Location |
LINK_DATE |
Booking Link Date |
LOST_TO_PROPERTY |
Lost To Property |
MAINMARKET |
Main Market Code |
MARKET_CODE |
Market Code |
MASTER_NAME_ID |
Master Name ID |
METHOD_DUE |
Rooming List Due Date |
ORIGINAL_RATE_CODE |
Original Rate Code |
OTHER_REVENUE |
Other Revenue: All Catering Revenue other than F&B from the Catering Events. This figure is calculated to match the Event Forecast reports. For ACT events, the Billed revenue is used. Events in a return-to-inventory status are not included. |
OWNER |
Block Owner ID (Primary) |
OWNER_CODE |
Block Owner Initials (Primary) |
OWNER_CODE_SREPNAME |
Block Owner Name (Primary) |
OWNER_EMAIL |
Booking Owner Email |
OWNER_FAX |
Booking Owner Fax |
OWNER_PHONE |
Booking Owner Phone |
OWNER_RESORT |
Booking Details - > Owner_Resort |
OWNER_TITLE |
Booking Owner Title |
PAYMENT_METHOD |
Payment Method |
PEAK_ROOMS |
Peak Rooms - Actual |
PORTERAGE_PRICE |
Porterage Price |
PORTERAGE_YN |
Porterage Included Flag |
PRINT_ACC_NAME |
Print Account Name |
PRINT_ACC_NAME2 |
Print Account Name Line 2 |
PRINT_ACC_NAME3 |
Print Account Name Line 3 |
PRINT_ACC_PHONE |
Print Account Phone |
PRINT_ACC_ADDRESS1 |
Print Account Address Line 1 |
PRINT_ACC_ADDRESS2 |
Print Account Address Line 2 |
PRINT_ACC_ADDRESS3 |
Print Account Address Line 3 |
PRINT_ACC_ADDRESS4 |
Print Account Address Line 4 |
PRINT_ACC_CITY |
Print Account City |
PRINT_ACC_CITY_EXT |
Print Account City Extension |
PRINT_ACC_STATE |
Print Account State |
PRINT_ACC_ZIPCODE |
Print Account ZIP Code |
PRINT_ACC_COUNTRY |
Print Account Country |
PRINT_ACC_COUNTRY_DESC |
Print Account Country Description |
PRINT_ACC_ID |
Print Account ID |
PRINT_CON_NAME |
Print Contact Name (Title + First + Middle + Last) |
PRINT_CON_FIRST |
Print Contact First Name |
PRINT_CON_LAST |
Print Contact Last Name |
PRINT_CON_MIDDLE |
Print Contact Middle Name |
PRINT_CON_ADDRESS1 |
Print Contact Address Line 1 |
PRINT_CON_ADDRESS2 |
Print Contact Address Line 2 |
PRINT_CON_ADDRESS3 |
Print Contact Address Line 3 |
PRINT_CON_ADDRESS4 |
Print Contact Address Line 4 |
PRINT_CON_CITY |
Print Contact City |
PRINT_CON_CITY_EXT |
Print Contact City Extension |
PRINT_CON_STATE |
Print Contact State |
PRINT_CON_ZIPCODE |
Print Contact ZIP Code |
PRINT_CON_COUNTRY |
Print Contact Country |
PRINT_CON_COUNTRY_DESC |
Print Contact Country Description |
PRINT_CON_ID |
Print Contact ID |
PRINT_CON_BUSINESS_GREETING |
Print Contact Business Greeting |
PRINT_CON_DEPARTMENT |
Print Contact Department |
PRINT_CON_POSITION |
Print Contact Position |
PRINT_CON_EMAIL |
Print Contact Email |
PRINT_CON_PHONE |
Print Contact Phone |
PRINT_CON_LETTER_GREETING |
Print Contact Letter Greeting |
PRINT_CON_XFIRST |
Print Contact Alternate First Name |
PRINT_CON_XLAST |
Print Contact Alternate Last Name |
PRINT_CON_XLETTER_GREETING |
Print Contact Alternate Letter Greeting |
PRINT_CON_XSALUTATION |
Print Contact Alternate Salutation |
PROFILE_DESC |
Linked Potential Description |
PROFILE_ID |
Linked Potential ID |
RATE_CODE |
Rate Code |
RATE_OVERRIDE |
Rate Override |
RATE_OVERRIDE_REASON |
Rate Override Reason |
RELATED_RESORTS |
Related Resorts |
REPRESENTATIVE |
On Site Contact Name |
RESERVE_INVENTORY_YN |
N/A |
RESORT_BOOKED |
Confirmed Resort (SFA) |
REV_BLOCKED |
Room Revenue Blocked - Gross |
REV_BLOCKED_NET |
Room Revenue Blocked - Net |
REV_CONTRACTED |
Room Revenue Contracted |
RIV_MARKET_SEGMENT |
RIV Market Segment |
RMS_BLOCKED |
Total number of Blocked Rooms |
RMS_CONTRACTED |
Total Rooms Contracted |
RMS_CURRENCY |
Rooms ReferenceCurrency |
RMS_DECISION |
Rooms Decision Date |
RMS_EXCHANGE |
Rooms Exchange Rate |
RMS_FOLLOWUP |
Rooms Follow Up Date |
RMS_OWNER |
Rooms Owner ID (Primary) |
RMS_OWNER_CODE |
Rooms Owner Initials (Primary) |
RMS_OWNER_EMAIL |
Rooms Owner Email |
RMS_OWNER_FAX |
Rooms Owner Fax |
RMS_OWNER_PHONE |
Rooms Owner Phone |
RMS_OWNER_RESORT |
Rooms Owner Default Resort |
RMS_OWNER_SREPNAME |
Rooms Owner Name (Primary) |
RMS_OWNER_TITLE |
Rooms Owner Title |
RMS_OWNERS |
All Rooms Owner Initials |
RMS_QUOTE_CURR |
Rooms Quoted Currency |
ROOMS_PER_DAY |
Peak Rooms - Estimated |
SALES_ID |
N/A |
SBEGINDATE |
Shoulder Begin Date |
SEC_CON_ACTIONCODE |
Contact 2 Action Code |
SEC_CON_ACTIVE_YN |
Contact 2 Active Flag |
SEC_CON_ADDRESS1 |
Contact 2 Address 1 |
SEC_CON_ADDRESS2 |
Contact 2 Address 2 |
SEC_CON_ADDRESS3 |
Contact 2 Address 3 |
SEC_CON_ADDRESS4 |
Contact 2 Address 4 |
SEC_CON_BIRTH_DATE |
Contact 2 Birth Date |
SEC_CON_BUSINESS_GREETING |
Contact 2 Envelope Greeting |
SEC_CON_CASH_BL_IND |
Contact 2 Restricted |
SEC_CON_CITY |
Contact 2 City |
SEC_CON_CITY_EXT |
Contact 2 City Extension |
SEC_CON_CONTACT_YN |
Contact 2 Contact Flag |
SEC_CON_COUNTRY |
Contact 2 Country |
SEC_CON_COUNTRY_DESC |
Contact 2 Country Description |
SEC_CON_DEPARTMENT |
Contact 2 Department |
SEC_CON_EMAIL |
Contact 2 Email |
SEC_CON_FAX |
Contact 2 Fax |
SEC_CON_FIRST_NAME |
Contact 2 First Name |
SEC_CON_FULL_NAME |
Contact 2 Full Name |
SEC_CON_ID |
Contact 2 ID |
SEC_CON_INFLUENCE |
Contact 2 Influence |
SEC_CON_LANGUAGE |
Contact 2 Language |
SEC_CON_LANGUAGE_DESC |
Contact 2 Language Description |
SEC_CON_LAST_NAME |
Contact 2 Last Name |
SEC_CON_LETTER_GREETING |
Contact 2 Salutation |
SEC_CON_MARKETS |
Contact 2 Market Code |
SEC_CON_MIDDLE_NAME |
Contact 2 Middle Name |
SEC_CON_PHONE |
Contact 2 Phone |
SEC_CON_POSITION |
Contact 2 Position |
SEC_CON_PRODUCT_INTEREST |
Contact 2 Profile Interest |
SEC_CON_RELATIONSHIP |
Contact 2 Relationship Type |
SEC_CON_RELATIONSHIP_DESC |
Contact 2 Relationship Description |
SEC_CON_SCOPE |
Contact 2 Scope |
SEC_CON_SCOPE_CITY |
Contact 2 Scope City |
SEC_CON_SFIRST |
Contact 2 First Name (CAPS) |
SEC_CON_SNAME |
Contact 2 Last Name (CAPS) |
SEC_CON_SREP_ID |
Contact 2 Owner Initials (Primary) |
SEC_CON_SREP_NAME |
Contact 2 Owner Full Name (Primary) |
SEC_CON_STATE |
Contact 2 State |
SEC_CON_STATE_DESC |
Contact 2 State Description |
SEC_CON_SXFIRST_NAME |
Contact 2 Alternate First Name (CAPS) |
SEC_CON_SXNAME |
Contact 2 Alternate Last Name (CAPS) |
SEC_CON_TERRITORY |
Contact 2 Territory |
SEC_CON_TITLE |
Contact 2 Title |
SEC_CON_XENVELOPE_GREETING |
Contact 2 Alternate Envelope Greeting |
SEC_CON_XFIRST_NAME |
Contact 2 Alternate First Name |
SEC_CON_XFULL_NAME |
Contact 2 Alternate Full Name |
SEC_CON_XLANGUAGE |
Contact 2 Alternate Language |
SEC_CON_XLANGUAGE_DESC |
Contact 2 Alternate Language Description |
SEC_CON_XLAST_NAME |
Contact 2 Alternate Last Name |
SEC_CON_XSALUTATION |
Contact 2 Alternate Salutation |
SEC_CON_XTITLE |
Contact 2 Alternate Title |
SEC_CON_ZIP_CODE |
Contact 2 Postal Code |
SENDDATE |
Lead Send Date |
SENT_DATE |
Oppty Created Date |
SERVICE_CHARGE |
Service Charge |
SHOULDER_BEGIN_DATE |
Shoulder Begin Date |
SHOULDER_END_DATE |
Shoulder End Date |
SOURCE |
Booking Source Code |
SOURCE_ADDRESS1 |
Source Address 1 |
SOURCE_ADDRESS2 |
Source Address 2 |
SOURCE_BUSINESS_GREETING |
N/A |
SOURCE_CITY |
Source City |
SOURCE_CITY_EXT |
Source City Extension |
SOURCE_CON_ACTIONCODE |
Source Contact Action Code |
SOURCE_CON_ACTIVE_YN |
Source Contact Active Flag |
SOURCE_CON_ADDRESS1 |
Source Contact Address 1 |
SOURCE_CON_ADDRESS2 |
Source Contact Address 2 |
SOURCE_CON_ADDRESS3 |
Source Contact Address 3 |
SOURCE_CON_ADDRESS4 |
Source Contact Address 4 |
SOURCE_CON_BIRTH_DATE |
Source Contact Birth Date |
SOURCE_CON_BUSINESS_GREETING |
Source Contact Business Greeting |
SOURCE_CON_CASH_BL_IND |
Source Contact Restrict Message |
SOURCE_CON_CITY |
Source Contact City |
SOURCE_CON_CITY_EXT |
Source Contact City Extension |
SOURCE_CON_CONTACT_YN |
Source Contact Flag |
SOURCE_CON_COUNTRY |
Source Contact Country |
SOURCE_CON_COUNTRY_DESC |
Source Contact Country Description |
SOURCE_CON_DEPARTMENT |
Source Contact Department |
SOURCE_CON_EMAIL |
Source Contact Email |
SOURCE_CON_FAX |
Source Contact Fax |
SOURCE_CON_FIRST |
Source Contact First Name |
SOURCE_CON_ID |
Source Contact ID |
SOURCE_CON_INFLUENCE |
Source Contact Influence |
SOURCE_CON_LANGUAGE |
Source Contact Language |
SOURCE_CON_LANGUAGE_DESC |
Source Contact Language Description |
SOURCE_CON_LAST |
Source Contact Last Name |
SOURCE_CON_LETTER_GREETING |
Source Contact Salutation |
SOURCE_CON_MARKETS |
Source Contact Market |
SOURCE_CON_MIDDLE |
Source Contact Middle Name |
SOURCE_CON_NAME |
Source Contact Full Name |
SOURCE_CON_PHONE |
Source Contact Phone |
SOURCE_CON_POSITION |
Source Contact Position |
SOURCE_CON_PRIMARY_YN |
Source Contact Primary Flag |
SOURCE_CON_PRODUCT_INTEREST |
Source Contact Profile Interest |
SOURCE_CON_RELATIONSHIP |
Source Contact Relationship Type |
SOURCE_CON_RELATIONSHIP_DESC |
Source Contact Relationship Description |
SOURCE_CON_SCOPE |
Source Contact Scope |
SOURCE_CON_SCOPE_CITY |
Source Contact Scope City |
SOURCE_CON_SFIRST |
Source Contact First Name (CAPS) |
SOURCE_CON_SNAME |
Source Contact Last Name (CAPS) |
SOURCE_CON_SREP_ID |
Source Contact Owner Initials (Primary) |
SOURCE_CON_SREP_NAME |
Source Contact Owner Full Name (Primary) |
SOURCE_CON_STATE |
Source Contact State |
SOURCE_CON_SXFIRST_NAME |
Source Contact Alternate First Name (CAPS) |
SOURCE_CON_SXNAME |
Source Contact Alternate Last Name (CAPS) |
SOURCE_CON_TERRITORY |
Source Contact Territory |
SOURCE_CON_TITLE |
Source Contact Title |
SOURCE_CON_XFIRST |
Source Contact Alternate First Name |
SOURCE_CON_XLANGUAGE |
Source Contact Alternate Language |
SOURCE_CON_XLANGUAGE_DESC |
Source Contact Alternate Language Description |
SOURCE_CON_XLAST |
Source Contact Alternate Last Name |
SOURCE_CON_XLETTER_GREETING |
Source Contact Alternate Envelope Greeting |
SOURCE_CON_XNAME |
Source Contact Alternate Full Name |
SOURCE_CON_XSALUTATION |
Source Contact Alternate Salutation |
SOURCE_CON_XTITLE |
Source Contact Alternate Title |
SOURCE_CON_ZIPCODE |
Source Contact Postal Code |
SOURCE_COUNTRY |
Source Country |
SOURCE_COUNTRY_DESC |
Source Country Description |
SOURCE_EMAIL |
Source Email |
SOURCE_FAX |
Source Fax |
SOURCE_ID |
Source ID |
SOURCE_NAME |
Source Name |
SOURCE_NAME_ID |
Source Name ID |
SOURCE_NAME2 |
Source Name 2 |
SOURCE_NAME3 |
Source Name 3 |
SOURCE_PHONE |
Source Phone |
SOURCE_RELATIONSHIP |
Source Relationship Type |
SOURCE_RELATIONSHIP_DESC |
Source Relationship Description |
SOURCE_STATE |
Source State |
SOURCE_XDISPLAY_NAME |
Source Alternate Full Name |
SOURCE_XENVELOPE_GREETING |
Source Alternate Envelope Greeting |
SOURCE_XFIRST_NAME |
Source Alternate First Name |
SOURCE_XLANGUAGE |
Source Alternate Language |
SOURCE_XLANGUAGE_DESC |
Source Alternate Language Description |
SOURCE_XSALUTATION |
Source Alternate Salutation |
SOURCE_XTITLE |
Source Alternate Title |
SOURCE_ZIPCODE |
Source Postal Code |
SUPER_BLOCK_ID |
Master Block ID |
SUPER_BLOCK_RESORT |
Master Block Resort |
TAX_AMOUNT |
Tax Amount |
TBD_RATES |
N/A |
TENTATIVE_LEVEL |
N/A |
TOTAL_COMPLIMENTARY_ROOMS |
Total Complimentary Rooms |
TOTAL_REVENUE |
Total Revenue:
|
TRACECODE |
Trace Code |
UDESCRIPTION |
Business Block Name (CAPS) |
UDFC01 |
UDFC01 |
UDFC02 |
UDFC02 |
UDFC03 |
UDFC03 |
UDFC04 |
UDFC04 |
UDFC05 |
UDFC05 |
UDFC06 |
UDFC06 |
UDFC07 |
UDFC07 |
UDFC08 |
UDFC08 |
UDFC09 |
UDFC09 |
UDFC10 |
UDFC10 |
UDFC11 |
UDFC11 |
UDFC12 |
UDFC12 |
UDFC13 |
UDFC13 |
UDFC14 |
UDFC14 |
UDFC15 |
UDFC15 |
UDFC16 |
UDFC16 |
UDFC17 |
UDFC17 |
UDFC18 |
UDFC18 |
UDFC19 |
UDFC19 |
UDFC20 |
UDFC20 |
UDFC21 |
UDFC21 |
UDFC22 |
UDFC22 |
UDFC23 |
UDFC23 |
UDFC24 |
UDFC24 |
UDFC25 |
UDFC25 |
UDFC26 |
UDFC26 |
UDFC27 |
UDFC27 |
UDFC28 |
UDFC28 |
UDFC29 |
UDFC29 |
UDFC30 |
UDFC30 |
UDFC31 |
UDFC31 |
UDFC32 |
UDFC32 |
UDFC33 |
UDFC33 |
UDFC34 |
UDFC34 |
UDFC35 |
UDFC35 |
UDFC36 |
UDFC36 |
UDFC37 |
UDFC37 |
UDFC38 |
UDFC38 |
UDFC39 |
UDFC39 |
UDFC40 |
UDFC40 |
UDFD01 |
UDFD01 |
UDFD02 |
UDFD02 |
UDFD03 |
UDFD03 |
UDFD04 |
UDFD04 |
UDFD05 |
UDFD05 |
UDFD06 |
UDFD06 |
UDFD07 |
UDFD07 |
UDFD08 |
UDFD08 |
UDFD09 |
UDFD09 |
UDFD10 |
UDFD10 |
UDFD11 |
UDFD11 |
UDFD12 |
UDFD12 |
UDFD13 |
UDFD13 |
UDFD14 |
UDFD14 |
UDFD15 |
UDFD15 |
UDFD16 |
UDFD16 |
UDFD17 |
UDFD17 |
UDFD18 |
UDFD18 |
UDFD19 |
UDFD19 |
UDFD20 |
UDFD20 |
UDFN01 |
UDFN01 |
UDFN02 |
UDFN02 |
UDFN03 |
UDFN03 |
UDFN04 |
UDFN04 |
UDFN05 |
UDFN05 |
UDFN06 |
UDFN06 |
UDFN07 |
UDFN07 |
UDFN08 |
UDFN08 |
UDFN09 |
UDFN09 |
UDFN10 |
UDFN10 |
UDFN11 |
UDFN11 |
UDFN12 |
UDFN12 |
UDFN13 |
UDFN13 |
UDFN14 |
UDFN14 |
UDFN15 |
UDFN15 |
UDFN16 |
UDFN16 |
UDFN17 |
UDFN17 |
UDFN18 |
UDFN18 |
UDFN19 |
UDFN19 |
UDFN20 |
UDFN20 |
UDFN21 |
UDFN21 |
UDFN22 |
UDFN22 |
UDFN23 |
UDFN23 |
UDFN24 |
UDFN24 |
UDFN25 |
UDFN25 |
UDFN26 |
UDFN26 |
UDFN27 |
UDFN27 |
UDFN28 |
UDFN28 |
UDFN29 |
UDFN29 |
UDFN30 |
UDFN30 |
UDFN31 |
UDFN31 |
UDFN32 |
UDFN32 |
UDFN33 |
UDFN33 |
UDFN34 |
UDFN34 |
UDFN35 |
UDFN35 |
UDFN36 |
UDFN36 |
UDFN37 |
UDFN37 |
UDFN38 |
UDFN38 |
UDFN39 |
UDFN39 |
UDFN40 |
UDFN40 |
UPDATE_DATE |
Update Date |
UPDATE_USER |
Update User ID |
UPLOAD_DATE |
Upload Date |
XACC_NAME |
Company Alternate Name |
XAGENT_NAME |
Agent Alternate Name |
XSOURCE_NAME |
Source Alternate Name |
D:\micros\opera\production\runtimes\contract_sample.doc. If you do not have access to the app server files ask your system administrator to copy the file to one of your local directories and pick it up from there. Once you've found the file in your operating system search box, click on Open. This will transfer the file path into the Select File field.
Show Me