Class SY_TableConversion0500

Properties

No Properties

Methods

FUNCTION ALERemoval_000_05_00_00_00()  
FUNCTION ALERemoval_000_05_00_07_00()  
FUNCTION ALERemoval_000_05_10_03_00()  
FUNCTION ALERemoval_000_05_10_06_00()  
FUNCTION ALERemoval_000_05_20_00_00()  
FUNCTION ALERemoval_000_05_20_02_00()  
FUNCTION ALERemoval_000_05_30_00_00()  
FUNCTION ALERemoval_000_05_40_01_00()  
FUNCTION ALERemoval_000_06_20_00_00()  
FUNCTION PaperlessOffice_000_06_00_01_00()  

Convert J/C & P/R records in paperless office tables after migrating from a prior level to 2018

Returns [boolean] Success
FUNCTION PL_EmailMessage_000_06_10_00_00()  

Convert PL_EmailMessage to 2019

Returns [boolean] Success
FUNCTION RemoveFLLegacyRecords_000_05_30_01_00()  

Remove legacy dictionary and system records for the new, Framework Fixed Assets module.

Returns [boolean] Always returns success.
FUNCTION RemoveJCLegacyRecords_000_05_50_00_00()  

Remove legacy records for job cost which as of version 2018 is a framework module.

FUNCTION RemoveObsoleteRecords_000_06_00_00_00()  

Remove misc records after migrating from a prior level to 2018

FUNCTION RemovePRLegacyRecords_000_05_50_00_00()  

Remove legacy records for payroll which as of version 2018 is a framework module.

FUNCTION RemoveTCLegacyRecords_000_06_00_00_00()  

Remove legacy records for time card which is not available as a legacy module in version 2018.

FUNCTION SY_Company_000_05_00_00_00()  
FUNCTION SY_COUNTRY_000_05_20_00_00()  

If CU_Country records exists, merge them into SY_Country and delete CU_Country CU Country is deprecated as of Sage 100 2015 (Version 5.20)

Returns [boolean] Success or Failure.
FUNCTION SY_ExportLink_000_05_30_00_00()  

Remove unneeded record from SY_ExportLink

Returns [boolean] Success
FUNCTION SY_ExportLink_000_06_00_01_00()  

Remove unneeded records from SY_ExportLink in 6.00.01

Returns [boolean] Success
FUNCTION SY_Metering_000_05_30_02_00()  

Convert SY_Metering to 2016 PU2 Schema

FUNCTION SY_RoleSecurity_000_05_20_00_00()  

Create SY_RoleSecurity records for each role and new Sage 100 2015 tasks.

Returns [boolean] Success or Failure.
FUNCTION SY_TaskSchedulerHeader_000_06_10_00_00()  

Convert Task Scheduler Header records

Returns [boolean] Success or Failure.
FUNCTION SY_Token_000_06_10_00_00()  

Convert SY_Token to 2019

Returns [boolean] Success
FUNCTION SY_URLMaintenance_000_05_20_02_00()  

Change URL Description for SAGEPAY payroll service.

Returns [boolean] Success or Failure.
FUNCTION SY_URLMaintenance_000_06_10_00_00()  

Change URL USe Proxy Server setting for Sage default URLs.

Returns [boolean] Success or Failure.
FUNCTION SY_UserAutoComplete_000_05_10_00_00()  

Create SY_UserAUtoComplete records for each user..

Returns [boolean] Success or Failure.

Properties inherited from: SY_Password

AESCipher$, AES256Cipher$

Properties inherited from: SY_TableConversionCommon

cHistoryIol$, LogObj

Methods inherited from: SY_Password

ConfirmAESKey(), ConfirmPassword(), EncryptAESData(), EncryptAESKey(), EncryptAESPassword(), EncryptPassword(), GetAESDataTest$(), PasswordAcceptable(), ValidateAESData(), ValidateAESPassword(), ValidatePassword(), VerifyAESDataEncryption(), DecryptAESData(), DecryptAESKey(), DecryptAESPassword(), DecryptAltAESData(), DecryptPassword(), EncryptAltAESData(), GetKEK$(), InitAESKey(), InitializeAES(), InitializeAltAES(), ValidateAltAESData(), VerifyAltAESDataEncryption()

Methods inherited from: SY_TableConversionCommon

ClearHistoryRecordsToUpdate(), CloseTableCopy(), ConvertRecord(), ConvertTable(), CreateTable(), CreateTableNewCopy(), DropTable(), GetHistoryRecordsToUpdate$(), OpenTable(), OpenTableCopy(), RemoveData(), RemoveDctDefinitions(), RemoveLegacyFileDefinitions(), RemoveRecord(), RemoveRecordTask(), Rename(), RenameColumn(), SetDefaults(), TableConversionEncryptTable(), TableConvertRenameColumns(), TableExists(), UpdateCopyProgress(), PERFORM AddUDFToDictionary(), ClearGridARecords(), CopyTableName$(), CopyUDFsToMirrorTable(), DeleteTask(), DictionaryValidation(), EncryptRec(), GetColumnRecords(), InitCustomizer(), ResolveColumnTag(), ResolveValueToken$(), SetCreatedUpdatedColumns(), UpdateProgressBar(), WriteToLog()