Tables [dbo].[SOSImageConversion]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created1:00:53 AM Thursday, March 21, 2019
Last Modified1:00:53 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
CustomerNumbervarchar(32)32
True
Customeridint4
False
NotesDocidvarchar(50)50
True
DocTypevarchar(50)50
True
CreateDatedatetime8
True
Referencevarchar(50)50
True
Descriptionvarchar(256)256
True
Processedbit1
True
FilePathvarchar(1000)1000
True
FileNamevarchar(255)255
False
CustomerNamevarchar(128)128
True
DBFileIDint4
True
CREATE TABLE [dbo].[SOSImageConversion]
(
[CustomerNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Customerid] [int] NOT NULL,
[NotesDocid] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DocType] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreateDate] [datetime] NULL,
[Reference] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Processed] [bit] NULL,
[FilePath] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FileName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CustomerName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DBFileID] [int] NULL
) ON [PRIMARY]
GO