npm package: @rofer/magic-mike
Description: [#](#) Magic Mike (ALPHA)
Latest version: 0.0.20

[#](#) Magic Mike (ALPHA)

## Ratonale

This is a package for interacting with the CRM designed to make it easy to do so. This is achieved through the following techniques:

- batching all requests in bundles of 100, maximum 300 records per minute.
- caching all tracked records in a local database
- typescript interfaces for all entities
- runtime validation for all write fields


## Features

 - [X] Create \U+1F525
 - [X] Update
 - [X] Read (by hash) 
 - [ ] Read (by query)
 - [ ] Delete (by hash with test flag only)


## Notes
In this guide top level await is used. As of node 18.12.1 this is not supported. I used this to make the code more readable and concice. You can wrap your code in an async function to make the code work in the expected way. Example:


```typescript

import {MagicMike} from '@rofer/magic-mike'

const MM = new MagicMike(<username>, <password>, options?);

async function main() {

const rid = await MM.tables.masterReservations.fetchNewId()
console.log({rid})

}

main()

```


## Usage

```typescript
npm install @rofer/magic-mike
```


### Create a Reservation

```typescript
import {MagicMike} from '@rofer/magic-mike'

const MM = new MagicMike(<username>, <password>, options?);

const rid = await MM.tables.masterReservations.fetchNewId()

const response = await MM.tables.masterReservations.set(rid, {
  anyAdditionalNotes: 'this is a note'
})

```

### Update a Reservation
```typescript

import {MagicMike} from '@rofer/magic-mike'

const MM = new MagicMike(<username>, <password>, options?);

const res = await MM.tables.masterReservations.set(<hash>,{
  'Any Additional Notes': 'hello world',
  'TestReservation': true
})

```

### Read a Reservation
```typescript
import {MagicMike} from '@rofer/magic-mike'

const MM = new MagicMike(<username>, <password>, options?);

const res = await MM.tables.masterReservations.get(<hash>)
console.log({res})
//  {res: {reservationIdNumber: '1234', anyAdditionalNotes: 'hello world'...ect.}}

```

### Write to a Date Field 

Magic mike supports native date object use
- TODO: add string support

```typescript
import {MagicMike} from '@rofer/magic-mike'
const MM = new MagicMike(<username>, <password>, options?);

const rid = await MM.tables.masterReservations.fetchNewId()

const res = await crm.tables.masterReservations.set(rid, {
  'Any Additional Notes': 'hello world',
  'TestReservation': true
  'Date of Booking': new Date()
})

```


### Check the health of the app

Because Magic-Mike is a mirror database there is a possiblity that the database is out of sync with the CRM. We have done a mountain of work to ensure that the reach of this issue is small. To measure potential issues we have included a check health function that pulls a random sample from Magic-Mike, then pulls those ids from CRM and compares them. It returns the total records pulled, the amount of records that are the same, the health percentage, the amount of records pulled with a flag to identify which record was bad and the an array of differences (if any). The default (100 records) is the maximum allowed to inhibit flooding CRM with requests as the health check must be done synchronously, however you can pass a smaller number if you wish to increase the speed.

In testing the health has been identified as ~99.95% accuracy with a sample of 1000 records accross 25 tests. I expect this number to continue to move up as Magic-mike is used as the input for our apps as I expect 2 contributing factors to move the needle. 

1) Changes will not come from CRM itself, apps will tell magic mike to update the CRM. This will reduce the number of changes that are not reflected in magic mike.
2) As the load on Magic-Mike increases, the load on CRM will decrease by at-least a factor of 100 because the batch size is 100, this is a conservative estimate as it does not take into account any other efficiencies picked up by pulling directly from Magic-Mike and bypassing the CRM completely. I expect with a smaller load the CRM API to increase in accuracy.


```typescript
import {MagicMike} from '@rofer/magic-mike'
const MM = new MagicMike(<username>, <password>, options?);

const healthReport = await MM.utils.checkHealth()
// will run the health check off of 100 records


const healthReport = await MM.utils.checkHealth(20)
// will run the health check off of 20 records

```




### Use the Caching Feature

Magic mike by default only uses cached reservations. This is to prevent overloading the CRM with requests. The way that this is achieved is by maintaining 1000 blank records on any given table at any given time. When calling 'fetch new id' it pops a fresh blank id off of the top of the stack and makes it available to you; this is done on the backend inside of a transaction block to ensure cached id's are not reused. Periodically Magic Mike will make requests to the crm to clean up any pulled cached reservations that have not been used.

```typescript
const rid = await MM.tables.masterReservations.fetchNewId()

console.log({rid})
// {rid: '84e0f6f627c68e7a4185bf18c682d2e7d012'}

// refreshing the cache manually, feature for debugging only and will be removed in production
await MM.utils.refreshCache()

```

### Options 

| Option        | Type             | Description                                                                                                                                                   |
| ------        | ----             | -----------                                                                                                                                                   |
| forceProd     | boolean          | Force Magic-mike to use the remote api, rather than local emulators                                                                                           |
| versionTarget | 'prod' \| 'beta' | Which backend to use, use beta for changes not yet pushed to prod, warning beta is unstable because beta is where all the cutting edge features are developed |

### Return types

When you read from a table the return type is an object with the keys the labels of the fields, and the values being the values of the fields
When you write to a table the return type is a string, of either 'success' or 'fail' if failure the underlying axios library will also throw 500
# Table Write Information
## master-reservations
| Field | Type | id | choices* |
| ---- | ---- | ---- | --- |
| dateCreated | unknown | 1 | NA |
| dateOfBooking | date (yyyy-MM-dd) | 12 | NA |
| reservationIdNumber | recordid, (no write) | 3 | NA |
| destination | text (string) | 31 | SLR - Orlando, FL, OPS - Orlando, OPS - Myrtle Beach, OPS - Punta Cana, OPS - San Diego, OPS - Branson, OPS - Las Vegas, OPS - Palm Springs, OPS - Breckenridge, OPS - Open Destination, MST - Travel America Promotion, MST - Double the Destinations*, SMD - Gatlinburg, TN |
| guestFullName | text (string) | 79 | NA |
| spouseFullName | text (string) | 84 | NA |
| emailAddress | email (\w+@\w+\.\w+) | 78 | NA |
| maritalStatus | text (string) | 81 | Married, Single Female, Single Male, Co-Hab, Married/Co-Hab (Male Couples), Married/Co-Hab (Female Couples) |
| alternateNumber | phone ((\d{3}) \d{3}-\d{4}) | 76 | NA |
| phoneNumber | phone ((\d{3}) \d{3}-\d{4}) | 82 | NA |
| roomType | text (string) | 33 | Standard - Sleeps (4), Executive King - Sleeps (2), 1 Bedroom - Sleeps (4), 2 Bedroom - Sleeps (6), 3 Bedroom - Sleeps (8), Oceanfront Suite - Sleeps (6), Oceanfront Standard - Sleeps (4), Junior Suite - Sleeps (4) |
| sourceCode | text (string) | 47 | Online Package Sales, Seychelle_MB, Seychelle_PC, Package Sales, Past Guest, Previous Package, Referral, SLR NRO, TIG, ORL_1, ORL_5, ULV, SD_3, MB_2, PC_4, na, MB_3, ORL_6, PC_5, SD_4, MB_2_Conversions, ORL_7_Conversions, MB_5, PC_6_Retarget, MB_4_Retarget, CORP, ORL_7_Retarget_Conversion, SOFLO, BR_2_Retarget_Conversion, SD_6_Retarget_Conversion, PC_7_Conversions, MB_6_Traffic, ORL_8_Retarget_Conversion, BR_3_Traffic, MB_8_Retarget_Conversion, MB_5_Retarget_2_Conversion, SD_5_Retarget_2_Conversion, PC_4_Conversions, PC_8_Conv_3/22, ORL_9_Conv, ORL_9_Conv_3/22, SD_8_Retarget_Traffic_1, BR_4_Conv, PC_8_Retarget_1, MB_9_Conv, SD_8_Conv_3/22, ., PC_8_Retarget_2, MB_9_Retarget, email_retarget_orl, MB_9_Retarget_Traffic_2, PC_9_Retarget_Traffic, ORL_10_Conv_3/29, MB_10_Conv, SD_9_Conv_3/29, BR_5_Conv_3/29, Orl_10_Conv, BR_5_Retarget_Conv, ORL_10_Retarget_Conv, LV_3_Conv_3/29, SD_9_Retarget_Conv, email_retarget_mb, PC_9_Conv_3/29, SUN, PC_9_Retarget_Conv, PC_10_Conv_4/5, PC_10_R1_Conv, PC_10_R2_Conv, BR_6_R2_Conv, MB_11_R1_Conv, BR_6_Conv_4/5, VHQ, ORL_11_R1_Conv, PC_11_R1_Conv, ORL_12_R1_Conv, ORL_12_R2_Conv, BR_7_Traffic_4/13, MB_12_Traffic_4/13, MB_12_R2_Conv, MB_12_R1_Conv, PC_Email_New, JAY, PC_11_Traffic_4/13, BR_7_R2_Conv, SD_11_Traffic_4/13, PC_11_R2_Conv, SD_11_R2_Conv, FTL, 2FreeNites Pipeline, T4L Pipeline, Travel Options Pipeline (Test), BRB Pipeline, TOP Pipeline, New GCG Pipeline, DOUBLE DESTINATIONS, LV_6_Traffic_4/19, ORL_13_R1_Conv, PC_12_Conv_4/19, CPA, MB_13_R1_Conv, PS_3_R1_Conv, LV_6_Conv_4/19, MB_12_Traffic_4/19, B2B Pipeline, VG, SD_12_R1_Conv, SD_12_Traffic_4/19, BR_8_R1_Conv, PC_12_Traffic_4/19, MyrtleBeach, 101 deal, Trade Show Travel, ULV Pipeline Acquisition, MB_13_Traffic_4/19, PS_2_Traffic_4/13, PS_3_Traffic_4/19, PC_13_Conv_5/4, T2V, ORL_14_Traffic_5, ORL_14_Traffic_5/4, BR_8_Traffic_5/4, none, PS_4_Traffic_5/4, BR_9_traffic_5/13_2, MB_14_Traffic_5/13_1, BTI, OPS, ORL_16_traffic_5/20_lookalike_audience_1%, PC_13_traffic_5/4_2, MB_14_Traffic_5/13_4, LV_7_traffic_5/14_1, LV_8_traffic_5/20_3_audience_1, PC_13_Traffic_5/28, Mkt Pkgs, BR_9_traffic_5/20, FP/NS, New Mini-Vacs, BAS, Timeshare Companies, LV_10_Traffic_6/11_Lookalike_audience_1%, Chat Team Unknown Source, 828, SAM Pipeline, PES Pipeline Upload, PCNEW_email, New Package Sales Specific, Festiva Specific Owners, PC_Conversions_6/28_CBO, Punta Cana_05/18/21_Traffic, PC_Traffic_7_Carousel, PC_Conv_7/1_Women_Only, ACT, Westgate Specific Property, MB_16_Traffic_7/13, Google, PC_Traffic_7/2_Carousel, MB_16_Traffic_7/13_Blue, $$ - BG Show Leads, PCvsDR_Traffic_7/16_PC, ORLNEW_email, test ad, BS_1, MB_traffic_7/30_couple, ORL_Traffic_7/30_orange, Purchase A Trip, New Specific City, Show Leads, vimeo, Booking report East, PCLast_30_Day_Conversions, Myrtle Beach Guests, Specific City, ViciDial, Carolina packages, Cruise Leads, 350 MINI VACS, BRB Pipeline Test, Westgate TNB, Seaglass Bluegreen, Original Benjamins, KMM, Festiva Guests, Westgate Owners, 2016 Bookings, Westgate Specific, Marketing TNBs, OUTBOUND, Affiliate Resorts, Westgate 2015 TNB, Booking report mid, Vacation Destinations, Departure Program, HBNTRAVEL, Recent TNBS, SAC, Diamond Tour No Buys, festiva owner base, BOOK VIP, Silver Lake, OG Benjamins, ATL IB, Specfic Resort TNB, MBACT, MB Special Guest, 828ITYS, vip 1, WPBLeadCampaign, MB Bluewater Hotel, Pre-Arrival, New Past Guest MB BG, PC 12 Traffic 4/19, New Leads, Diamond TNBs, past �guest mb, MKT PKG SPEC CITY, Daytona Guest, specific destination, New Las Vegas, ST. Augustine/Bluegreen, St. augustine, Tropical Getaways, 99 Deposit, New Marketing Packages, FVR, 2016 Package Sales, 2016 Specific City, Wyndham Poinst Owners, 2017 New Package Sales IMS, Seychelle, BIV, TNB, Ari, WWV Reservation Live Transfer, BVD Reservation Live Transfer, 816, undecided, VG JAY, PC_November_Daily_Email_Blast, Sunset Pipeline Upload, Global Vacations, Sunset Pipeline Upload 11.11.21, Sunset Pipeline Upload 11.12.21, Marriott List, Ocean Isle 2016, Wyndham All Owners, Booking Report West, 2017 expired, PC_Traffic_11/30, 779, PC_December_Daily_Email_Blast, SNG Pipeline Acquisition 1/12/22, DLUX, blog_Allinclusive_vday, TEMPORARY CONSOLIDATION, SAM Pipeline Acquisition 3/31/22, SUN Live Transfer, RESGO, Wyndham Hotel Stays, GLX Live Transfer, MayEmail1CouponButton, Hotel Partners, Booksi Reservation, Booksi New Sale, SAM Pipeline Acquisition 6/10/22, Blake Hotel New Orleans, Tahiti Resort, Doubletree by Hilton Savannah, Mountain Club on Loon, Westgate Cocoa Beach Resort, Westgate Lakes Resort & Spa, Villa Del Palmar Cabo, Drury Inn and Suites, Westgate Myrtle Beach Oceanfront Resort, Westgate Smokey Mtn Resort, Cambria New Orleans, Palmera Inn & Suites, Hilton Garden Inn Charleston / Mt. Pleasant, Crown Reef, Westgate Las Vegas Resort & Casino, Villa Del Palmar Cancun, RafaSdk, Sunscape Akumal Beach Resort & Spa, Best Western Castillo Del Sol, Westgate Historic Williamsburg Resort, Flagship Resort, Cambria Hotel Mount Pleasant, Eilan Hotel And Spa, Poconos Mountain Villas, River Green Resort, Fantasea Resorts at Atlantic Palace, Dana Point Marina Inn, The Ponce St Augustine Hotel, Fairfield Inn and Suites, Westgate Branson Woods Resort, Apple Tree Inn, Hotel Zamora, Holiday Inn Express Hilton Head, Downtown Grand, Riverwalk Resort at Loon Mountain, Crystal Palms Beach Resort, River Terrace Resort & Convention Center, Embassy Suites by Hilton Savannah, 5-Star Grand Sirenis Riviera Maya, Best Western Plus Crossroads Inn and Suites, Krystal Resort Cancun, SAM Pipeline Acquisition 3/31/23, SAM Pipeline Acquisition 3/31/24, SpringHill Suites by Marriott Savannah, Bilmar Beach Resorts, Christine, July Email 1, Springhill Suites, Westgate Vacation Villas, Royal Goan Beach Club Royal Palm, Westgate Las Vegas Hotel & Casino, Westgate Smoky Mountain Resort, Royal Goan Beach & Club Royal Palm, Westgate Lakes Orlando, All Inclusive - Sandos Finisterra Los Cabos, All Inclusive - Mayan Palace Collection, Welk Resorts San Diego, All Inclusive - Villa Del Palmar Cancun, Resort Condovac La Costa, All Inclusive - Omni Cancun Resort, Westgate Town Center, All Inclusive - Dreams Puerto Aventuras, The Fives Beach Hotel & Residences, All Inclusive - Dreams Cabo, All Inclusive - Villa del Palmar Cabo, Beach Cove Resort, All Inclusive - Krystal Resort Cancun, Oasis Palm Beach, All Inclusive - Adult Luxury Punta Cana, The Grandview at Las Vegas, All Inclusive - Dreams Tulum, All Inclusive - Grand Oasis Cancun, All Inclusive - Vallarta Beach Resort, All Inclusive - Grand Sirenis Punta Cana, All Inclusive - Dreams Riviera Maya, All Inclusive - Sandos Playacar Resort, All Inclusive - Marina Fiesta Resort, Newport Beachside - Miami Beach, All Inclusive - Sandos Caracol, All Inclusive - Grand Sirenis, All Inclusive - Cabo Palace Beach Resort, The Downtown Grand, All Inclusive - Secrets Royal Beach Punta Cana, All Inclusive - Sirenis Cocotal Beach, All Inclusive - Secrets Vallarta Bay, All Inclusive - Secrets Aura Cozumel, 12 Night Dream Escapes, All Inclusive - Reflect Krystal Grand Los Cabos, All Inclusive - BlueBay Grand Esmeralda, Club de Soleil Resort, All Inclusive - Cancun Palm Beach Resort, Tahiti Village, All Inclusive - Villa Del Palmar Puerto Vallarta, Bonaventure Resort, Welk Resorts Branson, River Terrace, Welk Resorts Sirena Del Mar Cabo, All Inclusive - Diamond Jewel Cancun Resort, All Inclusive - Sunscape Sabor Cozumel, Westgate Branson, All Inclusive - Grand Oasis Palm, Westgate Oceanfront Resort, All Inclusive - Secrets Puerto Los Cabos, All Inclusive - Breathless Punta Cana, All Inclusive - Dreams Royal Beach Punta Cana, Cambria - New Orleans, Cambria Charleston Riverview, staySky Suites I-Drive Orlando, All Inclusive - Dreams Villamagna, All Inclusive - Dreams Vista Cancun Resort & Spa, Pocono Mountain Villas By Exploria Resorts, All Inclusive - Grand Punta Cana Beach Resort, Ocean Key Resort, Ultimate Hotel Stay & Cruise Package, All Inclusive - Mia Reef Isla Mujeres, All Inclusive - Barcelo Grand Faro Los Cabos, All Inclusive - Now Jade Riviera Cancun, All Inclusive - Secrets Vine, Hawthorn Suites Lake Buena Vista, The Mountain Club On Loon, Club 36, All Inclusive - Krystal Grand Cancun, Hotel Indigo Savannah Historic District, Wild Bear Inn, All Inclusive - Ocean Riviera Paradise, All Inclusive - Mexico Palace Cancun Riviera Maya, All Inclusive - All Inclusive Upgrade Cabo, All Inclusive - Puerto Vallarta Palace Beach Resort, All Inclusive - Hotel Casa Maya Cancun, All Inclusive - Dreams Natura Resort & Spa Family, Hilton Garden Inn - Mt Pleasant, All Inclusive - The Fives Oceanfront Puerto Morelos, DoubleTree by Hilton Hotel Savannah Hist District, Myrtlewood Villas by Bluegreen, Resort At Governors Crossing by Bluegreen, Crown Reef Beach Resort and Waterpark by Bluegreen, All Inclusive - Now Sapphire Riviera Maya Cancun, All Inclusive - All Inclusive Upgrade Cancun, All Inclusive - Sandos Cancun, Best Western Castillo del Sol - Daytona Beach, Springhill Suites by Marriott WI Dells, Casa Dorada At Dreams, All Inclusive - Secrets St. James, Embassy Suites by Hilton Orlando International, All Inclusive - Posadas EP, All Inclusive - Royal Solaris Cabo, All Inclusive - Secrets Wild Orchid, Fairfield Inn & Suites - WI Dells, All Inclusive - Sunset Vistas, Palace Resort by Bluegreen, Westgate Lakes Orlando., All Inclusive - Dreams Las Mareas Luxury, Buenaventura Grand Hotel, Landmark Resort by Bluegreen, Fountains Resort Orlando Bluegreen, All Inclusive - Dreams Sands Cancun, Comfort Inn Williamsburg Gateway, Northstar By Welk Resorts Lake Tahoe, All Inclusive - Ultra Luxury Cancun Riviera Resort, All Inclusive - Breathless Montego Bay, Westgate Las Vegas Hotel and Casino, All Inclusive - Hotel Xcaret, All Inclusive - 5 Star Cabo Beach Resort, All Inclusive - Paradisus Cancun Resort, Westgate Williamsburg, Beach Colony Resort, All Inclusive - The Fives Beach Hotel, Bilmar Beach Resort, All Inclusive - Unlimited Adult Luxury Cabo Resort, All Inclusive - Now Onyx Punta Cana, Drury Inn & Suites Near La Cantera Pkwy, All Inclusive - Secrets Playa Mujeres, All Inclusive - Secrets Papagayo, All Inclusive - Playa Grande Resort, Comfort Suites West of the Ashley by BG, Hilton Garden Inn Savannah Historic District, Holiday Inn Express Busch Gardens, St. James Hotel, All Inclusive - Hacienda Encantada, Seacoast Suites, All Inclusive - Dreams Dominicus La Romana, Renaissance Resort At World Golf Village, All Inclusive - Dreams Acapulco, Eagles Ridge Cabin Resort, Staybridge Suites Myrtle Beach by Bluegreen, All Inclusive - Secrets Maroma Beach, Holiday Inn Express WI Dells, All Inclusive - Dreams Punta Cana, past  guest mb, 2016 Ocean Isle Guest History, Sunny Travel, Disneyworld Vacation Packages, Plantation Resort MB TNBs, new past guest mb, VIP, pompano beach, PLAYCATION, Spec Booking Location, WPSS, New Past Guest St Augustine, Online Direct, Morritts Tortuga Club, All Inclusive - Sunscape Cove, Westgate Collection Orlando, All Inclusive - Zoetry Agua Punta Cana, All Inclusive - Oasis Palm Beach Cancun Sweepstakes, Enclave Suites Orlando, All Inclusive - Sweepstakes All Inclusive Upgrade, Holiday Inn Resort Los Cabos, Holiday Inn Lake Buena Vista, All Inclusive - BlueBay Esmeralda, All Inclusive - Mayan Palace Acapulco, Kahana Beach Resort, All Inclusive - Villas Sol, Jockey Club, All Inclusive - Mayan Palace Nuevo Vallarta, Tuscana Mediterranean Resort, Casablanca on the Ocean, All Inclusive - Sunscape Splash, All Inclusive - Secrets Akumal, The Berkley Las Vegas, All Inclusive - Krystal Grand Los Cabos, Westgate Collection Las Vegas, All Inclusive - Grand Oasis Sens, All Inclusive - Oasis Cancun Lite, All Inclusive - Dreams Las Mareas, Bahama House, Attitash Mountain Village, All Inclusive - Secrets Silversands, All Inclusive - Melia Puerto Vallarta, All Inclusive - Mayan Palace Riviera Maya, Absolute Bangla Suites Phuket, Ellington Resort at Wachesaw Murrells Inlet, Solmar Resort, Ramada Plaza Marco Polo, Hollywood Beach Resort, Westgate Palace, All Inclusive - Villa del Palmar at the Islands of Loreto, All Inclusive - Mayan Palace Puerto Vallarta, All Inclusive - Gran Porto Real Resort, All Inclusive - Dreams Playa Bonita, All Inclusive - Grand Oasis Palm Cancun, D Monaco Cabins, Grand Oaks, Patton at Sandcastle South Beach, Villas At Regal Palms Resort, All Inclusive - Playa Blanca Beach Resort, Festiva Resort Orlando, Peppertree Ocean Club, Cabins at Green Mountain, All Inclusive - Zoetry Montego Bay, All Inclusive - Sunscape Dorado Pacifico Ixtapa, Best Western Aku Tiki Inn, All Inclusive - Oasis Tulum Lite, Summer Bay Orlando, Calypso Cay Vacation Villas, Branson Yacht Club, Grand Orlando Resort, Lake Buena Vista Resort Village & Spa, DoubleTree Resort Myrtle Beach, All Inclusive - Bel Air Collection Cancun, All Inclusive - Bel Air Riviera Maya, Design Suites Miami Beach, Tropicana Las Vegas, Ultimate VIP Flex Pass, Emporio Hotel & Suites Cancun, Grand Seas Resort, Vacation Villas at Fantasyworld Two, Atrium Resort, Myrtle Beach Flex Pass, Ultimate Myrtle Beach Flex Pass, Hampton Inn & Suites North Conway, Beach House Hilton Head, All Inclusive - Mayan Palace Puerto Penasco, All Inclusive - Dreams Palm Beach Punta Cana, All Inclusive - Grand Oasis Tulum, Samba Beach Resort, Gatlinburg Town Square, Staybridge Suites Myrtle Beach, Viva Wyndham Fortuna Beach, Crowne Plaza Orlando - Universal Blvd, Best Western New Smyrna, Stone Castle, Resort At Governors Crossing, Holiday Inn Surfside Beach Myrtle Beach, Westgate Towers, Crown Reef Beach Resort and Waterpark, Royale Parc Suites, Crown Reef Beach Resort & Waterpark, All Inclusive - Secrets Huatulco, The Townes at Kings Creek Plantation, The Cottages at Kings Creek, All Inclusive - Now Amber Puerto Vallarta, Coconut Palms Beach Resort II, All Inclusive - Hyatt Ziva Puerto Vallarta, Crown Club Inn, Sheraton Myrtle Beach Convention Center Hotel, St. Christopher Best Western, Delta Orlando Lake Buena Vista Resort, El Caribe Resort, Radisson Hotel Branson, Landmark Resort, Doubletree Suites Walt Disney World, All Inclusive - Compostela Beach Club, Westgate Collection Branson, Westgate Collection Gatlinburg, All Inclusive - Posada Real Los Cabos, Best Western Ambassador Inn, Beach House Suites - St. Pete, El Paseo - South Beach, All Inclusive - Acapulco Collection, Ocean Creek, Westgate Collection Williamsburg, St. Petersburg Marriott Clearwater, Park Lane Hilton Head, Howard Johnson - St. Pete, Beverly Hills Collection, All Inclusive - Hotel Le Reve, All Inclusive - Zoetry Villa Rolandi Isla Mujeres Cancun, Wintergreen Resort, Palace Resort, All Inclusive - Breathless Cabo San Lucas, Wakulla Suites A Westgate Resort, Beach Cove, Caravelle Resort, La Quinta Inn & Suites Pigeon Forge, Sawgrass Grand, Wyndham Garden - Williamsburg, Grande Villas At World Golf Village, The Estates at Kings Creek, Treasure Bay Resort & Marina, Quality Inn & Suites Myrtle Beach, Beverly Hills Club, Sea Watch Resort, All Inclusive - Mayan Palace Mazatlan, All Inclusive - Dreams Playa Mujeres, All Inclusive - Las Palmas By The Sea, Replay Pool Villa Beachfront, Absolute Q Signature Spa & Resort, Two Villas Holiday Oxygen Bangtao Beach, Best Western Plus - Zion Crossroads, Park Grove Inn, Holiday Inn Express Gatlinburg Downtown, Aloft Charleston, CoCo Key Hotel & Water Resort, Black Fox Lodge, Americinn Lodge & Suites WI Dells, Grande Shores Ocean Resort, All Inclusive - Dreams La Romana, Country Cascades, Captains Quarters, Prince Resort, Royal Park Albatros, Hotel Blue, Brookside Resort, Fountains Resort Orlando, All Inclusive - Zoetry Paraiso De La Bonita, Jaybird`s Inn St Augustine, Oak Plantation Resort, Shular Inn, Polynesian Water Park Resort, Holiday Inn Express Universal, All Inclusive - Breathless Riviera Maya, All Inclusive - Park Royal Cancun, Days Inn - Cocoa Beach, Village by the Sea, All Season Suites, Forest Dunes, Westgate Collection Myrtle Beach, Daytona Beach Collection, All Inclusive - Now Larimar Punta Cana, The Summit, Myrtle Beach, All Inclusive - Secrets Cap Cana Punta Cana, The Westin Las Vegas Hotel, Casa Dorada at Medano Beach, Marina Inn at Grande Dunes, Tuscany Suites & Casino, All Inclusive - Sunscape Dominican Beach, Luxor Las Vegas, All Inclusive - Grand Sirenis Matlali Hills, All Inclusive - Sunscape Bavaro Beach, Costa Adeje Gran Hotel, 4 Star Gatlinburg Hotel, 4 Star Virginia Beach Hotel, 4 Star Myrtle Beach Hotel, 4 Star New Orleans Hotel, 4 Star New Orleans, 4 Star New York City Hotel, 4 Star Miami Hotel, Risata Bali Resort and Spa, Hyatt Place - Charleston/Historic District, Quality Inn Pigeon Forge, All Inclusive - Grand Park Royal Cancun, Penerif Collection, Holiday Inn Express - Pigeon Forge, All Inclusive - Reflect Krystal Grand Cancun, Mountain Run at Boyne, 4 Star Branson Hotel, 4 Star South Padre Hotel, Best Western Cocoa Beach Hotel, Cibola Vista Resort, All Inclusive - ESJ Azul, Christmas Mountain Village, Seadust, All Inclusive - Del Mar by Joy Resorts Punta Cana, Econo Lodge Riverside, Clarion Willow River - Sevierville, All Inclusive - Mexico Palace Riviera Maya, Trade Winds Inn - Maine, Westgate Lakes & Cruise, Comfort Inn & Suites Northeast GateWay, All Inclusive - Risata Bali Resort, Hidden Cove Resort, Miami Beachside Resort, All Inclusive - Ultra Luxury Montego Bay Resort, All Inclusive - Adult Only Riviera Beach Resort, Hooters Casino Hotel, All Inclusive - Secrets Capri, Creekstone Inn, All Inclusive - Ultra Luxury Cabo Resort, All Inclusive - Adult Luxury Montego Bay Resort, Beach Park Hotel, All Inclusive - 5 Star Cancun Villa Resort, All Inclusive - Luxury Adult Punta Cana Resort, All Inclusive - Hotel V10, SLS Las Vegas, Marina Inn at Grande Dunes by Bluegreen, All Inclusive - Mayan Palace Puerto Vallarta VVIP, Samui Emerald Condotel, All Inclusive - Mayan Palace Cancun Riviera Maya, All Inclusive - Mexico Palace Cancun Riviera Maya., All Inclusive - Posadas EP - No Tour, All Inclusive - Grand Mayan Riviera Maya, All Inclusive - Cabo Palace Beach Resort., All Inclusive - Now Amber Puerto Vallarta Especial, All Inclusive - Sunscape Curacao Resort Spa & Casino, Laurel Crest Resort, All Inclusive - Cabo Palace Resort, Hotel St. Pierre, All Inclusive - All Inclusive Upgrade Puerto Vallarta, All Inclusive - Diamante, Fountains Resort Orlando Sponsored by Bluegreen, B1 Beachfront Apartment, St. Petersburg Marriott, Melody Maker, All Inclusive - Krystal Puerto Vallarta, All Inclusive - Sunscape Puerto Plata, All Inclusive - Cancun Bay Resort, Absolute Twin Sands Resort and Spa, All Inclusive - Barcelo Maya Beach Resort, La Quinta Inn & Suites, Meridian Plaza Hotel, Harbour Lights, Maingate Lakeside Resort, Replay Pool Villa Beachfront Samui, River Oaks Resort by Bluegreen, All Inclusive - Mexico Palace Maya, Days Inn & Suites Williamsburg Colonial, Ramada Pigeon Forge South, All Inclusive - All Inclusive - Villa Del Palmar Puerto Vallarta EP - No Tour, Baymont Inn & Suites Gatlinburg, Holiday Inn Surfside Beach Myrtle Beach by BG, DoubleTree by Hilton Williamsburg, The Bearskin Lodge by Bluegreen, B Resort & Spa, DoubleTree by Hilton Hotel Savannah Historic District, The Appy Lodge by Bluegreen, Days Inn Petoskey, Hyatt Regency Savannah, The Old Creek Lodge by Bluegreen, All Inclusive - Krystal Resort Cancun Especial, River Inn Hotel - WI Dells, Fairfield Inn Celebration, Barefoot Resort, Mountain Grand Lodge and Spa, All Inclusive - Ultra Luxury Punta Cana Resort, Springhill Suites Lake Buena Vista, Hampton Inn Patriots Point, Homewood Suites by Hilton Savannah, Best Western Plus Historic Area Inn, Quality Suites The Royale Parc, Westgate Town Center & Water Park, All Inclusive - Almar Vacation Club, Westgate Town Center Especial, All Inclusive - Mexico Palace Cancun, La Quinta Inn & Suites Williamsburg, Residence Inn by Marriott Savannah, Carolina Winds, Courtyard Barefoot Landing, Park Inn by Radisson Williamsburg Historic, Hampton Inn Broadway at the Beach, All Inclusive - Mayan Palace Cancun Riviera & BookVIP Plus, The Ponce St. Augustine Hotel, All Inclusive - Mayan Palace Cancun Riviera Maya Especial, Towneplace Suites Lake Buena Vista, All Inclusive - Now Emerald Cancun, All Inclusive - Mayan Palace Nuevo Vallarta VVIP, Daytona Bahama House, 4 Star Nashville Hotel, Red Lion Hotel - Orlando Maingate, All Inclusive - Mayan Palace Mazatlan VVIP, All Inclusive - Las Palmas All Inclusive & BookVIP Plus, All Inclusive - Grand Sirenis Especial, FantaSea Resorts, Hampton Inn West Ashley, All Inclusive - Dreams Playa Bonita Panama Especial, All Inclusive - Las Palmas, All Inclusive - Mexico Palace Cancun - Riviera Maya, All Inclusive - Ultra Luxury Curacao Resort, All Inclusive - Luxury Mayan Riviera Beach Resort, Holiday Inn Savannah Historic District, All Inclusive - Mayan Palace Collection RA Non All Inclusive, All Inclusive - Mayan Palace Collection RA All Inclusive, US Collection Reactivation, The Lodge at Five Oaks by Bluegreen, All Inclusive - Mexico Palace Dolphin Experience, Drury Inn San Antonio Northwest Medical Center, Welk Resorts Breckenridge, All Inclusive - Krystal Cancun Dolphin Experience, All Inclusive - Barcelo Mismaloya Puerto Vallarta, All Inclusive - Mayan Palace Collection & BookVIP Plus Membership, All Inclusive - Dreams Huatulco, All Inclusive - Adult Luxury Cancun Riviera Maya Resort, All Inclusive - Grand Cancun Beach Resort, All Inclusive - Utra Luxury Tulum Resort, Gold Crown Cancun Resort, SAHARA Las Vegas, The Reef Coco Beach, Hampton Inn & Suites Savannah Historic District, All Inclusive - Mayan Palace Puerto Penasco VVIP, Hilton Garden Inn Universal, Staybridge Suites Orlando Royale Parc Suites, All Inclusive - Sunscape Puerto Vallarta, Residence Inn Convention Center, All Inclusive - Inspiration Riviera Maya Adult Only, All Inclusive - Ultra Adult Luxury Puerto Vallarta, Grand Beach Los Cabos Resort, Hampton Inn Universal, All Inclusive - Luxury Puerto Vallarta Resort, All Inclusive - Mayan Palace Acapulco VVIP, All Inclusive - Hotel 52 Playa del Carmen, Point Orlando Resort, Welk Resorts Palm Springs, All Inclusive - Chic Punta Cana, S.R. Hotel Hilton Head, Comfort Inn & Suites Orlando, All Inclusive - Grand Beach Playa del Carmen, All Inclusive - Adult Luxury Papagayo, All Inclusive - Ultra Luxury Adult Only Cabo Resort, All Inclusive - Ultra Luxury Puerto Aventuras Resort, All Inclusive - Reflect Krystal Grand Nuevo Vallarta, All Inclusive - Playa Mujeres Adult Luxury, All Inclusive - Ultra Adult Only Cancun Resort, All Inclusive - 5 Star Costa Rica Beach Luxury Resort, All Inclusive - Unlimited Adult Huatulco Resort & Spa, All Inclusive - Sunscape Akumal, All Inclusive - Hotel Xcaret Especial, All Inclusive - Casa Del Mar Los Cabos, Grand Sens Resort, Westgate Las Vegas Hotel & Casino Especial, Stratosphere, Aspens On Blackcomb, The Lodge at Five Oaks, Holiday Inn Express & Suites Petoskey, 4 Star Charlotte Hotel, Cambria Hotel St Petersburg-Madeira Beach Marina, Holiday Inn Riverwalk, All Inclusive - Ultra Luxury All Inclusive Upgrade, BOOKVIP Open Package, Odyssey Dells, The Grand Hotel, Occidental Nuevo Vallarta, Ancora Cap Cana, Los Cabos Golf Resort, Dreams Vista Cancun Resort & Spa, PC_carousel_LeadGen7/7, Home2 Suites, Gift from relative, Cabo Palace Beach Resort, Puerto Vallarta Palace Beach Resort, Villa Del Palmar Puerto Vallarta, Occidental Grand Nuevo Vallarta, YT, SAM Pipeline Acquisition 3/31/25, SAM Pipeline Acquisition 3/31/26, SAM Pipeline Acquisition 3/31/27, SAM Pipeline Acquisition 3/31/28, SAM Pipeline Acquisition 3/31/29, SAM Pipeline Acquisition 3/31/30, SAM Pipeline Acquisition 3/31/31, SAM Pipeline Acquisition 3/31/32, Oasis Palm & Grand Oasis Palm, Omni Cancun Hotel & Villas, Latrisha, Grand Oasis Cancun, Omni Cancun Resort, Calypso Cay Resort, Dreams Jade Resort & Spa, Newport Beachside Hotel & Resort, Wyndham Grand Cancun, Country Inn & Suites, Sirenis Cocotal Beach, Country Inn and Suites by Radisson Pigeon Forge South, Grand Sirenis, Wingate by Wyndham New York Midtown, Krystal Grand Los Cabos, Buenaventura Grand Puerto Vallarta, Black Friday USA Multi Stay, Black Friday 4 Night USA Flexi Stay, Oasis Tropical, Omni Southpark, The Anaheim Hotel, Eagle Aruba Resort, Grand Sirenis Riviera Maya Resort, Landmark, Grand Sirenis Punta Cana Resort, Hyatt Place Sandestin at Grand Blvd, Cyber Monday 4 Night USA Flexi Stay, Cyber Monday USA Multi Stay, Eagle Aruba Resort and Casino, Barcelo Grand Faro Los Cabos, Courtyard Virginia Beach Oceanfront/North, Fort Lauderdale Beach Resort, PC_Carousel_US_5/4_Offer_10/19, The Christie Lodge |
| voComplete | checkbox (boolean) | 96 | NA |
| cancelReservation | checkbox (boolean) | 105 | NA |
| chargebackDate | date (yyyy-MM-dd) | 236 | NA |
| checkForPartial | checkbox (boolean) | 98 | NA |
| partialAmountPaidToday | currency (number) | 99 | NA |
| creditCardType | text (string) | 56 | Visa, Mastercard, Discover, American Express, amex, External |
| ccApprovalCode | text (string) | 58 | NA |
| numberOfActiveDateLegs | numeric (number) | 571 | NA |
| numberOfAdults | text (string) | 28 | NA |
| numberOfChildren | text (string) | 29 | NA |
| numberOfNights | numeric (number) | 27 | NA |
| age25+ | text (string) | 424 | Yes, No |
| anyAdditionalNotes | text-multi-line (string) | 60 | NA |
| bonusTravelGifting | text (string) | 410 | Choose Your Cruise 4 Day Bahamas/Mexico, Choose Your Cruise 5 Day Cruise&Stay, Choose Your Cruise 6 Day Caribbean/Mexico/Bermuda, Bonus 3 Day/2 Night Getaway, Choose Your Cruise 4 Day Bahamas/Mexico (2), Choose Your Cruise 5 Day Cruise&Stay (2), Choose Your Cruise 6 Day Caribbean/Mexico/Bermuda (2), Bonus 3 Day/2 Night Getaway (2), 8 Day & 7 Night Condo Stay |
| callbackDate | unknown | 249 | NA |
| callbackReason | text (string) | 250 | NA |
| chargebackAmount | currency (number) | 237 | NA |
| creditCardDeclined | checkbox (boolean) | 335 | NA |
| city | text (string) | 161 | NA |
| country | text (string) | 164 | NA |
| creditCard | text (string) | 392 | Has Major CC, Debit Card Only, Unknown |
| postalCode | text (string) | 163 | NA |
| stateSlashRegion | text (string) | 162 | Alabama, Alaska, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, District of Columbia, Florida, Georgia, Hawaii, Idaho, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Carolina, North Dakota, Ohio, Oklahoma, Oregon, Pennsylvania, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin, Wyoming, Alberta, CAN, British Columbia, CAN, Quebec, CAN, Ontario, CAN, Saskatchewan, CAN, Manitoba, CAN, New Brunswick, CAN, Nova Scotia, CAN, Newfoundland Labrador, CAN, Prince Edward Island, CAN, Puerto Rico, Bermuda, Bahamas, US Virgin Islands, Ecuador, Virgin Islands, Guam, Barbados, Netherlands, American Samoa, Cayman Islands, St. Kitts & Nevis, Dominican Republic, Dutch Caribbean, Edmond, Jamaica, St. Croix, Mexico, Northern Mariana Isl., St John, Trinidad, Other (Foreign) |
| street1 | text (string) | 159 | NA |
| street2 | text (string) | 160 | NA |
| dateCancelled | date (yyyy-MM-dd) | 106 | NA |
| dateModified | unknown | 2 | NA |
| developer | text (string) | 30 | MST - Monster, SLR - Silverlake Resort, OPS - Online Package Sales, SMD - Smoky Mountain Distributors |
| disposition | text (string) | 538 | CONF - Confirmed, CONF - LVM, CONF - Date Rescheduled, CONF - Date Cancelled, CONF - Callback, CONF - VPA Added/Confirmed, CONF - VPS Added/Confirmed, CONF - VPS Added/Rescheduled, CONF - VPS Added/Cancelled, CONF - VPS Not Added/Confirmed, CONF - Other, GS - Reschedule, GS - Inbound Date Set, GS - Date Inquiry/No ACT, GS - Date Inquiry/Non Qualified, GS - Destination Dates Not Available, GS - Destination Not Available Yet, GS - Date Cancellation, GS - Full Refund/Cancel Open Package, GS - Partial Refund, GS - Resent Letter, GS - Guest Complaint - Now Happy :), GS - Non Qualified for all Destinations, OM - Tour Status Edit, OM - Data Entry, OM - PCG - LVM, GS - OUTBOUND-LVM task list, GS - OUTBOUND-ODR Left Voicemail, GS - OUTBOUND-Date set, GS - OUTBOUND-website submission, GS - OUTBOUND-Question for guest, GS - Gift Request, GS - Guest Complaint-will follow up, GS - Transferred to confirmations, GS - Guest Complaint-Escalated to Mgnt, GS - Edited Guest profile, GS - Built In CRM from scratch, GS - Questions regarding check in, GS - Upgrade Room/Extra Night, GS - Called about confirmation, GS - Pitched Dates/Not Interested, GS - MSP (Monster Savings Platform) Questions, GS - Send a Coffee!, GS - Requested Certificate, GSM - Admin, CHAT - General Questions |
| dnc | checkbox (boolean) | 457 | NA |
| efpDateWelcomeLetter | unknown | 110 | NA |
| efpDateOpsSlashOvrSlashNro | unknown | 599 | NA |
| efpDatePcg | unknown | 338 | NA |
| efpDateRefund | unknown | 223 | NA |
| efpDateSurvey | unknown | 283 | NA |
| efpDateAutoDispo | unknown | 637 | NA |
| genieNumber | text (string) | 46 | NA |
| gifting | text (string) | 39 | $50 Visa Card, $75 Visa Card, $100 Visa Card, $150 Visa Card, 8 Day & 7 Night Condo Stay, 7 Night Disc Cruise *Port Fees/Tax Apply, 3/2 Bonus Getaway, Includes $100 Restaurant Dining Certificate, $100 Dining Dough, $150 Amex, $50 Dining Dough, $100 Resort Credit, $150 Dining Dough, Disc Cruise Cert *Port Fees & Tax Apply, $50 Resort Credit, $200 Dining Dough, $200 Amex, $50 Amex, Relax with 7 Heater Outdoor Pools & HotTubs, $50 Visa, $125 Resort Credit, $75 Dining Dough, $75 Resort Credit, $125 Dining Dough |
| giftingNotes | text-multi-line (string) | 145 | NA |
| gt | checkbox (boolean) | 232 | NA |
| guestDateOfBirth | date (yyyy-MM-dd) | 41 | NA |
| income | currency (number) | 40 | NA |
| last4OfCreditCardOnly | text (string) | 53 | NA |
| lastModifiedBy | user (string) | 5 | NA |
| listOfDevelopersActivated | text (string) | 504 | NA |
| monthsOpen | text (string) | 26 | 12, 15, 18, 24, 36, 48, No Expiration, Dated Package |
| nq | checkbox (boolean) | 233 | NA |
| ns | checkbox (boolean) | 234 | NA |
| nt | checkbox (boolean) | 453 | NA |
| occupation | text (string) | 183 | NA |
| packagePriceWithoutProFee | currency (number) | 35 | NA |
| partialBalanceDueDate | date (yyyy-MM-dd) | 38 | NA |
| partialPaidInFull | checkbox (boolean) | 95 | NA |
| processingFee | currency (number) | 36 | NA |
| rciPurchased | text (string) | 475 | Yes, No |
| rciType | text (string) | 476 | 1 Week Pin, 5 Week Pin, 10 Week Pin |
| reasonForCancel | text (string) | 107 | NA |
| rebrandlyWelcomeLetterLink | unknown | 533 | NA |
| refundAmount | currency (number) | 122 | NA |
| refundDate | date (yyyy-MM-dd) | 123 | NA |
| refundTextDateSlashTime | unknown | 579 | NA |
| refundTextTrigger | checkbox (boolean) | 577 | NA |
| relatedEmployee | numeric (number) | 186 | NA |
| relatedEmployee2 | numeric (number) | 205 | NA |
| relatedEmployee3 | numeric (number) | 196 | NA |
| relatedOfficeId | numeric (number) | 520 | NA |
| relatedRciPin | numeric (number) | 486 | NA |
| requestedArrivalDate | date (yyyy-MM-dd) | 473 | NA |
| reservationOwner | user (string) | 4 | NA |
| savonPurchased | text (string) | 474 | Yes, No |
| sendToCourierTriggerWelcomeLetter | checkbox (boolean) | 112 | NA |
| sendToCourierTriggerOpsSlashOvrSlashNro | checkbox (boolean) | 600 | NA |
| sendToCourierTriggerPcg | checkbox (boolean) | 339 | NA |
| sendToCourierTriggerRefund | checkbox (boolean) | 227 | NA |
| sendToCourierTriggerSurvey | checkbox (boolean) | 289 | NA |
| sendToCourierTriggerAutoDispo | checkbox (boolean) | 643 | NA |
| sendToCourierTriggerTextMessage | checkbox (boolean) | 574 | NA |
| sendToCourierTriggerTstpWelcomeLetter | checkbox (boolean) | 438 | NA |
| spouseDateOfBirth | date (yyyy-MM-dd) | 272 | NA |
| spouseOccupation | text (string) | 184 | NA |
| totalNumberOfTrips | numeric (number) | 425 | NA |
| totalPaid | currency (number) | 535 | NA |
| totalRefunded | currency (number) | 536 | NA |
| totalVoided | currency (number) | 537 | NA |
| triggerFieldWelcomeLetter | text (string) | 117 | NA |
| triggerFieldOpsSlashOvrSlashNro | text (string) | 603 | NA |
| triggerFieldPcg | text (string) | 342 | NA |
| triggerFieldRefund | text (string) | 228 | NA |
| triggerFieldSurvey | text (string) | 290 | NA |
| triggerFieldAutoDispo | text (string) | 644 | NA |
| triggerFieldTstpWelcomeLetter | text (string) | 441 | NA |
| tstpEfpDate | unknown | 437 | NA |
| activeDateLegs | text (string) | 594 | NA |
| refundGsAgent | user (string) | 623 | NA |
| rSlashSAppRevenue | currency (number) | 624 | NA |
| developerNqs | text (string) | 625 | NA |
| callbackAgent | unknown | 646 | NA |
| totalOfPartialInstallmentsPaid | currency (number) | 654 | NA |
| numberOfAutoDispoEmailsToday | numeric (number) | 662 | NA |
| numberOfSurveysSent | numeric (number) | 663 | NA |
| sentHc | date (yyyy-MM-dd) | 664 | NA |
| numberOfEmails | numeric (number) | 667 | NA |
| taskListDest | text (string) | 671 | NA |
| opsSubOffice | text (string) | 675 | Phone Room - Day, Phone Room - Night, Chat Team, Service Team, Online Sale |
| dateLegConfirmationNeeded | numeric (number) | 676 | NA |
| numberOfTripsCompleted | numeric (number) | 680 | NA |
| upgradeAmountsCharged | currency (number) | 681 | NA |
| tcpaOptIn | text (string) | 685 | Yes, No, Didn't Ask |
| dlTcpaOptInYes | numeric (number) | 686 | NA |
| dlTcpaOptInNo | numeric (number) | 687 | NA |
| ipAddressClean | text (string) | 690 | NA |
| homeowner | text (string) | 691 | Homeowner, Renter, Unknown |
| numberOfTripsCompletedAllInclusive | numeric (number) | 693 | NA |
| wgsGuest | numeric (number) | 695 | NA |
| mspSubscription | checkbox (boolean) | 701 | NA |
| builtWithPartnerPortal | checkbox (boolean) | 703 | NA |
| tso | checkbox (boolean) | 705 | NA |
| ownsTimeshareWith | text (string) | 706 | NA |
| children'sAges | text (string) | 707 | 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 2eeb1fae-f2dc-4f6c-a1b7-5b41d135e1ce, 0abe0022-5c12-4b45-bec8-b5e351c3bdeb, e206d85b-5b19-4895-b780-baac1b84c33a, 51490049-b74f-4ea7-8a7c-e01d08dcb608, 4e9d1006-2c6c-4a34-a86a-0a1401be479d, 415ca43d-e762-44c3-8b30-d92879ed7bf6, 09f646b2-4a2e-4b5f-aa52-5c1963ce2f80, fb6c285a-54fb-45d2-9bd0-976455f21b8c, 1795ebef-0d13-4418-8b06-927f9e2584ce, 679c4c8f-5c2c-4471-aadd-ac329502c637, 8b4904d0-2916-493a-bb08-deceb70b5c87, 9e13dc20-9efd-43bc-b053-20fe8a02858d, fa354603-8564-4181-af3b-137d49cff1ba, c2bdb70d-9259-4cbf-9b20-49b55fcab918, 8f15abcc-4475-4771-893f-9d65d70b3a25, 43d05500-7cc1-4780-92e8-95bbf69ad35e, 9c8d342e-74c4-49a8-ab0f-5464125d844e, 0442abc8-8288-4108-8506-6c5bc7d266ab, 2f7d4c68-6740-4da7-bc9d-0acb541d54fd, 862864e1-90f7-4569-95cc-cd553696bfbc, 8cd98364-3612-46cc-a5c0-b463866ce1d2, e06edc08-ae47-4333-a20a-cb843a45fbca, 9331ca34-dc80-4901-a684-043635d01a69, 21, 2a3641d7-ae48-4ed2-94e0-e37cd83739b6, 7993837e-668b-48e3-ab16-7e3b8c43a66e, 91adb3cd-f666-4f47-8b26-e8ce91c7133a, 22, 42e4de3e-2e8a-447e-98ac-f3913a3934b7, 18, bdecf01d-37d8-4af7-999d-ed3b5d577897, 59c3c505-f72c-4c15-8ec0-272f3519bc6e, 19, 86dfc1c2-86b5-4721-b463-f8659c37afad, 0bb73a08-c371-452c-8aaf-51990c5c97ea, 489c639d-704f-463e-99f1-49e2d34c9553, 18ab2364-4386-40ca-a27a-dd551ffa442a, 66980370-59fb-457e-80cc-f0379d3454ac, 4118a404-de6e-4c64-9471-4a4e87dabd1c, 136, 9cc39118-90be-4ff0-8c54-08f0d67e2bd4, 8fbbeb67-be29-41e1-bfd4-4e23d1a0a51a, 114e7e9a-4483-44c8-ba63-01fe1f3c7c66, d94a43c1-b3c0-4201-959a-3c4bbebebb4b, -114, -1, 0.11, 824c636e-2fbd-4a35-82a2-fd547de7e24f, aef85001-bf80-4dec-98b2-a10bf3c5d724, 5dfdbda4-7db2-4c89-aa08-4bba60609e5a, a525858c-d928-46fc-afe5-b564217c38b9, d6069a4a-e218-4f39-b916-387f395ff13a, e0270988-55f1-4dce-9774-d74f1b52a040, 10397a28-047c-4f8d-a642-ae4ed14921d0, 6a29175a-ce4f-4ff0-8420-cf72000b99f2, b8dc0518-69ac-4cc2-ac69-a0c5c58de5d9, 6262d5ca-4ef3-449d-bdfc-b2b34f81dd43, 661cc16a-909b-4897-82ad-58dd7823ae07, 1b92948f-0dad-4e01-af0c-8bcecb308dd7, -15, -8, 1.5, 5245b93a-dee7-4d9e-917a-563fb407332a, 20, 09f9884a-99d0-4994-92ce-7c7e77def6ff, 23 |
| guestDlState | text (string) | 708 | Alabama, Alaska, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, Florida, Georgia, Hawaii, Idaho, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Carolina, North Dakota, Ohio, Oklahoma, Oregon, Pennsylvania, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin, Wyoming, Canada, District of Columbia |
| guestDlNumber | text (string) | 709 | NA |
| spouseDlState | text (string) | 710 | Alabama, Alaska, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, Florida, Georgia, Hawaii, Idaho, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Carolina, North Dakota, Ohio, Oklahoma, Oregon, Pennsylvania, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin, Wyoming, Canada |
| spouseDlNumber | text (string) | 711 | NA |
| totalRciActivationFeePaid | currency (number) | 712 | NA |
| pappLink | text (string) | 715 | NA |
| voPdfLink | url (string) | 719 | NA |
| addSubscriptionAfterPos | url (string) | 720 | NA |
| numberOfActiveRciWeeks | numeric (number) | 721 | NA |
| password | text (string) | 722 | NA |
| textVoDocument | url (string) | 725 | NA |
| usedTextVoOverride | checkbox (boolean) | 726 | NA |
| bgFicoCheck | text (string) | 727 | NA |
| ancoraFicoCheck | text (string) | 728 | NA |
| dateFlexAmount | currency (number) | 730 | NA |
| testreservation | checkbox (boolean) | 733 | NA |
| tppSubscriptionsActive | numeric (number) | 735 | NA |
| dateLegOffice | text (string) | 739 | NA |
| relatedActivator | numeric (number) | 740 | NA |
| rafasdkTimestamp | date (yyyy-MM-dd) | 743 | NA |
| sourceurl | url (string) | 746 | NA |
| numberOfPaymentsPkgSales | numeric (number) | 748 | NA |
| ancoraFicoOrder | text (string) | 749 | NA |
| datrixstatus | text (string) | 751 | NA |
| resendToTracker | checkbox (boolean) | 752 | NA |
| notes | text-multi-line (string) | 753 | NA |
| numberOfNotes | numeric (number) | 756 | NA |
| notesHistory | text (string) | 757 | NA |
| tppAmount | currency (number) | 761 | NA |
| totalPaymentAmount | currency (number) | 762 | NA |
| depositCreditOnFile | currency (number) | 768 | NA |
| depositsOnDateLegs | currency (number) | 778 | NA |
| wgsCreditOnFile | currency (number) | 770 | NA |
| spouseFico | checkbox (boolean) | 769 | NA |
| totalNqFeeCharged | numeric (number) | 771 | NA |
| totalBadTourChargeDue | currency (number) | 772 | NA |
| netGsRevenueDepositOnly7Days | currency (number) | 776 | NA |
| netGsRevenueDepositOnlyLifetime | currency (number) | 779 | NA |
| totalTaxesCollected | currency (number) | 777 | NA |
| isCache | checkbox (boolean) | 780 | NA |
## date-legs
| Field | Type | id | choices* |
| ---- | ---- | ---- | --- |
| recordIdNumber | recordid, (no write) | 3 | NA |
| reservationStatus | text (string) | 27 | Active, Cancelled |
| arrivalDate | date (yyyy-MM-dd) | 8 | NA |
| confirmationNumber | text (string) | 12 | NA |
| tourDate | date (yyyy-MM-dd) | 15 | NA |
| tourTime | text (string) | 16 | 7:30 AM, 8:00 AM, 8:15 AM, 8:20 AM, 8:25 AM, 8:30 AM, 8:45 AM, 8:50 AM, 9:00 AM, 9:15 AM, 9:30 AM, 9:45 AM, 10:00 AM, 10:15 AM, 10:30 AM, 10:45 AM, 10:50 AM, 11:00 AM, 11:15 AM, 11:20 AM, 11:30 AM, 11:45 AM, 11:55 AM, 12:00 PM, 12:15 PM, 12:30 PM, 12:45 PM, 1:00 PM, 1:20 PM, 1:25 PM, 1:30 PM, 1:45 PM, 1:55 PM, 2:00 PM, 2:15 PM, 2:25 PM, 2:30 PM, 2:45 PM, 2:55 PM, 3:00 PM, 3:30 PM, 4:00 PM, 6:00 PM, 6:30 PM, 7:00 PM, 9:00 PM, 9:30 PM, *Assigned at Check-in, *No Tour Required, Assigned At Check-in, *Assigned at Checkin, 01:30 PM, 8:55 AM, 09:00 am, 1:30 AM, 0, 12:30 AM, 11:25 AM, 09:30 am, 12:00 AM, 08:45 am, *ASSIGNED AT CHECK IN, 11:30am, ASSIGNED AT CHECK IN, ?1?:?30? ?PM, 08:30 am, 02:00 pm, 12:45 AM, 2:15 AM, ?12?:?00? ?PM, ?9?:?30? ?AM, 03:00 pm, 02:30 pm, ?9?:?00? ?AM, 2:14 PM, ?10?:?00? ?AM, ?1?:?00? ?PM, ?11?:?00? ?AM, ?10?:?30? ?AM, 12 PM, 01:00 PM, 08:00 am, 02:45 PM, 00:00 AM, 09:30, 07:30 am, 10:55 AM, 11:30 PM, 8:56 AM, 2:50 PM, 1:00 AM, 8:15 |
| activatingOffice | text (string) | 140 | GS MB, GS FTL, GS NST, Act MB, Act 707, Act NST, Act MYR, Act FTL, DS NST, DS MB, NRO, Chat, Online App, Online App Rebook, Auto Scheduler, OPS, 707, SSA, GUN, 2ND, ODR, Conf |
| totaldepositattached | currency (number) | 458 | NA |
| totalwgsattached | currency (number) | 460 | NA |
| numberOfAdults13+ | numeric (number) | 172 | NA |
| numberOfChildren012 | numeric (number) | 173 | NA |
| numberOfReferrals | numeric (number) | 182 | NA |
| relatedNumber | numeric (number) | 463 | NA |
| secondUndefined | text (string) | 393 | NA |
| thirdUndefined | text (string) | 369 | NA |
| fourthUndefined | text (string) | 370 | NA |
| accountNumber | text (string) | 169 | NA |
| activePhoneForTexts | text (string) | 170 | Primary Phone, Alternate Phone |
| addedTourDate | checkbox (boolean) | 376 | NA |
| arrivalConfirmed | checkbox (boolean) | 18 | NA |
| arrivalDatesHistory | text (string) | 381 | NA |
| autodispo | file | 251 | NA |
| badTourChargeDue | currency (number) | 355 | NA |
| badTourChargeStatus | text (string) | 356 | NA |
| badTourReason | text (string) | 322 | NA |
| bgRoomTypes | text (string) | 93 | Standard Oceanview - Sleeps 4, Efficiency Oceanview - Sleeps 4, Suite Oceanview - Sleeps 6, 1 Bedroom Oceanview - Sleeps 4, 2 Bedroom - Sleeps 6 |
| bluegreenConfirmationLetter | file | 78 | NA |
| builtByDatrix | checkbox (boolean) | 399 | NA |
| cancelAndRSlashSDate | date (yyyy-MM-dd) | 366 | NA |
| cancelAndRSlashSTeamMember | user (string) | 365 | NA |
| cappConfirmed | checkbox (boolean) | 302 | NA |
| cappShortLink | text (string) | 303 | NA |
| cappSignatureLink | url (string) | 433 | NA |
| cappSourceConfirmed | text (string) | 353 | NA |
| childrensAgesListAll | text (string) | 174 | less than 1 yr old, 1 yr old, 2 yr old, 3 yr old, 4 yr old, 5 yr old, 6 yr old, 7 yr old, 8 yr old, 9 yr old, 10 yr old, 11 yr old, 12 yr old, 13 yr old, 14 yr old, 15 yr old, 16 yr old, 17 yr old, 14, 16, 11, 7yr old, 2 yo, 10 yrs., 9 mo, 14 months, 12, 7, 1917, 3, 17, 15 yrs., 3 Months, 4, 13, 6, 18 yrs old, 1717, 19, 2, 912, 510, 416, 1412, 8 months, 10, 8, 1715, 146, 12 months, 5, 0, 11 Month Old, 15, 1, 1716, 58, 2 months, 28, 9 years, 14 years old, 175, 5mons, 1.5 y/o, 14 year old, 12 year old, 4 months, 5 mths old, 1815, 9, 3b841eba-b2db-4da2-a853-0a513fbb6a5b, 21, 915, a15f5d25-8355-464e-ac0f-25ecfa3e591e, 12d49ed0-c2cd-427c-881a-dc21bd1cc11a, fd8bb731-a054-4c02-bc72-248003932718, 9965b875-7a39-451d-baa8-9e89ed6bc376, 11d0cd0a-522c-48ea-8e6f-872fdf9ffc87, 22, 79, 3f05c961-9c27-4b26-999a-5a44148d0c01, 18, bcd20ef9-b31e-4eba-a386-2daba2d89438, 806c4fe3-b891-465e-a967-5263e3322627, 10 month, 7 years old, 9 years old, 8e5edba1-9868-4ac3-af2d-10c156c2ef98, 8e6b349b-756f-492a-a6e5-4d0c45fc111c, ac004900-bd8e-4c3c-bd5a-fa0b5620fd02, b1229b80-d22e-4c8d-9926-e429726f0097, 9d9993d4-9245-4cfd-9592-b83e06c2b1ae, ae69f386-e169-4249-ac9f-2b119f02bb91, 136, e3afd1cb-9425-4a4d-92fe-a3bcfec4c4f1, f771d0c4-4c04-4232-95c6-397ade16d4a5, cc37a51f-51de-4326-a532-3883a706dff0, 710d1dd9-db6d-418e-a683-6473c51995de, -114, -1 |
| confirmationNumberHistory | text (string) | 388 | NA |
| confirmationTeamMember | user (string) | 315 | NA |
| confirmationTextDateSlashTime | unknown | 125 | NA |
| confirmationTextStatus | text (string) | 128 | NA |
| confirmationTextTrigger | checkbox (boolean) | 123 | NA |
| confletterTextTrigger | checkbox (boolean) | 266 | NA |
| confletterrebrandlyTextDateSlashTime | unknown | 267 | NA |
| confletterrebrandlyTextStatus | text (string) | 268 | NA |
| dateConfirmed | unknown | 19 | NA |
| dateCreated | unknown | 1 | NA |
| dateModified | unknown | 2 | NA |
| dateReActivedByApp | date (yyyy-MM-dd) | 229 | NA |
| dateRequest | text (string) | 26 | NA |
| dateTourStatusEntered | date (yyyy-MM-dd) | 352 | NA |
| datesUnavailable | checkbox (boolean) | 239 | NA |
| datrixUserOverrodeDeposit | checkbox (boolean) | 395 | NA |
| developerNotesFromDip | text (string) | 273 | NA |
| disposition | text (string) | 208 | CONF - Confirmed, CONF - LVM, CONF - LVM (Text Sent), CONF - Date Rescheduled, CONF - Date Cancelled, CONF - Callback, CONF - Unable to Reach Cxl, CONF - VPA Added/Confirmed, CONF - VPS Added/Confirmed, CONF - VPS Added/Rescheduled, CONF - VPS Added/Cancelled, CONF - VPS Not Added/Confirmed, CONF - Other, GS/ACT - Date Cancelled |
| efpDateAutoDispo | unknown | 244 | NA |
| efpDateBluegreenConf | unknown | 79 | NA |
| efpDateGenericConf | unknown | 67 | NA |
| efpDateInternalConf | unknown | 52 | NA |
| facebookLikeTextDateSlashTime | unknown | 280 | NA |
| facebookLikeTextStatus | text (string) | 281 | NA |
| ficoChecked | checkbox (boolean) | 283 | NA |
| flightInfo | text-multi-line (string) | 397 | NA |
| futm | user (string) | 348 | NA |
| genericConfirmationLetter | file | 66 | NA |
| gifting | text (string) | 13 | $150 Visa Card, $100 Visa Card, $150 Amex Card, $75 Visa Card, $50 Visa Card, $100 Dining Dough, N/A |
| gt | checkbox (boolean) | 20 | NA |
| hash | text (string) | 338 | NA |
| hash2 | text (string) | 346 | NA |
| hotelRetailValue | text (string) | 446 | NA |
| internalConfirmationLetter | file | 51 | NA |
| lastModifiedBy | user (string) | 5 | NA |
| mailHardCopyConfirmation | checkbox (boolean) | 196 | NA |
| manualCappSendDateSlashTime | unknown | 359 | NA |
| manualCappSendStatus | text (string) | 360 | NA |
| manualCappSendTextTrigger | checkbox (boolean) | 362 | NA |
| notes | text-multi-line (string) | 113 | NA |
| nq | checkbox (boolean) | 23 | NA |
| nqByDeveloper | checkbox (boolean) | 238 | NA |
| ns | checkbox (boolean) | 22 | NA |
| nt | checkbox (boolean) | 21 | NA |
| opcGifting | text (string) | 289 | $100 Visa Gift Card, $25 Visa Gift Card, $50 Loft Restaurant Voucher, $100 Loft Restaurant Voucher, $50 Visa Gift Card, $75 Visa Gift Card, 8 Day/7 Night Condo Cert |
| reasonForCancel | text (string) | 152 | Guest cancelled - Accommodations did not meet expectations, Guest cancelled - Guest felt misled, Guest cancelled - Work Conflict, Guest cancelled - Family Emergency, Guest cancelled - Coronavirus, Guest cancelled - Feeling Unwell, Guest cancelled - Guest request, GS - Rebooking, GS - Data Entry Error, GS - Dates Unavailable/NQ, GS/Conf - Guest rescheduled dates, Conf cancelled - Cancelled during Confirmation Process, Conf cancelled - NQ |
| rebrandlyConfirmationLetterLink | text (string) | 263 | NA |
| recordOwner | user (string) | 4 | NA |
| referralShortLink | text (string) | 304 | NA |
| relatedDestinationId | numeric (number) | 292 | NA |
| relatedEmployee | numeric (number) | 138 | NA |
| relatedEmployee2 | numeric (number) | 143 | NA |
| relatedLogo | numeric (number) | 76 | NA |
| relatedReservation | numeric (number) | 31 | NA |
| relatedResort | numeric (number) | 159 | NA |
| relatedRoomType | numeric (number) | 130 | NA |
| rescheduleAppSource | text (string) | 237 | NA |
| rescheduleTextDateSlashTime | unknown | 201 | NA |
| rescheduleTextStatus | text (string) | 216 | NA |
| rescheduleTextTrigger | checkbox (boolean) | 199 | NA |
| sendReferralLink | checkbox (boolean) | 305 | NA |
| sendToCourierTriggerAutoDispo | checkbox (boolean) | 250 | NA |
| sendToCourierTriggerBluegreenConf | checkbox (boolean) | 85 | NA |
| sendToCourierTriggerGenericConf | checkbox (boolean) | 73 | NA |
| sendToCourierTriggerInternalConf | checkbox (boolean) | 61 | NA |
| shortDateRequestLetterLink | text (string) | 402 | NA |
| shortRescheduleLink | text (string) | 211 | NA |
| silverlakeGifting | text (string) | 116 | VISA25 �Qty: 2 �($50 Visa), VISA25 �Qty: 3 �($75 Visa), VISA25 �Qty: 4 �($100 Visa), VISA25 �Qty: 5 �($125 Visa), VISA25 �Qty: 6 �($150 Visa), Travel Certificate |
| soldOutSheetChecked | checkbox (boolean) | 282 | NA |
| specialRequests | text (string) | 261 | Handicap Accessible Room, Pet Friendly |
| taxesDue | currency (number) | 445 | NA |
| tcpaOptIn | text (string) | 310 | Yes, No |
| textToDeveloper | text (string) | 274 | NA |
| tourBill | currency (number) | 312 | NA |
| tourId | text (string) | 392 | NA |
| tourRevenue | currency (number) | 24 | NA |
| triggerFieldAutoDispo | text (string) | 248 | NA |
| triggerFieldBluegreenConf | text (string) | 83 | NA |
| triggerFieldGenericConf | text (string) | 71 | NA |
| triggerFieldInternalConf | text (string) | 56 | NA |
| tsOwnerWith | text (string) | 100 | NA |
| tsOwner | text (string) | 99 | Yes, No |
| tsPurchasePrice | currency (number) | 323 | NA |
| vgResortChoices | text (string) | 195 | Cabo San Lucas - Villa Del Palmar, Cabo San Lucas - Reflect Krystal Grand Cabo, Cabo San Lucas - Posada Real San Jose, Cabo San Lucas - Barcelo Gran Faro Los Cabos, Puerto Vallarta - Villa Del Palmar, Puerto Vallarta - Buenaventura Grand Puerto Vallarta, Puerto Vallarta - Reflect Kyrstal Grand Nuevo Vallarta, Puerto Vallarta - Las Palmas by the Sea, Puerto Vallarta - Samba Vallarta, Loreto - Villa Del Palmar, Loreto - Loreto Bay Golf Resort & Spa, Cancun - Villa Del Palmar Deluxe Unit ~resagent1@taferresorts.com, Cancun - Oasis Palm Grand Category ~resagent2@taferresorts.com, Cancun - Oasis Palm LITE Category ~resagent2@taferresorts.com, Cancun - Grand Oasis Grand Category ~resagent2@taferresorts.com, Cancun - BlueBay Esmeralda Deluxe Garden View ~resagent2@taferresorts.com, Cancun - Ocean Riviera Paradise Resort DAISY JR Suite Garden View ~resagent2@taferresorts.com, Cancun - Ocean Riviera Paradise Resort EDEN JR Suite Garden View ~resagent2@taferresorts.com |
| voGenieNumber | text (string) | 145 | NA |
| vpgBonus | currency (number) | 147 | NA |
| totaltaxescollected | currency (number) | 471 | NA |
## payments
| Field | Type | id | choices* |
| ---- | ---- | ---- | --- |
| paymentDate | unknown | 6 | NA |
| relatedReservation | numeric (number) | 11 | NA |
| paymentType | text (string) | 8 | NA |
| referenceNumber | text (string) | 9 | NA |
| paymentAmount | currency (number) | 7 | NA |
| chargeDetail | text (string) | 10 | NEW PACKAGE REVENUE, OPS Sale, Vac Pack Service Fee, White Glove Service, Vacation Multiplier Service, Service Fee, GS/ACT - Reschedule Fee, GS/ACT - Cancellation Fee, GS/ACT - Add Extra Night, GS/ACT - Upgrade Room, GS/ACT - NQ Fee, GS/ACT - NT Fee, GS/ACT - NS Fee, GS/ACT - All-Inclusive Additional Persons Fee, GS/ACT - Ancora Fee, GS/ACT - Sunset Fee, GS/ACT - Refundable Deposit, GS/ACT - Vallarta Garden Fee, GS/ACT - Eagle Aruba Fee, GS/ACT - Maui Resort Fee, GS/ACT - Welk Cabo Resort Fee, GS/ACT - Villa Group Resort Fee, GS/ACT - Fives/UVC/GQ Resort Taxes, GS/ACT - Costa Rica Villa Sol Resort Taxes, GS/ACT - Bluebay Resort Fees, GS/ACT - Taino Resort Fees, GS/ACT - ULC Resort Fees, GS/ACT - ETS Resort Fees, GS/ACT - DVC Bali Resort Fees, GS/ACT - Be Live Resort Fees, GS/ACT - Deposit/Fee Remaining Balance, GS/ACT - NTR Resort Fee Non-Refundable, GS/ACT - NTR Additional Persons Fee, GS/ACT - CVC Resort Fee, CONF - Taxes, Admin - Partial Payment, Monster Savings Platform, RCI Activation Fee Non-Refundable, RCI Cleaning Fees Non-Refundable, TPP, Date Flex, Flexi stay, Monster Membership Recurring Fee, Monster Membership AddOn - 4 People, Monster Membership AddOn - 2 People, Monster Membership AddOn - SH |
| dateCreated | unknown | 1 | NA |
| dateModified | unknown | 2 | NA |
| lastModifiedBy | user (string) | 5 | NA |
| merchantResponse | text-multi-line (string) | 14 | NA |
| merchantResponseRefund | text-multi-line (string) | 17 | NA |
| merchantResponseVoid | text-multi-line (string) | 18 | NA |
| processingUser | user (string) | 29 | NA |
| refundProcessingUser | user (string) | 84 | NA |
| recordIdNumber | recordid, (no write) | 3 | NA |
| recordOwner | user (string) | 4 | NA |
| relatedCredential | numeric (number) | 12 | NA |
| relatedCreditCard | numeric (number) | 13 | NA |
| relatedEmployeeActivator1 | numeric (number) | 30 | NA |
| relatedEmployeeActivator2 | numeric (number) | 53 | NA |
| relatedEmployeeActivator3 | numeric (number) | 56 | NA |
| relatedEmployeeActivator4 | numeric (number) | 59 | NA |
| relatedPayment | numeric (number) | 22 | NA |
| relatedOffice | numeric (number) | 37 | NA |
| chargeDetail2 | text (string) | 46 | NEW PACKAGE REVENUE, OPS Sale, Vac Pack Service Fee, White Glove Service, GS/ACT - Reschedule Fee, GS/ACT - Cancellation Fee, GS/ACT - Add Extra Night, GS/ACT - Upgrade Room, GS/ACT - NQ Fee, GS/ACT - NT Fee, GS/ACT - NS Fee, GS/ACT - All-Inclusive Additional Persons Fee, GS/ACT - Ancora Fee, GS/ACT - Sunset Fee, GS/ACT - Refundable Deposit, GS/ACT - Maui Resort Fee, GS/ACT - Welk Cabo Resort Fee, GS/ACT - Villa Group Resort Fee, GS/ACT - Fives/UVC/GQ Resort Taxes, GS/ACT - Costa Rica Villa Sol Resort Taxes, GS/ACT - Bluebay Resort Fees, GS/ACT - ULC Resort Fees, GS/ACT - DVC Bali Resort Fees, GS/ACT - ETS Resort Fees, GS/ACT - Be Live Resort Fees, GS/ACT - Vallarta Garden Fee, GS/ACT - Deposit/Fee Remaining Balance, CONF - Taxes, Admin - Partial Payment, Monster Savings Platform, RCI Activation Fee Non-Refundable, RCI Cleaning Fees Non-Refundable, TPP, Date Flex |
| chargeDetail3 | text (string) | 47 | NA |
| chargeDetail4 | text (string) | 48 | NA |
| detail1Price | currency (number) | 49 | NA |
| detail2Price | currency (number) | 50 | NA |
| detail3Price | currency (number) | 51 | NA |
| detail4Price | currency (number) | 52 | NA |
| relatedSubscription | numeric (number) | 66 | NA |
| refundDate | date (yyyy-MM-dd) | 82 | NA |
| refundAmount | currency (number) | 83 | NA |
| refundInMerchant | checkbox (boolean) | 93 | NA |
| notes | text-multi-line (string) | 97 | NA |
| eppRevReceiptDate | unknown | 106 | NA |
| sendToCourierTriggerRevReceipt | checkbox (boolean) | 111 | NA |
| triggerFieldRevReceipt | text (string) | 112 | NA |
| chargebackAmount | currency (number) | 113 | NA |
| chargebackDate | date (yyyy-MM-dd) | 114 | NA |
| relatedRciWeek | numeric (number) | 117 | NA |
| resendToTracker | checkbox (boolean) | 128 | NA |
| vpaReceipt | file | 133 | NA |
| createRevReciept | url (string) | 134 | NA |
| numberOfDateLegRecordsdnr | numeric (number) | 158 | NA |
| numberOfDateLegRecordsdnr2 | numeric (number) | 164 | NA |
| datelegrecordsdnr | checkbox (boolean) | 168 | NA |
| wgsrecordsdnrNumber | checkbox (boolean) | 170 | NA |
| isuploaded | checkbox (boolean) | 171 | NA |
| relateddateleg | numeric (number) | 178 | NA |
| reasonForEditingRelatedDateLeg | text (string) | 186 | NA |
## email-activity
| Field | Type | id | choices* |
| ---- | ---- | ---- | --- |
| emailTo | text (string) | 6 | NA |
| emailFrom | text (string) | 7 | NA |
| emailCc | text (string) | 8 | NA |
| emailBcc | text (string) | 9 | NA |
| emailSubject | text (string) | 10 | NA |
| emailSentDate | unknown | 12 | NA |
| masterTableDbid | text (string) | 13 | NA |
| masterTableRecid | text (string) | 14 | NA |
| relatedProject | numeric (number) | 15 | NA |
| configurationName | text (string) | 16 | NA |
| errorDetails | text (string) | 23 | NA |
| dateCreated | unknown | 1 | NA |
| dateModified | unknown | 2 | NA |
| lastModifiedBy | user (string) | 5 | NA |
| recordIdNumber | recordid, (no write) | 3 | NA |
| recordOwner | user (string) | 4 | NA |
| relatedEmail | numeric (number) | 20 | NA |
| relatedReservation | numeric (number) | 17 | NA |
| relatedDateLeg | numeric (number) | 24 | NA |
| relatedTicket | numeric (number) | 28 | NA |
| relatedCharge | numeric (number) | 35 | NA |
| opened | checkbox (boolean) | 42 | NA |
| openedTimestamp | unknown | 43 | NA |
| clicked | checkbox (boolean) | 44 | NA |
| clickedTimestamp | unknown | 45 | NA |
| mercuryid | text (string) | 46 | NA |
## partials
| Field | Type | id | choices* |
| ---- | ---- | ---- | --- |
| dateCreated | unknown | 1 | NA |
| amountPaidToday | currency (number) | 6 | NA |
| typeOfPayment | text (string) | 8 | Initial Payment, Installment, Final Payment |
| last4OfCardUsed | text (string) | 24 | NA |
| approvalCode | text (string) | 25 | NA |
| dateModified | unknown | 2 | NA |
| lastModifiedBy | user (string) | 5 | NA |
| recordIdNumber | recordid, (no write) | 3 | NA |
| recordOwner | user (string) | 4 | NA |
| relatedReservation | numeric (number) | 9 | NA |
| relatedPackage | numeric (number) | 32 | NA |
## text-activity
| Field | Type | id | choices* |
| ---- | ---- | ---- | --- |
| cellNumber | text (string) | 6 | NA |
| message | text (string) | 7 | NA |
| processedDate | unknown | 8 | NA |
| processedMessage | text (string) | 9 | NA |
| error | checkbox (boolean) | 10 | NA |
| relatedReservation | numeric (number) | 14 | NA |
| errorDetails | text (string) | 16 | NA |
| clicked | checkbox (boolean) | 17 | NA |
| clickedTimestamp | unknown | 18 | NA |
| configurationName | text (string) | 19 | NA |
| mercuryId | text (string) | 20 | NA |
| direction | text (string) | 21 | Inbound, Outbound, Reply |
| attachments | text (string) | 22 | NA |
| dateCreated | unknown | 1 | NA |
| dateModified | unknown | 2 | NA |
| lastModifiedBy | user (string) | 5 | NA |
| recordIdNumber | recordid, (no write) | 3 | NA |
| recordOwner | user (string) | 4 | NA |
## subscriptions
| Field | Type | id | choices* |
| ---- | ---- | ---- | --- |
| dateCreated | unknown | 1 | NA |
| recordIdNumber | recordid, (no write) | 3 | NA |
| status | text (string) | 10 | Active, Cancelled by Guest, Suspended for Payment, Initiated Chargeback |
| subscriptionType | text (string) | 6 | Monster Savings Platform, TPP, Monster Membership Bronze, Monster Membership Silver, Monster Membe