# 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

No extended properties defined.

## Bound Defaults

No defaults bound to that datatype

## Bound Rules

No rules bound to that datatype

## [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

Datatype is not used in any 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

Script
CREATE TYPE [dbo].[OrderNumber] FROM [nvarchar](25) NULL

#### See also

List of Datatypes