Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Production TransactionHistoryArchive (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 17:49


wikibot

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.

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