CI_CommonPII, CI_Constant, PM_Constant, SY_Common, SY_TableConversionCommon

[boolean] isTRUE if PM Conversion is successful

Destination Module Code

Source Module Code

Convert the JT_ActivityCode table to the PM_ActivityCode table.

Convert the JT_DailyPartsUsage table to the PM_DailyMaterialsUsage table.

Convert the JT_Department table to the PM_Department table.

Convert the JT_EarningsCode table to the PM_EarningsCode table.

Convert the JT_Employee table to the PM_Employee table.

Convert the JT_LaborCrewDetail table to the PM_LaborCrewDetail table.

Convert the JT_LaborCrewHeader table to the PM_LaborCrewHeader table.

Convert the JT_LaborEntry table to the PM_LaborEntry table.

Convert the JT_LaborHistory table to the PM_LaborHistory table.

Convert the JT_MiscellaneousCodes table to the PM_UserDefinedInfoSetup and PM_UserDefinedInfoCodes and PM_AttachmentCategory tables.

Convert the JT_Options table to the PM_Options table.

Convert the JT_StatusCode table to the PM_StatusCode table.

Convert the JT_TemplateAttachments table to the PM_TemplateAttachments table.

Convert the JT_TemplateMemoSettings table to the PM_TemplateMemoSettings table.

Convert the JT_TemplateMemo table to the PM_TemplateMemo table.

Convert the JT_TemplateParts table to the PM_TemplateMaterials table.

Convert the JT_Template table to the PM_Template table.

Convert the JT_TimeHistory table to the PM_TimeHistory table.

Convert the JT_ToolCode table to the PM_ToolCode table.

Convert the JT_TransactionHistory table to the PM_TransactionHistory table.

Convert the JT_TransactionLotSerialHistory table to the PM_TransactionLotSerialHistory table.

Convert the JT_UnitOfMeasure table to the PM_UnitOfMeasure table.

Convert the JT_WeeklyTimeEntry table to the PM_WeeklyTimeEntry table.

Convert the JT_WorkCenter table to the PM_WorkCenter table.

Convert the JT_WorkTicketAttachments table to the PM_WorkTicketAttachments table.

Convert the JT_WorkTicketClass table to the PM_WorkTicketClass table.

Convert the JT_WorkTicketDefaults table to the PM_WorkTicketDefaults table.

Convert the JT_WorkTicketDetail table to the PM_WorkTicketDetail table.

Convert the JT_WorkTicketHeader table to the PM_WorkTicketHeader table.

Convert the JT_WorkTicketHistoryDetail table to the PM_WorkTicketHistoryDetail table.

Convert the JT_WorkTicketHistoryHeader table to the PM_WorkTicketHistoryHeader table.

Convert the JT_WorkTicketHistoryStep table to the PM_WorkTicketHistoryStep table.

Convert the JT_WorkTicketLabelPrint table to the PM_WorkTicketLabelPrint table.

Convert the JT_WorkTicketMemoSettings table to the PM_WorkTicketStepMemoSettings table.

Convert the JT_WorkTicketMemo table to the PM_WorkTicketStepMemo table.

Convert the JT_WorkTicketPrint table to the PM_WorkTicketPrint table.

Convert the JT_WorkTicketStep table to the PM_WorkTicketStep table.

Convert the JT_WorkTicketStepWIP table to the PM_WorkTicketStepWIP table.

Convert the JT_WorkTicketTierDistribution table to the PM_WorkTicketTierDistribution table.

Convert the JT_WTDetailDynoInventoryHist table to the PM_DynamicMaterialsHistory table.

Run the data conversion for the PM module.

Update tables in other modules that contain JT data.

AllowSensitiveAccess

itmREGULAR$, itmSPECIAL$, itmCHARGE$, itmCOMMENT$, itmMISC$, valSTANDARD$, valAVERAGE$, valFIFO$, valLIFO$, valLOT$, valSERIAL$, typFINISHEDGOODS$, typRAWMATERIALS$, typDISCONTINUED$, typKIT$, proMAKE$, proBUY$, proSUBCONTRACT$, proMAKETOORDER$, proBUYTOORDER$, tierFIFO$, tierLIFO$, tierLOT$, tierSERIAL$, upceanTYPENONE$, upceanTYPEOTHER$

actClassEMPLOYEE$, actClassGENERAL$, actClassMACHINE$, actClassOUTSIDESVC$, capTimeNO$, capTimeNOEDIT$, capTimeYES$, earnTypeALLOCTIPS$, earnTypeEXCLUDETIPCALC$, earnTypeEXEMPTTIPS$, earnTypeFRINGE$, earnTypeMISC$, earnTypeOVERTIME$, earnTypeREGULAR$, earnTypeTAXABLETIPS$, earnTypeTIMEOFF1$, earnTypeTIMEOFF2$, earnTypeTIMEOFF3$, cAllEarningsTypes$, earnMethodADDAMOUNT$, earnMethodFIXED$, earnMethodSTANDARD$, cAllEarnMethods$, lttLABOR$, lttCREW$, lttMISC$, lttINOUT$, lttCOST$, dpcSTANDARD$, dpcAVERAGE$, dpcLAST$, overheadTypeAMOUNT$, overheadTypePERCENT$, prtPickNONE$, prtPickBYWHSE$, prtPickBYTICK$, tcmCodeACTUAL$, tcmCodeBUDGET$, tcmCodeSTANDARD$, tcmCodeLOWER$, tcmDescACTUAL$, tcmDescBUDGET$, tcmDescSTANDARD$, tcmDescLOWER$, trnLABOR$, trnMATERIALS$, trnCLOSE$, trnCOMPLETION$, trcSTATUS$, trcLABOR$, trcINVENTORY$, trcDIRECTCHARGE$, trcINVOICE$, trcCLOSE$, trcSCRAP$, udiSTRING$, udiNUMBER$, udiYESNO$, udiCODE$, udiDATE$, mftCodeSALESORDER$, mftCodeSALESORDERLINE$, mftCodeWORKTICKET$, mftCodeINVENTORY$, mftDescSALESORDER$, mftDescSALESORDERLINE$, mftDescWORKTICKET$, mftDescINVENTORY$, wtsOPEN$, wtsQUOTE$, wtsRELEASED$, wtsCLOSED$, wtsDELETED$, lbrIssMethodAUTOISSUE$, lbrIssMethodBACKFLUSH$, lbrIssMethodMANUAL$, matIssMethodAUTOISSUE$, matIssMethodBACKFLUSH$, matIssMethodMANUAL$, prtWORKTICKET$, prtOPERATIONTICKET$, prtCOMPLETEMISSINGCOST$, prtCOMPLETEVARFROMSTD$, prtCLOSEMISSINGCOST$, prtCLOSEVARFROMSTD$, prtCLOSECOSTLEDGER$, prtPICKSHEET$, drtBACKOUT$, drtADDIN$, drsNEW$, drsUPDATED$, drsCOMPLETED$, schFIXED$, schACTSPERHOUR$, schHOURSPERACT$, scaleNOSCALING$, scalePRODUCTIONRUN$, scalePARENTSPERTEMPLATE$, scaleTEMPLATESPERPARENT$, stepZERO$, dfltClosureWorkCenter$

cHistoryIol$, LogObj

GetDecryptedCols(), CheckEncryptedCols(), ClearEncryptedCols(), DecryptRec(), EncryptRec(), GetEncryptedCols(), InitEncryptInfo(), MaskColumnValue$(), ResetEncryptedCols()

GetCalendarEndingDate(), GetDefaultExtendedDescriptionKey$(), UPCEANCheckDigit(), UPCEANFetch(), UPCEANUpdate()

BuildAlternateIOL$(), BuildMemoryFile(), ConvertCalendarToJulian(), ConvertJulianToCalendar$(), FormatTime$(), HHMMToMinutes(), HHMMToNum(), LoadCustomLabelConstants(), NumToHHMM$(), TimeToHHMM()

FormatAddress(), ParseCityStateZip(), ClassValidateDirectory(), DirectoryCheck(), GetNextSequence(), GetUNCNamedDrive(), IsInstalled(), LocalizeFileIOList(), LocalizeIOList(), PackSequence$(), UnpackSequence(), UseChildKeyColl()

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