Tables [dbo].[ICItems$]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:57:30 AM Thursday, March 21, 2019
Last Modified12:57:30 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
Itemnvarchar(255)510
True
Descriptionnvarchar(255)510
True
BarCodenvarchar(255)510
True
Serializednvarchar(255)510
True
WebEnablednvarchar(255)510
True
UMnvarchar(255)510
True
Categorynvarchar(255)510
True
InventoryCodenvarchar(255)510
True
Costnvarchar(255)510
True
ExpenseCodenvarchar(255)510
True
SalesCodenvarchar(255)510
True
F12nvarchar(255)510
True
F13nvarchar(255)510
True
F14nvarchar(255)510
True
ServiceCodenvarchar(255)510
True
F16nvarchar(255)510
True
EquipmentCodenvarchar(255)510
True
f18nvarchar(255)510
True
F19nvarchar(255)510
True
F20nvarchar(255)510
True
F21nvarchar(255)510
True
F22nvarchar(255)510
True
F23nvarchar(255)510
True
F24nvarchar(255)510
True
F25nvarchar(255)510
True
F26nvarchar(255)510
True
F27nvarchar(255)510
True
F28nvarchar(255)510
True
CREATE TABLE [dbo].[ICItems$]
(
[Item] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BarCode] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Serialized] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebEnabled] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UM] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Category] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InventoryCode] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Cost] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExpenseCode] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SalesCode] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[F12] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[F13] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[F14] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ServiceCode] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[F16] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipmentCode] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[f18] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[F19] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[F20] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[F21] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[F22] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[F23] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[F24] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[F25] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[F26] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[F27] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[F28] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO