Navigation: iVend Database Database > Tables > TrxTransaction Table > Indexes >
iVend 6.6 Database Help
IX_TrxTransaction Index
Collapse All Expand All
iVend Database Database > TrxTransaction Table : IX_TrxTransaction 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 |
System generated Primary Key |
Ascending |
|
BusinessDate |
Business date of the store |
Ascending |
|
IsSuspended |
Signifies whether the transaction is a suspended transaction or not |
Ascending |
|
POSKey |
Reference Key of POS at which the transaction is made. See also POS |
Ascending |
|
StoreKey |
Reference Key of Store at which the POS is connected. See also Store |
Ascending |
|
TransactionId |
A number is generated according to the Transaction Numbering Settings at RetailProfile |
Ascending |
|
CustomerKey |
Reference Key of Customer for which the transaction is made. See also Customer |
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.