Production.TransactionHistoryArchive

Table: 'Production.TransactionHistoryArchive'

9 fields. 75 bytes.

Transactions for previous years.

Field Name Data Type Size Original Type Default Nullable Description Check

TransactionID int Not null Primary key for TransactionHistoryArchive 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 = Work Order, S = Sales Order, P = Purchase Order (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				Not null	Primary key for TransactionHistoryArchive 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 = Work Order, S = Sales Order, P = Purchase Order	(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.TransactionHistoryArchive'

Primary Key Name Field Name

PK_TransactionHistoryArchive_TransactionID TransactionID

There are no Foreign Keys for this table.

Primary Key Name	Field Name
PK_TransactionHistoryArchive_TransactionID	TransactionID

Indexes for table 'Production.TransactionHistoryArchive', 3 items

Index Name Description Clustered Unique Fields

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

IX_TransactionHistoryArchive_ProductID Nonclustered index. No No ProductID

IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID Nonclustered index. No No ReferenceOrderID, ReferenceOrderLineID

Index Name	Description	Clustered	Unique	Fields
PK_TransactionHistoryArchive_TransactionID	Clustered index created by a primary key constraint.	Yes	Yes	TransactionID
IX_TransactionHistoryArchive_ProductID	Nonclustered index.	No	No	ProductID
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID	Nonclustered index.	No	No	ReferenceOrderID, ReferenceOrderLineID

Triggers for table 'Production.TransactionHistoryArchive', 1 item

Name Description Type Enabled

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

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

Dependencies for table 'Production.TransactionHistoryArchive', 2 items

Object Name Type Field Name

Production.CK_TransactionHistoryArchive_TransactionType check cns N/A

Production.uTransactionHistoryArchive trigger N/A

Object Name	Type	Field Name
Production.CK_TransactionHistoryArchive_TransactionType	check cns	N/A
Production.uTransactionHistoryArchive	trigger	N/A