Tables [dbo].[SCEquipmentBillingsEx]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:59:19 AM Thursday, March 21, 2019
Last Modified1:07:57 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsDefault
EquipmentIDint4
False
EquipLocationIDint4
True
EquipCustomerIDint4
True
Periodint4
False
DatePeriodint4
False
GLPeriodint4
False
ContractIDint4
True
ContractMajorvarchar(32)32
True
BillingTypeIDint4
False
InvoiceIDint4
True
ItemIDint4
True
Quantitydecimal(18,6)9
True
((0))
Amountmoney8
False
Costmoney8
False
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
CostBWmoney8
False
((0))
CostColormoney8
False
((0))
CREATE TABLE [dbo].[SCEquipmentBillingsEx]
(
[EquipmentID] [int] NOT NULL,
[EquipLocationID] [int] NULL,
[EquipCustomerID] [int] NULL,
[Period] [int] NOT NULL,
[DatePeriod] [int] NOT NULL,
[GLPeriod] [int] NOT NULL,
[ContractID] [int] NULL,
[ContractMajor] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillingTypeID] [int] NOT NULL,
[InvoiceID] [int] NULL,
[ItemID] [int] NULL,
[Quantity] [decimal] (18, 6) NULL CONSTRAINT [DF_SCEquipmentBillingsEx_Quantity] DEFAULT ((0)),
[Amount] [money] NOT NULL,
[Cost] [money] NOT NULL,
[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,
[CostBW] [money] NOT NULL CONSTRAINT [DF_SCEquipmentBillingsEx_CostBW] DEFAULT ((0)),
[CostColor] [money] NOT NULL CONSTRAINT [DF_SCEquipmentBillingsEx_CostColor] DEFAULT ((0))
) ON [PRIMARY]
GO