[dbo].[VanlineStatementDetail]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count (~)	0
Created	7:34:04 PM Tuesday, September 24, 2024
Last Modified	7:34:08 PM Tuesday, September 24, 2024

	Name	Data Type	Max Length (Bytes)	Identity
	VanlineStatementDetailID	int	4	1 - 1
$Indexes IX_VanlineStatementDetail_HeaderOrderControl: VanlineStatementHeaderFID\OrderControl$ $Indexes IX_VanlineStatementDetail_HeaderStageDetailFID: VanlineStatementHeaderFID\StageDetailFID$	VanlineStatementHeaderFID	int	4
$Indexes IX_VanlineStatementDetail_HeaderOrderControl: VanlineStatementHeaderFID\OrderControl$	OrderControl	varchar(30)	30
	BrandCode	varchar(32)	32
	ShipperLastName	varchar(32)	32
	ShipperFirstName	varchar(32)	32
	Description	varchar(128)	128
	LoadDate	datetime	8
	DeliveryDate	datetime	8
	Weight	int	4
	Miles	int	4
	DriverNo	varchar(15)	15
	VendorNo	varchar(15)	15
	TransactionType	varchar(32)	32
	PaymentCode	varchar(32)	32
	CustomerNumber	varchar(15)	15
	MergeablePayment	bit	1
	CanSeparateDistributions	bit	1
	SortBy	varchar(128)	128
$Indexes IX_VanlineStatementDetail_HeaderStageDetailFID: VanlineStatementHeaderFID\StageDetailFID$	StageDetailFID	int	4
	CreatedDate	datetime	8
	VanlineStatementDownloadLogFID	int	4

	Name	Columns	Unique
	PK_VanlineStatementDetail	VanlineStatementDetailID
	IX_VanlineStatementDetail_HeaderStageDetailFID	VanlineStatementHeaderFID, StageDetailFID
	IX_VanlineStatementDetail_HeaderOrderControl	VanlineStatementHeaderFID, OrderControl

Name	Columns
FK_VanlineStatementDetail_VanlineStatementDownloadLog	VanlineStatementDownloadLogFID->[dbo].[VanlineStatementDownloadLog].[VanlineStatementDownloadLogID]
FK_VanlineStatementDetail_VanlineStatementHeader	VanlineStatementHeaderFID->[dbo].[VanlineStatementHeader].[VanlineStatementHeaderID]

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

SQL Script

CREATE TABLE [dbo].[VanlineStatementDetail]
(
[VanlineStatementDetailID] [int] NOT NULL IDENTITY(1, 1),
[VanlineStatementHeaderFID] [int] NOT NULL,
[OrderControl] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BrandCode] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipperLastName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipperFirstName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LoadDate] [datetime] NULL,
[DeliveryDate] [datetime] NULL,
[Weight] [int] NULL,
[Miles] [int] NULL,
[DriverNo] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VendorNo] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TransactionType] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PaymentCode] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MergeablePayment] [bit] NOT NULL,
[CanSeparateDistributions] [bit] NOT NULL,
[SortBy] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StageDetailFID] [int] NULL,
[CreatedDate] [datetime] NOT NULL,
[VanlineStatementDownloadLogFID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[VanlineStatementDetail] ADD CONSTRAINT [PK_VanlineStatementDetail] PRIMARY KEY CLUSTERED  ([VanlineStatementDetailID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_VanlineStatementDetail_HeaderOrderControl] ON [dbo].[VanlineStatementDetail] ([VanlineStatementHeaderFID], [OrderControl]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_VanlineStatementDetail_HeaderStageDetailFID] ON [dbo].[VanlineStatementDetail] ([VanlineStatementHeaderFID], [StageDetailFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[VanlineStatementDetail] ADD CONSTRAINT [FK_VanlineStatementDetail_VanlineStatementDownloadLog] FOREIGN KEY ([VanlineStatementDownloadLogFID]) REFERENCES [dbo].[VanlineStatementDownloadLog] ([VanlineStatementDownloadLogID])
GO
ALTER TABLE [dbo].[VanlineStatementDetail] ADD CONSTRAINT [FK_VanlineStatementDetail_VanlineStatementHeader] FOREIGN KEY ([VanlineStatementHeaderFID]) REFERENCES [dbo].[VanlineStatementHeader] ([VanlineStatementHeaderID])
GO
GRANT SELECT ON  [dbo].[VanlineStatementDetail] TO [MssExec]
GRANT INSERT ON  [dbo].[VanlineStatementDetail] TO [MssExec]
GRANT DELETE ON  [dbo].[VanlineStatementDetail] TO [MssExec]
GRANT UPDATE ON  [dbo].[VanlineStatementDetail] TO [MssExec]
GO