npm package: @rofer/crm-sdk
Description: ## Ratonale
Latest version: 0.0.41

# 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 

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