CI_CommonPII, CI_Constant, PM_Constant, SY_Common, SY_TableConversionCommon

[boolean] isTRUE if PM Conversion is successful

[string] Destination Module Code

[string] Source Module Code

[integer] Line key increment

[integer] Line Sequence number increment

Accumulate totals for history records

Add In Work Ticket Detail (Materials) to history

Convert the WO0 table to the PM_Options table.

Convert the WO0 table to the PM_WorkTicketClass table.

Convert the WO1 table to the PM_WorkTicketHeader table.

Convert the WO2 table to the PM_WorkTicketDetail table.

Convert the WO3 table to the PM_WorkTicketStep table.

Convert the WO5 table to the PM_Template table.

Convert the WO9 Table to thePM_TransactionHistory table. Creates records in PM_TransactionLotSerialHistory, PM_WorkTicketTierDistribution and PM_LaborHistory if necessary

Convert the WOA table to the PM_WorkCenter table.

Convert the WOB table to the PM_ActivityCode table.

Convert the WOC table to the PM_Template table.

Convert the WOE table to the PM_WorkCenterClosure table.

Convert the WOF table to the PM_ToolCode table.

Convert the WOG table to the PM_Department table.

Convert the WOG table to the PM_Employee table.

Convert the WOH table to the PM_LaborCrewHeader table.

Convert the WOP table to the PM_TemplateMemo table.

Convert the WOP table to the PM_WorkTicketMemo table.

Create the company batch options records

Create the company P/M Default Records in various tables not converted

Update PM Template in additional tables

Run the data conversion for the WO module.

Write Template Memo record to PM_TemplateMemo

#param sequenceNoColLength [input, numeric] column length for SequenceNo$ column

Write WorkTicket Memo record to PM_WorkTicketMemo and PM_WorkTicketHistMemo

#param sequenceNoColLength [input, numeric] column length for SequenceNo$ column

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