-- For Count Lot No Item at Physical Count.
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Vstk_trs_PhysicalDetails
	(
	ID bigint NOT NULL IDENTITY (1, 1),
	CountDate datetime NULL,
	ItemCode varchar(20) NULL,
	ItemType varchar(1) NULL,
	ItemRefNo varchar(20) NULL,
	BalanceQty numeric(20, 6) NULL,
	CountQty numeric(20, 6) NULL,
	DifferentQty numeric(20, 6) NULL,
	AdjustQty numeric(20, 6) NULL,
	TrsOutlet varchar(20) NULL,
	CountStatus bit NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Vstk_trs_PhysicalDetails ADD CONSTRAINT
	DF_Vstk_trs_PhysicalDetails_BalanceQty DEFAULT ((0)) FOR BalanceQty
GO
ALTER TABLE dbo.Vstk_trs_PhysicalDetails ADD CONSTRAINT
	DF_Vstk_trs_PhysicalDetails_CountQty DEFAULT ((0)) FOR CountQty
GO
ALTER TABLE dbo.Vstk_trs_PhysicalDetails ADD CONSTRAINT
	DF_Vstk_trs_PhysicalDetails_DifferentQty DEFAULT ((0)) FOR DifferentQty
GO
ALTER TABLE dbo.Vstk_trs_PhysicalDetails ADD CONSTRAINT
	DF_Vstk_trs_PhysicalDetails_AdjustQty DEFAULT ((0)) FOR AdjustQty
GO
ALTER TABLE dbo.Vstk_trs_PhysicalDetails ADD CONSTRAINT
	DF_Vstk_trs_PhysicalDetails_CountStatus DEFAULT ((0)) FOR CountStatus
GO
ALTER TABLE dbo.Vstk_trs_PhysicalDetails ADD CONSTRAINT
	PK_Vstk_trs_PhysicalDetails PRIMARY KEY CLUSTERED 
	(
	ID
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
COMMIT
select Has_Perms_By_Name(N'dbo.Vstk_trs_PhysicalDetails', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Vstk_trs_PhysicalDetails', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Vstk_trs_PhysicalDetails', 'Object', 'CONTROL') as Contr_Per 



ALTER TABLE Vstk_trs_PhysicalDetails ADD BatchNo Varchar(20)
GO

ALTER TABLE Vstk_trs_PhysicalDetails ADD MFGDate DateTime
GO

ALTER TABLE Vstk_trs_PhysicalDetails ADD ExpiredDate DateTime
GO

ALTER TABLE Vstk_trs_PhysicalDetails ADD TempCountQty Numeric(20,6)
GO

ALTER TABLE Vstk_trs_PhysicalDetails ADD TempDifferentQty Numeric(20,6)
GO

ALTER TABLE Vstk_trs_PhysicalDetails ADD TempAdjustQty Numeric(20,6)
GO

ALTER TABLE Vstk_trs_PhysicalDetails ADD TempCountStatus Bit
GO