iVend Database Database : ConTrxTransactionSurcharge Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

PRIMARY

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

TransactionSurchargeKey

Value is the system generated key of the transaction surcharge.

VarWChar

50

TransactionKey

Value is key of the transaction on which surcharge has been added.

VarWChar

50

SurchargeKey

Value is the surcharge key which has been added to the transaction.

VarWChar

50

CommentKey

Value is the Comment key. See also Comment

VarWChar

50

SourceType

Value is the source type against which the surcharge has been taken.

Valid values are:

Transaction = 0

SpecialOrder = 1

Layaway = 2

Rental = 3

SaleItem = 4

Payments = 6

Fulfillment =7

Integer

4

SourceKey

Value is the key of the source selected.

VarWChar

50

TaxCodeKey

Value is the key of the taxcode applied on the surcharge. See also Tax

VarWChar

50

TaxRate

Value is the tax rate applied for tax calculation of surcharge.

Numeric

9 (20,5)

AmountType

Amount type.

Valid values are:

Amount = 0

Percentage = 1

Integer

4

AmountPercent

Value is the applied surcharge percentage.

Numeric

9 (20,5)

Amount

Value is the amount of surcharge applicable.

Numeric

9 (20,5)

DiscountType

Discount type applicable.

Valid values are:

None = 0

Amount = 1

Percent = 2

Integer

4

DiscountAmount

Value is the discount amount deducted from the surcharge amount on the transaction.

Numeric

9 (20,5)

DiscountPercent

Value is discount percent applied on the surcharge.

Numeric

9 (20,5)

TotalAfterDiscount

Value is the total discouted surcharge amount.

Numeric

9 (20,5)

TaxableDiscountAmount

For future use.

Numeric

9 (20,5)

StoreTaxableDiscountAmount

For future use.

Numeric

9 (20,5)

Tax

Value is the tax amount applied on the surcharge.

Numeric

9 (20,5)

PostTaxDiscount

For future use.

Numeric

9 (20,5)

PostTaxDiscountLiability

For future use.

Numeric

9 (20,5)

PostTaxDiscountStoreLiability

For future use.

Numeric

9 (20,5)

Total

Value is the surcharge total.

Numeric

9 (20,5)

IsRefund

Value is true If the surcharge with the order item has been refunded.

Boolean

1

Status

Value is the current status of the surcharge.

Valid values are:

Active = 0

Cancelled = 1

Integer

4

PayInAdvance

value is true if the surcharge is marked to be paid in advance.

Boolean

1

IsNewSurcharge

Value is true if the transaction has been edited and new surcharge has been added.

Boolean

1

IsPaymentDiscountReversalSurcharge

Value is True if the Surcharge can be used as Surcharge while doing the payment for the Reversal of the Transaction

Boolean

1

((0))

Comments

VarWChar

4000

Index

Description

Primary

Unique

PK_ConTrxTransactionSurcharge

Database Object

Object Type

Description

Dep Level

Integration_Consolidated_TransactionSurcharge

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[ConTrxTransactionSurcharge](

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

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

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

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

[SourceType] [int] NULL,

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

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

[TaxRate] [decimal](20, 5) NULL,

[AmountType] [int] NULL,

[AmountPercent] [decimal](20, 5) NULL,

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

[DiscountType] [int] NULL,

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

[DiscountPercent] [decimal](20, 5) NULL,

[TotalAfterDiscount] [decimal](20, 5) NULL,

[TaxableDiscountAmount] [decimal](20, 5) NULL,

[StoreTaxableDiscountAmount] [decimal](20, 5) NULL,

[Tax] [decimal](20, 5) NULL,

[PostTaxDiscount] [decimal](20, 5) NULL,

[PostTaxDiscountLiability] [decimal](20, 5) NULL,

[PostTaxDiscountStoreLiability] [decimal](20, 5) NULL,

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

[IsRefund] [bit] NULL,

[Status] [int] NULL,

[PayInAdvance] [bit] NULL,

[IsNewSurcharge] [bit] NULL,

[IsPaymentDiscountReversalSurcharge] [bit] NULL,

[Comments] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

CONSTRAINT [PK_ConTrxTransactionSurcharge] PRIMARY KEY CLUSTERED

(

[TransactionSurchargeKey] 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].[ConTrxTransactionSurcharge] ADD CONSTRAINT [DF_ConTrxTransactionSurcharge_IsPaymentDiscountReversalSurcharge] DEFAULT ((0)) FOR [IsPaymentDiscountReversalSurcharge]