Table 'Production.TransactionHistory', Record of each purchase order, sales order, or work order transaction year to date.

Table 'Production.TransactionHistory', Record of each purchase order, sales order, or work order transaction year to date.

Property Name	Property Value
Records	113443
Fields	9
Record size (bytes) w/o BLOBs	75

Field statistics for 'TransactionID' int identity

Field property	Property Value
Minimum value	100000
Maximum value	213442
Average value	156721.0
Values variance	1072452307.6666666
Unique values	113443

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	1
Maximum value	999
Average value	813.31752510071135
Values variance	29559.593108622423
Unique values	441

Field statistics for 'ReferenceOrderID' int

Field property	Property Value
Minimum value	417
Maximum value	75123
Average value	57587.75930643583
Values variance	285365944.52746665
Unique values	37118

Field statistics for 'ReferenceOrderLineID' int

Field property	Property Value
Minimum value	0
Maximum value	71
Average value	4.6712886647920104
Values variance	78.151851644982401
Unique values	72

Field statistics for 'TransactionDate' datetime

Field property	Property Value
Minimum value	2003-09-01 00:00:00.000
Maximum value	2004-09-03 00:00:00.000
Unique values	365

Field statistics for 'TransactionType' nchar(1)

Field property	Property Value
Minimum value	P
Maximum value	W
Unique values	3

Field statistics for 'Quantity' int

Field property	Property Value
Minimum value	1
Maximum value	39270
Average value	35.059095757340693
Values variance	141813.18800640013
Unique values	455

Field statistics for 'ActualCost' money(19,4)

Field property	Property Value
Minimum value	.0000
Maximum value	2443.3500
Average value	240.71411328752288
Values variance	305892.94481861318
Unique values	252

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2003-09-01 00:00:00.000
Maximum value	2004-09-03 00:00:00.000
Unique values	365