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

GiftCertificateKey

Primary key

VarWChar

50

TransactionKey

Reference Key of Transaction. See also Transaction

VarWChar

50

TransactionGiftCertificateKey

Reference Key of Transaction Gift Cetificate. See also Transaction Gift Cetificate

VarWChar

50

ProductKey

Refers to the product. See also Product

VarWChar

50

CustomerKey

Reference key of customer. Also see Customer

VarWChar

50

SerialNumberKey

Stores the SerialKey of the Serial Number of the Gift Certificate

VarWChar

50

Price

Stiores the Price of the Gift Certificate

Numeric

9 (20,5)

Quantity

Stores the Quantity of the Gift Certificate

Numeric

9 (20,5)

Total

Stores the total value of the Gift Certificate

Numeric

9 (20,5)

BalanceAmount

Stores the balance amount of the used gift certificate

Numeric

9 (20,5)

ValidDate

Stores the value for number of days the Gift certificate is valid

DBTimeStamp

4

IssueDate

Stores the Date on which the Gift Certificate is issued.

DBTimeStamp

4

IssueStoreKey

Stores the Store Key from where the Gift certificate is issued.

VarWChar

50

Status

Stores the status of Gift ceritifcate

Valid values are

Active = 0

Redeemed = 1

Hold = 2

Expired = 3

Lost = 4

Integer

4

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

SerialNumber

Stores the Serial Number of the issued Gift certificate

VarWChar

50

SubsidiaryKey

Reference key of the Subsidiary. See also Subsidiary

VarWChar

50

((0))

Index

Description

Primary

Unique

PK_PmtGiftCertificate

Database Object

Object Type

Description

Dep Level

BarCodeResolution

Stored Procedure

1

ExecuteInventoryItemLogUpdate

Stored Procedure

2

GiftCertificateUpdate

Stored Procedure

1

TrxCompleteTransactionUpdates

Stored Procedure

2

TrxInventoryUpdateCheckNegativeInventory

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[PmtGiftCertificate](

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

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

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

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

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

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

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

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

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

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

[ValidDate] [datetime] NOT NULL,

[IssueDate] [datetime] NOT NULL,

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

[Status] [int] 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,

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

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

CONSTRAINT [PK_PmtGiftCertificate] PRIMARY KEY CLUSTERED

(

[GiftCertificateKey] 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].[PmtGiftCertificate] ADD CONSTRAINT [DF_PmtGiftCertificate_SubsidiaryKey] DEFAULT ((0)) FOR [SubsidiaryKey]