[ca_itrm].[RPTMP_136CC7

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	1691
Created	2:19:03 PM Wednesday, March 14, 2007
Last Modified	2:19:04 PM Wednesday, March 14, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

1691

Created

2:19:03 PM Wednesday, March 14, 2007

Last Modified

2:19:04 PM Wednesday, March 14, 2007

	Name	Data Type	Max Length (Bytes)
	company_name	nvarchar(100)	200
	sw_name	nvarchar(255)	510
	sw_version_label	nvarchar(64)	128
	asset_source_uuid	binary(16)	16
$Cluster Key RPTMP_136CC7_01_index: dis_sw_uuid\IDX$	dis_sw_uuid	binary(16)	16
	UNITID	int	4
	DOMAINID	int	4
	TYPE	int	4
	AREA	nvarchar(127)	254
	NAME	nvarchar(127)	254
	LRUNDATE	int	4
	PLATFORM	int	4
$Cluster Key RPTMP_136CC7_01_index: dis_sw_uuid\IDX$	IDX	int	4
	ASSETID	binary(16)	16
	ASSETTYPE	int	4
	PRIMOBJECT	binary(16)	16
	PRIMSERVER	binary(16)	16
	SECOBJECT	binary(16)	16
	SECSERVER	binary(16)	16
	ROWFLAG	int	4
	SignatureSca_Manufactur_T0015	nvarchar(127)	254
	SignatureSca_Title_T0016	nvarchar(127)	254
	SignatureSca_VersionLab_T0017	nvarchar(127)	254

Name

Data Type

Max Length (Bytes)

Allow Nulls

company_name

nvarchar(100)

200

sw_name

nvarchar(255)

510

sw_version_label

nvarchar(64)

128

asset_source_uuid

binary(16)

$Cluster Key RPTMP_136CC7_01_index: dis_sw_uuid\IDX$

dis_sw_uuid

binary(16)

UNITID

int

DOMAINID

int

TYPE

int

AREA

nvarchar(127)

254

NAME

nvarchar(127)

254

LRUNDATE

int

PLATFORM

int

$Cluster Key RPTMP_136CC7_01_index: dis_sw_uuid\IDX$

IDX

int

ASSETID

binary(16)

ASSETTYPE

int

PRIMOBJECT

binary(16)

PRIMSERVER

binary(16)

SECOBJECT

binary(16)

SECSERVER

binary(16)

ROWFLAG

int

SignatureSca_Manufactur_T0015

nvarchar(127)

254

SignatureSca_Title_T0016

nvarchar(127)

254

SignatureSca_VersionLab_T0017

nvarchar(127)

254

	Name	Columns
$Cluster Key RPTMP_136CC7_01_index: dis_sw_uuid\IDX$	RPTMP_136CC7_01_index	dis_sw_uuid, IDX

Name

Columns

$Cluster Key RPTMP_136CC7_01_index: dis_sw_uuid\IDX$

RPTMP_136CC7_01_index

dis_sw_uuid, IDX

SQL Script

CREATE TABLE [ca_itrm].[RPTMP_136CC7_01]
(
[company_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sw_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sw_version_label] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[asset_source_uuid] [binary] (16) NULL,
[dis_sw_uuid] [binary] (16) NOT NULL,
[UNITID] [int] NULL,
[DOMAINID] [int] NULL,
[TYPE] [int] NULL,
[AREA] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NAME] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LRUNDATE] [int] NULL,
[PLATFORM] [int] NULL,
[IDX] [int] NOT NULL,
[ASSETID] [binary] (16) NULL,
[ASSETTYPE] [int] NULL,
[PRIMOBJECT] [binary] (16) NULL,
[PRIMSERVER] [binary] (16) NULL,
[SECOBJECT] [binary] (16) NULL,
[SECSERVER] [binary] (16) NULL,
[ROWFLAG] [int] NULL,
[SignatureSca_Manufactur_T0015] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SignatureSca_Title_T0016] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SignatureSca_VersionLab_T0017] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [RPTMP_136CC7_01_index] ON [ca_itrm].[RPTMP_136CC7_01] ([dis_sw_uuid], [IDX]) ON [PRIMARY]
GO