ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
Production.TransactionHistoryArchive_(table)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | Production.TransactionHistoryArchive |- valign="top" | '''Description''' | Transactions for previous years. |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | TransactionID | int | not null | | Primary key for TransactionHistoryArchive records. |- valign="top" | ProductID | int | not null | | Product identification number. Foreign key to Product.ProductID. |- valign="top" | ReferenceOrderID | int | not null | | Purchase order, sales order, or work order identification number. |- valign="top" | ReferenceOrderLineID | int | not null | ((0)) | Line number associated with the purchase order, sales order, or work order. |- valign="top" | TransactionDate | datetime | not null | (getdate()) | Date and time of the transaction. |- valign="top" | TransactionType | nchar(1) | not null | | W = Work Order, S = Sales Order, P = Purchase Order |- valign="top" | Quantity | int | not null | | Product quantity. |- valign="top" | ActualCost | money | not null | | Product cost. |- valign="top" | ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |} === Primary Key === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Primary Key''' | '''Columns''' |- valign="top" | PK_TransactionHistoryArchive_TransactionID | TransactionID |} === Indexes === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Index''' | '''Type''' | '''Columns''' |- valign="top" | IX_TransactionHistoryArchive_ProductID | | ProductID |- valign="top" | IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID | | ReferenceOrderID, ReferenceOrderLineID |} === Check Constraints === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Check Constraint''' | '''Expression''' | '''Description''' |- valign="top" | 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 === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- valign="top" | Schema | Schema | [[Production_(schema)|Production]] |} == automatically generated == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table''' | Production.TransactionHistoryArchive |- valign="top" | '''Description''' | Transactions for previous years. |- |- |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description / PK / Index''' |- | TransactionID | int | not null | | Primary key for TransactionHistoryArchive records.<br />PK_TransactionHistoryArchive_TransactionID |- | ProductID | int | not null | | Product identification number. Foreign key to Product.ProductID.<br />IX_TransactionHistoryArchive_ProductID |- | ReferenceOrderID | int | not null | | Purchase order, sales order, or work order identification number.<br />IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID |- | ReferenceOrderLineID | int | not null | (0) | Line number associated with the purchase order, sales order, or work order.<br />IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID |- | TransactionDate | datetime | not null | (GETDATE()) | Date and time of the transaction.<br /> |- | TransactionType | nchar(1) | not null | | W = Work Order, S = Sales Order, P = Purchase Order<br /> |- | Quantity | int | not null | | Product quantity.<br /> |- | ActualCost | money | not null | | Product cost.<br /> |- | ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated.<br /> |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- | Schema | Schema | [[Production_(schema)|Production]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.