1.Functional Description
This business function will get all the ECO Parts List Records from the F3013 table for a given
Index/Key number combination. This BSFN will provide records by either full key or partial key.
The first time the function is called, pass a '1' in the Type parameter so the Request is not
released.
To get the next value in the table, pass a '2' in the Type parameter. To release the request, pass a
'3' in the Type parameter.
Index: Pass in the number that identifies the index used to fetch the record.
Suppress Error Message: 1=Suppress runtime error message handling, 0=Allow runtime error
message handling.
This business function will get the next ECO Parts List Record by Index/Key number combination and
have capability to provide records by either Full key or Partial Key, It will have capability to provide
user with field values of every record.
1.2Setup Notes and Prerequisites
Set on "Suppress Error Messages" to suppress the runtime error message handling. Otherwise, if an
error occurs the error message will be displayed on the message line and the appropriate field (if any)
will be highlighted.
The user passes to the business function the number of the index they want to use, the number of key
fields within that index that will be used and key values (full or partial).
List of Indexes:
1 = ECPR, KIT, MMCU, TBM, BQTY, SRV (6 Keys)
2 = ECPR, ITM, MMCU, TBM, BQTY, TRV (6 Keys)
3 = ITM, DOCO (2 Keys)
4 = DOCO, PSQ, RSQ (3 Keys)
5 = DOCO, DCTO (2 Keys)
Return Field values.
1.3Special Logic
None.
2.Technical Specifications
2.4Processing
1. If the Input Request Type = '3', Release the Request and exit the Business function.
2. If the Input Request Type is '1', Get the Part List Table row (F3013) using Index/Key/Key Values
combination.
3. If the Request Type = '2', read the next F3013 row using above keys.
4. If row is found
Load the Output fields.
Save the Current Unique Keys.
Exit
Else
Release the request and exit the business function.
Endif
5. If any errors, Release the request and exit the function.
Retrievals:
1. ECO Parts List Detail Table (F3013).
Returns:
1. If fetch fails, return Error Message ID '0002' (Record Invalid).
2. If fetch is successful, and the memory allocation is successful, return the field values if
required.
3. If EOF reached, return '1' in End of File parameter, otherwise return 0
Checklist:
Business Function SVR(The Business Function SVR document can be found on
in the shared folder NTSERV2.xls)
______Business Function Name
______Source file Name
______Description of what the function does
______Which programs use the function
______Authors name
Object Librarian Check:
______Verify Related Functions List against header file
______Verify Related Tables List against header file
______Verify Business Function Data Structure in the header file against Business Function
Parameter List
______"Check In" All the Business Function Parameter Lists
All Business Functions must be run through Bounds Checker before checking them in.
______Bounds Checker
Note:Make sure to highlight the line and click on either 'Parameters' or 'Notes' button to get
Function ID
^
D3000780 - Get ECO Parts List Sequentially
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,
| ||||
mnPrimarySequence | PSQ | MATH_NUMERIC | NONE | NONE |
mnRelatedSequence | RSQ | MATH_NUMERIC | NONE | NONE |
cParentChildInclusion | ECPR | char | NONE | NONE |
A code that indicates whether the item is a parent or component. Using this value, the system selects items for you on the Related Items
| ||||
mnItemNumberShort | 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
| ||||
szBranch | 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
| ||||
szTypeOfBill | TBM | char | NONE | NONE |
A user defined code (40/TB) that designates the type of bill of material. You can define different types of bills of material for different uses.
| ||||
mnSwapToItem | KIT | MATH_NUMERIC | NONE | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
mnBatchQuantity | BQTY | MATH_NUMERIC | NONE | NONE |
The quantity of finished units that you expect this bill of material or routing to produce. You can specify varying quantities of components
| ||||
szToRevisionLevel | TRV | char | NONE | NONE |
The revision level for the part that is reported next. This might not be the next sequential revision. | ||||
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
| ||||
szSwapToRevisionLevel | SRV | char | NONE | NONE |
The revision level of the "Swap-to item" whenever an engineering change order is swapping out one item for another. The swap-to revision
| ||||
cRequestType | EV01 | 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
| ||||
szIndex | 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
| ||||
szKeys | 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
| ||||
cTypeOfItemChange | TIC | char | NONE | NONE |
A code that describes the type of item change. This value is used by the Related Items window to determine the number and nature of
| ||||
szComponentBranch | CMCU | char | NONE | NONE |
A secondary or lower-level business unit. The system uses the value that you enter to indicate that a branch or plant contains several
| ||||
szBatchQtyUOM | 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). | ||||
mnOperationSequenceNo | OPSQ | MATH_NUMERIC | NONE | NONE |
A number used to indicate an order of succession.
In routing instructions, a number that sequences the fabrication or assembly steps in the
| ||||
mnQuantityRequired | QNTY | MATH_NUMERIC | NONE | NONE |
The number of units that the system applies to the transaction. | ||||
cFixedVariableQuantity | FORQ | char | NONE | NONE |
A code that indicates if the quantity per assembly for an item on the bill of material varies according to the quantity of the parent item
| ||||
szUnitOfMeasure | UM | char | NONE | NONE |
A user defined code (00/UM) that identifies the unit of measurement for an amount or quantity. For example, it can represent a barrel, box,
| ||||
szFromRevisionLevel | FRV | char | NONE | NONE |
The revision level for the part that was previously reported. This might be the previous sequential revision. | ||||
szLastRevisionNo | RVNO | char | NONE | NONE |
A subset to the drawing number. It provides an additional description of the drawing and is useful if the system uses an engineering drawing
| ||||
jdEffectiveFromDate | EFFF | JDEDATE | NONE | NONE |
A date that indicates one of the following:
o When a component part goes into effect on a bill of material
o When a routing step goes into
| ||||
jdEffectiveThruDate | EFFT | JDEDATE | NONE | NONE |
A date that indicates one of the following:
o When a component part is no longer in effect on a bill of material
o When a routing step is no
| ||||
szFromSerialNo | FSER | char | NONE | NONE |
This field is used to identify the serial number of a particular parent part and specify when the component will become an active part of the
| ||||
szThruSerialNo | TSER | char | NONE | NONE |
This field is used to identify the serial number of a particular parent part and specify when the component will no longer be an active part of
| ||||
szUser | USER | char | NONE | NONE |
The code that identifies a user profile. | ||||
szProgramID | PID | char | NONE | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
jdDateUpdated | UPMJ | JDEDATE | NONE | NONE |
The date that specifies the last update to the file record. | ||||
mnTimeUpdated | TDAY | MATH_NUMERIC | NONE | NONE |
The computer clock in hours:minutes:seconds. | ||||
szWorkStationID | JOBN | char | NONE | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
cEndOfFile | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cReturnFieldValues | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cSuppressErrorMessages | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
idRequestHandle | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
idUserHandle | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
mnComponentLineNo | CPNB | MATH_NUMERIC | OPT | NONE |
A number that specifies how the system displays the sequence of components on a single-level bill of material. This number initially
|
None |
F3013 ECO Parts List Detail |