CREATE TABLE [dbo].[rptGLPresTransDetails_EX]
(
[RowID] [int] NOT NULL IDENTITY(1, 1),
[ReportLeaseID] [int] NOT NULL,
[TransactionDetailID] [int] NULL,
[AccountID] [int] NOT NULL,
[DeptID] [int] NULL,
[ItemID] [int] NULL,
[ModelID] [int] NULL,
[ParentModelID] [int] NULL,
[EquipmentID] [int] NULL,
[MeterID] [int] NULL,
[OrigAmount] [money] NOT NULL,
[Amount] [money] NOT NULL,
[TransactionTypeID] [int] NOT NULL,
[Reference] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SubReference] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Date] [datetime] NOT NULL,
[Period] [int] NOT NULL,
[BranchID] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContractID] [int] NULL,
[CustomerID] [int] NULL,
[BillToID] [int] NULL,
[ShipToID] [int] NULL,
[VendorID] [int] NULL,
[SalesRepID] [int] NULL,
[OutCost] [money] NULL,
[TechnicianID] [int] NULL,
[SegmentID] [int] NULL,
[CategoryID] [int] NULL,
[Category] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PresAccountID] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Percentage] [decimal] (16, 4) NULL,
[Multiplier] [int] NOT NULL CONSTRAINT [DF_rptGLPresTransDetails_EX_Multiplier] DEFAULT ((1)),
[CountedCopies] [int] NULL,
[CoveredCopies] [int] NULL,
[BillableCopies] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[rptGLPresTransDetails_EX] ADD CONSTRAINT [FK_rptGLPresTransDetails_EX_ReportLeaseID_rptRPReportLeases_EX] FOREIGN KEY ([ReportLeaseID]) REFERENCES [dbo].[rptRPReportLeases_EX] ([ReportLeaseID])
GO