Tables [dbo].[SHStates]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created1:00:44 AM Thursday, March 21, 2019
Last Modified1:15:34 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
StateIDint4
False
1 - 1
Statevarchar(16)16
True
StateNamevarchar(32)32
True
Typeint4
True
SalesTaxLiabilityGLIDint4
True
Activebit1
False
((1))
Foreign Keys FK_SHStates_VendorID_APVendors: [dbo].[APVendors].VendorIDVendorIDint4
True
NameColumns
FK_SHStates_VendorID_APVendorsVendorID->[dbo].[APVendors].[VendorID]
CREATE TABLE [dbo].[SHStates]
(
[StateID] [int] NOT NULL IDENTITY(1, 1),
[State] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StateName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Type] [int] NULL,
[SalesTaxLiabilityGLID] [int] NULL,
[Active] [bit] NOT NULL CONSTRAINT [DF_SHStates_Active] DEFAULT ((1)),
[VendorID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHStates] ADD CONSTRAINT [FK_SHStates_VendorID_APVendors] FOREIGN KEY ([VendorID]) REFERENCES [dbo].[APVendors] ([VendorID])
GO