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

ProductCostAuditKey

Primary Key

VarWChar

50

ProductCostKey

Reference Key for Product Cost

VarWChar

50

EffectiveDate

Date on which the costing will be applicable

DBTimeStamp

4

Cost

Stores the Cost of the Product

Numeric

9 (20,5)

OperationType

Add, Edit, Delete

Integer

4

UserKey

Stores the User Key who created the record

VarWChar

50

CreatedDate

Value is the Date on which the Audit has been performed

DBTimeStamp

4

Index

Description

Primary

Unique

PK_InvProductCostAudit

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvProductCostAudit](

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

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

[EffectiveDate] [datetime] NULL,

[Cost] [numeric](20, 5) NULL,

[OperationType] [int] NULL,

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

[CreatedDate] [datetime] NULL,

CONSTRAINT [PK_InvProductCostAudit] PRIMARY KEY CLUSTERED

(

[ProductCostAuditKey] ASC

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

) ON [PRIMARY]