[dbo].[GPWarehouse]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count (~)	22999
Created	7:07:56 PM Thursday, December 17, 2009
Last Modified	9:12:09 AM Friday, November 8, 2024

	Name	Data Type	Max Length (Bytes)	Default
$Primary Key PK_GPWarehouse: CustomerNumber\DocumentType\DocumentNumber$	CustomerNumber	varchar(15)	15
	OrderID	int	4
	Authority	varchar(30)	30
	OrderNumber	varchar(23)	23
	Salesperson	varchar(44)	44
	Shipper	varchar(44)	44
	OrderOriginAddress	varchar(30)	30
	OrderDestinationAddress	varchar(30)	30
	BranchID	varchar(5)	5
	InvoiceNumber	varchar(64)	64
	InvoiceDate	datetime	8
	InvoiceAmount	money	8
	InvoiceAge	int	4
	InvoiceCreatedDate	datetime	8
	InvoiceCreatedBy	varchar(44)	44
	InvoicedHeaderID	int	4
$Primary Key PK_GPWarehouse: CustomerNumber\DocumentType\DocumentNumber$	DocumentNumber	varchar(21)	21
	DocumentDescription	varchar(128)	128
	DocumentDate	datetime	8
	DueDate	datetime	8
	PostDate	datetime	8
	JournalDate	datetime	8
$Primary Key PK_GPWarehouse: CustomerNumber\DocumentType\DocumentNumber$	DocumentType	smallint	2
	OriginalTransactionAmount	money	8
	CurrentTransactionAmount	money	8
	DocumentAge	int	4
	ItemCode	int	4
	BranchFID	int	4
	PONumber	varchar(30)	30
	GBLNumber	varchar(21)	21
	IsFactored	bit	1	((0))

	Name	Columns	Fill Factor
$Primary Key PK_GPWarehouse: CustomerNumber\DocumentType\DocumentNumber$	PK_GPWarehouse	CustomerNumber, DocumentType, DocumentNumber
	IX_GPWarehouse_CustomerNumber	CustomerNumber	80
	IX_GPWarehouse_OrderID	OrderID	80
	IX_GPWarehouse_OrderNumber	OrderNumber

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

SQL Script

CREATE TABLE [dbo].[GPWarehouse]
(
[CustomerNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OrderID] [int] NULL,
[Authority] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OrderNumber] [varchar] (23) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Salesperson] [varchar] (44) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Shipper] [varchar] (44) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OrderOriginAddress] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OrderDestinationAddress] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BranchID] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InvoiceNumber] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InvoiceDate] [datetime] NULL,
[InvoiceAmount] [money] NULL,
[InvoiceAge] [int] NULL,
[InvoiceCreatedDate] [datetime] NULL,
[InvoiceCreatedBy] [varchar] (44) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InvoicedHeaderID] [int] NULL,
[DocumentNumber] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DocumentDescription] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DocumentDate] [datetime] NULL,
[DueDate] [datetime] NULL,
[PostDate] [datetime] NULL,
[JournalDate] [datetime] NULL,
[DocumentType] [smallint] NOT NULL,
[OriginalTransactionAmount] [money] NULL,
[CurrentTransactionAmount] [money] NULL,
[DocumentAge] [int] NULL,
[ItemCode] [int] NULL,
[BranchFID] [int] NULL,
[PONumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GBLNumber] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsFactored] [bit] NOT NULL CONSTRAINT [DF_GPWarehouse_IsFactored] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GPWarehouse] ADD CONSTRAINT [PK_GPWarehouse] PRIMARY KEY NONCLUSTERED  ([CustomerNumber], [DocumentType], [DocumentNumber]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [IX_GPWarehouse_CustomerNumber] ON [dbo].[GPWarehouse] ([CustomerNumber]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_GPWarehouse_OrderID] ON [dbo].[GPWarehouse] ([OrderID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_GPWarehouse_OrderNumber] ON [dbo].[GPWarehouse] ([OrderNumber]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[GPWarehouse] TO [MssExec]
GRANT INSERT ON  [dbo].[GPWarehouse] TO [MssExec]
GRANT DELETE ON  [dbo].[GPWarehouse] TO [MssExec]
GRANT UPDATE ON  [dbo].[GPWarehouse] TO [MssExec]
GO