[dbo].[RevenueRatingImportedInvoiceDetail]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count (~)	0
Created	9:05:59 AM Friday, November 22, 2024
Last Modified	9:06:03 AM Friday, November 22, 2024

Name	Data Type	Max Length (Bytes)	Identity
RevenueRatingImportedInvoiceDetailID	int	4	1 - 1
RevenueRatingImportedHeaderFID	int	4
AgentFID	int	4
Description	varchar(128)	128
GrossAmount	decimal(12,4)	9
DiscountPct	decimal(12,4)	9
DistributionCode	varchar(10)	10
PrintDescription	varchar(128)	128
Quantity2	decimal(12,4)	9
Quantity	decimal(12,4)	9
Rate	decimal(12,4)	9
RateTypeFID	int	4
ImportDateTime	datetime	8
OrdersFID	int	4
CarrierBillingMinorFID	int	4
CarrierBillingMajorFID	int	4

	Name	Columns	Unique
	PK_RevenueRatingImportedInvoiceDetail	RevenueRatingImportedInvoiceDetailID
	IX_RevenueRatingImportedInvoiceDetail_CarrierBillingMinor	CarrierBillingMinorFID
	IX_RevenueRatingImportedInvoiceDetailFID	RevenueRatingImportedHeaderFID

Name	Delete	Columns
FK_RevenueRatingImportedInvoiceDetail_Agent		AgentFID->[dbo].[Agent].[AgentPriKey]
FK_RevenueRatingImportedInvoiceDetail_RateType	SetNull	RateTypeFID->[dbo].[RateTypes].[RTypePriKey]
FK_RevenueRatingImportedInvoiceDetail_RevenueRatingImportedHeader	Cascade	RevenueRatingImportedHeaderFID->[dbo].[RevenueRatingImportedHeader].[RevenueRatingImportedHeaderID]

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

SQL Script

CREATE TABLE [dbo].[RevenueRatingImportedInvoiceDetail]
(
[RevenueRatingImportedInvoiceDetailID] [int] NOT NULL IDENTITY(1, 1),
[RevenueRatingImportedHeaderFID] [int] NOT NULL,
[AgentFID] [int] NULL,
[Description] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GrossAmount] [decimal] (12, 4) NULL,
[DiscountPct] [decimal] (12, 4) NULL,
[DistributionCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PrintDescription] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Quantity2] [decimal] (12, 4) NULL,
[Quantity] [decimal] (12, 4) NULL,
[Rate] [decimal] (12, 4) NULL,
[RateTypeFID] [int] NULL,
[ImportDateTime] [datetime] NULL,
[OrdersFID] [int] NULL,
[CarrierBillingMinorFID] [int] NULL,
[CarrierBillingMajorFID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RevenueRatingImportedInvoiceDetail] ADD CONSTRAINT [PK_RevenueRatingImportedInvoiceDetail] PRIMARY KEY NONCLUSTERED  ([RevenueRatingImportedInvoiceDetailID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_RevenueRatingImportedInvoiceDetail_CarrierBillingMinor] ON [dbo].[RevenueRatingImportedInvoiceDetail] ([CarrierBillingMinorFID]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [IX_RevenueRatingImportedInvoiceDetailFID] ON [dbo].[RevenueRatingImportedInvoiceDetail] ([RevenueRatingImportedHeaderFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RevenueRatingImportedInvoiceDetail] ADD CONSTRAINT [FK_RevenueRatingImportedInvoiceDetail_Agent] FOREIGN KEY ([AgentFID]) REFERENCES [dbo].[Agent] ([AgentPriKey])
GO
ALTER TABLE [dbo].[RevenueRatingImportedInvoiceDetail] ADD CONSTRAINT [FK_RevenueRatingImportedInvoiceDetail_RateType] FOREIGN KEY ([RateTypeFID]) REFERENCES [dbo].[RateTypes] ([RTypePriKey]) ON DELETE SET NULL
GO
ALTER TABLE [dbo].[RevenueRatingImportedInvoiceDetail] ADD CONSTRAINT [FK_RevenueRatingImportedInvoiceDetail_RevenueRatingImportedHeader] FOREIGN KEY ([RevenueRatingImportedHeaderFID]) REFERENCES [dbo].[RevenueRatingImportedHeader] ([RevenueRatingImportedHeaderID]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[RevenueRatingImportedInvoiceDetail] TO [MssExec]
GRANT INSERT ON  [dbo].[RevenueRatingImportedInvoiceDetail] TO [MssExec]
GRANT DELETE ON  [dbo].[RevenueRatingImportedInvoiceDetail] TO [MssExec]
GRANT UPDATE ON  [dbo].[RevenueRatingImportedInvoiceDetail] TO [MssExec]
GO