Merge Tags

 

This report is used for...

 Selecting Merge tags for customizing reports.  The list of Merge tags is available in RMS by going to the Merge Tags option on the RMS Reports Main menu.  Select the option to display the list.  Double click a merge tag from the list in RMS to copy it to your clipboard and paste in your report or custom letter. 

 

 SC = Control File (Special Control/ Company)

**SC:COMPANY.ADDRESS.LINE.1**                        Company Address Line 1

**SC:COMPANY.ADDRESS.LINE.2**                        Company Address Line 2

**SC:COMPANY.ADDRESS.LINE.3**                        Company Address Line 3

**SC:COMPANY.EMAIL.ADDRESS**                        Company Email Address

**SC:COMPANY.FAX.PHONE**                                Company Fax Number

**SC:COMPANY.NAME**                                          Company Name

**SC:COMPANY.PHONE.1**                                     Company Phone Number 1

**SC:COMPANY.PHONE.2**                                     Company Phone Number 2

**SC:COMPANY.WEB.SITE**                                    Company Web Site

**SC:CURRENT.DATE**                                            Outputs current Date (MM/DD/YYYY)

**SC:CURRENT.DATE.LONG**                                  Outputs current Date in long format (Month Day, Year)

**SC:CURRENT.TIME**                                             Outputs current time

R = Reservation file   

**R:ADVERTISING.SOURCE**                                  Advertising Source from the reservation file

**R:AGENT.ASSIGNED.DATE**                                Date when the Travel Agent was assigned to the reservation

**R:AGENT.WITHHELD.PAYMT**                              Agent withheld payment dollar amount

**R:AMENITIES.AMT**                                              Amenitiy amount

**R:ARRIVAL**                                                         Arrival date

**R:BALANCE.DUE.DATE**                                      Balance due date

**R:BALANCE.OWED**                                            Balance owed by guest

**R:BEGINNING.AMT.DUE**                                     Beginning amount due (includes charges, tax and deposit amount)

**R:BROCHURE.PROCESSED**                               Brochure processed Y/N

**R:CHG.COORD.FEE**                                           Coordination fee amount for CY reservations

**R:CLEANING.AMT**                                               Cleaning amount

**R:COMMISSION**                                      Commission amount

**R:COMP.STATUS**                                                Whether or not the reservation is complementary

**R:COUPONS.SENT**                                             Coupons sent (Y/N)

**R:DATE.OF.RESV**                                               Date that the reservation was made

**R:DEPARTURE**                                                   Departure date

**R:DEPOSIT.AMOUNT**                                          Reservation deposit amount

**R:DISCOUNT.INFO**                                              The Discount group code, if used

**R:EQUIP.RENTAL.AMT**                                        Equipment rental amount

**R:FINAL.INSTRUCT.SENT**                                    Date that the final instructions letter was printed for reservation

**R:FULFILLMENT.CODE**                                       Mail fulfillment code

**R:GROSS.DISBURSED**                                       Money as disbursed to owner

**R:GUEST.LICENSE.RECD**                                   Y/N to whether or not the GLA has been received

**R:LAST.CHANGE.DATE**                                      Date of last reservation change

**R:MID.RENTAL.CLEANING**                                  Date of mid-rental cleaning

**R:NUMBER.OF.ADULTS**                          Number of adults

**R:NUMBER.OF.CHILDREN**                                  Number of children

**R:O.NOTIFICATION.SENT**                                    Date owner notification was printed

**R:OTHER.CHARGES**                                           Total amount of charges

**R:OWNERS.GROSS.INCOME**                              Owner's gross income. The balance of reservation pre tax, charges

**R:PACK.EQUIP.AMT**                                           Total amount of equipment booked via packages

**R:PACKAGE.USED**                                             The name or key of the package used

**R:PRIMARY.LAST.NAME**                                     Last name of the primary guest

**R:PRIMARY.NAME**                                              Name of the primary guest

**R:REFERRAL.AMT**                                              Amount of the referral fee

**R:REFERRED.NAME**                                          Guest name on a referred reservation

**R:REFERRED.RESV**                                           Unit number, Travel agent/Rental discount

**R:RENTED.BEDROOMS**                                     Rooms rented (controlled by 'allow lower bedrooms' via rate)

**R:RENTER.CONFIRM.SENT**                                 Date rental confirmation sent

**R:RESERVATION.NUMBER**                                 Reservation number

**R:RESPONSE.METHOD**                          Reservation response method

**R:RESV.CHANGED.BY**                                       Last operator to change reservation

**R:RESV.MADE.BY**                                              Operator initials of booking operator

**R:RESV.NUMBER**                                               Reservation number

**R:RESV.PERCENTS**                                           Deposit, Referral, Commission and Tax percentages

**R:SALES.AGENT.ASSIGNED**                              Sales agent assignment

**R:SECTION**                                                         Unit section

**R:SECURITY.DEPOSIT**                                        Security deposit amount due

**R:SPECIAL.DESCRIPTION**                                  Special description (seen in resv view)

**R:STATUS.CODE**                                                Reservation status (A,B,C,CY,D,E)

**R:TAX.1**                                                  Tax amount 1

**R:TAX.2**                                                  Tax amount 2

**R:TAX.3**                                                  Tax amount 3

**R:TOTAL.CC.CHARGE**                                         Amount of CC charge (to owner)

**R:TOTAL.PAYMENTS.PAID**                                 Total amount paid by guest

**R:UNIT.NUMBER**                                                 Unit number (not unit ID, this is the internal RMS value)

**R:USER.FIELD.1**                                                 User miscellaneous field 1

**R:USER.FIELD.2**                                                 User miscellaneous field 2

SR (Special Reservation) = Reservation file   

**SR:AGENT.ASSIGNED.SIGNATURE**                    Agent assigned signature Line

**SR:AGENT.ASSIGNED.WRITTEN.TYPED.BY**       Agent assigned Written/Typed by initials

**SR:AGENT.ASSIGNED.PHONE**                           Agent assigned phone #

**SR:AGENT.ASSIGNED.FIRST.NAME**                   Agent assigned first name

**SR:ARRIVAL.DAY.OF.WEEK**                               Day of the week of the arrival date

**SR:ARRIVAL.LONG**                                             Outputs arrival date in long format (Month Day, Year)

**SR:ARRIVAL.NO.YEAR**                                       Month and day of arrival

**SR:ARRIVAL.SEASON**                                        Season of arrival

**SR:CC.INFO**                                                        CC #, expire, name on card, address on card, cardholder’s signature and date signed

**SR:DEPARTURE.DAY.OF.WEEK**                        Day of the week of the departure date

**SR:DEPARTURE.LONG**                                       Outputs departure date in long format

**SR:DEPARTURE.NO.YEAR**                                 Month and day of departure

R = Reservation file   

 **R:ADVERTISING.SOURCE**                                  Advertising Source from the reservation file

 

**R:AGENT.ASSIGNED.DATE**

 Date when the Travel Agent was assigned to the reservation

 

**R:AGENT.WITHHELD.PAYMT**

 Agent withheld payment dollar amount

 

**R:AMENITIES.AMT**

 Amenitiy amount

 

**R:ARRIVAL**

 Arrival date

 

**R:BALANCE.DUE.DATE**

 Balance due date

 

**R:BALANCE.OWED**

 Balance owed by guest

 

**R:BEGINNING.AMT.DUE**

 Beginning amount due (includes charges, tax and deposit amount)

 

**R:BROCHURE.PROCESSED**

 Brochure processed Y/N

 

**R:CHG.COORD.FEE**

 Coordination fee amount for CY reservations

 

**R:CLEANING.AMT**

 Cleaning amount 

 

**R:CLEANING.VENDOR**

 Cleaning vendor

 

**R:COMMISSION**

 Commission amount

 

**R:COMP.STATUS**

 Whether or not the reservation is complementary

 

**R:COUPONS.SENT**

 Coupons sent (Y/N)

 

**R:DATE.OF.RESV**

 Date that the reservation was made

 

**R:DEPARTURE**

 Departure date

 

**R:DEPOSIT.AMOUNT**

 Reservation deposit amount

 

 **R:DISBURSED.ALL**

Y/N to whether or not money was disbursed

 

**R:DISCOUNT.INFO**

 The Discount group code, if used

 

**R:EQUIP.RENTAL.AMT**

 Equipment rental amount

 

**R:FINAL.INSTRUCT.SENT**

 Date that the final instructions letter was printed for reservation

 

**R:FULFILLMENT.CODE**

 Mail fulfillment code

 

**R:GROSS.DISBURSED**

 Money as disbursed to owner

 

**R:GUEST.LICENSE.RECD**

 Y/N to whether or not the GLA has been received 

 

**R:LAST.CHANGE.DATE**

 Date of last reservation change

 

**R:MID.RENTAL.CLEANING**

 Date of mid-rental cleaning

 

**R:NUMBER.OF.ADULTS**

 Number of adults

 

**R:NUMBER.OF.CHILDREN**

 Number of children

 

**R:O.NOTIFICATION.SENT**

 Date owner notification was printed

 

**R:OTHER.CHARGES**

 Total amount of charges

 

**R:OWNERS.GROSS.INCOME**

 Owner's gross income.  The balance of reservation pre tax, charges

 

**R:PACK.EQUIP.AMT**

 Total amount of equipment booked via packages

 

**R:PACKAGE.USED**

 The name or key of the package used 

 

**R:PRIMARY.LAST.NAME**

 Last name of the primary guest

 

**R:PRIMARY.NAME**

 Name of the primary guest 

 

**R:REFERRAL.AMT**

 Amount of the referral fee

 

**R:REFERRED.NAME**

 Guest name on a referred reservation

 

**R:REFERRED.RESV**

 Unit number, Travel agent/Rental discount

 

**R:RENTED.BEDROOMS**

 Rooms rented (controlled by 'allow lower bedrooms' via rate)

 

**R:RENTER.CONFIRM.SENT**

 Date rental confirmation sent

 

**R:RESERVATION.NUMBER**

 Reservation number

 

**R:RESPONSE.METHOD**

 Reservation response method

 

**R:RESV.CHANGED.BY**

 Last operator to change reservation

 

**R:RESV.MADE.BY**

 Operator initials of booking operator

 

**R:RESV.NUMBER**

 Reservation number

 

**R:RESV.PERCENTS**

 Deposit, Referral, Commission and Tax percentages

 

**R:SALES.AGENT.ASSIGNED**

 Sales agent assignment

 

**R:SECTION**

 Unit section

 

**R:SECURITY.DEPOSIT**

 Security deposit amount due

 

**R:SPECIAL.DESCRIPTION**

 Special description (seen in resv view)

 

**R:STATUS.CODE**

 Reservation status (A,B,C,CY,D,E)

 

**R:TAX.1**

 Tax amount 1

 

**R:TAX.2**

 Tax amount 2

 

**R:TAX.3**

 Tax amount 3

 

**R:TOTAL.CC.CHARGE**

 Amount of CC charge (to owner)

 

**R:TOTAL.PAYMENTS.PAID**

 Total amount paid by guest 

 

**R:UNIT.NUMBER**

 Unit number (not unit ID, this is the internal RMS value)

 

**R:USER.FIELD.1**

 User miscellaneous field 1

 

**R:USER.FIELD.2**

 User miscellaneous field 2

 

SR (Special Reservation) = Reservation file 

 **SR:AGENT.ASSIGNED.SIGNATURE**

 Agent assigned signature Line

 

**SR:AGENT.ASSIGNED.WRITTEN.TYPED.BY**

 Agent assigned Written/Typed by initials

 

**SR:AGENT.ASSIGNED.PHONE**

 Agent assigned phone #

 

**SR:AGENT.ASSIGNED.FIRST.NAME**

 Agent assigned first name

 

**SR:ARRIVAL.DAY.OF.WEEK**

 Day of the week of the arrival date

 

**SR:ARRIVAL.LONG**

 Outputs arrival date in long format (Month Day, Year)

 

**SR:ARRIVAL.NO.YEAR**

 Month and day of arrival

 

**SR:ARRIVAL.SEASON**

 Season of arrival

 

**SR:BEGIN.DUE.LESS.ALL.DEPOSIT**

Beginning amount due minus the rental and security deposit

 

**SR:BEGIN.DUE.LESS.RENT.DEPOSIT**

Beginning amount due minus the rental deposit

 

**SR:BEGIN.DUE.LESS.SEURITY.DEPOSIT**

 Beginning amount due minus the security deposit

 

**SR:CC.INFO**

 CC #, expire, name on card, address on card, cardholder’s signature and date signed

 

**SR:DEPARTURE.DAY.OF.WEEK**

 Day of the week of the departure date

 

**SR:DEPARTURE.LONG**

 Outputs departure date in long format (Month Day, Year)

 

**SR:DEPARTURE.NO.YEAR**

 Month and day of departure

 

**SR:DEPOSIT.DETAIL**

 Deposit text detail

 

**SR:EARLY.ARRIVAL**

 Outputs Early Arrival

 

**SR:EQUIP.DETAILS**

 Equipment delivery, pickup, description, quantity and amount. For printed, in columnar format, for email one line each detail item

 

**SR:GLA.RECEIVED**

 Text whether GLA has been received or not

 

**SR:GUEST.RENT**

 Resv owner gross-rent discount+amenities+pkg equipment 

 

**SR:LATE.DEPARTURE**

 Outputs Late Departure

 

**SR:NOTES**

 Short and long note comment for control file specified categories

 

**SR:NUMBER.OF.NIGHTS**

 Reservation departure date – reservation arrival date

 

**SR:OTHER.CHARGE.DETAILS**

 Either one line for other charge amount, or split out charges to be detailed, if control file says to split out some charges.  To split out charges see  Control File>Information to Print>Resv Cong /GLA Information to Print>Chargs to itemize on Confirmation.

 

**SR:OWNER.NET**

 Owners net

 

**SR:PACKAGE.DESCRIPTION**

 Package description

 

**SR:PAY.DETAIL**

 Text for Confirmation of payments received for a single payment trans amount and date

 

**SR:RESV.TOTAL.TAX**

 Tax1+Tax2+Tax3

 

**SR:RESV.TRANS.LIST**

 List of reservation transactions

 

**SR:TRANS.MODE**

Transportation mode from the reservation maintenance screen

 

**SR:TRAVEL.INSURANCE**

 Travel insurance amount, as well as a line to decline

 

**SR:TRAVEXTRATEXT**

 

**SR:TI.NEW**

 

U = Unit file

**U:ACCOUNTING.POOL**

 

**U:AGENT.ASSIGNED**

 Rotating assignment or key of the Agent assigned to the unit

 

**U:AMOUNT.OWED.TO.OWNER**

 dollar amount owned to owner, maintained by owner statements

 

**U:BEDROOM.STATUS**

 Allow lock-off (Y/N), works with allow lower bedrooms in rate record

 

**U:CLEANING.CHARGE**

 Amount to charge owner for cleaning

 

**U:COMP.REMAIN**

 Number of comp nights remaining

 

**U:COMP.USED**

 Number of comp nights used

 

**U:DAYS.RENTED.YEAR.1**

 Number of days the unit has been rented for year 1

 

**U:DAYS.RENTED.YEAR.2**

 Number of days the unit has been rented for year 2

 

**U:DAYS.RENTED.YEAR.3**

 Number of days the unit has been rented for year 3

 

**U:DECK**

 Is there a deck Y/N

 

 **U:DEDUCT.CLEANING**

 

**U:DEPOSIT.AMOUNT**

 

**U:DISTANCE.FROM.BEACH**

 Distance description #1

 

**U:DISTANCE.FROM.POOL**

 Distance Description #2

 

**U:EXPORT.TO.BOOK.SITES**

Y/N whether unit info may be sent to booking sites

 

**U:FORWARD.BALANCE**

 Owner balance forward amount

 

**U:HIGH.SEC.DEPOSIT**

 High security deposit amount

 

**U:INTERNAL.COMMENT**

 Internal comment

 

**U:LAST.CHANGE.DATE**

 

**U:LAST.CHANGE.TIME**

 

**U:LEVEL**

 Level

 

**U:LOCATION**

 Location

 

**U:LOCK.BOX.1**

 Lock box key code #1

 

**U:LOCK.BOX.2**

 Lock box key code #2

 

**U:LOCK.BOX.3**

 Lock box key code #3

 

**U:MAX.NUMBER.OF.PEOPLE**

 Maxs number of peple for the unit

 

**U:MONTHLY.RATE**

 Monthly rate amount

 

**U:MSC.FEATURES**

 Unit features

 

**U:NUMBER.OF.BATHROOMS**

 Number of bathroom 

 

**U:NUMBER.OF.BEDROOMS**

 Number of bedrooms

 

**U:OWNER.NUMBER**

 Owner Number 

 

**U:PAYMENT**

 Pay to owner or Escrow

 

**U:PKGS.STATUS**

 Status for accepting packages

 

**U:PRICE.RANGE**

 

**U:PROCESSED.FLAG**

 Whether or not the unit has been added to the system (Y/N)

 

**U:PROPERTY.ADDRESS**

 Unit property address

 

**U:RENTAL.STATUS**

 Short term, Long Term or Both

 

**U:SALES.AGENT**

 Sales agent

 

**U:SCREENED.PORCH**

 Whether or not the unti has a screened in porch

 

**U:SECTION**

 Section

 

**U:SECURITY**

 The amount of the security deposit

 

**U:SECURITY.DEPOSIT**

 The amount of the security deposit

 

**U:SLEEPER.SOFA**

 Sleeper sofa

 

**U:SLEEPING.ACCOM**

 Unit sleeping accommodations

 

**U:SPECIAL.DESC**

 Special description

 

**U:STANDARD.RATE**

 Standard rates for unit - Year 1 * Year 2 * Year 3

 

**U:TAX.JURISDICTION**

 

**U:TELEPHONE.NUMBER**

 Unit telephone number

 

**U:TYPE**

 Unit Type - Short term, Long term or Both

 

**U:UNIT.ADDRESS.1**

Unit address found in the additional unit info

 

**U:UNIT.ADDRESS.2**

Unit address 2 found in the additional unit info

 

**U:UNIT.CITY**

City info found in the additional unit info

 

**U:UNIT.COUNTRY.CODE**

Unit Country  found in additional address info

 

**U:UNIT.DISC.LESS.2.WKS**

 

**U:UNIT.DISC.MORE.2.WKS**

 

**U:UNIT.ID**

Unit name/number entered via the UI

 

**U:UNIT.LAT**

 Unit latitude for unit olb detail pages 

 

**U:UNIT.LONG**

 Unit longitude for unit olb detail pages

 

**U:UNIT.NUMBER**

 RMS internal unit number

 

**U:UNIT.REGION**

Region found in the additional address information

 

**U:UNIT.MAX.DISCOUNT**

 

**U:UNIT.RESERVE.HELD**

 Amount of money currently held for owner reserve

 

**U:UNIT.RESERVE.TO.HOLD**

 Total amount of money to hold for owner reserve

 

 **U:UNIT.STATE**

State found in the additional address information

 

**U:UNIT.SUB.REGION**

Sub-region found in the additional address information

 

**U:UNIT.UNDER.MGT**

 Whether or not unit is under management (Y/N)

 

**U:WILL.ACCEPT.PKGS**

 Whether or not the unit will accept packages (Y/N)

 

**U:UNIT.ZIP.CODE**

Unit zip code found in the additional address information

 

**U:VIEW**

Unit view found in unit details

 

**U:WILL.ACCEPT.PKGS**

Y/N value if unit will allow packages to be booked

 

SU (Special Unit)  = Unit file 

**SU:ADDRESS.RIGHT.FORMAT**

 Unit address right formatted 30 spaces

 

**SU:LOCATION.TEXT**

 Unit location description 

 

**SU:MISC.CARS**

 Maximum cars (parking) for unit

 

**SU:MISC.CY.CLEAN**

 CY status cleaning amount

 

**SU:MISC.GROSS.DISBURSED**

 Gross Amount disbursed to owner

 

**SU:MISC.OWNER.CLEAN**

 Owner cleaning amount

 

**SU:SECTION.TEXT**

 Unit section description 

 

M = Mail file 

**M:ADDRESS.LINE.1**

 Address line 1

 

**M:ADDRESS.LINE.2**

 Address line 2

 

**M:ADVERTISING.SOURCE**

 Mail entry advertising source

 

**M:BROCHURE.PROCESSED**

 Has brochure been processed for mail entry? (Y/N)

 

**M:CELL.PHONE**

Cell phone number

 

**M:CITY**

 City

 

**M:DATE.RESERVED**

 Date of reservation

 

**M:DEPARTURE.DATE**

 Departure date of reservation

 

**M:E.MAIL**

 Email address

 

**M:EMAIL.CC.1**

E mail to send copy to

 

**M:EMAIL.CC.2**

Second E mail to send copy

 

**M:EMAIL.CC.3**

Third E mail to send copy

 

**M:FAX.PHONE**

 Fax phone number of mail entry

 

**M:FOREIGN.ADDRESS**

 Foreign address (if used)

 

**M:FOREIGN.ADDRESS.FLAG**

 Whether or not the address given is foreign

 

**M:FULFILLMENT.CODE**

 Mail entry fulfillment code

 

**M:HOME.PHONE**

 Home phone

 

**M:INQ.GRADE**

 Mail entry inquiry grade, if any

 

**M:INQ.MADE.BY**

 Operator initials of individual making the inquiry

 

**M:INQUIRY.DATE**

 Date the inquiry was made

 

**M:INQUIRY.TIME**

 Time that the inquiry was made

 

**M:LAST.NAME**

 Mail entry last name

 

**M:LEVEL**

 Mail level

 

**M:MAIL.ID**

 RMS mailing list number

 

**M:NAME**

 Full name of mailing list entry

 

**M:OFFICE.PHONE**

 Office phone

 

**M:OTHER.PHONE**

 Other phone

 

**M:OTHER.PHONE.2**

 

**M:PRIMARY.CONTACT**

 Mailing list entry primary means of contact (email or post office)

 

**M:RESPONSE.METHOD**

 Response method

 

**M:STATE**

 State

 

**M:STATUS**

 Status (owner, inquiry, previous renter)

 

**M:TIME.RESERVED**

 Time that the reservation was reserved

 

**M:UNIT.PREFERRED**

 Unit that the mailing list entry prefers

 

**M:ZIP.CODE**

 Zip code

  

SM (Special Mail) = Mail file 

**SM:ADDRESS.BLOCK**

 Puts out address line(s), city, state and zip and foreign address 

 

O = Owner file 

**O:ADDRESS.1099**

 Owner 1099 address

 

**O:BALANCE.FORWARD**

 Owner balance forward amount

 

**O:COMMENT**

 Owner miscellaneous comment

 

**O:E.MAIL**

 Owner email address

 

**O:FAX.PHONE**

 Fax phone for owner

 

**O:FEE.CODE**

 Owner fee code

 

**O:HOME.TELEPHONE**

 Owner's home telephone number

 

**O:LAST.NAME**

 Owner's last name

 

**O:MAILING.LIST.NUM**

 Owner's mailing list number

 

**O:NOT.USED.1**

 

**O:OFFICE.TELEPHONE**

 Owner's office telephone number

 

**O:OWNER.ID**

 External RMS owner id number

 

**O:OWNER.NUMBER**

 Internal RMS owner id number

 

**O:OWNERS.NAME**

 Owner name

 

**O:OWNERS.SALUTATION**

 Owner salutation

 

**O:PAY.TO.ORDER**

 Name used on owner checks

 

**O:PRINT.1099**

Y/N value whether to print owner 1099

 

**O:SALES.AGENT.ASSIGNED**

 Whether or not the owner has a sales agent assigned

 

**O:SOCIAL.SECURITY.NO**

 Owner's social security number or federal tax id

 

**O:TAX.ID.TYPE**

 Whether the number given for owner is federal id or social security

 

**O:UNITS.OWNED**

 How many units that the owner owns in RMS

 

ORL (Owner Resv Listing) = Owner file 

  **ORL:RESV.COLUMN**

 Outputs owner resv detail in columnar format as report now does

 

**ORL:RESV.PARAGRAPH**

 Outputs owner resv detail in paragraph format with all data

 

**ORL:RESV.P.NO.PEOPLE**

 Outputs owner resv detail in paragraph format, no adults/children

 

**ORL:RESV.P.NO.NAME**

 Outputs owner resv detail in paragraph format, no guest name info

 

**ORL:RESV.P.NO.PEOPLE.NO.NAME**

 Outputs owner resv detail in paragraph format, no guest name info, no adults/children

  

 

ONT (Owner Notification Resv Details) = Owner file

  **ONT:RESV.DETAIL.COLUMNS**

 Outputs owner resv detail in columnar format as report now does

 

**ONT:RESV.DETAIL.LINES**

 Outputs owner resv detail in lined format as report now does

 

D = Trans file

**D:AMOUNT**

 Transaction amount

 

**D:CHECK.NO**

 Check number

 

**D:CREATE.CONSOLE**

 console that created the transaction

 

**D:DATE.CREATED**

 The date the transaction was created

 

**D:DATE**

 Transaction date

 

**D:DEBIT.ACCT**

 Account debited

 

**D:DESCRIPTION**

 Transaction description

 

**D:DTRAN.NUMBER**

 Dtran transaction number

 

**D:INVOICE.NUM**

 Invoice number

 

**D:NAME.OF.CC.OWNER**

 Name on credit card 

 

**D:OPER.INITIALS**

 Operator initials of individual who created tranaction in RMS

 

**D:OWNER.WEEK**

 Week of transaction for owner

 

**D:POST.TO.MONTH**

 Month transaction posted to

 

**D:REF.TYPE**

 Refernce type

 

**D:REFERENCE.NUMBER**

 Reference number of transaction

 

**D:RES.NUMBER**

 Reservation number for transaction

 

 **D:SDDW.REPORTED**

 

**D:STMT.DATE**

 Statement date 

 

**D:TIME.CREATED**

 Time transaction was created

 

**D:WORKO.NUM**

 RMS workorder number associated with the transaction

 

**D:YEAR.FINALIZED**

 Year that the transaction was finalized

 

L = Long Term

**L:ARRIVAL**

 Long term reservation arrival date

 

**L:COMMENT**

 Long term reservation comment

 

**L:DEPARTURE**

 Long term reservation departure date

 

**L:HOME.TELEPHONE**

 Home phone of long term tenant

 

**L:LAST.NAME**

 Last name of long term tenant

 

**L:MAILING.LIST.NUM**

 RMS mailing list number for long term tenant

 

**L:NUMBER.OF.ADULTS**

 Number of adults on long term reservation

 

**L:NUMBER.OF.CHILDREN**

 number of children on long term reservation

 

**L:OFFICE.TELEPHONE**

 Office telephone of long term tenant

 

**L:PLACE.OF.EMPLOYMENT**

 Long term tenant place of employment

 

**L:SECURITY.DEPOSIT**

 Security deposit amount (unit file) for long term reservation

 

**L:SOCIAL.SECURITY.NO**

 Social Security number of long term tenant

 

**L:TENANT.ID.NUMBER**

 RMS long term tenant id number

 

**L:TENANT.NAME**

 Long term tenant name

 

**L:UNIT.MONTHLY.RATE**

 Monthly rate for long term reservation

 

**L:UNIT.NUMBER**

 Unit number of long term reservation

 

 Misc

 **PROMPT:(LABEL TEXT)**

 Prompt for a value to insert. Replace the text LABEL TEXT with what you want the prompt label to be.

 

Maintenance System (Work Orders)

**W:ACTUAL.PROBLEM**

 

**W:APPROVED**

 

**W:ASK.VALUES**

 

**W:BALANCE.DUE**

 

**W:BEGIN.AMT.DUE**

 

**W:CANCEL.CONSOLE**

 

**W:CANCEL.OPER**

 

**W:CATEGORY**

 

**W:CHARGE.GLS**

 

**W:CHARGE.TO**

 

**W:CHECK.NO**

 

**W:CLASSIFICATION**

 

**W:CMMO.KEY**

 

**W:COMPLETE.BY**

 

**W:COMPLETE.TIME**

 

**W:COMPLETE.VIA**

 

**W:CUSTOMER**

 

**W:DATE.BILLED**

 

**W:DATE.CANCEL**

 

**W:DATE.COMPLETED**

 

**W:DATE.REPORTED**

 

**W:DATE.UNBILLED**

 

**W:DESCRIPTION.FOR.WO**

 

**W:DESCRIPTION.TO.OWNER**

 

**W:DTRAN.KEY**

 

**W:GENERAL.COMMENT**

 

**W:INTRN.KEYS**

 

**W:INV.ITEMS**

 

**W:MARKUP.KEYS**

 

**W:NEXT.ARRIVAL**

 

**W:NUMBER.OF.REQUESTS**

 

**W:ORIG.COMPLETE**

 

**W:OTHER.ITEMS**

 

**W:OVERRIDE.AMTS**

 

**W:OWNER.CHARGE**

 

**W:PAYABLE.KEY**

 

**W:PAYMENTS.PAID**

 

**W:PRIORITY**

 

**W:PROB.GIVEN.TO**

 

**W:PROBLEM.TAKEN.BY**

 

**W:REPORTED.BY**

 

**W:REPORTED.PROBLEM.2**

 

**W:REPORTED.PROBLEM**

 

**W:RMS.VENDOR**

 

**W:SET.NUM**

 

**W:SHOW.ON.STMT**

 

**W:STAMP.APPROVAL**

 

**W:STATUS**

 

**W:STMT.DATE**

 

**W:TAX.ONE**

 

**W:TAX.THREE**

 

**W:TAX.TWO**

 

**W:TEMPLATE.BILLED**

 

**W:TIME.CANCEL**

 

**W:TIME.REPORTED**

 

**W:TOTAL.CHARGE**

 

**W:UNIT.NUMBER**

 

**W:VENDOR.CHARGE**

 

**W:VENDOR.DATE.BILLED**

 

**W:VENDOR.INVOICE**

 

**W:VENDOR.LABOR**

 

**W:VENDOR.NUMBER**

 

**W:VENDOR.PARTS**

 

**W:VENDOR.TOTAL**

 

**W:WORK.ORDER.NUMBER**

 

Work Order Special

**WS:REPORTED.BY.TEXT**

 

**WS:STATUS.TEXT**

 

**WS:UNDER.CONTRACT**

 

**WS:VENDOR.ID**

 

Unit Inventory File

**UI:AC.FILTER.SIZE.2**

 

**UI:AC.FILTER.SIZE.3**

 

**UI:AC.FILTER.SIZE**

 

**UI:AC.MAKE.AND.MODEL.1**

 

**UI:AC.MAKE.AND.MODEL.2**

 

**UI:AC.SERVICE.COMPANY**

 

**UI:ACTUAL.CLEANING.CREW**

 

**UI:APPLIANCE.SERV.COMP**

 

Unit Web

**UW:ALLOW.OLB.OWNER**

 

**UW:COMMENT.1**

 

**UW:COMMENT.2**

 

**UW:COMMENT.3**

 

**UW:COMMENT.4**

 

**UW:COMMENT.5**

 

**UW:DISC.ALLOW.OLB**

 

**UW:DISC.COMMENT.1**

 

**UW:DISC.COMMENT.2**

 

**UW:DISC.COMMENT.3**

 

**UW:DISC.COMMENT.4**

 

**UW:DISC.COMMENT.5**

 

**UW:DISC.THUMBNAIL**

 

**UW:DISC.WEBLINK**

 

**UW:FULL.PARTIAL.TN**

 

**UW:FULL.PARTIAL.WL**

 

**UW:ONLINE.BOOKING**

 

**UW:PASSWORD**

 

**UW:SECRET.ANSWER**

 

**UW:SECRET.QUESTION**

 

**UW:SHOW.UNIT.ON.WEB**

 

**UW:THUMBNAIL**

 

**UW:UNIT.NUMBER**

 

**UW:WEB.SORT.ORDER**

 

**UW:WEBLINK**

 

Date File Fields

**DT:PRIOR.MONTH.ARRIVAL**

One month of the date record, with label prior month to arrival

 

**DT:ARRIVAL.MONTH**

One month of the date record, with label for arrival

 

**DT:NEXT.MONTH.ARRIVAL**

One month of the daterecord with label next month to arrival

 

**DT:PRIORITY.ARRIVAL**

Priority for arrival day

 

**DT:PRIORITY.DEPARTURE**

Priority for departure day

 

Reservation Note Categories

**NT:RESV.CATS**

Resvervation note categories to put out

 

**NT:UNIT.CATS**

Unit note categories to put out