Difference between revisions of "Purchasing.PurchaseOrderDetail (table)"

From dbscript Online Help
Jump to: navigation, search
Line 128: Line 128:
 
| ON UPDATE
 
| ON UPDATE
 
|}
 
|}
−
 
 
== automatically generated ==
 
== automatically generated ==
  
Line 150: Line 149:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description
+
| '''Description / PK / Index
−
| '''PK / Index
 
 
 
−
|-
+
|- valign="top"
 
| PurchaseOrderID
 
| PurchaseOrderID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID.
+
| Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID.PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
−
| PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
+
|- valign="top"
−
|-
 
 
| PurchaseOrderDetailID
 
| PurchaseOrderDetailID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key. One line number per purchased product.
+
| Primary key. One line number per purchased product.PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
−
| PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
+
|- valign="top"
−
|-
 
 
| DueDate
 
| DueDate
 
| datetime
 
| datetime
Line 173: Line 169:
 
|  
 
|  
 
| Date the product is expected to be received.
 
| Date the product is expected to be received.
−
|
+
|- valign="top"
−
|-
 
 
| OrderQty
 
| OrderQty
 
| smallint
 
| smallint
Line 180: Line 175:
 
|  
 
|  
 
| Quantity ordered.
 
| Quantity ordered.
−
|
+
|- valign="top"
−
|-
 
 
| ProductID
 
| ProductID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| Product identification number. Foreign key to Product.ProductID.
+
| Product identification number. Foreign key to Product.ProductID.IX_PurchaseOrderDetail_ProductID
−
| IX_PurchaseOrderDetail_ProductID
+
|- valign="top"
−
|-
 
 
| UnitPrice
 
| UnitPrice
 
| money
 
| money
Line 194: Line 187:
 
|  
 
|  
 
| Vendor's selling price of a single product.
 
| Vendor's selling price of a single product.
−
|
+
|- valign="top"
−
|-
 
 
| LineTotal
 
| LineTotal
 
|  
 
|  
Line 201: Line 193:
 
|  
 
|  
 
| Per product subtotal. Computed as OrderQty * UnitPrice.
 
| Per product subtotal. Computed as OrderQty * UnitPrice.
−
|
+
|- valign="top"
−
|-
 
 
| ReceivedQty
 
| ReceivedQty
 
| decimal(8, 2)
 
| decimal(8, 2)
Line 208: Line 199:
 
|  
 
|  
 
| Quantity actually received from the vendor.
 
| Quantity actually received from the vendor.
−
|
+
|- valign="top"
−
|-
 
 
| RejectedQty
 
| RejectedQty
 
| decimal(8, 2)
 
| decimal(8, 2)
Line 215: Line 205:
 
|  
 
|  
 
| Quantity rejected during inspection.
 
| Quantity rejected during inspection.
−
|
+
|- valign="top"
−
|-
 
 
| StockedQty
 
| StockedQty
 
|  
 
|  
Line 222: Line 211:
 
|  
 
|  
 
| Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty.
 
| Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty.
−
|
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
Line 229: Line 217:
 
| (GETDATE())
 
| (GETDATE())
 
| Date and time the record was last updated.
 
| Date and time the record was last updated.
−
|
 
 
|}
 
|}
  
Line 262: Line 249:
 
| uPurchaseOrderDetail
 
| uPurchaseOrderDetail
 
| ON UPDATE
 
| ON UPDATE
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Referenced Object
 +
| '''Object Type
 +
| '''Dependency Type
 +
 +
|-
 +
| [[Production.TransactionHistory_(table)|Production.TransactionHistory]]
 +
| Table
 +
| Insert
 +
|-
 +
| [[Production.TransactionHistory_(table)|Production.TransactionHistory]]
 +
| Table
 +
| Insert
 +
|-
 +
| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 +
| Table
 +
| Select
 +
|-
 +
| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 +
| Table
 +
| Select
 +
|-
 +
| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 +
| Table
 +
| Update
 +
|-
 +
| [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
 +
| Table
 +
| Select
 +
|-
 +
| [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
 +
| Table
 +
| Update
 +
|-
 +
| [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
 +
| Table
 +
| Update
 +
|-
 +
| [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
 +
| Procedure
 +
| Execute
 +
|-
 +
| [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
 +
| Procedure
 +
| Execute
 +
|-
 +
| [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]
 +
| Procedure
 +
| Execute
 +
|-
 +
| [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]
 +
| Procedure
 +
| Execute
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Referencing Object
 +
| '''Object Type
 +
| '''Reference Type
 +
 +
|-
 +
| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 +
| Table
 +
| Select
 +
|-
 +
| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 +
| Table
 +
| Select
 +
|-
 +
| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 +
| Table
 +
| Update
 
|}
 
|}

Revision as of 23:57, 26 November 2009

wikibot

Table Purchasing.PurchaseOrderDetail


Column Data Type Nullable Default PK Index
PurchaseOrderID int not null PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
PurchaseOrderDetailID int not null PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
DueDate datetime not null
OrderQty smallint not null
ProductID int not null IX_PurchaseOrderDetail_ProductID
UnitPrice money not null
LineTotal
ReceivedQty decimal(8, 2) not null
RejectedQty decimal(8, 2) not null
StockedQty
ModifiedDate datetime not null (getdate())


Relation Column Referenced Column
Production.Product ProductID ProductID
Purchasing.PurchaseOrderHeader PurchaseOrderID PurchaseOrderID


Triggers Type
iPurchaseOrderDetail ON INSERT
uPurchaseOrderDetail ON UPDATE

automatically generated

Table Purchasing.PurchaseOrderDetail
Description Individual products associated with a specific purchase order. See PurchaseOrderHeader.


Column Data Type Nullable Default Description / PK / Index
PurchaseOrderID int not null Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID.PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
PurchaseOrderDetailID int not null Primary key. One line number per purchased product.PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
DueDate datetime not null Date the product is expected to be received.
OrderQty smallint not null Quantity ordered.
ProductID int not null Product identification number. Foreign key to Product.ProductID.IX_PurchaseOrderDetail_ProductID
UnitPrice money not null Vendor's selling price of a single product.
LineTotal Per product subtotal. Computed as OrderQty * UnitPrice.
ReceivedQty decimal(8, 2) not null Quantity actually received from the vendor.
RejectedQty decimal(8, 2) not null Quantity rejected during inspection.
StockedQty Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty.
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Production.Product ProductID ProductID
Purchasing.PurchaseOrderHeader PurchaseOrderID PurchaseOrderID


Triggers Type
iPurchaseOrderDetail ON INSERT
uPurchaseOrderDetail ON UPDATE


Referenced Object Object Type Dependency Type
Production.TransactionHistory Table Insert
Production.TransactionHistory Table Insert
Purchasing.PurchaseOrderDetail Table Select
Purchasing.PurchaseOrderDetail Table Select
Purchasing.PurchaseOrderDetail Table Update
Purchasing.PurchaseOrderHeader Table Select
Purchasing.PurchaseOrderHeader Table Update
Purchasing.PurchaseOrderHeader Table Update
dbo.uspLogError Procedure Execute
dbo.uspLogError Procedure Execute
dbo.uspPrintError Procedure Execute
dbo.uspPrintError Procedure Execute


Referencing Object Object Type Reference Type
Purchasing.PurchaseOrderDetail Table Select
Purchasing.PurchaseOrderDetail Table Select
Purchasing.PurchaseOrderDetail Table Update
Retrieved from "http://dbshelp.devio.at/index.php?title=Purchasing.PurchaseOrderDetail_(table)&oldid=1230"