0.0.41 • Published 1 year ago

@rofer/crm-sdk v0.0.41

Weekly downloads
-
License
-
Repository
-
Last release
1 year 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*
dateCreatedunknown1NA
dateOfBookingdate (yyyy-MM-dd)12NA
reservationIdNumberrecordid, (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
guestFullNametext (string)79NA
spouseFullNametext (string)84NA
emailAddressemail (\w+@\w+.\w+)78NA
maritalStatustext (string)81Married, Single Female, Single Male, Co-Hab, Married/Co-Hab (Male Couples), Married/Co-Hab (Female Couples)
alternateNumberphone ((\d{3}) \d{3}-\d{4})76NA
phoneNumberphone ((\d{3}) \d{3}-\d{4})82NA
roomTypetext (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)
sourceCodetext (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, 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
voCompletecheckbox (boolean)96NA
cancelReservationcheckbox (boolean)105NA
chargebackDatedate (yyyy-MM-dd)236NA
checkForPartialcheckbox (boolean)98NA
partialAmountPaidTodaycurrency (number)99NA
creditCardTypetext (string)56Visa, Mastercard, Discover, American Express, amex, External
ccApprovalCodetext (string)58NA
numberOfActiveDateLegsnumeric (number)571NA
numberOfAdultstext (string)28NA
numberOfChildrentext (string)29NA
numberOfNightsnumeric (number)27NA
age25+text (string)424Yes, No
anyAdditionalNotestext-multi-line (string)60NA
bonusTravelGiftingtext (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
callbackDateunknown249NA
callbackReasontext (string)250NA
chargebackAmountcurrency (number)237NA
creditCardDeclinedcheckbox (boolean)335NA
citytext (string)161NA
countrytext (string)164NA
creditCardtext (string)392Has Major CC, Debit Card Only, Unknown
postalCodetext (string)163NA
stateSlashRegiontext (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, Alberta, CAN, British Columbia, CAN, Quebec, 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
street1text (string)159NA
street2text (string)160NA
dateCancelleddate (yyyy-MM-dd)106NA
dateModifiedunknown2NA
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
efpDateWelcomeLetterunknown110NA
efpDateOpsSlashOvrSlashNrounknown599NA
efpDatePcgunknown338NA
efpDateRefundunknown223NA
efpDateSurveyunknown283NA
efpDateAutoDispounknown637NA
genieNumbertext (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
giftingNotestext-multi-line (string)145NA
gtcheckbox (boolean)232NA
guestDateOfBirthdate (yyyy-MM-dd)41NA
incomecurrency (number)40NA
last4OfCreditCardOnlytext (string)53NA
lastModifiedByuser (string)5NA
listOfDevelopersActivatedtext (string)504NA
monthsOpentext (string)2612, 15, 18, 24, 36, No Expiration, Dated Package
nqcheckbox (boolean)233NA
nscheckbox (boolean)234NA
ntcheckbox (boolean)453NA
occupationtext (string)183NA
packagePriceWithoutProFeecurrency (number)35NA
partialBalanceDueDatedate (yyyy-MM-dd)38NA
partialPaidInFullcheckbox (boolean)95NA
processingFeecurrency (number)36NA
rciPurchasedtext (string)475Yes, No
rciTypetext (string)4761 Week Pin, 5 Week Pin, 10 Week Pin
reasonForCanceltext (string)107NA
rebrandlyWelcomeLetterLinkunknown533NA
refundAmountcurrency (number)122NA
refundDatedate (yyyy-MM-dd)123NA
refundTextDateSlashTimeunknown579NA
refundTextTriggercheckbox (boolean)577NA
relatedEmployeenumeric (number)186NA
relatedEmployee2numeric (number)205NA
relatedEmployee3numeric (number)196NA
relatedOfficeIdnumeric (number)520NA
relatedRciPinnumeric (number)486NA
requestedArrivalDatedate (yyyy-MM-dd)473NA
reservationOwneruser (string)4NA
savonPurchasedtext (string)474Yes, No
sendToCourierTriggerWelcomeLettercheckbox (boolean)112NA
sendToCourierTriggerOpsSlashOvrSlashNrocheckbox (boolean)600NA
sendToCourierTriggerPcgcheckbox (boolean)339NA
sendToCourierTriggerRefundcheckbox (boolean)227NA
sendToCourierTriggerSurveycheckbox (boolean)289NA
sendToCourierTriggerAutoDispocheckbox (boolean)643NA
sendToCourierTriggerTextMessagecheckbox (boolean)574NA
sendToCourierTriggerTstpWelcomeLettercheckbox (boolean)438NA
spouseDateOfBirthdate (yyyy-MM-dd)272NA
spouseOccupationtext (string)184NA
totalNumberOfTripsnumeric (number)425NA
totalNetGsRevenueActivationsDepositOnlycurrency (number)593NA
netGsRevenueDepositOnly7Dayscurrency (number)734NA
totalPaidcurrency (number)535NA
totalRefundedcurrency (number)536NA
totalVoidedcurrency (number)537NA
triggerFieldWelcomeLettertext (string)117NA
triggerFieldOpsSlashOvrSlashNrotext (string)603NA
triggerFieldPcgtext (string)342NA
triggerFieldRefundtext (string)228NA
triggerFieldSurveytext (string)290NA
triggerFieldAutoDispotext (string)644NA
triggerFieldTstpWelcomeLettertext (string)441NA
tstpEfpDateunknown437NA
activeDateLegstext (string)594NA
totalVpsChargedcurrency (number)621NA
refundGsAgentuser (string)623NA
rSlashSAppRevenuecurrency (number)624NA
developerNqstext (string)625NA
callbackAgentunknown646NA
totalOfPartialInstallmentsPaidcurrency (number)654NA
numberOfAutoDispoEmailsTodaynumeric (number)662NA
numberOfSurveysSentnumeric (number)663NA
sentHcdate (yyyy-MM-dd)664NA
numberOfEmailsnumeric (number)667NA
taskListDesttext (string)671NA
opsSubOfficetext (string)675Phone Room - Day, Phone Room - Night, Chat Team, Service Team, Online Sale
dateLegConfirmationNeedednumeric (number)676NA
numberOfTripsCompletednumeric (number)680NA
upgradeAmountsChargedcurrency (number)681NA
tcpaOptIntext (string)685Yes, No, Didn't Ask
dlTcpaOptInYesnumeric (number)686NA
dlTcpaOptInNonumeric (number)687NA
ipAddressCleantext (string)690NA
homeownertext (string)691Homeowner, Renter, Unknown
numberOfTripsCompletedAllInclusivenumeric (number)693NA
wgsGuestnumeric (number)695NA
mspSubscriptioncheckbox (boolean)701NA
builtWithPartnerPortalcheckbox (boolean)703NA
tsocheckbox (boolean)705NA
ownsTimeshareWithtext (string)706NA
children'sAgestext (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, 6262d5ca-4ef3-449d-bdfc-b2b34f81dd43, 661cc16a-909b-4897-82ad-58dd7823ae07, 1b92948f-0dad-4e01-af0c-8bcecb308dd7, -15, -8, 1.5
guestDlStatetext (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
guestDlNumbertext (string)709NA
spouseDlStatetext (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
spouseDlNumbertext (string)711NA
totalRciActivationFeePaidcurrency (number)712NA
pappLinktext (string)715NA
voPdfLinkurl (string)719NA
addSubscriptionAfterPosurl (string)720NA
numberOfActiveRciWeeksnumeric (number)721NA
passwordtext (string)722NA
textVoDocumenturl (string)725NA
usedTextVoOverridecheckbox (boolean)726NA
bgFicoChecktext (string)727NA
ancoraFicoChecktext (string)728NA
dateFlexAmountcurrency (number)730NA
testreservationcheckbox (boolean)733NA
tppSubscriptionsActivenumeric (number)735NA
dateLegOfficetext (string)739NA
relatedActivatornumeric (number)740NA
rafasdkTimestampdate (yyyy-MM-dd)743NA
totalCreditOnFilecurrency (number)744NA
sourceurlurl (string)746NA
numberOfPaymentsPkgSalesnumeric (number)748NA
ancoraFicoOrdertext (string)749NA
datrixstatustext (string)751NA
resendToTrackercheckbox (boolean)752NA
notestext-multi-line (string)753NA
numberOfNotesnumeric (number)756NA
notesHistorytext (string)757NA
tppAmountcurrency (number)761NA
totalPaymentAmountcurrency (number)762NA

date-legs

FieldTypeidchoices*
recordIdNumberrecordid, (no write)3NA
reservationStatustext (string)27Active, Cancelled
arrivalDatedate (yyyy-MM-dd)8NA
confirmationNumbertext (string)12NA
tourDatedate (yyyy-MM-dd)15NA
tourTimetext (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, 2:25 PM, 8:56 AM, 2:25 AM, 1:20pm, 1:30pm, 12 PM, 9:30, ?1?:?00? ?PM, ?10?:?00? ?AM, 9:31 AM, 930am, ?9?:?45? ?AM, 2:30PM, 9:00 PM, AM, 09:00am, 01:00 AM, 04:00 PM
activatingOfficetext (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, Conf
numberOfAdults13+numeric (number)172NA
numberOfChildren012numeric (number)173NA
numberOfReferralsnumeric (number)182NA
accountNumbertext (string)169NA
activePhoneForTextstext (string)170Primary Phone, Alternate Phone
arrivalConfirmedcheckbox (boolean)18NA
autodispofile251NA
bgRoomTypestext (string)93Standard Oceanview - Sleeps 4, Efficiency Oceanview - Sleeps 4, Suite Oceanview - Sleeps 6, 1 Bedroom Oceanview - Sleeps 4, 2 Bedroom - Sleeps 6
bluegreenConfirmationLetterfile78NA
cappConfirmedcheckbox (boolean)302NA
cappShortLinktext (string)303NA
childrensAgesListAlltext (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
confirmationTextDateSlashTimeunknown125NA
confirmationTextStatustext (string)128NA
confirmationTextTriggercheckbox (boolean)123NA
confletterTextTriggercheckbox (boolean)266NA
manualCappSendTextTriggercheckbox (boolean)362NA
confletterrebrandlyTextDateSlashTimeunknown267NA
confletterrebrandlyTextStatustext (string)268NA
dateCancelleddate (yyyy-MM-dd)213NA
dateConfirmedunknown19NA
dateCreatedunknown1NA
dateModifiedunknown2NA
dateReActivedByAppdate (yyyy-MM-dd)229NA
dateRequesttext (string)26NA
datesUnavailablecheckbox (boolean)239NA
developerNotesFromDiptext (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
efpDateAutoDispounknown244NA
efpDateBluegreenConfunknown79NA
efpDateGenericConfunknown67NA
efpDateInternalConfunknown52NA
facebookLikeTextDateSlashTimeunknown280NA
facebookLikeTextStatustext (string)281NA
ficoCheckedcheckbox (boolean)283NA
genericConfirmationLetterfile66NA
giftingtext (string)13$150 Visa Card, $100 Visa Card, $75 Visa Card, $50 Visa Card, $100 Dining Dough, N/A
gtcheckbox (boolean)20NA
internalConfirmationLetterfile51NA
lastModifiedByuser (string)5NA
mailHardCopyConfirmationcheckbox (boolean)196NA
notestext-multi-line (string)113NA
nqcheckbox (boolean)23NA
nqByDevelopercheckbox (boolean)238NA
nscheckbox (boolean)22NA
ntcheckbox (boolean)21NA
opcGiftingtext (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
reasonForCanceltext (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
rebrandlyConfirmationLetterLinktext (string)263NA
shortDateRequestLetterLinktext (string)402NA
recordOwneruser (string)4NA
referralShortLinktext (string)304NA
relatedDestinationIdnumeric (number)292NA
relatedEmployeenumeric (number)138NA
relatedEmployee2numeric (number)143NA
relatedLogonumeric (number)76NA
relatedReservationnumeric (number)31NA
relatedResortnumeric (number)159NA
relatedRoomTypenumeric (number)130NA
rescheduleAppSourcetext (string)237NA
rescheduleTextDateSlashTimeunknown201NA
rescheduleTextStatustext (string)216NA
rescheduleTextTriggercheckbox (boolean)199NA
sendReferralLinkcheckbox (boolean)305NA
sendToCourierTriggerAutoDispocheckbox (boolean)250NA
sendToCourierTriggerBluegreenConfcheckbox (boolean)85NA
sendToCourierTriggerGenericConfcheckbox (boolean)73NA
sendToCourierTriggerInternalConfcheckbox (boolean)61NA
shortRescheduleLinktext (string)211NA
silverlakeGiftingtext (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
soldOutSheetCheckedcheckbox (boolean)282NA
specialRequeststext (string)261Handicap Accessible Room
tcpaOptIntext (string)310Yes, No
textToDevelopertext (string)274NA
tourBillcurrency (number)312NA
tourRevenuecurrency (number)24NA
triggerFieldAutoDispotext (string)248NA
triggerFieldBluegreenConftext (string)83NA
triggerFieldGenericConftext (string)71NA
triggerFieldInternalConftext (string)56NA
tsOwnerWithtext (string)100NA
tsOwnertext (string)99Yes, No
vgResortChoicestext (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
voGenieNumbertext (string)145NA
vpgBonuscurrency (number)147NA
confirmationTeamMemberuser (string)315NA
badTourReasontext (string)322NA
tsPurchasePricecurrency (number)323NA
relatedDepositSlashTaxesnumeric (number)335NA
hashtext (string)338NA
depositSlashTaxesAssociatedtext (string)339Yes, No
vpsSlashWgsPurchasedOnThisDateLegtext (string)340Yes, No
relatedVpsnumeric (number)341NA
hash2text (string)346NA
futmuser (string)348NA
dateTourStatusEntereddate (yyyy-MM-dd)352NA
cappSourceConfirmedtext (string)353NA
badTourChargeDuecurrency (number)355NA
badTourChargeStatustext (string)356NA
manualCappSendDateSlashTimeunknown359NA
manualCappSendStatustext (string)360NA
cancelAndRSlashSTeamMemberuser (string)365NA
cancelAndRSlashSDatedate (yyyy-MM-dd)366NA
thirdUndefinednumeric (number)371NA
secondUndefinednumeric (number)394NA
fourthUndefinednumeric (number)372NA
addedTourDatecheckbox (boolean)376NA
arrivalDatesHistorytext (string)381NA
confirmationNumberHistorytext (string)388NA
tourIdtext (string)392NA
datrixUserOverrodeDepositcheckbox (boolean)395NA
flightInfotext-multi-line (string)397NA
builtByDatrixcheckbox (boolean)399NA
relatedDepositSlashTaxesPaymentnumeric (number)421NA
relatedWgsPaymentnumeric (number)427NA
cappSignatureLinkurl (string)433NA

payments

FieldTypeidchoices*
paymentDateunknown6NA
relatedReservationnumeric (number)11NA
paymentTypetext (string)8NA
referenceNumbertext (string)9NA
paymentAmountcurrency (number)7NA
chargeDetailtext (string)10NEW 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 - 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
dateCreatedunknown1NA
dateModifiedunknown2NA
lastModifiedByuser (string)5NA
merchantResponsetext-multi-line (string)14NA
merchantResponseRefundtext-multi-line (string)17NA
merchantResponseVoidtext-multi-line (string)18NA
processingUseruser (string)29NA
refundProcessingUseruser (string)84NA
recordIdNumberrecordid, (no write)3NA
recordOwneruser (string)4NA
relatedCredentialnumeric (number)12NA
relatedCreditCardnumeric (number)13NA
relatedEmployeeActivator1numeric (number)30NA
relatedEmployeeActivator2numeric (number)53NA
relatedEmployeeActivator3numeric (number)56NA
relatedEmployeeActivator4numeric (number)59NA
relatedPaymentnumeric (number)22NA
relatedOfficenumeric (number)37NA
chargeDetail2text (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
chargeDetail3text (string)47NA
chargeDetail4text (string)48NA
detail1Pricecurrency (number)49NA
detail2Pricecurrency (number)50NA
detail3Pricecurrency (number)51NA
detail4Pricecurrency (number)52NA
relatedSubscriptionnumeric (number)66NA
refundDatedate (yyyy-MM-dd)82NA
refundAmountcurrency (number)83NA
refundInMerchantcheckbox (boolean)93NA
notestext-multi-line (string)97NA
eppRevReceiptDateunknown106NA
sendToCourierTriggerRevReceiptcheckbox (boolean)111NA
triggerFieldRevReceipttext (string)112NA
chargebackAmountcurrency (number)113NA
chargebackDatedate (yyyy-MM-dd)114NA
relatedRciWeeknumeric (number)117NA
resendToTrackercheckbox (boolean)128NA
vpaReceiptfile133NA
createRevReciepturl (string)134NA
numberOfDateLegRecordsnumeric (number)164NA
datelegrecordscheckbox (boolean)168NA

email-activity

FieldTypeidchoices*
emailTotext (string)6NA
emailFromtext (string)7NA
emailCctext (string)8NA
emailBcctext (string)9NA
emailSubjecttext (string)10NA
emailSentDateunknown12NA
masterTableDbidtext (string)13NA
masterTableRecidtext (string)14NA
relatedProjectnumeric (number)15NA
configurationNametext (string)16NA
errorDetailstext (string)23NA
dateCreatedunknown1NA
dateModifiedunknown2NA
lastModifiedByuser (string)5NA
recordIdNumberrecordid, (no write)3NA
recordOwneruser (string)4NA
relatedEmailnumeric (number)20NA
relatedReservationnumeric (number)17NA
relatedDateLegnumeric (number)24NA
relatedTicketnumeric (number)28NA
relatedChargenumeric (number)35NA
openedcheckbox (boolean)42NA
openedTimestampunknown43NA
clickedcheckbox (boolean)44NA
clickedTimestampunknown45NA

partials

FieldTypeidchoices*
dateCreatedunknown1NA
amountPaidTodaycurrency (number)6NA
typeOfPaymenttext (string)8Initial Payment, Installment, Final Payment
last4OfCardUsedtext (string)24NA
approvalCodetext (string)25NA
dateModifiedunknown2NA
lastModifiedByuser (string)5NA
recordIdNumberrecordid, (no write)3NA
recordOwneruser (string)4NA
relatedReservationnumeric (number)9NA
relatedPackagenumeric (number)32NA
0.0.40

1 year ago

0.0.41

1 year ago

0.0.37

1 year ago

0.0.38

1 year ago

0.0.39

1 year ago

0.0.35

1 year ago

0.0.36

1 year ago

0.0.20

2 years ago

0.0.21

2 years ago

0.0.22

2 years ago

0.0.23

2 years ago

0.0.24

2 years ago

0.0.25

2 years ago

0.0.15

2 years ago

0.0.16

2 years ago

0.0.17

2 years ago

0.0.18

2 years ago

0.0.19

2 years ago

0.0.30

2 years ago

0.0.31

2 years ago

0.0.32

2 years ago

0.0.10

2 years ago

0.0.33

2 years ago

0.0.11

2 years ago

0.0.34

2 years ago

0.0.12

2 years ago

0.0.13

2 years ago

0.0.14

2 years ago

0.0.26

2 years ago

0.0.27

2 years ago

0.0.28

2 years ago

0.0.29

2 years ago

0.0.8

2 years ago

0.0.7

2 years ago

0.0.6

2 years ago

0.0.2

2 years ago