ScrewTurn Wiki

Edit

wikibot

TableProduction.TransactionHistoryArchive
DescriptionTransactions for previous years.

Edit

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.

Edit

Primary Key

Primary KeyColumns
PK_TransactionHistoryArchive_TransactionIDTransactionID

Edit

Indexes

IndexTypeColumns
IX_TransactionHistoryArchive_ProductID ProductID
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID ReferenceOrderID, ReferenceOrderLineID

Edit

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'

Edit

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaProduction

Edit

automatically generated

TableProduction.TransactionHistoryArchive
DescriptionTransactions for previous years.

ColumnData TypeNullableDefaultDescription / PK / Index
TransactionIDintnot null Primary key for TransactionHistoryArchive records.
PK_TransactionHistoryArchive_TransactionID
ProductIDintnot null Product identification number. Foreign key to Product.ProductID.
IX_TransactionHistoryArchive_ProductID
ReferenceOrderIDintnot null Purchase order, sales order, or work order identification number.
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
ReferenceOrderLineIDintnot null(0)Line number associated with the purchase order, sales order, or work order.
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
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.



Dependency TypeObject TypeReferenced Object
SchemaSchemaProduction

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.