F3002GetLastLineNumberbyOpSeq
F3002GetLastLineNumberbyOpSeq
Minor Business Rule
Object Name: N3003180
Parent DLL: CMFGBASE
Location: Client/Server
Language: NER
1.Functional Description
1.1Purpose
This function is selecting records from F3002 that match the ITM, CMCU, TBM, OPSQ, QNTY, and UM
(index ITEM, CBranch, +A) 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
1.3Special Logic
2.Technical Specifications
2.4Processing
Select records from F3002 based on ITM, CMCU, TBM, OPSQ, QNTY, and UM.
Fetch from the first record selected the component number (CPNT).
^
Data Structure
D3003180 - F3002GetLastLineNumberbyOpSeq
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
IdentifierShortItemITM | ITM | MATH_NUMERIC | OPT | INPUT |
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 |
BranchComponentCMCU | CMCU | char | OPT | INPUT |
A secondary or lower-level business unit. The system uses the value that you enter to indicate that a branch or plant contains several
subordinate departments or jobs. For example, assume that the component branch is named MMCU. The structure of MMCU might be as follows:
Branch/Plant - (MMCU)
Dept A - (MCU)
Dept B - (MCU)
Job 123 - (MCU) |
TypeBillTBM | TBM | char | OPT | INPUT |
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. |
SequenceNoOperationsOPSQ | OPSQ | MATH_NUMERIC | OPT | INPUT |
A number used to indicate an order of succession.
In routing instructions, a number that sequences the fabrication or assembly steps in the
manufacture of an item. You can track costs and charge time by operation.
In bills of material, a number that designates the routing step in the
fabrication or assembly process that requires a specified component part. You define the operation sequence after you create the routing
instructions for the item. The Shop Floor Management system uses this number in the backflush/preflush by operation process.
In engineering
change orders, a number that sequences the assembly steps for the engineering change.
For repetitive manufacturing, a number that
identifies the sequence in which an item is scheduled to be produced.
Skip To fields allow you to enter an operation sequence that you want to begin
the display of information.
You can use decimals to add steps between existing steps. For example, use 12.5 to add a step between steps
12 and 13. |
QtyRequiredStandard | QNTY | MATH_NUMERIC | OPT | INPUT |
The number of units that the system applies to the transaction.
|
UnitOfMeasure | UM | char | OPT | INPUT |
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,
cubic meter, liter, hour, and so on. |
ComponentNumberCPNB | CPNB | MATH_NUMERIC | OPT | OUTPUT |
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.
|