Tables [dbo].[SynchFail_Labor]
PropertyValue
HeapTrue
Row Count (~)0
Created1:00:54 AM Thursday, March 21, 2019
Last Modified1:00:54 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
LaborIDint4
False
CallIDint4
True
Arrivaldatetime8
True
Departuredatetime8
True
OdometerStartdecimal(16,1)9
True
OdometerEnddecimal(16,1)9
True
TravelHoursfloat8
True
ModifiedDatedatetime8
False
CreateDatedatetime8
False
IsActivebit1
False
Deletedbit1
False
DispatchHistoryIDint4
True
Dispatchdatetime8
True
ExistsOnServerbit1
False
CREATE TABLE [dbo].[SynchFail_Labor]
(
[LaborID] [int] NOT NULL,
[CallID] [int] NULL,
[Arrival] [datetime] NULL,
[Departure] [datetime] NULL,
[OdometerStart] [decimal] (16, 1) NULL,
[OdometerEnd] [decimal] (16, 1) NULL,
[TravelHours] [float] NULL,
[ModifiedDate] [datetime] NOT NULL,
[CreateDate] [datetime] NOT NULL,
[IsActive] [bit] NOT NULL,
[Deleted] [bit] NOT NULL,
[DispatchHistoryID] [int] NULL,
[Dispatch] [datetime] NULL,
[ExistsOnServer] [bit] NOT NULL
) ON [PRIMARY]
GO