SQL - InnQuest Extension Functions

(roomMaster SQL Extensions)

There are five InnQuest (roomMaster) Extensions that can be used when creating SQL Statements.

• RESERVETOTALSTAY for reservations when using RESERVE

• FOLIOTOTALSTAY for folios when using FOLIOHD

• RATETOTALSTAY for rates when using FORECAST

• FOREIGNCURRENCY to convert any monetary value to a different currency

• CREATEFIELD creates a new field with a value from Clarion Syntax

Each extension function converts an existing column to the new value. These extension functions are needed to further define a value using an internal roomMaster calculation since these values are not stored in the tables but must be calculated at runtime.

To calculate the value, the extension function must contain the column number OR column name where the value will appear and holds the initial parameter as well as additional parameters to further define the results. Extension functions can only be called at the bottom portion of the SQL Statement, after the SUBTOTAL functions.

important

All extensions (ISQL and roomMaster) must be at the very bottom of the entire SQL Syntax, even when using UNION ALL.

For Example:

sql statement union all sql statement union all sql statement ISQL Functions
InnQuest (roomMaster) Extension functions