1.Functional Description
This function is to be used to get Message Details from F3411 for an item or group of items, based
on filters for an Item/Branch in F4102. The function will pass filtering fields to F4102, find the
appropriate Items in the Branch that meet those filtering criteria, then get all the details of each
record from F3411 for that specific Item/Branch combination. (see parameters below).
1.1Purpose
The purpose of this business function is to match filtering criteria with specificItems in a Branch,
then search the Detail Message F3411 for messages for that Item/Branch, returning the message
record(s) to the P3411 Find/Browse form. The message detail will be passed back to the P3411 Find/Browse grid
rows, one item's messages per row. Further filtering may be done in the F3411, but the normal
OneWorld QBE tool will accomplish that additional filtering
1.2Setup Notes and Prerequisites
None
1.3Special Logic
This business function will first search F4102 to find the Items as filtered by Branch and other
F4102 fields. The Branch/Plant may be input as either MCU (Data Item Business Unit = Demand Branch in
F3411) or MMCU (Data Item Branch = Supply Branch in F3411). The business function will have to recognize
that either MCU or MMCU should be matched to MCU in the Item/Branch F4102. Once the Items are found,
it will retrieve all data items in F3411 for the identified Item/Branch.
2.Technical Specifications
Clear Output Parameters
if Mode = 0Open Tables Mode
/* Open Tables */
Open files F4102, F3411
if open table not successful
set error messages
Mode = 2
else
Mode = 1
/* Initialize Values */
Set Global Table Flag = 0
Short Item Number = 0
Set F4102 Index ID to Key 5 for default to open table
/* Initialize Branch/Plant value, set up search parameters */
If incoming Demand Branch MCU > blank
set IPMCU = incoming MCU
set MMMCU = incoming MCU
set Global Branch Flag = 'D'
set up F3411 Key 5
else if incoming Supply Branch MMCU > blank
set IPMCU = incoming MMCU
set MMMMCU = incoming MMCU
set Global Branch Flag = 'S'
set up F3411 Key 6
else
set error messages -- branch plant required
Mode = 2
/* Evaluate Input Values */
Wk Value = -1
if Planning Code MPST != ' '
Wk Value = 1
else
Wk Value = 0
if Buyer BUYR != 0
Wk Value = Wk Value + 10
if Planner ANPL != 0
Wk Value = Wk Value + 100
if Master Planning Family PRP4 != blanks
Wk Value = Wk Value + 1000
if Wk Value > 0/* error checking */
/*All Fetches include Branch mcu */
/* Determine KeySelect */
(use Key 5)Case Wk Value = 1000 (prp4)
Number of Keys = 2
Which Select = 5
Case Wk Value == 1001 (prp4, mpst)
Number of Keys = 3
Which Select = 5
(use Key 6)
Case Wk Value == 100 (anpl)
Number of Keys = 2
Which Select = 6
Case Wk Value == 1100(anpl, prp4)
Number of Keys = 3
Which Select = 6
Case Wk Value == 1101 (anpl, prp4, mpst)
Number of Keys = 4
Which Select = 6
(use Key 7)
Case Wk Value == 10 (buyr)
Number of Keys = 2
Which Select = 7
Case Wk Value == 1010 (buyr, prp4)
Number of Keys = 3
Which Select = 7
Case Wk Value == 1011 (buyr, prp4, mpst)
Number of Keys = 4
Which Select = 7
(use Select 1)
Case Wk Value == 1( mpst)
Number of Keys = 1
Which Select = 1
Case Wk Value == 11 (mpst, buyr)
Number of Keys = 2
Which Select = 1
Case Wk Value == 111 (mspt, buyr, anpl)
Number of Keys = 3
Which Select = 1
Case Wk Value == 1111 (mpst, buyr, anpl, prp4)
Number of Keys = 4
Which Select = 1
(use Select 2)
Case Wk Value == 110 (anpl, buyr)
Number of Keys = 2
Which Select = 2
Case Wk Value == 1110 (anpl, buyr, prp4)
Number of Keys = 3
Which Select = 2
(use Select 3)
Case Wk Value == 101 (mpst, anpl)
Number of Keys = 2
Which Select = 3
Default
Number of Keys = -1
F4102 Index ID = Null
if Which Select > 0 /* success */
if Which Select = 5
set F4102 Key 5
else if Which Select = 6
set F4102 Key 6
else if Which Select = 7
set F4102 Key 7
else
set up select structure
if Mode == 2
set errors and return
else /* get first record */
switch Which Select
case 5:
Copy Input values into fetch structure (TempBranch, Master Planning
Family, Planning Code)
Fetch Record
case 6:
Copy Input values into fetch structure (TempBranch, Master Planning
Family,Planning Code, Planner)
Fetch Record
case 7:
Copy Input values into fetch structure (TempBranch, Master Planning
Family,Planning Code, Buyer)
Fetch Record
default: /* select structure */
Fetch Record
if Fetch Fails
set Mode = 2
else
copy retrieved Short Item Number from the F4102 to the Output parameter
set Mode = 1
if Global Branch Flag == D
MMMCU = Demand Branch
F3411 Fetch Structure Short Item Number = Short Item Number
Fetch Record from F3411
Else
MMMMCU = Supply Branch
F3411 Fetch Structure Short Item Number = Short Item Number
Fetch Record from F3411
if fetch fails
set Global Table = 0 /* get next item number from F4102 */
else
Exit Flag = 1/* return to app */
Table Flag = 1/* set up fro next fetch on F3411 */
Load Output Parameters
End Mode 0
if Mode = 1
while wk exit flag = 0
if Global Table Flag = 0
/* Get Item Number */
Fetch item number from F4102 using incoming search parameters
if fetch fails
wk exit flag = 1 - all records read for incoming values
Mode = 2
else
MMITM = IBITM
if Branch Flag = D
MMMCU = Demand Branch
F3411 Fetch Structure Short Item Number = Short Item
Number
Fetch Record from F3411
Else
MMMMCU = Supply Branch
F3411 Fetch Structure Short Item Number = Short Item
Number
Fetch Record from F3411
if Fetch Fails
Global Table flag = 0/* get next item number from
F4102 */
else
Exit Flag = 1/* exit while loop */
Global Table Flag = 1/* set for next fetch on F3411 */
Load Output Parameters
End Global Table Flag = 0
else/* subsequent calls to F3411 */
Fetch record from F3411 using item number, branch/plant
if fetch fails
set Global Table Flag = 0 - all records read for given item
number
else
wk exit flag = 1 - record retrieved
Load Output Parameters
end while
End Mode 1
if Mode == 2 Close Program
Clear Output Parameters
Close Files
Memory Cleanup
End Mode 2
End Processing
^
D3400510 - Get Message Detail
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
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
| ||||
szDemandBranch | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szSupplyBranch | 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
| ||||
cPlanningCode | MPST | char | NONE | NONE |
A code that indicates how Master Production Schedule (MPS), Material Requirements Planning (MRP), or Distribution Requirements
| ||||
mnBuyer | BUYR | MATH_NUMERIC | NONE | NONE |
The address number of the person responsible for setting up and maintaining the correct stocking levels for the item. | ||||
mnPlanner | ANPL | MATH_NUMERIC | NONE | NONE |
The address number of the material planner for this item. | ||||
szMasterPlanningFamily | PRP4 | char | NONE | NONE |
A user defined code (41/P4) that represents an item property type or classification, such as commodity type or planning family. The system
| ||||
cSuppressErrorMessages | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cMode | EV02 | 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
| ||||
cMessageType | MSGT | char | NONE | NONE |
A code that distinguishes different messages generated in the Distribution Requirements Planning/Master Production Schedule/Material
| ||||
szDescription | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
mnQuantityAvailable | TRQT | MATH_NUMERIC | NONE | NONE |
A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and
| ||||
mnOrderNumber | DOCO | MATH_NUMERIC | NONE | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szOrderType | DCTO | char | NONE | NONE |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
jdDateRequested | DRQJ | JDEDATE | NONE | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
jdDateStart | STRT | JDEDATE | NONE | NONE |
The start date for the order. You can enter this date manually, or have the system calculate it using a backscheduling routine. The routine
| ||||
jdDateRecommendedStart | RSTJ | JDEDATE | NONE | NONE |
The recommended start date for an order. | ||||
jdDateRecommendedComplet | RRQJ | JDEDATE | NONE | NONE |
The completion date planned for this order. | ||||
cHoldCode | HCLD | char | NONE | NONE |
A code that is used in Distribution Requirements Planning/Master Production Schedule/Material Requirements Planning and capacity
| ||||
mnVendor | VEND | MATH_NUMERIC | NONE | NONE |
The address book number of the preferred provider of this item. | ||||
mnUniqueKey | UKID | MATH_NUMERIC | NONE | NONE |
This field is a unique number used to identify a record in a file. | ||||
cCleared | MSGA | char | NONE | NONE |
A code to indicate which messages should be displayed.
A Y code will display all messages, including those that have been cleared or
| ||||
szCompany | KCOO | char | NONE | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
mnLineNumber | LNID | MATH_NUMERIC | NONE | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
szOrderSuffix | SFXO | char | NONE | NONE |
In the A/R and A/P systems, a code that corresponds to the pay item. In the Sales Order and Procurement systems, this code identifies
| ||||
cTableFlag | EV03 | char | NONE | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
cBranchFlag | EV04 | char | NONE | NONE |
PeopleSoft event point processing flag 04. | ||||
nNumberOfKeys | INT02 | integer | NONE | NONE |
Number of Days in the Past to Query for Quote Requests Received. | ||||
nWhichSelect | INT03 | integer | NONE | NONE |
Event point for Integer. | ||||
idF4102IndexID | GENLN3 | ID | NONE | NONE |
General purpose ID variable. | ||||
hRequestF3411 | GENLN3 | ID | OPT | NONE |
General purpose ID variable. | ||||
hRequestF4102 | GENLN3 | ID | OPT | NONE |
General purpose ID variable. |
None |
None |