F03B20FetchNextUniqueID

F03B20 Fetch Next Unique ID

Minor Business Rule

Object Name: B03B0166

Parent DLL: CFIN

Location: Client/Server

Language: C

B03B0166
F03B20 Fetch Next Unique ID

Functional Description

Purpose
This function determines the value of Unique Key ID from F03B20 and returns it back to the caller.
The function finds the highest number of Unique Key ID from F03B20, adds it by 1, and returns it back
to the caller.

Setup Notes and Prerequisites

Special Logic

Technical Specifications

Parameters
ItemDescription I/OReq?Notes
UKIDUnique Key IDOYes

Related Tables
F03B20A/R Notification History

Related Business Functions

Processing
• Fetch Unique Key ID from F03B20; sort Unique Key ID descending.
• If JDBReturn is not equal to JDEDB_PASSED,
•

Assign a '1' to Unique Key ID.

• Else,
•
If Unique Key ID (fetched) is a '0',

•
Assign a '1' to Unique Key ID (output).

•
Else,

•
Add 1 to Unique Key ID (fetched) and move it to the Unique Key ID (output).

•
End if.

• End if.

Data Structure

D03B0166 - F03B20 Fetch Next Unique ID

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnUniqueKeyIDInternal UKID MATH_NUMERIC NONE NONE

This field is a unique number used to identify a record in a file.

Related Functions

None

Related Tables

F03B20 A/R Notification History

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnUniqueKeyIDInternal	UKID	MATH_NUMERIC	NONE	NONE
This field is a unique number used to identify a record in a file.