Datatype: OrderNumber

Properties

Property	Value
Name	OrderNumber
ID	261
Schema	dbo
Owner	dbo
User Defined
Native Datatype	nvarchar(25)
Max Length (in bytes)	50
Nullable
Is Assembly Type
Is Table Type

Extended Properties

Bound Defaults

Bound Rules

[OrderNumber] is used in the following columns

Column Name	Object Name	Description	ANSI Padded	Is Rowguidcol	Is Identity	Is Computed	Is Filestream	Is Replicated	Is Non Sql Subscribed	Is Merge Published	Is DTS Replicated	Is Xml Document	Is Sparse	Is Column Set
PurchaseOrderNumber	Sales.SalesOrderHeader	Customer purchase order number reference.

[OrderNumber] is used in the following parameters

Objects that depend on [OrderNumber]

• dbo.OrderNumber
  • Sales.SalesOrderHeader
    • Sales.SalesOrderDetail
      • Sales.iduSalesOrderDetail
      • Sales.ufn_SalesByStore
    • Sales.SalesOrderHeaderSalesReason
    • Sales.uSalesOrderHeader
    • Sales.vSalesPersonSalesByFiscalYears

Objects on which [OrderNumber] depends

• dbo.OrderNumber

SQL

See also