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

PaymentTypeAttributeKey

Primary Key

VarWChar

50

PaymentTypeKey

Reference key of Payment type. See also PaymentType

VarWChar

50

Id

Attribute Id

VarWChar

20

Description

Attribute Description

VarWChar

100

Type

Type of the attribute defined

Valid values are:

String = 0

Numeric = 1

DateTime = 2

Boolean = 3

Integer

4

IsRequired

Whether this attribute is mandatory to be entered at the time of payment collection

Boolean

1

MinimumStringLength

Minimum string length that needs to be entered

Integer

4

MaximumStringLength

Maximum string length that needs to be entered

Integer

4

MinimumNumericValue

Minimum numeric value that needs to be entered

Numeric

9 (20,5)

MaximumNumericValue

Maximum numeric value that needs to be entered

Numeric

9 (20,5)

MinimumDate

Minimum Date value that needs to be entered

DBTimeStamp

4

MaximumDate

Maximum Date value that needs to be entered

DBTimeStamp

4

BooleanValue

Default boolean value

Boolean

1

IsActive

Whether this attrbute is active or not

Boolean

1

DefaultValue

Default value for the attribute

VarWChar

255

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

IsMasked

Value is true if the Payment Type is Masked.

Boolean

1

((0))

Index

Description

Primary

Unique

PK_PmtPaymentTypeAttribute

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[PmtPaymentTypeAttribute](

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

[PaymentTypeKey] [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 NOT NULL,

[Type] [int] NOT NULL,

[IsRequired] [bit] NOT NULL,

[MinimumStringLength] [int] NOT NULL,

[MaximumStringLength] [int] NOT NULL,

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

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

[MinimumDate] [datetime] NOT NULL,

[MaximumDate] [datetime] NOT NULL,

[BooleanValue] [bit] NOT NULL,

[IsActive] [bit] NOT NULL,

[DefaultValue] [nvarchar](255) 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,

[IsMasked] [bit] NULL,

CONSTRAINT [PK_PmtPaymentTypeAttribute] PRIMARY KEY CLUSTERED

(

[PaymentTypeAttributeKey] 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].[PmtPaymentTypeAttribute] ADD CONSTRAINT [DF__PmtPaymen__IsMas__44F51FF9] DEFAULT ((0)) FOR [IsMasked]