Production.ProductInventory (table) - Revision history

Bot at 22:16, 23 June 2010

2010-06-23T22:16:45Z

Bot at 22:06, 2 February 2010

2010-02-02T22:06:11Z

Bot at 21:54, 28 December 2009

2009-12-28T21:54:52Z

Bot at 05:59, 30 November 2009

2009-11-30T05:59:37Z

Bot at 05:34, 30 November 2009

2009-11-30T05:34:58Z

Bot at 05:32, 30 November 2009

2009-11-30T05:32:16Z

Bot at 05:23, 30 November 2009

2009-11-30T05:23:39Z

Bot at 23:13, 26 November 2009

2009-11-26T23:13:05Z

Bot at 23:10, 26 November 2009

2009-11-26T23:10:28Z

Bot at 22:57, 26 November 2009

2009-11-26T22:57:39Z

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Production.ProductInventory
@@ Line 8: / Line 8: @@
 | '''Description
 | Product inventory information.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | ProductID
@@ Line 70: / Line 68: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_ProductInventory_ProductID_LocationID
 | ProductID, LocationID
@@ Line 81: / Line 79: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_ProductInventory_Bin
 | ([Bin]>=(0) AND [Bin]<=(100))
 | Check constraint [Bin] BETWEEN (0) AND (100)
-|-
+|- valign="top"
 | CK_ProductInventory_Shelf
 | ([Shelf] like '[A-Za-z]' OR [Shelf]='N/A')
@@ Line 98: / Line 96: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Production.Location_(table)|Production.Location]]
 | LocationID
 | LocationID
-|-
+|- valign="top"
 | [[Production.Product_(table)|Production.Product]]
 | ProductID
@@ Line 116: / Line 114: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 130: / Line 128: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Select
 | Function

@@ 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
+|
-| Product identification number. Foreign key to Product.ProductID.<br />PK_ProductInventory_ProductID_LocationID
+| Product identification number. Foreign key to Product.ProductID.
 |- valign="top"
 | LocationID
@@ Line 31: / Line 32: @@
 | not null
+|
-| Inventory location identification number. Foreign key to Location.LocationID. <br />PK_ProductInventory_ProductID_LocationID
+| Inventory location identification number. Foreign key to Location.LocationID.
 |- valign="top"
 | Shelf
@@ Line 37: / Line 38: @@
 | not null
+|
-| Storage compartment within an inventory location.<br />
+| Storage compartment within an inventory location.
 |- valign="top"
 | Bin
@@ Line 43: / Line 44: @@
 | not null
+|
-| Storage container on a shelf in an inventory location.<br />
+| Storage container on a shelf in an inventory location.
 |- valign="top"
 | Quantity
@@ Line 49: / Line 50: @@
 | not null
 | ((0))
-| Quantity of products in the inventory location.<br />
+| Quantity of products in the inventory location.
 |- valign="top"
 | rowguid
@@ Line 55: / Line 56: @@
 | not null
 | (newid())
-| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 |- valign="top"
 | ModifiedDate
@@ Line 61: / Line 62: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 82: / Line 109: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 95: / Line 136: @@
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Production.ProductInventory
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | ProductID
 | int
 | not null
+|
-| PK_ProductInventory_ProductID_LocationID
+| Product identification number. Foreign key to Product.ProductID.<br />PK_ProductInventory_ProductID_LocationID
+|- valign="top"
 | LocationID
 | smallint
 | not null
+|
-| PK_ProductInventory_ProductID_LocationID
+| Inventory location identification number. Foreign key to Location.LocationID. <br />PK_ProductInventory_ProductID_LocationID
+|- valign="top"
 | Shelf
 | nvarchar(10)
 | not null
+|
+| Storage compartment within an inventory location.<br />
+|- valign="top"
 | Bin
 | tinyint
 | not null
+|
+| Storage container on a shelf in an inventory location.<br />
+|- valign="top"
 | Quantity
 | smallint
 | not null
 | ((0))
+| Quantity of products in the inventory location.<br />
+|- valign="top"
 | rowguid
 | uniqueidentifier
 | not null
 | (newid())
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 86: / Line 81: @@
 | ProductID
 |}
 == automatically generated ==

@@ Line 93: / Line 93: @@
 | Production.ProductInventory
 |- valign="top"
 | '''Description
 | Product inventory information.
 |-
 |}

@@ Line 181: / Line 181: @@
 | Schema
 | Schema
-| [[Production_(schema)|.Production]]
+| [[Production_(schema)|Production]]
 |}

@@ Line 169: / Line 169: @@
 | ProductID
 | ProductID
 |}
@@ Line 177: / Line 190: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[dbo.ufnGetStock_(function)|dbo.ufnGetStock]]