iVend Database Database : InvWarehouse Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

5

Data Space Used

8.00 KB

Index Space Used

8.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

WarehouseKey

System generated Primary key of the table.

VarWChar

50

Id

Refers to the warehouse's Id.

VarWChar

20

Description

Refers to the warehouse's description.

VarWChar

100

AddressKey

Refers to the address of the warehouse.See also Address

VarWChar

50

SalesTaxCodeKey

Refers to the sales tax code. See also Tax

VarWChar

50

PurchaseTaxCodeKey

Refers to the purchase tax code. See also Tax

VarWChar

50

AccountingID

Maps to the unique id of the ERP system

VarWChar

50

PriceListKey

Reference key of the Price List which is applicable at the Warehouse. See also Price List

VarWChar

50

BranchCode

Refers to the branch code of the warehouse.

VarWChar

50

WarehouseType

Refers to the type of warehouse.

Valid values are:

General = 0

Retail = 1

InTransit = 2

Integer

4

((0))

InTransitWarehouseKey

Refers to the InTransit warehouse for the particular warehouse.

VarWChar

50

Created

Date of creation of this record

DBTimeStamp

4

CreatedBy

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

VarWChar

50

Modified

Date of last modification of this record

DBTimeStamp

4

ModifiedBy

Reference of user who has modified 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

OwnerShipType

Ownership of the warehouse.

Valid values are:

CompanyOwnedCompanyOperated = 0

CompanyOwnedDistributorOperated = 1

DistributorOwnedDistributorOperated = 2

Integer

4

InventoryStoreGroupKey

Specifies the Store Group key (stores) who have access to this warehouse

VarWChar

50

((0))

IsActive

Value is true if the warehouse is active

Boolean

1

((1))

SubsidiaryKey

Reference key of the Subsidiary. See also Subsidiary

VarWChar

50

((0))

SalesLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

((0))

RefundLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

((0))

FulfilmentLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

((0))

GoodsReceiveLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

((0))

StockTransferLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

((0))

GoodsIssueLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

((0))

GoodsReturnLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

((0))

IsLocationEnabled

Hold true if location is enabled on warehouse

Boolean

1

((0))

DefaultLocationKey

Reference Key of Location. See also InvLocation.

VarWChar

50

((0))

UseDefaultLocation

Value is True if the Default location has to be used for the warehouse.

Boolean

1

((0))

AllowNegativeInventory

Value is true if the negative inventory transactions are allowed at POS else false.

Boolean

1

((0))

Index

Description

Primary

Unique

PK_InvWarehouse

Database Object

Object Type

Description

Dep Level

BarCodeResolution

Stored Procedure

1

BatchQuantityUpdates

Stored Procedure

1

CancelStockTransfer

Stored Procedure

1

Daily_ProductCost

User Defined Function

1

DataNotification

Stored Procedure

1

ExecuteInventoryItemLogUpdate

Stored Procedure

2

Forecast

Stored Procedure

1

GetBOMQuantity

Stored Procedure

1

GetInventoryItemForStockCount

Stored Procedure

1

GetMobileReplicationData

Stored Procedure

1

GetUserRights

Stored Procedure

Gets the valid rights for the user

1

GoodsReceiptPOReport

Stored Procedure

1

Integration_ARPayment

Stored Procedure

1

Integration_Consolidated_Transaction

Stored Procedure

1

Integration_Consolidated_TransactionPayment

Stored Procedure

1

Integration_funcTransaction

User Defined Function

1

Integration_GoodsIssue

Stored Procedure

1

Integration_GoodsReceipt

Stored Procedure

1

Integration_GoodsReturn

Stored Procedure

1

Integration_InventoryItem

Stored Procedure

1

Integration_InventoryItemPrice

Stored Procedure

1

Integration_PurchaseOrder

Stored Procedure

1

Integration_StockTransfer

Stored Procedure

1

Integration_TransactionPayment

Stored Procedure

1

InventoryCount_Save

Stored Procedure

1

InventoryItemQuantityUpdates

Stored Procedure

1

InvGetAllSelectedAttributeItemsList

Stored Procedure

2

MRP

Stored Procedure

1

PurchaseOrderReport

Stored Procedure

1

ReplicationRecordsToSend

Stored Procedure

1

Rpt_ItemWithoutSale

User Defined Function

1

StockTransferReport

Stored Procedure

1

Trg_ReplicationTransactionMobile

Trigger

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

TrxCompleteTransactionUpdates

Stored Procedure

2

TrxConsolidateTransaction

Stored Procedure

1

TrxConsolidateTransactionForCreditCustomers

Stored Procedure

1

TrxInventoryUpdateCheckNegativeInventory

Stored Procedure

1

TrxUpdateCustomerBalance

Stored Procedure

1

UpdateDeliveryInformationFromSAPBusinessOne

Stored Procedure

1

UpdateInventoryCost

Stored Procedure

Used in replication to update the cost of an item if the costing method is set to enterprise

1

uspGetItemPrice

Stored Procedure

1

vw_GrossProfit

View

1

vw_InventoryCost

View

1

vw_InvInventoryItem

View

1

vw_InvProductInventoryInfo

View

1

vw_ProductCost

View

1

vwAnalytics_InventorySnapshot

View

1

vwAnalytics_MerchandiseInventoryCount

View

1

vwAnalytics_MerchandiseSales

View

1

vwAnalytics_NetSales

View

1

vwAnalytics_OpenStockTransferReceipt

View

1

vwAnalytics_OpenStockTransferRequest

View

1

vwAnalytics_Sales

View

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvWarehouse](

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

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

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

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

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

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

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

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

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

[WarehouseType] [int] NOT NULL,

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

[Created] [datetime] NOT NULL,

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

[Modified] [datetime] NOT NULL,

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

[IsDeleted] [bit] NOT NULL,

[OwnerShipType] [int] NOT NULL,

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

[IsActive] [bit] NOT NULL,

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

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

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

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

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

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

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

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

[IsLocationEnabled] [bit] NOT NULL,

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

[UseDefaultLocation] [bit] NULL,

[AllowNegativeInventory] [bit] NOT NULL,

CONSTRAINT [PK_InvWarehouse] PRIMARY KEY CLUSTERED

(

[WarehouseKey] 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].[InvWarehouse] ADD CONSTRAINT [DF_InvWarehouse_WarehouseType] DEFAULT ((0)) FOR [WarehouseType]

ALTER TABLE [dbo].[InvWarehouse] ADD CONSTRAINT [DF_InvWarehouse_InventoryStoreGroupKey] DEFAULT ((0)) FOR [InventoryStoreGroupKey]

ALTER TABLE [dbo].[InvWarehouse] ADD CONSTRAINT [DF_InvWarehouse_IsActive] DEFAULT ((1)) FOR [IsActive]

ALTER TABLE [dbo].[InvWarehouse] ADD CONSTRAINT [DF_InvWarehouse_SubsidiaryKey] DEFAULT ((0)) FOR [SubsidiaryKey]

ALTER TABLE [dbo].[InvWarehouse] ADD CONSTRAINT [DF_InvWarehouse_SalesLocationKey] DEFAULT ((0)) FOR [SalesLocationKey]

ALTER TABLE [dbo].[InvWarehouse] ADD CONSTRAINT [DF_InvWarehouse_RefundLocationKey] DEFAULT ((0)) FOR [RefundLocationKey]

ALTER TABLE [dbo].[InvWarehouse] ADD CONSTRAINT [DF_InvWarehouse_FulfilmentLocationKey] DEFAULT ((0)) FOR [FulfilmentLocationKey]

ALTER TABLE [dbo].[InvWarehouse] ADD CONSTRAINT [DF_InvWarehouse_GoodsReceiveLocationKey] DEFAULT ((0)) FOR [GoodsReceiveLocationKey]

ALTER TABLE [dbo].[InvWarehouse] ADD CONSTRAINT [DF_InvWarehouse_StockTransferLocationKey] DEFAULT ((0)) FOR [StockTransferLocationKey]

ALTER TABLE [dbo].[InvWarehouse] ADD CONSTRAINT [DF_InvWarehouse_GoodsIssueLocationKey] DEFAULT ((0)) FOR [GoodsIssueLocationKey]

ALTER TABLE [dbo].[InvWarehouse] ADD CONSTRAINT [DF_InvWarehouse_GoodsReturnLocationKey] DEFAULT ((0)) FOR [GoodsReturnLocationKey]

ALTER TABLE [dbo].[InvWarehouse] ADD CONSTRAINT [DF_InvWarehouse_IsLocationEnabled] DEFAULT ((0)) FOR [IsLocationEnabled]

ALTER TABLE [dbo].[InvWarehouse] ADD CONSTRAINT [DF_InvWarehouse_DefaultLocationKey] DEFAULT ((0)) FOR [DefaultLocationKey]

ALTER TABLE [dbo].[InvWarehouse] ADD CONSTRAINT [DF__InvWareho__UseDe__6ED64B2C] DEFAULT ((0)) FOR [UseDefaultLocation]

ALTER TABLE [dbo].[InvWarehouse] ADD CONSTRAINT [DF__InvWareho__Allow__4FB2A58E] DEFAULT ((0)) FOR [AllowNegativeInventory]