Production TransactionHistoryArchive (table)

wikibot

TableProduction.TransactionHistoryArchive
DescriptionTransactions for previous years.

Columns

ColumnData TypeNullableDefaultDescription
TransactionIDintnot null Primary key for TransactionHistoryArchive records.
ProductIDintnot null Product identification number. Foreign key to Product.ProductID.
ReferenceOrderIDintnot null Purchase order, sales order, or work order identification number.
ReferenceOrderLineIDintnot null((0))Line number associated with the purchase order, sales order, or work order.
TransactionDatedatetimenot null(getdate())Date and time of the transaction.
TransactionTypenchar(1)not null W = Work Order, S = Sales Order, P = Purchase Order
Quantityintnot null Product quantity.
ActualCostmoneynot null Product cost.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_TransactionHistoryArchive_TransactionIDTransactionID

Indexes

IndexTypeColumns
IX_TransactionHistoryArchive_ProductID ProductID
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID ReferenceOrderID, ReferenceOrderLineID

Check Constraints

Check ConstraintExpressionDescription
CK_TransactionHistoryArchive_TransactionType(upper(TransactionType)='P' OR upper(TransactionType)='S' OR upper(TransactionType)='W')Check constraint TransactionType='p' OR TransactionType='s' OR TransactionType='w' OR TransactionType='P' OR TransactionType='S' OR TransactionType='W'

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaProduction