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. | ||
+ | |- | ||
|} | |} | ||
− | + | ||
{| 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 18: | ||
| '''Nullable | | '''Nullable | ||
| '''Default | | '''Default | ||
− | | '''Description | + | | '''Description / PK / Index |
− | + | ||
|- valign="top" | |- valign="top" | ||
| SalesOrderID | | SalesOrderID | ||
Line 24: | Line 25: | ||
| not null | | not null | ||
| | | | ||
− | | Primary key. | + | | Primary key.<br />PK_SalesOrderHeader_SalesOrderID |
|- valign="top" | |- valign="top" | ||
| RevisionNumber | | RevisionNumber | ||
Line 30: | Line 31: | ||
| not null | | not null | ||
| ((0)) | | ((0)) | ||
− | | Incremental number to track changes to the sales order over time. | + | | Incremental number to track changes to the sales order over time.<br /> |
|- valign="top" | |- valign="top" | ||
| OrderDate | | OrderDate | ||
Line 36: | Line 37: | ||
| not null | | not null | ||
| (getdate()) | | (getdate()) | ||
− | | Dates the sales order was created. | + | | Dates the sales order was created.<br /> |
|- valign="top" | |- valign="top" | ||
| DueDate | | DueDate | ||
Line 42: | Line 43: | ||
| not null | | not null | ||
| | | | ||
− | | Date the order is due to the customer. | + | | Date the order is due to the customer.<br /> |
|- valign="top" | |- valign="top" | ||
| ShipDate | | ShipDate | ||
Line 48: | Line 49: | ||
| null | | null | ||
| | | | ||
− | | Date the order was shipped to the customer. | + | | Date the order was shipped to the customer.<br /> |
|- valign="top" | |- valign="top" | ||
| Status | | Status | ||
Line 54: | Line 55: | ||
| not null | | not null | ||
| ((1)) | | ((1)) | ||
− | | Order current status. 1 = In process; 2 = Approved; 3 = Backordered; 4 = Rejected; 5 = Shipped; 6 = Cancelled | + | | Order current status. 1 = In process; 2 = Approved; 3 = Backordered; 4 = Rejected; 5 = Shipped; 6 = Cancelled<br /> |
|- valign="top" | |- valign="top" | ||
| OnlineOrderFlag | | OnlineOrderFlag | ||
Line 60: | Line 61: | ||
| not null | | not null | ||
| ((1)) | | ((1)) | ||
− | | 0 = Order placed by sales person. 1 = Order placed online by customer. | + | | 0 = Order placed by sales person. 1 = Order placed online by customer.<br /> |
|- valign="top" | |- valign="top" | ||
| SalesOrderNumber | | SalesOrderNumber | ||
Line 66: | Line 67: | ||
| | | | ||
| | | | ||
− | | Unique sales order identification number. | + | | Unique sales order identification number.<br />AK_SalesOrderHeader_SalesOrderNumber |
|- valign="top" | |- valign="top" | ||
| PurchaseOrderNumber | | PurchaseOrderNumber | ||
Line 72: | Line 73: | ||
| null | | null | ||
| | | | ||
− | | Customer purchase order number reference. | + | | Customer purchase order number reference. <br /> |
|- valign="top" | |- valign="top" | ||
| AccountNumber | | AccountNumber | ||
Line 78: | Line 79: | ||
| null | | null | ||
| | | | ||
− | | Financial accounting number reference. | + | | Financial accounting number reference.<br /> |
|- valign="top" | |- valign="top" | ||
| CustomerID | | CustomerID | ||
Line 84: | Line 85: | ||
| not null | | not null | ||
| | | | ||
− | | Customer identification number. Foreign key to Customer.CustomerID. | + | | Customer identification number. Foreign key to Customer.CustomerID.<br />IX_SalesOrderHeader_CustomerID |
|- valign="top" | |- valign="top" | ||
| ContactID | | ContactID | ||
Line 90: | Line 91: | ||
| not null | | not null | ||
| | | | ||
− | | Customer contact identification number. Foreign key to Contact.ContactID. | + | | Customer contact identification number. Foreign key to Contact.ContactID.<br /> |
|- valign="top" | |- valign="top" | ||
| SalesPersonID | | SalesPersonID | ||
Line 96: | Line 97: | ||
| null | | null | ||
| | | | ||
− | | Sales person who created the sales order. Foreign key to SalesPerson.SalePersonID. | + | | Sales person who created the sales order. Foreign key to SalesPerson.SalePersonID.<br />IX_SalesOrderHeader_SalesPersonID |
|- valign="top" | |- valign="top" | ||
| TerritoryID | | TerritoryID | ||
Line 102: | Line 103: | ||
| null | | null | ||
| | | | ||
− | | Territory in which the sale was made. Foreign key to SalesTerritory.SalesTerritoryID. | + | | Territory in which the sale was made. Foreign key to SalesTerritory.SalesTerritoryID.<br /> |
|- valign="top" | |- valign="top" | ||
| BillToAddressID | | BillToAddressID | ||
Line 108: | Line 109: | ||
| not null | | not null | ||
| | | | ||
− | | Customer billing address. Foreign key to Address.AddressID. | + | | Customer billing address. Foreign key to Address.AddressID.<br /> |
|- valign="top" | |- valign="top" | ||
| ShipToAddressID | | ShipToAddressID | ||
Line 114: | Line 115: | ||
| not null | | not null | ||
| | | | ||
− | | Customer shipping address. Foreign key to Address.AddressID. | + | | Customer shipping address. Foreign key to Address.AddressID.<br /> |
|- valign="top" | |- valign="top" | ||
| ShipMethodID | | ShipMethodID | ||
Line 120: | Line 121: | ||
| not null | | not null | ||
| | | | ||
− | | Shipping method. Foreign key to ShipMethod.ShipMethodID. | + | | Shipping method. Foreign key to ShipMethod.ShipMethodID.<br /> |
|- valign="top" | |- valign="top" | ||
| CreditCardID | | CreditCardID | ||
Line 126: | Line 127: | ||
| null | | null | ||
| | | | ||
− | | Credit card identification number. Foreign key to CreditCard.CreditCardID. | + | | Credit card identification number. Foreign key to CreditCard.CreditCardID.<br /> |
|- valign="top" | |- valign="top" | ||
| CreditCardApprovalCode | | CreditCardApprovalCode | ||
Line 132: | Line 133: | ||
| null | | null | ||
| | | | ||
− | | Approval code provided by the credit card company. | + | | Approval code provided by the credit card company.<br /> |
|- valign="top" | |- valign="top" | ||
| CurrencyRateID | | CurrencyRateID | ||
Line 138: | Line 139: | ||
| null | | null | ||
| | | | ||
− | | Currency exchange rate used. Foreign key to CurrencyRate.CurrencyRateID. | + | | Currency exchange rate used. Foreign key to CurrencyRate.CurrencyRateID.<br /> |
|- valign="top" | |- valign="top" | ||
| SubTotal | | SubTotal | ||
Line 144: | Line 145: | ||
| not null | | not null | ||
| ((0.00)) | | ((0.00)) | ||
− | | Sales subtotal. Computed as SUM(SalesOrderDetail.LineTotal)for the appropriate SalesOrderID. | + | | Sales subtotal. Computed as SUM(SalesOrderDetail.LineTotal)for the appropriate SalesOrderID.<br /> |
|- valign="top" | |- valign="top" | ||
| TaxAmt | | TaxAmt | ||
Line 150: | Line 151: | ||
| not null | | not null | ||
| ((0.00)) | | ((0.00)) | ||
− | | Tax amount. | + | | Tax amount.<br /> |
|- valign="top" | |- valign="top" | ||
| Freight | | Freight | ||
Line 156: | Line 157: | ||
| not null | | not null | ||
| ((0.00)) | | ((0.00)) | ||
− | | Shipping cost. | + | | Shipping cost.<br /> |
|- valign="top" | |- valign="top" | ||
| TotalDue | | TotalDue | ||
Line 162: | Line 163: | ||
| | | | ||
| | | | ||
− | | Total due from customer. Computed as Subtotal + TaxAmt + Freight. | + | | Total due from customer. Computed as Subtotal + TaxAmt + Freight.<br /> |
|- valign="top" | |- valign="top" | ||
| Comment | | Comment | ||
Line 168: | Line 169: | ||
| null | | null | ||
| | | | ||
− | | Sales representative comments. | + | | Sales representative comments.<br /> |
|- valign="top" | |- valign="top" | ||
| rowguid | | rowguid | ||
Line 174: | Line 175: | ||
| not null | | not null | ||
| (newid()) | | (newid()) | ||
− | | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. | + | | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_SalesOrderHeader_rowguid |
|- valign="top" | |- valign="top" | ||
| ModifiedDate | | ModifiedDate | ||
Line 180: | Line 181: | ||
| not null | | not null | ||
| (getdate()) | | (getdate()) | ||
− | | Date and time the record was last updated. | + | | Date and time the record was last updated.<br /> |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|} | |} | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
{| 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 191: | ||
| '''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 230: | ||
|} | |} | ||
− | + | ||
{| 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 236: | ||
| '''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 247: | ||
|} | |} | ||
− | + | ||
{| 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 | ||
|} | |} | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
{| 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 406: | Line 268: | ||
| '''Child Object | | '''Child Object | ||
− | |- | + | |- |
| Data Type | | Data Type | ||
| Type | | Type | ||
Line 413: | Line 275: | ||
| | | | ||
| | | | ||
− | |- | + | |- |
| Data Type | | Data Type | ||
| Type | | Type | ||
Line 420: | Line 282: | ||
| | | | ||
| | | | ||
− | |- | + | |- |
| Data Type | | Data Type | ||
| Type | | Type | ||
Line 427: | Line 289: | ||
| | | | ||
| | | | ||
− | |- | + | |- |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
| Select | | Select | ||
| Table | | Table | ||
Line 441: | Line 296: | ||
| Trigger | | Trigger | ||
| uSalesOrderHeader | | uSalesOrderHeader | ||
− | |- | + | |- |
| Update | | Update | ||
| Table | | Table | ||
Line 448: | Line 303: | ||
| Trigger | | Trigger | ||
| uSalesOrderHeader | | uSalesOrderHeader | ||
− | |- | + | |- |
| Update | | Update | ||
| Table | | Table | ||
Line 455: | Line 310: | ||
| Trigger | | Trigger | ||
| uSalesOrderHeader | | uSalesOrderHeader | ||
− | |- | + | |- |
| Update | | Update | ||
| Table | | Table | ||
Line 462: | Line 317: | ||
| Trigger | | Trigger | ||
| uSalesOrderHeader | | uSalesOrderHeader | ||
− | |- | + | |- |
| Execute | | Execute | ||
| Procedure | | Procedure | ||
Line 469: | Line 324: | ||
| Trigger | | Trigger | ||
| uSalesOrderHeader | | uSalesOrderHeader | ||
− | |- | + | |- |
| Execute | | Execute | ||
| Procedure | | Procedure | ||
Line 476: | Line 331: | ||
| Trigger | | Trigger | ||
| uSalesOrderHeader | | uSalesOrderHeader | ||
− | |- | + | |- |
| Execute | | Execute | ||
| Function | | Function | ||
Line 483: | Line 338: | ||
| Trigger | | Trigger | ||
| uSalesOrderHeader | | uSalesOrderHeader | ||
− | |- | + | |- |
| Execute | | Execute | ||
| Function | | Function | ||
Line 492: | Line 347: | ||
|} | |} | ||
− | + | ||
{| 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 502: | Line 357: | ||
| '''Child Object | | '''Child Object | ||
− | |- | + | |- |
| Select | | Select | ||
| View | | View | ||
Line 509: | Line 364: | ||
| | | | ||
| | | | ||
− | |- | + | |- |
| Select | | Select | ||
| Table | | Table | ||
Line 516: | Line 371: | ||
| Trigger | | Trigger | ||
| iduSalesOrderDetail | | iduSalesOrderDetail | ||
− | |- | + | |- |
| Update | | Update | ||
| Table | | Table | ||
Line 523: | Line 378: | ||
| Trigger | | Trigger | ||
| iduSalesOrderDetail | | iduSalesOrderDetail | ||
− | |- | + | |- |
| Select | | Select | ||
| Table | | Table | ||
Line 530: | Line 385: | ||
| Trigger | | Trigger | ||
| uSalesOrderHeader | | uSalesOrderHeader | ||
− | |- | + | |- |
| Update | | Update | ||
| Table | | Table | ||
Line 538: | Line 393: | ||
| uSalesOrderHeader | | uSalesOrderHeader | ||
|} | |} | ||
+ | |||