CREATE TABLE [dbo].[ARTransactionDetailDistributions]
(
[RowID] [int] NOT NULL IDENTITY(1, 1),
[ParentRowID] [int] NOT NULL,
[CoverageFromDate] [datetime] NOT NULL,
[CoverageToDate] [datetime] NOT NULL,
[CoverageDatePeriod] [int] NOT NULL,
[CoveragePeriod] [int] NOT NULL,
[Quantity] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ARTransactionDetailDistributions_Quantity] DEFAULT ((0)),
[Amount] [money] NOT NULL,
[Cost] [money] NOT NULL,
[GLID] [int] NULL,
[DeptID] [int] NULL,
[CostGLID] [int] NULL,
[CostDeptID] [int] NULL,
[TaxFlag] [int] NOT NULL,
[MeterTotal] [decimal] (18, 0) NULL,
[OverageMeterTotal] [decimal] (18, 0) NULL,
[BilledMeterTotal] [decimal] (18, 0) NULL,
[UnderageMeterTotal] [decimal] (18, 0) NULL,
[MeterBW] [decimal] (18, 0) NULL,
[OverageMeterBW] [decimal] (18, 0) NULL,
[BilledMeterBW] [decimal] (18, 0) NULL,
[UnderageMeterBW] [decimal] (18, 0) NULL,
[MeterColor] [decimal] (18, 0) NULL,
[OverageMeterColor] [decimal] (18, 0) NULL,
[BilledMeterColor] [decimal] (18, 0) NULL,
[UnderageMeterColor] [decimal] (18, 0) NULL,
[MeterScanner] [decimal] (18, 0) NULL,
[OverageMeterScanner] [decimal] (18, 0) NULL,
[BilledMeterScanner] [decimal] (18, 0) NULL,
[UnderageMeterScanner] [decimal] (18, 0) NULL,
[MeterOther] [decimal] (18, 0) NULL,
[OverageMeterOther] [decimal] (18, 0) NULL,
[BilledMeterOther] [decimal] (18, 0) NULL,
[UnderageMeterOther] [decimal] (18, 0) NULL,
[CreateDate] [datetime] NOT NULL,
[CreatorID] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARTransactionDetailDistributions] ADD CONSTRAINT [PK__ARTransa__FFEE745152957793] PRIMARY KEY CLUSTERED ([RowID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARTransactionDetailDistributions] ADD CONSTRAINT [FK_ARTransactionDetailDistributions_ParentRowID_ARTransactionDetails] FOREIGN KEY ([ParentRowID]) REFERENCES [dbo].[ARTransactionDetails] ([RowID])
GO