1.Functional Description
This business function will get Active Receipt Routing Records Sequentially for a given Routing flag,
Update Bucket, Order Number, Order Type, Key Company, Order Suffix and Line Number. It will select
only those records which have Outstanding Quantity.
1.1Purpose
This function is used to obtain data from the F43092 table for calculating Open Order Quantity for
Supply and Demand Inquiry. The function will return Error codes.
1.2Setup Notes and Prerequisites
In order to shorten the processing time, the table will be kept open until the request is released.
The Mode must as follows.
1. The first time the function is called, the Mode must be set to '1' in Order to Open the Table.
2. To select records in the table, the Mode must be '2'.
3. To read and get the open quantity, the Mode must be '3'.
4. To kill the Request, the Mode must be Set to '4'.
5. If the Summary flag = '1', The Mode cannot be '3'. It Must be '1' or '2' or '4'
1.3Special Logic
If the Input Mode is '1', Open the table and Store the Request and User in global variables. If the
Mode is '2', the records will be selected. If Mode is '3', the rows will be read sequentially. If the
Mode is '4', Kill and Release the request.
2.Technical Specifications
The following actions have to be performed by the Business Function.
1.If Mode = '1'
Open the F43092 table and Store the RequestID & User in Global Variables
If Unable to Open the Request
Kill Request, Set Error Code to '1' and Exit the function
Endif
Endif
2.If Mode = '2'
Select records using the Input Keys from the F43092 table with Quantity (QTYO) > 0
If Selection fails
Error Code = '2'. Exit the function
Else
Mode = '3'
Endif
Endif
3. If Mode = '3'
If Summary flag = '1'
While not end of file
Read the F43092 records sequentially using all Input keys until end
of file
If found
If PXUOM <> Input UOM
Convert PXQTYO into Input UOM using B4000520 TFLA, STDP,
OT1Y
Else
Converted Qty = PXQTYO
Endif
Outstanding Qty= Outstand Qty + Converted Qty
Operation Code = blanks
Endif
EndWhile
Error Code = '2'
Else
Read the F43092 records sequentially using all Input keys
If not end of file
If PXUOM <> Input UOM
Convert PXQTYO into Input UOM using B4000520, using TFLA,
STDP, OT1Y
Else
Converted Qty = PXQTYO
Endif
Output Qty Outstanding = Converted Qty
Operation Code = PXOPRC
Else
Error Code = '2'
Endif
Endif
Endif
4.If Mode = 4
Release and Kill the Request
Endif
^
D3400300 - Get Receipt Routing Data
Data Item Data Structure DescriptionI/ORequiredNotes
RTGC Routing flag IY
UPIB Update Bucket IY
DOCO Order Number IY
DCTO Order Type IY
KCOO Key Company I Default = '00000'
SFXO Order Suffix I Default = ' '
LNID Line Number I Default = blanks
UOM Input Unit of Measure I
EV01 Summary flag I 1- Summarise the Qty Open ' '
- Get Indiv Row Qty
EV02 Mode IY 1 - Open Table 2 - Select
Rows and Get Data 3 - Get Next
Row Data 4 - Release and Kill
Request
EV03 Suppress Error Message I ' ' - Display Errors '1' -
Suppress Error Messages
EV04 Error Code O '0' - Success (Default) '1' -
Open Table failed '2' - End
of file reached
DTAI Error Message ID O Blanks - Success '3143' -
Errors
QTYO Outstanding Quantity O Quantity from F43092 in Input
UOM
OPRC Operation Code O PXOPRC
STDP Standard Potency IY For std potency processing
OT1Y Potency Control IY For std potency processing
TFLA Std UOM Conversion IY Required for UOM Conversion
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cRoutingFlag | RTGC | char | NONE | NONE |
Inidcates if the receipt transaction is in or through the purchase order routing process. Valid values are:
Y Transaction is in or has been
| ||||
szUpdateBucket | UPIB | char | NONE | NONE |
Indicates which quantity field in the Item Location table that the system updates when quantity is moved from one receipt routing operation
| ||||
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
| ||||
szKeyCompany | 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
| ||||
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
| ||||
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
| ||||
cSummaryFlag | 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. | ||||
cSuppressErrorMessage | 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,
| ||||
cErrorCode | EV04 | char | NONE | NONE |
PeopleSoft event point processing flag 04. | ||||
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
| ||||
mnOutstandingQuantity | QTYO | MATH_NUMERIC | NONE | NONE |
The number of units currently at this operation. | ||||
szInputUnitOfMeasure | UOM | char | NONE | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
szOperationCode | OPRC | char | NONE | NONE |
A user defined code (43/OC) that represents an operation or step within the receipt route. | ||||
mnStandardPotency | STDP | MATH_NUMERIC | NONE | NONE |
The percentage of active ingredients normally found in an item. | ||||
cPotencyControl | OT1Y | char | NONE | NONE |
A code that indicates whether you control the item by potency. | ||||
szStandardUOMConversion | TFLA | char | NONE | NONE |
Allows you to bypass the item-specific unit of measure and use the standard unit of measure. Valid values are:
blank Use the item-specific
| ||||
mnIdentifierShortItem | ITM | MATH_NUMERIC | OPT | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
hRequestF43092 | GENLN3 | ID | REQ | NONE |
General purpose ID variable. |
B4000460 Free Ptr To Data Structure | ||||
B4000520 Get Item UoM Conversion Factor |
F43092 Purchase Order Receipt Routing File |