Tables [dbo].[rptGLPresTransDetails_EX]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:58:50 AM Thursday, March 21, 2019
Last Modified1:14:04 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
RowIDint4
False
1 - 1
Foreign Keys FK_rptGLPresTransDetails_EX_ReportLeaseID_rptRPReportLeases_EX: [dbo].[rptRPReportLeases_EX].ReportLeaseIDReportLeaseIDint4
False
TransactionDetailIDint4
True
AccountIDint4
False
DeptIDint4
True
ItemIDint4
True
ModelIDint4
True
ParentModelIDint4
True
EquipmentIDint4
True
MeterIDint4
True
OrigAmountmoney8
False
Amountmoney8
False
TransactionTypeIDint4
False
Referencevarchar(512)512
True
SubReferencevarchar(64)64
True
Datedatetime8
False
Periodint4
False
BranchIDint4
True
Descriptionvarchar(255)255
True
ContractIDint4
True
CustomerIDint4
True
BillToIDint4
True
ShipToIDint4
True
VendorIDint4
True
SalesRepIDint4
True
OutCostmoney8
True
TechnicianIDint4
True
SegmentIDint4
True
CategoryIDint4
True
Categoryvarchar(64)64
True
PresAccountIDvarchar(64)64
True
Percentagedecimal(16,4)9
True
Multiplierint4
False
((1))
CountedCopiesint4
True
CoveredCopiesint4
True
BillableCopiesint4
True
NameColumns
FK_rptGLPresTransDetails_EX_ReportLeaseID_rptRPReportLeases_EXReportLeaseID->[dbo].[rptRPReportLeases_EX].[ReportLeaseID]
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