Tables [dbo].[ARTransactionDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:57:01 AM Thursday, March 21, 2019
Last Modified1:10:25 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK__ARTransa__FFEE74514C3FEB81: RowIDRowIDint4
False
1 - 1
CustomerIDint4
False
ParentCustomerIDint4
True
VendorIDint4
True
Datedatetime8
False
CoverageFromDatedatetime8
False
CoverageToDatedatetime8
False
DatePeriodint4
False
Periodint4
False
Referencevarchar(32)32
False
SubReferencevarchar(128)128
False
('')
TransactionTypeIDint4
False
Descriptionvarchar(1024)1024
True
DetailDescriptionvarchar(1024)1024
True
EquipmentIDint4
True
ContractIDint4
True
ContractMajorvarchar(32)32
True
TransactionDetailTypeIDint4
False
InvoiceIDint4
True
FulfillIDint4
True
VoucherIDint4
True
DetailID1int4
True
DetailID2int4
True
DetailID3int4
True
WarehouseIDint4
True
BinIDint4
True
StockTypeIDint4
True
ItemIDint4
True
Quantitydecimal(18,6)9
False
((0))
Amountmoney8
False
Costmoney8
False
Billbit1
False
((1))
Voidbit1
False
((0))
TechnicianIDint4
True
TechnicianID2int4
True
SalesRepIDint4
True
CalculatedOutCostmoney8
False
((0))
OutCostmoney8
False
((0))
UseBaseOutCostbit1
False
((0))
OverrideOutCostbit1
False
((0))
OutCostExtendedmoney8
False
((0))
OutCostRatedecimal(18,6)9
False
((0))
MeterIDint4
True
MeterTotaldecimal(18,0)9
True
OverageMeterTotaldecimal(18,0)9
True
BilledMeterTotaldecimal(18,0)9
True
UnderageMeterTotaldecimal(18,0)9
True
MeterBWdecimal(18,0)9
True
OverageMeterBWdecimal(18,0)9
True
BilledMeterBWdecimal(18,0)9
True
UnderageMeterBWdecimal(18,0)9
True
MeterColordecimal(18,0)9
True
OverageMeterColordecimal(18,0)9
True
BilledMeterColordecimal(18,0)9
True
UnderageMeterColordecimal(18,0)9
True
MeterScannerdecimal(18,0)9
True
OverageMeterScannerdecimal(18,0)9
True
BilledMeterScannerdecimal(18,0)9
True
UnderageMeterScannerdecimal(18,0)9
True
MeterOtherdecimal(18,0)9
True
OverageMeterOtherdecimal(18,0)9
True
BilledMeterOtherdecimal(18,0)9
True
UnderageMeterOtherdecimal(18,0)9
True
CreateDatedatetime8
False
CreatorIDvarchar(32)32
False
ContractNumbervarchar(32)32
False
('')
EquipmentNumbervarchar(32)32
False
('')
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__ARTransa__FFEE74514C3FEB81: RowIDPK__ARTransa__FFEE74514C3FEB81RowID
True
80
CREATE TABLE [dbo].[ARTransactionDetails]
(
[RowID] [int] NOT NULL IDENTITY(1, 1),
[CustomerID] [int] NOT NULL,
[ParentCustomerID] [int] NULL,
[VendorID] [int] NULL,
[Date] [datetime] NOT NULL,
[CoverageFromDate] [datetime] NOT NULL,
[CoverageToDate] [datetime] NOT NULL,
[DatePeriod] [int] NOT NULL,
[Period] [int] NOT NULL,
[Reference] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SubReference] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARTransactionDetails_SubReference] DEFAULT (''),
[TransactionTypeID] [int] NOT NULL,
[Description] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DetailDescription] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipmentID] [int] NULL,
[ContractID] [int] NULL,
[ContractMajor] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TransactionDetailTypeID] [int] NOT NULL,
[InvoiceID] [int] NULL,
[FulfillID] [int] NULL,
[VoucherID] [int] NULL,
[DetailID1] [int] NULL,
[DetailID2] [int] NULL,
[DetailID3] [int] NULL,
[WarehouseID] [int] NULL,
[BinID] [int] NULL,
[StockTypeID] [int] NULL,
[ItemID] [int] NULL,
[Quantity] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ARTransactionDetails_Quantity] DEFAULT ((0)),
[Amount] [money] NOT NULL,
[Cost] [money] NOT NULL,
[Bill] [bit] NOT NULL CONSTRAINT [DF_ARTransactionDetails_Bill] DEFAULT ((1)),
[Void] [bit] NOT NULL CONSTRAINT [DF_ARTransactionDetails_Void] DEFAULT ((0)),
[TechnicianID] [int] NULL,
[TechnicianID2] [int] NULL,
[SalesRepID] [int] NULL,
[CalculatedOutCost] [money] NOT NULL CONSTRAINT [DF_ARTransactionDetails_CalculatedOutCost] DEFAULT ((0)),
[OutCost] [money] NOT NULL CONSTRAINT [DF_ARTransactionDetails_OutCost] DEFAULT ((0)),
[UseBaseOutCost] [bit] NOT NULL CONSTRAINT [DF_ARTransactionDetails_UseBaseOutCost] DEFAULT ((0)),
[OverrideOutCost] [bit] NOT NULL CONSTRAINT [DF_ARTransactionDetails_OverrideOutCost] DEFAULT ((0)),
[OutCostExtended] [money] NOT NULL CONSTRAINT [DF_ARTransactionDetails_OutCostExtended] DEFAULT ((0)),
[OutCostRate] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ARTransactionDetails_OutCostRate] DEFAULT ((0)),
[MeterID] [int] 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,
[ContractNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARTransactionDetails_ContractNumber] DEFAULT (''),
[EquipmentNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARTransactionDetails_EquipmentNumber] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARTransactionDetails] ADD CONSTRAINT [PK__ARTransa__FFEE74514C3FEB81] PRIMARY KEY CLUSTERED  ([RowID]) ON [PRIMARY]
GO