|
|
|
Simple Report Writer Column Filters
A list of values has been provided for certain columns when creating a filter. If the Parameter check box is selected the list of values is also available when running the report in the application. A list of values select arrow appears when the option of either In or Equal is selected. The In option displays a multi select list of values and the Equal option displays a single select list of values. The following columns have been provided with a list of values:
Column Description |
View |
Account Type |
Profile |
Communication Type 1 |
Profile |
Communication Type 2 |
Profile |
Communication Type 3 |
Profile |
Competition Code |
Profile |
Country Code |
Profile |
Credit Card Type |
Profile |
Industry Code |
Profile |
Keyword |
Profile |
Language Code |
Profile |
Market Code |
Profile |
Membership Type |
Profile |
Nationality Code |
Profile |
Owner |
Profile |
Owner Full Name |
Profile |
Phone Type |
Profile |
Priority |
Profile |
Product Interests/Interests |
Profile |
Restricted YN |
Profile |
Rooms Potential |
Profile |
Scope |
Profile |
Scope City |
Profile |
Source Code |
Profile |
State Code |
Profile |
Tax Type |
Profile |
Territory |
Profile |
Title |
Profile |
Trace Code |
Profile |
UDFC01 - UDF40 |
Profile |
UDFN01 - UDFN40 |
Profile |
VIP Code |
Profile |
|
|
Block Code |
Reservations |
Cancellation Reason |
Reservations |
CC Type |
Reservations |
Country Code |
Reservations |
Country Description |
Reservations |
Currency Code |
Reservations |
Discount Reason |
Reservations |
Extension Type |
Reservations |
Guarantee Code |
Reservations |
Insert User ID |
Reservations |
Language |
Reservations |
Language Description |
Reservations |
Market Code |
Reservations |
Market Description |
Reservations |
Membership Level |
Reservations |
Membership Type |
Reservations |
Nationality |
Reservations |
Products |
Reservations |
Rate Code |
Reservations |
Reservation Color |
Reservations |
Reservation Status |
Reservations |
Room |
Reservations |
Room Class |
Reservations |
Room Type |
Reservations |
Source Code |
Reservations |
Source Code Description |
Reservations |
Special Request |
Reservations |
Tax Type Code |
Reservations |
UDFC01 - UDF40 |
Reservations |
UDFN01 - UDFN40 |
Reservations |
Update User ID |
Reservations |
VIP Code |
Reservations |
VIP Code Description |
Reservations |
Waitlist Priority |
Reservations |
Waitlist Reason Code |
Reservations |
|
|
Adjustment Reason Code |
Financial |
Adjustment YN |
Financial |
AR Status |
Financial (with activation of AR license) |
Arrangement Code |
Financial |
Cashier ID |
Financial |
Currency Code |
Financial |
Fixed Charges YN |
Financial |
Folio Name |
Financial |
Folio Window |
Financial |
Insert User |
Financial |
Invoice Type |
Financial |
Market Code |
Financial |
Product |
Financial |
Rate Code |
Financial |
Room Class |
Financial |
Room Number |
Financial |
Source Code |
Financial |
TA Commissionable |
Financial |
Tax Deferred YN |
Financial |
Tax Generated YN |
Financial |
Tax Inclusive YN |
Financial |
Transaction Code |
Financial |
Transaction Code Group |
Financial |
Transaction Code Subgroup |
Financial |
Transaction Group Type |
Financial |
Update User |
Financial |
|
|
Account Country |
Business Block |
Account Name |
Business Block |
Account Relationship Type |
Business Block |
Account State |
Business Block |
Agent Country |
Business Block |
Agent Relationship Type |
Business Block |
Agent State |
Business Block |
All Block Owner Initials |
Business Block |
All Catering Owner Initials |
Business Block |
All Rooms Owner Initials |
Business Block |
Block Code |
Business Block |
Block Origin |
Business Block |
Block Type |
Business Block |
Booking Method |
Business Block |
Booking Owner Title |
Business Block |
Booking Type |
Business Block |
Catering Cancellation Code |
Business Block |
Catering Only Flag |
Business Block |
Catering Owner Title |
Business Block |
Catering Quoted Currency |
Business Block |
Catering Reference Currency |
Business Block |
Catering Status |
Business Block |
Channel |
Business Block |
Confirmed Resort (SFA) |
Business Block |
Contact 1 Country |
Business Block |
Contact 1 Relationship Type |
Business Block |
Contact 1 State |
Business Block |
Contact 2 Country |
Business Block |
Contact 2 Relationship Type |
Business Block |
Contact 2 State |
Business Block |
Creation User |
Business Block |
Credit Card Type |
Business Block |
Currency Code |
Business Block |
Date Definite (based on the status selected in the application setting Blocks>Date Definite. |
Business Block |
Description |
Business Block |
Elastic Flag |
Business Block |
Exchange Posting Type |
Business Block |
Lost To |
Business Block |
Main Market Code |
Business Block |
Market Code |
Business Block |
Payment Method |
Business Block |
Primary Block Owner Initials |
Business Block |
Primary Block Owner Name |
Business Block |
Primary Catering Owner Initials |
Business Block |
Primary Catering Owner Name |
Business Block |
Primary Rooms Owner Initials |
Business Block |
Primary Rooms Owner Name |
Business Block |
Property |
Business Block |
Rate Code |
Business Block |
Reservation Type |
Business Block |
Rooms Cancellation Code |
Business Block |
Rooms Local Currency |
Business Block |
Rooms Owner Title |
Business Block |
Rooms Quoted Currency |
Business Block |
Rooms Status |
Business Block |
Source |
Business Block |
Source Country |
Business Block |
Source Relationship Type |
Business Block |
Source State |
Business Block |
Trace Code |
Business Block |
UDFC01 - UDF40 |
Business Block |
UDFN01 - UDFN40 |
Business Block |
Update User |
Business Block |
|
|
Actual Attendees |
Events |
Actual Manual |
Events |
Display Doorcard |
Events |
Do Not Move |
Events |
Event Property |
Events |
Event Property |
Events |
Event Type |
Events |
Event Type |
Events |
Function Space |
Events |
Function Space Code |
Events |
Loud Event |
Events |
Package Code |
Events |
Package Description |
Events |
Property |
Events |
Rate Code |
Events |
Room Setup Style |
Events |
Status |
Events |
Column Name |
Column Description |
REASON_CODE |
Adjustment Reason Code |
IND_ADJUSTMENT_YN |
Adjustment YN |
POSTED_AMOUNT |
Amount Posted |
COMPRESSED_YN |
AR Compressed YN |
AR_LED_CREDIT |
AR Credit Amount |
AR_LED_DEBIT |
AR Debit Amount |
INVOICE_NO |
AR Invoice Number |
AR_STATE |
AR Status |
AR_TRANSFER_DATE |
AR Transfer Date |
ARRANGEMENT_CODE |
Arrangement Code |
ARRANGEMENT_TYPE |
Arrangement Description |
BILL_NO |
Bill Number |
BUSINESS_DATE |
Business Date of Transaction |
CASHIER_ID |
Cashier ID |
CHEQUE_NUMBER |
Check Number |
CURRENCY |
Currency Code |
DEP_LED_CREDIT |
Deposit Ledger Credit |
DEP_LED_DEBIT |
Deposit Ledger Debit |
DISPLAY_YN |
Display YN |
EXCHANGE_RATE |
Exchange Rate for Transaction |
FIXED_CHARGES_YN |
Fixed Charges YN |
FOLIO_TYPE |
Folio Name |
FOLIO_VIEW |
Folio Window |
TAX_ELEMENTS |
Generates |
GROSS_AMOUNT |
Gross Amount |
GUEST_ACCOUNT_CREDIT |
Guest Account Credit |
GUEST_ACCOUNT_DEBIT |
Guest Account Debit |
INTERNAL_YN |
Internal YN |
INSERT_DATE |
Insert Date |
INSERT_USER |
Insert User |
INVOICE_CLOSE_DATE |
Invoice Closing Date |
INVOICE_TYPE |
Invoice Type |
MARKET_CODE |
Market Code |
NET_AMOUNT |
Net Amount |
PACKAGE_CREDIT |
Package Account Credit |
PACKAGE_DEBIT |
Package Account Debit |
PASSER_BY_NAME |
Passerby Name |
PRICE_PER_UNIT |
Price |
PRODUCT |
Product |
QUANTITY |
Quantity of Product |
RATE_CODE |
Rate Code |
RECPT_NO |
Receipt Number |
REFERENCE |
Reference |
REMARK |
Remark |
REVENUE_AMT |
Revenue Amount |
ROOM_CLASS |
Room Class |
ROOM |
Room Number |
SOURCE_CODE |
Source Code |
TA_COMMISSIONABLE_YN |
TA Commissionable |
DEFERRED_YN |
Tax Deferred YN |
TAX_GENERATED_YN |
Tax Generated YN |
TAX_INCLUSIVE_YN |
Tax Inclusive YN |
TRX_AMOUNT |
Transaction Amount |
TRX_CODE |
Transaction Code |
TRANSACTION_DESCRIPTION |
Transaction Code Description |
TC_GROUP |
Transaction Code Group |
TC_SUBGROUP |
Transaction Code Subgroup |
TRX_DATE |
Transaction Date |
TRX_TYPE |
Transaction Type |
FT_SUBTYPE |
Transaction Group Type |
TRNS_ACTIVITY_DATE |
Transfer Date |
UPDATE_DATE |
Update Date |
UPDATE_USER |
Update User |
Column Name |
Column Description |
CANCEL_RES |
Cancel Reservations - This Year |
CANCEL_RES_LASTYR |
Cancel Reservations - Last Year |
F_B_REVENUE |
F&B Revenue - This Year |
F_B_REVENUE LASTYR |
F&B Revenue - Last Year |
NON_REVENUE |
Non Revenue - This Year |
NON_REVENUE_LASTYR |
Non Revenue - Last Year |
NO_SHOW_RES |
No Show Reservations - This Year |
NO_SHOW_RES_LASTYR |
No Show Reservations - Last Year |
OTHER_REVENUE |
Extra Revenue - This Year |
OTHER_REVENUE_LASTYR |
Extra Revenue - Last Year |
RES_ARRIVALS |
Reservation Arrivals - This Year |
RES_ARRIVALS_LASTYR |
Reservation Arrivals - Last Year |
RES_DAY_USE |
Day Use Reservations - This Year |
RES_DAY_USE_LASTYR |
Day Use Reservations - Last Year |
RES NIGHTS |
Reservation Nights - This Year |
RES_NIGHTS_LASTYR |
Reservation Nights - Last Year |
ROOM_REVENUE |
Room Revenue - This Year |
ROOM_REVENUE_LASTYR |
Room Revenue - Last Year |
F_EDITADDRTYPE |
Address Type |
F_EDITADDRESS11 |
Address1 |
F_EDITADDRESS12 |
Address2 |
F_EDITARNO |
AR Number |
F_EDITACCTCONTACT |
Billing Contact |
F_EDITCITY |
City |
F_EDITCONTRACTNO |
Contract No. |
F_EDITCOUNTRY |
Country |
F_EDITCREATED |
Creation Date |
F_EDITDATEOFBIRTH1 |
Date of Birth |
F_EDITFIRSTNAME1 |
First Name |
F_EDITNAME1, F_EDITFIRSTNAME1 |
Guest Full Name |
F_EDITSAVEHISTORY |
History YN |
F_EDITLANGUAGE |
Language |
F_MAILING |
Mailing YN |
F_EDITNAME1 |
Name |
F_EDITNATIONALITY |
Nationality |
F_EDITPASSPORT |
Passport No. |
F_EDITTELEPHONE1 |
Phone Number |
F_EDITPOSTALCODE |
Postal Code |
F_EDITTYPE |
Profile Type |
F_EDITLONGNAME |
Salutation |
F_EDITSTATE |
State |
F_EDITTITLE |
Title |
F_EDITSHORTNAME |
Title Description |
UDFC01 UDFC40 |
UDFC01 UDFC40 |
UDFD01 UDFD20 |
UDFD01 UDFD20 |
UDFN01 UDFN40 |
UDFN01 UDFN40 |
F_EDITUSERID |
User ID |
F_EDITVIP |
VIP Status |
TOTAL_CANCELS |
Cancel Rooms - This Year |
TOTAL_CANCELS_LASTYR |
Cancel Rooms - Last Year |
TOTAL_DAY_USE |
Day Use Rooms - This Year |
TOTAL_DAY_USE_LASTYR |
Day Use Rooms - Last Year |
TOTAL_NIGHTS |
Room Nights - This Year |
TOTAL_NIGHTS_LASTYR |
Room Nights - Last Year |
TOTAL_NO_SHOWS |
No Show Rooms - This Year |
TOTAL_NO_SHOWS_LASTYR |
No Show Rooms - Last Year |
TOTAL_REVENUE |
Total Revenue - This Year |
TOTAL_REVENUE_LASTYR |
Total Revenue - Last Year |
TOTAL_STAY |
Arrival Rooms - This Year |
TOTAL_STAY_LASTYR |
Arrival Rooms - Last Year |
Column Name |
Column Description |
ACCOMPANYING_NAMES |
Accompanying Guest Name |
ACCOMPANYING_YN |
Accompanying YN |
ACTUAL_CHECK_IN_DATE |
Actual Check-in Date |
TRUNC_ACTUAL_CHECK_OUT_DATE |
Actual Departure Date |
ADULTS |
Adults |
ARRIVAL_CARRIER_CODE |
Arrival Carrier Code |
ARRIVAL_COMMENTS |
Arrival Comments |
TRUNC_ARRIVAL |
Arrival Date |
ARRIVAL_STATION_CODE |
Arrival Station Code |
ARRIVAL_TIME |
Arrival Time |
ARRIVAL_TRANSPORT_CODE |
Arrival Transport Code |
ARRIVAL_TRANSPORT_TYPE |
Arrival Transport Type |
ARRIVAL_TRANPORTATION_YN |
Arrival Transport YN |
ATTACH_CC_TO_PROFILE |
Attach CC to Profile YN |
AUTHORISED_BILLING_YN |
Authorized Billing YN |
BALANCE |
Balance |
BALANCE_PACKAGES |
Package Amount Balance |
BALANCE_ROOM_REVENUE |
Room Revenue Balance |
BREAK_TO_EMPTY_ROOM_YN |
Break Share to Empty Room YN |
BUSINESS_TITLE |
Business Title |
CANCELLATION_DATE |
Cancellation Date |
CANCELLATION_NO |
Cancellation No. |
CANCELLATION_REASON_CODE |
Cancellation Reason |
CANCELLATION_REASON_DESC |
Cancellation Reason Desc |
CHILDREN_BUCKET_1 |
Children Bucket 1 |
CHILDREN_BUCKET_2 |
Children Bucket 2 |
CHILDREN_BUCKET_3 |
Children Bucket 3 |
CHILDREN_BUCKET_4 |
Children Bucket 4 |
CHILDREN_BUCKET_5 |
Children Bucket 5 |
CREDIT_CARD_EXP_DATE |
CC Exp Date |
CREDIT_CARD_NUMBER |
CC Number |
CREDIT_CARD_TYPE |
CC Type |
CHILDREN |
Children |
COMMENTS |
Comments |
COMMISSION_PAID |
Commission Amount |
COMMISSION_CODE |
Commission Code |
COMPLIMENTARY_YN |
Comp YN |
COMPANY_NAME |
Company Name |
COMPANY ID |
Company Name ID |
COMP_TYPE_CODE |
Comp Type |
CONFIRMATION_NO |
Conf Number |
CONFIRMATION_LETTER |
Confirmation Letter Format |
CONFIRMATION_LETTER_ID |
Confirmation Letter ID |
CUSTOMER_REFERENCE |
Customer Reference |
GUEST_COUNTRY |
Country Code |
GUEST_COUNTRY_DESC |
Country Description |
BUSINESS_DATE_CREATED |
Creation Date |
CREDIT_LIMIT |
Credit Limit |
CURRENC_CODE |
Currency Code |
CUSTOM_REFERENCE |
Custom Reference |
BIRTH_DATE |
Date of Birth |
DEPARTURE_CARRIER_CODE |
Departure Carrier Code |
DEPARTURE_COMMENTS |
Departure Comments |
TRUNC_DEPARTURE |
Departure Date |
DEPARTURE_STATION_CODE |
Departure Station Code |
DEPARTURE_TIME |
Departure Time |
DEPARTURE_TRANSPORT_CODE |
Departure Transport Code |
DEPARTURE_TRANSPORT_TYPE |
Departure Transport Type |
DEPARTURE_TRANSPORTATION_YN |
Departure Transport YN |
DISCOUNT_AMT |
Discount Amount |
DISCOUNT_PRCNT |
Discount Percent |
DISCOUNT_REASON_CODE |
Discount Reason |
DO_DEPARTURE_TIME |
Drop Off Time |
DO_NOT_MOVE_YN |
Do Not Move Room |
DO_NOT_UPDATE_PROFILE |
Do Not Update Profile YN |
EVENT_ID |
Event ID |
EXCHANGE_POSTING_TYPE |
Exchange Posting Type |
EXTENSION_ID |
Extension ID |
EXTN_NUMBER |
Extension No. |
EXTN_TYPE |
Extension Type |
EXT_SEQ_NO |
External Seq No. |
EXTERNAL_REFERENCE |
External Reference |
EXT_SEG_NO |
External Seg No. |
FB_REVENUE |
F&B Revenue |
FIXED_CHARGE |
Fixed Charge |
FIXED_RATE_YN |
Fixed Rate YN |
FOLIO_YN |
Folio YN |
EFFECTIVE_RATE_AMOUNT |
Full Rate Amount |
GROUP_NAME |
Group Name |
GROUP_ID |
Group Name ID |
GUARANTEE_CODE |
Guarantee Code |
GUARANTEE_CODE_DESC |
Guarantee Code Desc |
GUEST_FIRST_NAME |
Guest First Name |
GUEST_NAME_ID |
Guest Name ID |
GUEST_PRIV_YN |
Guest Privacy YN |
GUEST_SIGNATURE |
Guest Signature |
HURDLE_OVERRIDE |
Hurdle Override YN |
HURDLE |
Hurdle Rate |
INSERT_DATE |
Insert Date |
INSERT_USER |
Insert User ID |
ITEM_INVENTORY |
Item Inventory |
OVERRIDE_INVENTORY_YN |
Inventory Override YN |
GUEST_LANGUAGE |
Language |
GUEST_LANGUAGE_DESC |
Language Description |
GUEST_MIDDLE_NAME |
Middle Name |
GUEST_NAME |
Last Name |
LAST_ROOM |
Last Room No. |
LOCATOR_YN |
Locator YN |
MARKET_CODE |
Market Code |
MEMBERSHIP_ID |
Membership ID |
MEMBERSHIP_LEVEL |
Membership Level |
MEMBERSHIP_NUMBER |
Membership No. |
MEMBERSHIP_TYPE |
Membership Type |
MESSAGE_YN |
Message YN |
MULTIPLE_ADULTS_YN |
Multiple Adults YN |
MULTIPLE_CHILDREN_YN |
Multiple Children YN |
MULTIPLE_COMMENTS_YN |
Multiple Comments YN |
MULTIPLE_EXTENSIONS_YN |
Multiple Extensions YN |
MULTIPLE_FIXED_RATE |
Multiple Fixed Rate YN |
MULTIPLE_MARKET_CODE_YN |
Multiple Market Code YN |
MULTIPLE_MEMBERSHIPS_YN |
Multiple Memberships YN |
MULTIPLE_ORIGIN_OF_BOOKING_YN |
Multiple Origin Code YN |
MULTIPLE_RATE_CODE_YN |
Multiple Rate Code YN |
MULTIPLE_SHARE_AMOUNT_YN |
Multiple Share Amnt YN |
MULTIPLE_YN |
Multiple YN |
NAME_TYPE |
Name Type |
NAME_USAGE_TYPE |
Name Type |
NATIONALITY |
Nationality |
NIGHTS |
Number of Nights |
CHANNEL |
Origin Code |
ORIGINAL_END_DATE |
Original Departure Date |
BOOKED_ROOM_CATEGORY_LABEL |
Original Room Type - RTC |
PARENT_RESV_NAME_ID |
Parent Resv Name ID |
PARTY_CODE |
Party Code |
PASSPORT |
Passport No. |
PAYMENT_AMOUNT |
Payment Amount |
PAYMENT_METHOD |
Payment Method |
PAYMENT_METHOD_DESC |
Payment Method Desc |
GUEST_PHONE |
Phone Number |
REVENUE_TYPE_CODE |
PM Revenue Code |
POSTING_ ALLOWED_YN |
Post YN |
PREFERRED_ROOM_TYPE |
Preferred Room Type |
PRINT_RATE_YN |
Print Rate YN |
PRODUCTS |
Products |
PROMOTIONS |
Promotions |
PSEUDO_ROOM_TYPE |
Pseudo Room Type YN |
PU_ARRIVAL_TIME |
Pick Up Time |
RATE_CODE |
Rate Code |
RATEABLE_VALUE |
Rateable Value |
RECALCULATE_RATE_YN |
Recalculate Rate YN |
REINSTATE_YN |
Reinstated YN |
RESORT |
Property |
RESV_NAME_ID |
Reservation Name ID |
COMPUTED_RESV_STATUS |
Reservation Status |
RESTRICTION_OVERRIDE |
Restriction Override YN |
RESV_CL_DESTINATION_ID |
Resv Conf Letter Address |
RESV_CL_DESTINATION |
Resv Conf Letter Destination |
RESV_CONF_LETTER_ID |
Resv Conf Letter ID |
RESV_CONF_LETTER_STATUS |
Resv Conf Letter Status |
RESV_CONF_LETTER_LTA |
Resv Conf Letter Time |
RESERVATION_PACKAGES |
Total Package Amount |
RESERVATION_ROOM_PRICE |
Total Room Revenue |
ROOM_CLASS |
Room Class |
ROOM |
Room No. |
ROOM_REVENUE |
Room Revenue |
ROOM_CATEGORY_LABEL |
Room Type |
ROUTING_YN |
Routing YN |
SFIRST_GUEST_NAME |
Search Guest First Name |
SNAME |
Search Guest Last Name |
SGUEST_NAME |
Share Guest Name |
SHARE_AMOUNT |
Rate Amount |
SHARE_ID |
Share ID |
SHARED_YN |
Shared YN |
ORIGIN_OF_BOOKING |
Source Code |
ORIGIN_OF_BOOKING_DESC |
Source Code Desc |
SOURCE_NAME |
Source Name |
SOURCE_ID |
Source Name ID |
SUITE_WITH |
Suite Room No. |
SWCARD_ISSUE_NUMBER |
Switch Card Number |
SWCARD_START_DATE |
Switch Card Start Date |
TAX_EXEMPT_NO |
Tax Exempt No. |
NAME_TAX_TYPE |
Tax Type Code |
NAME_TAX_DESCRIPTION |
Tax Type Desc |
GUEST_TITLE |
Title |
GUEST_TITLE_DESC |
Title Description |
TOTAL_REVENUE |
Total Revenue |
TRACE_YN |
Trace YN |
ARRIVAL_DATE_TIME |
Transport Arrival Date |
DEPARTURE_DATE_TIME |
Transport Departure Date |
TRAVEL_AGENT_NAME |
Travel Agent Name |
TRAVEL_AGENT_ID |
Travel Agent Name ID |
UDFC01 UDFC40 |
UDFC01 UDFC40 |
UDFD01 UDFD20 |
UDFD01 UDFD20 |
UDFN01 UDFN40 |
UDFN01 UDFN40 |
UPDATE_DATE |
Update Date |
UPDATE_USER |
Update User ID |
VIDEO_CHECKOUT_YN |
Video Checkout YN |
VIP |
VIP Code |
GUEST_VIP_DESC |
VIP Code Description |
WL_TELEPHONE_NO |
Waitlist Phone No. |
WL_PRIORITY |
Waitlist Priority |
WL_REASON_CODE |
Waitlist Reason Code |
WL_REASON_DESCRIPTION |
Waitlist Reason Description |
WALKIN_YN |
Walkin YN |
YIELDABLE_YN |
Yieldable Rate YN |
Column Name |
Column Description |
Only display |
ACC_ADDRESS1 |
Account Address 1 |
|
ACC_ADDRESS2 |
Account Address 2 |
|
ACC_CITY |
Account City |
|
ACC_CITY_EXT |
Account City Extension |
|
ACC_COUNTRY |
Account Country |
|
ACC_EMAIL |
Account Email |
|
ACC_FAX |
Account Fax |
|
ACC_ID |
Account ID |
|
ACC_NAME |
Account Name |
|
ACC_NAME2 |
Account Name 2 |
|
ACC_NAME3 |
Account Name 3 |
|
ACC_PHONE |
Account Phone |
|
ACC_RELATIONSHIP |
Account Relationship Type |
|
ACC_RELATIONSHIP_DESC |
Account Relationship Description |
|
ACC_STATE |
Account State |
|
ACC_ZIPCODE |
Account Postal Code |
|
ACTUAL_AVG_RATE |
Actual Average Rate |
|
ACTUAL_REVENUE |
Actual Room Revenue |
|
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_COUNTRY |
Agent Country |
|
AGENT_EMAIL |
Agent Email |
|
AGENT_FAX |
Agent Fax |
|
AGENT_ID |
Agent ID |
|
AGENT_NAME |
Agent Name |
|
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_ZIPCODE |
Agent Postal Code |
|
ALIAS |
Alias |
|
ALLOTMENT_CODE |
Block Code |
|
ALLOTMENT_ORIGION |
Block Origin |
|
ALLOTMENT_TYPE |
Block Type |
|
ALL_OWNERS |
All Block Owner Initials |
|
ARRIVAL_TIME |
Arrival Time |
|
ATTENDEES |
Attendees |
|
AVAILABLE_REVENUE |
Available Revenue |
|
AVAILABLE_ROOMS |
Available Rooms |
|
AVG_PEOPLE_PER_ROOM |
Avg People per Room |
|
AVG_RATE |
Avg Rate |
|
BEGIN_DATE |
Start Date |
|
BFST_DESC |
Breakfast Description |
S |
BFST_PRICE |
Breakfast Price |
S |
BFST_YN |
Breakfast Included Flag |
S |
BOOKING_STATUS |
Rooms Status |
|
BOOKINGMETHOD |
Booking Method |
|
BOOKINGMETHODDESC |
Booking Method Description |
|
BOOKINGTYPE |
Booking Type |
|
BUSBLOCK_ID |
Business Block ID |
|
BUSBLOCK_PROPERTY |
Property |
|
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 |
S |
CAT_CANX_DATE |
Catering Cancellation Date |
S |
CAT_CANX_DESC |
Catering Cancellation Description |
S |
CAT_CANX_NO |
Catering Cancellation Number |
S |
CAT_CURRENCY |
Catering Reference Currency |
S |
CAT_DECISION |
Catering Decision Date |
S |
CAT_EXCHANGE |
Catering Exchange Rate |
S |
CAT_FOLLOWUP |
Catering Follow Up Date |
S |
CAT_OWNER |
Primary Catering Owner ID |
S |
CAT_OWNER_CODE |
Primary Catering Owner Initials |
S |
CAT_OWNER_EMAIL |
Catering Owner Email |
S |
CAT_OWNER_FAX |
Catering Owner Fax |
S |
CAT_OWNER_PHONE |
Catering Owner Phone |
S |
CAT_OWNER_SREPNAME |
Primary Catering Owner Name |
S |
CAT_OWNER_TITLE |
Catering Owner Title |
S |
CAT_OWNERS |
All Catering Owner Initials |
S |
CAT_QUOTE_CURR |
Catering Quoted Currency |
S |
CAT_REVENUE |
Catering Revenue |
S |
CAT_REVENUE_EXP |
Expected Event Catering Revenue. |
S |
CAT_REVENUE_FOR |
Forecasted Event Catering Revenue. |
S |
CAT_STATUS |
Catering Status |
S |
CATERINGONLY_YN |
Catering Only Flag |
S |
CHANNEL |
Channel |
|
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 |
|
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_BUSINESS_GREETING |
Contact 1 Business Greeting |
|
CON_CITY |
Contact 1 City |
|
CON_CITY_EXT |
Contact 1 City Extension |
|
CON_COUNTRY |
Contact 1 Country |
|
CON_DEPARTMENT |
Contact 1 Department |
|
CON_FIRST |
Contact 1 First Name |
|
CON_ID |
Contact 1 ID |
|
CON_LAST |
Contact 1 Last Name |
|
CON_LETTER_GREETING |
Contact 1 Salutation |
|
CON_MIDDLE |
Contact1 Middle Name |
|
CON_NAME |
Contact 1 Full Name |
|
CON_POSITION |
Contact 1 Position |
|
CON_RELATIONSHIP |
Contact 1 Relationship Type |
|
CON_RELATIONSHIP_DESC |
Contact 1 Relationship Description |
|
CON_STATE |
Contact 1 State |
|
CON_XFIRST |
Contact 1 Native First Name |
|
CON_XLAST |
Contact 1 Native Last Name |
|
CON_XLETTER_GREETING |
Contact 1 Native Envelope Greeting |
|
CON_XNAME |
Contact 1 Native Full Name |
|
CON_XSALUTATION |
Contact 1 Native Salutation |
|
CON_XTITLE |
Contact 1 Native Title |
|
CONTACT_EMAIL |
Contact 1 Email |
|
CONTACT_FAX |
Contact 1 Fax |
|
CONTACT_PHONE |
Contact 1 Phone |
|
CONTACT_ZIPCODE |
Contact 1 Postal Code |
|
CONTRACT_NR |
Contract Number |
S |
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_DEF (based on the status selected n the application setting Blocks>Date Definite. |
Date Definite |
|
DEPARTURE_TIME |
Departure Time |
|
DESCRIPTION |
Description |
|
DESTINATION |
Lost To |
|
DETAILS_OK_YN |
Details OK Flag |
S |
DISTRIBUTED_YN |
Distributed Flag |
S |
ELASTIC |
Elastic Flag |
|
END_DATE |
End Date |
|
EVENTS_GUARANTEED_YN |
Events Guaranteed Flag |
S |
EXCHANGE_POSTING_TYPE |
Exchange Posting Type |
|
EXCHANGE_RATE |
Exchange Rate |
|
EXTERNAL_LOCKED |
Locked Externally Flag |
|
FB_REVENUE |
F&B Revenue |
S |
FB_REVENUE_EXP |
Expected Event F&B Revenue. |
S |
FB_REVENUE_FOR |
Forecasted Event F&B Revenue |
S |
FUNCTIONTYPE |
Function Type |
|
GUARANTEE_CODE |
Reservation Type |
|
IATA_CORP_NO |
IATA / CORP Number |
|
INACTIVE_DATE |
Inactive Date |
|
INFOBOARD |
Infoboard |
S |
INSERT_DATE |
Creation Date |
|
INSERT_USER |
Creation User |
|
INV_CUTOFF_DATE |
Rooms Cutoff Date |
|
INV_CUTOFF_DAYS |
Cutoff Days |
|
MAINMARKET |
Main Market Code |
|
MARKET_CODE |
Market Code |
|
METHOD_DUE |
Rooming List Due Date |
|
OTHER_REVENUE |
Other Revenue |
|
OTHER_REVENUE_EXP |
Expected Event Other Revenue. |
S |
OTHER_REVENUE_FOR |
Forecasted Event Other Revenue. |
S |
OWNER |
Primary Block Owner ID |
|
OWNER_CODE |
Primary Block Owner Initials |
|
OWNER_CODE_SREPNAME |
Primary Block Owner Name |
|
OWNER_EMAIL |
Booking Owner Email |
|
OWNER_FAX |
Booking Owner Fax |
|
OWNER_PHONE |
Booking Owner Phone |
|
OWNER_TITLE |
Booking Owner Title |
|
PAYMENT_METHOD |
Payment Method |
|
PORTERAGE_PRICE |
Porterage Price |
S |
PORTERAGE_YN |
Porterage Included Flag |
S |
PROFILE_DESC |
Linked Potential Description |
S |
PROFILE_ID |
Linked Potential ID |
S |
RATE_CODE |
Rate Code |
|
REPRESENTATIVE |
Representative On Site |
S |
RESORT_BOOKED |
Confirmed Resort (SFA) |
S |
REV_BLOCKED |
Revenue Blocked |
|
RMS_BLOCKED |
Room Blocked |
|
RMS_CURRENCY |
Rooms Local Currency |
|
RMS_DECISION |
Rooms Decision Date |
|
RMS_EXCHANGE |
Rooms Exchange Rate |
|
RMS_FOLLOWUP |
Rooms Follow Up Date |
|
RMS_OWNER |
Primary Rooms Owner ID |
|
RMS_OWNER_CODE |
Primary Rooms Owner Initials |
|
RMS_OWNER_EMAIL |
Rooms Owner Email |
|
RMS_OWNER_FAX |
Rooms Owner Fax |
|
RMS_OWNER_PHONE |
Rooms Owner Phone |
|
RMS_OWNER_SREPNAME |
Primary Rooms Owner Name |
|
RMS_OWNER_TITLE |
Rooms Owner Title |
|
RMS_OWNERS |
All Rooms Owner Initials |
|
RMS_QUOTE_CURR |
Rooms Quoted Currency |
|
ROOMS_PER_DAY |
Peak Rooms |
S |
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_BUSINESS_GREETING |
Contact 2 Envelope Greeting |
|
SEC_CON_CITY |
Contact 2 City |
|
SEC_CON_CITY_EXT |
Contact 2 City Extension |
|
SEC_CON_COUNTRY |
Contact 2 Country |
|
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_LAST_NAME |
Contact 2 Last Name |
|
SEC_CON_LETTER_GREETING |
Contact 2 Salutation |
|
SEC_CON_MIDDLE_NAME |
Contact 2 Middle Name |
|
SEC_CON_PHONE |
Contact 2 Phone |
|
SEC_CON_POSITION |
Contact 2 Position |
|
SEC_CON_RELATIONSHIP |
Contact 2 Relationship Type |
|
SEC_CON_RELATIONSHIP_DESC |
Contact 2 Relationship Description |
|
SEC_CON_STATE |
Contact 2 State |
|
SEC_CON_XENVELOPE_GREETING |
Contact 2 Native Envelope Greeting |
|
SEC_CON_XFIRST_NAME |
Contact 2 Native First Name |
|
SEC_CON_XFULL_NAME |
Contact 2 Native Full Name |
|
SEC_CON_XLAST_NAME |
Contact 2 Native Last Name |
|
SEC_CON_XSALUTATION |
Contact 2 Native Salutation |
|
SEC_CON_XTITLE |
Contact 2 Native Title |
|
SEC_CON_ZIP_CODE |
Contact 2 Postal Code |
|
SERVICE_CHARGE |
Service Charge |
S |
SHOULDER_BEGIN_DATE |
Shoulder Begin Date |
S |
SHOULDER_END_DATE |
Shoulder End Date |
S |
SOURCE |
Source |
|
SOURCE_ADDRESS1 |
Source Address 1 |
|
SOURCE_ADDRESS2 |
Source Address 2 |
|
SOURCE_CITY |
Source City |
|
SOURCE_CITY_EXT |
Source City Extension |
|
SOURCE_COUNTRY |
Source Country |
|
SOURCE_EMAIL |
Source Email |
|
SOURCE_FAX |
Source Fax |
|
SOURCE_ID |
Source ID |
|
SOURCE_NAME |
Source Name |
|
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_ZIPCODE |
Source Postal Code |
|
SUPER_BLOCK_ID |
Master Block ID |
|
TAX_AMOUNT |
Tax Amount |
S |
TBD_RATES |
TBD Rates Flag |
S |
TOTAL_COMPLIMENTARY_ROOMS |
Total Complimentary Rooms |
|
TOTAL_REVENUE |
Total Revenue |
|
TRACECODE |
Trace Code |
|
UDFC01 - UDFC40 |
UDFC01 - UDF40 |
|
UDFD01 - UDFD20 |
UDFD01 - UDFD20 |
|
UDFN01 - UDFN40 |
UDFN01 - UDFN40 |
|
UPDATE_DATE |
Update Date |
|
UPDATE_USER |
Update User |
|
XACC_NAME |
Account Native Name |
|
XAGENT_NAME |
Agent Native Name |
|
XSOURCE_NAME |
Source Native Name |
|
Column Name |
Column Description |
ACTUAL_ATTENDEES |
Actual Attendees |
ACTUAL_MANUAL |
Actual Manual |
ACTUAL_REVENUE |
Actual Revenue |
ALLOW_REGISTRY_YN |
Registration Required Y/N |
ATTENDEES |
Attendees |
BILLED_REVENUE |
Billed Revenue |
BOOK_ID |
Business Block ID |
DISCOUNT_PERCENTAGE |
Discount Percentage |
DO_NOT_MOVE_YN |
Do Not Move Y/N |
DISPLAY_DOORCARD_YN |
Display Doorcard Y/N |
EVENT_END_DATE |
End Date |
EVENT_END_TIME |
End Time |
EVENT_ID |
Event ID |
EVENT_NAME |
Event Name |
EVENT_START_DATE |
Start Date |
EVENT_START_TIME |
Start Time |
EVENT_STATUS |
Status |
EVENT_TIME |
Event Time |
EVENT_TYPE |
Event Type |
EV_RESORT |
Event Property |
EXPECTED_REVENUE |
Expected Revenue |
FORECAST_REVENUE |
Forecasted Revenue |
GEM$EVENT.EXCLUDE_FROM_FORECAST_YN |
Exclude From Forecast |
GEM$EVENT.FORECAST_REVENUE_ONLY_YN |
Forecast Revenue Only |
GEM$EVENT.SET_ATTENDEES |
Set Attendees |
GUARANTEED |
Minimum Guaranteed |
GUARANTEED_REVENUE |
Guaranteed Revenue |
LOUD_EVENT_YN |
Loud Event Y/N |
MASTER_EVENT_ID |
Master Event ID |
PKG_CODE |
Package Code |
PKG_NAME |
Package Description |
RATECODE |
Rate Code |
RATE_AMOUNT |
Rate Amount |
REG_ATTENDEES |
Attendees (Registered) |
RESORT |
Business Block Property |
ROOM |
Function Space Code |
ROOM_NAME |
Function Space |
ROOM_SETUP |
Room Setup Style |
SETDOWN_TIME |
Minimum Setdown Time |
SETUP_SETDWN_TIME |
Total Event Time (with Setup/Setdown) |
SETUP_TIME |
Minimum Setup Time |
Column Name |
Column Description |
ACCOUNT_ID |
Account ID |
ACCOUNT/COMPANY |
Account/Company |
ACTIVITY_ID |
Activity ID |
OWNER |
Owner |
ACTIVITY_TYPE |
Activity Type |
ASSIGNED_ON_DATE |
Assigned on Date |
BUSINESS_BLOCK_ID |
Business Block ID |
BUSINESS_BLOCK |
Business Block |
BLOCK_CODE |
Block Code |
COMPLETED_DATE |
Completed Date |
CONTACT_NAME_ID |
Contact Name ID |
CONTACT_DATE |
Contact Name |
CREATED_DATE |
Created Date |
DURATION |
Duration |
TIME_UNIT_CODE |
Time Unit Code |
TIME_UNIT_DESCRIPTION |
Time Unit Description |
END_DATE |
End Date |
INSERT_DATE |
Insert Date |
INSERT_USER |
Insert User |
NOTES |
Notes |
PARENT_ACTIVITY_ID |
Parent Activity ID |
PRIORITY_CHANGED_YN |
Priority Changed YN |
PRIORITY_CODE |
Priority Code |
PRIORITY_DESCRIPTION |
Priority Description |
PRICATE_YN |
Private YN |
PURPOSE |
Purpose |
PROPERTY |
Property |
START_DATE |
Start Date |
TRACE_CODE |
Trace Code |
UPDATE_DATE |
Update Date |
UPDATE_USER |
Update User |
