iVend Database Database > Tables > InvGoodReceiptBatch Table

iVend 6.6 Database Help

InvGoodReceiptBatch Table

Collapse All Expand All

iVend Database Database : InvGoodReceiptBatch Table

Description

This is affected in case the goods receipt is done for a batch product.

Properties

Columns

Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
GoodReceiptBatchKey	Primary Key	VarWChar	50
GoodReceiptDetailKey	Reference Key of goods receipt detail	VarWChar	50
BatchKey	Reference Key of batch	VarWChar	50
QuantityReceived	Quantity received of Batch in goods receipt	Numeric	9 (20,5)
SourceType	Valid Values are : None = 0, PurchaseOrder = 1, StockTransfer = 2, GiftCertificateReceipt = 3, GiftCertificateStockTransfer = 4, InventoryReconciliation = 5	Integer	4

Indexes

Index	Description	Primary	Unique
PK_InvGoodReceiptBatch

Objects that depend on InvGoodReceiptBatch

Database Object	Object Type	Description	Dep Level
GoodsReceiptPOReport	Stored Procedure		1
GoodsReceiptReport	Stored Procedure		1
Integration_GoodsReceipt	Stored Procedure		1
Integration_GoodsReceiptSerialBatch	Stored Procedure		1

SQL

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvGoodReceiptBatch](

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

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

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

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

[SourceType] [int] NULL,

CONSTRAINT [PK_InvGoodReceiptBatch] PRIMARY KEY CLUSTERED

(

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