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 | ||
− | |- | + | |- |
− | |||
− | |||
|} | |} | ||
− | + | ||
{| 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 17: | Line 15: | ||
| '''Nullable | | '''Nullable | ||
| '''Default | | '''Default | ||
− | | ''' | + | | '''PK |
− | + | | '''Index | |
− | |- | + | |
+ | |- | ||
| SalesOrderID | | SalesOrderID | ||
| int | | int | ||
| not null | | not null | ||
| | | | ||
− | | | + | | PK_SalesOrderHeader_SalesOrderID |
− | |- | + | | |
+ | |- | ||
| RevisionNumber | | RevisionNumber | ||
| tinyint | | tinyint | ||
| not null | | not null | ||
| ((0)) | | ((0)) | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| OrderDate | | OrderDate | ||
| datetime | | datetime | ||
| not null | | not null | ||
| (getdate()) | | (getdate()) | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| DueDate | | DueDate | ||
| datetime | | datetime | ||
| not null | | not null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| ShipDate | | ShipDate | ||
| datetime | | datetime | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| Status | | Status | ||
| tinyint | | tinyint | ||
| not null | | not null | ||
| ((1)) | | ((1)) | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| OnlineOrderFlag | | OnlineOrderFlag | ||
| dbo.Flag | | dbo.Flag | ||
| not null | | not null | ||
| ((1)) | | ((1)) | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| SalesOrderNumber | | SalesOrderNumber | ||
| | | | ||
| | | | ||
| | | | ||
− | | | + | | |
− | |- | + | | AK_SalesOrderHeader_SalesOrderNumber |
+ | |- | ||
| PurchaseOrderNumber | | PurchaseOrderNumber | ||
| dbo.OrderNumber | | dbo.OrderNumber | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| AccountNumber | | AccountNumber | ||
| dbo.AccountNumber | | dbo.AccountNumber | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| CustomerID | | CustomerID | ||
| int | | int | ||
| not null | | not null | ||
| | | | ||
− | | | + | | |
− | |- | + | | IX_SalesOrderHeader_CustomerID |
+ | |- | ||
| ContactID | | ContactID | ||
| int | | int | ||
| not null | | not null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| SalesPersonID | | SalesPersonID | ||
| int | | int | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | IX_SalesOrderHeader_SalesPersonID |
+ | |- | ||
| TerritoryID | | TerritoryID | ||
| int | | int | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| BillToAddressID | | BillToAddressID | ||
| int | | int | ||
| not null | | not null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| ShipToAddressID | | ShipToAddressID | ||
| int | | int | ||
| not null | | not null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| ShipMethodID | | ShipMethodID | ||
| int | | int | ||
| not null | | not null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| CreditCardID | | CreditCardID | ||
| int | | int | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| CreditCardApprovalCode | | CreditCardApprovalCode | ||
| varchar(15) | | varchar(15) | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| CurrencyRateID | | CurrencyRateID | ||
| int | | int | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| SubTotal | | SubTotal | ||
| money | | money | ||
| not null | | not null | ||
| ((0.00)) | | ((0.00)) | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| TaxAmt | | TaxAmt | ||
| money | | money | ||
| not null | | not null | ||
| ((0.00)) | | ((0.00)) | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| Freight | | Freight | ||
| money | | money | ||
| not null | | not null | ||
| ((0.00)) | | ((0.00)) | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| TotalDue | | TotalDue | ||
| | | | ||
| | | | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| Comment | | Comment | ||
| nvarchar(128) | | nvarchar(128) | ||
| null | | null | ||
| | | | ||
− | | | + | | |
− | |- | + | | |
+ | |- | ||
| rowguid | | rowguid | ||
| uniqueidentifier | | uniqueidentifier | ||
| not null | | not null | ||
| (newid()) | | (newid()) | ||
− | | | + | | |
− | |- | + | | AK_SalesOrderHeader_rowguid |
+ | |- | ||
| ModifiedDate | | ModifiedDate | ||
| datetime | | datetime | ||
| not null | | not null | ||
| (getdate()) | | (getdate()) | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
| | | | ||
− | |||
− | |||
− | |||
| | | | ||
− | |||
|} | |} | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
{| 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 257: | Line 216: | ||
| '''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 296: | Line 255: | ||
|} | |} | ||
− | + | ||
{| 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 302: | Line 261: | ||
| '''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 313: | Line 272: | ||
|} | |} | ||
− | + | ||
{| 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 | ||
|} | |} | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
== automatically generated == | == automatically generated == | ||
Line 546: | Line 288: | ||
| '''Table | | '''Table | ||
| Sales.SalesOrderHeader | | Sales.SalesOrderHeader | ||
− | |- | + | |- |
+ | |||
| '''Description | | '''Description | ||
| General sales order information. | | General sales order information. | ||
|- | |- | ||
+ | |||
|} | |} | ||
Line 802: | Line 546: | ||
{| 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" | ||
+ | | '''Referenced Object | ||
+ | | '''Object Type | ||
| '''Dependency Type | | '''Dependency Type | ||
− | + | ||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
+ | | [[dbo.AccountNumber_(type)|dbo.AccountNumber]] | ||
+ | | Type | ||
| Data Type | | Data Type | ||
+ | |- | ||
+ | | [[dbo.Flag_(type)|dbo.Flag]] | ||
| Type | | Type | ||
− | | | + | | Data Type |
− | |||
− | |||
− | |||
|- | |- | ||
− | | | + | | [[dbo.OrderNumber_(type)|dbo.OrderNumber]] |
| Type | | Type | ||
− | |||
− | |||
− | |||
− | |||
− | |||
| Data Type | | Data Type | ||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
− | + | | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] | |
− | + | | Table | |
− | | [[ | + | | Select |
− | |||
− | | | ||
− | | | ||
|- | |- | ||
− | | | + | | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] |
| Table | | Table | ||
− | | | + | | Update |
− | |||
− | |||
− | |||
|- | |- | ||
+ | | [[Sales.SalesPerson_(table)|Sales.SalesPerson]] | ||
+ | | Table | ||
| Update | | Update | ||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
− | | | + | | [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]] |
| Table | | Table | ||
− | |||
− | |||
− | |||
− | |||
− | |||
| Update | | Update | ||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
+ | | [[dbo.uspLogError_(procedure)|dbo.uspLogError]] | ||
+ | | Procedure | ||
| Execute | | Execute | ||
+ | |- | ||
+ | | [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]] | ||
| Procedure | | Procedure | ||
− | | | + | | Execute |
− | |||
− | |||
− | |||
|- | |- | ||
+ | | [[dbo.ufnGetAccountingEndDate_(function)|dbo.ufnGetAccountingEndDate]] | ||
+ | | Function | ||
| Execute | | Execute | ||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
− | | | + | | [[dbo.ufnGetAccountingStartDate_(function)|dbo.ufnGetAccountingStartDate]] |
| Function | | Function | ||
− | |||
− | |||
− | |||
− | |||
− | |||
| Execute | | Execute | ||
− | |||
− | |||
− | |||
− | |||
− | |||
|} | |} | ||
Line 898: | Line 599: | ||
{| 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" | ||
+ | | '''Referencing Object | ||
+ | | '''Object Type | ||
| '''Reference Type | | '''Reference Type | ||
− | + | ||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
+ | | [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]] | ||
+ | | View | ||
| Select | | Select | ||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
+ | | [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]] | ||
+ | | Table | ||
| Select | | Select | ||
+ | |- | ||
+ | | [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]] | ||
| Table | | Table | ||
− | | | + | | Update |
− | |||
− | |||
− | |||
|- | |- | ||
− | | | + | | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] |
| Table | | Table | ||
− | | | + | | Select |
− | |||
− | |||
− | |||
|- | |- | ||
− | | | + | | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] |
| Table | | Table | ||
− | |||
− | |||
− | |||
− | |||
− | |||
| Update | | Update | ||
− | |||
− | |||
− | |||
− | |||
− | |||
|} | |} |