UpdateLowLevelCodes

Update Low Level Codes

Major Business Rule

Object Name: B3001080

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
This business function will update the low level codes in the bill of material table (F3002).

1.2Setup Notes and Prerequisites

1.3Special Logic

2.Technical Specifications

3.0 Processing

1.0.  Retrieve the Parent Item Low Level Code (LLX) from the Item Master Table (F4101).

2.0.  Retrieve the Component Item Low Level Code (LLX) from the Item Master Table (F4101).

3.0.  Store DS Component Item and distance from Parent Item = 1.

4.0.  Retrieve next lower level component until all lower level components have been processed

5.0.  Store the F3002 Component and maximum distance from parent item.

6.0.  Retrieve Time, Date, User ID, Program ID, and Work Station.

7.0. Update the Parent Item Low Level Code if needed. If the Parent Item Low Level Code (check F4101
and F4102) is equal to zero, assign the Parent Item Low Level Code = 1 and update the Parent Item Low
Level Code in the Item Master Table and Item Branch Table.  More than one record may be updated in
the Item Branch Table.

Update the Item Master Low Level Code, Program ID, Job Number, Date Updated, and Time of Day.
Update the Item Branch Low Level Code, Program ID, Job Number, Date Updated, and Time of Day.

8.0.  Update the Component Item Low Level Code.

8.1.  Calculate new component low level code = Parent Low Level Code +1.

8.2.  If New Low Level Code is greater than the Item Master low level code, update the Low Level
code in the Item Master Table (F4101).  Update the Item Master Low Level Code, Program ID, Job
Number, Date Updated, and Time of Day.
8.3.   If the New Low Level Code is greater than the Item Branch low level code, update the Low
Level code in the Item Branch Table (F4102) using Item Number.  More then one record may exisit per
item number in the Item Branch Table.  Update the Item Branch Low Level Code, Program ID, Job
Number, Date Updated, and Time of Day.

9.0.  Update the low level codes of all lower level bill of material components.

9.1.  Calculate new component low level code = Parent Low Level Code + Component level

9.2.  If the new low level code is greater than the Item Master low level code, update the Low
Level code
          in the Item Master Table (F4101).  Update the Item Master Low Level Code, Program ID,
Job
          Number, Date Updated, and Time of Day.
9.3.  If the new low level code is greater than the Item Branch low level code, update the Low
Level code
          in the Item Branch Table (F4102) using Item Number.  More than one record may exist per
item
          number in the Item Branch Table.  Update the Item Branch Low Level Code, Program ID, Job
          Number, Date Updated, and Time of Day.

Data Structure

D3001080 - Update Low Level Codes

Parameter Name Data Item Data Type Req/Opt I/O/Both

szParentBranch MMCU char NONE NONE

A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which
represent lower-level business units, subordinate to it. For example:     o Branch/Plant (MMCU)     o Dept A (MCU)     o Dept B (MCU)     o Job 123
(MCU) Business unit security is based on the higher-level business unit.

mnParentItem KIT MATH_NUMERIC NONE NONE

The system provides for three separate item numbers.    1.   Item Number (short) - An eight-digit, computer assigned, completely
non-significant item number.    2.   2nd Item Number - The 25-digit, free form, user defined alphanumeric item number.    3.   3rd Item Number - Another
25-digit, free form, user defined alphanumeric item number.

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

mnComponentItem 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

cSuppressErrorMessages EV01 char NONE NONE

An option that specifies the type of processing for an event.

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.

szProgramID PID char NONE NONE

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

Related Functions

B9800100 Get Audit Information

Related Tables

F3002 Bill of Material Master File

F4101 Item Master

F4102 Item Branch File

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szParentBranch	MMCU	char	NONE	NONE
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which represent lower-level business units, subordinate to it. For example: o Branch/Plant (MMCU) o Dept A (MCU) o Dept B (MCU) o Job 123 (MCU) Business unit security is based on the higher-level business unit.
mnParentItem	KIT	MATH_NUMERIC	NONE	NONE
The system provides for three separate item numbers. 1. Item Number (short) - An eight-digit, computer assigned, completely non-significant item number. 2. 2nd Item Number - The 25-digit, free form, user defined alphanumeric item number. 3. 3rd Item Number - Another 25-digit, free form, user defined alphanumeric item number.
szComponentBranch	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)
mnComponentItem	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
cSuppressErrorMessages	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
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.
szProgramID	PID	char	NONE	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.

F3002 Bill of Material Master File
F4101 Item Master
F4102 Item Branch File