JC_Constant, SY_TableConversionCommon

Module Code

Converts the Legacy JC0 file to the JC_CostType table

Converts the Legacy JC0 file to the JC_Options table

Converts the Legacy JC1 file to the JC_Job table

Converts the Legacy JC2 file to the JC_JobCostCode table

Converts the Legacy JC2 file to the JC_JobCostCodeDetail table

Converts the Legacy JC3 file to the JC_JobBillingHistory table

Converts the Legacy JC3 file to the JC_JobCostCodeHistory table

Converts the Legacy JC3 file to the JC_JobTransactionDetail table

Converts the Legacy JC8 file to the JC_JobDailyTransactions table

Converts the Legacy JC9 file to the JC_OverheadAllocation table

Converts the Legacy JCA file to the JC_JobType table

Converts the Legacy JCB file to the JC_BurdenRate table

Converts the Legacy JCB file to the JC_OverheadRate table

Convert the Legacy JCC file to the JC_CostCode table

Converts the Legacy JCC file to the JC_CostCodeDetail table

Converts the Legacy JCG file to the JC_JobEstimate table

Converts the Legacy JCI file to the JC_JobEstimateDetail table

Converts the Legacy JCJ file to the JC_JobEstimateItemPrice table

Converts the Legacy JCJ file to the JC_JobEstimateItmAssyPrice table

Converts the Legacy JCK file to the JC_UnitOfMeasure table

Converts the Legacy JCM file to the JC_JobEstimateDetailAssy table

Converts the Legacy JCP file to the JC_JobEstimateMemo table

Converts the Legacy JCP file to the JC_JobHistoryMemo table

Converts the Legacy JCP file to the JC_JobMemo table

Converts the Legacy JC_01 file to the JC_JobBillingTaxDetail table

Converts the Legacy JC_02 file to the JC_JobBillingTaxSummary table

Converts the Legacy JC_03 file to the JC_CostRetentionDetail table

Converts the Legacy JC_05 file to the JC_JobStatusControl table

Converts the Legacy JC_H1 file to the JC_JobHistory table

Converts the Legacy JC_H2 file to the JC_JobHistoryCostCode table

Converts the Legacy JC_H2 file to the JC_JobHistoryCostCodeDtl table

Converts the Legacy JC_H3 file to the JC_JobBillingHistory table

Converts the Legacy JC_H3 file to the JC_JobCostCodeHistory table

Converts the Legacy JC_H3 file to the JC_JobHistoryTransDetail table

Runs the Legacy to Framework data conversion for the Job Cost 2.0 module

postingTypeDIRECTCOST$, postingTypeBILLING$, postingTypeCASHRECEIPT$, lineTypeCOSTCODE$, lineTypeCHARGE$, lineTypeCOMMENT$, jobCERTIFIEDPAYROLLFORMS$, jobTranTypeCHANGEORDER$, jobTranTypeBILL$, jobTranTypeCOST$, jobDetailTypeCHANGEORDER$, jobDetailTypeCOST$, jobDetailTypeINVOICE$, jobDetailTypePAYMENT$, jobAcctMethodCOMPLETED$, jobAcctMethodPERCENTAGE$, recognizeWIPMethodACTUALCOST$, recognizeWIPMethodESTIMATEPERCENT$, jobStatusBID$, jobStatusOPEN$, jobStatusCOMPLETE$, jobStatusLATE$, jobStatusHOLD$, jobStatusCLOSED$, cAllJobStatusCodes$, cAllJobStatusDesc$, costTypeBURDEN$, costTypeEQUIPMENT$, costTypeLABOR$, costTypeMATERIAL$, costTypeOVERHEAD$, costTypeSUBCONTRACT$, cStandardCostTypes$, cStandardCostTypesDesc$, costCodeStatusALL$, costCodeStatusORIGINAL$, costCodeStatusREVISED$, costCodeStatusNONE$, billMethodNONBILLABLE$, billMethodFIXED$, billMethodTIMEMATERIAL$, billMethodDescNONBILLABLE$, billMethodDescFIXED$, billMethodDescTIMEMATERIAL$, pricingMethodNONBILLABLE$, pricingMethodUNITPRICE$, pricingMethodPERCENTCOSTMARKUP$, overheadBasisDAILY$, overheadBasisMONTHLY$, overheadBasisNONE$, estItemITEM$, estItemASSEMBLY$, estLineREGULAR$, estLineMISC$, estLineCOMMENT$, estLineSUBTOTAL$, estLineTOTAL$, estLineValueMISC$, estLineValueCOMMENT$, estLineValueSUBTOTAL$, estLineValueTOTAL$, estMarkupPERCENT$, estMarkupAMOUNT$, estMarkupOVERRIDE$

cHistoryIol$, LogObj

CalculateJobTotals(), CalculateUnitPrice()

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