1.Functional Description
1.1Purpose
This function will retrieve the data selection from the R4211DC, set the same data selection over the
F42119 and return F42119 records to the R4211DC.
1.2Setup Notes and Prerequisites
This function has been hard coded to retrieve the data selection from R4211DC only. It must be
called from the Sales Order Detail (V4211B) init section of R4211DC in mode '1' in order to retrieve the
data selection.
1.3Special Logic
2.Technical Specifications
2.1Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
ERRCError CodeON'0' No error '1' Fetch failed or other error
VERSVersionINReport Version to retrieve data selection from
EV01ModeIY
PIDProgram IDIYName of calling report
GENLNGPointerI/OYTable handle for sequential fetches
KCOOKey CompanyONKey to F42119
DOCODocument NumberONKey to F42119
DCTOOrder TypeONKey to F42119
LNIDLine NumberONKey to F42119
DTAIError Message IDO N
UOMUnit of MeasureON
MCUBusiness UnitON
ITMShort Item NumberON
CRCDCurrency CodeON
MATH01Section IDINIdentifies the section from which to retrieve
data selection
DTFRDate FromINData selection appended to select records with
Dates greater than or equal to From Date
DTTODate ThruINData selection appended to select records with
Dates less than or equal to Thru Date
DT17Date Data ItemINThe type of date to use to append data
selection
2.2Related Tables
Table Table Description
F4211Sales Order Detail
F42119Sales Order History
2.3Related Business Functions
None
2.4Processing
Error Code = '0'
If Mode = '1'
Retrieve data selection (K2GetDataSelection)
If successful
Open F42119
If successful
For number of select structures returned by K2GetDataSelection
Select structure table = "F42119"
End For
If From Date and Thru Date are not blank
If Date Data Item is blank
Date Data Item = "DRQJ"
End If
Set Selection over F42119
If successful
Select Keyed using blank Key 1 for F42119
If successful
Pointer = jdeStoreDataPtr
End If
End If
End If
If Mode = '2'
If Pointer is not zero
JdeRetrieveDataPtr
F42119 Fetch
If successful
Load data structure
End If
End If
End If
If error or Mode = '3'
If Pointer is not zero
jdeRemoveDataPtr
Pointer = '0'
Close F42119
End If
End If
If error
Error Code = '1'
End If
^
D1600240 - Set F4211 Data Selection for F42119
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cErrorCode | ERRC | char | OPT | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
szVersion | VERS | char | OPT | NONE |
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
| ||||
cMode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
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
| ||||
idPointer | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
szKeyCompany | 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
| ||||
mnDocumentNumber | 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
| ||||
mnLineNumber | 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
| ||||
szErrorMessageID | DTAI | char | OPT | 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
| ||||
szUnitOfMeasure | 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). | ||||
szBusinessUnit | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
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
| ||||
szCurrencyCodeFrom | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
mnSectionID | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. | ||||
jdDateFrom | DTFR | JDEDATE | OPT | NONE |
The beginning date for which the transaction or code is applicable. | ||||
jdDateThru | DTTO | JDEDATE | OPT | NONE |
The ending date for which the transaction or code is applicable. | ||||
szDateDataItem | DTI7 | char | OPT | NONE |
The name of a data item. In driver calculations, the field must be completed with a data item that represents a date. |
None |
F4211 Sales Order Detail File | ||||
F42119 Sales Order History File |