Class PM_DailyMaterialsUsageReg_upd

Properties

LOCAL cDailyPostingWorkFile$="PM_DailyPostingWork"  

[string] file name of the Production Management Daily Posting Work table

LOCAL cRegisterSortOption$="I"  

[string] Sort option for register from UI I-Product Line, W-Work Ticket, Default value is I

LOCAL cItemWhereClause$="1=1"  

[string] Selection grid value for CI_Item table, default to all

LOCAL cRecapFile$="PM_DailyMaterialsUsageRecap.rpt"  

[string] Crystal report name for Daily Materials Usage Recap report

LOCAL cRecapWorkFile$="PM_DailyMaterialsUsageRecapWrk"  

[string] register recap work file name

LOCAL cRegisterWrk$="PM_DailyMaterialsUsageWrk"  

Work Table name

LOCAL cStandardPostingComment$="P/M Materials Usage"  

[string] Standard Posting Comment

LOCAL cWorkTicketWhereClause$="1=1"  

[string] Selection grid value for PM_WorkTicketHistoryHeader table, default to all

LOCAL cReportFile$  
LOCAL cSourceJournal$  
PROPERTY ErrorLog   * Read Only *

[objhandle] object handle of Error Log object

PROPERTY ReportCaption$  

[string] Report Caption

Methods

FUNCTION GetSourceTables$(table$)  

Gets source tables for a specific table for custom office

ParameterDescription
table$ [input, string] table name to return source tables for
Returns a SEP separated string of source tables
FUNCTION ProcessAdditionalReports(reportName$, cOutputType$)  

Processes additional report(s) after the daily materials register

ParameterDescription
reportName$ [input, string] Name of additional report
cOutputType$ [input, string] Output Type (Print, Preview, etc.)
Returns [boolean] success if additional report(s) printed, otherwise failure
FUNCTION SetUpdateOptions(regSort$, transThruDate$, itemClause$, wtClause$)  

Sets update options from UI

ParameterDescription
regSort$ [input, string] sort order for register, I=Item Code, W=Work Ticket Number
transThruDate$ [input, string] date to use to select daily materials records to update. Null means all records
itemClause$ [input, string] selection grid where clause for CI_Item, used to restrict daily materials records to update
wtClause$ [input, string] selection grid where clause for PM_WorkTicketHisoryHeader, used to restrict daily materials records to update

Properties inherited from: CI_Constant

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$

Properties inherited from: PM_Constant

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$

Properties inherited from: SY_Selection

cDefaultOperand$, cMaintenanceOption, cSkipPromote, Category1Desc$, Category2Desc$, Category3Desc$, Category4Desc$, HasDates

Properties inherited from: SY_Update

cGroup$, cDeferredAuditRegister$, CurrentPeriod$, PeriodEndingDate$, PeriodStartingDate$, Restart

Methods inherited from: CI_Constant

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

Methods inherited from: PM_Constant

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

Methods inherited from: SY_Selection

BuildSelectDefaults(), ChangeOperand(), ChangeValue1(), ChangeValue2(), ClassOnFocusGrid(), ClassOnFocusGridSetKey(), CreateSelectWhere(), GetWhereClause(), LoadGrid(), LoadRow(), OnExitGrid(), PostLoadGrid(), ReadSelectDefault(), ResetALL(), ReturnReportSelection(), ReturnSetupGrid(), ReturnSetupTable(), RowMods(), SaveRow(), SetOperand(), SetRowState(), AddRecPrefix$(), PERFORM BuildClause(), FindMultiSepChar(), FixDepartment(), FixDivision(), PERFORM FormatValue(), GetBeginEnd(), GetBeginEndCol(), PERFORM GetSelection(), IsUDFReportSelection(), PERFORM JoinClause(), PfxWhereClause(), PostLoad(), PromoteCacheMode(), RefreshSelectionGrid(), PERFORM ResetValue1(), PERFORM ResetValue2(), SaveRowWrite(), SearchOutsideQuotes(), SelectionResetRow(), SetAutoComplete(), SetupForDateSelections(), SubstituteOutsideQuotes(), PERFORM SYSResolveSelectToken()

Methods inherited from: SY_Update

GetCurrentRegister$(), PrintErrorLog(), ProcessReport(), SetPostingDate(), SetPrintComment(), Update(), PERFORM ClearDailyPostingWorkFile(), PERFORM ClearDrillDownWorkFile(), PERFORM ClearWorkFiles(), GetNextRegisterNo(), PERFORM PostTableReadSY_Update(), PERFORM PreNextRecordSY_Update(), PERFORM PreTableWriteSY_Update(), PERFORM SaveUnusedRegisterNo(), UpdateCleanup(), UpdateGLDailyPostingFile(), UpdateInit(), UpdateMain(), UpdateTempGLDaily(), WriteGLSummaryDrillDown(), WriteTempGLDrillDown()