iVend Database Database : PmtPaymentType Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

PRIMARY

System Object

Published for Replication

Rows

8

Data Space Used

8.00 KB

Index Space Used

8.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

PaymentTypeKey

Primary Key

VarWChar

50

Id

Unique id for payment type

VarWChar

20

Description

Description for payment type

VarWChar

100

DisplayOrder

Specifies the display order in which the payment types would be displayed at the POS in the payments screen

Integer

4

Type

Specifies the tender type for the payment type.

Valid values are:

Cash = 0

CreditCard = 1

DebitCard = 2 OnAccount = 4

Check = 5

TravellersCheck = 6

Voucher = 8

Custom = 9

Integer

4

AllowOverTender

Check for allowing over-tender

Boolean

1

OverTenderRateType

Over tender rate type.

Valid values are:

Amount = 0

Percentage = 1

Integer

4

OverTenderRate

Rate of over-tender

Numeric

9 (20,5)

DefaultAmount

Default amount for making the payment at POS

Numeric

9 (20,5)

MaxAmount

Maximum amount accepted through this payment type

Numeric

9 (20,5)

MinAmount

Minimum amount accepted through this payment type

Numeric

9 (20,5)

IsCounted

Check for the payment type is countable or not

Boolean

1

CountType

If the IsCounted flag is TRUE, then this field contains the type of counting to be done.

Valid values are:

None = 0

Summary = 1

Detail = 2

Integer

4

Franked

For future use

Boolean

1

FrankingPrintFormatKey

For future use

VarWChar

50

PrintingFormatKey

For future use

VarWChar

50

PrintPaymentReceipt

Check for printing the payment receipt

Boolean

1

PrintPaymentReceiptCount

For future use

Integer

4

OpenCashDrawer

Check for opening the cash drawer at the time of receiving the payment for this tender type

Boolean

1

AffectsTippleAmount

Check for affecting the tipple point

Boolean

1

SurchargeKey

For future use

VarWChar

50

IsActive

Check for payment type is active or not

Boolean

1

IsAuthorized

Check whether this payment type requires authorization. E.g. Credit Card requires authorization

Boolean

1

RequireSignature

For future use

Boolean

1

RoundingMethodType

Define the rounding method for this payment type.

Valid values are:

NoRounding = 0

RoundToFiveHundredth = 1

RoundToTenHundredth = 2

RoundToOne = 3

Integer

4

IsRefundable

Flag for checking the payment type to be refundable

Boolean

1

CreatedBy

Reference of user who has created this record. See also Security User

VarWChar

50

Created

Date of creation of this record

DBTimeStamp

4

ModifiedBy

Reference of user who has modified this record. See also Security User

VarWChar

50

Modified

Date of last modification of this record

DBTimeStamp

4

IsDeleted

Value is True if the record has been deleted from the system. Record is always Soft Deleted

Boolean

1

IsIntegrated

Check whether any payment taken against this payment type would integrate back into the ERP system

Boolean

1

TreatAsOnAccount

Check whether to treat the custom payment type similar to On Account payment type. This option is only avaliable in case the tender type is Custom

Boolean

1

IsInformationTender

Check whether to treat the custom payment type just for information. This option is only avaliable in case the tender type is Custom and the payment type does not Integrate into the ERP system

Boolean

1

AllowPartialTender

Check for partial tendering allowed or not for Gift Certificates

Boolean

1

RequireManagerAuthorization

Value is true if the manager is required for the payment type during the transaction.

Boolean

1

((0))

RequireManagerAuthorizationForRefund

Value is True if the refund requires the manager authorization.

Boolean

1

((0))

AllowOfflineAuthorization

Not in Use

Boolean

1

CurrencyKey

Reference Key for currency

VarWChar

50

((0))

AllowUsingTestPaymentProcessor

Value is True if the test payment processor needs to used for the payment

Boolean

1

((0))

AssemblyName

Value is the assembly information i.e. the complete path where the assembly for the device is kept.

VarWChar

200

ClassName

Value is the class name which handles the device in assembly.

VarWChar

200

Location

Value is the path where the hardware assemblies can be found.

VarWChar

200

ConfigData

Store the device specific configuration information in XML format. E.g. Device Name etc

LongVarWChar

16

HideCardNumber

Value is True if the Card number has to be hidden

Boolean

1

((0))

SubsidiaryKey

Reference key of the Subsidiary. See also Subsidiary

VarWChar

50

((0))

Index

Description

Primary

Unique

PK_PmtPaymentType

Database Object

Object Type

Description

Dep Level

AssignTill

Stored Procedure

Assigns a Till to the selected POS

1

CreateTillCount

Stored Procedure

1

GetMobileReplicationData

Stored Procedure

1

Integration_ARPayment

Stored Procedure

1

Integration_Consolidated_TransactionPayment

Stored Procedure

1

Integration_TransactionPayment

Stored Procedure

1

RemoveTill

Stored Procedure

Removes a Till from the selected POS

1

TrxCompleteTransactionUpdates

Stored Procedure

1

TrxUpdateCustomerBalance

Stored Procedure

1

UpdateTillAfterPaymentInsert

Stored Procedure

Handles updates to Till once payment against a particular payment type has been taken

1

UpdateTillAmounts

Stored Procedure

Handles updates to Till once payment against a transaction has been taken

1

uspTapeReport

Stored Procedure

1

XTapeReport

Stored Procedure

Generates the XTape report for a particular till

1

ZTapeReport

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[PmtPaymentType](

[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 NULL,

[DisplayOrder] [int] NOT NULL,

[Type] [int] NOT NULL,

[AllowOverTender] [bit] NOT NULL,

[OverTenderRateType] [int] NOT NULL,

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

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

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

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

[IsCounted] [bit] NOT NULL,

[CountType] [int] NOT NULL,

[Franked] [bit] NOT NULL,

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

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

[PrintPaymentReceipt] [bit] NOT NULL,

[PrintPaymentReceiptCount] [int] NOT NULL,

[OpenCashDrawer] [bit] NOT NULL,

[AffectsTippleAmount] [bit] NOT NULL,

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

[IsActive] [bit] NOT NULL,

[IsAuthorized] [bit] NOT NULL,

[RequireSignature] [bit] NOT NULL,

[RoundingMethodType] [int] NOT NULL,

[IsRefundable] [bit] NOT NULL,

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

[Created] [datetime] NOT NULL,

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

[Modified] [datetime] NOT NULL,

[IsDeleted] [bit] NOT NULL,

[IsIntegrated] [bit] NOT NULL,

[TreatAsOnAccount] [bit] NOT NULL,

[IsInformationTender] [bit] NOT NULL,

[AllowPartialTender] [bit] NULL,

[RequireManagerAuthorization] [bit] NOT NULL,

[RequireManagerAuthorizationForRefund] [bit] NOT NULL,

[AllowOfflineAuthorization] [bit] NULL,

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

[AllowUsingTestPaymentProcessor] [bit] NOT NULL,

[AssemblyName] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ClassName] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Location] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ConfigData] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[HideCardNumber] [bit] NOT NULL,

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

CONSTRAINT [PK_PmtPaymentType] PRIMARY KEY CLUSTERED

(

[PaymentTypeKey] ASC

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

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

ALTER TABLE [dbo].[PmtPaymentType] ADD CONSTRAINT [DF_PmtPaymentType_RequireManagerAuthorization] DEFAULT ((0)) FOR [RequireManagerAuthorization]

ALTER TABLE [dbo].[PmtPaymentType] ADD CONSTRAINT [DF_PmtPaymentType_RequireManagerAuthorizationForRefund] DEFAULT ((0)) FOR [RequireManagerAuthorizationForRefund]

ALTER TABLE [dbo].[PmtPaymentType] ADD CONSTRAINT [DF_PmtPaymentType_CurrencyKey] DEFAULT ((0)) FOR [CurrencyKey]

ALTER TABLE [dbo].[PmtPaymentType] ADD CONSTRAINT [DF_PmtPaymentType_AllowUsingTestPaymentProcessor] DEFAULT ((0)) FOR [AllowUsingTestPaymentProcessor]

ALTER TABLE [dbo].[PmtPaymentType] ADD CONSTRAINT [DF_PmtPaymentType_HideCardNumber] DEFAULT ((0)) FOR [HideCardNumber]

ALTER TABLE [dbo].[PmtPaymentType] ADD CONSTRAINT [DF_PmtPaymentType_SubsidiaryKey] DEFAULT ((0)) FOR [SubsidiaryKey]