Class IP_InventoryReqPlanning

Properties

LOCAL cBackSchedule$="B"  

[string] local constant to backward schedule

LOCAL cExplodeMakeActionComponent$="C"  

[string] requirements planning option to explode components

LOCAL cExplodeMakeActionParent$="P"  

[string] requirements planning option to only show parent item, no components

LOCAL cExplodeSubassemblies$=isYES$  

[yes/No] set to isYES to always explode subassemblies when processing IRP for bill items

LOCAL cMakeBuildTimeCalcBasedOnTemplate$="T"  

[string] local constant for make build time calc based on template

LOCAL cPullInWorkTicket$=isNO$  

[yes/No] IP option to allow work tickets to be pulled in to meet earlier demand

LOCAL cPushOutWorkTicket$=isNO$  

[yes/No] IP option to allow work tickets to be pushed out to meet later demand

LOCAL cScaleParentsPerTemplate$="Y"  

[STRING] local constant for scaling method parents per template

LOCAL cScaleProductionRun$="P"  

[STRING] local constant for scaling method production run

LOCAL cScaleTemplatesPerParent$="M"  

[STRING] local constant for scaling method templates per parent

LOCAL cScheduleDays$="Sunday"+SEP+"Monday"+SEP+"Tuesday"+SEP+"Wednesday"+SEP+"Thursday"+SEP+"Friday"+SEP+"Saturday"+SEP  

[string] list of days of the week used for scheduling

LOCAL cSOTypes$="SB"  

[string] list of sales order types to include in requirement planning

LOCAL cFulfillBUY2ORDER$="BO"  

[string] constant value for fulfill by buy to order

LOCAL cFulfillBUY2STOCK$="BS"  

[string] constant value for fulfill by buy to stock

LOCAL cFulfillMAKE2ORDER$="MO"  

[string] constant value for fulfill by make to order

LOCAL cFulfillMAKE2STOCK$="MS"  

[string] constant value for fulfill by make to stock

LOCAL cStatusINACTIVE$="I"  

[string] constant value for status of inactive

LOCAL cProALL$=proBUY$+proBUYTOORDER$+proMAKE$+proMAKETOORDER$+proSUBCONTRACT$  
LOCAL cPlanINVENTORY$="I"  
LOCAL cPlanWORKTICKET$="W"  
LOCAL cPTMAKE$="M"  
LOCAL cPTPURCHASE$="P"  
LOCAL cWTStatusQUOTE$="Q"  

[string] constant value for quote work ticket status

LOCAL cWTStatusReleased$="R"  

[string] constant value for released work ticket status

PROPERTY BM_Setup  

[boolean] Flag to indicate the Bill of Materials module is set up for this company.

PROPERTY CreateWTWithMaterialsFrom$  

[string] Create Work Ticket With Materials From, B-Bill, W-Template, A-Both

PROPERTY GatherDetail  

[boolean] true if need to gather item demand/supply detail

PROPERTY IM_RequireMultipleWarehouses   * Read Only *

[boolean] true if I/M setup option to require multiple warehouses is set

PROPERTY IntegratePM$   * Read Only *

[Yes/No] I/P Setup option 'Integrate Production Management'

PROPERTY IntegratePO$   * Read Only *

[Yes/No] I/P Setup option 'Integrate Purchase Order'

PROPERTY IntegrateSO$   * Read Only *

[Yes/No] I/P Setup option 'Integrate Sales Order'

PROPERTY ItemSelectionClause$  

[String] clause for item code from selection grid

PROPERTY IP_BaseEffectiveDateOnDemandDate$   * Read Only *

[Yes/No] I/P Setup option 'BaseEffectiveDateOnDemandDate'

PROPERTY LblWTDESC$   * Read Only *

[string] user defined label for Work Ticket

PROPERTY LockFH   * Read Only *

[filehandle] handle to lock table for single user use of specific selection

PROPERTY MoveDetail  

[boolean] true if when moving requirement detail from production to purchase or purchase to production

PROPERTY NewReportSetting$  

[string] selection/report setting switching to

PROPERTY PM_IntegrateBillOfMaterials$   * Read Only *

[string] Yes/No flag for whether Production Management is integrated with the Bill of Materials module. Source is PM_Options.

PROPERTY ReportCaption$=$$  

[string] report caption

PROPERTY ReportFile$=$$  

[string] crystal report file name

PROPERTY SkipProcessErrorDisplay=isTRUE  

[boolean] set to true to skip error display logic in SY_ReportCommonUI

Methods

FUNCTION CalculateUnitCost(tmpItem$, tmpAPDivisionNo$, tmpVendorNo$, tmpQuantity)  

Calculates unit cost for item, vendor, and quantity

ParameterDescription
tmpItem$ [string] item code to calculate unit cost for
tmpAPDivisionNo$ [string] vendor division number to calculate unit cost for
tmpVendorNo$ [string] vendor number to calculate unit cost for
tmpQuantity [number] quantity used to calculate unit cost for
Returns [number] the calculated unit cost
FUNCTION ClearSelection()  

Clears selections from header, detail, and summary tables for currently selected selection setting

Returns [boolean] retSUCCESS(1) if selections cleared for current report setting or retFAILURE(0) if no current selection selected and locked
FUNCTION CloseLock()  

Closes lock file handle

Returns [boolean] Always returns retSUCCESS(1)
FUNCTION DoFieldMappings()  

Logic to perform field mappings for selections

Returns [boolean] Always returns retSUCCESS(1)
FUNCTION GetInvReqPlanning(buysExist, makesExist)  
FUNCTION GetInvReqPlanning(buysExist, makesExist, checkReportSetting$)  

Logic to check if any buy or make requirement planning records exist for the current report setting

ParameterDescription
buysExist [boolean] Set to true if any buy requirement planning records exist for this report selection
makesExist [boolean] Set to true if any make requirement planning records exist for this report selection
checkReportSetting$ {optional} [input, string] alternate selection setting to check for generated data, if no setting uses current setting
Returns [boolean] Always returns retSUCCESS(1)
FUNCTION LockReportSetting()  

Lock specified report settings so only one user can process

Returns [boolean] lock file handle, returns 0 if not locked
FUNCTION RegenerateDetail(summaryKey$)  

Regenerate Detail following generation of purchase orders, work tickets and regenerate for a specific item and warehouse

ParameterDescription
summaryKey$ [input, string] key of summary memory file used to create purchase orders, work tickets or to regenerate
Returns [boolean] Returns success if successfully regenerated detail for the summaryKey$ submitted, returns failure if the summaryKey$ submitted was not found
FUNCTION RegenerateMakeItem(makeItemCode$, makeWhse$, fromCreateWT)  

Regenerates Make item detail when creating work tickets

ParameterDescription
makeItemCode$ [string] item Code that is a make item and needs to be regenerated
makeWhse$ [string] warehouse code for make item that needs to be regenerated
fromCreateWT [boolean] set to true when coming from create work tickets
Returns [boolean] Always returns retSUCCESS(1)
FUNCTION Resummarize(detailFH, summaryFH, summaryKey$)  

Resummarize summary based on detail detailFH [input, integer] memory table containing a set of records from IP_InventoryReqPlanningDetail summaryFH [input, integer] memory table containing a set of records from IP_InventoryReqPlanningSummary summaryKey$ [input, string] key of summary memory file record to resummarize

Returns [boolean] Always returns retSUCCESS(1)
FUNCTION SelectWorkTicketDetail(sumKey$, tmpItem$, tmpWhse$)  

Selects work ticket detail item when creating work tickets

ParameterDescription
tmpItem$ [string] item Code to select work ticket detail for
tmpWhse$ [string] warehouse to select work ticket detail for
Returns [boolean] Always returns retSUCCESS(1)
FUNCTION SelectWorkTickets(tmpSummKey$, tmpItem$, tmpWhse$)  

Selects work tickets when creating work tickets

ParameterDescription
tmpItem$ [string] item Code to select work tickets for
tmpWhse$ [string] warehouse to select work tickets for
Returns [boolean] Always returns retSUCCESS(1)
FUNCTION SetDefaults(optionsString$)  

Set default values for parameters in optionsString

ParameterDescription
optionsString$ [string] string of options for dialog
Returns [boolean] Always returns retSUCCESS(1)
FUNCTION SetIMWhereClause()  

Set the IM where clause from the selections

Returns [boolean] Always returns retSUCCESS(1)
FUNCTION SetIRPHeaderTimeStamp()  

Creates IP_InventoryReqPlanningHeader for current selection

Returns [boolean] Always returns retSUCCESS(1)
FUNCTION SummarizeAfterCreateWT()  
Returns [boolean] Always returns retSUCCESS(1)
FUNCTION SummarizeWorkTable(detailFH, summaryFH)  

Summarize Work Table detailFH [input, integer] memory table containing a set of records from IP_InventoryReqPlanningDetail summaryFH [input, integer] memory table containing a set of records from IP_InventoryReqPlanningSummary

Returns [boolean] Always returns retSUCCESS(1)
FUNCTION UpdateTopLevelWorkTicket(tmpWTKey$)  

Updates the top level work ticket memory table when creating work tickets

ParameterDescription
tmpWTKey$ [input, string] work ticket created
Returns [boolean] Always returns retSUCCESS(1)

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: IP_Constant

actionBUYTOORDER$, actionCANTRESCHEDULE$, actionINCREASEQTY$, actionMAKE$, actionMAKETORDER$, actionMOVEOUT$, actionORDER$, actionPULLIN$, actionPUSHOUT$, actionQTYINCREASED$, actionQTYREDUCED$, actionREDUCEQTY$, actionUNNEEDED$, actionDescBUYTOORDER$, actionDescCANTRESCHEDULE$, actionDescINCREASEQTY$, actionDescMAKE$, actionDescMAKETORDER$, actionDescMOVEOUT$, actionDescORDER$, actionDescPULLIN$, actionDescPUSHOUT$, actionDescQTYINCREASED$, actionDescQTYREDUCED$, actionDescREDUCEQTY$, actionDescUNNEEDED$, mftCodeSALESORDER$, mftCodeWORKTICKET$, mftCodeINVENTORY$, mftDescSALESORDER$, mftDescWORKTICKET$, mftDescINVENTORY$, planCycleWEEK$, planCycleMONTH$, wtsOPEN$, wtsQUOTE$, wtsRELEASED$, wtsCLOSED$, wtsDELETED$, sourceBILLCOMPONENT$, sourceINVENTORY$, sourceWTMATERIALS$, sourceWTPARENT$, sourcePROJDEMAND$, sourcePO$, sourceSO$

Properties inherited from: IP_Selection

cIRPTask$

Properties inherited from: SY_Report

cMainTable$, cIsSysDB, cCommonElements$, CurrentFiscalYear$, CurrentPeriod$, ReportID$, UseWorkstationDfltPntrStdRpt$, UseWorkstationDfltPntrStdForm$, ReportSettingPrinterName$, RecordSet

Methods inherited from: CI_Constant

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

Methods inherited from: IP_Constant

GetActionDesc$(), GetSourceDesc$(), LoadDescMemFile()

Methods inherited from: IP_Selection

ResolveSelectToken(), BT_OKView(), BT_SelectionSetting(), CheckSelectionSetting(), GetDefaultSelectionSetting(), PostLoad()

Methods inherited from: SY_Report

AppendReportOptions(), BuildExtendedSort(), CreateStandardSetting(), GetCurrentClause(), GetFiscal(), GetLocal(), GetOptions(), GetRecordSettings(), OpenRecordSet(), ParseOptionsGrid(), ProcessReport(), ProcessReportWorkTable(), ReplaceDefault(), ResetWorkTables(), SelectReportSetting(), SetDefaults(), SetOptions(), SetRecordSettings(), SetReportObjectPrinterProps(), SetReportWhereClause(), This function will set the value of the variable cReportWhereClause$. This value is used by SY_Selection'GetWhereClause(), GetOperandStartEnd(), GetSelectCriteria(), GetSelectOperandValues(), SetChildColl(), WriteWorkstationPrinter()