MS Dynamics RMS Item Data Fields

 

	[BinLocation] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Item_BinLocation]  DEFAULT (''),
[BuydownPrice] [money] NOT NULL CONSTRAINT [DF_Item_BuydownPrice] DEFAULT (0),
[BuydownQuantity] [float] NOT NULL CONSTRAINT [DF_Item_BuydownQuantity] DEFAULT (0),
[CommissionAmount] [money] NOT NULL CONSTRAINT [DF_Item_CommissionAmount] DEFAULT (0),
[CommissionMaximum] [money] NOT NULL CONSTRAINT [DF_Item_CommissionMaximum] DEFAULT (0),
[CommissionMode] [int] NOT NULL CONSTRAINT [DF_Item_CommissionMode] DEFAULT (0),
[CommissionPercentProfit] [real] NOT NULL CONSTRAINT [DF_Item_CommissionPercentProfit] DEFAULT (0),
[CommissionPercentSale] [real] NOT NULL CONSTRAINT [DF_Item_CommissionPercentSale] DEFAULT (0),
[Description] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Item_Description] DEFAULT (''),
[FoodStampable] [bit] NOT NULL CONSTRAINT [DF_Item_FoodStampable] DEFAULT (0),
[HQID] [int] NOT NULL CONSTRAINT [DF_Item_HQID] DEFAULT (0),
[ItemNotDiscountable] [bit] NOT NULL CONSTRAINT [DF_Item_ItemNotDiscountable] DEFAULT (0),
[LastReceived] [datetime] NULL,
[LastUpdated] [datetime] NOT NULL CONSTRAINT [DF_Item_LastUpdated] DEFAULT (getdate()),
[Notes] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[QuantityCommitted] [float] NOT NULL CONSTRAINT [DF_Item_QuantityCommitted] DEFAULT (0),
[SerialNumberCount] [int] NOT NULL CONSTRAINT [DF_Item_SerialNumberCount] DEFAULT (0),
[TareWeightPercent] [float] NOT NULL CONSTRAINT [DF_Item_TareWeightPercent] DEFAULT (0),
[ID] [int] IDENTITY(1,1) NOT NULL,
[ItemLookupCode] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Item_ItemLookupCode] DEFAULT (''),
[DepartmentID] [int] NOT NULL CONSTRAINT [DF_Item_DepartmentID] DEFAULT (0),
[CategoryID] [int] NOT NULL CONSTRAINT [DF_Item_CategoryID] DEFAULT (0),
[MessageID] [int] NOT NULL CONSTRAINT [DF_Item_MessageID] DEFAULT (0),
[Price] [money] NOT NULL CONSTRAINT [DF_Item_Price] DEFAULT (0),
[PriceA] [money] NOT NULL CONSTRAINT [DF_Item_PriceA] DEFAULT (0),
[PriceB] [money] NOT NULL CONSTRAINT [DF_Item_PriceB] DEFAULT (0),
[PriceC] [money] NOT NULL CONSTRAINT [DF_Item_PriceC] DEFAULT (0),
[SalePrice] [money] NOT NULL CONSTRAINT [DF_Item_SalePrice] DEFAULT (0),
[SaleStartDate] [datetime] NULL,
[SaleEndDate] [datetime] NULL,
[QuantityDiscountID] [int] NOT NULL CONSTRAINT [DF_Item_QuantityDiscountID] DEFAULT (0),
[TaxID] [int] NOT NULL CONSTRAINT [DF_Item_TaxID] DEFAULT (0),
[ItemType] [smallint] NOT NULL CONSTRAINT [DF_Item_ItemType] DEFAULT (0),
[Cost] [money] NOT NULL CONSTRAINT [DF_Item_Cost] DEFAULT (0),
[Quantity] [float] NOT NULL CONSTRAINT [DF_Item_Quantity] DEFAULT (0),
[ReorderPoint] [float] NOT NULL CONSTRAINT [DF_Item_ReorderPoint] DEFAULT (0),
[RestockLevel] [float] NOT NULL CONSTRAINT [DF_Item_RestockLevel] DEFAULT (0),
[TareWeight] [float] NOT NULL CONSTRAINT [DF_Item_TareWeight] DEFAULT (0),
[SupplierID] [int] NOT NULL CONSTRAINT [DF_Item_SupplierID] DEFAULT (0),
[TagAlongItem] [int] NOT NULL CONSTRAINT [DF_Item_TagAlongItem] DEFAULT (0),
[TagAlongQuantity] [float] NOT NULL CONSTRAINT [DF_Item_TagAlongQuantity] DEFAULT (0),
[ParentItem] [int] NOT NULL CONSTRAINT [DF_Item_ParentItem] DEFAULT (0),
[ParentQuantity] [float] NOT NULL CONSTRAINT [DF_Item_ParentQuantity] DEFAULT (0),
[BarcodeFormat] [smallint] NOT NULL CONSTRAINT [DF_Item_BarcodeFormat] DEFAULT (0),
[PriceLowerBound] [money] NOT NULL CONSTRAINT [DF_Item_PriceLowerBound] DEFAULT (0),
[PriceUpperBound] [money] NOT NULL CONSTRAINT [DF_Item_PriceUpperBound] DEFAULT (0),
[PictureName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Item_PictureName] DEFAULT (''),
[LastSold] [datetime] NULL,
[ExtendedDescription] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Item_ExtendedDescription] DEFAULT (''),
[SubDescription1] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Item_SubDescription1] DEFAULT (''),
[SubDescription2] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Item_SubDescription2] DEFAULT (''),
[SubDescription3] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Item_SubDescription3] DEFAULT (''),
[UnitOfMeasure] [nvarchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Item_UnitOfMeasure] DEFAULT (''),
[SubCategoryID] [int] NOT NULL CONSTRAINT [DF_Item_SubCategoryID] DEFAULT (0),
[QuantityEntryNotAllowed] [bit] NOT NULL CONSTRAINT [DF_Item_QuantityEntryNotAllowed] DEFAULT (0),
[PriceMustBeEntered] [bit] NOT NULL CONSTRAINT [DF_Item_PriceMustBeEntered] DEFAULT (0),
[BlockSalesReason] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Item_BlockSalesReason] DEFAULT (''),
[BlockSalesAfterDate] [datetime] NULL,
[Weight] [float] NOT NULL CONSTRAINT [DF_Item_Weight] DEFAULT (0),
[Taxable] [bit] NOT NULL CONSTRAINT [DF_Item_Taxable] DEFAULT (1),
[DBTimeStamp] [timestamp] NULL,
[BlockSalesBeforeDate] [datetime] NULL,
[LastCost] [money] NOT NULL CONSTRAINT [DF_Item_LastCost] DEFAULT (0),
[ReplacementCost] [money] NOT NULL CONSTRAINT [DF_Item_ReplacementCost] DEFAULT (0),
[WebItem] [bit] NOT NULL DEFAULT (0),
[BlockSalesType] [int] NOT NULL CONSTRAINT [DF_Item_BlockSalesType] DEFAULT (0),
[BlockSalesScheduleID] [int] NOT NULL CONSTRAINT [DF_Item_BlockSalesScheduleID] DEFAULT (0),
[SaleType] [int] NOT NULL CONSTRAINT [DF_Item_SaleType] DEFAULT (0),
[SaleScheduleID] [int] NOT NULL CONSTRAINT [DF_Item_SaleScheduleID] DEFAULT (0),
[Consignment] [bit] NOT NULL CONSTRAINT [DF_Item_Consignment] DEFAULT (0),
[Inactive] [bit] NOT NULL CONSTRAINT [Df_Item_Inactive] DEFAULT (0),
[LastCounted] [datetime] NULL,
[DoNotOrder] [bit] NOT NULL CONSTRAINT [Df_Item_DoNotOrder] DEFAULT (0),
[MSRP] [money] NOT NULL CONSTRAINT [Df_Item_MSRP] DEFAULT (0),
[DateCreated] [datetime] NOT NULL CONSTRAINT [Df_Item_DateCreated] DEFAULT (getdate()),
[Content] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [Df_Item_Content] DEFAULT (''),
[UsuallyShip] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [Df_Item_UsuallyShip] DEFAULT ('')