Tables [dbo].[FactoringSetup]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count (~)0
Created7:28:27 PM Tuesday, September 24, 2024
Last Modified7:28:31 PM Tuesday, September 24, 2024
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Primary Key PK_FactoringSetup: FactoringSetupIDCheck Constraints CK_FactoringSetupID : ([FactoringSetupID]=(1))FactoringSetupIDint4
No
ContraAccountvarchar(66)66
No
DueFromAccountvarchar(66)66
No
DateLastModifieddatetime8
No
Indexes Indexes
NameColumnsUnique
Primary Key PK_FactoringSetup: FactoringSetupIDPK_FactoringSetupFactoringSetupID
Yes
Check Constraints Check Constraints
NameOn ColumnConstraint
CK_FactoringSetupIDFactoringSetupID([FactoringSetupID]=(1))
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[FactoringSetup]
(
[FactoringSetupID] [int] NOT NULL,
[ContraAccount] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DueFromAccount] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DateLastModified] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FactoringSetup] ADD CONSTRAINT [CK_FactoringSetupID] CHECK (([FactoringSetupID]=(1)))
GO
ALTER TABLE [dbo].[FactoringSetup] ADD CONSTRAINT [PK_FactoringSetup] PRIMARY KEY NONCLUSTERED  ([FactoringSetupID]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[FactoringSetup] TO [MssExec]
GRANT INSERT ON  [dbo].[FactoringSetup] TO [MssExec]
GRANT DELETE ON  [dbo].[FactoringSetup] TO [MssExec]
GRANT UPDATE ON  [dbo].[FactoringSetup] TO [MssExec]
GO
Uses
Used By