iVend Database Database : InvLocation Table

Creation Date

10/12/2015 9:16 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

LocationKey

Primary Key

VarWChar

50

Id

Specify the Id of Location

VarWChar

50

Description

Specify the Description of Location

VarWChar

100

WarehouseKey

Reference Key of Warehouse. See also InvWarehouse.

VarWChar

50

IsDefault

Value is True if the specified location is marked as default location

Boolean

1

Sales

Value is True if the specified location is marked as sales location

Boolean

1

Refund

Value is True if the specified location is marked as refund location

Boolean

1

Fulfilment

Value is True if the specified location is marked as fulfilment location

Boolean

1

GoodsReceive

Value is True if the specified location is marked as goods receive location

Boolean

1

StockTransfer

Value is True if the specified location is marked as stock transfer location

Boolean

1

LocationTransfer

Value is True if the specified location is marked as location transfer location

Boolean

1

GoodsIssue

Value is True if the specified location is marked as goods issue location

Boolean

1

GoodsReturn

Value is True if the specified location is marked as goods return location

Boolean

1

CreatedBy

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

VarWChar

50

Created

Date of creation of this record

DBTimeStamp

4

ModifiedBy

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

VarWChar

50

Modified

Date of last modification of this record

DBTimeStamp

4

IsDeleted

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

Boolean

1

Freeze

Value is True if the specified location is marked as freeze location

Boolean

1

IsActive

Value is True if the specified location is marked as Active

Boolean

1

((1))

Index

Description

Primary

Unique

PK_CfgLocation

Database Object

Object Type

Description

Dep Level

GetMobileReplicationData

Stored Procedure

1

InvGetAllSelectedAttributeItemsList

Stored Procedure

3

InvWarehouseInventoryLocation

Stored Procedure

1

ReplicationRecordsToSend

Stored Procedure

1

Rpt_ItemWithoutSale

User Defined Function

1

rptOpeningBalance_Location

User Defined Function

1

TrgSBOBatchUpdate

Trigger

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

1

TrgSBOInventoryUpdate

Trigger

Handles updates made to item inventory in the ERP system (Business One in this case)

1

TrgSBOSerialUpdate

Trigger

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

1

vw_InvInventoryItem

View

1

vw_InvProductInventoryInfo

View

2

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvLocation](

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

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

[Description] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

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

[IsDefault] [bit] NOT NULL,

[Sales] [bit] NOT NULL,

[Refund] [bit] NOT NULL,

[Fulfilment] [bit] NOT NULL,

[GoodsReceive] [bit] NOT NULL,

[StockTransfer] [bit] NOT NULL,

[LocationTransfer] [bit] NOT NULL,

[GoodsIssue] [bit] NOT NULL,

[GoodsReturn] [bit] NOT NULL,

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

[Created] [datetime] NOT NULL,

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

[Modified] [datetime] NOT NULL,

[IsDeleted] [bit] NOT NULL,

[Freeze] [bit] NULL,

[IsActive] [bit] NULL,

CONSTRAINT [PK_CfgLocation] PRIMARY KEY CLUSTERED

(

[LocationKey] 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].[InvLocation] ADD CONSTRAINT [DF__InvLocati__IsAct__783FB9D5] DEFAULT ((1)) FOR [IsActive]