...
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
...
| Table filter |
|---|
| fixedCols | |
|---|
| totalrow | ,,, |
|---|
| hidelabels | false |
|---|
| ddSeparator | |
|---|
| sparkName | Sparkline |
|---|
| hidePane | Filtration panel |
|---|
| limitHeight | 1 |
|---|
| customNoTableMsgText | |
|---|
| sparkline | false |
|---|
| macroMarker | 1724787526960_62 |
|---|
| ddSeparators | true |
|---|
| default | , |
|---|
| isFirstTimeEnter | true |
|---|
| hideColumns | false |
|---|
| cell-width | 250,250 |
|---|
| totalRowName | |
|---|
| totalColName | |
|---|
| disabled | false |
|---|
| customNoTableMsg | false |
|---|
| globalFilter | false |
|---|
| formatVersion | 2 |
|---|
| iconfilter | |
|---|
| order | 0,1 |
|---|
| hideControls | false |
|---|
| inverse | false,false |
|---|
| numbering | Dynamic Ascending |
|---|
| datefilter | |
|---|
| column | |
|---|
| totalcol | |
|---|
| sort | DD Table Name ⇧,DD Column Name ⇧ |
|---|
| disableSave | true |
|---|
| rowsPerPage | 25 |
|---|
| 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 | |
|---|
| updateSelectOptions | true |
|---|
| worklog | 365|5|8|y w d h m|y w d h m |
|---|
| 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 |
|
...
...
AssetInfo
...
UpdatedDate
...
datetimeoffset
...
Date & Time With offset to UTC
...
AssetInfo
...
...
datetimeoffset
...
Date & Time With offset to UTC
datetime | No time Information. Has only Date | Asset | WarrantyExpirationDate | datetime | No time Information. Has only Date | Asset | DeactivatedDate | datetime | ET | Asset | AssetCreatedDate | datetime | ET |
|
...
...
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 |
|
...
AssetMeterReadings
...
MeasureDate
...
datetimeoffset(7)
...
Date & Time With offset to UTC
...
AssetMeterReadings
AssetCustomAttributes | CreatedDateInDataDirect | datetime | ET |
|
...
AssetMeterReadings
...
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 |
|
...
...
LeaseDate | datetime | No time Information. Has only Date |
|
...
AssetRefrigerantCharge
...
ChargeModifiedDate
...
datetimeoffset
...
Date & Time With offset to UTC
...
AssetRefrigerantCharge
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 |
|
...
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
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 |
|
...
AssetRefrigerantLeakImmeasurable
...
...
RepairDate
...
datetime
...
ET
MeasureDate | datetimeoffset(7) | Date & Time With offset to UTC | AssetMeterReadings | CreatedDateInDataDirect | datetime | ET | AssetMeterReadings | UpdatedDateInDataDirect | datetime | ET |
|
...
...
ChargeEffectiveDate | datetime |
|
...
ET
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 |
|
...
...
AssetRefrigerantLeakImmeasurableNotes
...
...
datetimeoffset
...
Date & Time With offset to UTC
datetime | No time Information. Has only Date | AssetRefrigerantLeak | RepairDate | datetime | ET |
|
...
...
InitialVerificationDate | datetime | ET |
|
...
AssetRefrigerantLeakImmeasurableWOs
AssetRefrigerantLeak | FollowupDate | datetime | ET | AssetRefrigerantLeak | GeneratedDate | datetime | ET | AssetRefrigerantLeak | LeakRecordModifiedDate | datetimeoffset | Date & Time With offset to UTC |
|
...
...
...
datetime
...
ET
...
AssetRefrigerantLeakImmeasurableWOs
...
UpdatedDateInDataDirect
...
datetime
...
ET
...
AssetRefrigerantLeakNotes
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 |
|
...
...
AssetRefrigerantLeakImmeasurable |
|
...
InitialVerificationDate | datetime | ET |
|
...
AssetRefrigerantLeakImmeasurable |
|
...
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
...
FollowupVerificationDate | datetime |
|
...
No time Information. Has only Date
...
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 | inventory_catalog | ValidDate | datetimeoffset | 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 |
|
...
AssetsInWorkorders
...
AssetsInWorkorders
...
inventory_part_purchase_items | UpdatedDate | datetimeoffset |
|
...
ET
...
Date & Time With offset to UTC | inventory_part_purchase_items | ReceivedDate | datetimeoffset |
|
...
ET
Date & Time With offset to UTC | inventory_part_purchase_items | CreatedDateInDataDirect | datetime |
|
...
ET
...
| ET | inventory_part_purchase_items | UpdatedDateInDataDirect | datetime | ET |
|
...
AssetValidationInfo
...
inventory_part_transit | TransferDate | datetimeoffset | Date & Time With offset to UTC |
|
...
AssetValidationInfo
...
AssetValidationInfo
...
inventory_part_transit | ShipDate | datetimeoffset |
|
...
ET
...
Date & Time With offset to UTC | inventory_part_transit | DateModified | datetimeoffset |
|
...
ET
Date & Time With offset to UTC | inventory_part_transit | CreatedDateInDataDirect | datetime | ET |
|
...
inventory_part_transit | UpdatedDateInDataDirect | datetime | ET |
|
...
audit
...
StartDate_DTO
...
datetimeoffset
...
Date & Time With offset to UTC
...
audit
...
inventory_part_transit_items | DateReceived | datetimeoffset | Date & Time With offset to UTC |
|
...
...
...
...
items | CreatedDateInDataDirect | datetime | ET |
|
...
...
...
...
items | UpdatedDateInDataDirect | datetime | ET |
|
...
...
...
...
...
datetime
...
ET
...
audit_issue_attachment
...
UpdatedDateInDataDirect
...
datetime
...
ET
...
datetimeoffset | Date & Time With offset to UTC | inventory_part_usage | ModifiedDate | datetimeoffset | Date & Time With offset to UTC | inventory_part_usage | CreatedDateInDataDirect | datetime | ET |
|
...
...
usage | UpdatedDateInDataDirect | datetime | ET |
|
...
budget
...
UpdatedDate
...
datetime
...
ET
...
budget
...
CreatedDateInDataDirect
...
datetime
...
ET
...
budget
...
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 |
|
...
...
CreatedDate | datetimeoffset | Date & Time With offset to UTC |
|
...
CheckListAssetTaskResponses
...
| inventory_parts | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
|
...
inventory_parts | CreatedDateInDataDirect | datetime | ET |
|
...
inventory_parts | UpdatedDateInDataDirect | datetime | ET |
|
...
inventory_stock | CreatedDate |
|
...
datetime
...
ET
...
checklists
...
ChecklistResponseUpdatedDate
...
datetime
...
ET
...
checklists
...
ChecklistUpdatedDate
...
datetime
...
ET
...
checklists
datetimeoffset | Date & Time With offset to UTC | inventory_stock | UpdatedDate |
|
...
datetime
...
ET
datetimeoffset | Date & Time With offset to UTC | inventory_stock | CreatedDateInDataDirect | datetime | ET |
|
...
inventory_stock | UpdatedDateInDataDirect | datetime | ET |
|
...
CheckListTasks
...
CreatedDate
...
datetimeoffset
...
Date & Time With offset to UTC
...
CheckListTasks
...
| 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 |
|
...
...
...
custom_asset_attributes
...
CreatedDateInDataDirect | datetime |
|
...
No time Information. Has only Date
ET | invoice_labor | UpdatedDateInDataDirect | datetime | ET |
|
...
...
materials | CreatedDateInDataDirect | datetime | ET |
|
...
...
materials | UpdatedDateInDataDirect | datetime | ET |
|
...
ftm
...
checkInDateTime
...
datetime
...
Location Timezone
...
ftm
...
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
...
invoice_statuses | CreatedDateInDataDirect | datetime |
|
...
Location Timezone
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 |
|
...
...
...
...
...
...
InvalidProposals
...
UpdatedDateInDataDirect
...
datetime
...
ET
...
InvalidRelationships
...
CreatedDateInDataDirect
...
datetime
...
ET
...
InvalidRelationships
...
UpdatedDateInDataDirect
...
datetime
...
ET
...
InvalidWorkorders
...
calldate
...
datetime
...
Location Timezone
...
...
datetime
...
ET
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 |
|
...
...
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 |
|
...
LeakInspectionComplianceAcknowledgement | UpdatedDateInDataDirect | datetime | ET |
|
...
...
invoices
...
...
Location Timezone
...
invoices
...
No time Information. Has only Date | locations | closedDate | datetime |
|
...
Location Timezone
No time Information. Has only Date | locations | CreatedDateInDataDirect | datetime |
|
...
...
...
UpdatedDateInDataDirect | datetime | ET |
|
...
...
CreatedDateInDataDirect | datetime | ET |
|
...
...
UpdatedDateInDataDirect | datetime | ET |
|
...
invoices
...
approvedDateDto
...
datetimeoffset
...
Date & Time With offset to UTC
...
invoices
...
lastPaymentDateDto
...
datetimeoffset
...
Date & Time With offset to UTC
...
invoices
...
locations_notes_headers | CreatedDateInDataDirect | datetime | ET | locations_notes_headers | UpdatedDateInDataDirect | datetime | ET | Materials | UseDate | datetimeoffset | Date & Time With offset to UTC |
|
...
...
ScMatCreatedDate | datetimeoffset | Date & Time With offset to UTC |
|
...
...
ScMatUpdatedDate | datetimeoffset | Date & Time With offset to UTC |
|
...
invoices
...
CreatedDateInDataDirect
...
datetime
...
ET
...
invoices
...
UpdatedDateInDataDirect
...
datetime
...
ET
...
label_history
...
Materials | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
|
...
...
label_history
...
...
datetime
...
ET
datetimeoffset | Date & Time With offset to UTC | Materials | WoCallDate | datetime |
|
...
...
labels
...
CreatedDateInDataDirect
...
datetime
...
ET
...
labels
...
UpdatedDateInDataDirect
...
datetime
...
ET
...
LeakInspectionComplianceAcknowledgement
...
DateAccepted
Materials | WoCallDate_dto | datetimeoffset | Date & Time With offset to UTC |
|
...
Materials | CreatedDateInDataDirect | datetime | ET |
|
...
Materials | UpdatedDateInDataDirect | datetime | ET |
|
...
...
noteDate | datetime | No time Information. Has only Date |
|
...
locations
...
notes_statistics | firstNoteDateTime | datetime | ET | notes_statistics | lastNoteDatetime | datetime |
|
...
No time Information. Has only Date
ET | notes_statistics | CreatedDateInDataDirect | datetime | ET |
|
...
notes_statistics | UpdatedDateInDataDirect | datetime | ET |
|
...
| PartUsageAudit | CreatedDate | datetimeoffset | Date & Time With offset to UTC | PartUsageAudit | CreatedDateInDataDirect | datetime | ET |
|
...
PartUsageAudit | UpdatedDateInDataDirect | datetime | ET |
|
...
...
...
...
...
...
...
...
...
Materials
...
UseDate
...
datetimeoffset
...
Date & Time With offset to UTC
...
Materials
...
pilot_provider_contracts | expire_date | datetime | ET | pilot_provider_contracts | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
|
...
Materials
pilot_provider_contracts | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
|
...
Materials
...
CreatedDate
...
datetimeoffset
...
Date & Time With offset to UTC
...
Materials
...
| 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 |
|
...
pilot_provider_emails | CreatedDateInDataDirect | datetime | ET |
|
...
pilot_provider_emails | UpdatedDateInDataDirect | datetime | ET |
|
...
...
...
...
datetime
...
No time Information. Has only Date
...
notes_statistics
...
firstNoteDateTime
...
datetime
...
ET
...
notes_statistics
datetimeoffset | Date & Time With offset to UTC | pilot_provider_workorders | UpdatedDate | datetimeoffset | Date & Time With offset to UTC | pilot_provider_workorders | CreatedDateInDataDirect | datetime | ET |
|
...
...
...
UpdatedDateInDataDirect | datetime | ET |
|
...
...
...
PartUsageAudit
...
...
datetime
...
ET
datetimeoffset | Date & Time With offset to UTC | pilot_providers | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
|
...
pilot_providers | CreatedDateInDataDirect | datetime | ET |
|
...
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_change | 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_ |
|
...
...
...
UpdatedDateInDataDirect | datetime | ET | wo_history_change_estimated_ |
|
...
...
...
OldEstimatedCompletionDate |
|
...
datetime
datetimeoffset | Date & Time With offset to UTC | wo_history_ |
|
...
UpdatedDateInDataDirect
...
datetime
...
change_estimated_completion_date | NewEstimatedCompletionDate | datetimeoffset | Date & Time With offset to UTC | wo_history_change_estimated_ |
|
...
...
...
datetime
datetimeoffset | Date & Time With offset to UTC | wo_history_change_ |
|
...
estimated_completion_date | CreatedDateInDataDirect | datetime | ET | wo_history_change_ |
|
...
estimated_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 |
|
