Navigation: iVend Database Database > Tables > TrxTransactionPromotionDetail Table > Indexes >
iVend 6.6 Database Help
IX_TrxTransactionPromotionDetail Index
Collapse All Expand All
iVend Database Database > TrxTransactionPromotionDetail Table : IX_TrxTransactionPromotionDetail 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 |
|
TransactionKey |
Reference key of the Transaction. See also Transaction |
Ascending |
|
ItemType |
Stores the type of line item on which the promotion got applied. Valid values are: None = 0 Sales = 1 Order = 2 Layaway = 3 |
Ascending |
|
Type |
Specifies whether the promotion got applied on Principal or Associate item. Valid values are: PrincipalItem = 0 AssociateItem = 1 |
Ascending |
|
PromotionNumber |
Promotion line number to identify transaction line number |
Ascending |
Index Statistics
Average key length |
|
Density |
|
Rows in the Table |
|
Rows Sampled |
|
Distribution Steps |
|
Updated |
|
See Also
Related Objects
TrxTransactionPromotionDetail Table
© 2019 All Rights Reserved.
Send comments on this topic.