[dbo].[PM00300]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count (~)	1
Created	4:57:08 PM Thursday, September 7, 2006
Last Modified	10:21:29 AM Thursday, April 21, 2011

	Name	Data Type	Max Length (Bytes)	Identity
$Cluster Primary Key PK_PM00300: VENDORID\ADRSCODE$	VENDORID	char(15)	15
$Cluster Primary Key PK_PM00300: VENDORID\ADRSCODE$	ADRSCODE	char(15)	15
	VNDCNTCT	char(61)	61
	ADDRESS1	char(61)	61
	ADDRESS2	char(61)	61
	ADDRESS3	char(61)	61
	CITY	char(35)	35
	STATE	char(29)	29
	ZIPCODE	char(11)	11
	COUNTRY	char(61)	61
	UPSZONE	char(3)	3
	PHNUMBR1	char(21)	21
	PHNUMBR2	char(21)	21
	PHONE3	char(21)	21
	FAXNUMBR	char(21)	21
	SHIPMTHD	char(15)	15
	TAXSCHID	char(15)	15
	DEX_ROW_ID	int	4	1 - 1

	Name	Columns	Unique	Fill Factor
$Cluster Primary Key PK_PM00300: VENDORID\ADRSCODE$	PK_PM00300	VENDORID, ADRSCODE		80

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

SQL Script

CREATE TABLE [dbo].[PM00300]
(
[VENDORID] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ADRSCODE] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VNDCNTCT] [char] (61) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ADDRESS1] [char] (61) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ADDRESS2] [char] (61) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ADDRESS3] [char] (61) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CITY] [char] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[STATE] [char] (29) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ZIPCODE] [char] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[COUNTRY] [char] (61) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UPSZONE] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PHNUMBR1] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PHNUMBR2] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PHONE3] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FAXNUMBR] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SHIPMTHD] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TAXSCHID] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DEX_ROW_ID] [int] NOT NULL IDENTITY(1, 1)
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PM00300] ADD CONSTRAINT [PK_PM00300] PRIMARY KEY CLUSTERED  ([VENDORID], [ADRSCODE]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[PM00300] TO [MssExec]
GRANT INSERT ON  [dbo].[PM00300] TO [MssExec]
GRANT DELETE ON  [dbo].[PM00300] TO [MssExec]
GRANT UPDATE ON  [dbo].[PM00300] TO [MssExec]
GO