CREATE TABLE [dbo].[FilterConditions] (
	[cflt] [numeric](18, 0) NOT NULL ,
	[seqn] [int] NOT NULL ,
	[cfld] [varchar] (30) NULL ,
	[oper] [int] NULL ,
	[valu] [varchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Filters] (
	[seco] [char] (10) NOT NULL ,
	[tviw] [smallint] NOT NULL ,
	[fltr] [varchar] (30) NULL ,
	[cflt] [numeric](18, 0) IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tcccp001] (
	[ract] [char] (6) NOT NULL ,
	[dsca] [varchar] (30) NOT NULL ,
	[avlb] [int] NULL ,
	[ptmu] [int] NULL ,
	[hrsd] [float] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tcccp030] (
	[ccal] [char] (9) NOT NULL ,
	[ract] [char] (6) NOT NULL ,
	[stdt] [datetime] NOT NULL ,
	[sttm] [numeric](18, 0) NOT NULL ,
	[endt] [datetime] NULL ,
	[entm] [numeric](18, 0) NULL ,
	[cutm] [numeric](18, 0) NULL ,
	[ccap] [numeric](18, 0) NULL ,
	[ustm] [datetime] NULL ,
	[uftm] [datetime] NULL ,
	[ahrs] [char] (19) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tccom130] (
	[cadr] [char] (9) NOT NULL ,
	[nama] [varchar] (35) NULL ,
	[namc] [varchar] (30) NULL ,
	[hono] [char] (10) NULL ,
	[name] [varchar] (30) NULL ,
	[pstc] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tsbss001] (
	[seco] [char] (10) NOT NULL ,
	[dsca] [varchar] (30) NULL ,
	[vers] [int] NULL ,
	[pbst] [datetime] NULL ,
	[pbet] [datetime] NULL ,
	[tost] [datetime] NULL ,
	[toet] [datetime] NULL ,
	[uset] [bit] NOT NULL ,
	[bwpa] [varchar] (200) NULL ,
	[vidt] [int] NULL ,
	[vitt] [int] NULL ,
	[scse] [char] (1200) NULL ,
	[sase] [char] (1200) NULL ,
	[skse] [char] (1200) NULL ,
	[dspr] [int] NULL ,
	[aurf] [bit] NOT NULL ,
	[rein] [int] NULL ,
	[sayn] [bit] NOT NULL ,
	[obdc] [varchar] (4) NULL ,
	[abdc] [varchar] (4) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tsbss002] (
	[seco] [char] (10) NOT NULL ,
	[vfro] [bit] NOT NULL ,
	[vplo] [bit] NOT NULL ,
	[vrlo] [bit] NOT NULL ,
	[vcmo] [bit] NOT NULL ,
	[vcoo] [bit] NOT NULL ,
	[vcao] [bit] NOT NULL ,
	[vclo] [bit] NOT NULL ,
	[vfra] [numeric](18, 0) NULL ,
	[vpla] [numeric](18, 0) NULL ,
	[vrla] [numeric](18, 0) NULL ,
	[vcma] [numeric](18, 0) NULL ,
	[vcoa] [numeric](18, 0) NULL ,
	[vcaa] [numeric](18, 0) NULL ,
	[vcla] [numeric](18, 0) NULL ,
	[dsuo] [varchar] (4) NULL ,
	[dsua] [varchar] (4) NULL ,
	[flyn] [bit] NOT NULL ,
	[flin] [int] NULL ,
	[ftna] [int] NULL ,
	[fonr] [int] NULL ,
	[fonc] [int] NULL ,
	[bcna] [numeric](18, 0) NULL ,
	[cfro] [numeric](18, 0) NULL ,
	[cplo] [numeric](18, 0) NULL ,
	[crlo] [numeric](18, 0) NULL ,
	[ccmo] [numeric](18, 0) NULL ,
	[ccoo] [numeric](18, 0) NULL ,
	[ccao] [numeric](18, 0) NULL ,
	[cclo] [numeric](18, 0) NULL ,
	[sybl] [int] NULL ,
	[syem] [int] NULL ,
	[syap] [int] NULL ,
	[syaa] [int] NULL ,
	[tif1] [varchar] (50) NULL ,
	[tif2] [varchar] (50) NULL ,
	[tif3] [varchar] (50) NULL ,
	[tif4] [varchar] (50) NULL ,
	[orpo] [char] (70) NULL ,
	[acpo] [char] (70) NULL ,
	[avse] [char] (1200) NULL ,
	[cavb] [char] (1200) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tsbss003] (
	[seco] [char] (10) NOT NULL ,
	[cfse] [char] (10) NULL ,
	[vfrp] [bit] NOT NULL ,
	[vrlp] [bit] NOT NULL ,
	[vfip] [bit] NOT NULL ,
	[vtrp] [bit] NOT NULL ,
	[vcmp] [bit] NOT NULL ,
	[cfra] [numeric](18, 0) NULL ,
	[cpla] [numeric](18, 0) NULL ,
	[crla] [numeric](18, 0) NULL ,
	[cfrp] [numeric](18, 0) NULL ,
	[crlp] [numeric](18, 0) NULL ,
	[cflp] [numeric](18, 0) NULL ,
	[ctrp] [numeric](18, 0) NULL ,
	[ccmp] [numeric](18, 0) NULL ,
	[cpts] [char] (1200) NULL ,
	[csrp] [char] (1200) NULL ,
	[bcrs] [numeric](18, 0) NULL ,
	[bcrv] [numeric](18, 0) NULL ,
	[bctv] [numeric](18, 0) NULL ,
	[bcsa] [numeric](18, 0) NULL ,
	[prsh] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tscfg200] (
	[ccfg] [char] (8) NOT NULL ,
	[crob] [char] (50) NOT NULL ,
	[oseq] [int] NOT NULL ,
	[dsca] [varchar] (30) NOT NULL ,
	[sear] [varchar] (16) NULL ,
	[dscb] [varchar] (6) NULL ,
	[dscc] [varchar] (12) NULL ,
	[dscd] [varchar] (8) NULL ,
	[wght] [float] NULL ,
	[obtp] [varchar] (25) NULL ,
	[cogr] [varchar] (6) NOT NULL ,
	[mobl] [bit] NOT NULL ,
	[indt] [datetime] NULL ,
	[emno] [char] (6) NULL ,
	[cndt] [datetime] NULL ,
	[coun] [float] NULL ,
	[cmea] [char] (6) NULL ,
	[cusc] [char] (3) NULL ,
	[incc] [bit] NOT NULL ,
	[mcno] [char] (6) NULL ,
	[loci] [varchar] (30) NULL ,
	[cdel] [char] (9) NULL ,
	[ccnt] [char] (9) NULL ,
	[dldt] [datetime] NULL ,
	[otbp] [char] (9) NULL ,
	[prip] [float] NULL ,
	[cwte] [char] (16) NULL ,
	[term] [numeric](18, 0) NULL ,
	[manu] [varchar] (25) NULL ,
	[cmnf] [char] (6) NULL ,
	[yrcn] [numeric](18, 0) NULL ,
	[mthc] [numeric](18, 0) NULL ,
	[cser] [char] (20) NULL ,
	[tdsc] [varchar] (20) NULL ,
	[idsc] [varchar] (20) NULL ,
	[item] [char] (47) NULL ,
	[revi] [char] (6) NULL ,
	[cpro] [char] (9) NULL ,
	[cspa] [char] (8) NULL ,
	[ttyp] [char] (47) NULL ,
	[tnum] [numeric](18, 0) NULL ,
	[prio] [numeric](18, 0) NULL ,
	[ccal] [char] (9) NULL ,
	[srno] [char] (9) NULL ,
	[spno] [numeric](18, 0) NULL ,
	[prno] [char] (9) NULL ,
	[ppno] [numeric](18, 0) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tscfg220] (
	[ccfg] [char] (8) NOT NULL ,
	[dsca] [varchar] (50) NOT NULL ,
	[sear] [varchar] (16) NULL ,
	[msdt] [datetime] NULL ,
	[medt] [datetime] NULL ,
	[cwoc] [char] (6) NOT NULL ,
	[csar] [char] (3) NULL ,
	[tecr] [char] (6) NULL ,
	[teca] [char] (6) NULL ,
	[tecb] [char] (6) NULL ,
	[cusc] [char] (3) NULL ,
	[cwte] [char] (16) NULL ,
	[ownr] [varchar] (25) NULL ,
	[ofbp] [char] (9) NULL ,
	[ccnt] [char] (9) NULL ,
	[cadr] [char] (9) NULL ,
	[ccor] [char] (9) NULL ,
	[czon] [char] (3) NULL ,
	[dist] [float] NULL ,
	[trti] [float] NULL ,
	[oplan] [varchar] (30) NULL ,
	[ccha] [float] NULL ,
	[ccur] [char] (3) NULL ,
	[wsts] [varchar] (80) NULL ,
	[mdnr] [char] (20) NULL ,
	[cpwc] [char] (6) NULL ,
	[ccal] [char] (9) NULL ,
	[prio] [numeric](18, 0) NULL ,
	[page] [varchar] (5) NULL ,
	[clrt] [char] (3) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tsclm020] (
	[crtc] [char] (3) NOT NULL ,
	[dsca] [varchar] (30) NULL ,
	[ccal] [char] (9) NULL ,
	[rctt] [float] NULL ,
	[enst] [float] NULL ,
	[sltn] [float] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tsclm024] (
	[sltt] [float] NOT NULL ,
	[dsca] [varchar] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tscompany] (
	[comp] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tsmdm030] (
	[cstp] [char] (3) NOT NULL ,
	[dsca] [varchar] (30) NOT NULL ,
	[prod] [char] (50) NULL ,
	[ract] [char] (6) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tsmdm100] (
	[cwoc] [char] (6) NOT NULL ,
	[dsca] [varchar] (31) NULL ,
	[wctp] [int] NULL ,
	[cmwc] [char] (6) NULL ,
	[cwar] [char] (6) NULL ,
	[clrt] [char] (3) NULL ,
	[srtp] [char] (20) NULL ,
	[grcq] [char] (3) NULL ,
	[srep] [char] (6) NULL ,
	[sncq] [char] (8) NULL ,
	[grsc] [char] (3) NULL ,
	[snsc] [char] (8) NULL ,
	[grsq] [char] (3) NULL ,
	[snsq] [char] (8) NULL ,
	[grso] [char] (3) NULL ,
	[snso] [char] (8) NULL ,
	[grca] [char] (3) NULL ,
	[snca] [char] (8) NULL ,
	[grfc] [char] (3) NULL ,
	[snfc] [char] (8) NULL ,
	[cvat] [char] (9) NULL ,
	[host] [char] (25) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tsmdm105] (
	[csar] [char] (3) NOT NULL ,
	[dsca] [varchar] (30) NOT NULL ,
	[artp] [int] NULL ,
	[cmsa] [char] (3) NULL ,
	[cwoc] [char] (6) NULL ,
	[cwar] [char] (6) NULL ,
	[trti] [float] NULL ,
	[dist] [float] NULL ,
	[ccha] [float] NULL ,
	[ccur] [char] (3) NULL ,
	[clrt] [char] (3) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tsmdm130] (
	[skll] [char] (4) NOT NULL ,
	[dsca] [varchar] (30) NULL ,
	[clrt] [char] (3) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tsmdm135] (
	[emno] [char] (6) NOT NULL ,
	[skll] [char] (4) NOT NULL ,
	[cogr] [char] (6) NOT NULL ,
	[afct] [float] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tsmdm140] (
	[emno] [char] (6) NOT NULL ,
	[dsca] [varchar] (36) NULL ,
	[frmn] [char] (6) NULL ,
	[csar] [char] (3) NULL ,
	[ccar] [char] (10) NULL ,
	[ouser] [char] (12) NULL ,
	[mpod] [float] NULL ,
	[cwoc] [char] (6) NULL ,
	[ccal] [char] (9) NULL ,
	[cadr] [char] (9) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tssoc200] (
	[orno] [char] (9) NOT NULL ,
	[ccfg] [char] (8) NULL ,
	[lcad] [char] (9) NULL ,
	[cprj] [char] (9) NULL ,
	[ordt] [datetime] NULL ,
	[osta] [int] NULL ,
	[cwoc] [char] (6) NULL ,
	[csar] [char] (3) NULL ,
	[emno] [char] (6) NULL ,
	[ccar] [char] (10) NULL ,
	[blyn] [bit] NOT NULL ,
	[ityn] [bit] NOT NULL ,
	[crit] [char] (6) NULL ,
	[ordu] [float] NULL ,
	[tvdu] [float] NULL ,
	[pstm] [datetime] NULL ,
	[pftm] [datetime] NULL ,
	[estm] [datetime] NULL ,
	[lftm] [datetime] NULL ,
	[otim] [bit] NOT NULL ,
	[appo] [bit] NOT NULL ,
	[rsrp] [bit] NOT NULL ,
	[tstm] [datetime] NULL ,
	[astm] [datetime] NULL ,
	[aftm] [datetime] NULL ,
	[cosh] [char] (9) NULL ,
	[crep] [char] (6) NULL ,
	[cbrn] [char] (6) NULL ,
	[cplt] [char] (3) NULL ,
	[cpay] [char] (3) NULL ,
	[ccrs] [char] (3) NULL ,
	[ccur] [char] (3) NULL ,
	[rats] [char] (10) NULL ,
	[ratf] [numeric](18, 0) NULL ,
	[rtdt] [datetime] NULL ,
	[rtyp] [char] (3) NULL ,
	[fcrt] [char] (20) NULL ,
	[ccty] [char] (3) NULL ,
	[txyn] [bit] NOT NULL ,
	[cvat] [char] (9) NULL ,
	[csco] [char] (9) NULL ,
	[csqu] [char] (9) NULL ,
	[ofbp] [char] (9) NULL ,
	[tinv] [bit] NOT NULL ,
	[ofad] [char] (9) NULL ,
	[ofcn] [char] (9) NULL ,
	[refa] [varchar] (30) NULL ,
	[refb] [varchar] (20) NULL ,
	[itbp] [char] (9) NULL ,
	[itad] [char] (9) NULL ,
	[itcn] [char] (9) NULL ,
	[pfbp] [char] (9) NULL ,
	[pfad] [char] (9) NULL ,
	[pfcn] [char] (9) NULL ,
	[stbp] [char] (9) NULL ,
	[stad] [char] (9) NULL ,
	[stcn] [char] (9) NULL ,
	[cdis] [char] (6) NULL ,
	[cadt] [datetime] NULL ,
	[lutd] [datetime] NULL ,
	[emer] [bit] NOT NULL ,
	[minu] [numeric](18, 0) NULL ,
	[ract] [datetime] NULL ,
	[orrt] [datetime] NULL ,
	[stna] [char] (35) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tssoc205] (
	[orno] [char] (9) NOT NULL ,
	[line] [int] NOT NULL ,
	[emno] [char] (6) NULL ,
	[acln] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tssoc210] (
	[orno] [char] (9) NOT NULL ,
	[acln] [int] NOT NULL ,
	[crac] [char] (8) NULL ,
	[dsca] [varchar] (30) NULL ,
	[cstp] [char] (3) NOT NULL ,
	[sear] [varchar] (16) NULL ,
	[cagr] [char] (3) NULL ,
	[ccfg] [char] (8) NULL ,
	[crob] [char] (50) NULL ,
	[oseq] [int] NULL ,
	[cmdl] [char] (47) NULL ,
	[orac] [char] (8) NULL ,
	[oras] [numeric](18, 0) NULL ,
	[ccll] [char] (9) NULL ,
	[cvat] [char] (9) NULL ,
	[fcon] [char] (9) NULL ,
	[cvtm] [datetime] NULL ,
	[crtc] [char] (3) NULL ,
	[prpr] [numeric](18, 0) NULL ,
	[cupr] [numeric](18, 0) NULL ,
	[obpr] [numeric](18, 0) NULL ,
	[cprl] [char] (10) NULL ,
	[cstn] [char] (10) NULL ,
	[chme] [varchar] (13) NULL ,
	[croo] [char] (50) NULL ,
	[osqo] [numeric](18, 0) NULL ,
	[cron] [char] (50) NULL ,
	[osqn] [numeric](18, 0) NULL ,
	[asta] [int] NULL ,
	[skla] [char] (4) NULL ,
	[sklb] [char] (4) NULL ,
	[sklc] [char] (4) NULL ,
	[bfbp] [char] (9) NULL ,
	[sbit] [char] (47) NULL ,
	[cmea] [char] (6) NULL ,
	[cskt] [char] (6) NULL ,
	[cchl] [numeric](18, 0) NULL ,
	[nivl] [float] NULL ,
	[pdvl] [float] NULL ,
	[aivl] [float] NULL ,
	[advl] [float] NULL ,
	[come] [char] (6) NULL ,
	[cova] [float] NULL ,
	[dbfc] [float] NULL ,
	[acdu] [float] NULL ,
	[appo] [bit] NOT NULL ,
	[pstm] [datetime] NOT NULL ,
	[pftm] [datetime] NOT NULL ,
	[estm] [datetime] NULL ,
	[lftm] [datetime] NULL ,
	[astm] [datetime] NULL ,
	[aftm] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tsspc200] (
	[ccfg] [char] (8) NOT NULL ,
	[crac] [char] (8) NOT NULL ,
	[aseq] [int] NOT NULL ,
	[dsca] [varchar] (30) NOT NULL ,
	[sear] [varchar] (16) NULL ,
	[cagr] [char] (3) NULL ,
	[cstp] [char] (3) NOT NULL ,
	[cwoc] [char] (6) NOT NULL ,
	[cchl] [numeric](18, 0) NULL ,
	[crob] [char] (50) NULL ,
	[oseq] [int] NULL ,
	[esct] [datetime] NULL ,
	[psct] [datetime] NOT NULL ,
	[pfct] [datetime] NOT NULL ,
	[lfct] [datetime] NULL ,
	[cmea] [char] (6) NULL ,
	[pivl] [float] NULL ,
	[pdvl] [float] NULL ,
	[adur] [float] NULL ,
	[trtm] [float] NULL ,
	[skla] [char] (4) NULL ,
	[sklb] [char] (4) NULL ,
	[sklc] [char] (4) NULL ,
	[dbfc] [float] NULL ,
	[appo] [bit] NOT NULL ,
	[stat] [int] NULL ,
	[otbp] [char] (9) NULL ,
	[item] [char] (47) NULL ,
	[chme] [varchar] (13) NULL ,
	[croo] [char] (50) NULL ,
	[osqo] [numeric](18, 0) NULL ,
	[cron] [char] (50) NULL ,
	[osqn] [numeric](18, 0) NULL ,
	[orno] [char] (9) NULL ,
	[acln] [numeric](18, 0) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tstables] (
	[tablename] [char] (8) NOT NULL ,
	[in_use] [int] NOT NULL ,
	[freq] [int] NULL ,
	[reqd] [bit] NOT NULL ,
	[lutm] [datetime] NULL ,
	[syme] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[FilterConditions] WITH NOCHECK ADD 
	CONSTRAINT [PK_FilterConditions] PRIMARY KEY  NONCLUSTERED 
	(
		[cflt],
		[seqn]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Filters] WITH NOCHECK ADD 
	CONSTRAINT [PK_Filters] PRIMARY KEY  NONCLUSTERED 
	(
		[cflt]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tcccp001] WITH NOCHECK ADD 
	CONSTRAINT [PK_tcccp001] PRIMARY KEY  NONCLUSTERED 
	(
		[ract]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tcccp030] WITH NOCHECK ADD 
	CONSTRAINT [PK_tcccp030] PRIMARY KEY  NONCLUSTERED 
	(
		[ccal],
		[ract],
		[stdt],
		[sttm]
	)  ON [PRIMARY] ,
	CONSTRAINT [IX_tcccp030] UNIQUE  NONCLUSTERED 
	(
		[ccal],
		[ract],
		[ustm]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tccom130] WITH NOCHECK ADD 
	CONSTRAINT [PK_tccom130] PRIMARY KEY  NONCLUSTERED 
	(
		[cadr]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tsbss001] WITH NOCHECK ADD 
	CONSTRAINT [DF_tsbss001_uset] DEFAULT (0) FOR [uset],
	CONSTRAINT [DF_tsbss001_aurf] DEFAULT (0) FOR [aurf],
	CONSTRAINT [DF_tsbss001_uset1] DEFAULT (0) FOR [sayn],
	CONSTRAINT [PK_tsbss001] PRIMARY KEY  NONCLUSTERED 
	(
		[seco]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tsbss002] WITH NOCHECK ADD 
	CONSTRAINT [DF_tsbss002_vfro] DEFAULT (0) FOR [vfro],
	CONSTRAINT [DF_tsbss002_vplo] DEFAULT (0) FOR [vplo],
	CONSTRAINT [DF_tsbss002_vrlo] DEFAULT (0) FOR [vrlo],
	CONSTRAINT [DF_tsbss002_vcmo] DEFAULT (0) FOR [vcmo],
	CONSTRAINT [DF_tsbss002_vcoo] DEFAULT (0) FOR [vcoo],
	CONSTRAINT [DF_tsbss002_vcao] DEFAULT (0) FOR [vcao],
	CONSTRAINT [DF_tsbss002_vclo] DEFAULT (0) FOR [vclo],
	CONSTRAINT [DF_tsbss002_flyn] DEFAULT (0) FOR [flyn],
	CONSTRAINT [PK_tsbss002] PRIMARY KEY  NONCLUSTERED 
	(
		[seco]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tsbss003] WITH NOCHECK ADD 
	CONSTRAINT [DF_tsbss003_vfrp] DEFAULT (0) FOR [vfrp],
	CONSTRAINT [DF_tsbss003_vrlp] DEFAULT (0) FOR [vrlp],
	CONSTRAINT [DF_tsbss003_vfip] DEFAULT (0) FOR [vfip],
	CONSTRAINT [DF_tsbss003_vtrp] DEFAULT (0) FOR [vtrp],
	CONSTRAINT [DF_tsbss003_vcmp] DEFAULT (0) FOR [vcmp],
	CONSTRAINT [PK_tsbss003] PRIMARY KEY  NONCLUSTERED 
	(
		[seco]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tscfg200] WITH NOCHECK ADD 
	CONSTRAINT [DF_tscfg200_mobl] DEFAULT (0) FOR [mobl],
	CONSTRAINT [DF_tscfg200_incc] DEFAULT (0) FOR [incc],
	CONSTRAINT [PK_tscfg200] PRIMARY KEY  NONCLUSTERED 
	(
		[ccfg],
		[crob],
		[oseq]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tscfg220] WITH NOCHECK ADD 
	CONSTRAINT [PK_tscfg220] PRIMARY KEY  NONCLUSTERED 
	(
		[ccfg]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tsclm020] WITH NOCHECK ADD 
	CONSTRAINT [PK_tsclm020] PRIMARY KEY  NONCLUSTERED 
	(
		[crtc]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tsclm024] WITH NOCHECK ADD 
	CONSTRAINT [PK_tsclm024] PRIMARY KEY  NONCLUSTERED 
	(
		[sltt]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tscompany] WITH NOCHECK ADD 
	CONSTRAINT [PK_tscompany] PRIMARY KEY  NONCLUSTERED 
	(
		[comp]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tsmdm030] WITH NOCHECK ADD 
	CONSTRAINT [PK_tsmdm030] PRIMARY KEY  NONCLUSTERED 
	(
		[cstp]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tsmdm100] WITH NOCHECK ADD 
	CONSTRAINT [PK_tsmdm100] PRIMARY KEY  NONCLUSTERED 
	(
		[cwoc]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tsmdm105] WITH NOCHECK ADD 
	CONSTRAINT [PK_tsmdm105] PRIMARY KEY  NONCLUSTERED 
	(
		[csar]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tsmdm130] WITH NOCHECK ADD 
	CONSTRAINT [PK_tsmdm130] PRIMARY KEY  NONCLUSTERED 
	(
		[skll]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tsmdm135] WITH NOCHECK ADD 
	CONSTRAINT [PK_tsmdm135] PRIMARY KEY  NONCLUSTERED 
	(
		[emno],
		[skll],
		[cogr]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tsmdm140] WITH NOCHECK ADD 
	CONSTRAINT [PK_tsmdm140] PRIMARY KEY  NONCLUSTERED 
	(
		[emno]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tssoc200] WITH NOCHECK ADD 
	CONSTRAINT [DF_tssoc200_blyn] DEFAULT (0) FOR [blyn],
	CONSTRAINT [DF_tssoc200_ityn] DEFAULT (0) FOR [ityn],
	CONSTRAINT [DF_tssoc200_otim] DEFAULT (0) FOR [otim],
	CONSTRAINT [DF_tssoc200_appo] DEFAULT (0) FOR [appo],
	CONSTRAINT [DF_tssoc200_rsrp] DEFAULT (0) FOR [rsrp],
	CONSTRAINT [DF_tssoc200_txyn] DEFAULT (0) FOR [txyn],
	CONSTRAINT [DF_tssoc200_tinv] DEFAULT (0) FOR [tinv],
	CONSTRAINT [DF_tssoc200_emer] DEFAULT (0) FOR [emer],
	CONSTRAINT [PK_tssoc200] PRIMARY KEY  NONCLUSTERED 
	(
		[orno]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tssoc205] WITH NOCHECK ADD 
	CONSTRAINT [PK_tssoc205] PRIMARY KEY  NONCLUSTERED 
	(
		[orno],
		[line]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tssoc210] WITH NOCHECK ADD 
	CONSTRAINT [DF_tssoc210_appo] DEFAULT (0) FOR [appo],
	CONSTRAINT [PK_tssoc210] PRIMARY KEY  NONCLUSTERED 
	(
		[orno],
		[acln]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tsspc200] WITH NOCHECK ADD 
	CONSTRAINT [PK_tsspc200] PRIMARY KEY  NONCLUSTERED 
	(
		[ccfg],
		[crac],
		[aseq]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[tstables] WITH NOCHECK ADD 
	CONSTRAINT [DF_tstables_syme] DEFAULT (1) FOR [syme],
	CONSTRAINT [PK_tstables] PRIMARY KEY  NONCLUSTERED 
	(
		[tablename]
	)  ON [PRIMARY] 
GO

CREATE  INDEX [IX_tssoc200] ON [dbo].[tssoc200]([pstm]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_tssoc210] ON [dbo].[tssoc210]([crob], [oseq], [pstm]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_tsspc200] ON [dbo].[tsspc200]([ccfg], [psct]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_tsspc200_1] ON [dbo].[tsspc200]([crob], [oseq], [psct]) ON [PRIMARY]
GO

