F3002GetLastLineNumber
F3002 Return Line Number
Minor Business Rule
Object Name: N3002060
Parent DLL: CMFGBASE
Location: Client/Server
Language: NER
1._Functional Description
1.1Purpose
This function is selecting records from F3002 that match the MMCU, KIT, TBM, COBY and BQTY being
passed in. The function is then retrieving the component number (CPNT) for the first record selected.
The component number is descending order, so it will be selecting the highest number. This is being
done in order to determine what the next component number should be to make the record unique.
1.2Setup Notes and Prerequisites
None.
2.1Special Logic
None.
2._Technical Specifications
2.4Processing
Select records from F3002 based on MMCU, KIT, TBM, COBY and BQTY.
Fetch from the first record selected the component number (CPNT) or the substitute line number
(SBNT).
^
Data Structure
D3002060 - F3002 Get Last Line Number
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|
| szCostCenterAlt | 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. |
| mnItemNumberShortKit | KIT | MATH_NUMERIC | NONE | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
non-significant item number.
2. 2nd Item Number - The 25-digit, free form, user defined alphanumeric item number.
3. 3rd Item Number - Another
25-digit, free form, user defined alphanumeric item number. |
| szTypeBill | 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. |
| cCoproductsByproducts | COBY | char | NONE | NONE |
A code that distinguishes standard components or ingredients from co-products,by-products, and intermediates. Co-products are
(concurrent) end items as the result of a process. By-products are items that can be produced at any step of a process, but were not planned.
Intermediate products are items defined as a result of a step but are automatically consumed in the following step.
Generally, intermediates are
nonstock items and are only defined steps with a pay-point for reporting purposes. Standard components (Discrete Manufacturing)
or ingredients
(Process Manufacturing) are consumed during the production process. Valid values are:
C Co-products
B By-products
I Intermediate
products
Blank Standard components or ingredients |
| mnUnitsBatchQuantity | 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. |
| mnSubstituteItemSequenceNu | SBNT | MATH_NUMERIC | OPT | NONE |
A number that indicates the sequence for the substitute items for a component.
The system looks for substitute items by this sequence
number.
|
| mnComponentNumber | 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
indicates the sequence in which a component was added to the bill of material. You can modify this number to change the sequence in which the
components appear.
|