<< Click to Display Table of Contents >> Navigation: iVend Database Database > Tables > CfgLineAttribute Table |
Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
CfgLineAttribute Table
Collapse All Expand All
iVend Database Database : CfgLineAttribute 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 |
LineAttributeKey |
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 |
|
|
|
|
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 |
|
|
|
|
ValueTable |
Specifies the table name that is used to fetch the value for the attribute |
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 |
Check whether any information regarding the line attribute would integrate back into the ERP system. |
Boolean |
1 |
|
((0)) |
|
|
IntegratedFieldName |
It stores the Field Name integrated or mappaed with ERP system for the line attribute. |
VarWChar |
50 |
|
|
|
|
IsActive |
Speicifes whether the line attribute is active or not. Only active line attributes are allowed to be used for selection. |
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 Layaway to display |
Boolean |
1 |
|
|
|
|
Quotation |
Value is True if the Quotation 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 Pattern to display |
VarChar |
100 |
|
|
|
|
Delivery |
Signifies if the line attributes is valid for the Delivery transaction |
Boolean |
1 |
|
|
|
|
IsVisible |
Speicifes whether the line attribute is visible on the UI or not. |
Boolean |
1 |
((1)) |
|
Indexes
Index |
Description |
Primary |
Unique |
|
Objects that depend on CfgLineAttribute
|
Database Object |
Object Type |
Description |
Dep Level |
Stored Procedure |
|
1 |
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[CfgLineAttribute]( [LineAttributeKey] [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, [ValidationType] [int] NOT NULL, [DefaultValue] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ValueTable] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS 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, [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_CfgTransactionItemAttribute] PRIMARY KEY CLUSTERED ( [LineAttributeKey] 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].[CfgLineAttribute] ADD CONSTRAINT [DF_CfgLineAttribute_IsIntegrated] DEFAULT ((0)) FOR [IsIntegrated] ALTER TABLE [dbo].[CfgLineAttribute] ADD CONSTRAINT [DF_CfgLineAttribute_IsActive] DEFAULT ((1)) FOR [IsActive] ALTER TABLE [dbo].[CfgLineAttribute] ADD CONSTRAINT [DF_CfgLineAttribute_IsVisible] DEFAULT ((1)) FOR [IsVisible] |
See Also
© 2019 All Rights Reserved.
Send comments on this topic.