# Datatype: AccountNumber

## Properties

Property | Value
--- | ---
Name | AccountNumber
ID | 257
Schema | dbo
Owner | dbo
User Defined |
Native Datatype | nvarchar(15)
Max Length (in bytes) | 30
Nullable |
Is Assembly Type |
Is Table Type |

## Extended Properties

Name | Value
--- | ---
MS_Description | mobi czwartek - AccountNumber

## Bound Defaults

No defaults bound to that datatype

## Bound Rules

No rules bound to that datatype

## [AccountNumber] 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
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
AccountNumber | Purchasing.Vendor | Vendor account (identification) number. |  |  |  |  |  |  |  |  |  |  |  |
AccountNumber | Sales.SalesOrderHeader | Financial accounting number reference. |  |  |  |  |  |  |  |  |  |  |  |

## [AccountNumber] is used in the following parameters

Datatype is not used in any parameters

## Objects that depend on [AccountNumber]

- dbo.AccountNumber
  - Purchasing.Vendor
    - dbo.ufnGetContactInformation
    - Purchasing.dVendor
    - Purchasing.ProductVendor
    - Purchasing.PurchaseOrderHeader
      - Purchasing.PurchaseOrderDetail
        - Purchasing.iPurchaseOrderDetail
        - Purchasing.uPurchaseOrderDetail
      - Purchasing.uPurchaseOrderHeader
    - Purchasing.vVendorWithAddresses
    - Purchasing.vVendorWithContacts
  - Sales.SalesOrderHeader
    - Sales.SalesOrderDetail
      - Sales.iduSalesOrderDetail
      - Sales.ufn_SalesByStore
    - Sales.SalesOrderHeaderSalesReason
    - Sales.uSalesOrderHeader
    - Sales.vSalesPersonSalesByFiscalYears

## Objects on which [AccountNumber] depends

- dbo.AccountNumber

## SQL

Script
CREATE TYPE [dbo].[AccountNumber] FROM [nvarchar](15) NULL EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'mobi czwartek - AccountNumber' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TYPE',@level1name=N'AccountNumber'

#### See also

List of Datatypes