Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
TrxTransactionItemAttribute Table
Collapse All Expand All
iVend Database Database : TrxTransactionItemAttribute Table |
Description
Defines a list of sale tranaction attributes (any additional information) captured at the time of a transaction.
Properties
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 |
Columns
|
Column Name |
Description |
Datatype |
Length |
Allow Nulls |
Default |
Formula |
|
TransactionItemAttributeKey |
System generated Primary Key |
VarWChar |
50 |
|
|
|
|
TransactionKey |
Refers to the key of the transaction. See also Transaction |
VarWChar |
50 |
|
((0)) |
|
|
Source |
Type of Transaction Item |
Integer |
4 |
|
|
|
|
SourceKey |
Reference Key of Source |
VarWChar |
50 |
|
|
|
|
Attribute1 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute2 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute3 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute4 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute5 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute6 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute7 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute8 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute9 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute10 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute1Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
|
|
|
Attribute2Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
|
|
|
Attribute3Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
|
|
|
Attribute4Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
|
|
|
Attribute5Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
|
|
|
Attribute6Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
|
|
|
Attribute7Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
|
|
|
Attribute8Key |
Refers to the attribute key |
VarWChar |
50 |
|
|
|
|
Attribute9Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
|
|
|
Attribute10Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
|
|
|
Attribute11 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute11Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
((0)) |
|
|
Attribute12 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute12Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
((0)) |
|
|
Attribute13 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute13Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
((0)) |
|
|
Attribute14 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute14Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
((0)) |
|
|
Attribute15 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute15Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
((0)) |
|
|
Attribute16 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute16Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
((0)) |
|
|
Attribute17 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute17Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
((0)) |
|
|
Attribute18 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute18Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
((0)) |
|
|
Attribute19 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute19Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
((0)) |
|
|
Attribute20 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute20Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
((0)) |
|
|
Attribute21 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute21Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
((0)) |
|
|
Attribute22 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute22Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
((0)) |
|
|
Attribute23 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute23Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
((0)) |
|
|
Attribute24 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute24Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
((0)) |
|
|
Attribute25 |
The value given for each attribute of the transaction |
VarWChar |
100 |
|
|
|
|
Attribute25Key |
Refers to the attribute key. See also Sales Atribute |
VarWChar |
50 |
|
((0)) |
|
Indexes
Index |
Description |
Primary |
Unique |
|
|
|
|
|
|
|
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[TrxTransactionItemAttribute]( [TransactionItemAttributeKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [TransactionKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Source] [int] NOT NULL, [SourceKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Attribute1] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute2] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute3] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute4] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute5] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute6] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute7] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute8] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute9] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute10] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute1Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute2Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute3Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute4Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute5Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute6Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute7Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute8Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute9Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute10Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute11] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute11Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Attribute12] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute12Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Attribute13] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute13Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Attribute14] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute14Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Attribute15] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute15Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Attribute16] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute16Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Attribute17] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute17Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Attribute18] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute18Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Attribute19] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute19Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Attribute20] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute20Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Attribute21] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute21Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Attribute22] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute22Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Attribute23] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute23Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Attribute24] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute24Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Attribute25] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Attribute25Key] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_TrxTransactionItemAttribute] PRIMARY KEY CLUSTERED ( [TransactionItemAttributeKey] 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].[TrxTransactionItemAttribute] ADD CONSTRAINT [DF_TrxTransactionItemAttribute_TransactionKey] DEFAULT ((0)) FOR [TransactionKey] ALTER TABLE [dbo].[TrxTransactionItemAttribute] ADD CONSTRAINT [DF_TrxTransactionItemAttribute_Attribute11Key] DEFAULT ((0)) FOR [Attribute11Key] ALTER TABLE [dbo].[TrxTransactionItemAttribute] ADD CONSTRAINT [DF_TrxTransactionItemAttribute_Attribute12Key] DEFAULT ((0)) FOR [Attribute12Key] ALTER TABLE [dbo].[TrxTransactionItemAttribute] ADD CONSTRAINT [DF_TrxTransactionItemAttribute_Attribute13Key] DEFAULT ((0)) FOR [Attribute13Key] ALTER TABLE [dbo].[TrxTransactionItemAttribute] ADD CONSTRAINT [DF_TrxTransactionItemAttribute_Attribute14Key] DEFAULT ((0)) FOR [Attribute14Key] ALTER TABLE [dbo].[TrxTransactionItemAttribute] ADD CONSTRAINT [DF_TrxTransactionItemAttribute_Attribute15Key] DEFAULT ((0)) FOR [Attribute15Key] ALTER TABLE [dbo].[TrxTransactionItemAttribute] ADD CONSTRAINT [DF_TrxTransactionItemAttribute_Attribute16Key] DEFAULT ((0)) FOR [Attribute16Key] ALTER TABLE [dbo].[TrxTransactionItemAttribute] ADD CONSTRAINT [DF_TrxTransactionItemAttribute_Attribute17Key] DEFAULT ((0)) FOR [Attribute17Key] ALTER TABLE [dbo].[TrxTransactionItemAttribute] ADD CONSTRAINT [DF_TrxTransactionItemAttribute_Attribute18Key] DEFAULT ((0)) FOR [Attribute18Key] ALTER TABLE [dbo].[TrxTransactionItemAttribute] ADD CONSTRAINT [DF_TrxTransactionItemAttribute_Attribute19Key] DEFAULT ((0)) FOR [Attribute19Key] ALTER TABLE [dbo].[TrxTransactionItemAttribute] ADD CONSTRAINT [DF_TrxTransactionItemAttribute_Attribute20Key] DEFAULT ((0)) FOR [Attribute20Key] ALTER TABLE [dbo].[TrxTransactionItemAttribute] ADD CONSTRAINT [DF_TrxTransactionItemAttribute_Attribute21Key] DEFAULT ((0)) FOR [Attribute21Key] ALTER TABLE [dbo].[TrxTransactionItemAttribute] ADD CONSTRAINT [DF_TrxTransactionItemAttribute_Attribute22Key] DEFAULT ((0)) FOR [Attribute22Key] ALTER TABLE [dbo].[TrxTransactionItemAttribute] ADD CONSTRAINT [DF_TrxTransactionItemAttribute_Attribute23Key] DEFAULT ((0)) FOR [Attribute23Key] ALTER TABLE [dbo].[TrxTransactionItemAttribute] ADD CONSTRAINT [DF_TrxTransactionItemAttribute_Attribute24Key] DEFAULT ((0)) FOR [Attribute24Key] ALTER TABLE [dbo].[TrxTransactionItemAttribute] ADD CONSTRAINT [DF_TrxTransactionItemAttribute_Attribute25Key] DEFAULT ((0)) FOR [Attribute25Key] |
See Also
Related Objects
© 2019 All Rights Reserved.
Send comments on this topic.