Navigation: iVend Database Database > Tables > InvInventoryItemLog Table > Indexes >
iVend 6.6 Database Help
IX_InvInventoryItemLog Index
Collapse All Expand All
iVend Database Database > InvInventoryItemLog Table : IX_InvInventoryItemLog Index |
Properties
File Group |
PRIMARY |
Space Used |
64.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 |
|
SourceKey |
Refers to the source document key |
Ascending |
|
SourceType |
Refers to the source document. Valid values are: External = -1 Unknown = 0 GoodsReceipt = 1 GoodsReceiptPO = 2 GoodsReceiptSTN = 3 StockTransfer = 4 KitBuildBreak = 5 StoreUseInventory = 6 SaleTransaction = 7 LayawayTransaction = 8 SpecialOrderTransaction = 9 |
Ascending |
|
InventoryItemLogKey |
Primary key |
Ascending |
Index Statistics
Average key length |
12.90 |
Density |
0.00 |
Rows in the Table |
2013 |
Rows Sampled |
2013 |
Distribution Steps |
1 |
Updated |
Oct 8 2018 5:57PM |
See Also
Related Objects
© 2019 All Rights Reserved.
Send comments on this topic.