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

TransactionLostItemKey

Primary Key for the table

VarWChar

50

TransactionKey

Reference Key of Transaction. See also Transaction

VarWChar

50

WarehouseKey

The warehouse associated with the store. See also Warehouse

VarWChar

50

ProductKey

Reference key of the product. See also Product

VarWChar

50

InventoryItemKey

Reference Key of InventoryItem. See also Inventory Item

VarWChar

50

Description

Specifies whether the line item has a valid serial number attached to it

VarWChar

100

HasDiscounts

Specifies whether any discounts have been applied on the line item

Boolean

1

TaxCodeKey

Reference Key of TaxCode if given at the line-level. See also Tax

VarWChar

50

TaxRate

The rate of the TaxCode

Numeric

9 (20,5)

HasTaxCodeOverride

This flag checks if the tax code has been overrided by the user

Boolean

1

OriginalPrice

The original price of the sale item

Numeric

9 (20,5)

BasePrice

The price which is tax exclusive

Numeric

9 (20,5)

Price

The overriden price of the sale item

Numeric

9 (20,5)

PriceSource

Value is the price source of the order item.

Valid values are:

None = 0

System = 1

Manual = 2

Integer

4

Quantity

Quantity of the line item

Numeric

9 (20,5)

OpenQuantity

The quantity which remains to be fulfilled (in case of fulfillment attached)

Numeric

9 (20,5)

FullfilledQuantity

The actual quantity that has been fulfilled/delivered (in case of fulfillment attached)

Numeric

9 (20,5)

RefundedQuantity

The quantity which has been refunded

Numeric

9 (20,5)

SubTotal

This amount is the BasePrice * Quantity

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 applied to the line item.

Numeric

9 (20,5)

DiscountPercent

The % of discount been given at the line-level

Numeric

9 (20,5)

SaleDiscountAmount

The discount amount applicable to the sale-level

Numeric

9 (20,5)

ExclusiveDiscountPercent

Discount percentage applied on the Line item on exclusive price

Numeric

9 (20,5)

TaxableDiscountAmount

For future use

Numeric

9 (20,5)

StoreTaxableDiscountAmount

For future use

Numeric

9 (20,5)

Tax

Tax of the line-level item

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 total amount of the line item.

Numeric

9 (20,5)

TotalBeforeSaleDiscount

Value is the total amount before any sale discount had been applied.

Numeric

9 (20,5)

TotalPostSaleDiscount

Value is the total amount after any sale discount applied.

Numeric

9 (20,5)

CommentKey

Refers to the comment key. See also Comment

VarWChar

50

HasDiscountOverride

This flag checks if the discounts has been overrided by the user

Boolean

1

TotalTaxableAmount

Stores the amount on which the tax would be calculated

Numeric

9 (20,5)

((0))

IsTaxInclusive

This setting is copied from product setup while doing the transaction. Setting specifies if the item is marked as TaxInclusive item.

Boolean

1

((0))

IgnoreDiscountItemsForSaleDiscount

Value is true if the sale discount should not be applied on already discounted items.

Boolean

1

((0))

UOMQuantity

Stores the UOM quantity

Numeric

9 (20,5)

UOMBaseQuantity

Stores the Base UOM quantity

Numeric

9 (20,5)

UOMGroupDetailKey

Reference Key for the UOM Group Detail

VarWChar

50

ScannedBarcode

Stores the current Scanned Barcode value

VarWChar

50

ScannedBarcodeSource

Value is the source from where the product barcode has been entered. The valid values are:

BarcodeScan = 0,

ManualScan = 1,

Upsell = 2,

Promotion =3,

ProductSearch =4,

AlternateProductView= 5

Integer

4

((0))

ExchangeRate

Stores the Exchange rate for the Currency for the lost item

Numeric

9 (20,5)

((1))

Comments

Stores comments

VarWChar

4000

Index

Description

Primary

Unique

IX_TrxTransactionLostSaleItem

PK_TrxTransactionLostSaleItem

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[TrxTransactionLostSaleItem](

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

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

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

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

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

[Description] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[HasDiscounts] [bit] NOT NULL,

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

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

[HasTaxCodeOverride] [bit] NOT NULL,

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

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

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

[PriceSource] [int] NOT NULL,

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

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

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

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

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

[DiscountType] [int] NOT NULL,

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

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

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

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

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

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

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

[HasDiscountOverride] [bit] NOT NULL,

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

[IsTaxInclusive] [bit] NOT NULL,

[IgnoreDiscountItemsForSaleDiscount] [bit] NOT NULL,

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

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

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

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

[ScannedBarcodeSource] [int] NULL,

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

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

CONSTRAINT [PK_TrxTransactionLostSaleItem] PRIMARY KEY CLUSTERED

(

[TransactionLostItemKey] 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].[TrxTransactionLostSaleItem] ADD CONSTRAINT [DF_TrxTransactionLostSaleItem_TotalTaxableAmount] DEFAULT ((0)) FOR [TotalTaxableAmount]

ALTER TABLE [dbo].[TrxTransactionLostSaleItem] ADD CONSTRAINT [DF_TrxTransactionLostSaleItem_IsTaxInclusive] DEFAULT ((0)) FOR [IsTaxInclusive]

ALTER TABLE [dbo].[TrxTransactionLostSaleItem] ADD CONSTRAINT [DF_TrxTransactionLostSaleItem_IgnoreDiscountItemsForSaleDiscount] DEFAULT ((0)) FOR [IgnoreDiscountItemsForSaleDiscount]

ALTER TABLE [dbo].[TrxTransactionLostSaleItem] ADD CONSTRAINT [DF_TrxTransactionLostSaleItem_ScannedBarcodeSource] DEFAULT ((0)) FOR [ScannedBarcodeSource]

ALTER TABLE [dbo].[TrxTransactionLostSaleItem] ADD CONSTRAINT [DF_TrxTransactionLostSaleItem_ExchangeRate] DEFAULT ((1)) FOR [ExchangeRate]