Tables [dbo].[ICWorkOrders]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:57:55 AM Thursday, March 21, 2019
Last Modified1:16:01 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_ICWorkOrders: WorkOrderIDWorkOrderIDint4
False
WorkOrderNumbervarchar(15)15
False
Typechar(4)4
False
Datedatetime8
False
Descriptionvarchar(255)255
False
ReqDatedatetime8
True
Foreign Keys FK_ICWorkOrders_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
False
SerialNumbervarchar(30)30
False
Quantitydecimal(18,6)9
False
Costmoney8
False
((0))
EstOpenDatedatetime8
True
EstCloseDatedatetime8
True
OpenDatedatetime8
True
CloseDatedatetime8
True
Materialmoney8
False
((0))
LaborHoursdecimal(18,6)9
False
LaborRatemoney8
False
Labormoney8
False
((0))
StdOverheadmoney8
False
((0))
Overheadmoney8
False
((0))
Amountmoney8
False
((0))
Foreign Keys FK_ICWorkOrders_JobID_ICJobs: [dbo].[ICJobs].JobIDJobIDint4
True
Finisheddecimal(18,6)9
False
((0))
Canceleddecimal(18,6)9
False
((0))
Modulechar(4)4
False
Sourcevarchar(15)15
False
Referencevarchar(15)15
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
Foreign Keys FK_ICWorkOrders_PreAssemblyWarehouseID_ICWarehouses: [dbo].[ICWarehouses].PreAssemblyWarehouseIDPreAssemblyWarehouseIDint4
True
Foreign Keys FK_ICWorkOrders_PostAssemblyWarehouseID_ICWarehouses: [dbo].[ICWarehouses].PostAssemblyWarehouseIDPostAssemblyWarehouseIDint4
True
Foreign Keys FK_ICWorkOrders_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_ICWorkOrders: WorkOrderIDPK_ICWorkOrdersWorkOrderID
True
80
NameColumns
FK_ICWorkOrders_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_ICWorkOrders_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
FK_ICWorkOrders_JobID_ICJobsJobID->[dbo].[ICJobs].[JobID]
FK_ICWorkOrders_PostAssemblyWarehouseID_ICWarehousesPostAssemblyWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
FK_ICWorkOrders_PreAssemblyWarehouseID_ICWarehousesPreAssemblyWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
CREATE TABLE [dbo].[ICWorkOrders]
(
[WorkOrderID] [int] NOT NULL,
[WorkOrderNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Type] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Date] [datetime] NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ReqDate] [datetime] NULL,
[ItemID] [int] NOT NULL,
[SerialNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Quantity] [decimal] (18, 6) NOT NULL,
[Cost] [money] NOT NULL CONSTRAINT [DF_ICWorkOrders_Cost] DEFAULT ((0)),
[EstOpenDate] [datetime] NULL,
[EstCloseDate] [datetime] NULL,
[OpenDate] [datetime] NULL,
[CloseDate] [datetime] NULL,
[Material] [money] NOT NULL CONSTRAINT [DF_ICWorkOrders_Material] DEFAULT ((0)),
[LaborHours] [decimal] (18, 6) NOT NULL,
[LaborRate] [money] NOT NULL,
[Labor] [money] NOT NULL CONSTRAINT [DF_ICWorkOrders_Labor] DEFAULT ((0)),
[StdOverhead] [money] NOT NULL CONSTRAINT [DF_ICWorkOrders_StdOverhead] DEFAULT ((0)),
[Overhead] [money] NOT NULL CONSTRAINT [DF_ICWorkOrders_Overhead] DEFAULT ((0)),
[Amount] [money] NOT NULL CONSTRAINT [DF_ICWorkOrders_Amount] DEFAULT ((0)),
[JobID] [int] NULL,
[Finished] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICWorkOrders_Finished] DEFAULT ((0)),
[Canceled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICWorkOrders_Canceled] DEFAULT ((0)),
[Module] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Source] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Reference] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_ICWorkOrders_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ICWorkOrders_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[PreAssemblyWarehouseID] [int] NULL,
[PostAssemblyWarehouseID] [int] NULL,
[BranchID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICWorkOrders] ADD CONSTRAINT [PK_ICWorkOrders] PRIMARY KEY CLUSTERED  ([WorkOrderID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICWorkOrders] ADD CONSTRAINT [FK_ICWorkOrders_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ICWorkOrders] ADD CONSTRAINT [FK_ICWorkOrders_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[ICWorkOrders] ADD CONSTRAINT [FK_ICWorkOrders_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[ICWorkOrders] ADD CONSTRAINT [FK_ICWorkOrders_PostAssemblyWarehouseID_ICWarehouses] FOREIGN KEY ([PostAssemblyWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
ALTER TABLE [dbo].[ICWorkOrders] ADD CONSTRAINT [FK_ICWorkOrders_PreAssemblyWarehouseID_ICWarehouses] FOREIGN KEY ([PreAssemblyWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO