iVend Database Database : InvBatchLocation Table

Creation Date

9/18/2015 10:05 AM

File Group

PRIMARY

Text File Group

PRIMARY

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

BatchLocationKey

Primary Key

VarWChar

50

BatchKey

Reference Key of Batch. See also InvBatch.

VarWChar

50

BatchNumber

Hold the batch Number

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

CommentKey

Reference Key of Comment. See also CfgComment.

VarWChar

50

AdmissionDate

Value is the date when batch received.

DBTimeStamp

4

ExpirationDate

Value is the date when batch will expired.

DBTimeStamp

4

ManufacturingDate

Value is the manufacturing date of batch.

DBTimeStamp

4

InStockQuantity

Value is the quantity of batch in stock.

Numeric

9 (20,4)

CommittedQuantity

For future use.

Numeric

9 (20,4)

OnOrderQuantity

Value is the quantity of batch which is on order.

Numeric

9 (20,4)

OnRentQuantity

For future use

Numeric

9 (20,4)

((0))

LostQuantity

For future use

Numeric

9 (20,4)

InReturnQuantity

For future use

Numeric

9 (20,4)

AvailableQuantity

Value is the quantity of batch which is available at warehouse.

Numeric

9 (20,4)

OnLayawayQuantity

Value is the quantity of batch which is on layaway.

Numeric

9 (20,4)

ReleasedQuantity

For future use.

Numeric

9 (20,4)

Status

Value which denotes the current status of the batch, in the form of Available or NotAvailable.

Integer

4

Price

Hold the price of batch

Numeric

9 (20,5)

((0.00))

Details

For future use

LongVarWChar

16

AllocatedQuantity

For future use.

Numeric

9 (20,4)

Created

Date of creation of this record

DBTimeStamp

4

Modified

Date of last modification of this record

DBTimeStamp

4

CreatedBy

Reference of user who has created this record. See also Security User

VarWChar

50

ModifiedBy

Reference of user who has created this record. See also Security User

VarWChar

50

IsDeleted

Value is True if the record has been deleted from the system. Record is always Soft Deleted

Boolean

1

Comments

Stores comments.

VarWChar

4000

Index

Description

Primary

Unique

PK_InvBatchLocation

Database Object

Object Type

Description

Dep Level

BatchLocationQuantityUpdates

Stored Procedure

Used in replication to update the Batch quantities

1

BatchQuantityUpdates

Stored Procedure

1

CancelStockTransfer

Stored Procedure

1

ExecuteInventoryItemLogUpdate

Stored Procedure

2

GetMobileReplicationData

Stored Procedure

1

InvWarehouseInventoryLocation

Stored Procedure

1

ReplicationRecordsToSend

Stored Procedure

1

TrgSBOBatchUpdate

Trigger

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

1

TrxCompleteTransactionUpdates

Stored Procedure

2

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvBatchLocation](

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

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

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

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

[AdmissionDate] [datetime] NULL,

[ExpirationDate] [datetime] NULL,

[ManufacturingDate] [datetime] NULL,

[InStockQuantity] [decimal](20, 4) NOT NULL,

[CommittedQuantity] [decimal](20, 4) NOT NULL,

[OnOrderQuantity] [decimal](20, 4) NOT NULL,

[OnRentQuantity] [decimal](20, 4) NULL,

[LostQuantity] [decimal](20, 4) NOT NULL,

[InReturnQuantity] [decimal](20, 4) NOT NULL,

[AvailableQuantity] [decimal](20, 4) NOT NULL,

[OnLayawayQuantity] [decimal](20, 4) NOT NULL,

[ReleasedQuantity] [decimal](20, 4) NULL,

[Status] [int] NOT NULL,

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

[Details] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[AllocatedQuantity] [decimal](20, 4) NULL,

[Created] [datetime] NOT NULL,

[Modified] [datetime] NOT NULL,

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

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

[IsDeleted] [bit] NOT NULL,

[Comments] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

CONSTRAINT [PK_InvBatchLocation] PRIMARY KEY CLUSTERED

(

[BatchLocationKey] ASC

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

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

ALTER TABLE [dbo].[InvBatchLocation] ADD CONSTRAINT [DF_InvBatchLocation_OnRentQuantity] DEFAULT ((0)) FOR [OnRentQuantity]

ALTER TABLE [dbo].[InvBatchLocation] ADD CONSTRAINT [DF_InvBatchLocation_Price] DEFAULT ((0.00)) FOR [Price]