Tables [dbo].[rpt_ICTempSalesbyMonth]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:58:50 AM Thursday, March 21, 2019
Last Modified12:58:50 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
WarehouseIDint4
True
Warehousevarchar(32)32
True
ItemIDint4
True
Col1varchar(12)12
True
Col2varchar(12)12
True
Col3varchar(12)12
True
Col4varchar(12)12
True
Col5varchar(12)12
True
Col6varchar(12)12
True
Col7varchar(12)12
True
Col8varchar(12)12
True
Col9varchar(12)12
True
Col10varchar(12)12
True
Col11varchar(12)12
True
Col12varchar(12)12
True
CREATE TABLE [dbo].[rpt_ICTempSalesbyMonth]
(
[WarehouseID] [int] NULL,
[Warehouse] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ItemID] [int] NULL,
[Col1] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Col2] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Col3] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Col4] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Col5] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Col6] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Col7] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Col8] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Col9] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Col10] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Col11] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Col12] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO