Class IP_InventoryReqPlanningRpt_rpt

Properties

LOCAL cReportFile$="IP_InventoryReqPlanningRpt.rpt"  

[string] Crystal report file name, used by paperless office.

LOCAL cWorkFile$="IP_PlanningReportWrk"  

[string] Report work table name.

PROPERTY ReportCaption$   * Read Only *

[string] Report title.

PROPERTY SummaryFH  

[filehandle] File handle to the IP_InventoryReqPlanningSummary memory table. Passed in from IP_InventoryReqPlanningSummary_UI class.

PROPERTY ReportIDFilter$  

[string] Report ID. Passed in from IP_InventoryReqPlanningSummary_UI class.

PROPERTY ProcurementFilter$  

[string] 'Procurement' filter. Passed in from IP_InventoryReqPlanningSummary_UI class.

PROPERTY IncludeFilter$  

[string] 'Include' filter. Passed in from IP_InventoryReqPlanningSummary_UI class.

Methods

FUNCTION GetSourceTables$(table$)  

Gets report source tables.

ParameterDescription
table$ [input, string] Work table name
Returns [string] A SEP delimited list of source table names.
FUNCTION ReportOptionChange(field$, value$)  

Triggers report file change when report selection is changed.

ParameterDescription
field$ [input, string] Name of report option changed
value$ [input, string] Value of report option changed
Returns Always returns retSUCCESS(1)
FUNCTION ReturnSetupTable(tableFH, whereClause$)  

Returns where clause from selections.

ParameterDescription
tableFH [input, numeric] memory table or SY_ReportSelection file handle
whereClause$ [output, string] selection where clause
Returns 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: 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: 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()