0.0.6 • Published 2 years ago

monster_crm-sdk v0.0.6

Weekly downloads
-
License
-
Repository
-
Last release
2 years ago

Gordon

Ratonale

This is a package for interacting with the CRM designed to make it easy to do so. It batches requests and sends them to the CRM in a single request, meaning that the most requests that can happen is 1 per table per seconds. We have also added a few quality of life features such as typescript interfaces so that you know exactly what fields you can modify and what tables you have access to.

Usage

npm install monster_crm-sdk

Create a Reservation

import {Crm} from 'monster_crm-sdk';

const crm = new Crm(<username>, <password>, options?);

const res = await crm.tables.masterReservations.setReservation({
  'Any Additional Notes': 'hello world',
  'TestReservation': true
})

Update a Reservation

import {Crm} from 'monster_crm-sdk';

const crm = new Crm(<username>, <password>, options?);

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

Update/Create a Dateleg

If you would like to create a new one, just omit the hash.

import {Crm} from 'monster_crm-sdk';

const crm = new Crm(<user>, <password>)
const res = await crm.tables.dateLegs.setLeg({
  'Flight Info': 'hello world'
}, <hash>)

Write to a Date Field

import {Crm} from 'monster_crm-sdk';

const crm = new Crm(<user>, <password>)
const formattedDate = crm.formatCrmDate(new Date())

const res = await crm.tables.masterReservations.setReservation({
  'Any Additional Notes': 'hello world',
  'TestReservation': true
  'Date of Booking': formattedDate
}, '<hash>')

Write to the Email Activity Table

import {Crm} from 'monster_crm-sdk';

const crm = new Crm(<user>, <password>)

const res = crm.tables.EmailActivity.setEmail({
  emailFrom: <from>,
  emailTo: <to>,
  emailSubject: <subject>,
  relatedReservation: <reservationId>
})

Use the Caching Feature

The caching feature allows you to create a record out of order in the CRM, for example a common thing you might see is that you need to create a reservation before creating a new payment. With the caching feature you can create both at the same time. Here is an example using a date-leg.

import {Crm} from 'monster_crm-sdk';

const crm = new Crm(<user>, <password>)

const reservationId = crm.idFromCache('master-reservations')

const reservationResponse = crm.tables.masterReservations.setReservation({
'Guest Full Name': 'hello world',
'Reservation ID#': reservationId
})

const dateleg = crm.tables.dateLegs.setLeg({
"Related Reservation": reservationId,
'Flight Info': 'hello world'
})

const [res, dl] = await Promise.all([reservationResponse, dateleg])
// both reservation and dateleg were created simultaniously

Id from Cache values

  • master-reservations
  • date-legs

Options

OptionTypeDescription
forceProdbooleanForce gordon 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, which is either the record id 'updated', 'not updated'

Table Write Information

master-reservations

FieldTypeidchoices*
Date of Bookingdate (yyyy-MM-dd)12NA
Reservation ID#recordid, (no write)3NA
Destinationtext (string)31SLR - 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
Guest Full Nametext (string)79NA
Spouse Full Nametext (string)84NA
Email Addressemail (\w+@\w+.\w+)78NA
Marital Statustext (string)81Married, Single Female, Single Male, Co-Hab, Married/Co-Hab (Male Couples), Married/Co-Hab (Female Couples)
Alternate Numberphone ((\d{3}) \d{3}-\d{4})76NA
Phone Numberphone ((\d{3}) \d{3}-\d{4})82NA
Room Typetext (string)33Standard - 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)
Source Codetext (string)47Online 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
VO Completecheckbox (boolean)96NA
Cancel Reservationcheckbox (boolean)105NA
Chargeback Datedate (yyyy-MM-dd)236NA
Check for Partialcheckbox (boolean)98NA
Partial Amount Paid Todaycurrency (number)99NA
Credit Card Typetext (string)56Visa, Mastercard, Discover, American Express, amex, External
CC Approval Codetext (string)58NA
# of Active Date legsnumeric (number)571NA
# of Adultstext (string)28NA
# of Childrentext (string)29NA
# of Nightsnumeric (number)27NA
Age 25+?text (string)424Yes, No
Any Additional Notestext-multi-line (string)60NA
Bonus Travel Giftingtext (string)410Choose 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
Callback Reasontext (string)250NA
Chargeback Amountcurrency (number)237NA
Credit Card Declined?checkbox (boolean)335NA
Citytext (string)161NA
Countrytext (string)164NA
Credit Card?text (string)392Has Major CC, Debit Card Only, Unknown
Postal Codetext (string)163NA
State/Regiontext (string)162Alabama, 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, British Columbia, CAN, Ontario, CAN, Quebec, CAN, Manitoba, CAN, Alberta, CAN, Saskatchewan, CAN, New Brunswick, CAN, Nova Scotia, CAN, Newfoundland Labrador, CAN, Puerto Rico
Street 1text (string)159NA
Street 2text (string)160NA
Date Cancelleddate (yyyy-MM-dd)106NA
Developertext (string)30MST - Monster, SLR - Silverlake Resort, OPS - Online Package Sales, SMD - Smoky Mountain Distributors
Dispositiontext (string)538CONF - 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
DNCcheckbox (boolean)457NA
Genie #text (string)46NA
Giftingtext (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
Gifting Notestext-multi-line (string)145NA
GTcheckbox (boolean)232NA
Guest Date of Birthdate (yyyy-MM-dd)41NA
Incomecurrency (number)40NA
Last 4 of Credit Card Onlytext (string)53NA
Last Modified Byuser (string)5NA
List of Developers Activatedtext (string)504NA
Months Opentext (string)2612, 15, 18, 24, 36, No Expiration, Dated Package
NQcheckbox (boolean)233NA
NScheckbox (boolean)234NA
NTcheckbox (boolean)453NA
Occupationtext (string)183NA
Package Price (without pro fee)currency (number)35NA
Partial Balance Due Datedate (yyyy-MM-dd)38NA
Partial Paid in Fullcheckbox (boolean)95NA
Processing Feecurrency (number)36NA
RCI Purchased?text (string)475Yes, No
RCI Typetext (string)4761 Week Pin, 5 Week Pin, 10 Week Pin
Reason for Canceltext (string)107NA
Rebrandly Welcome Letter Linkunknown533NA
Refund Amountcurrency (number)122NA
Refund Datedate (yyyy-MM-dd)123NA
Refund Text Triggercheckbox (boolean)577NA
Related Employeenumeric (number)186NA
Related Employee2numeric (number)205NA
Related Employee3numeric (number)196NA
Related Office IDnumeric (number)520NA
Related RCI Pinnumeric (number)486NA
Requested Arrival Datedate (yyyy-MM-dd)473NA
Reservation Owneruser (string)4NA
Savon Purchased?text (string)474Yes, No
Send to Courier Trigger Welcome Lettercheckbox (boolean)112NA
Send to Courier Trigger OPS/OVR/NROcheckbox (boolean)600NA
Send to Courier Trigger PCGcheckbox (boolean)339NA
Send to Courier Trigger Refundcheckbox (boolean)227NA
Send to Courier Trigger Surveycheckbox (boolean)289NA
Send to Courier Trigger Auto Dispocheckbox (boolean)643NA
Send to Courier Trigger Text Messagecheckbox (boolean)574NA
Send to Courier Trigger TSTP Welcome Lettercheckbox (boolean)438NA
Spouse Date of Birthdate (yyyy-MM-dd)272NA
Spouse Occupationtext (string)184NA
Total # of Tripsnumeric (number)425NA
Total Net GS Revenue - Activations Deposit Onlycurrency (number)593NA
Net GS Revenue - Deposit Only (7 Days)currency (number)734NA
Total Paidcurrency (number)535NA
Total Refundedcurrency (number)536NA
Total Voidedcurrency (number)537NA
Trigger Field Welcome Lettertext (string)117NA
Trigger Field OPS/OVR/NROtext (string)603NA
Trigger Field PCGtext (string)342NA
Trigger Field Refundtext (string)228NA
Trigger Field Surveytext (string)290NA
Trigger Field Auto Dispotext (string)644NA
Trigger Field TSTP Welcome Lettertext (string)441NA
Active Date Legstext (string)594NA
Total VPS Chargedcurrency (number)621NA
Refund GS Agentuser (string)623NA
R/S App Revenuecurrency (number)624NA
Developer NQstext (string)625NA
Callback Agentunknown646NA
Total of Partial Installments Paidcurrency (number)654NA
# of Auto-Dispo Emails Todaynumeric (number)662NA
# of Surveys Sentnumeric (number)663NA
Sent HCdate (yyyy-MM-dd)664NA
# of Emailsnumeric (number)667NA
Task List Dest.text (string)671NA
OPS Sub Officetext (string)675Phone Room - Day, Phone Room - Night, Chat Team, Service Team, Online Sale
Date Leg Confirmation Needednumeric (number)676NA
# of Trips Completednumeric (number)680NA
Upgrade Amounts Chargedcurrency (number)681NA
TCPA Opt-In?text (string)685Yes, No, Didn't Ask
DL TCPA Opt-In YESnumeric (number)686NA
DL TCPA Opt-In NOnumeric (number)687NA
IP Address Cleantext (string)690NA
Homeownertext (string)691Homeowner, Renter, Unknown
# of Trips Completed - All Inclusivenumeric (number)693NA
WGS Guestnumeric (number)695NA
MSP Subscriptioncheckbox (boolean)701NA
Built with Partner Portalcheckbox (boolean)703NA
TSOcheckbox (boolean)705NA
Owns Timeshare Withtext (string)706NA
Children's Agestext (string)7070, 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
Guest DL Statetext (string)708Alabama, 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
Guest DL #text (string)709NA
Spouse DL Statetext (string)710Alabama, 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
Spouse DL #text (string)711NA
Total RCI Activation Fee Paidcurrency (number)712NA
PAPP Linktext (string)715NA
VO PDF Linkurl (string)719NA
Add Subscription after POSurl (string)720NA
# of Active RCI weeksnumeric (number)721NA
Passwordtext (string)722NA
Text VO Documenturl (string)725NA
Used Text VO Overridecheckbox (boolean)726NA
BG Fico Checktext (string)727NA
Ancora Fico Checktext (string)728NA
Date Flex Amountcurrency (number)730NA
TestReservationcheckbox (boolean)733NA
TPP Subscriptions (Active)numeric (number)735NA
Date Leg Officetext (string)739NA
Related Activatornumeric (number)740NA
RafaSdk-timestampdate (yyyy-MM-dd)743NA
Total Credit on Filecurrency (number)744NA
SourceURLurl (string)746NA
# of Payments (Pkg Sales)numeric (number)748NA
Ancora Fico Ordertext (string)749NA
DatrixStatustext (string)751NA
resend to trackercheckbox (boolean)752NA
Notestext-multi-line (string)753NA
# of Notesnumeric (number)756NA
Notes Historytext (string)757NA
TPP Amountcurrency (number)761NA

date-legs

FieldTypeidchoices*
Record ID#recordid, (no write)3NA
Reservation Statustext (string)27Active, Cancelled
Arrival Datedate (yyyy-MM-dd)8NA
Confirmation Numbertext (string)12NA
Tour Datedate (yyyy-MM-dd)15NA
Tour Timetext (string)1607:30 am, 08:00 am, 08:30 am, 08:45 am, 09:00 am, 09:30 am, 10:00 am, 10:30 am, 10:45 am, 11:00 am, 11:30 am, 12:00 pm, 12:30 pm, 12:45 pm, 1:00 pm, 02:00 pm, 02:30 pm, 03:00 pm, 03:30 pm, 07:00 pm, Assigned at Check-in, Assigned At Check-in, 0, 11:20am, 8:50 AM, 3:00 PM, 11:20 AM, Assigned at Checkin, ?11?:?30? ?AM, 9:00 AM, 2:45 PM, 11:25 AM, 9:45 AM, 8:30 AM, 8:55 AM, 1:25 PM, 1:30 PM, ?9?:?00? ?AM, 2:15 AM, 2:15 PM, 1:50 AM, 12:30 AM, 2:30 PM, 9:30 AM, 10:30, 8:20 AM, 01:30 PM, 1:20 PM, 1:20 AM, ?12?:?00? ?PM, 2:00 PM, No Tour Required, ASSIGNED AT CHECK IN, 6:00 PM, ?2?:?30? ?PM, 12:30, ASSIGNED AT CHECK IN, ?1?:?30? ?PM, 12:30pm, 10:00, 11:15 AM, 1:00pm, 8:30, 9:00, 09:30 PM, 10:55 AM, 12pm, 10:00AM, 12:15 PM, 2:14 PM, 1130, _other, 3 PM, 8:45 AM, 01:00 PM, ?9?:?30? ?AM, 9:00am, 02:45 PM, 09:30, 11:30 PM, 00:00 AM, 01:00 pm, ?12?:?30? ?PM, ?10?:?30? ?AM, 1200 PM, 12:00 AM, 12:45 AM, 02:15 PM, 8:25 AM, 11:45 AM, 9:15 AM, -, 9:55 AM, 11:45 PM, 8:55, 11:25, 12:00, 11:26 AM, OVERAGE, 12:01 AM, 11:30, 1:55 AM, 1:55 PM, 1:45 PM, 8:31 AM, 11:30am, 11:55 AM, 11:55 PM, 8:00 AM, 2:30 AM, 12:29 PM, 11:56 AM, 9:30M, 1:00 AM, 1:30 AM, 2:00 AM, 8:15 AM, 11:25 PM
Activating Officetext (string)140GS 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
# of Adults (13+)numeric (number)172NA
# of Children (0-12)numeric (number)173NA
# of Referralsnumeric (number)182NA
Account #text (string)169NA
Active Phone for Textstext (string)170Primary Phone, Alternate Phone
Arrival Confirmedcheckbox (boolean)18NA
AutoDispofile251NA
BG Room Typestext (string)93Standard Oceanview - Sleeps 4, Efficiency Oceanview - Sleeps 4, Suite Oceanview - Sleeps 6, 1 Bedroom Oceanview - Sleeps 4, 2 Bedroom - Sleeps 6
Bluegreen_Confirmation_Letterfile78NA
CAPP Confirmedcheckbox (boolean)302NA
CAPP Short Linktext (string)303NA
Childrens Ages (List all)text (string)174less 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
Confirmation Text Statustext (string)128NA
Confirmation Text Triggercheckbox (boolean)123NA
ConfLetter Text Triggercheckbox (boolean)266NA
Manual CAPP Send Text Triggercheckbox (boolean)362NA
ConfLetterRebrandly Text Statustext (string)268NA
Date Cancelleddate (yyyy-MM-dd)213NA
Date Re-Actived by Appdate (yyyy-MM-dd)229NA
Date Requesttext (string)26NA
Dates Unavailablecheckbox (boolean)239NA
Developer Notes from DIPtext (string)273NA
Dispositiontext (string)208CONF - 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
Facebook Like Text Statustext (string)281NA
FICO Checkedcheckbox (boolean)283NA
Generic_Confirmation_Letterfile66NA
Giftingtext (string)13$150 Visa Card, $100 Visa Card, $75 Visa Card, $50 Visa Card, $100 Dining Dough, N/A
GTcheckbox (boolean)20NA
Internal_Confirmation_Letterfile51NA
Last Modified Byuser (string)5NA
Mail Hard Copy Confirmationcheckbox (boolean)196NA
Notestext-multi-line (string)113NA
NQcheckbox (boolean)23NA
NQ by Developercheckbox (boolean)238NA
NScheckbox (boolean)22NA
NTcheckbox (boolean)21NA
OPC Giftingtext (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
Reason for Canceltext (string)152Guest 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
Rebrandly Confirmation Letter Linktext (string)263NA
Short Date Request Letter Linktext (string)402NA
Record Owneruser (string)4NA
Referral Short Linktext (string)304NA
Related Destination IDnumeric (number)292NA
Related Employeenumeric (number)138NA
Related Employee2numeric (number)143NA
Related Logonumeric (number)76NA
Related Reservationnumeric (number)31NA
Related Resortnumeric (number)159NA
Related Room Typenumeric (number)130NA
Reschedule App Sourcetext (string)237NA
Reschedule Text Statustext (string)216NA
Reschedule Text Triggercheckbox (boolean)199NA
Send Referral Linkcheckbox (boolean)305NA
Send to Courier Trigger Auto Dispocheckbox (boolean)250NA
Send to Courier Trigger Bluegreen Confcheckbox (boolean)85NA
Send to Courier Trigger Generic Confcheckbox (boolean)73NA
Send to Courier Trigger Internal Confcheckbox (boolean)61NA
short Reschedule Linktext (string)211NA
Silverlake Giftingtext (string)116VISA25 �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
Sold Out Sheet Checkedcheckbox (boolean)282NA
Special Requeststext (string)261Handicap Accessible Room
TCPA Opt-In?text (string)310Yes, No
Text to Developertext (string)274NA
Tour Billcurrency (number)312NA
Tour Revenuecurrency (number)24NA
Trigger Field Auto Dispotext (string)248NA
Trigger Field Bluegreen Conftext (string)83NA
Trigger Field Generic Conftext (string)71NA
Trigger Field Internal Conftext (string)56NA
TS Owner With:text (string)100NA
TS Owner?text (string)99Yes, No
VG Resort Choicestext (string)195Cabo 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
VO Genie #text (string)145NA
VPG Bonuscurrency (number)147NA
Confirmation Team Memberuser (string)315NA
Bad Tour Reasontext (string)322NA
TS Purchase Pricecurrency (number)323NA
Related Deposit/Taxesnumeric (number)335NA
Hashtext (string)338NA
Deposit/Taxes Associated?text (string)339Yes, No
VPS/WGS Purchased on THIS date leg?text (string)340Yes, No
Related VPSnumeric (number)341NA
hash2text (string)346NA
FUTMuser (string)348NA
Date Tour Status Entereddate (yyyy-MM-dd)352NA
CAPP Source - Confirmedtext (string)353NA
Bad Tour Charge Duecurrency (number)355NA
Bad Tour Charge Statustext (string)356NA
Manual CAPP Send Statustext (string)360NA
Cancel&R/S Team Memberuser (string)365NA
Cancel&R/S Datedate (yyyy-MM-dd)366NA
3rd Traveler Agenumeric (number)371NA
2nd Traveler Agenumeric (number)394NA
4th Traveler Agenumeric (number)372NA
Added Tour Date?checkbox (boolean)376NA
Arrival Dates Historytext (string)381NA
Confirmation Number Historytext (string)388NA
Tour IDtext (string)392NA
Datrix - User Overrode Depositcheckbox (boolean)395NA
Flight Infotext-multi-line (string)397NA
Built by Datrixcheckbox (boolean)399NA
Related Deposit/Taxes Paymentnumeric (number)421NA
Related WGS Paymentnumeric (number)427NA

payments

FieldTypeidchoices*
Related Reservationnumeric (number)11NA
Payment Typetext (string)8NA
Reference Numbertext (string)9NA
Payment Amountcurrency (number)7NA
Charge Detailtext (string)10NEW 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 - Vallarta Garden 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 - 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, CONF - Taxes, Admin - Partial Payment, Monster Savings Platform, RCI Activation Fee Non-Refundable, RCI Cleaning Fees Non-Refundable, TPP, Date Flex
Last Modified Byuser (string)5NA
Merchant Responsetext-multi-line (string)14NA
Merchant Response: Refundtext-multi-line (string)17NA
Merchant Response: Voidtext-multi-line (string)18NA
Processing Useruser (string)29NA
Refund Processing Useruser (string)84NA
Record ID#recordid, (no write)3NA
Record Owneruser (string)4NA
Related Credentialnumeric (number)12NA
Related Credit Cardnumeric (number)13NA
Related Employee (Activator 1)numeric (number)30NA
Related Employee (Activator 2)numeric (number)53NA
Related Employee (Activator 3)numeric (number)56NA
Related Employee (Activator 4)numeric (number)59NA
Related Paymentnumeric (number)22NA
Related Officenumeric (number)37NA
Charge Detail 2text (string)46NEW 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
Charge Detail 3text (string)47NA
Charge Detail 4text (string)48NA
Detail 1 Pricecurrency (number)49NA
Detail 2 Pricecurrency (number)50NA
Detail 3 Pricecurrency (number)51NA
Detail 4 Pricecurrency (number)52NA
Related Subscriptionnumeric (number)66NA
Refund Datedate (yyyy-MM-dd)82NA
Refund Amountcurrency (number)83NA
Refund in Merchantcheckbox (boolean)93NA
Notestext-multi-line (string)97NA
Send to Courier Trigger Rev Receiptcheckbox (boolean)111NA
Trigger Field Rev Receipttext (string)112NA
Chargeback Amountcurrency (number)113NA
Chargeback Datedate (yyyy-MM-dd)114NA
Related RCI Weeknumeric (number)117NA
resend to trackercheckbox (boolean)128NA
VPA_Receiptfile133NA
Create Rev Reciepturl (string)134NA
# of Date Leg recordsnumeric (number)164NA

email-activity

FieldTypeidchoices*
Email Totext (string)6NA
Email Fromtext (string)7NA
Email CCtext (string)8NA
Email BCCtext (string)9NA
Email Subjecttext (string)10NA
Master Table dbidtext (string)13NA
Master Table recidtext (string)14NA
Related Projectnumeric (number)15NA
Configuration Nametext (string)16NA
Error Detailstext (string)23NA
Last Modified Byuser (string)5NA
Record ID#recordid, (no write)3NA
Record Owneruser (string)4NA
Related Emailnumeric (number)20NA
Related Reservationnumeric (number)17NA
Related Date Legnumeric (number)24NA
Related Ticketnumeric (number)28NA
Related Chargenumeric (number)35NA
0.0.6

2 years ago

0.0.5

2 years ago

0.0.4

2 years ago

0.0.3

2 years ago

0.0.1

2 years ago