InvTempMatrixProductList Table

<< Click to Display Table of Contents >>

Navigation:  iVend Database Database > Tables >

InvTempMatrixProductList Table

Navigation: iVend Database Database > Tables >

hm_btn_navigate_prevhm_btn_navigate_tophm_btn_navigate_next

iVend 6.6 Database Help

InvTempMatrixProductList Table

Collapse All Expand All

iVend Database Database : InvTempMatrixProductList Table

Properties

Creation Date

10/8/2018 5:57 PM

File Group

PRIMARY

Text File Group

 

System Object

dbimages_boolean-false

Published for Replication

dbimages_boolean-false

Rows

0

Data Space Used

0.00 KB

Index Space Used

0.00 KB

Columns

 

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

Primary Key

TempAttributeKey

 

VarWChar

50

 

 

 

 

POSKey

 

VarWChar

50

 

 

 

 

AttributeKey

 

VarWChar

50

 

 

 

 

AttributeDetailKey

 

VarWChar

50

 

 

 

Indexes

Index

Description

Primary

Unique

PK_InvTempMatrixProductList

 

dbimages_tick

dbimages_tick

Objects that depend on InvTempMatrixProductList

 

Database Object

Object Type

Description

Dep Level

InvGetMatrixItems procedure

InvGetMatrixItems

Stored Procedure

Applies Buy Some Get Some promotion on the transaction

1

SQL

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[InvTempMatrixProductList](

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

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

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

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

CONSTRAINT [PK_InvTempMatrixProductList] PRIMARY KEY CLUSTERED

(

[TempAttributeKey] ASC

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

) ON [PRIMARY]

See Also

Related Objects

iVend Database Database

 

 


© 2019 All Rights Reserved.

Send comments on this topic.