1.Functional Description
1.1Purpose
This function will sort the requested table by UKID. Get the UKID of the last record and add one (1)
to it and return that number.
1.2Special Logic
This function will sort the table in descending order by UKID. Fetch the first record in the table.
Add one to the UKID of that record and return it.
The parameter Table Name must be passed in. This is used to determine which Table to get the Next
Unique Key ID from. Valid values for Table Name are: F3111, F31122, F3015, F3411, F3412, F30UI004,
F3303 and F3311. This function was designed to add other table's when needed.
2.Technical Specifications
2.3Processing
Validate that the DS Table Name passed in is a valid value.
If valid table name, determine which table will be used. Sort the requested table in descending
order by UKID.
Fetch the first record which will have the highest UKID number. Add one to this number and return it
to the calling program in DS Unique Key ID.
D3100490 - Get Next Unique ID For Mfg.
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnUniqueKeyID | UKID | MATH_NUMERIC | NONE | NONE |
This field is a unique number used to identify a record in a file. | ||||
cSuppressErrorMessages | 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
| ||||
szTableName | OBJP | char | NONE | NONE |
Primary object in a relationship of two objects. |
None |
F3015 Component Locator File | ||||
F30UI004 Bill of Material Update Work File | ||||
F3111 Work Order Parts List | ||||
F31122 Work Order Time Transactions | ||||
F3303 Capacity Resource Profile | ||||
F3311 Capacity Message File | ||||
F3312 Capacity Pegging | ||||
F3411 MPS/MRP/DRP Message File | ||||
F3412 MPS/MRP/DRP Lower Level Requirements File | ||||
F3462 Forecast Shipment Summary |