Class SY_TableConversion0500

Build Information

Date 2011.08.25 35 at 12:17:24 PM PDT

Inherits

SY_Password, SY_TableConversionCommon

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 ALERemoval_000_07_00_00_00()  
FUNCTION ALERemoval_000_07_10_00_00()  
FUNCTION IP_RemoveSystemData_000_07_10_01_00()  

Remove I/P records if migrating from Scanco IRP to Sage IRP.

FUNCTION JT_RemoveSystemData_000_07_10_00_00()  

Remove J/T records if migrating from J/T to the new P/M module.

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 RemoveObsoleteRecords_000_07_10_00_00()  

Remove misc records after migrating from a prior level to 2022

FUNCTION RemoveObsoleteRecords_000_07_20_01_00()  

Remove obsolete system records after migrating from a prior level to 2023.1

FUNCTION RemoveObsoleteRecords_000_07_30_00_00()  

Remove obsolete system records after migrating from a prior level to 2024

FUNCTION RemoveObsoleteRecords_000_07_40_00_00()  

Remove obsolete system records after migrating from a prior level to 2025

FUNCTION RemoveOffice365_000_07_40_00_00()  

Remove Office 365 System Tables after migrating from a prior level to 2025

FUNCTION RemovePRLegacyRecords_000_05_50_00_00()  

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

FUNCTION RemoveSY_ResourceRoleSecurity_000_07_40_00_00()  

Remove SY_ResourceRolSecurity after migrating from a prior level to 2025

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_Context_000_07_30_00_00()  

Create context and data source records for new UDF data source SO_SalesOrderDetail_bus:CopyFromSalesOrder.

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_GridDefinition_000_07_00_00_00()  

Remove "SO_INVOICECMTIERDISTRIBUTION" grid definitions

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

Remove re-keyed records from SY_MessageLink.

FUNCTION SY_Metering_000_05_30_02_00()  

Convert SY_Metering to 2016 PU2 Schema

FUNCTION SY_ReportOption_000_06_20_02_00()  

Convert SY_ReportOption record for SY_RoleReport converting check box for include records with no access to a drop box

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

Convert SY_ReportOption records to correct field naming DB_PrintComment$ to DB_PrintComments$ in invoice printing tasks' records

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

Convert SY_ReportSetting records to set new column SaveDateSelections to correct default value. STANDARD setting default N as selections not retained. Other settings if date row exists in selections will be Y else N

Returns [boolean] Success or Failure.
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_RoleSecurity_000_07_00_00_00()  

Create SY_RoleSecurity records for tasks that previously were excluded from role maintenance.

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_Task_000_07_00_00_00()  

Add Security Option Group Other to security options and events tasks that were migrated

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.
FUNCTION WO_RemoveSystemData_000_07_10_00_00()  

Remove W/O records if migrating from W/O to the new P/M module.

Properties inherited from: SY_TableConversionCommon

cHistoryIol$, LogObj

Methods inherited from: SY_TableConversionCommon

ClearHistoryRecordsToUpdate(), CloseTableCopy(), ConvertRecord(), ConvertTable(), CreateTable(), CreateTableNewCopy(), DropTable(), GetHistoryRecordsToUpdate$(), IsSetup(), 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()