Class IP_InventoryReqPlanningSummary_bus

Properties

LOCAL cMainTable$="IP_InventoryReqPlanningSummary"  

[string] Main table for class

LOCAL cIsSysDB=isFALSE  

[boolean] True/False flag denoting whether the main table is a system table

LOCAL cModuleCode$="I/P"  

[string] Module code that this task belongs to

LOCAL cItemTypes$  
LOCAL cPerformVendorStatusChecking  
PROPERTY AP_DivisionLength   * Read Only *

[integer] Length of A/P Division Number field

PROPERTY AP_Divisions$   * Read Only *

[string] Yes/No flag for whether divisions are used in the A/P module. Source is AP_Options.

PROPERTY AP_Integrated   * Read Only *

[boolean] True/False is the A/P module integrated

PROPERTY AP_VendorLength   * Read Only *

[integer] Length of Vendor Number field

PROPERTY BM_Integrated   * Read Only *

[boolean] True/False is the B/M module integrated

PROPERTY CI_NumberOfDecimalPlacesInCost   * Read Only *

[integer] Number of decimal places in cost fields. Source is CI_Options.

PROPERTY CI_NumberOfDecimalPlacesInQty   * Read Only *

[integer] Number of decimal places in quantity fields. Source is CI_Options.

PROPERTY CostMask$   * Read Only *

[string] Mask to be used for cost fields

PROPERTY FilterInclude$  

[string] Filter Include, A=All; Y=Items to produce/buy, N=Items not requiring to be procuced/bought

PROPERTY FilterProcurementType$  

[string] Filter Procurement Type; M=Produce, B=Buy

PROPERTY FilterSelectionSetting$  

[string] to store the selection setting being processed

PROPERTY InactivePurchaseItems  

[boolean] True/False Set to true if there are any inactive items with a purchase requirement

PROPERTY IRPBus  

[object handle] Object handle to an instance of IP_InventoryReqPlanning

PROPERTY MaxFilters=5  

[integer] Maximum number of filters allowed

PROPERTY NumFilters   * Read Only *

[integer] Number of filters

PROPERTY PM_DefaultStockWorkTicketClass$   * Read Only *

[string] Default Stock Work Ticket Class. Source is PM_Options.

PROPERTY PM_Integrated   * Read Only *

[boolean] True/False is the P/M module integrated

PROPERTY PO_Integrated   * Read Only *

[boolean] True/False is the P/O module integrated

PROPERTY QtyMask$   * Read Only *

[string] Mask to be used for quantity fields

PROPERTY SO_Integrated   * Read Only *

[boolean] True/False is the S/O module integrated

Methods

FUNCTION AddFilter(field$, value$)  

Add Filter

ParameterDescription
field$ [input, string] field name to filter on
value$ [input, string] value of field name to filter on
Returns [boolean] True if filter added, False if is not added
FUNCTION BuildFilterList$(fieldName$)  

Build Filter List for a specific field name of unique values that exist for that field name in the generated summary and detail table records

ParameterDescription
fieldName$ [input, string] field name to build the filter list for
Returns [string] list of unique values
FUNCTION BuildWorkFiles(summaryFH, detailFH)  

Build workfiles used to create purchase orders or work tickets

ParameterDescription
summaryFH [output, filehandle] memory file storing selected IP_InventoryReqPlanningSummary records
detailFH [output, filehandle] memory file storing selected IP_InventoryReqPlanningDetail records
Returns [boolean] True if successful, False if not
FUNCTION BuildWorkFilesResetUserChanges(tmpItem$, tmpWhse$, wtCreate)  

Resets user changes to production items at summary and detail level as creating work tickets

ParameterDescription
tmpItem$ [input, string] item code work tickets created for
tmpWhse$ [input, string] warehouse code work tickets created for
wtCreate [input, boolean] set to true when resetting user changes for item that work tickets just created for
Returns [boolean] True, always returns success
FUNCTION ChangeProcurement(keyVal$)  

Change Procurement for a record, Purchase->Produce or Produce->Purchase

ParameterDescription
keyVal$ [input, string] key value of record to change
Returns [boolean] True if successful, False if not
FUNCTION CloseUserChangeTables()  

Closes tables used to reset user changes after create of work tickets

Returns [boolean] True, always returns success
FUNCTION Delete(key$)  

Overrides base class function from SY_Maint. This is done to add logic to deal with the filters when deleting a record

ParameterDescription
key$ [input, string] key to summary record to delete
Returns [boolean] True if successful, False if not
FUNCTION GetDetailFH()  

Get Detail File handle

Returns [integer] File handle to the detail table
FUNCTION GetFilter(filterNo, filterField$, filterValue$)  

Get Filter

ParameterDescription
filterNo [input, integer] filter number to get
filterField$ [output, string] field name for filter
filterValue$ [output, string] value of field name for filter
Returns [boolean] True if successful, False if filter number has not been added
FUNCTION GetItemWarehouseAvail(itmCode$, whseCode$)  

Retrieves the quantity available for an item and warehouse

ParameterDescription
itmCode$ [input, string] item code to retrieve qty available for
whseCode$ [input, string] warehouse code to retrieve qty available for
Returns [numeric] returns the qty available for an item and warehouse
FUNCTION GetSummaryFH()  

Get Summary File handle

Returns [integer] File handle to the summary table
FUNCTION InitWorkTable()  

Overrides base class function from SY_Maint. This replaces the base class logic that creates a set of records that will be maintained.

Returns [boolean] True, always returns success
FUNCTION ReloadLine(summaryKey$)  

Reload Line

ParameterDescription
summaryKey$ [input, string] key of summary record to reload
Returns [boolean] True, always returns success
FUNCTION RemoveFilter(filterNo)  

Remove Filter

ParameterDescription
filterNo [input, integer] filter number to remove
Returns [boolean] True, always returns success
FUNCTION ResetUserChanges()  

Resets user changes to production items putting summary/detail recs back on hold and adjust summary quantity if needed for holds

Returns [boolean] True, always returns success
FUNCTION Write()  

Overrides base class function from SY_Maint. This is done to add logic to deal with the filters when writing a record

Returns [boolean] True if record written successfully, False if record is not written successfully

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

cItemTypes$, cAllowAliasItems, cAliasItemTypes$, cItemCodeDescCol$, cItemTypeCol$, cExtDescKeyCol$, ItemTypes$, AllowAliasItems, AliasItemTypes$, ExtendedDescriptionBusiness, ItemCodeDescCol$, AllowPhantom, AllowEngineering, AllowInactive, InvalidPurchase, IMIntegrated

Properties inherited from: CI_VendorNo_val

HoldPayment, SeparateCheck

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_Maint

cActionWrite, cActionDelete, cActivityLogFilePrefix$, DocDateWarnDisplayed, DocDateWarnStatus, EditState, RecordChanged, FirstFailure$, DocumentTotal, ReadOnlyReason$, UDTValidation$, ViewOnly, CurrentPrecision, DocDateWarnForceOff, DocDateWarnObject, ScriptObject, ImportTest, SkipNullCheck$, AFSRequiredFields$

Properties inherited from: SY_MaintSet

FileChanged

Methods inherited from: CI_APDivision_val

ClassValidateAPDivision()

Methods inherited from: CI_Constant

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

Methods inherited from: CI_ItemCode_val

Write(), PERFORM CheckForAlias(), PERFORM CheckUseIn(), CheckValidBill(), ClassOverrideDescription(), ClassOverrideItemCode(), ClassValidateDescription(), ClassValidateItemCode(), ItemTypeSetDefaults(), PERFORM ItemTypeSetDefaults(), UpdateGridExtendedDescKey(), ValidateGroupNotCurrentItemType()

Methods inherited from: CI_UnitOfMeasure_val

ClassValidateUnitOfMeasure()

Methods inherited from: CI_VendorNo_val

ClassValidateVendorNo()

Methods inherited from: CI_Warehouse_val

SetAllowInactiveRestrictedWhse(), ClassValidateWarehouse(), GetClassName$()

Methods inherited from: IP_Constant

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

Methods inherited from: SY_Maint

ChangedRecordCompare(), ChangedRecordInfo(), Clear(), ClearRecord(), ConfirmDelete(), CopyFrom(), ExportToCSV(), GetColumnInfo(), GetColumnProperties$(), GetDefaults(), GetOrigRecord$(), GetPropertyValue(), GetValidationGroups$(), ResetDocDateWarnState(), SetCopyKeyValue(), SetDocDateWarnDisplayed(), SetDocDateWarnOff(), SetKey(), SetKeyValue(), SetPartialRecord(), SetRecord(), SetToReadOnly(), SetValue(), SetValues(), Write(), ActivityLogCreateFile(), ActivityLogPrepare(), ActivityLogSetMessage$(), ActivityLogWrite(), CallScript(), CheckForAdvancedFieldSettings(), CheckForScripts(), CheckNullRequiredField(), PERFORM ChildValidate(), ClassValidateDate(), ClassValidateTelephoneNo(), ClearSetFiles(), ColInfoInitAll(), ColInfoInitDefaults(), CommitRow(), GetPropertyCommon(), InitColInfo(), InitScriptEngine(), InitSearchForUpdate(), InitWorkTable(), IsColInIOList(), IsValid(), LoadColInfo(), OpenMainTable(), ParseExtField(), PreWriteScripts(), RemoveColToSkip(), ResetRow(), RetrieveColInfo(), SetDefaults(), SetFilter(), SetMode(), SetParentHandle(), SetValueNoValidate(), StoreColToSkip(), ValidateAll(), ValidateAllRecord(), ValidateColInfo(), ValidateRule()

Methods inherited from: SY_MaintSet

ClearSetFiles(), CommitRow(), QuickRowLoad(), ResetRow(), SeedDetailRow(), SetFilter(), SetMode()