Tables [dbo].[ARCommCodesMethods]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:56:42 AM Thursday, March 21, 2019
Last Modified1:01:35 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
ARCommMethodIDbigint8
False
1 - 1
Codevarchar(5)5
False
Categoryvarchar(16)16
False
CategoryIDbigint8
True
ItemTypevarchar(64)64
False
Methodvarchar(5)5
False
Ratedecimal(18,2)9
False
NetVal1varchar(32)32
True
NetFactor1decimal(18,2)9
True
NetVal2varchar(32)32
True
NetFactor2decimal(18,2)9
True
NetFeemoney8
True
RuleID1int4
True
RuleID2int4
True
ReportPeriodint4
True
PeriodLockedbit1
True
((0))
CREATE TABLE [dbo].[ARCommCodesMethods]
(
[ARCommMethodID] [bigint] NOT NULL IDENTITY(1, 1),
[Code] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Category] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CategoryID] [bigint] NULL,
[ItemType] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Method] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Rate] [decimal] (18, 2) NOT NULL,
[NetVal1] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NetFactor1] [decimal] (18, 2) NULL,
[NetVal2] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NetFactor2] [decimal] (18, 2) NULL,
[NetFee] [money] NULL,
[RuleID1] [int] NULL,
[RuleID2] [int] NULL,
[ReportPeriod] [int] NULL,
[PeriodLocked] [bit] NULL CONSTRAINT [DF_ARCommCodesMethods_PeriodLocked] DEFAULT ((0))
) ON [PRIMARY]
GO