F3013GetNextRecord
F3013 Get Next Record
Minor Business Rule
Object Name: B3001990
Parent DLL: CMFGBASE
Location: Client/Server
Language: C
1.Functional Description
This function will read all records sequentially, from F3013 using specified index & number of keys.
1.1Purpose
The business function's original intention is to retrieve the records with Short Item numbers stored
as KIT in F3013.
1.2Setup Notes and Prerequisites
None
1.3Special Logic
No special logic is contained within this function.
2.Technical Specifications
2.4Processing
If the Input Request Type = '1', get the Parts List record, using specified key values.
If the Input Request Type = '2', read the next F3013 record using the key values.
If the Input Request Type = '3', release the request and exit the Business function.
If record found
fetch the record and load the output
set ERRC = '0', indicating successful fetch
Exit the function
else
if fetch is unsuccessful, set ERRC = '1'
If fetch is unsuccessful (ERRC = '1'), release the request, and exit the Business function.
^
Data Structure
D3001990 - F3013 Get Next Record
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
mnShortItemNumber | 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
numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and
so forth. The item numbers are as follows:
o Item Number (short) - An eight-digit, computer-assigned item number
o 2nd Item Number - The
25-digit, free-form, user defined alphanumeric item number
o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item
number |
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
represent lower-level business units, subordinate to it. For example:
o Branch/Plant (MMCU)
o Dept A (MCU)
o Dept B (MCU)
o Job 123
(MCU)
Business unit security is based on the higher-level business unit. |
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
becomes the next revision level for the item only when the ECO is created in "Swap To" mode. |
mnDocumentNumber | 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,
and so on. |
szDocumentOrderType | 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
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post
program. (These entries are not self-balancing when you originally enter them.)
The following document types are defined by J.D. Edwards and
should not be changed:
P
Accounts Payable documents
R
Accounts Receivable documents
T
Payroll documents
I
Inventory documents
O
Purchase Order Processing documents
J
General Accounting/Joint Interest Billing documents
S
Sales Order Processing documents
|
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
effect as a sequence on the routing for an item
o When a rate schedule is in effect The default is the current system date. You can enter
future effective dates so that the system plans for upcoming changes. Items that are no longer effective in the future can still be recorded and
recognized in Product Costing, Shop Floor Management, and Capacity Requirements Planning. The Material Requirements Planning system
determines valid components by effectivity dates, not by the bill of material revision level. Some forms display data based on the effectivity
dates you enter. |
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
longer in effect as a sequence on the routing for an item
o When a rate schedule is no longer active The default is December 31 of the
default year defined in the Data Dictionary for Century Change Year. You can enter future effective dates so that the system plans for upcoming
changes. Items that are no longer effective in the future can still be recorded and recognized in Product Costing, Shop Floor Management,
and Capacity Requirements Planning. The Material Requirements Planning system determines valid components by effectivity dates, not by
the bill of material revision level. Some forms display data based on the effectivity dates you enter. |
szDrawingRevision | 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
as a reference for this item. |
cChangeType | 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
related items allowed. The value is also used during Engineering Change Population to determine the changes. Valid values are:
N Add a new
component or bill
S Swap or replace one item with another
C Change an existing component or bill
R Remove an existing component or
bill |
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
window when you perform a where-used inquiry for components or a single-level or multilevel inquiry for parent items. The Engineering Change
Population program uses this value to determine the requested change. Valid values are:
P The item is a parent.
C The item is a
component. |
szTypeBOM | 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.
For example:
M Standard manufacturing bill
RWK Rework bill
SPR Spare parts bill
The system enters bill type M in the work order
header when you create a work order, unless you specify another bill type. The system reads the bill type code on the work order header to
know which bill of material to use to create the work order parts list. MRP uses the bill type code to identify the bill of material to use when it
attaches MRP messages. Batch bills of material must be type M for shop floor management, product costing, and MRP processing. |
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
based on the amount of finished goods produced. For example, 1 ounce of solvent is required per unit up to 100 units of finished product.
However, if 200 units of finished product is produced, 2 ounces of solvent are required per finished unit. In this example, you would set up batch
quantities for 100 and 200 units of finished product, specifying the proper amount of solvent per unit. |
szUnitOfMeasure | 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).
|
szRevisionLevelFrom | FRV | char | NONE | NONE |
The revision level for the part that was previously reported. This might be the previous sequential revision. |
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
interactive program is P4210, and the number of the Print Invoices batch process report is R42565.
The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where:
T
The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program.
SS
The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system.
XXX
The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.
|
cRequestType | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event.
|
cErrorCode | ERRC | char | NONE | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
Set Server program (XT4914). |
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
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
|
cSuppressErrorMessages | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event.
|
idHRequestF3013 | GENLNG | ID | NONE | NONE |
General purpose ID variable. |