Tables [dbo].[VanlineStatementStageDetail]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created9:11:36 AM Thursday, May 23, 2024
Last Modified9:11:36 AM Thursday, May 23, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_VanlineStatementStageDetail: VanlineStatementStageDetailIDVanlineStatementStageDetailIDint4
No
1 - 1
Foreign Keys FK_VanlineStatementStageDetail_VanlineStatementStageHeader: [dbo].[VanlineStatementStageHeader].VanlineStatementStageHeaderFIDIndexes IX_[VanlineStatementStageDetail_Header: VanlineStatementStageHeaderFIDVanlineStatementStageHeaderFIDint4
No
OrderControlvarchar(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
Yes
CanSeparateDistributionsbit1
Yes
SortByvarchar(128)128
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_VanlineStatementStageDetail: VanlineStatementStageDetailIDPK_VanlineStatementStageDetailVanlineStatementStageDetailID
Yes
IX_[VanlineStatementStageDetail_HeaderVanlineStatementStageHeaderFID
Foreign Keys Foreign Keys
NameDeleteColumns
FK_VanlineStatementStageDetail_VanlineStatementStageHeaderCascadeVanlineStatementStageHeaderFID->[dbo].[VanlineStatementStageHeader].[VanlineStatementStageHeaderID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[VanlineStatementStageDetail]
(
[VanlineStatementStageDetailID] [int] NOT NULL IDENTITY(1, 1),
[VanlineStatementStageHeaderFID] [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] NULL,
[CanSeparateDistributions] [bit] NULL,
[SortBy] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[VanlineStatementStageDetail] ADD CONSTRAINT [PK_VanlineStatementStageDetail] PRIMARY KEY CLUSTERED  ([VanlineStatementStageDetailID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_[VanlineStatementStageDetail_Header] ON [dbo].[VanlineStatementStageDetail] ([VanlineStatementStageHeaderFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[VanlineStatementStageDetail] ADD CONSTRAINT [FK_VanlineStatementStageDetail_VanlineStatementStageHeader] FOREIGN KEY ([VanlineStatementStageHeaderFID]) REFERENCES [dbo].[VanlineStatementStageHeader] ([VanlineStatementStageHeaderID]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[VanlineStatementStageDetail] TO [MssExec]
GRANT INSERT ON  [dbo].[VanlineStatementStageDetail] TO [MssExec]
GRANT DELETE ON  [dbo].[VanlineStatementStageDetail] TO [MssExec]
GRANT UPDATE ON  [dbo].[VanlineStatementStageDetail] TO [MssExec]
GO
Uses
Used By