CacheProcessInboundForecasts

Process Inbound Forecasts

Minor Business Rule

Object Name: B34A1040

Parent DLL: CMFG

Location: Client/Server

Language: C

1.Functional Description
1.1Purpose
This function will perform Load, Delete, Update, Get, and Clear functions on the Forecasts cache used
in the Numetrix Inbound Forecast UBE (R34A485).  On a Create process, an identifier for the cache
(hCache handle) is passed back to the calling program for subsequent calls to this function.  This cache
is required so that records may be sorted in the order Item Number, Branch, Forecast Type, Date,
Customer Number so that deletes can be handled efficiently.

1.2Setup Notes and Prerequisites
The calling application is responsible for loading all appropriate key values to the data structure
and identifying the number of keys to use in retrieval/update processes.  The application must also
store the hCache pointers passed back from the "Create" process and pass these pointers back to the
business function on the other process modes which require them (see technical specifications below).

1.3Special Logic
There is no special logic within this function.

2.Technical Specifications
2.4Processing
Main Processing:
Cache Layout:.

AliasData ItemNotes
Index
ITMShort Item Number
MCUBranch
TYPFForecast Type
DRQJDate Requested
AN8Address Number
Text
FQTForecast Quantity

I.    Perform setup functions

A. Initialize cache to get handle.
B.Initialize return code to success.

C.If not successful, Set error "032E," "Error Processing Cache" and set return code to
failure.

II. Processing Based on Mode.

A.If Process Mode is "1" - GET:

1.Retrieve element from cache using keys to index.

B.If Process Mode is "2" - ADD:

1.Add element to cache.

C.If Process Mode is "3" - UPDATE:

1.Update cache element.

D.If Process Mode is "4" - DELETE:

1.Delete cache element matching key

E.If Process Mode is "5" - DELETE ALL:

1.Delete all cache elements

F.If Process Mode is "6" - GET NEXT:

1.Retrieve next element from cache using keys or keyless

G.If Process Mode is "7" - ADD/UPDATE:

1.If element exist, update, else add element to cache.

H.If Process Mode is "8" - END

1.Perform cleanup functions (Terminate cache).

I.If Process Mode is "9" - END

1.Close the cursor.

Data Structure

D34A1040B - Cache Process Forecasts

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnShortItemNumber	ITM	MATH_NUMERIC	OPT	NONE
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
szBranch	MCU	char	OPT	NONE
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szForecastType	TYPF	char	OPT	NONE
A user defined code (34/DF) that indicates one of the following: o The forecasting method used to calculate the numbers displayed about the item o The actual historical information about the item
jdDateRequested	DRQJ	JDEDATE	OPT	NONE
The date that an item is scheduled to arrive or that an action is scheduled for completion.
mnAddressNumber	AN8	MATH_NUMERIC	OPT	NONE
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
mnForecastQuantity	FQT	MATH_NUMERIC	OPT	NONE
The quantity of units forecasted for production during a planning period.
nNumberOfKeys	INT01	integer	OPT	NONE
Number of Days in Future to Query for Responses Due.
cProcessMode	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cCacheCodeError	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cSuppressErrorMessage	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
szErrorMessageID	DTAI	char	OPT	NONE
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
mnJobNumber	JOBS	MATH_NUMERIC	OPT	NONE
The job number (work station ID) which executed the particular job.
cReturnCursor	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
idCursor	GENLNG	ID	OPT	NONE
General purpose ID variable.

Related Functions

None

Related Tables

None

F3460ProcessInboundForecasts

Process Inbound Forecasts

Minor Business Rule

Object Name: B34A1040

Parent DLL: CMFG

Location: Client/Server

Language: C

Data Structure

D34A1040A - F3460 Process Inbound Numetrix Forecasts

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szPathName	NFLF	char	OPT	NONE
Flat file path name. ^
szDateFormat	FRMT	char	OPT	NONE
The format of a date as it is stored in the database. For OneWorld, the following date formats are valid: YMD, MDY, DMY, EMD. If you leave this field blank, the system displays dates based on the settings of the operating system on the workstation. With NT, the Regional Settings in the Control Panel control the settings for the operating system of the workstation. For World Software, the following date formats are valid: DMY, MDY, YMD. EMD is not a valid date format.
cFieldDelimiter	FFDL	char	OPT	NONE

cTextQualifier	TC056	char	OPT	NONE
Indicates that a double quotation mark is used to quailfy text in this user-defined file.
cErrorCondition	ERRC	char	OPT	NONE
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document Set Server program (XT4914).
cSuppressErrorMessage	SUPPS	char	OPT	NONE
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function. 0 = allow runtime error message handling. 1 = suppress runtime error message handling.
szErrorMessageId	DTAI	char	OPT	NONE
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
mnJobNumber	JOBS	MATH_NUMERIC	OPT	NONE
The job number (work station ID) which executed the particular job.
mnRecordCount	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
szDefaultForecastType	TYPF	char	OPT	NONE
A user defined code (34/DF) that indicates one of the following: o The forecasting method used to calculate the numbers displayed about the item o The actual historical information about the item

Related Functions

None

Related Tables

None