[dbo].[RevenueRatingImportInvoiceFuel]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count (~)	3
Created	7:37:30 PM Tuesday, September 24, 2024
Last Modified	7:37:30 PM Tuesday, September 24, 2024

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count (~)

Created

7:37:30 PM Tuesday, September 24, 2024

Last Modified

7:37:30 PM Tuesday, September 24, 2024

	Name	Data Type	Max Length (Bytes)	Identity
	RevenueRatingImportInvoiceFuelID	int	4	1 - 1
$Cluster Key IX_RevenueRatingImportInvoiceFuel_FuelCalculatedCode: FuelDistributionCode\CalculatedFromDistributionCode$	FuelDistributionCode	varchar(10)	10
$Cluster Key IX_RevenueRatingImportInvoiceFuel_FuelCalculatedCode: FuelDistributionCode\CalculatedFromDistributionCode$	CalculatedFromDistributionCode	varchar(10)	10

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

RevenueRatingImportInvoiceFuelID

int

1 - 1

$Cluster Key IX_RevenueRatingImportInvoiceFuel_FuelCalculatedCode: FuelDistributionCode\CalculatedFromDistributionCode$

FuelDistributionCode

varchar(10)

$Cluster Key IX_RevenueRatingImportInvoiceFuel_FuelCalculatedCode: FuelDistributionCode\CalculatedFromDistributionCode$

CalculatedFromDistributionCode

varchar(10)

	Name	Columns	Unique
	PK_RevenueRatingImportInvoiceFuel	RevenueRatingImportInvoiceFuelID
$Cluster Key IX_RevenueRatingImportInvoiceFuel_FuelCalculatedCode: FuelDistributionCode\CalculatedFromDistributionCode$	IX_RevenueRatingImportInvoiceFuel_FuelCalculatedCode	FuelDistributionCode, CalculatedFromDistributionCode

Name

Columns

Unique

PK_RevenueRatingImportInvoiceFuel

RevenueRatingImportInvoiceFuelID

$Cluster Key IX_RevenueRatingImportInvoiceFuel_FuelCalculatedCode: FuelDistributionCode\CalculatedFromDistributionCode$

IX_RevenueRatingImportInvoiceFuel_FuelCalculatedCode

FuelDistributionCode, CalculatedFromDistributionCode

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

Type

Action

Owning Principal

Grant

Delete

MssExec

Grant

Insert

MssExec

Grant

Select

MssExec

Grant

Update

MssExec

SQL Script

CREATE TABLE [dbo].[RevenueRatingImportInvoiceFuel]
(
[RevenueRatingImportInvoiceFuelID] [int] NOT NULL IDENTITY(1, 1),
[FuelDistributionCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CalculatedFromDistributionCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RevenueRatingImportInvoiceFuel] ADD CONSTRAINT [PK_RevenueRatingImportInvoiceFuel] PRIMARY KEY NONCLUSTERED  ([RevenueRatingImportInvoiceFuelID]) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [IX_RevenueRatingImportInvoiceFuel_FuelCalculatedCode] ON [dbo].[RevenueRatingImportInvoiceFuel] ([FuelDistributionCode], [CalculatedFromDistributionCode]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[RevenueRatingImportInvoiceFuel] TO [MssExec]
GRANT INSERT ON  [dbo].[RevenueRatingImportInvoiceFuel] TO [MssExec]
GRANT DELETE ON  [dbo].[RevenueRatingImportInvoiceFuel] TO [MssExec]
GRANT UPDATE ON  [dbo].[RevenueRatingImportInvoiceFuel] TO [MssExec]
GO