<< Click to Display Table of Contents >> Navigation: iVend Database Database > Tables > CfgSaleAttribute Table |
Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
CfgSaleAttribute Table
Collapse All Expand All
iVend Database Database : CfgSaleAttribute Table |
Description
Stores the sales attributes (Added information that can be attached to each transaction at POS) created in the system. Maximum of 10 attributes are allowed to be created.
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 |
SaleAttributeKey |
Value is the system generated Primary Key of the table. |
VarWChar |
50 |
|
|
|
|
|
Name |
Value is the name of the attribute field. |
VarWChar |
50 |
|
|
|
|
Sequence |
Sepcifies the order in which the attribute would be captured at POS |
Integer |
4 |
|
|
|
|
Required |
Value is true if it is mandatory to enter the value to this attribute. |
Boolean |
1 |
|
|
|
|
CaptureType |
Speicifies the time of capture of the attribute Valid values are: BeginingOfSale = 0 EndOfSale = 1 |
Integer |
4 |
|
|
|
|
ValidationType |
For future use. |
Integer |
4 |
|
|
|
|
DefaultValue |
Default value for the attribute. This value is displayed at the time of capture of the attribute but the user can always change the value |
VarWChar |
100 |
|
|
|
|
Created |
Date of creation of this record |
DBTimeStamp |
4 |
|
|
|
|
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 |
|
|
|
|
IsIntegrated |
Value is True if the attribute Is Integrated |
Boolean |
1 |
|
((0)) |
|
|
IntegratedFieldName |
Value is True if the Integrated Field Name to display |
VarWChar |
50 |
|
|
|
|
ValueTable |
Stores the Table Name for the values to display on screen to select |
VarWChar |
100 |
|
|
|
|
IsActive |
Value is True if attribute is active |
Boolean |
1 |
|
((1)) |
|
|
Sale |
Value is True if the Sale to display |
Boolean |
1 |
|
|
|
|
SaleRefund |
Value is True if the Sale Refund to display |
Boolean |
1 |
|
|
|
|
SaleExchange |
Value is True if the Sale Exchange to display |
Boolean |
1 |
|
|
|
|
SpecialOrder |
Value is True if the Special Order to display |
Boolean |
1 |
|
|
|
|
Layaway |
Value is True if the Layaway to display |
Boolean |
1 |
|
|
|
|
Quotation |
Value is True if the Quotation to display |
Boolean |
1 |
|
|
|
|
GiftCertificate |
Value is True if the Gift Certificate to display |
Boolean |
1 |
|
|
|
|
CouponIssue |
Value is True if the Coupon Issue to display |
Boolean |
1 |
|
|
|
|
AdvancePayment |
Value is True if the Advance Payment to display |
Boolean |
1 |
|
|
|
|
RegExPattern |
Value is True if the Reg Ex Pattern to display |
VarChar |
100 |
|
|
|
|
Delivery |
Signifies if the line attributes is valid for the sale transaction |
Boolean |
1 |
|
|
|
|
IsVisible |
Speicifes whether the attribute is visible on the UI or not. |
Boolean |
1 |
((1)) |
|
Indexes
Index |
Description |
Primary |
Unique |
|
Objects that depend on CfgSaleAttribute
|
Database Object |
Object Type |
Description |
Dep Level |
Stored Procedure |
|
1 |
||
Stored Procedure |
|
1 |
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[CfgSaleAttribute]( [SaleAttributeKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Sequence] [int] NOT NULL, [Required] [bit] NOT NULL, [CaptureType] [int] NOT NULL, [ValidationType] [int] NOT NULL, [DefaultValue] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS 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, [IsIntegrated] [bit] NOT NULL, [IntegratedFieldName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ValueTable] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [IsActive] [bit] NOT NULL, [Sale] [bit] NULL, [SaleRefund] [bit] NULL, [SaleExchange] [bit] NULL, [SpecialOrder] [bit] NULL, [Layaway] [bit] NULL, [Quotation] [bit] NULL, [GiftCertificate] [bit] NULL, [CouponIssue] [bit] NULL, [AdvancePayment] [bit] NULL, [RegExPattern] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Delivery] [bit] NULL, [IsVisible] [bit] NULL, CONSTRAINT [PK_CfgSaleAttribute] PRIMARY KEY CLUSTERED ( [SaleAttributeKey] 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].[CfgSaleAttribute] ADD CONSTRAINT [DF_CfgSaleAttribute_IsIntegrated] DEFAULT ((0)) FOR [IsIntegrated] ALTER TABLE [dbo].[CfgSaleAttribute] ADD CONSTRAINT [DF_CfgSaleAttribute_IsActive] DEFAULT ((1)) FOR [IsActive] ALTER TABLE [dbo].[CfgSaleAttribute] ADD CONSTRAINT [DF_CfgSaleAttribute_IsVisible] DEFAULT ((1)) FOR [IsVisible] |
See Also
© 2019 All Rights Reserved.
Send comments on this topic.