Tables [dbo].[AutoCommissionOptions]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)10
Created10:12:49 PM Thursday, December 28, 2006
Last Modified6:06:10 PM Monday, April 28, 2014
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_AutoCommissionOptions: AutoCommissionOptionsIDAutoCommissionOptionsIDint4
No
1 - 1
LaborAreavarchar(64)64
No
Enabledbit1
No
((0))
ForCarrierImportbit1
No
((0))
Indexes Indexes
NameColumnsUniqueFill Factor
Cluster Primary Key PK_AutoCommissionOptions: AutoCommissionOptionsIDPK_AutoCommissionOptionsAutoCommissionOptionsID
Yes
80
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[AutoCommissionOptions]
(
[AutoCommissionOptionsID] [int] NOT NULL IDENTITY(1, 1),
[LaborArea] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Enabled] [bit] NOT NULL CONSTRAINT [DF_AutoCommissionOptions_Enabled] DEFAULT ((0)),
[ForCarrierImport] [bit] NOT NULL CONSTRAINT [DF_AutoCommissionOptions_ForCarrierImport] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AutoCommissionOptions] ADD CONSTRAINT [PK_AutoCommissionOptions] PRIMARY KEY CLUSTERED  ([AutoCommissionOptionsID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[AutoCommissionOptions] TO [MssExec]
GRANT INSERT ON  [dbo].[AutoCommissionOptions] TO [MssExec]
GRANT DELETE ON  [dbo].[AutoCommissionOptions] TO [MssExec]
GRANT UPDATE ON  [dbo].[AutoCommissionOptions] TO [MssExec]
GO
Uses
Used By