F3462UpdateForcstShpmntSummyRec

F3462Update Forecast Shipment Summary Record

Minor Business Rule

Object Name: N3401380

Parent DLL: CALLBSFN

Location: Client/Server

Language: NER

1.Functional Description

This function will first try to find out if a F3462 Forecast Shipment Summary record exists
for given short Item, Business Unit and Promised Delivery Date. If a record is found , then It
will update the Transaction Quantity field otherwise it will just insert a new record.

1.1Purpose
For an item with planning fence rule of  "H" and with valid  document  type ( exists in  UDC
40/CF) ,
      this business function  will add a record to F3462  Forecast Summary File when a  record is not
found
      for given promised delivery date . If there is a record then it will update the quantity
ordered field
      with a new one.

1.2Setup Notes and Prerequisites

1.3Special Logic

2.Technical Specifications

2.4Processing

1.0   ADD mnQuatityShipped and mnQuantityOrdered to mnTransactionQuantity

1.1Fetch F3462 with mnShortItemNumber, szBusinessUnit, jdPromisedDeliveryDate to know if a

        record exists  .
1.2  if a record not found


   else

Data Structure

D3401380 - Data Structure for N3401380

Data Item Data Structure DescriptionI/ORequiredNotes
ITM            MnShortItemNumber                  IY
LITM            MnThirdItemNumber                  IY
AITM            MnSecondItemNumber            IY
MCU            SzBusinessUnit                  IY
CO             SzCompany                        IY
SOQS            MnQuantityShipped                  IY
UORG            MnQuantityOrdered                  IY
PDDJ            JdPromisedDeliveryDate            IY
PID            SzProgramID                        IY
UPMJ            MnTimeUpdated                  IY
TDAY            MnTimeofDay                        IY
USER            SzUser                        IY
JOBN            SzWorkStationID                  IY

^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szIdentifier3rdItem	AITM	char	OPT	INPUT
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item numbers are as follows: 1. Item Number (short) - An 8-digit, computer-assigned 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. In addition to these three basic item numbers, an extensive cross-reference search capability has been provided (see XRT). Numerous cross references to alternate part numbers can be user defined, such as substitute item numbers, replacements, bar codes, customer numbers, or supplier numbers.
szIdentifier2ndItem	LITM	char	OPT	INPUT
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to alternative item numbers. The three types of item numbers are: Item Number (short) An 8-digit, computer-assigned item number. 2nd Item Number A 25-digit, user defined, alphanumeric item number. 3rd Item Number Another 25-digit, user defined, alphanumeric item number. In addition to these three basic item numbers, the system provides an extensive cross-reference search capability. You can define numerous cross-references to alternative part numbers. For example, you can define substitute item numbers, replacements, bar codes, customer numbers, or supplier numbers.
mnIdentifierShortItem	ITM	MATH_NUMERIC	OPT	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.
szCompany	CO	char	OPT	INPUT
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
mnUnitsQuantityShipped	SOQS	MATH_NUMERIC	OPT	INPUT
The number of units committed for shipment in Sales Order Entry, using either the entered or the primary unit of measure defined for this item. In the Manufacturing system and Work Order Time Entry, this field can indicate completed or scrapped quantities. The quantity type is determined by the type code entered.
mnUnitsTransactionQty	UORG	MATH_NUMERIC	OPT	INPUT
The quantity of units affected by this transaction.
jdPromisedDeliveryDate	PDDJ	JDEDATE	OPT	INPUT
The promised shipment date for either a sales order or purchase order. The Supply and Demand Programs use this date to calculate Available to Promise information. This value can be automatically calculated during sales order entry. This date represents the day that the item can be shipped from the warehouse.
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.
jdDateUpdated	UPMJ	JDEDATE	OPT	INPUT
The date that specifies the last update to the file record.
mnTimeOfDay	TDAY	MATH_NUMERIC	OPT	INPUT
The computer clock in hours:minutes:seconds.
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.

Related Functions

None

Related Tables

None