Class SO_TableConversion0500

Inherits

SY_TableConversionCommon

Properties

No Properties

Methods

FUNCTION SO_CancelReasonCode_000_06_00_00_00()  

Conversion logic for version 6.0.0.0 to add new cancel/reason code "RESWH"

Returns [boolean]
ValueDescription
retFAILURE (0) - record was not created
retSUCCESS (1) - record was created without incident (if needed)
FUNCTION SO_CheckNumberExpansion_000_05_30_00_00()  

Conversion logic for version 5.3.0.0 to increase zero fill of CheckNoForDeposit in SO_SalesOrderHeader and SO_InvoiceHeader

Returns [boolean]
ValueDescription
retFAILURE (0) - an error was encountered
retSUCCESS (1) - records were updated without incident (if needed)
FUNCTION SO_ExtendedDescDefault_000_06_10_03_00()  

Conversion logic to set blank Extended description keys to the default of all zeroes for Sales Order Detail, SO Invoice Detail and Sales Order History Detail tables for versions prior to 6.10.3.0

Returns [boolean]
ValueDescription
retFAILURE (0) - records were not updated
retSUCCESS (1) - records were updated without incident (if needed)
FUNCTION SO_InvoiceMultiSO_000_06_00_03_00()  

Conversion logic for version 6.0.3.0 to populate new fields and table for multiple sales orders on 1 invoice

Returns [boolean]
ValueDescription
retFAILURE (0) - an error was encountered
retSUCCESS (1) - records were updated without incident (if needed)
FUNCTION SO_InvoiceTierDistribution_000_05_00_02_00()  

Conversion logic for version 5.0.2.0 to populate null fields in SO_InvoiceTierDistribution.

Returns [boolean]
ValueDescription
retFAILURE (0) - an error was encountered
retSUCCESS (1) - records were updated without incident (if needed)
FUNCTION SO_Options_000_06_20_00_00()  

Function to set AESDataEncryptionTest column value

Returns [boolean]
ValueDescription
retFAILURE (0) - an error was encountered
retSUCCESS (1) - The table conversion successfully completed.
FUNCTION SO_PayBalance_000_06_10_00_00()  

Conversion logic for version 6.1.0.0 to assign value in PayBalance in SO_SalesOrderHeader and SO_InvoiceHeader

Returns [boolean]
ValueDescription
retFAILURE (0) - records were not updated
retSUCCESS (1) - records were updated without incident (if needed)
FUNCTION SO_SalesOrderHistoryHeader_000_06_00_02_00()  

Conversion logic for version 6.0.2.0 to populate InvoicedAmt in SO_SalesOrderHistoryHeader

Returns [boolean]
ValueDescription
retFAILURE (0) - records were not updated
retSUCCESS (1) - records were updated without incident (if needed)

Properties inherited from: SY_TableConversionCommon

cHistoryIol$, LogObj

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