Owner: Production 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB: 6304 
Index Size KB: 2992 
Rows: 113443 
Description: Record of each purchase order, sales order, or work order transaction year to date. 


Name Data Type Length NULL Default IsIdentity IsGUID Description
    TransactionID  int          Primary key for TransactionHistory records. 
    ProductID  int          Product identification number. Foreign key to Product.ProductID. 
    ReferenceOrderID  int          Purchase order, sales order, or work order identification number. 
    ReferenceOrderLineID  int    ((0))      Line number associated with the purchase order, sales order, or work order. 
    TransactionDate  datetime    (getdate())      Date and time of the transaction. 
    TransactionType  nchar          W = WorkOrder, S = SalesOrder, P = PurchaseOrder 
    Quantity  int          Product quantity. 
    ActualCost  money          Product cost. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 9 column(s)

Identity column

Name Seed Increment Not for replication
  TransactionID  100000   


Index Primary Unique Description
  PK_TransactionHistory_TransactionID      Primary key (clustered) constraint 
  IX_TransactionHistory_ProductID      Nonclustered index. 
  IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID      Nonclustered index. 
Total: 3 index(es)

Check Constraints

Name Expression
  CK_TransactionHistory_TransactionType  (upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W') 
Total: 1 constraint(s)

Referenced Tables

Table Foreign Key Primary Key or Unique Constraint
  Production.Product  FK_TransactionHistory_Product_ProductID  PK_Product_ProductID 
Total: 1 table(s)

Objects that [Production].[TransactionHistory] depends on

Object Name Owner Object Type Dep Level
  Flag  dbo  User Defined type 
  Name  dbo  User Defined type 
  ProductCategory  Production  Table 
  ProductModel  Production  Table 
  UnitMeasure  Production  Table 
  ProductSubcategory  Production  Table 
  Product  Production  Table 
Total: 7 object(s)

Objects that depend on [Production].[TransactionHistory]

Object Name Owner Object Type Dep Level
  iduSalesOrderDetail  Sales  Trigger 
  iPurchaseOrderDetail  Purchasing  Trigger 
  iWorkOrder  Production  Trigger 
  uPurchaseOrderDetail  Purchasing  Trigger 
  uWorkOrder  Production  Trigger 
Total: 5 object(s)


CREATE TABLE [TransactionHistory] (
    [TransactionID] [int] IDENTITY (100000, 1) NOT NULL ,
    [ProductID] [int] NOT NULL ,
    [ReferenceOrderID] [int] NOT NULL ,
    [ReferenceOrderLineID] [int] NOT NULL CONSTRAINT [DF_TransactionHistory_ReferenceOrderLineID] DEFAULT ((0)),
    [TransactionDate] [datetime] NOT NULL CONSTRAINT [DF_TransactionHistory_TransactionDate] DEFAULT (getdate()),
    [TransactionType] [nchar] (1) COLLATE Latin1_General_CS_AS NOT NULL ,
    [Quantity] [int] NOT NULL ,
    [ActualCost] [money] NOT NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_TransactionHistory_ModifiedDate] DEFAULT (getdate()),
    CONSTRAINT [PK_TransactionHistory_TransactionID] PRIMARY KEY  CLUSTERED
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_TransactionHistory_Product_ProductID] FOREIGN KEY
    ) REFERENCES [Product] (
    CONSTRAINT [CK_TransactionHistory_TransactionType] CHECK (upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W')

See Also

List of tables