CREATE TABLE [dbo].[RPFormatCodeDetails]
(
[FormatCodeDetailID] [int] NOT NULL IDENTITY(1, 1),
[FormatCodeID] [int] NOT NULL,
[Name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GroupByDigits] [int] NULL,
[GroupLevel] [int] NULL,
[GroupByValueFrom] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GroupByValueTo] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GroupOrderby] [int] NULL,
[ShowHeader] [bit] NULL,
[ShowFooter] [bit] NULL,
[SubtotalFlag] [int] NULL,
[CreatorID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_RPFormatCodeDetails_CreateDate] DEFAULT (getdate()),
[UpdatorID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_RPFormatCodeDetails_LastUpdate] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPFormatCodeDetails] ADD CONSTRAINT [PK__RPFormat__4BD3CF82AF291DF0] PRIMARY KEY CLUSTERED ([FormatCodeDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPFormatCodeDetails] ADD CONSTRAINT [FK_RPFormatCodeDetails_FormatCodeID_RPFormatCodes] FOREIGN KEY ([FormatCodeID]) REFERENCES [dbo].[RPFormatCodes] ([FormatCodeID])
GO