Production.TransactionHistoryArchive (table)

wikibot

Table	Production.TransactionHistoryArchive
Description	Transactions for previous years.

Column	Data Type	Nullable	Default	Description / PK / Index
TransactionID	int	not null		Primary key for TransactionHistoryArchive records. PK_TransactionHistoryArchive_TransactionID
ProductID	int	not null		Product identification number. Foreign key to Product.ProductID. IX_TransactionHistoryArchive_ProductID
ReferenceOrderID	int	not null		Purchase order, sales order, or work order identification number. IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
ReferenceOrderLineID	int	not null	((0))	Line number associated with the purchase order, sales order, or work order. IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
TransactionDate	datetime	not null	(getdate())	Date and time of the transaction.
TransactionType	nchar(1)	not null		W = Work Order, S = Sales Order, P = Purchase Order
Quantity	int	not null		Product quantity.
ActualCost	money	not null		Product cost.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

automatically generated

Table	Production.TransactionHistoryArchive
Description	Transactions for previous years.

Column	Data Type	Nullable	Default	Description / PK / Index
TransactionID	int	not null		Primary key for TransactionHistoryArchive records. PK_TransactionHistoryArchive_TransactionID
ProductID	int	not null		Product identification number. Foreign key to Product.ProductID. IX_TransactionHistoryArchive_ProductID
ReferenceOrderID	int	not null		Purchase order, sales order, or work order identification number. IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
ReferenceOrderLineID	int	not null	(0)	Line number associated with the purchase order, sales order, or work order. IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
TransactionDate	datetime	not null	(GETDATE())	Date and time of the transaction.
TransactionType	nchar(1)	not null		W = Work Order, S = Sales Order, P = Purchase Order
Quantity	int	not null		Product quantity.
ActualCost	money	not null		Product cost.
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Dependency Type	Object Type	Referenced Object
Schema	Schema	Production