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

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

Property NameProperty Value
Records89253
Fields9
Record size (bytes) w/o BLOBs75

Field statistics for 'TransactionID' int

Field propertyProperty Value
Minimum value1
Maximum value89253
Average value44627.0
Values variance663848938.5
Unique values89253

Field statistics for 'ProductID' int

Field propertyProperty Value
Minimum value1
Maximum value999
Average value734.88867601089044
Values variance30822.924952772395
Unique values497

Field statistics for 'ReferenceOrderID' int

Field propertyProperty Value
Minimum value1
Maximum value53449
Average value35121.18044211399
Values variance273409591.10356051
Unique values51380

Field statistics for 'ReferenceOrderLineID' int

Field propertyProperty Value
Minimum value0
Maximum value72
Average value6.7729824207589662
Values variance131.79021388662906
Unique values73

Field statistics for 'TransactionDate' datetime

Field propertyProperty Value
Minimum value2001-05-17 00:00:00.000
Maximum value2003-08-31 00:00:00.000
Unique values794

Field statistics for 'TransactionType' nchar(1)

Field propertyProperty Value
Minimum valueP
Maximum valueW
Unique values3

Field statistics for 'Quantity' int

Field propertyProperty Value
Minimum value1
Maximum value39570
Average value34.260002464903138
Values variance215740.42294159011
Unique values640

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

Field propertyProperty Value
Minimum value.0000
Maximum value3578.2700
Average value396.62429128334242
Values variance598596.82295942004
Unique values293

Field statistics for 'ModifiedDate' datetime

Field propertyProperty Value
Minimum value2001-05-17 00:00:00.000
Maximum value2003-08-31 00:00:00.000
Unique values794