Navigation: iVend Database Database > Tables > ProCoupon Table > Indexes >
iVend 6.6 Database Help
IX_ProCoupon Index
Collapse All Expand All
iVend Database Database > ProCoupon Table : IX_ProCoupon Index |
Properties
File Group |
PRIMARY |
Space Used |
16.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 |
|
IsDeleted |
Value is True if the record has been deleted from the system. Record is always Soft Deleted |
Ascending |
|
StartDate |
Stores the validity start date of the coupon. The default value for this field is current date. |
Ascending |
|
EndDate |
Stores the validity end date of the coupon. |
Ascending |
|
UPCCode |
Stores the Universal Product Code (UPC) for the Coupon (UPC is a type of bar code) |
Ascending |
|
CanIssueAtPOS |
The value is True if the coupon can be issued at Point Of Sale. |
Ascending |
Index Statistics
Average key length |
50.29 |
Density |
0.00 |
Rows in the Table |
7 |
Rows Sampled |
7 |
Distribution Steps |
1 |
Updated |
Oct 8 2018 5:57PM |
See Also
Related Objects
© 2019 All Rights Reserved.
Send comments on this topic.