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

ProductDefaultSettingsKey

System generated primary key of the table.

VarWChar

50

AllowFractionalQuantity

Flag to check whether fractional quantity is allowed or not

Boolean

1

DiscountsAllowed

Flag to check whether discount is allowed or not

Boolean

1

HasUpsells

Flag to specify whether any Up Sell products have been defined for the current Product

Boolean

1

HasAlternateProducts

Flag to specify whether any Alternate products have been defined for the current Product

Boolean

1

HasWarrantyAvailable

Value is True if the Warranty on the product is available

Boolean

1

IsBatchTracked

Flag to check whether the product is batch tracked or not

Boolean

1

IsExchangable

Flag to check whether the product is exchangable or not

Boolean

1

IsNonStock

Flag to check whether the product has stock or not

Boolean

1

IsRefundable

Flag to check whether the product is refundable or not

Boolean

1

IsRentable

Value is True if the product can be rented

Boolean

1

IsSaleable

Flag to check whether the product is saleable or not

Boolean

1

IsSerialTracked

Flag to check whether the product is serial tracked or not

Boolean

1

IsWeighed

Flag to check whether the product is weighed or not

Boolean

1

IsKit

Flag to check whether the product is a kit or not

Boolean

1

IsAssembly

Flag to check whether the product is an assembly or not

Boolean

1

CanLayaway

Flag to check whether the product can be put on layaway or not

Boolean

1

CanOrder

Flag to check whether the product can be put on a special order or not

Boolean

1

IsOnHold

Flag to check whether the product is on hold or not

Boolean

1

IsTaxExempt

Flag to check whether the product is tax exempted or not

Boolean

1

IsOpenPrice

Flag to check whether the product price can be changed or not

Boolean

1

IsOpenDescription

Flag to check whether the product description can be changed or not

Boolean

1

IsInclusiveTaxed

Flag to check whether the product is tax inlclusive or not

Boolean

1

DefaultQuantity

Refers to the default quantity of the product

Numeric

9 (20,4)

RequireAgeVerification

Flag to check whether the product requires age verification or not

Boolean

1

IsGiftCertificate

Value is True if the product can be used as Gift Certificate

Boolean

1

IsZeroValue

Flag to check whether the product can be sold at a zero value or not

Boolean

1

IsPurchasable

Flag to check whether the product is purchasable or not

Boolean

1

IsMatrixItem

Flag to check whether the product is Matrix Parent Product or not.

Boolean

1

IsMatrixChildItem

Flag to check whether the product is variant or child item.

Boolean

1

IsTwoDimensionalMatrixItem

Flag to check whether the product supports 2D attributes.

Boolean

1

PriceOverrideAllowed

Flag to check whether the product prices can be changed at the POS

Boolean

1

ExpiryMessageDays

Show message before Number of days of the product expiry

Integer

4

CanRefundExpiredItem

Flag to check whether the expired batch/serial for the product can be refunded or not

Boolean

1

LoyaltyPointsRedeemable

Value is true if the Loyalty Points on this product can be redeemed

Boolean

1

IsStoreCredit

Value is true if the gift certificate to be used as the Store Credit.

Boolean

1

IgnoreDiscountItemsForSaleDiscount

Value is true if the item is to be ignored for Sale level discount when already discounted.

Boolean

1

SaleDiscountsAllowed

Value is true if the Sale Discount is allowed for this product

Boolean

1

HasPackageGroup

Value is true if product is a part of package

Boolean

1

AutoSelectSerialBatchType

Value is true is the Batch / Serial needs to be selected automatically

Integer

4

UsePriceEmbeddedBarcode

Value is True is the product Barcode has price embedded

Boolean

1

MustSwipeCard

This falg is specific for the Gift Card Setting. If this is true then the gift card must be swiped and user is not allowed to key the number manually at the POS

Boolean

1

DiscountsGroupAllowed

Value is true if the Discount group is allowed

Boolean

1

IsEBTItem

Indicates that this item is eligible for EBT

Boolean

1

MinAge

Stores the min age for the product purchase

Integer

4

ReturnDays

Stores the no of return days for a product

Integer

4

Index

Description

Primary

Unique

PK__InvProdu__7B0B18CC7DA38D70

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvProductDefaultSettings](

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

[AllowFractionalQuantity] [bit] NOT NULL,

[DiscountsAllowed] [bit] NOT NULL,

[HasUpsells] [bit] NOT NULL,

[HasAlternateProducts] [bit] NOT NULL,

[HasWarrantyAvailable] [bit] NOT NULL,

[IsBatchTracked] [bit] NOT NULL,

[IsExchangable] [bit] NOT NULL,

[IsNonStock] [bit] NOT NULL,

[IsRefundable] [bit] NOT NULL,

[IsRentable] [bit] NOT NULL,

[IsSaleable] [bit] NOT NULL,

[IsSerialTracked] [bit] NOT NULL,

[IsWeighed] [bit] NOT NULL,

[IsKit] [bit] NOT NULL,

[IsAssembly] [bit] NOT NULL,

[CanLayaway] [bit] NOT NULL,

[CanOrder] [bit] NOT NULL,

[IsOnHold] [bit] NOT NULL,

[IsTaxExempt] [bit] NOT NULL,

[IsOpenPrice] [bit] NOT NULL,

[IsOpenDescription] [bit] NOT NULL,

[IsInclusiveTaxed] [bit] NOT NULL,

[DefaultQuantity] [decimal](20, 4) NOT NULL,

[RequireAgeVerification] [bit] NOT NULL,

[IsGiftCertificate] [bit] NULL,

[IsZeroValue] [bit] NOT NULL,

[IsPurchasable] [bit] NOT NULL,

[IsMatrixItem] [bit] NOT NULL,

[IsMatrixChildItem] [bit] NOT NULL,

[IsTwoDimensionalMatrixItem] [bit] NOT NULL,

[PriceOverrideAllowed] [bit] NOT NULL,

[ExpiryMessageDays] [int] NOT NULL,

[CanRefundExpiredItem] [bit] NOT NULL,

[LoyaltyPointsRedeemable] [bit] NOT NULL,

[IsStoreCredit] [bit] NOT NULL,

[IgnoreDiscountItemsForSaleDiscount] [bit] NOT NULL,

[SaleDiscountsAllowed] [bit] NOT NULL,

[HasPackageGroup] [bit] NOT NULL,

[AutoSelectSerialBatchType] [int] NULL,

[UsePriceEmbeddedBarcode] [bit] NOT NULL,

[MustSwipeCard] [bit] NOT NULL,

[DiscountsGroupAllowed] [bit] NOT NULL,

[IsEBTItem] [bit] NULL,

[MinAge] [int] NULL,

[ReturnDays] [int] NULL,

CONSTRAINT [PK__InvProdu__7B0B18CC7DA38D70] PRIMARY KEY CLUSTERED

(

[ProductDefaultSettingsKey] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]