Tables [dbo].[VanlineStatementStageHeader]
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_VanlineStatementStageHeader: VanlineStatementStageHeaderIDVanlineStatementStageHeaderIDint4
No
1 - 1
AgentNumbervarchar(10)10
No
StatementDatedatetime8
No
StatementYearint4
No
StatementNumberint4
No
VanlineGroupExternalCodevarchar(10)10
No
StatementDescriptionvarchar(30)30
Yes
IsCRBatchbit1
Yes
IsVanLineStatementbit1
Yes
AutoApplybit1
Yes
Importablebit1
No
ImportCompletebit1
No
ImportStartDatedatetime8
No
ImportEndDatedatetime8
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_VanlineStatementStageHeader: VanlineStatementStageHeaderIDPK_VanlineStatementStageHeaderVanlineStatementStageHeaderID
Yes
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[VanlineStatementStageHeader]
(
[VanlineStatementStageHeaderID] [int] NOT NULL IDENTITY(1, 1),
[AgentNumber] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[StatementDate] [datetime] NOT NULL,
[StatementYear] [int] NOT NULL,
[StatementNumber] [int] NOT NULL,
[VanlineGroupExternalCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[StatementDescription] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsCRBatch] [bit] NULL,
[IsVanLineStatement] [bit] NULL,
[AutoApply] [bit] NULL,
[Importable] [bit] NOT NULL,
[ImportComplete] [bit] NOT NULL,
[ImportStartDate] [datetime] NOT NULL,
[ImportEndDate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[VanlineStatementStageHeader] ADD CONSTRAINT [PK_VanlineStatementStageHeader] PRIMARY KEY CLUSTERED  ([VanlineStatementStageHeaderID]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[VanlineStatementStageHeader] TO [MssExec]
GRANT INSERT ON  [dbo].[VanlineStatementStageHeader] TO [MssExec]
GRANT DELETE ON  [dbo].[VanlineStatementStageHeader] TO [MssExec]
GRANT UPDATE ON  [dbo].[VanlineStatementStageHeader] TO [MssExec]
GO
Uses
Used By