Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
TaxTaxCodeCondition Table
Collapse All Expand All
iVend Database Database : TaxTaxCodeCondition Table |
Description
Stores the data for the Tax code condition
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 |
|
TaxConditionKey |
Primary key |
VarWChar |
50 |
|
|
|
|
CustomerConditionType |
Store the Customer Type Valid values are None =0 Customer = 1 Customer Group =2 |
Integer |
4 |
|
((0)) |
|
|
CustomerValue |
Stores the value based on the Customer Type chosen |
VarWChar |
50 |
|
((0)) |
|
|
ProductConditionType |
Store the Product Type Valid values are None =0 Product = 1 Product Group =2 |
Integer |
4 |
|
|
|
|
ProductValue |
Stores the value based on the product Type chosen |
VarWChar |
50 |
|
((0)) |
|
|
WarehouseConditionType |
Store the Warehouse Type Valid values are None =0 Warehouse= 1 Store Group =2 |
Integer |
4 |
|
((0)) |
|
|
WarehouseValue |
Stores the value based on the Warehouse Type chosen |
VarWChar |
50 |
|
|
|
|
ConditionType |
Store the Condition Type Valid values are None = 10 ShipTo_Zip = 1 ShipTo_City = 2 ShipTo_County = 3 ShipTo_State = 4 ShipTo_Country = 5 |
Integer |
4 |
|
|
|
|
ConditionValue |
Stores the value for Country or State based on the Condition type |
VarWChar |
50 |
|
|
|
|
TaxCodeKey |
Reference key of the applicable tax code. See also Tax |
VarWChar |
50 |
|
|
|
|
Created |
Date of creation of this record |
DBTimeStamp |
4 |
|
|
|
|
CreatedBy |
Reference of user who has created this record. See also Security User |
VarWChar |
50 |
|
|
|
|
Modified |
Date of last modification of this record |
DBTimeStamp |
4 |
|
|
|
|
ModifiedBy |
Reference of user who has modified this record. See also Security User |
VarWChar |
50 |
|
|
|
|
MinimumPrice |
Stores the minimum price of an item if the tax code condition is based on the price of an item. |
Numeric |
9 (20,5) |
|
((0)) |
|
|
MaximumPrice |
Stores the maximum price of an item if the tax code condition is based on the price of an item. |
Numeric |
9 (20,5) |
|
((0)) |
|
|
AttributeCondition1 |
Stores the Attribute Key on which the tax condition is defined |
VarWChar |
50 |
|
|
|
|
AttributeCondition2 |
Stores the Attribute Key on which the tax condition is defined |
VarWChar |
50 |
|
|
|
|
AttributeCondition3 |
Stores the Attribute Key on which the tax condition is defined |
VarWChar |
50 |
|
|
|
|
AttributeValue1 |
Stores the Attribute value on which the tax condition is defined |
VarWChar |
50 |
|
|
|
|
AttributeValue2 |
Stores the Attribute value on which the tax condition is defined |
VarWChar |
50 |
|
|
|
|
AttributeValue3 |
Stores the Attribute value on which the tax condition is defined |
VarWChar |
50 |
|
|
|
|
UDFCondition1 |
Stores the User Defined Key on which the tax condition is defined |
VarWChar |
50 |
|
|
|
|
UDFCondition2 |
Stores the User Defined Key on which the tax condition is defined |
VarWChar |
50 |
|
|
|
|
UDFCondition3 |
Stores the User Defined Key on which the tax condition is defined |
VarWChar |
50 |
|
|
|
|
UDFValue1 |
Stores the User Defined field value on which the tax condition is defined |
VarWChar |
100 |
|
|
|
|
UDFValue2 |
Stores the User Defined field value on which the tax condition is defined |
VarWChar |
100 |
|
|
|
|
UDFValue3 |
Stores the User Defined field value on which the tax condition is defined |
VarWChar |
100 |
|
|
|
|
FromDate |
Date from which the Tax condition would get applied |
DBTimeStamp |
4 |
|
|
|
|
ToDate |
Date To which the Tax condition would get applied |
DBTimeStamp |
4 |
|
|
|
|
FromTime |
Time from which the Tax condition would get applied |
DBTimeStamp |
4 |
|
|
|
|
ToTime |
Time to which the Tax condition would get applied |
DBTimeStamp |
4 |
|
|
|
|
SubsidiaryKey |
Reference key of the Subsidiary. See also Subsidiary |
VarWChar |
50 |
|
((0)) |
|
|
SaleAttributeCondition1 |
|
VarWChar |
50 |
|
|
|
|
SaleAttributeCondition2 |
|
VarWChar |
50 |
|
|
|
|
SaleAttributeCondition3 |
|
VarWChar |
50 |
|
|
|
|
SaleAttributeValue1 |
|
VarWChar |
50 |
|
|
|
|
SaleAttributeValue2 |
|
VarWChar |
50 |
|
|
|
|
SaleAttributeValue3 |
|
VarWChar |
50 |
|
|
|
|
LineAttributeCondition1 |
|
VarWChar |
50 |
|
|
|
|
LineAttributeCondition2 |
|
VarWChar |
50 |
|
|
|
|
LineAttributeCondition3 |
|
VarWChar |
50 |
|
|
|
|
LineAttributeValue1 |
|
VarWChar |
50 |
|
|
|
|
LineAttributeValue2 |
|
VarWChar |
50 |
|
|
|
|
LineAttributeValue3 |
|
VarWChar |
50 |
|
|
|
Indexes
Index |
Description |
Primary |
Unique |
|
|
|
|
|
|
|
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[TaxTaxCodeCondition]( [TaxConditionKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [CustomerConditionType] [int] NOT NULL, [CustomerValue] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ProductConditionType] [int] NOT NULL, [ProductValue] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [WarehouseConditionType] [int] NOT NULL, [WarehouseValue] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ConditionType] [int] NOT NULL, [ConditionValue] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [TaxCodeKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Created] [datetime] NOT NULL, [CreatedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Modified] [datetime] NOT NULL, [ModifiedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [MinimumPrice] [decimal](20, 5) NOT NULL, [MaximumPrice] [decimal](20, 5) NOT NULL, [AttributeCondition1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [AttributeCondition2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [AttributeCondition3] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [AttributeValue1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [AttributeValue2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [AttributeValue3] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [UDFCondition1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [UDFCondition2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [UDFCondition3] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [UDFValue1] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [UDFValue2] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [UDFValue3] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [FromDate] [datetime] NULL, [ToDate] [datetime] NULL, [FromTime] [datetime] NULL, [ToTime] [datetime] NULL, [SubsidiaryKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SaleAttributeCondition1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SaleAttributeCondition2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SaleAttributeCondition3] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SaleAttributeValue1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SaleAttributeValue2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SaleAttributeValue3] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LineAttributeCondition1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LineAttributeCondition2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LineAttributeCondition3] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LineAttributeValue1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LineAttributeValue2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LineAttributeValue3] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_TaxTaxCodeByCustomer] PRIMARY KEY CLUSTERED ( [TaxConditionKey] 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].[TaxTaxCodeCondition] ADD CONSTRAINT [DF_TaxTaxCodeByCustomer_CustomerGroupKey] DEFAULT ((0)) FOR [CustomerConditionType] ALTER TABLE [dbo].[TaxTaxCodeCondition] ADD CONSTRAINT [DF_TaxTaxCodeByCustomer_CustomerKey] DEFAULT ((0)) FOR [CustomerValue] ALTER TABLE [dbo].[TaxTaxCodeCondition] ADD CONSTRAINT [DF_TaxTaxCodeByCustomer_ProductGroupKey] DEFAULT ((0)) FOR [ProductValue] ALTER TABLE [dbo].[TaxTaxCodeCondition] ADD CONSTRAINT [DF_TaxTaxCodeByCustomer_ProductKey] DEFAULT ((0)) FOR [WarehouseConditionType] ALTER TABLE [dbo].[TaxTaxCodeCondition] ADD CONSTRAINT [DF_TaxTaxCodeCondition_MinimumPrice] DEFAULT ((0)) FOR [MinimumPrice] ALTER TABLE [dbo].[TaxTaxCodeCondition] ADD CONSTRAINT [DF_TaxTaxCodeCondition_MaximumPrice] DEFAULT ((0)) FOR [MaximumPrice] ALTER TABLE [dbo].[TaxTaxCodeCondition] ADD CONSTRAINT [DF__TaxTaxCod__Subsi__76577163] DEFAULT ((0)) FOR [SubsidiaryKey] |
See Also
Related Objects
© 2019 All Rights Reserved.
Send comments on this topic.