Difference between revisions of "Production.Location (table)"
Line 12: | Line 12: | ||
+ | === 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 19: | ||
| '''Nullable | | '''Nullable | ||
| '''Default | | '''Default | ||
− | | '''Description | + | | '''Description |
|- valign="top" | |- valign="top" | ||
Line 25: | Line 26: | ||
| not null | | not null | ||
| | | | ||
− | | Primary key for Location records. | + | | Primary key for Location records. |
|- valign="top" | |- valign="top" | ||
| Name | | Name | ||
Line 31: | Line 32: | ||
| not null | | not null | ||
| | | | ||
− | | Location description. | + | | Location description. |
|- valign="top" | |- valign="top" | ||
| CostRate | | CostRate | ||
Line 37: | Line 38: | ||
| not null | | not null | ||
| ((0.00)) | | ((0.00)) | ||
− | | Standard hourly cost of the manufacturing location. | + | | Standard hourly cost of the manufacturing location. |
|- valign="top" | |- valign="top" | ||
| Availability | | Availability | ||
Line 43: | Line 44: | ||
| not null | | not null | ||
| ((0.00)) | | ((0.00)) | ||
− | | Work capacity (in hours) of the manufacturing location. | + | | Work capacity (in hours) of the manufacturing location. |
|- valign="top" | |- valign="top" | ||
| ModifiedDate | | ModifiedDate | ||
Line 49: | Line 50: | ||
| not null | | not null | ||
| (getdate()) | | (getdate()) | ||
− | | Date and time the record was last updated. | + | | 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 | ||
+ | |- | ||
+ | | PK_Location_LocationID | ||
+ | | LocationID | ||
+ | |} | ||
+ | === Indexes === | ||
+ | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
+ | |- style="background:silver" | ||
+ | | '''Index | ||
+ | | '''Type | ||
+ | | '''Columns | ||
+ | |||
+ | |- | ||
+ | | AK_Location_Name | ||
+ | | Unique | ||
+ | | Name | ||
+ | |} | ||
+ | === Check Constraints === | ||
+ | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
+ | |- style="background:silver" | ||
+ | | '''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 === | ||
{| 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 70: | Line 110: | ||
|} | |} | ||
− | + | === 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 81: | Line 121: | ||
| Type | | Type | ||
| [[dbo.Name_(type)|dbo.Name]] | | [[dbo.Name_(type)|dbo.Name]] | ||
+ | |||
+ | |- | ||
+ | | Schema | ||
+ | | Schema | ||
+ | | [[Production_(schema)|Production]] | ||
|} | |} | ||
+ | |||
+ | |||
== wikivalues == | == wikivalues == | ||
Revision as of 23:06, 2 February 2010
Contents
wikibot
Table | Production.Location |
Description | Product inventory and manufacturing locations. |
Columns
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
Primary Key | Columns |
PK_Location_LocationID | LocationID |
Indexes
Index | Type | Columns |
AK_Location_Name | Unique | Name |
Check Constraints
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
Detail Table | Column | Referencing Column |
Production.ProductInventory | LocationID | LocationID |
Production.WorkOrderRouting | LocationID | LocationID |
References
Dependency Type | Object Type | Referenced Object |
Data Type | Type | dbo.Name |
Schema | Schema | Production |
wikivalues
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
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 |