Editing Sales.SalesOrderHeader (table)
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
− | |- | + | |- |
| '''Table | | '''Table | ||
| Sales.SalesOrderHeader | | Sales.SalesOrderHeader | ||
Line 8: | Line 8: | ||
| '''Description | | '''Description | ||
| General sales order information. | | General sales order information. | ||
+ | |- | ||
|} | |} | ||
+ | |||
=== Columns === | === Columns === | ||
Line 18: | Line 20: | ||
| '''Default | | '''Default | ||
| '''Description | | '''Description | ||
− | + | ||
|- valign="top" | |- valign="top" | ||
| SalesOrderID | | SalesOrderID | ||
Line 188: | Line 190: | ||
| '''Primary Key | | '''Primary Key | ||
| '''Columns | | '''Columns | ||
− | |- | + | |- |
| PK_SalesOrderHeader_SalesOrderID | | PK_SalesOrderHeader_SalesOrderID | ||
| SalesOrderID | | SalesOrderID | ||
Line 199: | Line 201: | ||
| '''Type | | '''Type | ||
| '''Columns | | '''Columns | ||
− | + | ||
− | |- | + | |- |
| AK_SalesOrderHeader_rowguid | | AK_SalesOrderHeader_rowguid | ||
| Unique | | Unique | ||
| rowguid | | rowguid | ||
− | |- | + | |- |
| AK_SalesOrderHeader_SalesOrderNumber | | AK_SalesOrderHeader_SalesOrderNumber | ||
| Unique | | Unique | ||
| SalesOrderNumber | | SalesOrderNumber | ||
− | |- | + | |- |
| IX_SalesOrderHeader_CustomerID | | IX_SalesOrderHeader_CustomerID | ||
| | | | ||
| CustomerID | | CustomerID | ||
− | |- | + | |- |
| IX_SalesOrderHeader_SalesPersonID | | IX_SalesOrderHeader_SalesPersonID | ||
| | | | ||
Line 224: | Line 226: | ||
| '''Expression | | '''Expression | ||
| '''Description | | '''Description | ||
− | + | ||
− | |- | + | |- |
| CK_SalesOrderHeader_DueDate | | CK_SalesOrderHeader_DueDate | ||
| ([DueDate]>=[OrderDate]) | | ([DueDate]>=[OrderDate]) | ||
| Check constraint [DueDate] >= [OrderDate] | | Check constraint [DueDate] >= [OrderDate] | ||
− | |- | + | |- |
| CK_SalesOrderHeader_Freight | | CK_SalesOrderHeader_Freight | ||
| ([Freight]>=(0.00)) | | ([Freight]>=(0.00)) | ||
| Check constraint [Freight] >= (0.00) | | Check constraint [Freight] >= (0.00) | ||
− | |- | + | |- |
| CK_SalesOrderHeader_ShipDate | | CK_SalesOrderHeader_ShipDate | ||
| ([ShipDate]>=[OrderDate] OR [ShipDate] IS NULL) | | ([ShipDate]>=[OrderDate] OR [ShipDate] IS NULL) | ||
| Check constraint [ShipDate] >= [OrderDate] OR [ShipDate] IS NULL | | Check constraint [ShipDate] >= [OrderDate] OR [ShipDate] IS NULL | ||
− | |- | + | |- |
| CK_SalesOrderHeader_Status | | CK_SalesOrderHeader_Status | ||
| ([Status]>=(0) AND [Status]<=(8)) | | ([Status]>=(0) AND [Status]<=(8)) | ||
| Check constraint [Status] BETWEEN (0) AND (8) | | Check constraint [Status] BETWEEN (0) AND (8) | ||
− | |- | + | |- |
| CK_SalesOrderHeader_SubTotal | | CK_SalesOrderHeader_SubTotal | ||
| ([SubTotal]>=(0.00)) | | ([SubTotal]>=(0.00)) | ||
| Check constraint [SubTotal] >= (0.00) | | Check constraint [SubTotal] >= (0.00) | ||
− | |- | + | |- |
| CK_SalesOrderHeader_TaxAmt | | CK_SalesOrderHeader_TaxAmt | ||
| ([TaxAmt]>=(0.00)) | | ([TaxAmt]>=(0.00)) | ||
Line 257: | Line 259: | ||
| '''Column | | '''Column | ||
| '''Referenced Column | | '''Referenced Column | ||
− | + | ||
− | |- | + | |- |
| [[Person.Address_(table)|Person.Address]] | | [[Person.Address_(table)|Person.Address]] | ||
| BillToAddressID | | BillToAddressID | ||
| AddressID | | AddressID | ||
− | |- | + | |- |
| [[Person.Address_(table)|Person.Address]] | | [[Person.Address_(table)|Person.Address]] | ||
| ShipToAddressID | | ShipToAddressID | ||
| AddressID | | AddressID | ||
− | |- | + | |- |
| [[Person.Contact_(table)|Person.Contact]] | | [[Person.Contact_(table)|Person.Contact]] | ||
| ContactID | | ContactID | ||
| ContactID | | ContactID | ||
− | |- | + | |- |
| [[Sales.CreditCard_(table)|Sales.CreditCard]] | | [[Sales.CreditCard_(table)|Sales.CreditCard]] | ||
| CreditCardID | | CreditCardID | ||
| CreditCardID | | CreditCardID | ||
− | |- | + | |- |
| [[Sales.CurrencyRate_(table)|Sales.CurrencyRate]] | | [[Sales.CurrencyRate_(table)|Sales.CurrencyRate]] | ||
| CurrencyRateID | | CurrencyRateID | ||
| CurrencyRateID | | CurrencyRateID | ||
− | |- | + | |- |
| [[Sales.Customer_(table)|Sales.Customer]] | | [[Sales.Customer_(table)|Sales.Customer]] | ||
| CustomerID | | CustomerID | ||
| CustomerID | | CustomerID | ||
− | |- | + | |- |
| [[Sales.SalesPerson_(table)|Sales.SalesPerson]] | | [[Sales.SalesPerson_(table)|Sales.SalesPerson]] | ||
| SalesPersonID | | SalesPersonID | ||
| SalesPersonID | | SalesPersonID | ||
− | |- | + | |- |
| [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]] | | [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]] | ||
| TerritoryID | | TerritoryID | ||
| TerritoryID | | TerritoryID | ||
− | |- | + | |- |
| [[Purchasing.ShipMethod_(table)|Purchasing.ShipMethod]] | | [[Purchasing.ShipMethod_(table)|Purchasing.ShipMethod]] | ||
| ShipMethodID | | ShipMethodID | ||
Line 302: | Line 304: | ||
| '''Column | | '''Column | ||
| '''Referencing Column | | '''Referencing Column | ||
− | + | ||
− | |- | + | |- |
| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]] | | [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]] | ||
| SalesOrderID | | SalesOrderID | ||
| SalesOrderID | | SalesOrderID | ||
− | |- | + | |- |
| [[Sales.SalesOrderHeaderSalesReason_(table)|Sales.SalesOrderHeaderSalesReason]] | | [[Sales.SalesOrderHeaderSalesReason_(table)|Sales.SalesOrderHeaderSalesReason]] | ||
| SalesOrderID | | SalesOrderID | ||
Line 316: | Line 318: | ||
{| 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" | ||
− | | ''' | + | | '''Triggers |
| '''Type | | '''Type | ||
− | + | ||
− | |- | + | |- |
| uSalesOrderHeader | | uSalesOrderHeader | ||
| ON UPDATE | | ON UPDATE | ||
|} | |} | ||
− | + | Trigger uSalesOrderHeader | |
<pre> | <pre> | ||
CREATE TRIGGER [Sales].[uSalesOrderHeader] ON [Sales].[SalesOrderHeader] | CREATE TRIGGER [Sales].[uSalesOrderHeader] ON [Sales].[SalesOrderHeader] | ||
Line 395: | Line 397: | ||
END; | END; | ||
</pre> | </pre> | ||
− | + | ||
=== References === | === References === | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
Line 406: | Line 408: | ||
| '''Child Object | | '''Child Object | ||
− | |- | + | |- |
| Data Type | | Data Type | ||
| Type | | Type | ||
Line 413: | Line 415: | ||
| | | | ||
| | | | ||
− | |- | + | |- |
| Data Type | | Data Type | ||
| Type | | Type | ||
Line 420: | Line 422: | ||
| | | | ||
| | | | ||
− | |- | + | |- |
| Data Type | | Data Type | ||
| Type | | Type | ||
Line 427: | Line 429: | ||
| | | | ||
| | | | ||
− | |- | + | |- |
| Schema | | Schema | ||
| Schema | | Schema | ||
Line 434: | Line 436: | ||
| | | | ||
| | | | ||
− | |- | + | |- |
| Select | | Select | ||
| Table | | Table | ||
Line 441: | Line 443: | ||
| Trigger | | Trigger | ||
| uSalesOrderHeader | | uSalesOrderHeader | ||
− | |- | + | |- |
| Update | | Update | ||
| Table | | Table | ||
Line 448: | Line 450: | ||
| Trigger | | Trigger | ||
| uSalesOrderHeader | | uSalesOrderHeader | ||
− | |- | + | |- |
| Update | | Update | ||
| Table | | Table | ||
Line 455: | Line 457: | ||
| Trigger | | Trigger | ||
| uSalesOrderHeader | | uSalesOrderHeader | ||
− | |- | + | |- |
| Update | | Update | ||
| Table | | Table | ||
Line 462: | Line 464: | ||
| Trigger | | Trigger | ||
| uSalesOrderHeader | | uSalesOrderHeader | ||
− | |- | + | |- |
| Execute | | Execute | ||
| Procedure | | Procedure | ||
Line 469: | Line 471: | ||
| Trigger | | Trigger | ||
| uSalesOrderHeader | | uSalesOrderHeader | ||
− | |- | + | |- |
| Execute | | Execute | ||
| Procedure | | Procedure | ||
Line 476: | Line 478: | ||
| Trigger | | Trigger | ||
| uSalesOrderHeader | | uSalesOrderHeader | ||
− | |- | + | |- |
| Execute | | Execute | ||
| Function | | Function | ||
Line 483: | Line 485: | ||
| Trigger | | Trigger | ||
| uSalesOrderHeader | | uSalesOrderHeader | ||
− | |- | + | |- |
| Execute | | Execute | ||
| Function | | Function | ||
Line 502: | Line 504: | ||
| '''Child Object | | '''Child Object | ||
− | |- | + | |- |
| Select | | Select | ||
| View | | View | ||
Line 509: | Line 511: | ||
| | | | ||
| | | | ||
− | |- | + | |- |
| Select | | Select | ||
| Table | | Table | ||
Line 516: | Line 518: | ||
| Trigger | | Trigger | ||
| iduSalesOrderDetail | | iduSalesOrderDetail | ||
− | |- | + | |- |
| Update | | Update | ||
| Table | | Table | ||
Line 523: | Line 525: | ||
| Trigger | | Trigger | ||
| iduSalesOrderDetail | | iduSalesOrderDetail | ||
− | |- | + | |- |
| Select | | Select | ||
| Table | | Table | ||
Line 530: | Line 532: | ||
| Trigger | | Trigger | ||
| uSalesOrderHeader | | uSalesOrderHeader | ||
− | |- | + | |- |
| Update | | Update | ||
| Table | | Table |