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

InventoryTransactionSurchargeKey

Primary Key

VarWChar

50

SurchargeKey

Reference key of the surcharge. See also Surcharge

VarWChar

50

CommentKey

Reference key of the comment. See also Comment

VarWChar

50

SourceType

Transaction type on which surcharge is applied

Integer

4

SourceKey

Reference key of the source document

VarWChar

50

TaxCodeKey

Reference key of the applicable tax code. See also Tax

VarWChar

50

TaxRate

Refers to the tax rate

Numeric

9 (20,5)

AmountType

Specifies whether amount has been defined in amount or precentage.

Valid values are:

Amount = 0

Percentage = 1

Integer

4

AmountPercent

Refers to the amount percent

Numeric

9 (20,5)

Amount

Refers to the amount value

Numeric

9 (20,5)

DiscountType

Specifies whether discount has been defined in amount or precentage.

Valid values are:

None = 0

Amount = 1

Percentage = 2

Integer

4

DiscountAmount

Refers to the discount percent

Numeric

9 (20,5)

DiscountPercent

Refers to the discount amount value

Numeric

9 (20,5)

TotalAfterDiscount

Refers to the total after the discount has been applied

Numeric

9 (20,5)

TaxableDiscountAmount

Amount on which the tax would be applied taking into account line level and document level discount

Numeric

9 (20,5)

StoreTaxableDiscountAmount

For future use

Numeric

9 (20,5)

Tax

Refers to the tax amount calculated

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

Total sucharge amount

Numeric

9 (20,5)

IsBaseDocumentSurcharge

Flag which specifies whether this surcharge has been refunded or accepted

Boolean

1

Status

Surcharge status.

Valid values are:

Active = 0

Cancelled = 1

Integer

4

LoadOnItemCost

Specifies if the surcharge is to be loaded on the item cost while calculating the average item cost.

Boolean

1

CurrencyKey

Reference key for the Currency. See Currency.

VarWChar

50

((0))

Comments

Stores comments.

VarWChar

4000

Index

Description

Primary

Unique

PK_InvInventoryTransactionSurcharge

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvTransactionSurcharge](

[InventoryTransactionSurchargeKey] [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,

[IsBaseDocumentSurcharge] [bit] NOT NULL,

[Status] [int] NOT NULL,

[LoadOnItemCost] [bit] NULL,

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

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

CONSTRAINT [PK_InvInventoryTransactionSurcharge] PRIMARY KEY CLUSTERED

(

[InventoryTransactionSurchargeKey] 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].[InvTransactionSurcharge] ADD CONSTRAINT [DF_InvTransactionSurcharge_CurrencyKey] DEFAULT ((0)) FOR [CurrencyKey]