Stock Allocations

The StkTrans table is used to perform stock movements in and out.

Field Mapping (mandatory fields in RED)

E2S Field	SAGE Field	Location within Sage	Data Type	Notes
ID	N/A	N/A	int	Used internally and not uploaded to Sage
Product	Product Code	Product/Services - Amend Allocations	nvarchar(30)	The key field for this tab. This will be the Product code this adjustment is for
Qty	Quantity Allocated	Product/Services - Amend Allocations	decimal(18, 2)	Quantity you wish to allocated
ProjectCode	Project Ref	Product/Services - Amend Allocations	nvarchar(8)	If provided the allocation n will be against this project
CostCode	Cost Code	Product/Services - Amend Allocations	nvarchar(8)	If provided the allocation n will be against this cost code as long as a valid project has also been provided
Date	Date	Product/Services - Amend Allocations	datetime	Date of allocation - will be today's date if blank
Details	Details	Product/Services - Amend Allocations	nvarchar(60)	The Details for the allocation (will be blank in Sage if left blank)
Ref	Ref.	Product/Services - Amend Allocations	nvarchar(30)	The Ref for the allocation (will be blank in Sage if left blank)
Status	N/A	N/A	nvarchar(8)

Script to create the table...

CREATE TABLE [dbo].[StockAllocations](

[ID] [int] IDENTITY(1,1) NOT NULL,

[Product] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Qty] [decimal](18, 2) NULL,

[ProjectCode] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[CostCode] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Date] [datetime] NULL,

[Details] [nvarchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Ref] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Status] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_StockAllocations_Status] DEFAULT (N'New'),

CONSTRAINT [PK_StockAllocations] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]