iVend Database Database : InvProductCostUpdateLog 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

ProductCostUpdateLogKey

System generated Primary key of the table.

VarWChar

50

InventoryItemLogKey

Reference key of inventory item log.

VarWChar

50

ProductKey

Reference key of product.

VarWChar

50

UpdatedCost

Stores the updated cost for the product

Numeric

9 (20,5)

TimeStamp

Value is the date time for the log

DBTimeStamp

4

SubsidiaryKey

Reference key of the Subsidiary. See also Subsidiary

VarWChar

50

((0))

Index

Description

Primary

Unique

PK_InvProductCostUpdateLog

Database Object

Object Type

Description

Dep Level

InventoryItemQuantityUpdates

Stored Procedure

1

TrxCompleteTransactionUpdates

Stored Procedure

2

UpdateInventoryCost

Stored Procedure

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

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvProductCostUpdateLog](

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

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

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

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

[TimeStamp] [datetime] NULL,

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

CONSTRAINT [PK_InvProductCostUpdateLog] PRIMARY KEY CLUSTERED

(

[ProductCostUpdateLogKey] 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].[InvProductCostUpdateLog] ADD CONSTRAINT [DF_InvProductCostUpdateLog_SubsidiaryKey] DEFAULT ((0)) FOR [SubsidiaryKey]