Tables [dbo].[SCContractMRISummaryExtended]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:59:18 AM Thursday, March 21, 2019
Last Modified12:59:18 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
ContractMRISummaryIDint4
False
CodeIDint4
True
ContractMRISummarySubIDint4
False
MetCodevarchar(10)10
False
MetDescvarchar(128)128
True
MetTotaldecimal(20,4)13
True
MetAmount1Descvarchar(32)32
True
MetAmount1decimal(20,4)13
True
MetAmount2Descvarchar(33)33
True
MetAmount2decimal(20,4)13
True
LastUpdatedatetime8
True
CREATE TABLE [dbo].[SCContractMRISummaryExtended]
(
[ContractMRISummaryID] [int] NOT NULL,
[CodeID] [int] NULL,
[ContractMRISummarySubID] [int] NOT NULL,
[MetCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MetDesc] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MetTotal] [decimal] (20, 4) NULL,
[MetAmount1Desc] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MetAmount1] [decimal] (20, 4) NULL,
[MetAmount2Desc] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MetAmount2] [decimal] (20, 4) NULL,
[LastUpdate] [datetime] NULL
) ON [PRIMARY]
GO