Event & Rental Management: Comprehensive Field Name Reference Guide

Whether you are designing a custom reporting dashboard, setting up an API integration, or auditing your CRM database, having a clear understanding of your data schema is critical. This reference article organizes and categorizes 270+ system field names typically utilized within event management and inventory rental software ecosystems.

1. Core Lead Details & Lifecycle Status

These fields capture the foundational metadata of a sales opportunity or booking request (the "Lead") and track its progression through your pipeline.

Lead ID / Lead Type
Lead Flag / Lead Saved as Copy
Lead Status / Lead Previous Status / Lead Status Change Date/Time
Lead Create Date/Time / Lead Create Date / Lead Create Hour / Lead Creator
Lead Modify Date/Time / Lead Rentals Conflict
Lead Book Date / Lead Contract Sent Date / Lead Contract Received Date / Contract Signed
PO Sent / PO Sent Date / PO Signed / Date PO Signed
Lead Quote Page ID / Lead Number of Guests / Lead Customer Request Flag * Lead Loading Status / Shared Inventory Lead / Current Time

2. Customer & Contact Information

This section handles individual customer data, CRM tracking metrics, organizational hierarchies, and compliance details.

Contact Identification & Demographics

Contact ID / Contact Title / Contact Customer Type / Contact Repeat Customer
Contact First Name / Contact Last Name / Contact Full Name
Contact Organization / Organization All Contacts / Contact Notes
Contact Address 1 / Contact Address 2 / Contact City / Contact State / Contact Zip / Contact Country

Communication Channels & Preferences

Contact Home Phone / Contact Home Phone CC
Contact Office Phone / Contact Office Phone CC
Contact Cell Phone / Contact Cell Phone CC / Contact Phone Number
Contact Fax / Contact Email / Marketing Consent / Contact Blacklisted

CRM Tracking & Activity

Contact Tag Name / Contact Tag Create Date/Time / Tag Creation Time
Contact Location Name / Contact Location ID / Contact Score
Contact Create Date/Time / Contact Create Date / Contact Modified Date/Time
Contact Next Event Date/Time / Primary Contact Next Event Date/Time
Contact Last Activity Date/Time / Contact Last Sales Contact Date/Time / Contact Last Contact Time / Contact Last Activity Time

3. Rental Inventory & Line Items

These tracking elements monitor active rental assets, configurations, item specifications, and warehouse logistics.

| Item Specifications | Operational Logistics | Tracking & Status |

| Rentals ID / Name | Rentals Qty (rented) | Rentals Active / Is Active|

| Rentals Category (Primary)| Rentals Quantity (max) | Lead Rentals Count |

| Rentals Description | Rentals Qty Increment | Lead Rentals Item Count |

| Rentals Weight | Rentals Warehouse Location| Rentals Serial # |

| Rentals Dimensions | Lead Total Rental Weight | Rentals Inspection List |

| Rentals Footprint | Rentals Packing List | Rental Last Rented Date |

| Rentals Tent Length / Width| Rentals Recovery Hours | Rental Next Rented Date |

| Rentals Circuits / Ties | Rentals Operator Instruct.| Rentals Is Option |

| Rentals Tie Weight | Rentals Contract Details | Rentals Is Package |

Lead Rental ID / Lead Rental Names / Rental Price / Rentals Notes

4. Scheduling, Hours & Logistics Temporal Data

A granular look at time-based fields calculated to manage durations, check constraints, and isolate operations by days, weeks, weekends, or months.

Core Timestamps & Durations

Lead Start Date/Time / Lead Start Date / Lead Start Time / Lead Start Hour
Lead End Date/Time / Lead End Date / Lead End Time / Lead End Hour
Rentals Start Date/Time / Rentals End Date/Time / Rentals Reserved Time
Lead Duration / Lead Number Of Nights / Lead Number Of Days
Lead Delivery Date / Lead Return Date / Lead Delivery Window Duration / Lead Return Window Duration
Lead Travel Duration / Lead Time Change Date/Time

Calendar Mapping Attributes

Lead Start Year / Lead Start Month / Lead Start Year-Month / Lead Start Year-Month-Day / Lead Start Year-Week (Mon-Sun)
Lead End Year / Lead End Month / Lead End Year-Month / Lead End Year-Month-Day
Lead Create Year-Week (Mon-Sun) / Lead Start Day Of Week / Lead End Day Of Week / Lead Start Day of Month

Weekday vs. Weekend Classifications

Lead Start Is Weekend (Sat - Sun) / Lead End Is Weekend (Sat - Sun)
Lead Start Is Weekday (Mon - Fri) / Lead End Is Weekday (Mon - Fri)
Lead Start Is Weekday (Mon - Thur) / Lead End Is Weekday (Mon - Thur)
Lead Start Is Weekend (Fri - Sun) / Lead End Is Weekend (Fri - Sun)
Lead Start Is Weekend (Sat - Mon) / Lead End Is Weekend (Sat - Mon)
Lead Start Is Weekend (Fri - Mon) / Lead End Is Weekend (Fri - Mon)

5. Setup & Teardown Windows

Crucial for labor management and dispatching, these fields explicitly outline when delivery crews have structural access to venue footprints.

Lead Setup Start Date/Time / Lead Setup End Date/Time / Lead Setup Start Date / Lead Setup End Date / Lead Setup Start Time / Lead Setup End Time / Lead Setup Duration / Lead Setup Start Day
Lead Teardown Start Date/Time / Lead Teardown End Date/Time / Lead Teardown Start Date / Lead Teardown End Date / Lead Teardown Start Time / Lead Teardown End Time / Lead Teardown Duration / Lead Teardown Start Day
Lead Setup Window Start Date/Time / Lead Setup Window Start Date / Lead Setup Window Start Time
Lead Setup Window End Date/Time / Lead Setup Window End Date / Lead Setup Window End Time
Lead Teardown Window Start Date/Time / Lead Teardown Window Start Date / Lead Teardown Window Start Time
Lead Teardown Window End Date/Time / Lead Teardown Window End Date / Lead Teardown Window End Time
Lead Setup Less Than Recommended

6. Event Venue & Location Mapping

Geographic and property specific metrics defining where inventory will be dropped off and installed.

Lead Event Name / Lead Location / Lead Delivery Type / Lead Surface / Lead Number Vehicles
Lead Venue Name / Lead Venue Contact / Lead Venue Notes
Venue ID / Venue Location ID / Venue Street / Venue Address2 / Venue County / Venue City / Venue State / Venue Zip / Venue Country / Venue Notes

7. Financials, Taxes & Payments

A robust transactional subset handling currency calculations, tax liabilities, fee additions, and internal profitability monitoring.

Totals, Discounts & Yield

Lead $Rental Total / Lead$ Total / Payment Amount
Lead $Paid / Lead$ Balance Due / Lead Deposit is Paid / Lead Profit
Lead $All Discounts / Lead Rentals$ Discount / Lead $ Auto Discounts

Taxes, Fees & Adjustments

Lead Tax Rate / Lead Rental Taxable / Rentals Taxable
Lead Tax Exempt / Lead Tax Exempt ID / Contact Tax Exempt ID
Lead $ Fees / Lead Fee Name / Lead Fee Price / Lead Fee Change Date/Time
Lead $Staff / Lead$ Distance

Transaction Processing Logs

Payment Date/Time / Payment Date / Payment Time / Payment Transaction # * Payment Method / Payment Type / Payment Source / Payment Status / Payment Ref ID / Has CC On File

8. Staffing, Shifts & Workers

Internal resource components mapping schedules, internal roles, wage parameters, and fulfillment accountability.

Staff / Lead Staff Recommended / Lead Volunteers / Rentals Staff / Rentals Volunteer / Rentals Setup Staff
Lead Sales Rep ID / Lead Sales Rep Name / Organization Sales Rep ID / Organization Sales Rep Name
Shift ID / Shift Create Date/Time / Shift Modified Date/Time / Shift Was Modified / Shift Notes
Shift Worker First Name / Shift Worker Last Name / Shift Start Date/Time / Shift End Date/Time / Shift Worker Response
Worker ID / Worker Username / Worker Position / Worker Rank / Worker Approved
Worker First Name / Worker Last Name / Worker Full Name / Worker Email
Worker Address / Worker City / Worker State / Worker Zip / Worker Country
Worker Home Phone / Worker Office Phone / Worker Cell Phone / Worker Notes
Worker Pay Rate / Rentals Contractor Pay / Worker Commission Percentage / Worker Mileage Rate

9. Vendors & Third-Party Management

Used when outsourcing assets or labor, these parameters detail logistical loops involving external suppliers.

Vendor Company Name / Vendor Contact / Vendor Category / Vendor Notes
Vendor Email Address / Vendor Office Phone Number / Vendor Cell Phone Number
Vendor Address 1 / Vendor Address 2 / Vendor City / Vendor State / Vendor Zip / Vendor Location Name
Rental Vendor ID / Rental Vendor Available / Vendor Markup %

10. Marketing, Referral & Tracking Data

Attribution frameworks indicating exactly how a customer found your system, matching digital ad identifiers directly to hard revenue.

Digital Attribution Summary

Lead Referral / Customer Referral / Lead / Customer Referral
Lead Adwords Click ID (Google PPC Tracking)
Lead Facebook Click ID (Meta Paid Social Tracking)
Leads UTM Source (Originating Platform, e.g., Newsletter, Google)
Leads UTM Medium (Marketing Element, e.g., CPC, Organic)
Leads UTM Campaign (Targeted Initiative Name)

11. Tasks, Journals & Communications Logs

Internal workflow registries that make sure automated emails, system actions, or human tasks do not drop through the cracks.

Tasks & Reminders

Task ID / Task Status / Task Link To / Task Description
Task Assigned To / Task Reminder Date/Time

Customer Touchpoint Logs

Email Log Sender / Email Log Email Address / Email Log Template Name / Custom Email Title
Email Log Sent Date/Time / Email Log Open Date/Time / Email Log Click Date/Time
Journal Link To / Journal Note / Journal Status / Journal Assigned To
Attachment Filename / Survey Name

Alternate Onsite Contacts

Lead Notes / Lead Additional Notes 1 / Lead Additional Notes 2
Lead Onsite Contact Name / Lead Onsite Contact Cell Phone
Lead Additional Contact Name / Lead Additional Contact Cell Phone

12. Environmental, System & Weather Conditions

External dynamic conditions and synchronization parameters tied to the execution framework of operations.

Weather: Min Temp (F) / Weather: Max Temp (F)
Weather: Max Wind (MPH) / Weather: Gust Wind (MPH)
Weather: Chance of Rain (%) / Weather: Total Precip (in)
Page Group Name / Page Group Name (for URLs)
QuickBooks Update Time

Settings - Filter Field Names