iVend Database Database > Tables

Navigation: iVend Database Database > Tables >

iVend 6.6 Database Help

InvProduct Table

Collapse All Expand All

iVend Database Database : InvProduct Table

Description

Stores the product related details.

Properties

Creation Date	4/13/2015 12:00 PM
File Group	PRIMARY
Text File Group	PRIMARY
System Object
Published for Replication
Rows	1023
Data Space Used	896.00 KB
Index Space Used	216.00 KB

Columns

Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
ProductKey	System generated Primary key of the table.	VarWChar	50
Id	Refers to the product's Id	VarWChar	50
Description	Refers to the product's description	VarWChar	100
Description2	Refers to the product's short description	VarWChar	100
Description3	Refers to the product's long description	VarWChar	200
PreferedVendorKey	Refers to the vendor. Refers to the Vendor	VarWChar	50
ProductGroupKey	Refers to the group of te product. See also Product Group	VarWChar	50
SalesTaxCodeKey	Refers to the sales taxCode. See also Tax	VarWChar	50
PurchaseTaxCodeKey	Refers to the purchase taxCode. See also Tax	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	For future use	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	For future use	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)
BasePrice	Refers to the base price of the product.	Numeric	9 (20,5)
UPC	Refers to the UPC of the product.	VarWChar	100
RequireAgeVerification	Flag to check whether the product requires age verification or not	Boolean	1
MinAge	Refers to the minimum age to which the product can be sold.	Integer	4
HasImage	Flag to check whether the product has image or not	Boolean	1
ManufacturerKey	Refers to the manufacturer.See also Manufacturer	VarWChar	50
AccountingID	Maps to the unique id of the ERP system	VarWChar	50
LeadTime	Refers to the minimum time in which the product can be made available.	Integer	4
IsGiftCertificate	For future use	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
Created	Date of creation of this record	DBTimeStamp	4
CreatedBy	Reference of user who has created this record. See also Security User	VarWChar	50
Modified	Date of last modification of this record	DBTimeStamp	4
ModifiedBy	Reference of user who has modified this record. See also Security User	VarWChar	50
IsDeleted	Value is True if the record has been deleted from the system. Record is always Soft Deleted	Boolean	1
IsMatrixItem	Specifies whether the product is Matrix child item.	Boolean	1
IsMatrixChildItem	Specifies whether the product is Matrix child item.	Boolean	1
IsTwoDimensionalMatrixItem	Specifies whether the product is 2 D Matrix product	Boolean	1
ParentMartixProductKey	Reference Key of Matrix product.	VarWChar	50
DefaultExpiryPeriod	Specifies the default expiry date for the product	Integer	4
GiftCertificateType	Stores the Gift Certificate type Valid values are None = 0 Pre Printed =1 System Generated =2 User Defined =3 Email = 4	Integer	4
PriceOverrideAllowed	Value is true If the cashier would be able to change the price of the product while selling it to customer.	Boolean	1		((1))
CanSellExpiredItem	Value is true if user can sell Expired Item	Boolean	1		((1))
ExpiryMessageDays	Show message before Number of days of the product expiry	Integer	4		((0))
CanRefundExpiredItem	Value is true if the refund for the expired item can be issued	Boolean	1		((1))
LoyaltyPointsRedeemable	Value is true if the Loyalty Points on this product can be redeemed	Boolean	1		((1))
IsStoreCredit	Value is true if the gift certificate to be used as the Store Credit.	Boolean	1		((0))
MaximumOpenPrice	Stores the maximum price allowed to a user at POS to specify the price of the product during a sale.	Numeric	9 (18,5)		((0))
IgnoreDiscountItemsForSaleDiscount	Value is true if the item is to be ignored for Sale level discount when already discounted.	Boolean	1		((0))
SaleDiscountsAllowed	Value is true if the Sale Discount is allowed for this product	Boolean	1		((0))
ProductClassKey	Reference of product class key. See also Product Class	VarWChar	50
PackageGroupKey	Reference of Package Group key. See also Package group	VarWChar	50		((0))
HasPackageGroup	Value is true if product is a part of package	Boolean	1		((0))
GiftCertificatePassTemplate	Stores the Gift Certificate Pass template to be used with passbook.	VarWChar	100
GiftCertificateEmailTemplate	Stores the Gift Certificate Email template to be used with passbook.	VarWChar	100
PassDescription	Description Value is the description of the Gift Certificate for the iVend Pass.	VarWChar	28
PassValue	Stores the value of the Gift certificate for the iVend Pass.	VarWChar	10
CommentKey	Refers to the comment key. See also Comment	VarWChar	50		((0))
AutoSelectSerialBatchType	Value is True if the Serial Batch needs to be selected Automatically	Integer	4		((0))
UsePriceEmbeddedBarcode	Value is True if the Product uses the Barcode with the Price	Boolean	1		((0))
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		((0))
UOMGroupKey	Reference key of UOM group.	VarWChar	50
DiscountsGroupAllowed	Value is true if the Disconts group are allowed	Boolean	1		((1))
PurchaseUOMKey	Reference key of purchase UOM.	VarWChar	50
PurchaseUOMPackageKey	Reference key of purchase UOM package.	VarWChar	50
SaleUOMKey	Reference key of sale UOM.	VarWChar	50
SaleUOMPackageKey	Reference key of sale UOM package.	VarWChar	50
InventoryUOMKey	Reference key of inventory UOM.	VarWChar	50
InventoryCountingUOMKey	Reference key of inventory counting UOM.	VarWChar	50
BarCodeMaskKey	Reference key of bar code mask.	VarWChar	50		((0))
IsEBTItem	Value is True if the product is EBT item	Boolean	1		((1))
ExternalLink	Stores the hyperlink of the information about the product	VarWChar	200
ExpiryDateRequiredForBatch	Value is True if the Expiry date is required for Batch	Boolean	1
ExpiryDateRequiredForSerial	Value is True if the Expiry date is required for Serial	Boolean	1
ReturnDays	Product can be return within specified days.	Integer	4		((0))
CostingMethod	Specifies costing method of product.	Integer	4
CostingSubMethod	Specifies costing submethod of product.	Integer	4
PrimaryFilterAttributeKey	Stores the primary attribute key for the product	VarWChar	50		((0))
TwoDimensionalFilterAttributeKey	Stores the two dimensional attribute key for the product	VarWChar	50		((0))
GracePeriod	Value is the grace period for the product	Integer	4		((0))
ProductDiscountGroupKey	Refers to the ProductDiscountGroup applicable to the Product.See also ProductDiscountGroup	VarWChar	50
IsTaxOnly	Value is True if the added item is Tax Free	Boolean	1		((0))
VariantCode	Value is the Variant code for the product	VarWChar	20
ReprintGCOnRedemption		Boolean	1		((0))
MinimumReprintingAmount	Applicable to Gift Certificate type only. If balance amount is more than this field, then only it prints after paying the amount using this Gift Certificate	Numeric	9 (20,5)		((0))
IsPrintingRequired	Applicable to Gift Certificate type only. If value is true, when tender type is Gift Certificate, it will print after the transaction.	Boolean	1		((0))
Comments	Stores comments.	VarWChar	4000
MaxQuantityPerTransaction	Stores max quantity that can be sale in single transaction.	Numeric	9 (20,5)		((0))
IsDynamicAssembly	Flag to check whether the product is Dynamic Assembly.	Boolean	1		((0))
MaxDiscountAmount	Stores max discount amount allowed on product.	Numeric	9 (20,5)
MaxDiscountPercentage	Stores max discount percentage allowed on product.	Numeric	9 (20,5)
AllowZeroPrice	Flag to check whether item can be sale at zero price or not.	Boolean	1		((1))
HSNCode		VarWChar	100
FulfillmentPlanSaleKey		VarWChar	50		((0))
FulfillmentPlanSOKey		VarWChar	50		((0))
FulfillmentPlanLayawayKey		VarWChar	50		((0))

Indexes

Index	Description	Primary	Unique
IX_InvProduct
IX_InvProduct_1
IX_InvProduct_2
PK_InvProduct

Relationships

Relationship	Description
FK_TrxScannedDataDetail_InvProduct

Objects that depend on InvProduct

Database Object	Object Type	Description	Dep Level
BarCodeResolution	Stored Procedure		1
BreakBuildKit	Stored Procedure		1
CustomeLabelReport	Stored Procedure		2
Daily_ProductCost	User Defined Function		1
DailySaleSummary	User Defined Function		1
Forecast	Stored Procedure		1
GenerateLabelData	Stored Procedure	Generates label data depending on the parameter specified	1
GenerateSKU	Stored Procedure		1
GetBOMQuantity	Stored Procedure		1
GetDeliveryPackages	Stored Procedure		1
GetInventoryItemForStockCount	Stored Procedure		1
GetMobileReplicationData	Stored Procedure		1
GetNextAutoGeneratedCode	Stored Procedure	Generates the next code depending on the Source Type	1
GetUOMPriceMatrix	Stored Procedure		1
GetValidPromotionsForProduct	Stored Procedure		1
GoodsIssueReport	Stored Procedure		1
GoodsReceiptPOReport	Stored Procedure		1
GoodsReceiptReport	Stored Procedure		1
Integration_Consolidated_Transaction	Stored Procedure		1
Integration_funcTransaction	User Defined Function		1
Integration_GoodsIssue	Stored Procedure		1
Integration_GoodsReceipt	Stored Procedure		1
Integration_GoodsReturn	Stored Procedure		1
Integration_PurchaseOrder	Stored Procedure		1
Integration_StockTransfer	Stored Procedure		1
InventoryCount_Save	Stored Procedure		1
InventoryItemQuantityUpdates	Stored Procedure		1
InvGetAllSelectedAttributeItems	Stored Procedure		1
InvGetAllSelectedAttributeItemsList	Stored Procedure		1
InvGetMatrixItems	Stored Procedure	Applies Buy Some Get Some promotion on the transaction	1
Loy_GetTransactionLineItem	Stored Procedure		1
MRP	Stored Procedure		1
PurchaseOrderReport	Stored Procedure		1
RPT_ABCAnalysis	Stored Procedure		1
Rpt_ItemWithoutSale	User Defined Function		1
rpt_LayAway	Stored Procedure		1
rptClosingBalanceQuantity	User Defined Function		1
rptOpeningBalance	User Defined Function		1
rptOpeningBalance_dailyClosingBal	User Defined Function		1
rptOpeningBalance_Location	User Defined Function		1
rptOpeningBalance_Stock	User Defined Function		1
rptSalesData	User Defined Function		1
rptSalesTransactionData	User Defined Function		1
rptSalesTransactionDataWithSalesPerson	User Defined Function		1
SalesAnalysisbySalesPersons	Stored Procedure		2
SalesDetail	User Defined Function		1
StockTransferReport	Stored Procedure		1
Trg_TrxScannedDataDetail	Trigger		1
TrgSBOBatchUpdate	Trigger	Handles updates made to Batch table from ERP system (Business One in this case)	1
TrgSBOInventoryUpdate	Trigger	Handles updates made to item inventory in the ERP system (Business One in this case)	1
TrgSBOSerialUpdate	Trigger	Handles updates made to Serial table from ERP system (Business One in this case)	1
TrxCompleteTransactionUpdates	Stored Procedure		2
TrxInventoryUpdateCheckNegativeInventory	Stored Procedure		1
TrxInventoryUpdateLaybyCancellationItem	Stored Procedure		1
TrxInventoryUpdateLaybyItem	Stored Procedure		1
TrxInventoryUpdateOrder	Stored Procedure	Handles updates related to Order item	1
TrxInventoryUpdateSaleDelivery	Stored Procedure	Handles updates related to delivery of a Sale item	1
TrxInventoryUpdateSaleItem	Stored Procedure	Handles updates related to sale item	1
TrxInventoryUpdatesSaleRefund	Stored Procedure	Handles updates related to On Account payments	1
TrxScannedDataDetail	Table		1
UpdateDeliveryInformationFromSAPBusinessOne	Stored Procedure		1
uspGetItemPrice	Stored Procedure		1
uspGetItemPriceForNAV	Stored Procedure		1
uspGetPurchasePriceForNAV	Stored Procedure		1
vw_GrossProfit	View		1
vw_InventoryCost	View		1
vw_InventoryMovement	View		1
vw_InvProduct	View		1
vw_InvProductInventoryInfo	View		1
vw_ProductCost	View		1
vw_ProductMerchandiseHierarchy	View		1
vw_SalesReportData	View		1
vwAnalytics_InventorySnapshot	View		1
vwAnalytics_MerchandiseInventoryCount	View		1
vwAnalytics_MerchandisePromotionSales	View		1
vwAnalytics_MerchandiseSales	View		1
vwAnalytics_NetSales	View		1
vwAnalytics_OpenPO_Snapshot	View		1
vwAnalytics_OpenStockTransferReceipt	View		1
vwAnalytics_OpenStockTransferRequest	View		1
vwAnalytics_Sales	View		1

SQL

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvProduct](

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

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

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

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

[Description3] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

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

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

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

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

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

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

[RequireAgeVerification] [bit] NOT NULL,

[MinAge] [int] NULL,

[HasImage] [bit] NOT NULL,

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

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

[LeadTime] [int] NOT NULL,

[IsGiftCertificate] [bit] NULL,

[IsZeroValue] [bit] NOT NULL,

[IsPurchasable] [bit] NOT NULL,

[Created] [datetime] NOT NULL,

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

[Modified] [datetime] NOT NULL,

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

[IsDeleted] [bit] NOT NULL,

[IsMatrixItem] [bit] NOT NULL,

[IsMatrixChildItem] [bit] NOT NULL,

[IsTwoDimensionalMatrixItem] [bit] NOT NULL,

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

[DefaultExpiryPeriod] [int] NULL,

[GiftCertificateType] [int] NULL,

[PriceOverrideAllowed] [bit] NOT NULL,

[CanSellExpiredItem] [bit] NOT NULL,

[ExpiryMessageDays] [int] NOT NULL,

[CanRefundExpiredItem] [bit] NOT NULL,

[LoyaltyPointsRedeemable] [bit] NOT NULL,

[IsStoreCredit] [bit] NOT NULL,

[MaximumOpenPrice] [numeric](18, 5) NOT NULL,

[IgnoreDiscountItemsForSaleDiscount] [bit] NOT NULL,

[SaleDiscountsAllowed] [bit] NOT NULL,

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

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

[HasPackageGroup] [bit] NOT NULL,

[GiftCertificatePassTemplate] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[GiftCertificateEmailTemplate] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[PassDescription] [nvarchar](28) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[PassValue] [nvarchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

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

[AutoSelectSerialBatchType] [int] NULL,

[UsePriceEmbeddedBarcode] [bit] NOT NULL,

[MustSwipeCard] [bit] NOT NULL,

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

[DiscountsGroupAllowed] [bit] NOT NULL,

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

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

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

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

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

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

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

[IsEBTItem] [bit] NULL,

[ExternalLink] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ExpiryDateRequiredForBatch] [bit] NULL,

[ExpiryDateRequiredForSerial] [bit] NULL,

[ReturnDays] [int] NULL,

[CostingMethod] [int] NULL,

[CostingSubMethod] [int] NULL,

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

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

[GracePeriod] [int] NULL,

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

[IsTaxOnly] [bit] NULL,

[VariantCode] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ReprintGCOnRedemption] [bit] NULL,

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

[IsPrintingRequired] [bit] NULL,

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

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

[IsDynamicAssembly] [bit] NOT NULL,

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

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

[AllowZeroPrice] [bit] NOT NULL,

[HSNCode] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

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

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

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

CONSTRAINT [PK_InvProduct] PRIMARY KEY CLUSTERED

(

[ProductKey] 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].[InvProduct] ADD CONSTRAINT [DF_InvProduct_AllowPriceOverride] DEFAULT ((1)) FOR [PriceOverrideAllowed]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_CanSellExpiredItem] DEFAULT ((1)) FOR [CanSellExpiredItem]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_ExpiryMessageDays] DEFAULT ((0)) FOR [ExpiryMessageDays]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_CanRefundExpiredItem] DEFAULT ((1)) FOR [CanRefundExpiredItem]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_LoyaltyPointsRedeemable] DEFAULT ((1)) FOR [LoyaltyPointsRedeemable]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_IsStoreCredit] DEFAULT ((0)) FOR [IsStoreCredit]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_MaximumOpenPrice] DEFAULT ((0)) FOR [MaximumOpenPrice]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_IgnoreDiscountItemsForSaleDiscount] DEFAULT ((0)) FOR [IgnoreDiscountItemsForSaleDiscount]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_SaleDiscountsAllowed] DEFAULT ((0)) FOR [SaleDiscountsAllowed]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_PackageGroupKey] DEFAULT ((0)) FOR [PackageGroupKey]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_HasTareWeight] DEFAULT ((0)) FOR [HasPackageGroup]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_CommentKey] DEFAULT ((0)) FOR [CommentKey]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_AutoSelectSerialBatchType] DEFAULT ((0)) FOR [AutoSelectSerialBatchType]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_UsePriceEmbeddedBarcode] DEFAULT ((0)) FOR [UsePriceEmbeddedBarcode]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_MustSwipeCard] DEFAULT ((0)) FOR [MustSwipeCard]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF__InvProduc__Disco__679450C0] DEFAULT ((1)) FOR [DiscountsGroupAllowed]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_BarCodeMaskKey] DEFAULT ((0)) FOR [BarCodeMaskKey]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_IsEBTItem] DEFAULT ((1)) FOR [IsEBTItem]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_ReturnDays] DEFAULT ((0)) FOR [ReturnDays]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF__InvProduc__Prima__2176D992] DEFAULT ((0)) FOR [PrimaryFilterAttributeKey]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF__InvProduc__TwoDi__226AFDCB] DEFAULT ((0)) FOR [TwoDimensionalFilterAttributeKey]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_GracePeriod] DEFAULT ((0)) FOR [GracePeriod]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_IsTaxOnly] DEFAULT ((0)) FOR [IsTaxOnly]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_ReprintGCOnRedemption] DEFAULT ((0)) FOR [ReprintGCOnRedemption]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_MinimumReprintingAmount] DEFAULT ((0)) FOR [MinimumReprintingAmount]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF_InvProduct_IsPrintingRequired] DEFAULT ((0)) FOR [IsPrintingRequired]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF__InvProduc__MaxQu__07F6FEB1] DEFAULT ((0)) FOR [MaxQuantityPerTransaction]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF__InvProduc__IsDyn__1368B15D] DEFAULT ((0)) FOR [IsDynamicAssembly]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF__InvProduc__Allow__30F91444] DEFAULT ((1)) FOR [AllowZeroPrice]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF__InvProduc__Fulfi__2FBAD748] DEFAULT ((0)) FOR [FulfillmentPlanSaleKey]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF__InvProduc__Fulfi__30AEFB81] DEFAULT ((0)) FOR [FulfillmentPlanSOKey]

ALTER TABLE [dbo].[InvProduct] ADD CONSTRAINT [DF__InvProduc__Fulfi__31A31FBA] DEFAULT ((0)) FOR [FulfillmentPlanLayawayKey]

Related Objects

iVend Database Database

Send comments on this topic.