Difference between revisions of "Production.Location (table)"

From dbscript Online Help
Jump to: navigation, search
 
(4 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| Production.Location
 
| Production.Location
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| Product inventory and manufacturing locations.
 
| Product inventory and manufacturing locations.
−
|-
 
 
|}
 
|}
  
−
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 18: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description / PK / Index
+
| '''Description
−
+
 
 
|- valign="top"
 
|- valign="top"
 
| LocationID
 
| LocationID
Line 25: Line 24:
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for Location records.<br />PK_Location_LocationID
+
| Primary key for Location records.
 
|- valign="top"
 
|- valign="top"
 
| Name
 
| Name
Line 31: Line 30:
 
| not null
 
| not null
 
|  
 
|  
−
| Location description.<br />AK_Location_Name
+
| Location description.
 
|- valign="top"
 
|- valign="top"
 
| CostRate
 
| CostRate
Line 37: Line 36:
 
| not null
 
| not null
 
| ((0.00))
 
| ((0.00))
−
| Standard hourly cost of the manufacturing location.<br />
+
| Standard hourly cost of the manufacturing location.
 
|- valign="top"
 
|- valign="top"
 
| Availability
 
| Availability
Line 43: Line 42:
 
| not null
 
| not null
 
| ((0.00))
 
| ((0.00))
−
| Work capacity (in hours) of the manufacturing location.<br />
+
| Work capacity (in hours) of the manufacturing location.
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 49: Line 48:
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
| Date and time the record was last updated.<br />
+
| 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_Location_LocationID
 +
| LocationID
 
|}
 
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
  
 +
|- valign="top"
 +
| AK_Location_Name
 +
| Unique
 +
| Name
 +
|}
  
 +
=== Check Constraints ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Check Constraint
 +
| '''Expression
 +
| '''Description
 +
 +
|- valign="top"
 +
| CK_Location_Availability
 +
| ([Availability]>=(0.00))
 +
| Check constraint [Availability] >= (0.00)
 +
|- valign="top"
 +
| CK_Location_CostRate
 +
| ([CostRate]>=(0.00))
 +
| Check constraint [CostRate] >= (0.00)
 +
|}
 +
 +
=== Detail Tables ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 59: Line 97:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Production.ProductInventory_(table)|Production.ProductInventory]]
 
| [[Production.ProductInventory_(table)|Production.ProductInventory]]
 
| LocationID
 
| LocationID
 
| LocationID
 
| LocationID
−
|-
+
|- valign="top"
 
| [[Production.WorkOrderRouting_(table)|Production.WorkOrderRouting]]
 
| [[Production.WorkOrderRouting_(table)|Production.WorkOrderRouting]]
 
| LocationID
 
| LocationID
Line 70: Line 108:
 
|}
 
|}
  
−
 
+
=== References ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 77: Line 115:
 
| '''Referenced Object
 
| '''Referenced Object
  
−
|-
+
|- valign="top"
 
| Data Type
 
| Data Type
 
| Type
 
| Type
 
| [[dbo.Name_(type)|dbo.Name]]
 
| [[dbo.Name_(type)|dbo.Name]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
  
 
|}
 
|}
−
 
  
  
Line 89: Line 131:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table Values
 
| '''Table Values
 
| Production.Location
 
| Production.Location
−
|-
 
 
|}
 
|}
  
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
  
−
{| border="1" cellpadding="5" cellspacing="0"  style="border-collapse:collapse"
 
−
|- style="background:silver"
 
 
| '''LocationID
 
| '''LocationID
 
| '''Name
 
| '''Name
 
| '''CostRate
 
| '''CostRate
 
| '''Availability
 
| '''Availability
−
|-  
+
|- valign="top"
−
| 1
+
 
−
| Tool Crib
+
| 1
−
| 0.00
+
| Tool Crib
−
| 0.00
+
| 0.00
−
|-  
+
| 0.00
−
| 2
+
|- valign="top"
−
| Sheet Metal Racks
+
 
−
| 0.00
+
| 2
−
| 0.00
+
| Sheet Metal Racks
−
|-  
+
| 0.00
−
| 3
+
| 0.00
−
| Paint Shop
+
|- valign="top"
−
| 0.00
+
 
−
| 0.00
+
| 3
−
|-  
+
| Paint Shop
−
| 4
+
| 0.00
−
| Paint Storage
+
| 0.00
−
| 0.00
+
|- valign="top"
−
| 0.00
+
 
−
|-  
+
| 4
−
| 5
+
| Paint Storage
−
| Metal Storage
+
| 0.00
−
| 0.00
+
| 0.00
−
| 0.00
+
|- valign="top"
−
|-  
+
 
−
| 6
+
| 5
−
| Miscellaneous Storage
+
| Metal Storage
−
| 0.00
+
| 0.00
−
| 0.00
+
| 0.00
−
|-  
+
|- valign="top"
−
| 7
+
 
−
| Finished Goods Storage
+
| 6
−
| 0.00
+
| Miscellaneous Storage
−
| 0.00
+
| 0.00
−
|-  
+
| 0.00
−
| 10
+
|- valign="top"
−
| Frame Forming
+
 
−
| 22.50
+
| 7
−
| 96.00
+
| Finished Goods Storage
−
|-  
+
| 0.00
−
| 20
+
| 0.00
−
| Frame Welding
+
|- valign="top"
−
| 25.00
+
 
−
| 108.00
+
| 10
−
|-  
+
| Frame Forming
−
| 30
+
| 22.50
−
| Debur and Polish
+
| 96.00
−
| 14.50
+
|- valign="top"
−
| 120.00
+
 
−
|-  
+
| 20
−
| 40
+
| Frame Welding
−
| Paint
+
| 25.00
−
| 15.75
+
| 108.00
−
| 120.00
+
|- valign="top"
−
|-  
+
 
−
| 45
+
| 30
−
| Specialized Paint
+
| Debur and Polish
−
| 18.00
+
| 14.50
−
| 80.00
+
| 120.00
−
|-  
+
|- valign="top"
−
| 50
+
 
−
| Subassembly
+
| 40
−
| 12.25
+
| Paint
−
| 120.00
+
| 15.75
−
|-  
+
| 120.00
−
| 60
+
|- valign="top"
−
| Final Assembly
+
 
−
| 12.25
+
| 45
−
| 120.00
+
| Specialized Paint
 +
| 18.00
 +
| 80.00
 +
|- valign="top"
 +
 
 +
| 50
 +
| Subassembly
 +
| 12.25
 +
| 120.00
 +
|- valign="top"
 +
 
 +
| 60
 +
| Final Assembly
 +
| 12.25
 +
| 120.00
 
|}
 
|}
  

Latest revision as of 10:55, 27 August 2011

wikibot[edit]

Table Production.Location
Description Product inventory and manufacturing locations.

Columns[edit]

Column Data Type Nullable Default Description
LocationID smallint not null Primary key for Location records.
Name dbo.Name not null Location description.
CostRate smallmoney not null ((0.00)) Standard hourly cost of the manufacturing location.
Availability decimal(8, 2) not null ((0.00)) Work capacity (in hours) of the manufacturing location.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_Location_LocationID LocationID

Indexes[edit]

Index Type Columns
AK_Location_Name Unique Name

Check Constraints[edit]

Check Constraint Expression Description
CK_Location_Availability ([Availability]>=(0.00)) Check constraint [Availability] >= (0.00)
CK_Location_CostRate ([CostRate]>=(0.00)) Check constraint [CostRate] >= (0.00)

Detail Tables[edit]

Detail Table Column Referencing Column
Production.ProductInventory LocationID LocationID
Production.WorkOrderRouting LocationID LocationID

References[edit]

Dependency Type Object Type Referenced Object
Data Type Type dbo.Name
Schema Schema Production


wikivalues[edit]

Table Values Production.Location
LocationID Name CostRate Availability
1 Tool Crib 0.00 0.00
2 Sheet Metal Racks 0.00 0.00
3 Paint Shop 0.00 0.00
4 Paint Storage 0.00 0.00
5 Metal Storage 0.00 0.00
6 Miscellaneous Storage 0.00 0.00
7 Finished Goods Storage 0.00 0.00
10 Frame Forming 22.50 96.00
20 Frame Welding 25.00 108.00
30 Debur and Polish 14.50 120.00
40 Paint 15.75 120.00
45 Specialized Paint 18.00 80.00
50 Subassembly 12.25 120.00
60 Final Assembly 12.25 120.00

automatically generated[edit]

Table Production.Location
Description Product inventory and manufacturing locations.


Column Data Type Nullable Default Description / PK / Index
LocationID smallint not null Primary key for Location records.
PK_Location_LocationID
Name Name not null Location description.
AK_Location_Name
CostRate smallmoney not null (0.00) Standard hourly cost of the manufacturing location.
Availability decimal(8, 2) not null (0.00) Work capacity (in hours) of the manufacturing location.
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Detail Table Column Referencing Column
Production.ProductInventory LocationID LocationID
Production.WorkOrderRouting LocationID LocationID


Dependency Type Object Type Referenced Object
Data Type Type dbo.Name
Schema Schema Production
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.Location_(table)&oldid=2933"