Production.TransactionHistoryArchive (table) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:00Z

Bot at 22:05, 2 February 2010

2010-02-02T22:05:07Z

Bot at 21:52, 2 February 2010

2010-02-02T21:52:25Z

Bot at 21:55, 28 December 2009

2009-12-28T21:55:43Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:27Z

Bot at 05:35, 30 November 2009

2009-11-30T05:35:50Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:37Z

Bot at 23:11, 26 November 2009

2009-11-26T23:11:19Z

Bot at 22:58, 26 November 2009

2009-11-26T22:58:31Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:43Z

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Production.TransactionHistoryArchive
@@ Line 8: / Line 8: @@
 | '''Description
 | Transactions for previous years.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | TransactionID
@@ Line 82: / Line 80: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_TransactionHistoryArchive_TransactionID
 | TransactionID
@@ Line 93: / Line 91: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | IX_TransactionHistoryArchive_ProductID
+|
 | ProductID
-|-
+|- valign="top"
 | IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
+|
@@ Line 110: / Line 108: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_TransactionHistoryArchive_TransactionType
 | (upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W')
@@ Line 124: / Line 122: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema

@@ Line 115: / Line 115: @@
 | (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'
 |}

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key for TransactionHistoryArchive records.<br />PK_TransactionHistoryArchive_TransactionID
+| Primary key for TransactionHistoryArchive records.
 |- valign="top"
 | ProductID
@@ Line 31: / Line 32: @@
 | not null
+|
-| Product identification number. Foreign key to Product.ProductID.<br />IX_TransactionHistoryArchive_ProductID
+| Product identification number. Foreign key to Product.ProductID.
 |- valign="top"
 | ReferenceOrderID
@@ Line 37: / Line 38: @@
 | not null
+|
-| Purchase order, sales order, or work order identification number.<br />IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
+| Purchase order, sales order, or work order identification number.
 |- valign="top"
 | ReferenceOrderLineID
@@ Line 43: / Line 44: @@
 | not null
 | ((0))
-| Line number associated with the purchase order, sales order, or work order.<br />IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
+| Line number associated with the purchase order, sales order, or work order.
 |- valign="top"
 | TransactionDate
@@ Line 49: / Line 50: @@
 | not null
 | (getdate())
-| Date and time of the transaction.<br />
+| Date and time of the transaction.
 |- valign="top"
 | TransactionType
@@ Line 55: / Line 56: @@
 | not null
+|
-| W = Work Order, S = Sales Order, P = Purchase Order<br />
+| W = Work Order, S = Sales Order, P = Purchase Order
 |- valign="top"
 | Quantity
@@ Line 61: / Line 62: @@
 | not null
+|
-| Product quantity.<br />
+| Product quantity.
 |- valign="top"
 | ActualCost
@@ Line 67: / Line 68: @@
 | not null
+|
-| Product cost.<br />
+| Product cost.
 |- valign="top"
 | ModifiedDate
@@ Line 73: / Line 74: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Production.TransactionHistoryArchive
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | TransactionID
 | int
 | not null
+|
-| PK_TransactionHistoryArchive_TransactionID
+| Primary key for TransactionHistoryArchive records.<br />PK_TransactionHistoryArchive_TransactionID
+|- valign="top"
 | ProductID
 | int
 | not null
+|
+| Product identification number. Foreign key to Product.ProductID.<br />IX_TransactionHistoryArchive_ProductID
-| IX_TransactionHistoryArchive_ProductID
+|- valign="top"
 | ReferenceOrderID
 | int
 | not null
+|
+| Purchase order, sales order, or work order identification number.<br />IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
-| IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
+|- valign="top"
 | ReferenceOrderLineID
 | int
 | not null
 | ((0))
+| Line number associated with the purchase order, sales order, or work order.<br />IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
-| IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
+|- valign="top"
 | TransactionDate
 | datetime
 | not null
 | (getdate())
+| Date and time of the transaction.<br />
+|- valign="top"
 | TransactionType
 | nchar(1)
 | not null
+|
+| W = Work Order, S = Sales Order, P = Purchase Order<br />
+|- valign="top"
 | Quantity
 | int
 | not null
+|
+| Product quantity.<br />
+|- valign="top"
 | ActualCost
 | money
 | not null
+|
+| Product cost.<br />
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
 == automatically generated ==

@@ Line 89: / Line 89: @@
 | Production.TransactionHistoryArchive
 |- valign="top"
 | '''Description
 | Transactions for previous years.
 |-
 |}

@@ Line 159: / Line 159: @@
 | (GETDATE())
 | Date and time the record was last updated.<br />
 |}