Table 'Production.TransactionHistoryArchive', Transactions for previous years.

Table 'Production.TransactionHistoryArchive', Transactions for previous years.

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

Field statistics for 'TransactionID' int

Field property	Property Value
Minimum value	1
Maximum value	89253
Average value	44627.0
Values variance	663848938.5
Unique values	89253

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	1
Maximum value	999
Average value	734.88867601089044
Values variance	30822.924952772395
Unique values	497

Field statistics for 'ReferenceOrderID' int

Field property	Property Value
Minimum value	1
Maximum value	53449
Average value	35121.18044211399
Values variance	273409591.10356051
Unique values	51380

Field statistics for 'ReferenceOrderLineID' int

Field property	Property Value
Minimum value	0
Maximum value	72
Average value	6.7729824207589662
Values variance	131.79021388662906
Unique values	73

Field statistics for 'TransactionDate' datetime

Field property	Property Value
Minimum value	2001-05-17 00:00:00.000
Maximum value	2003-08-31 00:00:00.000
Unique values	794

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	39570
Average value	34.260002464903138
Values variance	215740.42294159011
Unique values	640

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

Field property	Property Value
Minimum value	.0000
Maximum value	3578.2700
Average value	396.62429128334242
Values variance	598596.82295942004
Unique values	293

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2001-05-17 00:00:00.000
Maximum value	2003-08-31 00:00:00.000
Unique values	794