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 NameProperty Value
Records113443
Fields9
Record size (bytes) w/o BLOBs75

Field statistics for 'TransactionID' int identity

Field propertyProperty Value
Minimum value100000
Maximum value213442
Average value156721.0
Values variance1072452307.6666666
Unique values113443

Field statistics for 'ProductID' int

Field propertyProperty Value
Minimum value1
Maximum value999
Average value813.31752510071135
Values variance29559.593108622423
Unique values441

Field statistics for 'ReferenceOrderID' int

Field propertyProperty Value
Minimum value417
Maximum value75123
Average value57587.75930643583
Values variance285365944.52746665
Unique values37118

Field statistics for 'ReferenceOrderLineID' int

Field propertyProperty Value
Minimum value0
Maximum value71
Average value4.6712886647920104
Values variance78.151851644982401
Unique values72

Field statistics for 'TransactionDate' datetime

Field propertyProperty Value
Minimum value2003-09-01 00:00:00.000
Maximum value2004-09-03 00:00:00.000
Unique values365

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 value39270
Average value35.059095757340693
Values variance141813.18800640013
Unique values455

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

Field propertyProperty Value
Minimum value.0000
Maximum value2443.3500
Average value240.71411328752288
Values variance305892.94481861318
Unique values252

Field statistics for 'ModifiedDate' datetime

Field propertyProperty Value
Minimum value2003-09-01 00:00:00.000
Maximum value2004-09-03 00:00:00.000
Unique values365