Construction Job Site Rentals

Overview

Ticket Works is for BP Works equipment rentals orders and tracks machinery rentals such as lifts, booms, lulls and other relevant equipment used in the general construction and residential/commercial roofing. Length of the rental and associated costs/pricing is determined by how long a piece of equipment is used at a job site by the customer.

Data Information	Value
Refresh Cadence	`Monthly`
Historical Coverage	`2018`-`Present`
Geographic Coverage	`United States`, `Canada`

Schema

Name	Description
CUSTOMER_WORKS_CUSTOMER_ID	Internal customer designator
BP_PO_NUMBER	Internal purchase order number
RENTAL_START_DATE	Date of rental start
CALL_OFF_DATE	Date of rental completion
CREATED_DATE	Date when ticket is created
DAILY_RATE_CUSTOMER	Customer charge for day rate
WEEKLY_RATE_CUSTOMER	Customer charge for weekly rate
MONTHLY_RATE_CUSTOMER	Customer charge for monthly rate
PRODUCT_DESCRIPTION_WORKS_LIST_OF_PRODUCT_DESCRIPTION_WORKS_ID	Internal rental equipment designator
PRODUCT_DESC	Description of rental equipment
RENTAL_FREQUENCY	Length of time for rental
PICKUP_CUSTOMER	Customer pickup fee
DELIVERY_CUSTOMER	Customer delivery fee
DELIVERY_DATE	Date of rental delivery
DELIVERY_TIME	Time of day for rental delivery
PASS_FUEL	Additional fuel charge for usage
JOB_TYPE_DESC	Type of service being used
JOB_NUMBER	Internal Job identifier
JOB_SITE_CITY	City of job site
JOB_SITE_STATE	State of job site
JOB_SITE_ZIP	Postal code of job site
JOB_SITE_COUNTY	County of job site
CUSTOMER_CITY	Customer city location
CUSTOMER_ZIP	Customer postal code location