iVend Database Database : InvBatchLog Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

0

Data Space Used

0.00 KB

Index Space Used

0.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

InventoryBatchLogKey

System-generated primary key of the table.

VarWChar

50

BatchKey

Reference key of Batch for which the transaction is made. See also Batch.

VarWChar

50

WarehouseKey

Reference Key of warehouse where the batch exists. See also Warehouse.

VarWChar

50

ProductKey

Reference key of product to which the batch belongs. See also Product.

VarWChar

50

InQty

Quantity received

Numeric

9 (20,5)

OutQty

Quantity consumed

Numeric

9 (20,5)

SourceType

Source of incoming or outgoing quantity of Batch.

Valid values are:

External = -1

Unknown = 0

GoodsReceipt = 1

GoodsReceiptPO = 2

GoodsReceiptSTN = 3

StockTransfer = 4

KitBuildBreak = 5

StoreUseInventory = 6

SaleTransaction = 7

LayawayTransaction = 8

SpecialOrderTransaction = 9

Integer

4

SourceKey

Reference Key of Source. Eg. If the source is SaleTransaction, then the source key is the reference key of TransactionSale.

VarWChar

50

SourceDetailKey

Reference Key of Source Detail. Eg. If the source is SaleTransaction, then the source detail key is the reference key of TransactionSaleItem.

VarWChar

50

AllocatedQuantity

Stores the quantity of batch which is reserved for delivery from iVend Mobile POS.

Numeric

9 (20,5)

((0))

LocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

((0))

IsProcessed

Value is the true if the batch is processed.

Boolean

1

((0))

ReservedQuantity

Hold the reserved quantity for sale with delivery fulfillment and Layaway with delivery fulfillment

Numeric

9 (20,5)

((0))

UpdateType

Valid Values are:

Both = 0,

Available = 1,

InStock = 2

Integer

4

((0))

Index

Description

Primary

Unique

IX_InvBatchLog

PK_InvBatchLog

Database Object

Object Type

Description

Dep Level

BatchQuantityUpdates

Stored Procedure

1

CancelStockTransfer

Stored Procedure

1

ExecuteInventoryItemLogUpdate

Stored Procedure

1

TrgSBOBatchUpdate

Trigger

Handles updates made to Batch table from ERP system (Business One in this case)

1

TrxCompleteTransactionUpdates

Stored Procedure

1

TrxInventoryUpdateBatchNumber

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvBatchLog](

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

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

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

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

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

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

[SourceType] [int] NOT NULL,

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

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

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

[LocationKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[IsProcessed] [bit] NULL,

[ReservedQuantity] [decimal](20, 5) NULL,

[UpdateType] [int] NULL,

CONSTRAINT [PK_InvBatchLog] PRIMARY KEY CLUSTERED

(

[InventoryBatchLogKey] ASC

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

) ON [PRIMARY]

ALTER TABLE [dbo].[InvBatchLog] ADD CONSTRAINT [DF_InvBatchLog_AllocatedQuantity] DEFAULT ((0)) FOR [AllocatedQuantity]

ALTER TABLE [dbo].[InvBatchLog] ADD CONSTRAINT [DF_InvBatchLog_LocationKey] DEFAULT ((0)) FOR [LocationKey]

ALTER TABLE [dbo].[InvBatchLog] ADD CONSTRAINT [DF__InvBatchL__IsPro__2CE88C3E] DEFAULT ((0)) FOR [IsProcessed]

ALTER TABLE [dbo].[InvBatchLog] ADD CONSTRAINT [DF_InvBatchLog_ReservedQuantity] DEFAULT ((0)) FOR [ReservedQuantity]

ALTER TABLE [dbo].[InvBatchLog] ADD CONSTRAINT [DF_InvBatchLog_UpdateType] DEFAULT ((0)) FOR [UpdateType]