Page Comparison

Table filter

hideColumnsnumbering

fixedCols
totalrow	,,,
hidelabels	false
ddSeparator
sparkName	Sparkline
hidePane	Filtration panel
limitHeight	1
customNoTableMsgText
sparkline	false
macroMarker	17247873518141724787526960_15162
ddSeparators	true
default	,
isFirstTimeEnter	true
hideColumns	false
cell-width	250,250
false	totalRowName
totalColName
disabled	false
customNoTableMsg	false
globalFilter	false
formatVersion	2
iconfilter
order	0,1
hideControls	false
Dynamic Ascending	inverse	false,false
numbering	Dynamic Ascending
datefilter
column
totalcol
sort	DD Table Name ⇧,DD Column Name ⇧
totalcol	disableSave	falsetrue
rowsPerPage	10025
separator	Point (.)
labels	DD Table Name‚DD Column Name
thousandSeparator
ignoreFirstNrows
ddOperator
userfilter	DD Table Name,DD Column Name
datepattern	dd M yy
numberfilter
hideFilters
heightValue
updateSelectOptionshideFilters	true
worklog	365\|5\|8\|y w d h m\|y w d h m
updateSelectOptions	false
isOR	AND
showNRowsifNotFiltered

DD Table Name	DD Column Name	DataType	TImeZone Information
AnticipatedWorkorder	CreatedDate	datetime	No time Information. Has only Date
AnticipatedWorkorder	ScheduledDate	datetime	No time Information. Has only Date
AnticipatedWorkorder	ExpirationDate	datetime	Location Timezone
AnticipatedWorkorder	CreatedDateInDataDirect	datetime	ET
AnticipatedWorkorder	UpdatedDateInDataDirect	datetime	ET
AnticipatedWorkorder_Frequency	StartOn	datetime	No time Information. Has only Date
AnticipatedWorkorder_Frequency	StopOn	datetime	No time Information. Has only Date
AnticipatedWorkorder_Frequency	CreatedDateInDataDirect	datetime	ET
AnticipatedWorkorder_Frequency	UpdatedDateInDataDirect	datetime	ET
Asset	EffectiveStartDate	datetime	ET
Asset	EffectiveEndDate	datetime	ET
Asset	InstallDate	datetime	No time Information. Has only Date
Asset	PurchaseDate	datetime	No time Information. Has only Date
Asset	WarrantyExpirationDate	datetime	No time Information. Has only Date
Asset	DeactivatedDate	datetime	ET
Asset	AssetCreatedDate	datetime	ET
Asset	AssetModifiedDate	datetime	ET
Asset	CreatedDate	datetimeoffset	Date & Time With offset to UTC
Asset	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
Asset	CreatedDateInDataDirect	datetime	ET
Asset	UpdatedDateInDataDirect	datetime	ET
AssetCustomAttributes	CreatedDateInDataDirect	datetime	ET
AssetCustomAttributes	UpdatedDateInDataDirect	datetime	ET
AssetInfo	EffectiveStartDate	datetime	ET
AssetInfo	EffectiveEndDate	datetime	ET
AssetInfo	AssetTypeAddedAt	datetime	ET
AssetInfo	AssetTypeLastModifiedDate	datetime	ET
AssetInfo	RetiredDate	datetime	ET
AssetInfo	ManufacturedDate	datetime	ET
AssetInfo	LeaseDate	datetime	No time Information. Has only Date
AssetInfo	CreatedDate	datetimeoffset	Date & Time With offset to UTC
AssetInfo	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
AssetInfo	CreatedDateInDataDirect	datetime	ET
AssetInfo	UpdatedDateInDataDirect	datetime	ET
AssetLeakInspections	CreatedDate	datetimeoffset	Date & Time With offset to UTC
AssetLeakInspections	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
AssetLeakInspections	CreatedDateInDataDirect	datetime	ET
AssetLeakInspections	UpdatedDateInDataDirect	datetime	ET
AssetMeterReadings	MeasureDate	datetimeoffset(7)	Date & Time With offset to UTC
AssetMeterReadings	CreatedDateInDataDirect	datetime	ET
AssetMeterReadings	UpdatedDateInDataDirect	datetime	ET
AssetRefrigerantCharge	ChargeEffectiveDate	datetime	No time Information. Has only Date
AssetRefrigerantCharge	ChargeModifiedDate	datetimeoffset	Date & Time With offset to UTC
AssetRefrigerantCharge	CreatedDate	datetimeoffset	Date & Time With offset to UTC
AssetRefrigerantCharge	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
AssetRefrigerantCharge	CreatedDateInDataDirect	datetime	ET
AssetRefrigerantCharge	UpdatedDateInDataDirect	datetime	ET
AssetRefrigerantLeak	TriggerDate	datetime	No time Information. Has only Date
AssetRefrigerantLeak	RepairDate	datetime	ET
AssetRefrigerantLeak	InitialVerificationDate	datetime	ET
AssetRefrigerantLeak	FollowupDate	datetime	ET
AssetRefrigerantLeak	GeneratedDate	datetime	ET
AssetRefrigerantLeak	LeakRecordModifiedDate	datetimeoffset	Date & Time With offset to UTC
AssetRefrigerantLeak	CreatedDate	datetimeoffset	Date & Time With offset to UTC
AssetRefrigerantLeak	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
AssetRefrigerantLeak	CreatedDateInDataDirect	datetime	ET
AssetRefrigerantLeak	UpdatedDateInDataDirect	datetime	ET
AssetRefrigerantLeakImmeasurable	RepairDate	datetime	ET
AssetRefrigerantLeakImmeasurable	InitialVerificationDate	datetime	ET
AssetRefrigerantLeakImmeasurable	FollowupVerificationDate	datetime	ET
AssetRefrigerantLeakImmeasurable	CreatedDate	datetimeoffset	Date & Time With offset to UTC
AssetRefrigerantLeakImmeasurable	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
AssetRefrigerantLeakImmeasurable	CreatedDateInDataDirect	datetime	ET
AssetRefrigerantLeakImmeasurable	UpdatedDateInDataDirect	datetime	ET
AssetRefrigerantLeakImmeasurableNotes	CreatedDate	datetimeoffset	Date & Time With offset to UTC
AssetRefrigerantLeakImmeasurableNotes	CreatedDateInDataDirect	datetime	ET
AssetRefrigerantLeakImmeasurableNotes	UpdatedDateInDataDirect	datetime	ET
AssetRefrigerantLeakImmeasurableWOs	GeneratedDate	datetimeoffset	Date & Time With offset to UTC
AssetRefrigerantLeakImmeasurableWOs	CreatedDateInDataDirect	datetime	ET
AssetRefrigerantLeakImmeasurableWOs	UpdatedDateInDataDirect	datetime	ET
AssetRefrigerantLeakNotes	CreatedDate	datetimeoffset	Date & Time With offset to UTC
AssetRefrigerantLeakNotes	CreatedDateInDataDirect	datetime	ET
AssetRefrigerantLeakNotes	UpdatedDateInDataDirect	datetime	ET
AssetRefrigerantLeakWOs	CreatedDateInDataDirect	datetime	ET
AssetRefrigerantLeakWOs	UpdatedDateInDataDirect	datetime	ET
assets	InstallDate	datetime	No time Information. Has only Date
assets	PurchaseDate	datetime	No time Information. Has only Date
assets	WarrantyExpirationDate	datetime	No time Information. Has only Date
assets	DeactivatedDate	datetime	ET
assets	CreatedDateInDataDirect	datetime	ET
assets	UpdatedDateInDataDirect	datetime	ET
AssetsInWorkorders	DateAdded	datetimeoffset	Date & Time With offset to UTC
AssetsInWorkorders	CreatedDateInDataDirect	datetimeoffset	ET
AssetsInWorkorders	UpdatedDateInDataDirect	datetimeoffset	ET
AssetTypeCustomAttributes	CreatedDateInDataDirect	datetime	ET
AssetTypeCustomAttributes	UpdatedDateInDataDirect	datetime	ET
AssetValidationInfo	ValidatedDate	datetimeoffset	Date & Time With offset to UTC
AssetValidationInfo	CreatedDateInDataDirect	datetimeoffset	ET
AssetValidationInfo	UpdatedDateInDataDirect	datetimeoffset	ET
audit	CreatedDateInDataDirect	datetime	ET
audit	UpdatedDateInDataDirect	datetime	ET
audit	StartDate_DTO	datetimeoffset	Date & Time With offset to UTC
audit	FinishDate_DTO	datetimeoffset	Date & Time With offset to UTC
audit_check_list_item	CreatedDateInDataDirect	datetime	ET
audit_check_list_item	UpdatedDateInDataDirect	datetime	ET
audit_issue_attachment	CreatedDateInDataDirect	datetime	ET
audit_issue_attachment	UpdatedDateInDataDirect	datetime	ET
audit_workorder	CreatedDateInDataDirect	datetime	ET
audit_workorder	UpdatedDateInDataDirect	datetime	ET
budget	UpdatedDate	datetime	ET
budget	CreatedDateInDataDirect	datetime	ET
budget	UpdatedDateInDataDirect	datetime	ET
categories	CreatedDateInDataDirect	datetime	ET
categories	UpdatedDateInDataDirect	datetime	ET
CheckListAssetTaskResponses	StartTime	datetimeoffset	Date & Time With offset to UTC
CheckListAssetTaskResponses	EndTime	datetimeoffset	Date & Time With offset to UTC
CheckListAssetTaskResponses	CreatedDateInDataDirect	datetime	ET
CheckListAssetTaskResponses	UpdatedDateInDataDirect	datetime	ET
checklists	CreatedDate	datetime	ET
checklists	UpdatedDate	datetime	ET
checklists	ChecklistResponseUpdatedDate	datetime	ET
checklists	ChecklistUpdatedDate	datetime	ET
checklists	CreatedDateInDataDirect	datetime	ET
checklists	UpdatedDateInDataDirect	datetime	ET
CheckListTasks	CreatedDate	datetimeoffset	Date & Time With offset to UTC
CheckListTasks	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
CheckListTasks	CreatedDateInDataDirect	datetime	ET
CheckListTasks	UpdatedDateInDataDirect	datetime	ET
custom_asset_attributes	valueDate	datetime	No time Information. Has only Date
custom_asset_attributes	UpdatedDate	datetime	ET
custom_asset_attributes	CreatedDateInDataDirect	datetime	ET
custom_asset_attributes	UpdatedDateInDataDirect	datetime	ET
ftm	checkInDateTime	datetime	Location Timezone
ftm	checkOutDateTime	datetime	Location Timezone
ftm	checkInTime_dto	datetimeoffset	Date & Time With offset to UTC
ftm	checkOutTime_dto	datetimeoffset	Date & Time With offset to UTC
ftm	CreatedDateInDataDirect	datetime	ET
ftm	UpdatedDateInDataDirect	datetime	ET
InvalidInvoices	CreatedDateInDataDirect	datetime	ET
InvalidInvoices	UpdatedDateInDataDirect	datetime	ET
InvalidProposals	proposalDate	datetime	ET
InvalidProposals	CreatedDateInDataDirect	datetime	ET
InvalidProposals	UpdatedDateInDataDirect	datetime	ET
InvalidRelationships	CreatedDateInDataDirect	datetime	ET
InvalidRelationships	UpdatedDateInDataDirect	datetime	ET
InvalidWorkorders	calldate	datetime	Location Timezone
InvalidWorkorders	CreatedDateInDataDirect	datetime	ET
InvalidWorkorders	UpdatedDateInDataDirect	datetime	ET
invoiceinventory_laborcatalog	CreatedDateInDataDirectValidDate	datetime	ET
invoice_labor	UpdatedDateInDataDirect	datetime	ET
invoice_materials	CreatedDateInDataDirect	datetime	ET
invoice_materials	UpdatedDateInDataDirect	datetime	ET
invoice_statusesdatetimeoffset	Date & Time With offset to UTC
inventory_catalog	ExpireDate	datetimeoffset	Date & Time With offset to UTC
inventory_catalog	CreatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_catalog	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_catalog	CreatedDateInDataDirect	datetime	ET
inventory_catalog	UpdatedDateInDataDirect	datetime	ET
inventory_cyclecount_location_records	CreatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_cyclecount_location_records	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_cyclecount_location_records	CreatedDateInDataDirect	datetime	ET
inventory_cyclecount_location_records	UpdatedDateInDataDirect	datetime	ET
inventory_cyclecount_schedule_parts	CreatedDateInDataDirect	datetime	ET
inventory_cyclecount_schedule_parts	UpdatedDateInDataDirect	datetime	ET
inventory_cyclecount_schedule_parttypes	CreatedDateInDataDirect	datetime	ET
inventory_cyclecount_schedule_parttypes	UpdatedDateInDataDirect	datetime	ET
inventory_cyclecount_schedules	DueDate	datetimeoffset	Date & Time With offset to UTC
inventory_cyclecount_schedules	CompletionDate	datetimeoffset	Date & Time With offset to UTC
inventory_cyclecount_schedules	CreatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_cyclecount_schedules	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_cyclecount_schedules	CreatedDateInDataDirect	datetime	ET
inventory_cyclecount_schedules	UpdatedDateInDataDirect	datetime	ET
inventory_cyclecounts	CountDate	datetimeoffset	Date & Time With offset to UTC
inventory_cyclecounts	CreatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_cyclecounts	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_cyclecounts	CreatedDateInDataDirect	datetime	ET
inventory_cyclecounts	UpdatedDateInDataDirect	datetime	ET
inventory_locations	CreatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_locations	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_locations	CreatedDateInDataDirect	datetime	ET
inventory_locations	UpdatedDateInDataDirect	datetime	ET
inventory_part_purchase	CreatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_part_purchase	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_part_purchase	IssuedDate	datetimeoffset	Date & Time With offset to UTC
inventory_part_purchase	ReceivedDate	datetimeoffset	Date & Time With offset to UTC
inventory_part_purchase	CreatedDateInDataDirect	datetime	ET
inventory_part_purchase	UpdatedDateInDataDirect	datetime	ET
inventory_part_purchase_items	CreatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_part_purchase_items	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_part_purchase_items	ReceivedDate	datetimeoffset	Date & Time With offset to UTC
inventory_part_purchase_items	CreatedDateInDataDirect	datetime	ET
inventory_part_purchase_items	UpdatedDateInDataDirect	datetime	ET
inventory_part_transit	TransferDate	datetimeoffset	Date & Time With offset to UTC
inventory_part_transit	ShipDate	datetimeoffset	Date & Time With offset to UTC
inventory_part_transit	DateModified	datetimeoffset	Date & Time With offset to UTC
inventory_part_transit	CreatedDateInDataDirect	datetime	ET
inventory_part_transit	UpdatedDateInDataDirect	datetime	ET
inventory_part_transit_items	DateReceived	datetimeoffset	Date & Time With offset to UTC
inventory_part_transit_items	CreatedDateInDataDirect	datetime	ET
inventory_part_transit_items	UpdatedDateInDataDirect	datetime	ET
inventory_part_usage	CreatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_part_usage	ModifiedDate	datetimeoffset	Date & Time With offset to UTC
inventory_part_usage	CreatedDateInDataDirect	datetime	ET
inventory_part_usage	UpdatedDateInDataDirect	datetime	ET
inventory_part_usage_items	CreatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_part_usage_items	ModifiedDate	datetimeoffset	Date & Time With offset to UTC
inventory_part_usage_items	UseDate	datetimeoffset	Date & Time With offset to UTC
inventory_part_usage_items	CreatedDateInDataDirect	datetime	ET
inventory_part_usage_items	UpdatedDateInDataDirect	datetime	ET
inventory_parts	CreatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_parts	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_parts	CreatedDateInDataDirect	datetime	ET
inventory_parts	UpdatedDateInDataDirect	datetime	ET
inventory_stock	CreatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_stock	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
inventory_stock	CreatedDateInDataDirect	datetime	ET
inventory_stock	UpdatedDateInDataDirect	datetime	ET
inventory_stock_manual_change	ChangedDate	datetimeoffset	Date & Time With offset to UTC
inventory_stock_manual_change	CreatedDateInDataDirect	datetime	ET
inventory_stock_manual_change	UpdatedDateInDataDirect	datetime	ET
invoice_labor	CreatedDateInDataDirect	datetime	ET
invoice_labor	UpdatedDateInDataDirect	datetime	ET
invoice_materials	CreatedDateInDataDirect	datetime	ET
invoice_materials	UpdatedDateInDataDirect	datetime	ET
invoice_statuses	CreatedDateInDataDirect	datetime	ET
invoice_statuses	UpdatedDateInDataDirect	datetime	ET
invoices	invoiceDate	datetime	Location Timezone
invoices	postedDate	datetime	Location Timezone
invoices	TransferDate	datetime	Location Timezone
invoices	lastModifiedDate	datetime	ET
invoices	createdDate	datetime	ET
invoices	approvedDate	datetime	ET
invoices	approvedDateDto	datetimeoffset	Date & Time With offset to UTC
invoices	lastPaymentDateDto	datetimeoffset	Date & Time With offset to UTC
invoices	postedDateDto	datetimeoffset	Date & Time With offset to UTC
invoices	createdDateDto	datetimeoffset	Date & Time With offset to UTC
invoices	transferredDateDto	datetimeoffset	Date & Time With offset to UTC
invoices	CreatedDateInDataDirect	datetime	ET
invoices	UpdatedDateInDataDirect	datetime	ET
label_history	UpdatedDateDto	datetimeoffset	Date & Time With offset to UTC
label_history	CreatedDateInDataDirect	datetime	ET
label_history	UpdatedDateInDataDirect	datetime	ET
labels	CreatedDateInDataDirect	datetime	ET
labels	UpdatedDateInDataDirect	datetime	ET
LeakInspectionComplianceAcknowledgement	DateAccepted	datetimeoffset	Date & Time With offset to UTC
LeakInspectionComplianceAcknowledgement	CreatedDateInDataDirect	datetime	ET
invoice_statusesLeakInspectionComplianceAcknowledgement	UpdatedDateInDataDirect	datetime	ET
invoiceslocations	invoiceDateopenedDate	datetime	Location Timezone	invoices	postedDateNo time Information. Has only Date
locations	closedDate	datetime	Location Timezone	invoices	TransferDateNo time Information. Has only Date
locations	CreatedDateInDataDirect	datetime	Location TimezoneET
invoiceslocations	lastModifiedDateUpdatedDateInDataDirect	datetime	ETinvoices
locations_notes	createdDateCreatedDateInDataDirect	datetime	ETinvoices
locations_notes	approvedDateUpdatedDateInDataDirect	datetime	ET
invoices	approvedDateDto	datetimeoffset	Date & Time With offset to UTC
invoices	lastPaymentDateDto	datetimeoffset	Date & Time With offset to UTC
invoices	postedDateDtolocations_notes_headers	CreatedDateInDataDirect	datetime	ET
locations_notes_headers	UpdatedDateInDataDirect	datetime	ET
Materials	UseDate	datetimeoffset	Date & Time With offset to UTC
invoicesMaterials	createdDateDtoScMatCreatedDate	datetimeoffset	Date & Time With offset to UTC
invoicesMaterials	transferredDateDtoScMatUpdatedDate	datetimeoffset	Date & Time With offset to UTC
invoices	CreatedDateInDataDirect	datetime	ET
invoices	UpdatedDateInDataDirect	datetime	ET
label_history	UpdatedDateDto
Materials	CreatedDate	datetimeoffset	Date & Time With offset to UTC
label_historyMaterials	CreatedDateInDataDirectUpdatedDate	datetime	ET	label_history	UpdatedDateInDataDirectdatetimeoffset	Date & Time With offset to UTC
Materials	WoCallDate	datetimeET	Location Timezone
labels	CreatedDateInDataDirect	datetime	ET
labels	UpdatedDateInDataDirect	datetime	ET
LeakInspectionComplianceAcknowledgement	DateAccepted	Materials	WoCallDate_dto	datetimeoffset	Date & Time With offset to UTC
LeakInspectionComplianceAcknowledgementMaterials	CreatedDateInDataDirect	datetime	ET
LeakInspectionComplianceAcknowledgementMaterials	UpdatedDateInDataDirect	datetime	ETlocations
notes_statistics	openedDatenoteDate	datetime	No time Information. Has only Date
locationsnotes_statistics	closedDatefirstNoteDateTime	datetime	No time Information. Has only Date	locationsET
notes_statistics	lastNoteDatetime	datetime	ET
notes_statistics	CreatedDateInDataDirect	datetime	ETlocations
notes_statistics	UpdatedDateInDataDirect	datetime	ETlocations_notes
PartUsageAudit	CreatedDate	datetimeoffset	Date & Time With offset to UTC
PartUsageAudit	CreatedDateInDataDirect	datetime	ET
locations_notesPartUsageAudit	UpdatedDateInDataDirect	datetime	ET
locationspilot_notesprovider_headerscontracts	CreatedDateInDataDirectsince	datetime	ET
locationspilot_notesprovider_headerscontracts	UpdatedDateInDataDirectstart_date	datetime	ET
Materials	UseDate	datetimeoffset	Date & Time With offset to UTC
Materials	ScMatCreatedDatepilot_provider_contracts	expire_date	datetime	ET
pilot_provider_contracts	CreatedDate	datetimeoffset	Date & Time With offset to UTC	Materials
ScMatUpdatedDatepilot_provider_contracts	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
Materials	CreatedDate	datetimeoffset	Date & Time With offset to UTC
Materials	UpdatedDate
pilot_provider_contracts	CreatedDateInDataDirect	datetime	ET
pilot_provider_contracts	UpdatedDateInDataDirect	datetime	ET
pilot_provider_emails	CreatedDate	datetimeoffset	Date & Time With offset to UTC
Materials	WoCallDate	datetime	Location Timezone
Materials	WoCallDate_dto	pilot_provider_emails	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
Materialspilot_provider_emails	CreatedDateInDataDirect	datetime	ETMaterials
pilot_provider_emails	UpdatedDateInDataDirect	datetime	ET
notespilot_provider_statisticsworkorders	noteDateCreatedDate	datetime	No time Information. Has only Date
notes_statistics	firstNoteDateTime	datetime	ET
notes_statistics	lastNoteDatetimedatetimeoffset	Date & Time With offset to UTC
pilot_provider_workorders	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
pilot_provider_workorders	CreatedDateInDataDirect	datetime	ET
notespilot_provider_statisticsworkorders	CreatedDateInDataDirectUpdatedDateInDataDirect	datetime	ET
notespilot_statisticsproviders	UpdatedDateInDataDirectCreatedDate	datetime	ET	PartUsageAudit	CreatedDatedatetimeoffset	Date & Time With offset to UTC
pilot_providers	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
PartUsageAuditpilot_providers	CreatedDateInDataDirect	datetime	ETPartUsageAudit
pilot_providers	UpdatedDateInDataDirect	datetime	ET
priorities	CreatedDateInDataDirect	datetime	ET
priorities	UpdatedDateInDataDirect	datetime	ET
Program	StartDate	datetimeoffset	Date & Time With offset to UTC
Program	EndDate	datetimeoffset	Date & Time With offset to UTC
Program	CreatedOn	datetimeoffset	Date & Time With offset to UTC
Program	LastUpdatedOn	datetimeoffset	Date & Time With offset to UTC
Program	CreatedDateInDataDirect	datetime	ET
Program	UpdatedDateInDataDirect	datetime	ET
Project	CreatedOn	datetimeoffset	Date & Time With offset to UTC
Project	LastUpdatedOn	datetimeoffset	Date & Time With offset to UTC
Project	CreatedDateInDataDirect	datetime	ET
Project	UpdatedDateInDataDirect	datetime	ET
project_tasks_rfps	StartDate	datetimeoffset	Date & Time With offset to UTC
project_tasks_rfps	DueDate	datetimeoffset	Date & Time With offset to UTC
project_tasks_rfps	AssignedOn	datetimeoffset	Date & Time With offset to UTC
project_tasks_rfps	CreatedOn	datetimeoffset	Date & Time With offset to UTC
project_tasks_rfps	LastUpdatedOn	datetimeoffset	Date & Time With offset to UTC
project_tasks_rfps	IssuedOn	datetimeoffset	Date & Time With offset to UTC
project_tasks_rfps	CreatedDateInDataDirect	datetime	ET
project_tasks_rfps	UpdatedDateInDataDirect	datetime	ET
project_tasks_workorders	CallDate	datetimeoffset	Date & Time With offset to UTC
project_tasks_workorders	CreatedOn	datetimeoffset	Date & Time With offset to UTC
project_tasks_workorders	LastUpdatedOn	datetimeoffset	Date & Time With offset to UTC
project_tasks_workorders	IssuedOn	datetimeoffset	Date & Time With offset to UTC
project_tasks_workorders	CreatedDateInDataDirect	datetime	ET
project_tasks_workorders	UpdatedDateInDataDirect	datetime	ET
proposal_line_items	CreatedDateInDataDirect	datetime	ET
proposal_line_items	UpdatedDateInDataDirect	datetime	ET
proposal_status_history	createdDate	datetime	Location Timezone
proposal_status_history	ApprovedDate	datetime	Location Timezone
proposal_status_history	OnHoldDate	datetime	Location Timezone
proposal_status_history	RejectedDate	datetime	Location Timezone
proposal_status_history	VoidDate	datetime	Location Timezone
proposal_status_history	OpenDate	datetime	Location Timezone
proposal_status_history	AssignedDate	datetime	Location Timezone
proposal_status_history	ScheduledDate	datetime	Location Timezone
proposal_status_history	CreatedDateInDataDirect	datetime	ET
proposal_status_history	UpdatedDateInDataDirect	datetime	ET
proposal_statuses	CreatedDateInDataDirect	datetime	ET
proposal_statuses	UpdatedDateInDataDirect	datetime	ET
proposals	proposalDate	datetime	ET
proposals	approvedDate	datetime	UTC
proposals	lastModifiedDate	datetime	UTC
proposals	rejectedDate	datetime	UTC
proposals	onHoldDate	datetime	UTC
proposals	requestedDate	datetime	Location Timezone
proposals	createdDate	datetime	ET
proposals	CreatedDateInDataDirect	datetime	ET
proposals	UpdatedDateInDataDirect	datetime	ET
provider_communications	CreatedDateInDataDirect	datetime	ET
provider_communications	UpdatedDateInDataDirect	datetime	ET
provider_users	createdDate	datetime	ET
provider_users	updatedDate	datetime	ET
provider_users	CreatedDateInDataDirect	datetime	ET
provider_users	UpdatedDateInDataDirect	datetime	ET
providers	CreatedDateInDataDirect	datetime	ET
providers	UpdatedDateInDataDirect	datetime	ET
raw_proposals	proposalDate	datetime	ET
raw_proposals	approvedDate	datetime	UTC
raw_proposals	lastModifiedDate	datetime	UTC
raw_proposals	rejectedDate	datetime	UTC
raw_proposals	onHoldDate	datetime	UTC
raw_proposals	createdDate	datetime	ET
raw_workorders	calldate	datetime	Location Timezone
raw_workorders	completiondate	datetime	Location Timezone
raw_workorders	scheduledDate	datetime	Location Timezone
raw_workorders	reassigneddate	datetime	Location Timezone
raw_workorders	assignedDate	datetime	ET
raw_workorders	ProjectedCompletionDate	datetimeoffset	Location Timezone
raw_workorders	lastModifiedDate	datetime	ET
raw_workorders	createdDate	datetime	ET
real_estate	CallDate	datetime	Location Timezone
real_estate	WorkDate	datetime	Location Timezone
real_estate	InvoiceDate	datetime	Location Timezone
real_estate	InvoiceApprovedDate	datetime	ET
real_estate	SpendDate	datetime	Location Timezone
real_estate	UpdatedDate	datetime	ET
real_estate	CreatedDateInDataDirect	datetime	ET
real_estate	UpdatedDateInDataDirect	datetime	ET
RefreshStatus	CompletedDate	datetime	ET
RefrigerantCertificationActionLogs	CreatedDateDto	datetimeoffset	Date & Time With offset to UTC
RefrigerantCertificationActionLogs	UpdatedDateDto	datetimeoffset	Date & Time With offset to UTC
RefrigerantCertificationActionLogs	CreatedDateInDataDirect	datetime	ET
RefrigerantCertificationActionLogs	UpdatedDateInDataDirect	datetime	ET
RefrigerantCertificationActionTypes	CreatedDateDto	datetimeoffset	Date & Time With offset to UTC
RefrigerantCertificationActionTypes	UpdatedDateDto	datetimeoffset	Date & Time With offset to UTC
RefrigerantCertificationActionTypes	CreatedDateInDataDirect	datetime	ET
RefrigerantCertificationActionTypes	UpdatedDateInDataDirect	datetime	ET
RefrigerantTypes	CreatedDate	datetimeoffset	Date & Time With offset to UTC
RefrigerantTypes	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
RefrigerantTypes	CreatedDateInDataDirect	datetime	ET
RefrigerantTypes	UpdatedDateInDataDirect	datetime	ET
relationships	createdDate	datetime	ET
relationships	updatedDate	datetime	ET
relationships	CreatedDateInDataDirect	datetime	ET
relationships	UpdatedDateInDataDirect	datetime	ET
resolution_codes	createdDateDto	datetimeoffset	Date & Time With offset to UTC
resolution_codes	CreatedDateInDataDirect	datetime	ET
resolution_codes	UpdatedDateInDataDirect	datetime	ET
resolutions	lastModifiedDate	datetime	ET
resolutions	CreatedDateInDataDirect	datetime	ET
resolutions	UpdatedDateInDataDirect	datetime	ET
rfp	rfpDate	datetime	Location Timezone
rfp	created	datetime	ET
rfp	dueDate	datetime	Location Timezone
rfp	responseDate	datetime	Location Timezone
rfp	lastModifiedDate	datetime	ET
rfp	deletedDate	datetime	ET
rfp	CreatedDateInDataDirect	datetime	ET
rfp	UpdatedDateInDataDirect	datetime	ET
root_causes	CreatedDateInDataDirect	datetime	ET
root_causes	UpdatedDateInDataDirect	datetime	ET
spend	CallDate	datetime	Location Timezone
spend	WorkDate	datetime	Location Timezone
spend	ScheduledDate	datetime	Location Timezone
spend	SpendDate	datetime	Location Timezone
spend	UpdatedDate	datetime	ET
spend	CreatedDateInDataDirect	datetime	ET
spend	UpdatedDateInDataDirect	datetime	ET
StarRatings	CreatedDate	datetimeoffset	Date & Time With offset to UTC
StarRatings	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
StarRatings	CreatedDateInDataDirect	datetimeoffset	ET
StarRatings	UpdatedDateInDataDirect	datetimeoffset	ET
statuses	CreatedDateInDataDirect	datetime	ET
statuses	UpdatedDateInDataDirect	datetime	ET
technician_assigned_accepted	UpdatedTechnicianDateUtc	datetime	ET
technician_assigned_accepted	UpdatedTechnicianDateDto	datetimeoffset	Date & Time With offset to UTC
technician_assigned_accepted	CreatedDateInDataDirect	datetime	ET
technician_assigned_accepted	UpdatedDateInDataDirect	datetime	ET
technician_assigned_accepted	WOAssignmentDateDto	datetimeoffset	Date & Time With offset to UTC
technician_availability_log	unavailableUntilDate	datetime	ET
technician_availability_log	createdDate	datetime	ET
technician_availability_log	unavailableUntilDateDto	datetimeoffset	Date & Time With offset to UTC
technician_availability_log	createdDateDto	datetimeoffset	Date & Time With offset to UTC
technician_availability_log	CreatedDateInDataDirect	datetime	ET
technician_availability_log	UpdatedDateInDataDirect	datetime	ET
technician_time_tracking	startDate	datetime	Location Timezone
technician_time_tracking	endDate	datetime	Location Timezone
technician_time_tracking	startDateTime_dto	datetimeoffset	Date & Time With offset to UTC
technician_time_tracking	endDateTime_dto	datetimeoffset	Date & Time With offset to UTC
technician_time_tracking	CreatedDateInDataDirect	datetime	ET
technician_time_tracking	UpdatedDateInDataDirect	datetime	ET
technician_time_tracking_combined	startDateTime	datetime	Location Timezone
technician_time_tracking_combined	endDateTime	datetime	Location Timezone
technician_time_tracking_combined	startDateTime_dto	datetimeoffset	Date & Time With offset to UTC
technician_time_tracking_combined	endDateTime_dto	datetimeoffset	Date & Time With offset to UTC
technician_time_tracking_combined	CreatedDateInDataDirect	datetime	ET
technician_time_tracking_combined	UpdatedDateInDataDirect	datetime	ET
technician_time_tracking_history	OriginalStartTimeUtc	datetime	UTC
technician_time_tracking_history	OriginalEndTimeUtc	datetime	UTC
technician_time_tracking_history	NewStartTimeUtc	datetime	UTC
technician_time_tracking_history	NewEndTimeUtc	datetime	UTC
technician_time_tracking_history	LogTimeUtc	datetime	UTC
technician_time_tracking_history	OriginalStartTimeDto	datetimeoffset	Date & Time With offset to UTC
technician_time_tracking_history	OriginalEndTimeDto	datetimeoffset	Date & Time With offset to UTC
technician_time_tracking_history	NewStartTimeDto	datetimeoffset	Date & Time With offset to UTC
technician_time_tracking_history	NewEndTimeDto	datetimeoffset	Date & Time With offset to UTC
technician_time_tracking_history	LogTimeDto	datetimeoffset	Date & Time With offset to UTC
technician_time_tracking_history	CreatedDateInDataDirect	datetime	ET
technician_time_tracking_history	UpdatedDateInDataDirect	datetime	ET
TechnicianRefrigerantCertificationFiles	CreatedDateInDataDirect	datetimeoffset	ET
TechnicianRefrigerantCertificationFiles	UpdatedDateInDataDirect	datetimeoffset	ET
TechnicianRefrigerantCertifications	CertificationExpirationDate	datetimeoffset	Date & Time With offset to UTC
TechnicianRefrigerantCertifications	CreatedDateInDataDirect	datetimeoffset	ET
TechnicianRefrigerantCertifications	UpdatedDateInDataDirect	datetimeoffset	ET
time_zone_info	CreatedDateInDataDirect	datetime	ET
time_zone_info	UpdatedDateInDataDirect	datetime	ET
trades	CreatedDateInDataDirect	datetime	ET
trades	UpdatedDateInDataDirect	datetime	ET
users	createdDate	datetime	ET
users	updatedDate	datetime	ET
users	CreatedDateInDataDirect	datetime	ET
users	UpdatedDateInDataDirect	datetime	ET
vendors	CreatedDateInDataDirect	datetime	ET
vendors	UpdatedDateInDataDirect	datetime	ET
wo_amount_breakdown	lastModifiedDate	datetime	ET
wo_amount_breakdown	CreatedDateInDataDirect	datetime	ET
wo_amount_breakdown	UpdatedDateInDataDirect	datetime	ET
wo_history_amount_change	datecreated	datetime	ET
wo_history_amount_breakdownUpdatedDateInDataDirectchange	CreatedDateInDataDirect	datetime	ET
wo_history_amount_change	UpdatedDateInDataDirect	datetime	ET
wo_history_change_category	CreatedDate	datetime	ET
wo_history_change_category	CreatedDateInDataDirect	datetime	ET
wo_history_amountchange_changecategory	datecreatedUpdatedDateInDataDirect	datetime	ET
wo_history_change_amountestimated_completion_changedate	CreatedDateInDataDirectOldEstimatedCompletionDate	datetime	ETdatetimeoffset	Date & Time With offset to UTC
wo_history_change_amountestimated_completion_changedate	UpdatedDateInDataDirectNewEstimatedCompletionDate	datetime	ETdatetimeoffset	Date & Time With offset to UTC
wo_history_change_estimated_categorycompletion_date	CreatedDateUpdatedDate	datetime	ETdatetimeoffset	Date & Time With offset to UTC
wo_history_change_categoryestimated_completion_date	CreatedDateInDataDirect	datetime	ET
wo_history_change_categoryestimated_completion_date	UpdatedDateInDataDirect	datetime	ET
wo_history_change_nte	createdDate	datetime	ET
wo_history_change_nte	CreatedDateInDataDirect	datetime	ET
wo_history_change_nte	UpdatedDateInDataDirect	datetime	ET
wo_history_change_priority	UpdatedDate	datetime	ET
wo_history_change_priority	CreatedDateInDataDirect	datetime	ET
wo_history_change_priority	UpdatedDateInDataDirect	datetime	ET
wo_history_change_problem	UpdatedDate	datetime	ET
wo_history_change_problem	CreatedDateInDataDirect	datetime	ET
wo_history_change_problem	UpdatedDateInDataDirect	datetime	ET
wo_history_change_provider	CreatedDate	datetime	ET
wo_history_change_provider	CreatedDate_dto	datetimeoffset	Date & Time With offset to UTC
wo_history_change_provider	CreatedDateInDataDirect	datetime	ET
wo_history_change_provider	UpdatedDateInDataDirect	datetime	ET
wo_history_change_scheduled_date	oldScheduledDate	datetime	Location Timezone
wo_history_change_scheduled_date	newScheduledDate	datetime	Location Timezone
wo_history_change_scheduled_date	updatedDate	datetime	ET
wo_history_change_scheduled_date	CreatedDateInDataDirect	datetime	ET
wo_history_change_scheduled_date	UpdatedDateInDataDirect	datetime	ET
wo_history_change_status	updatedDate	datetime	ET
wo_history_change_status	updatedDateDto	datetimeoffset	Date & Time With offset to UTC
wo_history_change_status	CreatedDateInDataDirect	datetime	ET
wo_history_change_status	UpdatedDateInDataDirect	datetime	ET
wo_history_change_trade	UpdatedDate	datetime	ET
wo_history_change_trade	CreatedDateInDataDirect	datetime	ET
wo_history_change_trade	UpdatedDateInDataDirect	datetime	ET
workorder_additional_approval_codes	SrcCreatedDate	datetime	ET
workorder_additional_approval_codes	CreatedDateInDataDirect	datetime	ET
workorder_additional_approval_codes	UpdatedDateInDataDirect	datetime	ET
workorder_attachment_info	UploadDate	datetimeoffset	Date & Time With offset to UTC
workorder_attachment_info	CreatedDateInDataDirect	datetime	ET
workorder_attachment_info	UpdatedDateInDataDirect	datetime	ET
workorder_ivr	ivrTime	datetime	Location Timezone
workorder_ivr	lastModifiedDate	datetime	ET
workorder_ivr	CreatedDateInDataDirect	datetime	ET
workorder_ivr	UpdatedDateInDataDirect	datetime	ET
workorder_labor_performed	WorkDate	datetime	No time Information. Has only Date
workorder_labor_performed	checkInTime	datetime	Location Timezone
workorder_labor_performed	checkOutTime	datetime	Location Timezone
workorder_labor_performed	CreatedDate	datetime	ET
workorder_labor_performed	UpdatedDate	datetime	ET
workorder_labor_performed	checkInTime_dto	datetimeoffset	Date & Time With offset to UTC
workorder_labor_performed	checkOutTime_dto	datetimeoffset	Date & Time With offset to UTC
workorder_labor_performed	CreatedDate_dto	datetimeoffset	Date & Time With offset to UTC
workorder_labor_performed	UpdatedDate_dto	datetimeoffset	Date & Time With offset to UTC
workorder_labor_performed	CreatedDateInDataDirect	datetime	ET
workorder_labor_performed	UpdatedDateInDataDirect	datetime	ET
workorder_mechanic	ivrTime	datetime	Location Timezone
workorder_mechanic	lastModifiedDate	datetime	ET
workorder_mechanic	CreatedDateInDataDirect	datetime	ET
workorder_mechanic	UpdatedDateInDataDirect	datetime	ET
workorder_notes	CreatedDate	datetime	ET
workorder_notes	Date_Created_dto	datetimeoffset	Date & Time With offset to UTC
workorder_notes	CreatedDateInDataDirect	datetime	ET
workorder_notes	UpdatedDateInDataDirect	datetime	ET
workorder_notes	ActionRequiredResolvedDate	datetimeoffset	Date & Time With offset to UTC
workorder_notes_new	CreatedDate	datetime	ET
workorder_notes_new	Date_Created_dto	datetimeoffset	Date & Time With offset to UTC
workorder_notes_new	CreatedDateInDataDirect	datetime	ET
workorder_notes_new	UpdatedDateInDataDirect	datetime	ET
workorder_notes_new	ActionRequiredResolvedDate	datetimeoffset	Date & Time With offset to UTC
workorder_quality_survey	createdDate	datetime	ET
workorder_quality_survey	CreatedDateInDataDirect	datetime	ET
workorder_quality_survey	UpdatedDateInDataDirect	datetime	ET
workorder_reassignment_reasons	actionTimeStamp	datetime	ET
workorder_reassignment_reasons	actionTimeStamp_dto	datetimeoffset	Date & Time With offset to UTC
workorder_reassignment_reasons	CreatedDateInDataDirect	datetime	ET
workorder_reassignment_reasons	UpdatedDateInDataDirect	datetime	ET
workorders	calldate	datetime	Location Timezone
workorders	completiondate	datetime	Location Timezone
workorders	scheduledDate	datetime	Location Timezone
workorders	reassigneddate	datetime	Location Timezone
workorders	assignedDate	datetime	ET
workorders	ProjectedCompletionDate	datetimeoffset	Location Timezone
workorders	lastModifiedDate	datetime	ET
workorders	createdDate	datetime	ET
workorders	CreatedDateInDataDirect	datetime	ET
workorders	UpdatedDateInDataDirect	datetime	ET
workorders_ext	eta	datetime	Location Timezone
workorders_ext	originalEta	datetime	Location Timezone
workorders_ext	postedDate	datetime	Location Timezone
workorders_ext	poLoadFlagDate	datetime	Location Timezone
workorders_ext	CreatedDateInDataDirect	datetime	ET
workorders_ext	UpdatedDateInDataDirect	datetime	ET
workorders_linked	dateCreated	datetime	ET
workorders_linked	CreatedDateInDataDirect	datetime	ET
workorders_linked	UpdatedDateInDataDirect	datetime	ET
workorders_pm_compliance	ValidFromDate	datetimeoffset	Date & Time With offset to UTC
workorders_pm_compliance	ValidToDate	datetimeoffset	Date & Time With offset to UTC
workorders_pm_compliance	UpdatedDate	datetimeoffset	Date & Time With offset to UTC
workorders_pm_compliance	CreatedDateInDataDirect	datetime	ET
workorders_pm_compliance	UpdatedDateInDataDirect	datetime	ET

Versions Compared

Old Version 11

New Version Current

Key