iVend Database Database : InvBatchLocationLog Table

Creation Date

9/18/2015 10:05 AM

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

BatchLocationLogKey

Primary Key

VarWChar

50

BatchKey

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

VarWChar

50

WarehouseKey

Reference Key of Warehouse. See also InvWarehouse.

VarWChar

50

ProductKey

Reference Key of Product. See also InvProduct.

VarWChar

50

LocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

InQty

Quantity received

Numeric

9 (20,5)

OutQty

Quantity consumed

Numeric

9 (20,5)

SourceType

Refers to the source document.

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

GiftCertificateReceipt = 10,

GiftCertificateStockTransfer = 11,

GoodsReturn = 12,

InventoryReconciliation = 13,

StockTransferCancellation = 14,

DeliveryPackage = 15,

InventoryRevaluation = 16,

LocationStockTransfer = 17

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

For future use

Numeric

9 (20,5)

((0))

Index

Description

Primary

Unique

PK_InvBatchLocationLog

Database Object

Object Type

Description

Dep Level

BatchLocationQuantityUpdates

Stored Procedure

Used in replication to update the Batch quantities

1

InvWarehouseInventoryLocation

Stored Procedure

1

ReplicationRecordsToSend

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvBatchLocationLog](

[BatchLocationLogKey] [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,

[LocationKey] [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,

CONSTRAINT [PK_InvBatchLocationLog] PRIMARY KEY CLUSTERED

(

[BatchLocationLogKey] 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].[InvBatchLocationLog] ADD CONSTRAINT [DF_InvBatchLocationLog_AllocatedQuantity] DEFAULT ((0)) FOR [AllocatedQuantity]