iVend Database Database > Tables > InvStockTransferSerial Table

iVend 6.6 Database Help

InvStockTransferSerial Table

Collapse All Expand All

iVend Database Database : InvStockTransferSerial Table

Description

This gets affected in case the stock transfer is done for a serially tracked product

Properties

Columns

Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
StockTransferSerialKey	Primary Key	VarWChar	50
SerialKey	Reference key of the serial product	VarWChar	50
StockTransferDetailKey	Reference Key of the stock transfer detail	VarWChar	50
Status	Status of Stock Transfer detail serial item Valid values are: Open = 0 Close = 1	Integer	4
IsShortReceived	Hold true if serial is short received while receiving the stock transfer.	Boolean	1

Indexes

Index	Description	Primary	Unique
PK_InvStockTransferSerial

Objects that depend on InvStockTransferSerial

Database Object	Object Type	Description	Dep Level
CancelStockTransfer	Stored Procedure		1
Integration_GoodsReceiptSerialBatchShortReceived	Stored Procedure		1
Integration_StockTransfer	Stored Procedure		1
Integration_StockTransferSerialBatch	Stored Procedure		1
StockTransferReport	Stored Procedure		1

SQL

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvStockTransferSerial](

[StockTransferSerialKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[SerialKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[StockTransferDetailKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Status] [int] NOT NULL,

[IsShortReceived] [bit] NULL,

CONSTRAINT [PK_InvStockTransferSerial] PRIMARY KEY CLUSTERED

(

[StockTransferSerialKey] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

Send comments on this topic.