Functional Description
Purpose
This function gets the next available File Line Identifier for the F03B14 record based on the Payment
ID. The File Line Identifier is part of the F03B14 primary key.
Setup Notes and Prerequisites
This function is used in B03B0146 and P03B40.
Special Logic
Technical Specification
Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
PYIDPayment IDIY
RC5File Line IdentifierON
Related Tables
F03B14Receipts Detail File.
Processing
Open the F03B14 table.
If error occurs opening the table set an error.
Set selection for records where payment id is equal to the passed in payment id.
Sort the selection by payment id in ascending order and File Line Identifier in descending order.
Fetch the first record in the selection.
If the fetch fails then File Line Identifier is equal to 1
If the fetch is successful add 1 to the File Line Identifier and return the result to the calling
program.
^
D03B0147 - F03B14 - Get Next File Line Identifier-RC5
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| mnPaymentID | PYID | MATH_NUMERIC | NONE | NONE |
A number that the system assigns from Next Numbers to identify and track payment records. | ||||
| mnFileLineIdentifier50 | RC5 | MATH_NUMERIC | NONE | NONE |
This field is used to create a unique key within a file and should be used with a next number approach. | ||||
| None |
| None |