Functional Description
Purpose
This function is used to store information about a movement or disposition before the information is
written to the application tables.
Setup Notes and Prerequisites
None
Special Logic
This function uses a cache to store the movement or disposition information. A disposition is noted
by putting a '1' in the Disposition Flag (DISF) parameter.
The modes are as follows:
1Add/Update
2Get/Get Next
8Delete entire cache
9Delete specific record
The entire cache key is Computer ID (CTID), Job Number (JOBS), Disposition Flag (DISF), Order Number
(DOCO), Order Type (DCTO), Order Company (KCOO), Order Suffix (SFXO), Line Number (LNID), Receipt Line
Number (NLIN), Unit of Measure (UOM), Operation Sequence (OPRS), and Operation Sequence To(OSTO).
Technical Specification
If mode = '1'
Check if record is already in cache
If it is,
Update record in cache
Otherwise,
Add record to cache
If mode = '2'
If we do not have a valid cursor,
Open a cursor
Else
Restore the cursor
Get the next record matching the keys of Computer ID and Job Number
If mode = '8'
Delete all records in cache matching Computer ID and Job Number
If mode = '9'
Delete the record matching the cache key
D4301600 - F43092Z Receipt Routing Cache
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szComputerID | CTID | char | OPT | NONE |
mnJobNumber | JOBS | MATH_NUMERIC | OPT | NONE |
Special Input Expected
| ||||
szUserID | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
szProgramID | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
mnOrderNumber | DOCO | MATH_NUMERIC | OPT | 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 | OPT | 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
| ||||
szOrderCompany | KCOO | char | OPT | 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 | OPT | 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
| ||||
mnOrderLineNumber | LNID | MATH_NUMERIC | OPT | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
mnNumberOfLines | NLIN | MATH_NUMERIC | OPT | NONE |
A number representing the number of lines on either a purchase or sales order.
or The number of receivers recorded during the receipts
| ||||
szUOMFrom | UOM | char | OPT | 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). | ||||
mnOperationSequenceFrom | OPRS | MATH_NUMERIC | OPT | NONE |
The sequence in which the system performs the operations or steps of the route. | ||||
cReverseDispositionFlag | RVS | char | OPT | NONE |
A code that indicates whether the transaction is eligible for reversal or has already been reversed.
Valid values are:
Blank Transaction is
| ||||
mnBatchNumber | ICU | MATH_NUMERIC | OPT | NONE |
A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
| ||||
szBatchType | ICUT | char | OPT | NONE |
A code that specifies the system and type of transactions entered in a batch. The system assigns the value when you enter a transaction.
| ||||
cBatchStatus | BST | char | OPT | NONE |
A code that indicates whether a batch of transactions has been posted, is ready to post, is still open for entry, and so on. | ||||
jdBatchDate | DICJ | JDEDATE | OPT | NONE |
The date of the batch. If you leave this field blank, the system date is used. | ||||
jdGLDate | DGL | JDEDATE | OPT | NONE |
A date that identifies the financial period to which the transaction is to be posted.
The company constants specify the date range for each
| ||||
jdReceiptDate | RCDJ | JDEDATE | OPT | NONE |
The date you received this purchase order line. | ||||
cCurrencyMode | CRRM | char | OPT | NONE |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
mnTrnToPrimaryCnvFactor | CNV1 | MATH_NUMERIC | OPT | NONE |
The mathematical relationship showing the conversion between the primary and secondary units of measure. | ||||
mnPrchToPrimaryCnvFactor | CNV2 | MATH_NUMERIC | OPT | NONE |
The mathematical relationship showing the conversion between the primary and purchasing units of measure. | ||||
mnQuantityToMove | QTYM | MATH_NUMERIC | OPT | NONE |
The number of units that have been either moved or dispositioned. | ||||
mnQuantityAtOperation | QTYO | MATH_NUMERIC | OPT | NONE |
The number of units currently at this operation. | ||||
mnQuantityAdjusted | QTYA | MATH_NUMERIC | OPT | NONE |
The number of units that you adjusted during the receipt routing. | ||||
mnQuantityRejected | QTYJ | MATH_NUMERIC | OPT | NONE |
The number of units that you rejected during receipt routing. | ||||
mnQuantityReturned | QTYR | MATH_NUMERIC | OPT | NONE |
The number of units that you returned to the supplier through receipt routing.
You can return goods for credit or for replacement. The system
| ||||
mnQuantityReworked | QTYW | MATH_NUMERIC | OPT | NONE |
The number of units that will be reworked as a result of receipt routing. | ||||
mnQuantityScrapped | QTYC | MATH_NUMERIC | OPT | NONE |
The number of units that you scrapped during receipt routing. | ||||
szAdjustedReasonCode | RCD | char | OPT | NONE |
A user defined code (42/RC) that explains the purpose for a transaction. For example, you can indicate the reason that you are returning
| ||||
szRejectedReasonCode | RCDOW1 | char | OPT | NONE |
A user defined code (system 42/type RC) that explains the purpose for a transaction. For example, you can use a code to indicate a
| ||||
szReturnedReasonCode | RCDOW2 | char | OPT | NONE |
A user defined code (system 42/type RC) that explains the purpose for a transaction. For example, you can use a code to indicate a
| ||||
szReworkedReasonCode | RCDOW3 | char | OPT | NONE |
A user defined code (system 42/type RC) that explains the purpose for a transaction. For example, you can use a code to indicate a
| ||||
szScrappedReasonCode | RCDOW4 | char | OPT | NONE |
A user defined code (system 42/type RC) that explains the purpose for a transaction. For example, you can use a code to indicate a
| ||||
cReplaceDispositionAdj | RPL | char | OPT | NONE |
A code that indicates whether you want to replace the items that you are returning. Valid values are:
Y Replace the items. The system
| ||||
cReplaceDispositionRej | RPLOW1 | char | OPT | NONE |
This code is used in receipt routing and indicates whether the returned items should be replaced. Valid values are:
Y Replace the items.
| ||||
cReplaceDispositionRet | RPLOW2 | char | OPT | NONE |
This code is used in receipt routing and indicates whether the returned items should be replaced. Valid values are:
Y Replace the items.
| ||||
cReplaceDispositionRew | RPLOW3 | char | OPT | NONE |
This code is used in receipt routing and indicates whether the returned items should be replaced. Valid values are:
Y Replace the items.
| ||||
cReplaceDispositionScr | RPLOW4 | char | OPT | NONE |
This code is used in receipt routing and indicates whether the returned items should be replaced. Valid values are:
Y Replace the items.
| ||||
mnDocumentNumber | DOC | MATH_NUMERIC | OPT | NONE |
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document
| ||||
mnOperationSequenceTo | OSTO | MATH_NUMERIC | OPT | NONE |
The sequence in which the system performs the operations or steps of the route. | ||||
szOperationCodeFrom | OPRC | char | OPT | NONE |
A user defined code (43/OC) that represents an operation or step within the receipt route. | ||||
szOperationCodeTo | OPRT | char | OPT | NONE |
A user defined code (43/OC) that identifies the routing operation or step to which items were moved. | ||||
mnShortItemNumber | 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
| ||||
jdLedgerDate | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
mnLedgerTime | TDAY | MATH_NUMERIC | OPT | NONE |
The computer clock in hours:minutes:seconds. | ||||
mnPOLineNumber | POLN | MATH_NUMERIC | OPT | NONE |
A number that indicates the line number that was added to a purchase order when goods were returned to the supplier. | ||||
cMode | MODE | char | OPT | NONE |
Significant Data Values
| ||||
idF43092ZCacheDataPointer | GENLNG | ID | OPT | NONE |
Special Input Expected
| ||||
cDispositionFlag | DISF | char | OPT | NONE |
Significant Data Values
| ||||
cGLEditLineProcessedFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnPOProcessID | PEID | MATH_NUMERIC | OPT | NONE |
A code that identifies the Inter-Process Communication ID. | ||||
mnPOTransactionID | TCID | MATH_NUMERIC | OPT | NONE |
mnQuantityOnCreditPO | QTY | MATH_NUMERIC | OPT | NONE |
The number of units associated with an asset. | ||||
mnRcvdNotVchrdJE | JEL5 | MATH_NUMERIC | OPT | NONE |
A number that designates a line within a journal entry. The system uses this field to sequence the journal entry for inquiry purposes. | ||||
mnRoutingOperJE | JEL0 | MATH_NUMERIC | OPT | NONE |
A number that designates a line within a journal entry. The system uses this field to sequence the journal entry for inquiry purposes. | ||||
mnProrRecptJE | JELNNMBR | MATH_NUMERIC | OPT | NONE |
The line number of a row in the general ledger. | ||||
mnAPTradeJE | JELE | MATH_NUMERIC | OPT | NONE |
A number that identifies a line within a journal entry. The system uses this number to sequence the journal entry for inquiry purposes. | ||||
mnNumberKeys | NKEYS | MATH_NUMERIC | OPT | NONE |
The number of keys in an index that will be used to retrieve, delete, or update a record. | ||||
szRecNotVoucherAcct_VANI | VANI | char | OPT | NONE |
This is the received not vouchered account number associated with the PO Receiver table (F43121). |
None |
F43092Z Receipt Routing Work File |