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

SurchargeSourceType

Stores the Surcharge Source Type.

Valid Values are :

None = 0,

Sale = 1,

Fulfillment = 2

Integer

4

((0))

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))

ExchangeRate

Stores the Exchange rate for the Currency used in Transaction

Numeric

9 (20,5)

((1))

TotalEC

Stores the Enterprise Currency for the Total of Transaction

Numeric

9 (38,7)

([Total]*[ExchangeRate])

AmountEC

Stores the Enterprise Currency for the Transaction Amount

Numeric

9 (38,7)

([Amount]*[ExchangeRate])

TaxEC

Stores the Enterprise Currency for the Tax on transaction.

Numeric

9 (38,7)

([Tax]*[ExchangeRate])

Comments

Stores comments

VarWChar

4000

Index

Description

Primary

Unique

IX_TrxTransactionSurcharge

PK_TrxTransactionSurcharge

Database Object

Object Type

Description

Dep Level

Integration_TransactionSurcharge

Stored Procedure

1

TrxCompleteTransactionUpdates

Stored Procedure

2

TrxGenerateLayawayInstallments

Stored Procedure

Generates Layaway installments for the Layaway transaction

1

TrxInventoryUpdateLaybyCancellationItem

Stored Procedure

1

TrxInventoryUpdateLaybyItem

Stored Procedure

2

TrxInventoryUpdateOrder

Stored Procedure

Handles updates related to Order item

1

TrxInventoryUpdateQuotation

Stored Procedure

Handles updates related to Quotation item

1

TrxUpdateCustomerBalance

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[TrxTransactionSurcharge](

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

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

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

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

[SourceType] [int] NOT NULL,

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

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

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

[AmountType] [int] NOT NULL,

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

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

[DiscountType] [int] NOT NULL,

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

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

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

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

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

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

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

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

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

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

[IsRefund] [bit] NOT NULL,

[Status] [int] NOT NULL,

[PayInAdvance] [bit] NOT NULL,

[IsNewSurcharge] [bit] NOT NULL,

[SurchargeSourceType] [int] NULL,

[IsPaymentDiscountReversalSurcharge] [bit] NULL,

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

[TotalEC] AS ([Total]*[ExchangeRate]),

[AmountEC] AS ([Amount]*[ExchangeRate]),

[TaxEC] AS ([Tax]*[ExchangeRate]),

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

CONSTRAINT [PK_TrxTransactionSurcharge] 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].[TrxTransactionSurcharge] ADD CONSTRAINT [DF__TrxTransa__Surch__41C3AD93] DEFAULT ((0)) FOR [SurchargeSourceType]

ALTER TABLE [dbo].[TrxTransactionSurcharge] ADD CONSTRAINT [DF_TrxTransactionSurcharge_IsPaymentDiscountReversalSurcharge] DEFAULT ((0)) FOR [IsPaymentDiscountReversalSurcharge]

ALTER TABLE [dbo].[TrxTransactionSurcharge] ADD CONSTRAINT [DF_TrxTransactionSurcharge_ExchangeRate] DEFAULT ((1)) FOR [ExchangeRate]