[dbo].[StatementPayable]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count (~)	4242
Created	2:15:29 PM Monday, February 3, 2014
Last Modified	3:41:22 PM Tuesday, November 18, 2014

	Name	Data Type	Max Length (Bytes)	Identity	Default
$Indexes IX_StatementPayable_StatementDetail: StatementDetailFID\StatementPayableID$	StatementPayableID	int	4	1 - 1
$Indexes IX_StatementPayable_StatementDetailDist: StatementDetailFID\StatementDetailDistFID\VendorID$ $Indexes IX_StatementPayable_StatementDetail: StatementDetailFID\StatementPayableID$	StatementDetailFID	int	4
$Indexes IX_StatementPayable_StatementDetailDist: StatementDetailFID\StatementDetailDistFID\VendorID$	StatementDetailDistFID	int	4
	Description	varchar(128)	128
	BranchFID	int	4
	DivisionFID	int	4
$Indexes IX_StatementPayable_StatementDetailDist: StatementDetailFID\StatementDetailDistFID\VendorID$	VendorID	varchar(15)	15
	Amount	money	8		((0))
	1099Flag	bit	1		((0))
	DocumentNumber	varchar(23)	23
	ApplyAmount	money	8		((0))
	GPFlag	bit	1		((0))

	Name	Columns	Unique
	PK_StatementPayable	StatementPayableID
	IX_StatementPayable_StatementDetail	StatementDetailFID, StatementPayableID
	IX_StatementPayable_StatementDetailDist	StatementDetailFID, StatementDetailDistFID, VendorID

Name	Columns
FK_StatementPayable_Branch	BranchFID->[dbo].[Branch].[BranchPriKey]
FK_StatementPayable_Division	DivisionFID->[dbo].[Division].[DivisionID]
FK_StatementPayable_StatementDetailDist	StatementDetailDistFID->[dbo].[StatementDetailDist].[SDDPriKey]
FK_StatementPayable_StatementDetail	StatementDetailFID->[dbo].[StatementDetail].[SDPriKey]

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

SQL Script

CREATE TABLE [dbo].[StatementPayable]
(
[StatementPayableID] [int] NOT NULL IDENTITY(1, 1),
[StatementDetailFID] [int] NOT NULL,
[StatementDetailDistFID] [int] NULL,
[Description] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BranchFID] [int] NOT NULL,
[DivisionFID] [int] NULL,
[VendorID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Amount] [money] NOT NULL CONSTRAINT [DF_StatementPayable_Amount] DEFAULT ((0)),
[1099Flag] [bit] NOT NULL CONSTRAINT [DF_StatementPayable_1099Flag] DEFAULT ((0)),
[DocumentNumber] [varchar] (23) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ApplyAmount] [money] NOT NULL CONSTRAINT [DF_StatementPayable_ApplyAmount] DEFAULT ((0)),
[GPFlag] [bit] NOT NULL CONSTRAINT [DF_StatementPayable_GPFlag] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[StatementPayable] ADD CONSTRAINT [PK_StatementPayable] PRIMARY KEY CLUSTERED  ([StatementPayableID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_StatementPayable_StatementDetailDist] ON [dbo].[StatementPayable] ([StatementDetailFID], [StatementDetailDistFID], [VendorID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_StatementPayable_StatementDetail] ON [dbo].[StatementPayable] ([StatementDetailFID], [StatementPayableID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[StatementPayable] ADD CONSTRAINT [FK_StatementPayable_Branch] FOREIGN KEY ([BranchFID]) REFERENCES [dbo].[Branch] ([BranchPriKey])
GO
ALTER TABLE [dbo].[StatementPayable] ADD CONSTRAINT [FK_StatementPayable_Division] FOREIGN KEY ([DivisionFID]) REFERENCES [dbo].[Division] ([DivisionID])
GO
ALTER TABLE [dbo].[StatementPayable] ADD CONSTRAINT [FK_StatementPayable_StatementDetailDist] FOREIGN KEY ([StatementDetailDistFID]) REFERENCES [dbo].[StatementDetailDist] ([SDDPriKey])
GO
ALTER TABLE [dbo].[StatementPayable] ADD CONSTRAINT [FK_StatementPayable_StatementDetail] FOREIGN KEY ([StatementDetailFID]) REFERENCES [dbo].[StatementDetail] ([SDPriKey])
GO
GRANT SELECT ON  [dbo].[StatementPayable] TO [MssExec]
GRANT INSERT ON  [dbo].[StatementPayable] TO [MssExec]
GRANT DELETE ON  [dbo].[StatementPayable] TO [MssExec]
GRANT UPDATE ON  [dbo].[StatementPayable] TO [MssExec]
GO