Create Table StockTranLog
(
STranId int  IDENTITY(1, 1) NOT NULL primary key,
itemcode nvarchar(500),
VchrId int NULL,
VchrNo int NULL,
VchrDate datetime NULL,
VchrType nvarchar(50) NULL,
VchrFormType nvarchar(50) NULL,
AcCode nvarchar(500) NULL,
InQuantity decimal(24,4) NULL,
OutQuantity decimal(24,4) NULL,
Unit nvarchar(50) NULL,
Narration nvarchar(400) NULL,
UserName nvarchar(500) NULL,
TranDate datetime NULL,
BranchCode nvarchar(500) NULL,
InRate decimal(24,4) NULL,
OutRate decimal(24,4) NULL,
ActualUnit nvarchar(50) null,
ActualUnitQty decimal(24,4) NULL,
ActualRate decimal(24,4) NULL
)