-- Таблица движений
CREATE TABLE _AccumReg3524(
	_Period datetime NOT NULL,
	_RecorderTRef binary( 4 ) NOT NULL,
	_RecorderRRef binary( 16 ) NOT NULL,
	_LineNo numeric( 9 ,  0 ) NOT NULL,
	_Active binary( 1 ) NOT NULL,
	_RecordKind numeric( 1 ,  0 ) NOT NULL,
	_Fld3525RRef binary( 16 ) NOT NULL,
	_Fld3526RRef binary( 16 ) NOT NULL,
	_Fld3527RRef binary( 16 ) NOT NULL,
	_Fld3528RRef binary( 16 ) NOT NULL,
	_Fld3529 numeric( 16 ,  2 ) NOT NULL,
	_Fld3530RRef binary( 16 ) NOT NULL,
	_Fld3531RRef binary( 16 ) NOT NULL,
	_Fld3532RRef binary( 16 ) NOT NULL
)

-- Таблица итогов
CREATE TABLE _AccumRegTotals3537(
	_Period datetime NOT NULL,
	_Fld3525RRef binary( 16 ) NOT NULL,
	_Fld3526RRef binary( 16 ) NOT NULL,
	_Fld3527RRef binary( 16 ) NOT NULL,
	_Fld3528RRef binary( 16 ) NOT NULL,
	_Fld3529 numeric( 22 ,  2 ) NOT NULL
)

-- Таблица движений
CREATE UNIQUE CLUSTERED INDEX _AccumR3524_ByPeriod_TRN ON _AccumReg3524 
	(_Period, _RecorderTRef, _RecorderRRef, _LineNo)

CREATE UNIQUE INDEX _AccumR3524_ByDims3533_RTRN ON _AccumReg3524 
	(_Fld3525RRef, _Period, _RecorderTRef, _RecorderRRef, _LineNo)

CREATE UNIQUE INDEX _AccumR3524_ByDims3534_RTRN ON _AccumReg3524 
	(_Fld3526RRef, _Period, _RecorderTRef, _RecorderRRef, _LineNo)

CREATE UNIQUE INDEX _AccumR3524_ByDims3535_RTRN ON _AccumReg3524 
	(_Fld3527RRef, _Period, _RecorderTRef, _RecorderRRef, _LineNo)

CREATE UNIQUE INDEX _AccumR3524_ByDims3536_RTRN ON _AccumReg3524 
	(_Fld3528RRef, _Period, _RecorderTRef, _RecorderRRef, _LineNo)

CREATE UNIQUE INDEX _AccumR3524_ByRecorder_RN ON _AccumReg3524 
	(_RecorderTRef, _RecorderRRef, _LineNo)

-- Таблица итогов
CREATE UNIQUE CLUSTERED INDEX _AccumR3537_ByDims_TRRRR ON _AccumRegTotals3537 
	(_Period, _Fld3525RRef, _Fld3526RRef, _Fld3527RRef, _Fld3528RRef)

CREATE INDEX _AccumR3537_ByDims3534_TR ON _AccumRegTotals3537 
	(_Period, _Fld3526RRef)

CREATE INDEX _AccumR3537_ByDims3535_TR ON _AccumRegTotals3537 
	(_Period, _Fld3527RRef)

CREATE INDEX _AccumR3537_ByDims3536_TR ON _AccumRegTotals3537 
	(_Period, _Fld3528RRef)

-- Таблица движений
CREATE CLUSTERED INDEX Period ON _AccumReg3524(_Period)
CREATE INDEX Fld3525 ON _AccumReg3524(_Fld3525RRef)
CREATE INDEX Fld3526 ON _AccumReg3524(_Fld3526RRef)
CREATE INDEX Fld3527 ON _AccumReg3524(_Fld3527RRef)
CREATE INDEX Fld3528 ON _AccumReg3524(_Fld3528RRef)
CREATE INDEX Recorder ON _AccumReg3524(_RecorderRRef)

-- Таблица итогов
CREATE CLUSTERED INDEX Period ON _AccumRegTotals3537(_Period)
CREATE INDEX Fld3526 ON _AccumRegTotals3537(_Fld3526RRef)
CREATE INDEX Fld3527 ON _AccumRegTotals3537(_Fld3527RRef)
CREATE INDEX Fld3528 ON _AccumRegTotals3537(_Fld3528RRef)