Production.TransactionHistory

Table: 'Production.TransactionHistory'

9 fields. 75 bytes.

Record of each purchase order, sales order, or work order transaction year to date.

Field Name Data Type Size Original Type Default Nullable Description Check

TransactionID int identity int Not null Primary key for TransactionHistory records.

ProductID int Not null Product identification number. Foreign key to Product.ProductID.

ReferenceOrderID int Not null Purchase order, sales order, or work order identification number.

ReferenceOrderLineID int (0) Not null Line number associated with the purchase order, sales order, or work order.

TransactionDate datetime getdate() Not null Date and time of the transaction.

TransactionType nchar 1 Not null W = WorkOrder, S = SalesOrder, P = PurchaseOrder (upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W')

Quantity int Not null Product quantity.

ActualCost money 19,4 decimal(19,4) Not null Product cost.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
TransactionID	int identity		int		Not null	Primary key for TransactionHistory records.
ProductID	int				Not null	Product identification number. Foreign key to Product.ProductID.
ReferenceOrderID	int				Not null	Purchase order, sales order, or work order identification number.
ReferenceOrderLineID	int			(0)	Not null	Line number associated with the purchase order, sales order, or work order.
TransactionDate	datetime			getdate()	Not null	Date and time of the transaction.
TransactionType	nchar	1			Not null	W = WorkOrder, S = SalesOrder, P = PurchaseOrder	(upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W')
Quantity	int				Not null	Product quantity.
ActualCost	money	19,4	decimal(19,4)		Not null	Product cost.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Production.TransactionHistory'

Primary Key Name Field Name

PK_TransactionHistory_TransactionID TransactionID

Primary Key Name	Field Name
PK_TransactionHistory_TransactionID	TransactionID

Foreign keys for table 'Production.TransactionHistory', 1 item

Foreign Primary Key Name

TransactionHistory.ProductID Product.ProductID FK_TransactionHistory_Product_ProductID

Foreign	Primary	Key Name
TransactionHistory.ProductID	Product.ProductID	FK_TransactionHistory_Product_ProductID

Indexes for table 'Production.TransactionHistory', 3 items

Index Name Description Clustered Unique Fields

PK_TransactionHistory_TransactionID Clustered index created by a primary key constraint. Yes Yes TransactionID

IX_TransactionHistory_ProductID Nonclustered index. No No ProductID

IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID Nonclustered index. No No ReferenceOrderID, ReferenceOrderLineID

Index Name	Description	Clustered	Unique	Fields
PK_TransactionHistory_TransactionID	Clustered index created by a primary key constraint.	Yes	Yes	TransactionID
IX_TransactionHistory_ProductID	Nonclustered index.	No	No	ProductID
IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID	Nonclustered index.	No	No	ReferenceOrderID, ReferenceOrderLineID

Triggers for table 'Production.TransactionHistory', 1 item

Name Description Type Enabled

uTransactionHistory AFTER UPDATE trigger setting the ModifiedDate column in the TransactionHistory table to the current date. after Update Yes

Name	Description	Type	Enabled
uTransactionHistory	AFTER UPDATE trigger setting the ModifiedDate column in the TransactionHistory table to the current date.	after Update	Yes

Dependencies for table 'Production.TransactionHistory', 7 items

Object Name Type Field Name

Production.CK_TransactionHistory_TransactionType check cns N/A

Production.iWorkOrder trigger N/A

Production.uTransactionHistory trigger N/A

Production.uWorkOrder trigger N/A

Purchasing.iPurchaseOrderDetail trigger N/A

Purchasing.uPurchaseOrderDetail trigger N/A

Sales.iduSalesOrderDetail trigger N/A

Object Name	Type	Field Name
Production.CK_TransactionHistory_TransactionType	check cns	N/A
Production.iWorkOrder	trigger	N/A
Production.uTransactionHistory	trigger	N/A
Production.uWorkOrder	trigger	N/A
Purchasing.iPurchaseOrderDetail	trigger	N/A
Purchasing.uPurchaseOrderDetail	trigger	N/A
Sales.iduSalesOrderDetail	trigger	N/A