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

TransactionPaymentKey

Value is the system generated key of the transaction payment.

VarWChar

50

TransactionKey

Value is key of the transaction to which this payment has been applied. See also Transaction

VarWChar

50

PaymentTypeKey

Value is the payment type key.See also Payment Type

VarWChar

50

TenderType

Value is the tender type of the payment.

VarWChar

50

DetailKey

For future use

VarWChar

50

DetailType

For future use

Integer

4

Amount

Total amount paid using this payment type

Numeric

9 (20,5)

ChangeAmount

Value is the change amount

Numeric

9 (20,5)

CashBackAmount

Value is the cash back amount to be given back to customer.

Numeric

9 (20,5)

Name

Value is the name of the customer.

VarWChar

50

ExpirationDate

Value is the expiry date of the credit card or debit card or voucher depending on the tender type used

DBTimeStamp

4

ZipCode

Value is the zipcode of customer

VarWChar

50

AccountType

Value is the card type .

Integer

4

Address

Value is the customer address in case of the credit card.

VarWChar

50

City

Value is the customer address city in case of the credit card.

VarWChar

50

State

Value is the customer address state in case of the credit card.

VarWChar

50

CurrencyKey

Refernce key of currency, in which payment would be accepted

VarWChar

50

ExchangeRateKey

Refernce key of exchange rate of foreign currency

VarWChar

50

IsVoided

Value is true if the payment has been voided.

Boolean

1

HasAuthorization

Value is true if the payment has a third party authorization attached to it.

Boolean

1

HasCardSwipe

Value is true if the customer card has been swiped and the card number has not been entered manually by pos user.

Boolean

1

AuthorizationCode

Value is the code returned from authorization.

VarWChar

50

PaymentReferenceNumber

Payment reference number provided by the third party aurhorizer, used in case of Authorized type of payments

VarWChar

50

RoundingAmount

Value is the amount by which the payment amount has been rounded.

Numeric

9 (20,5)

OriginalReferenceNumber

Original Payment reference number provided by the third party aurhorizer, used in case of Authorized type of payments for refunds

VarWChar

100

Refunded

For future use

Boolean

1

CardNumber

Last 4 digits of credit / debit cards or any other voucher etc.

VarWChar

50

ForeignCurrencyAmount

Specifies amount of foreign currency.

Numeric

9 (20,5)

((0))

DiscountAmount

Value is the amount for the discount provided on this transaction

Numeric

9 (20,5)

NetPayableAmount

Value is the net amount paid for the transaction

Numeric

9 (20,5)

CheckDueDate

Captures the due date of the payments made by check

DBTimeStamp

4

Index

Description

Primary

Unique

PK_ConTrxTransactionPayment

Database Object

Object Type

Description

Dep Level

Integration_Consolidated_TransactionPayment

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[ConTrxTransactionPayment](

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

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

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

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

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

[DetailType] [int] NULL,

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

[ChangeAmount] [numeric](20, 5) NOT NULL,

[CashBackAmount] [numeric](20, 5) NOT NULL,

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

[ExpirationDate] [datetime] NULL,

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

[AccountType] [int] NOT NULL,

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

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

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

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

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

[IsVoided] [bit] NOT NULL,

[HasAuthorization] [bit] NULL,

[HasCardSwipe] [bit] NULL,

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

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

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

[OriginalReferenceNumber] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Refunded] [bit] NULL,

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

[ForeignCurrencyAmount] [numeric](20, 5) NOT NULL,

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

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

[CheckDueDate] [datetime] NULL,

CONSTRAINT [PK_ConTrxTransactionPayment] PRIMARY KEY CLUSTERED

(

[TransactionPaymentKey] 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].[ConTrxTransactionPayment] ADD CONSTRAINT [DF_ConTrxTransactionPayment_ForeignCurrencyAmount] DEFAULT ((0)) FOR [ForeignCurrencyAmount]