Class IP_ProjectedDemands_bus

Properties

LOCAL cMainTable$="IP_ProjectedDemand"  

[string] Main table name.

LOCAL cIsSysDB=isFALSE  

[boolean] Flag to indicate that the main table is a system table.

LOCAL cAllowAliasItems  
LOCAL cItemTypes$  
LOCAL cPerformCustomerStatusChecking  
PROPERTY ARSetUp   * Read Only *

[boolean] Flag to indicate that the Accounts Receivable module is set up.

PROPERTY IM_BaseInventoryPeriodsOn$   * Read Only *

[string] Inventory setup option 'Base Inventory Periods On'.

Methods

FUNCTION CheckIRP(planCycle$, planYear$, item$, whse$)  

Checks if projected demand for the specified item, warehouse, year (any period) is being used in inventory requirements planning.

ParameterDescription
planCycle$ [input, string] Planning cycle
planYear$ [input, string] Planning year
item$ [input, string] Item code
whse$ [input, string] Warehouse code
Returns [boolean] isTRUE (1) if IRP detail record exists. Otherwise isFALSE (0)
FUNCTION CopyProjectedDemands(item$, whse$, arDiv$, cust$, copyFromYr$, copyToYr$)  

Copies one year of project demands for the specified item/warehouse/customer.

ParameterDescription
item$ [input, string] Item code
whse$ [input, string] Warehouse code
arDiv$ [input, string] AR division number
cust$ [input, string] Customer number
copyFromYr$ [input, string] Copy from planning year
copyToYr$ [input, string] Copy to planning year
Returns [boolean] retSUCCESS (1) or retFAILURE (0)
FUNCTION CreateProjectedDemandRecords(item$, whse$, arDiv$, cust$, yr$, cycle$)  

Creates all period records for the specified item/warehouse/customer/year.

ParameterDescription
item$ [input, string] Item code
whse$ [input, string] Warehouse code
arDiv$ [input, string] AR division number
cust$ [input, string] Customer number
yr$ [input, string] Planning year
cycle$ [input, string] Planning cycle
Returns [boolean] retSUCCESS (1) or retFAILURE (0)
FUNCTION Delete(key$)  

Deletes a projected demand record.

Returns [boolean] retSUCCESS (1) or retFAILURE (0)
FUNCTION DeleteAllRows()  

Deletes all records from memory table when in SET mode.

Returns [boolean] retSUCCESS (1) or retFAILURE (0)
FUNCTION FiscalYearChange(yr$, action$)  

Fiscal Year Change. Update projected demand records to work with changes made to a fiscal year.

ParameterDescription
yr$ [input, string] Planning year
action$ [input, string] LAST=merge into last period of year, FIRST=merge into first period of next year, DELETE=delete records for periods that no longer exist
Returns [boolean] retSUCCESS (1)
FUNCTION GetContext$(destTable$)  

Gets the contexts available for a table

ParameterDescription
destTable$ [input, string] table name
Returns [string] all contexts available for a given table
FUNCTION GetContextSourceTables$(context$)  

Gets the source table for a context

ParameterDescription
context$ [input, string] context
Returns [string] source table for a given context
FUNCTION GetYearStartEndDates(cycle$, yr$, yearStartDate$, yearEndDate$)  

Gets calendar/fiscal year start date and end date. When planning by week, year end date may be different than actual year end date because week 1 starts on specific day of week.

ParameterDescription
cycle$ [input, string] Planning cycle.
yr$ [input, string] Planning year
yearStartDate$ [output, string] Year start date
yearEndDate$ [output, string] Year end date
Returns [boolean] retSUCCESS (1)
FUNCTION ProjectedDemandsExist(item$, whse$, arDiv$, cust$, yr$, cycle$)  

Checks if projected demands exist for the specified item/warehouse/customer.

ParameterDescription
item$ [input, string] Item code
whse$ [input, string] Warehouse code
arDiv$ [input, string] AR division number
cust$ [input, string] Customer number
yr$ [input, string] Planning year
cycle$ [input/output, string] Planning cycle.
Returns [numeric] retSUCCESS (1) if demands exist and all periods are present

retFAILURE (0) if demands do not exist retWARNING (-1) if demands exist but number of records on file does not match number of periods

FUNCTION Write()  

Validates period number and writes record.

Returns [boolean] retSUCCESS (1) or retFAILURE (0)

Properties inherited from: CI_CustomerNo_Val

cAllowCashCust, cPerformCreditChecking, CreditExceeded, CreditHold, PerformCreditChecking, AllowCashCustomer

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

cDummyIol$

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_ARDivision_Val

ClassValidateARDivision()

Methods inherited from: CI_CustomerNo_Val

GetNextCustomerNo(), ClassOverrideCustomerNo(), ClassValidateCustomerNo()

Methods inherited from: CI_FiscalYear_Val

ClassValidateFiscalYear()

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_Warehouse_Val

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

Methods inherited from: IP_Constant

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

Methods inherited from: SY_Customization

GetCustomizations(), PostTableRead(), PreNextRecord(), PreTableWrite()

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()