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

GiftCertificateLogKey

Primary Key

VarWChar

50

GiftCertificateKey

Reference Key of Gift Certificate. See also Gift Certificate.

VarWChar

50

SerialNumberKey

Stores the SerialKey of the Serial Number of the Gift Certificate

VarWChar

50

SourceType

Stores the Gift certificate Type <

valid values are

None = 0

Sale = 1

Reedmed = 2

Recharge = 3

CashBack = 4

Integer

4

SourceKey

Stores the Source key based on the Source type chosen

VarWChar

50

SourceDetailKey

Refers to the key of the sourceType of the transaction.

VarWChar

50

Amount

Stores the amount of the gift certificate used

Numeric

9 (20,5)

LogDate

Value is the date for the log

DBTimeStamp

4

(getdate())

IsProcessed

Value is true if the Gift Certificate has been processed.

Boolean

1

((0))

Index

Description

Primary

Unique

PK_PmtGiftCertificateLog

Database Object

Object Type

Description

Dep Level

ExecuteInventoryItemLogUpdate

Stored Procedure

1

GiftCertificateUpdate

Stored Procedure

1

vwAnalytics_GiftCertificates

View

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[PmtGiftCertificateLog](

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

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

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

[SourceType] [int] NOT NULL,

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

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

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

[LogDate] [datetime] NULL,

[IsProcessed] [bit] NULL,

CONSTRAINT [PK_PmtGiftCertificateLog] PRIMARY KEY CLUSTERED

(

[GiftCertificateLogKey] 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].[PmtGiftCertificateLog] ADD CONSTRAINT [DF_PmtGiftCertificateLog_LogDate] DEFAULT (getdate()) FOR [LogDate]

ALTER TABLE [dbo].[PmtGiftCertificateLog] ADD CONSTRAINT [DF__PmtGiftCe__IsPro__2917FB5A] DEFAULT ((0)) FOR [IsProcessed]