LeadtimeRollup

Leadtime Rollup

Major Business Rule

Object Name: N3003320

Parent DLL: CMFGBASE

Location: Client/Server

Language: NER

1.Functional Description

1.1Purpose
This function takes the item number, passed in data structure as input, and checks whether the item is Co/By. If an item is not Co/By, its parent(s) is/are
fetched from Bill Of Material Table F3002 and Leadtime Manufacturing and Leadtime Cumulative values are calculated for the parent. If the new calculated
values are greater than the values already in Item/Branch Table F4102, the record is updated in F4102. In case of a Co/By item, process information is
retrieved for the item and Leadtime values for item are updated using process Leadtime information..

The function uses "Branch/Plant" and "AsOfDate" supplied by user in the input data structure. The AsOfDate is used to validate the effectivity of that
record. A blank value of AsOfDate defaults to today's date. If the Branch/Plant field is blank then function updates all Branch/Plants that contain the item
in input data structure.

1.2Setup Notes and Prerequisites
This function is expected to be used in conjunction with "Leadtime Calculation" (N3003300). See the description for N3003300 for more information.

2.4Processing (N3003320 Leadtime Rollup)

0. Look for the Branch/Plant value passed from processing options. If the value is a blank or "*", open F4102 and sequentially read all the records for
given item number. The following processing is done for all the records fetched from F4102. If a Branch/Plant value is found in processing options, only the
record for that Item/Branch is fetched and processed.

1. Look in Table F3002 to see whether the item is specified as a Co/By Product.

2. If the item is not specified as a Co/By Product.

a)Retrieve parent records for the item from Bill Of Material Table F3002. Get Leadtime values for the parent from Item Branch F4102.
b)For each parent item, calculate Leadtime Manufacturing and Leadtime Cumulative Values. (Calculation details are in "Leadtime Rollup"
specifications document.)
c)If the calculated Leadtime values are greater than the values already in F4102 record, update F4102 record. MRP Net Change Flag is set.

3. If the item is specified as a Co/By Item.

a)Item's associated process is retrieved from F3002.
b)Manufacturing data for the process item is obtained from F4102.
c)The process manufacturing data is used to calculate Leadtime Values for the item. (Calculation details are in "Leadtime Rollup" specifications
document.)
d)Item manufacturing information is updated in Item Branch Table F4102. MRP Net Change Flag is set.

Data Structure

D3003320 - Leadtime Rollup

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnIdentifierShortItem	ITM	MATH_NUMERIC	REQ	INPUT
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
szCostCenter	MCU	char	OPT	INPUT
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.
jdAsOfDate	ASDE1	JDEDATE	OPT	INPUT
The date used for effectivity checking. Enter a specific date to display documents (orders, bills of material, routings, as applicable) that are effective on or after that date. The current system date is the default, but you can enter any future or past date.
idMessage_GENLNG	GENLNG	ID	OPT	INPUT
General purpose ID variable.
szUserId	USER	char	OPT	INPUT
The code that identifies a user profile.
szWorkStationId	JOBN	char	OPT	INPUT
The code that identifies the work station ID that executed a particular job.
jdDateToday	ASDE1	JDEDATE	OPT	INPUT
The date used for effectivity checking. Enter a specific date to display documents (orders, bills of material, routings, as applicable) that are effective on or after that date. The current system date is the default, but you can enter any future or past date.
mnTimeOfDay	TDAY	MATH_NUMERIC	OPT	INPUT
The computer clock in hours:minutes:seconds.
szProgramId	PID	char	OPT	INPUT
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.
cPOQueueHoursFlag	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.

Related Functions

None

Related Tables

None