Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
TrxTransactionCoupon Table
Collapse All Expand All
iVend Database Database : TrxTransactionCoupon Table |
Description
Stores the value for the Coupon in a transaction
Properties
Creation Date |
4/13/2015 12:00 PM |
File Group |
PRIMARY |
Text File Group |
PRIMARY |
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 |
|
TransactionCouponKey |
Primary Key |
VarWChar |
50 |
|
|
|
|
TransactionKey |
Refers to the Transaction key of the current coupon transaction. See also Transaction |
VarWChar |
50 |
|
|
|
|
SourceKey |
Value is the key of the source selected. |
VarWChar |
50 |
|
|
|
|
SourceType |
Value is the source type against which the coupon has been applied. |
Integer |
4 |
|
|
|
|
CouponKey |
Reference Key of Coupon. See also coupon |
VarWChar |
50 |
|
|
|
|
Quantity |
Value is the discount applied using the coupon |
Numeric |
9 (20,5) |
|
|
|
|
Discount |
Value is the discount applied using the coupon |
Numeric |
9 (20,5) |
|
|
|
|
WarehouseKey |
The warehouse associated with the transaction. See also Warehouse |
VarWChar |
50 |
|
|
|
|
SequenceNumber |
Store the Sequence no to display the Coupon while recalling the transaction |
Integer |
4 |
|
((0)) |
|
|
CouponHeaderDiscountAmount |
Stores the Discount amount for the coupon |
Numeric |
9 (20,5) |
|
((0)) |
|
|
CustomerKey |
Refers to the customer.See also Customer |
VarWChar |
50 |
|
((0)) |
|
|
CommentKey |
Value is the comment key for the transaction.See also Comment |
VarWChar |
50 |
|
((0)) |
|
|
Type |
Stores the Coupon type values used in transaction Valid values are Redeem = 0 Issue = 1 |
Integer |
4 |
|
|
|
|
ProductDetailNumber |
Captures the coupon serial number |
VarWChar |
50 |
|
|
|
|
Comments |
Stores comments |
VarWChar |
4000 |
|
|
|
|
Integration1 |
Additional Field for ERP Integration - Alpha numeric type |
VarWChar |
100 |
|
|
|
|
Integration2 |
Additional Field for ERP Integration - Alpha numeric type |
VarWChar |
100 |
|
|
|
|
Integration3 |
Additional Field for ERP Integration - Alpha numeric type |
VarWChar |
100 |
|
|
|
|
Integration4 |
Additional Field for ERP Integration - Alpha numeric type |
VarWChar |
100 |
|
|
|
|
Integration5 |
Additional Field for ERP Integration - Alpha numeric type |
VarWChar |
100 |
|
|
|
|
Integration6 |
Additional Field for ERP Integration - Numeric type |
Numeric |
9 (20,5) |
|
|
|
|
Integration7 |
Additional Field for ERP Integration - Numeric type |
Numeric |
9 (20,5) |
|
|
|
|
Integration8 |
Additional Field for ERP Integration - Numeric type |
Numeric |
9 (20,5) |
|
|
|
|
Integration9 |
Additional Field for ERP Integration - Numeric type |
Numeric |
9 (20,5) |
|
|
|
|
Integration10 |
Additional Field for ERP Integration - Numeric type |
Numeric |
9 (20,5) |
|
|
|
Indexes
Index |
Description |
Primary |
Unique |
|
|
|
|
|
|
|
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[TrxTransactionCoupon]( [TransactionCouponKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [TransactionKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [SourceKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [SourceType] [int] NOT NULL, [CouponKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Quantity] [decimal](20, 5) NOT NULL, [Discount] [decimal](20, 5) NOT NULL, [WarehouseKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [SequenceNumber] [int] NOT NULL, [CouponHeaderDiscountAmount] [decimal](20, 5) NOT NULL, [CustomerKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [CommentKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Type] [int] NOT NULL, [ProductDetailNumber] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Comments] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Integration1] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Integration2] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Integration3] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Integration4] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Integration5] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Integration6] [decimal](20, 5) NULL, [Integration7] [decimal](20, 5) NULL, [Integration8] [decimal](20, 5) NULL, [Integration9] [decimal](20, 5) NULL, [Integration10] [decimal](20, 5) NULL, CONSTRAINT [PK_TrxTransactionCoupon] PRIMARY KEY CLUSTERED ( [TransactionCouponKey] 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].[TrxTransactionCoupon] ADD CONSTRAINT [DF_TrxTransactionCoupon_SequenceNumber] DEFAULT ((0)) FOR [SequenceNumber] ALTER TABLE [dbo].[TrxTransactionCoupon] ADD CONSTRAINT [DF_TrxTransactionCoupon_CouponHeaderDiscountAmount] DEFAULT ((0)) FOR [CouponHeaderDiscountAmount] ALTER TABLE [dbo].[TrxTransactionCoupon] ADD CONSTRAINT [DF_TrxTransactionCoupon_CustomerKey] DEFAULT ((0)) FOR [CustomerKey] ALTER TABLE [dbo].[TrxTransactionCoupon] ADD CONSTRAINT [DF_TrxTransactionCoupon_CommentKey] DEFAULT ((0)) FOR [CommentKey] |
See Also
Related Objects
© 2019 All Rights Reserved.
Send comments on this topic.