iVend Database Database : CfgAddress Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

7

Data Space Used

8.00 KB

Index Space Used

8.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

AddressKey

System generated Primary key of the table.

VarWChar

50

ContactKey

Refers to the contact.

VarWChar

50

Address1

Refers to the 1st line of the address description.

VarWChar

100

Address2

Refers to the 2nd line of the address description.

VarWChar

100

Address3

Refers to the 3rd line of the address description.

VarWChar

100

City

Refers to the city.

VarWChar

100

ZipCode

Refers to the zipcode.

VarWChar

30

StateKey

Refers to the state. See also State

VarWChar

50

CountryKey

Refers to the country.See also Country

VarWChar

50

County

Refers to the county.

VarWChar

100

PhoneNumber

Refers to the phone number.

VarWChar

20

AlternatePhoneNumber

Refers to the alternate phone number.

VarWChar

20

FaxNumber

Refers to the fax number.

VarWChar

20

SalesTaxCodeKey

Refers to the sales tax code key.See also Tax

VarWChar

50

PurchaseTaxCodeKey

Refers to the purchase tax code key.See also Tax

VarWChar

50

CreatedBy

Reference of user who has created this record. See also Security User

VarWChar

50

Created

Date of creation of this record

DBTimeStamp

4

ModifiedBy

Reference of user who has modified this record. See also Security User

VarWChar

50

Modified

Date of last modification of this record

DBTimeStamp

4

IsDeleted

Value is True if the record has been deleted from the system. Record is always Soft Deleted

Boolean

1

StreetNo

Stores the Street No

VarWChar

100

Building

Stores the name of the Building

VarWChar

100

GlobalLocationNumber

Stores the name of the Global Location Number

VarWChar

50

Index

Description

Primary

Unique

PK_CfgAddress

Database Object

Object Type

Description

Dep Level

GetFullAddress

User Defined Function

1

GoodsReceiptPOReport

Stored Procedure

1

PurchaseOrderReport

Stored Procedure

1

rptSalesTransactionData

User Defined Function

1

rptSalesTransactionDataWithSalesPerson

User Defined Function

1

vw_AddressDetails

View

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[CfgAddress](

[AddressKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[ContactKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Address1] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Address2] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Address3] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[City] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ZipCode] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[StateKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[CountryKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[County] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[PhoneNumber] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[AlternatePhoneNumber] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[FaxNumber] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[SalesTaxCodeKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[PurchaseTaxCodeKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[CreatedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Created] [datetime] NOT NULL,

[ModifiedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Modified] [datetime] NOT NULL,

[IsDeleted] [bit] NOT NULL,

[StreetNo] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Building] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[GlobalLocationNumber] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

CONSTRAINT [PK_CfgAddress] PRIMARY KEY CLUSTERED

(

[AddressKey] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]