Tables [dbo].[InvoicedGroup]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)183258
Created4:57:09 PM Thursday, September 7, 2006
Last Modified7:35:54 PM Tuesday, June 11, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_InvoicedGroup: IGPriKeyIGPriKeyint4
No
1 - 1
Foreign Keys FK_InvoicedGroup_InvoicedHeader: [dbo].[InvoicedHeader].IHPriKeyIndexes IX_InvoicedGroup_BillingMajor: IHPriKey\BillingMajorFIDIndexes IX_InvoicedGroup_BillingMinor: IHPriKey\BillingMinorFIDIndexes IX_InvoicedGroup_ExtraStopFID: IHPriKey\ExtraStopFIDIndexes IX_InvoicedGroup_IHPriKey: IHPriKeyIHPriKeyint4
No
Descriptionvarchar(128)128
No
Amountmoney8
Yes
ItemCodeint4
Yes
Quantityfloat8
Yes
Ratefloat8
Yes
Discountfloat8
Yes
GrossAmountmoney8
Yes
SortOrderint4
No
Indexes IX_InvoicedGroup_BillingMajor: IHPriKey\BillingMajorFIDBillingMajorFIDint4
Yes
Indexes IX_InvoicedGroup_BillingMinor: IHPriKey\BillingMinorFIDBillingMinorFIDint4
Yes
Rollupbit1
No
((0))
Adhocbit1
No
((0))
ClaimHandlingRevenueFIDint4
Yes
ClaimItemDueFromFIDint4
Yes
Quantity2float8
Yes
Foreign Keys FK_InvoicedGroup_RateType: [dbo].[RateTypes].RateTypeFIDRateTypeFIDint4
Yes
SubTotalFlagbit1
No
((0))
Foreign Keys FK_InvoicedGroup_CustomerInvoiceReportEDIItem: [dbo].[CustomerInvoiceReportEDIItem].CustomerInvoiceReportEDIItemFIDCustomerInvoiceReportEDIItemFIDint4
Yes
Foreign Keys FK_InvoicedGroup_PointOfService: [dbo].[PointOfService].PointOfServiceFIDPointOfServiceFIDint4
Yes
Foreign Keys FK_InvoicedGroup_ExtraStop: [dbo].[XtraStop].ExtraStopFIDIndexes IX_InvoicedGroup_ExtraStopFID: IHPriKey\ExtraStopFIDExtraStopFIDint4
Yes
NoteTextvarchar(1024)1024
Yes
Foreign Keys FK_InvoicedGroup_LaborRatingTypeFID: [dbo].[LaborRatingType].LaborRatingTypeFIDLaborRatingTypeFIDint4
Yes
RateSourcevarchar(50)50
Yes
RateSourceRecordint4
Yes
Indexes Indexes
NameColumnsUniqueFill Factor
Cluster Primary Key PK_InvoicedGroup: IGPriKeyPK_InvoicedGroupIGPriKey
Yes
80
IX_InvoicedGroup_BillingMajorIHPriKey, BillingMajorFID
IX_InvoicedGroup_BillingMinorIHPriKey, BillingMinorFID
IX_InvoicedGroup_ExtraStopFIDIHPriKey, ExtraStopFID
IX_InvoicedGroup_IHPriKeyIHPriKey80
Foreign Keys Foreign Keys
NameUpdateDeleteColumns
FK_InvoicedGroup_CustomerInvoiceReportEDIItemCustomerInvoiceReportEDIItemFID->[dbo].[CustomerInvoiceReportEDIItem].[CustomerInvoiceReportEDIItemID]
FK_InvoicedGroup_ExtraStopExtraStopFID->[dbo].[XtraStop].[PriKey]
FK_InvoicedGroup_InvoicedHeaderCascadeCascadeIHPriKey->[dbo].[InvoicedHeader].[IHPriKey]
FK_InvoicedGroup_LaborRatingTypeFIDLaborRatingTypeFID->[dbo].[LaborRatingType].[LaborRatingTypeID]
FK_InvoicedGroup_PointOfServicePointOfServiceFID->[dbo].[PointOfService].[PointOfServiceID]
FK_InvoicedGroup_RateTypeRateTypeFID->[dbo].[RateTypes].[RTypePriKey]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[InvoicedGroup]
(
[IGPriKey] [int] NOT NULL IDENTITY(1, 1),
[IHPriKey] [int] NOT NULL,
[Description] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Amount] [money] NULL,
[ItemCode] [int] NULL,
[Quantity] [float] NULL,
[Rate] [float] NULL,
[Discount] [float] NULL,
[GrossAmount] [money] NULL,
[SortOrder] [int] NOT NULL,
[BillingMajorFID] [int] NULL,
[BillingMinorFID] [int] NULL,
[Rollup] [bit] NOT NULL CONSTRAINT [DF_InvoicedGroup_Rollup] DEFAULT ((0)),
[Adhoc] [bit] NOT NULL CONSTRAINT [DF_InvoicedGroup_Adhoc] DEFAULT ((0)),
[ClaimHandlingRevenueFID] [int] NULL,
[ClaimItemDueFromFID] [int] NULL,
[Quantity2] [float] NULL,
[RateTypeFID] [int] NULL,
[SubTotalFlag] [bit] NOT NULL CONSTRAINT [DF_InvoicedGroup_SubTotalFlag] DEFAULT ((0)),
[CustomerInvoiceReportEDIItemFID] [int] NULL,
[PointOfServiceFID] [int] NULL,
[ExtraStopFID] [int] NULL,
[NoteText] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LaborRatingTypeFID] [int] NULL,
[RateSource] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RateSourceRecord] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[InvoicedGroup] ADD CONSTRAINT [PK_InvoicedGroup] PRIMARY KEY CLUSTERED  ([IGPriKey]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_InvoicedGroup_BillingMajor] ON [dbo].[InvoicedGroup] ([BillingMajorFID]) INCLUDE ([IHPriKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_InvoicedGroup_BillingMinor] ON [dbo].[InvoicedGroup] ([BillingMinorFID]) INCLUDE ([IHPriKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_InvoicedGroup_ExtraStopFID] ON [dbo].[InvoicedGroup] ([ExtraStopFID]) INCLUDE ([IHPriKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_InvoicedGroup_IHPriKey] ON [dbo].[InvoicedGroup] ([IHPriKey]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[InvoicedGroup] ADD CONSTRAINT [FK_InvoicedGroup_CustomerInvoiceReportEDIItem] FOREIGN KEY ([CustomerInvoiceReportEDIItemFID]) REFERENCES [dbo].[CustomerInvoiceReportEDIItem] ([CustomerInvoiceReportEDIItemID])
GO
ALTER TABLE [dbo].[InvoicedGroup] ADD CONSTRAINT [FK_InvoicedGroup_ExtraStop] FOREIGN KEY ([ExtraStopFID]) REFERENCES [dbo].[XtraStop] ([PriKey])
GO
ALTER TABLE [dbo].[InvoicedGroup] ADD CONSTRAINT [FK_InvoicedGroup_InvoicedHeader] FOREIGN KEY ([IHPriKey]) REFERENCES [dbo].[InvoicedHeader] ([IHPriKey]) ON DELETE CASCADE ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[InvoicedGroup] ADD CONSTRAINT [FK_InvoicedGroup_LaborRatingTypeFID] FOREIGN KEY ([LaborRatingTypeFID]) REFERENCES [dbo].[LaborRatingType] ([LaborRatingTypeID])
GO
ALTER TABLE [dbo].[InvoicedGroup] ADD CONSTRAINT [FK_InvoicedGroup_PointOfService] FOREIGN KEY ([PointOfServiceFID]) REFERENCES [dbo].[PointOfService] ([PointOfServiceID])
GO
ALTER TABLE [dbo].[InvoicedGroup] ADD CONSTRAINT [FK_InvoicedGroup_RateType] FOREIGN KEY ([RateTypeFID]) REFERENCES [dbo].[RateTypes] ([RTypePriKey])
GO
GRANT SELECT ON  [dbo].[InvoicedGroup] TO [MssExec]
GRANT INSERT ON  [dbo].[InvoicedGroup] TO [MssExec]
GRANT DELETE ON  [dbo].[InvoicedGroup] TO [MssExec]
GRANT UPDATE ON  [dbo].[InvoicedGroup] TO [MssExec]
GO
Uses
Used By