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

• SCOAFile
• AccountNumber
• AccountNumberPrefix
• ShortCode
• SCOAAccount
• ShortDesc0
• ShortDesc1
• ShortDesc2
• ShortDesc3 
• ShortDesc4
• ShortDescription
  • These columns increases the sql speed of reports and MPBM

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

MPBM changes

Arrears changes

Contract and retention changes

Performance and management changes

SCOA changes

_as_MPBM_V_A1ScheduleMapping