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