mqbcPB5s

1/*<IssueID:112364>,Date:27-Jun-2019,Done By:Anvesh Kumar Dubey<1394>*/
2IF NOT EXISTS(SELECT TOP 1 1  FROM sys.tables WHERE name ='xtActualConsCutQty')
3BEGIN
4	CREATE TABLE xtActualConsCutQty
5	(
6		ActualConsCutQtyID xdtID IDENTITY(1,1),
7		GMPOActualConsID xdtID ,
8		StyleID xdtID ,
9		SupplierCompanycode xdtInt,
10		[ColorCode]	[dbo].[xdtName],
11		[ColorName]	[dbo].[xdtFileName],
12		OCQty  xdtUnits,
13		GMPOQty xdtUnits,
14		GMPOShippedQty xdtUnits,
15		CutQty	xdtUnits		
16	)	
17	ALTER TABLE xtActualConsCutQty ADD CONSTRAINT PK_xtActualConsCutQty_ActualConsCutQtyID PRIMARY KEY (ActualConsCutQtyID)
18END
19GO
20EXEC xspCreateIndex @TableName ='xtActualConsCutQty',@IndexColumnList ='ActualConsCutQtyID'
21GO
22EXEC xspCreateIndex @TableName ='xtActualConsCutQty',@IndexColumnList ='StyleID,SupplierCompanycode'
23EXEC xspCreateIndex @TableName ='xtActualConsCutQty',@IndexColumnList ='GMPOActualConsID,[ColorCode],[ColorName]',@IsUniqueIndex=1
24GO
25/*Start<IssueID:112364>*/
26IF NOT EXISTS (SELECT TOP 1 1 FROM syscolumns WHERE id = OBJECT_ID('xtActualConsCutQty') AND name = 'SampleQty')
27	ALTER TABLE xtActualConsCutQty ADD SampleQty xdtUnits NULL
28GO
29IF NOT EXISTS (SELECT TOP 1 1 FROM syscolumns WHERE id = OBJECT_ID('xtActualConsCutQty') AND name = 'RejectedQty')
30	ALTER TABLE xtActualConsCutQty ADD RejectedQty xdtUnits NULL
31GO
32IF NOT EXISTS (SELECT TOP 1 1 FROM syscolumns WHERE id = OBJECT_ID('xtActualConsCutQty') AND name = 'LossBySupplierQty')
33	ALTER TABLE xtActualConsCutQty ADD LossBySupplierQty xdtUnits NULL
34GO
35IF NOT EXISTS (SELECT TOP 1 1 FROM syscolumns WHERE id = OBJECT_ID('xtActualConsCutQty') AND name = 'Remarks')
36	ALTER TABLE xtActualConsCutQty ADD Remarks xdtText NULL
37GO
38/*End<IssueID:112364>*/