Tables [dbo].[VanlineStatementDetail]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created7:39:27 PM Wednesday, February 28, 2024
Last Modified7:39:31 PM Wednesday, February 28, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_VanlineStatementDetail: VanlineStatementDetailIDVanlineStatementDetailIDint4
No
1 - 1
Foreign Keys FK_VanlineStatementDetail_VanlineStatementHeader: [dbo].[VanlineStatementHeader].VanlineStatementHeaderFIDIndexes IX_VanlineStatementDetail_HeaderOrderControl: VanlineStatementHeaderFID\OrderControlIndexes IX_VanlineStatementDetail_HeaderStageDetailFID: VanlineStatementHeaderFID\StageDetailFIDVanlineStatementHeaderFIDint4
No
Indexes IX_VanlineStatementDetail_HeaderOrderControl: VanlineStatementHeaderFID\OrderControlOrderControlvarchar(30)30
Yes
BrandCodevarchar(32)32
Yes
ShipperLastNamevarchar(32)32
Yes
ShipperFirstNamevarchar(32)32
Yes
Descriptionvarchar(128)128
Yes
LoadDatedatetime8
Yes
DeliveryDatedatetime8
Yes
Weightint4
Yes
Milesint4
Yes
DriverNovarchar(15)15
Yes
VendorNovarchar(15)15
Yes
TransactionTypevarchar(32)32
Yes
PaymentCodevarchar(32)32
Yes
CustomerNumbervarchar(15)15
Yes
MergeablePaymentbit1
No
CanSeparateDistributionsbit1
No
SortByvarchar(128)128
Yes
Indexes IX_VanlineStatementDetail_HeaderStageDetailFID: VanlineStatementHeaderFID\StageDetailFIDStageDetailFIDint4
Yes
CreatedDatedatetime8
No
Foreign Keys FK_VanlineStatementDetail_VanlineStatementDownloadLog: [dbo].[VanlineStatementDownloadLog].VanlineStatementDownloadLogFIDVanlineStatementDownloadLogFIDint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_VanlineStatementDetail: VanlineStatementDetailIDPK_VanlineStatementDetailVanlineStatementDetailID
Yes
IX_VanlineStatementDetail_HeaderStageDetailFIDVanlineStatementHeaderFID, StageDetailFID
Yes
IX_VanlineStatementDetail_HeaderOrderControlVanlineStatementHeaderFID, OrderControl
Foreign Keys Foreign Keys
NameColumns
FK_VanlineStatementDetail_VanlineStatementDownloadLogVanlineStatementDownloadLogFID->[dbo].[VanlineStatementDownloadLog].[VanlineStatementDownloadLogID]
FK_VanlineStatementDetail_VanlineStatementHeaderVanlineStatementHeaderFID->[dbo].[VanlineStatementHeader].[VanlineStatementHeaderID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
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
Uses
Used By