iVend Database Database : InvUOMGroupDetail Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

9

Data Space Used

8.00 KB

Index Space Used

24.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

UOMGroupDetailKey

Refers to the UOM Group detail key.

VarWChar

50

UOMGroupKey

Refers to the UOM Group key. See UOM Group

VarWChar

50

LineNumber

Line number of detail

Integer

4

UOMKey

Refers to the UOM key. See InvUOM

VarWChar

50

AltQty

Stores the Alternat qty

Numeric

9 (20,5)

BaseUOMKey

Stores the base UoM Key for the UoM Group.

VarWChar

50

((0))

BaseQty

Stores the values that match the conversion rate between the alternate UoM and the base UoM.

Numeric

9 (20,5)

Created

Date of creation of this record

DBTimeStamp

4

(getdate())

Modified

Date of last modification of this record

DBTimeStamp

4

CreatedBy

Reference of user who has created this record. See also Security User

VarWChar

50

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

((0))

Index

Description

Primary

Unique

IX_InvUOMGroupDetail

PK__InvUOMGr__0A4B2BB21837881B

Database Object

Object Type

Description

Dep Level

GetUOMPriceMatrix

Stored Procedure

1

Integration_Consolidated_Transaction

Stored Procedure

1

rpt_LayAway

Stored Procedure

1

rptSalesData

User Defined Function

1

rptSalesTransactionData

User Defined Function

1

rptSalesTransactionDataWithSalesPerson

User Defined Function

1

uspGetItemPrice

Stored Procedure

1

vw_SalesReportData

View

1

vwAnalytics_MerchandiseSales

View

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvUOMGroupDetail](

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

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

[LineNumber] [int] NOT NULL,

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

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

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

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

[Created] [datetime] NOT NULL,

[Modified] [datetime] NOT NULL,

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

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

[IsDeleted] [bit] NOT NULL,

CONSTRAINT [PK__InvUOMGr__0A4B2BB21837881B] PRIMARY KEY CLUSTERED

(

[UOMGroupDetailKey] 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].[InvUOMGroupDetail] ADD CONSTRAINT [DF__InvUOMGro__BaseU__481BA567] DEFAULT ((0)) FOR [BaseUOMKey]

ALTER TABLE [dbo].[InvUOMGroupDetail] ADD CONSTRAINT [DF__InvUOMGro__Creat__1A1FD08D] DEFAULT (getdate()) FOR [Created]

ALTER TABLE [dbo].[InvUOMGroupDetail] ADD CONSTRAINT [DF__InvUOMGro__IsDel__1B13F4C6] DEFAULT ((0)) FOR [IsDeleted]