Data structure changes

_as_MPBM_accountExtension


_as_MPBM_accountExtensionAllversions


_as_MPBM_SegmentModelAllVersions



_AS_MPBM_ServiceMapping

Report changes

Sql's

To call the sp with full data:

EXEC 
		_AS_SP_DataExtract
			 @StartYear = 2018	
			,@PrintStartYear = 2019	
			,@DataType ='Original Budget'			---Select 'Draft' Union all Select 'Original' union all Select 'Adjusted' union all Select 'Actuals' union all Select 'Virements'
			,@IncludeVirements =0
			,@Actuals =0
			,@IncludeCommitments =0								
			,@ReportType = 'Full system' 			--Select 'Full data' Union all select 'Duplicate check' union all Select 'DataExtract'
			,@ScoaVersion = 'mSCOA_V6.2'
			,@IncludeData ='AA-AR-BB-BN-V-C-SB'



Reports

Trial balance pack

Report pack




MPBM changes

Arrears changes

Contract and retention changes

Performance and management changes

SCOA changes