iVend Database Database > Tables > InvInventoryTransactionBatch Table

iVend 6.6 Database Help

InvInventoryTransactionBatch Table

Collapse All Expand All

iVend Database Database : InvInventoryTransactionBatch Table

Description

This gets affected in case the product on the goods issue note is batch tracked.

Properties

Columns

Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
InventoryTransactionBatchKey	Primary Key	VarWChar	50
InventoryTransactionDetailKey	Reference Key of inventory transaction detail	VarWChar	50
InventoryTransactionKey	Reference Key of inventory transaction	VarWChar	50
BatchKey	Reference Key of the batch.	VarWChar	50
Quantity	Quantity of the batch product	Numeric	9 (20,5)

Indexes

Index	Description	Primary	Unique
PK_InvInventoryTransactionBatch

Objects that depend on InvInventoryTransactionBatch

Database Object	Object Type	Description	Dep Level
GoodsIssueReport	Stored Procedure		1
Integration_GoodsIssue	Stored Procedure		1
Integration_GoodsIssue_SerialBatch	Stored Procedure		1

SQL

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvInventoryTransactionBatch](

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

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

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

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

[Quantity] [decimal](20, 5) NOT NULL,

CONSTRAINT [PK_InvInventoryTransactionBatch] PRIMARY KEY CLUSTERED

(

[InventoryTransactionBatchKey] 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.