Navigation: iVend Database Database > Tables > TaxTaxCodeCondition Table > Indexes >
iVend 6.6 Database Help
IX_TaxTaxCodeCondition Index
Collapse All Expand All
iVend Database Database > TaxTaxCodeCondition Table : IX_TaxTaxCodeCondition Index |
Properties
File Group |
PRIMARY |
Space Used |
0.00 KB |
Fill Factor |
0 |
Do not Recompute Statistics |
|
Full Text Key |
|
Clustered Index |
|
Primary Key Index |
|
Unique Index |
|
Pad Index |
|
Columns
|
Column |
Description |
Sort Order |
|
CustomerConditionType |
Store the Customer Type Valid values are None =0 Customer = 1 Customer Group =2 |
Ascending |
|
CustomerValue |
Stores the value based on the Customer Type chosen |
Ascending |
|
ProductConditionType |
Store the Product Type Valid values are None =0 Product = 1 Product Group =2 |
Ascending |
|
ProductValue |
Stores the value based on the product Type chosen |
Ascending |
|
WarehouseConditionType |
Store the Warehouse Type Valid values are None =0 Warehouse= 1 Store Group =2 |
Ascending |
|
WarehouseValue |
Stores the value based on the Warehouse Type chosen |
Ascending |
|
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 |
Ascending |
|
ConditionValue |
Stores the value for Country or State based on the Condition type |
Ascending |
Index Statistics
Average key length |
|
Density |
|
Rows in the Table |
|
Rows Sampled |
|
Distribution Steps |
|
Updated |
|
See Also
Related Objects
© 2019 All Rights Reserved.
Send comments on this topic.