MPBM version 2.1.XX

Data structure changes

_as_MPBM_accountExtension

iUDF column is added to the table
- Based on the provided mapping from NT the IUDF is looked up in the scoa view : _as_MPBM_V_A1ScheduleMapping
Mtsf column is added to the table
- Based on the provided mapping from NT the Mstsf is looked up in the scoa view : _as_MPBM_V_A1ScheduleMapping

_as_MPBM_accountExtensionAllversions

Accounttype colum is added to the table
- This column will increase the speed of all the reports/extracts and MPBM
ucBSACOSAItemCombi column is added to the table
- This column will increase the speed of all the reports/extracts and MPBM
ucOSAFunctionCombi column is added to the table
- This column will increase the speed of all the reports/extracts and MPBM

_as_MPBM_SegmentModelAllVersions

Report changes

_asf_GetBalancesAllaccounts.sql
- The script is updated for 6.3
- Performance is improved
_ASf_GLBalancesPerAccount.sql
- The script is updated for 6.3
- Performance is improved
_as_sp_UpdateAccountType.sql
- The script is updated for 6.3
- Performance is improved
- The following types are added:
  - 3100 - Property Rates by Usage [Revenue - Non-exchange Revenue]
  - 3200 - Service Charges [Revenue - Non-exchange Revenue]
Reporting - Create static tables.sql
_as_SP_SetSCOAActiveTable.sql
_as_MPBM_AccountExtensionAllVersionExtended.sql
_as_GLAccountsFullMPBM.sql
Sagebudget.SQl
_as_MPBM_Virements.SQL
DataExtract Commitment.sql
mSCOA DataExtract Budget.sql
mSCOA BS .sql
mSCOA OSB.sql
Data extract - Actuals Movement only.sql
mSCOA BSAC.sql
mSCOA OSA.sql
Data extract - Actuals .sql
IDP extract.sql
_AS_MPBM_RME.sql
_asf_GetAgeingTransactions.sql
mSCOA Ageing SP.sql