Tables [dbo].[ServiceKeyTable]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created1:00:40 AM Thursday, March 21, 2019
Last Modified1:00:40 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
TechnicianIDint4
False
TransactionTypeIDint4
False
CallIDint4
True
CallBackCallIDint4
True
ReportLaborKeyvarchar(50)50
True
ReportPartsKeyvarchar(50)50
True
CalendarDatePeriodint4
True
Periodint4
True
EquipmentIDint4
True
CREATE TABLE [dbo].[ServiceKeyTable]
(
[TechnicianID] [int] NOT NULL,
[TransactionTypeID] [int] NOT NULL,
[CallID] [int] NULL,
[CallBackCallID] [int] NULL,
[ReportLaborKey] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ReportPartsKey] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CalendarDatePeriod] [int] NULL,
[Period] [int] NULL,
[EquipmentID] [int] NULL
) ON [PRIMARY]
GO