Class JC_TableConversion0500

Properties

No Properties

Methods

FUNCTION AP_OpenInvoiceByJobReport_000_06_10_03_00()  

Conversion logic for version 6.1.0.3 to convert AP Open Invoice By Job Report cost type selections

Returns [boolean]
ValueDescription
retSUCCESS (1) - The table conversion successfully completed.
FUNCTION AP_OpenInvoiceByJobReport_000_06_20_00_00()  
FUNCTION JC3_000_05_00_00_00()  

Function to convert JC3 Data to version 5.0. Adj Comment to allow room for a 20 char Inv Num.

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

Function to convert JC8 Data to version 5.0. Adj Comment to allow room for a 20 char Inv Num.

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

Function to convert internal builds and preview releases to the general release.

Returns [boolean]
ValueDescription
retSUCCESS (1) - The table conversion successfully completed.
FUNCTION JC_ConvertToFramework_000_05_50_00_00()  

Function to convert to Framework at version 5.50.

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

Function to convert JC_H3 Data to version 5.0. Adj Comment to allow room for a 20 char Inv Num.

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

Function to expand SeqNo

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

Function to convert packed sequence numbers to zero filled strings.

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

Function to correct job billing update errors.

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

Function to expand SeqNo

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

Function to set new AESDataEncryptionTest column value

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

Function to manually drop / re-init JC_UnbilledJobBillingWork to account for possilbe orphaned records cureently in the table.

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