Jobs

Delivery and collection jobs tracked in DeTrack. Single job can be retrieved by DoNumber.

Columns

Name	Type	References
Id [KEY]	String
DeliveryOrderNumber	String
Type	String		The allowed values are Delivery, Collection.
PrimaryJobStatus	String
Status	String
CreatedAt	Datetime
AccountNumber	String
ActualCrates	Integer
ActualPallets	Integer
ActualUtilization	Double
ActualWeight	Double
CompleteAddress	String
AddressLine1	String
AddressLine2	String
AddressLine3	String
AddressLatitude	Double
AddressLongitude	Double
AddressTrackedAt	Datetime
ArrivedAddress	String
ArrivedAt	Datetime
ArrivedLatitude	Double
ArrivedLongitude	Double
AssignTo	String
WarehouseAt	Datetime
Attempt	Integer
AttachmentUrl	String
BankPrefix	String
BillingAddress	String
Bins	Integer
Boxes	Integer
Bundles	Integer
CalledAt	Datetime
IsReattemptAllowed	Boolean
CancelledAt	Datetime
Cartons	Integer
Carrier	String
City	String
CompanyName	String
CompletionDate	Date
ConnectHost	String
ConnectId	String
ConnectToken	String
ContactlessSignatureLink	String
ContractorGroupIds	String
ContractorGroupName	String
Country	String
CubicMeter	Double
CubicMeters	Double
Customer	String
CustomerFeedback	String
Date	Date
DeliverFailedCount	Integer
DeliverToCollectFrom	String
Department	String
Depot	String
DepotContact	String
DepotContactNo	String
DestinationTimeWindow	String
DetrackNumber	String
DoorNumber	String
DriverMobileNumber	String
DriverRating	Integer
Envelopes	Integer
EtaTime	String
ExternalParams	String
FaxNumber	String
GeocodedLatitude	Double
GeocodedLongitude	Double
GeofenceAckAt	Datetime
GeofenceAckLatitude	Double
GeofenceAckLongitude	Double
GoodsServiceRating	Integer
GroupCode	String
GroupId	String
GroupName	String
HeadToDeliveryAt	Datetime
HeadToPickUpAt	Datetime
HoldTime	String
IdentificationNumber	String
InfoReceivedAt	Datetime
Instructions	String
InsurancePrice	Double
InvoiceAmount	Double
InvoiceNumber	String
IsAutoReschedule	Boolean
IsInsuranceCoverage	Boolean
IsOpenToMarketplace	Boolean
Items	String
ItemsCount	Integer
JobAge	Integer
JobFee	Double
JobOrder	Integer
JobOwner	String
JobPrice	Double
JobReceivedDate	Date
JobReleaseTime	String
JobSequence	Double
JobTime	String
JobType	String
LastName	String
LastReason	String
LiveEta	String
LockerAddress	String
LockerError	String
LockerLatitude	Double
LockerLongitude	Double
LockerStationId	String
LockerTransactionId	String
LockerTransactionStatus	String
MarketplaceOffer	String
MassPod	String
Milestones	String
Note	String
NotifyEmail	String
NumberOfShippingLabels	Integer
IsOnDemand	Boolean
OrderNumber	String
OtherPhoneNumbers	String
OutForDeliveryAt	Datetime
Pallets	Integer
ParcelHeight	Double
ParcelLength	Double
ParcelWidth	Double
PayerType	String
PaymentAmount	Double
PaymentCollected	Double
PaymentMode	String
PhoneNumber	String
Photo1At	Datetime
Photo1FileUrl	String
Photo2At	Datetime
Photo2FileUrl	String
Photo3At	Datetime
Photo3FileUrl	String
Photo4At	Datetime
Photo4FileUrl	String
Photo5At	Datetime
Photo5FileUrl	String
Photo6At	Datetime
Photo6FileUrl	String
Photo7At	Datetime
Photo7FileUrl	String
Photo8At	Datetime
Photo8FileUrl	String
Photo9At	Datetime
Photo9FileUrl	String
Photo10At	Datetime
Photo10FileUrl	String
PhotoPreviewAckAt	Datetime
PhotoPreviewAckLat	Double
PhotoPreviewAckLng	Double
PickUpAddress	String
PickUpAddress1	String
PickUpAddress2	String
PickUpAddress3	String
PickUpAssignTo	String
PickUpAt	Datetime
PickUpCity	String
PickUpCountry	String
PickUpFailedCount	Integer
PickUpFrom	String
PickUpLatitude	Double
PickUpLongitude	Double
PickUpPhotoPreviewAckAt	Datetime
PickUpPhotoPreviewAckLat	Double
PickUpPhotoPreviewAckLng	Double
PickUpPostalCode	String
PickUpReason	String
PickUpState	String
PickUpTime	String
PickUpZone	String
Pieces	Integer
PodAddress	String
PodAt	Datetime
PodGpsPermission	String
PodGpsStatus	String
PodLatitude	Double
PodLongitude	Double
PodTime	String
PostalCode	String
Priority	Integer
RateCardChargeable	String
RateCardChargeableId	String
RateCardId	String
RateCardVersion	Integer
Reason	String
IsReattempted	Boolean
ReceivedBySentBy	String
RecipientSenderDevicePodAt	Datetime
RecipientSenderDeviceSignatureFileUrl	String
RecipientSenderDeviceSignedBy	String
Remarks	String
Rolls	Integer
RunNumber	String
SalesPerson	String
ScheduledAt	Datetime
SenderPhoneNumber	String
SerialNumber	String
ServiceTime	Integer
ServiceType	String
ShipperName	String
SignatureFileUrl	String
SignedAt	Datetime
Source	String
StartDate	Date
State	String
Temperature	Double
TextedAt	Datetime
TimeWindow	String
TimeWindowFrom	String
TimeWindowTo	String
TimeZone	String
TotalPrice	Double
TrackingLink	String
TrackingNumber	String
TrackingStatus	String
TrackingStatusCode	String
Trays	Integer
UpdatedAt	Datetime
IsLockerUsed	Boolean
VehicleType	String
VendorName	String
VerificationCode	Integer
WarehouseAddress	String
WebhookUrl	String
Weight	Double
Zone	String