GetBranchLevel

Get Branch Level

Minor Business Rule

Object Name: B3400180

Parent DLL: CMFG

Location: Client/Server

Language: C

1.Functional Description
This function will return the Branch Level value from the F3403 record matching the given Component
Branch, Item Number - Short, and Master Planning Family values.  The function uses the first three keys
of the following index for the retrieval: CMCU, ITM, PRPX, BRSQ, EFFT.

1.1Purpose
The purpose of this function is to retrieve a default Branch Level value to use for new Branch
Relationship records which have the given Component Branch (Demand Branch) as a Supply Branch.  The function
retrieves the Branch Relationship record for the given Component Branch, Item Number - Short, and
Master Planning Family and returns the Branch Level value from the record.  If a matching record is not
found, the function returns the value zero.

1.2Setup Notes and Prerequisites

• None.

1.3Special Logic
None.

2.Technical Specifications
Initialize Branch Level parameter to zero (0).
Fetch the record from Branch Relationships file (F3403) for the given Component Branch, Item Number,
and Master Planning Family.
If the record is found, return the Branch Level value from the record.
If the record is not found, return error code "0002".

Data Structure

D3400180 - Get Branch Level

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szBranchComponent	CMCU	char	NONE	NONE
A secondary or lower-level business unit. The system uses the value that you enter to indicate that a branch or plant contains several subordinate departments or jobs. For example, assume that the component branch is named MMCU. The structure of MMCU might be as follows: Branch/Plant - (MMCU) Dept A - (MCU) Dept B - (MCU) Job 123 - (MCU)
mnShortItemNumber	ITM	MATH_NUMERIC	NONE	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
szMasterPlanningFamily	PRPX	char	NONE	NONE
A user defined code (system 41, type P4) under which you can organize logically related items. You can simplify the master planning process by concentrating on only the top 10% of the inventory value. This is similar to using the ABC Analysis, except that you can use this code to allow exceptions to ABC rules. Generally, you should only include items with high inventory investment in Master Planning. Excess stock can be carried for inventory items with little financial impact.
mnBranchLevel	BRLV	MATH_NUMERIC	NONE	NONE
Determines the level at which a component branch should be processed in multi-plant processing. The lowest level branches (which are assigned a higher numerical value) are processed first, followed by the higher level branches (which are assigned a lower numerical value). NOTE: Assign branch levels carefully so that the planning system generates all demand before allocating supply.
szErrorMessageID	DTAI	char	NONE	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.
cSuppressErrorMessages	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.

Related Functions

None

Related Tables

F3403 Branch Relationships Master File