|
CI_CommonPII, CI_Constant, PM_Constant, SY_Common, SY_TableConversionCommon |
| LOCAL cConversionOK=isFALSE |
[boolean] isTRUE if PM Conversion is successful |
| LOCAL cDestModuleCode$="P/M" |
[string] Destination Module Code |
| LOCAL cSourceModuleCode$="W/O" |
[string] Source Module Code |
| LOCAL cLineKeyIncrement=1 |
[integer] Line key increment |
| LOCAL cLineSeqNoIncrement=100000000 |
[integer] Line Sequence number |
| FUNCTION AccumulateTotalsforHistoryRecords(companyCode$) | ||||||||||||
Accumulate totals for history records | ||||||||||||
| ||||||||||||
| ||||||||||||
| ||||||||||||
| FUNCTION ConvertWOLToPM_WorkTicketHistoryHeader(companyCode$) | ||||||||||||
Convert the WOL table to the PM_WorkTicketHistoryHeader table. | ||||||||||||
| ||||||||||||
| ||||||||||||
| ||||||||||||
| FUNCTION ConvertWOMToPM_WorkTicketHistMemo(companyCode$) | ||||||||||||
Convert the WOM table to the PM_WorkTicketHistMemo table. | ||||||||||||
| ||||||||||||
| ||||||||||||
| ||||||||||||
| FUNCTION ConvertWONToPM_WorkTicketHistoryDetail(companyCode$, WOL$, newWorkTicketKey$) | ||||||||||||
Convert the WON table to the PM_WorkTicketHistoryDetail table. | ||||||||||||
| ||||||||||||
| ||||||||||||
| ||||||||||||
| FUNCTION ConvertWONToPM_WorkTicketHistoryStep(companyCode$, WOL$, newWorkTicketKey$) | ||||||||||||
Convert the WON table to the PM_WorkTicketHistoryStep table. | ||||||||||||
| ||||||||||||
| ||||||||||||
| ||||||||||||
| FUNCTION ConvertWOOToPM_TransactionHistory(companyCode$) | ||||||||||||
Convert the WOO table to the PM_TransactionHistory table. | ||||||||||||
| ||||||||||||
| ||||||||||||
| ||||||||||||
| FUNCTION WO_CONVERT_HISTORY_TO_PM() | ||||||||||||
Run the data conversion for the WO history files. | ||||||||||||
| ||||||||||||
| ||||||||||||
| FUNCTION WriteWorkTicketHistMemo(memoSourceDevString$, memoChnSrc, memoChnDest, destFile$, encryptCols$, sequenceNoColLength) | ||||||||||||
Write WorkTicket Memo record to 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() |
|
|