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.TransactionHistory_(table)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | Production.TransactionHistory |- valign="top" | '''Description''' | Record of each purchase order, sales order, or work order transaction year to date. |} === 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 TransactionHistory 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 = WorkOrder, S = SalesOrder, P = PurchaseOrder |- 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_TransactionHistory_TransactionID | TransactionID |} === Indexes === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Index''' | '''Type''' | '''Columns''' |- valign="top" | IX_TransactionHistory_ProductID | | ProductID |- valign="top" | IX_TransactionHistory_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_TransactionHistory_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') |} === Foreign Keys === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Relation''' | '''Column''' | '''Referenced Column''' |- valign="top" | [[Production.Product_(table)|Production.Product]] | ProductID | ProductID |} === 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]] |} === Dependencies === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Reference Type''' | '''Object Type''' | '''Referencing Object''' | '''Child Type''' | '''Child Object''' |- valign="top" | Insert | Table | [[Production.WorkOrder_(table)|Production.WorkOrder]] | Trigger | iWorkOrder |- valign="top" | Insert | Table | [[Production.WorkOrder_(table)|Production.WorkOrder]] | Trigger | uWorkOrder |- valign="top" | Insert | Table | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]] | Trigger | iPurchaseOrderDetail |- valign="top" | Insert | Table | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]] | Trigger | uPurchaseOrderDetail |- valign="top" | Insert | Table | [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]] | Trigger | iduSalesOrderDetail |} == automatically generated == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table''' | Production.TransactionHistory |- valign="top" | '''Description''' | Record of each purchase order, sales order, or work order transaction year to date. |- |- |} {| 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 TransactionHistory records.<br />PK_TransactionHistory_TransactionID |- | ProductID | int | not null | | Product identification number. Foreign key to Product.ProductID.<br />IX_TransactionHistory_ProductID |- | ReferenceOrderID | int | not null | | Purchase order, sales order, or work order identification number.<br />IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID |- | ReferenceOrderLineID | int | not null | (0) | Line number associated with the purchase order, sales order, or work order.<br />IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID |- | TransactionDate | datetime | not null | (GETDATE()) | Date and time of the transaction.<br /> |- | TransactionType | nchar(1) | not null | | W = WorkOrder, S = SalesOrder, P = PurchaseOrder<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" | '''Relation''' | '''Column''' | '''Referenced Column''' |- | [[Production.Product_(table)|Production.Product]] | ProductID | ProductID |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- | Schema | Schema | [[Production_(schema)|Production]] |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Reference Type''' | '''Object Type''' | '''Referencing Object''' | '''Child Type''' | '''Child Object''' |- | Insert | Table | [[Production.WorkOrder_(table)|Production.WorkOrder]] | Trigger | iWorkOrder |- | Insert | Table | [[Production.WorkOrder_(table)|Production.WorkOrder]] | Trigger | uWorkOrder |- | Insert | Table | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]] | Trigger | iPurchaseOrderDetail |- | Insert | Table | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]] | Trigger | uPurchaseOrderDetail |- | Insert | Table | [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]] | Trigger | iduSalesOrderDetail |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.