Functional Description
Purpose
This function retreives P.O. Ledger Detail table.
By Line Number, the function has to return to the calling
application, the last updated record with a Change Order less or equal to the one passed into input
parameters.
The Change Order, Line Number, Item, Quantity, Unit of Measure, Extend Amount, Currency fields and
Line Type are to be returned to the calling application.
Technical Specification
2.4Processing
The Business Function should select by Line Number (LNID), the record from the F43199 table with the
most recent Date Updated and Time Updated, with a Change Order (CORD, in descending order ) less or
equal than the one requested, using the following key : F43199 'f0DOCO, DCTO, KCOO, SFXO, LNID,LT.
If no records are found meeting the selection criteria set the NoRecordsFound return code on ('1').
Eg :
In the F43199 there are 10 records for Order 2974/OP :
DOCO DCTO KCOO SFXO LNID CORD LT USER UPMJ TDAY
---------- -------- --------- ------- ------- -------- ----
-------------- ---------- ---------
Line 1 : 2974 OP 00100 000 1000 000 CO PV919092 95.139
121223
Line 2 : 2974 OP 00100 000 1000 001 CO PV919092 95.145
161457
Line 3 : 2974 OP 00100 000 1000 003 CO PV919092 95.152
162422
Line 4 : 2974 OP 00100 000 1000 004 CO PV919092 95.152
162533
Line 5 : 2974 OP 00100 000 1000 006 CO PV919092 95.164
92346
Line 6 : 2974 OP 00100 000 1000 008 CO PV919092 95.164
114501
Line 7 : 2974 OP 00100 000 2000 000 CO PV919092 95.139
121228
Line 8 : 2974 OP 00100 000 3000 000 CO PV919092 95.156
101200
Line 9 : 2974 OP 00100 000 4000 007 CO PV919092 95.164
102014
Line 10 : 2974 OP 00100 000 4000 009 CO PV919092 95.164
104644
Process :
Access to F43199 table with the key : DOCO, DCTO, KCOO, SFXO, LNID, LT(='CO').
Multiple records should be selected with this key
Select records with F43199 CORD 'a3 Input parm CORD ordered by CORD in descending mode.
From the first record selected , return : CORD, LNID, LT, ITM, LITM, AITM, ANI, UORG,
UOM, CRCD, CRR, AEXP, FEA, LNTY.
Attended Result : CORD Input parameter = 005
Input Parameters which define the keyRecord to be returned
DOCO/DCTO/KCOO/SFXO/LNID/LT
2974 / OP /00100/ 000 /1.000/COLine 4
2974 / OP /00100/ 000 /2.000/COLine 7
2974 / OP /00100/ 000 /3.000/COLine 8
2974 / OP /00100/ 000 /4.000/CONot returned because CORD > 005
D4300300B - Get PO Change Order
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
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
| ||||
szOrderCompany | 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
| ||||
mnChangeOrder | CORD | MATH_NUMERIC | NONE | NONE |
The number of times this purchase order has been modified. You can locate a specific change order number to review the fields that were
| ||||
szUserId | USER | char | NONE | NONE |
The code that identifies a user profile. | ||||
jdDateUpdated | UPMJ | JDEDATE | NONE | NONE |
The date that specifies the last update to the file record. | ||||
szLedgerType | LT | char | NONE | NONE |
A user defined code (09/LT) that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You
|
None |
F4311 Purchase Order Detail File | ||||
F43199 P.O. Detail Ledger File - Flexible Version |