ResetUploadFlagStatus

Reset Upload Flag Status

Minor Business Rule

Object Name: B03B0039

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose
The purpose of the Reset Upload Flag Status business function is to determine whether a receipt has
been matched against an invoice record .  The function takes three parameters as input: (1) Payment Id;
(2) Receipt Amount Open; (3) Receipt Amount Foreign Open.  It returns the updated Receipt Amount
Open, the updated Receipt Amount Foreign Open and the Auto Cash Upload Status.

Reset Upload Status Flag reads the Receipt Header File (F03B13) by Payment Id.  After fetching a
matching record, the function compares the Receipt Amount Open and Receipt Amount Foreign Open amounts
(input fields passed to the function) against the Receipt Amount Open and Receipt Amount Foreign Open
fields retrieved from the file.  If either of these amounts is different, the function sets the Auto Cash
Upload Status flag to 'Y' (meaning a record has been matched), and then copies these retrieved amount
fields to Receipt Amount Open and Receipt Amount Foreign Open (input fields), respectively.  If both
amounts are equal to the retrieved amounts, Auto Cash Upload Status flag is set to 'U', meaning a
match did not occur.

Setup Notes and Prerequisites
None

Special Logic
None

Technical Specifications






Parameters


Item Description I/OReq?     Notes


pyidmnPaymentId IY Internal Payment ID of Receipt Header


aapmnReceiptAmountOpen I/OY Receipt domestic open amount


fapmnReceiptAmountForeignOpenI/OY Receipt Open Amount in foreign currency


eups    cAutoCashUploadStatus   O     N/R    'Y' means it was matched. 'U' means it was 

not matched


paap      mnReceiptRemOpen             O       N/R The actual receipt open amount fetched from 

F03B13 





Related Tables 


F03B13Receipts Header File





Related Functions


None





Processing


• Read Receipts Header File (F03B13) by Payment Id





• Compare Receipt Amount Open and Receipt Amount Foreign Open (input fields) against retrieved Receipt 

Amount Open and Receipt Amount Foreign Open fields





• If either amount is different:


 - Set Auto Cash Upload Status flag to 'Y' (meaning it was matched)





 - Copy retrieved Receipt Amount Open (retrieved field) to Receipt Amount Open (input 

field)





 - Copy retrieved Receipt Amount Foreign Open (retrieved field) to Receipt Amount  Foreign 

Open (input field)





• Else


 - Set Auto Cash Upload Status flag to 'U' (meaning it was not matched)


• Update Receipt payment amount 










^
Data Structure
D03B0039 - Reset Upload Flag Status


Purpose


This function data structure is used by Reset Upload Flag Status function.





Parameters


Item Description I/OReq?  Notes


PYIDmnPaymentId IY     Internal Payment ID of Receipt Header


AAPmnReceiptAmountOpen I/OY     Receipt domestic open amount


FAPmnReceiptAmountForeignOpenI/OY     Receipt Open Amount in foreign currency


EUPS    cAutoCashUploadStatus   O     N/R   'Y' means it was matched. 'U' means it was not 

matched


PAAP      mnReceiptRemOpen             O       N/R    The actual receipt open amount fetched from 

F03B13 







^

 
Parameter Name Data Item Data Type Req/Opt I/O/Both
mnPaymentId PYID MATH_NUMERIC NONE NONE


Item  ab  Descriptionab  ab  I/Oab Req?  Notes


 PYIDab  mnPaymentIdab  ab  Iab Y     Internal Payment ID of Receipt Header







^
mnReceiptAmountOpen AAP MATH_NUMERIC NONE NONE


Item  ab  Descriptionab  ab  I/Oab Req?  Notes


 AAPab  mnReceiptAmountOpenab  ab  I/Oab Y     Receipt domestic open amount







^
mnReceiptAmountForeignOpen FAP MATH_NUMERIC NONE NONE


Item  ab  Descriptionab  ab  I/Oab Req?  Notes


 FAPab  mnReceiptAmountForeignOpenab  I/Oab Y     Receipt Open Amount in foreign  currencyab 







^
cAutoCashUploadStatus EUPS char NONE NONE


Item  ab  Descriptionab  ab  I/Oab  Req?ab Notes


 EUPSab      cAutoCashUploadStatusab     Oab      N/R   'Y' means it was matched. 'U' means it was not 

matched










^
mnReceiptRemOpen PAAP MATH_NUMERIC NONE NONE


Item  ab  Descriptionab  ab  I/Oab  Req?ab Notes


PAAP      mnReceiptRemOpen             O       N/R    The actual receipt open amount fetched from 

F03B13







^

Related Functions

 
None

Related Tables

 
F03B13    	Receipts Header

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnPaymentId	PYID	MATH_NUMERIC	NONE	NONE
Item ab Descriptionab ab I/Oab Req? Notes PYIDab mnPaymentIdab ab Iab Y Internal Payment ID of Receipt Header ^
mnReceiptAmountOpen	AAP	MATH_NUMERIC	NONE	NONE
Item ab Descriptionab ab I/Oab Req? Notes AAPab mnReceiptAmountOpenab ab I/Oab Y Receipt domestic open amount ^
mnReceiptAmountForeignOpen	FAP	MATH_NUMERIC	NONE	NONE
Item ab Descriptionab ab I/Oab Req? Notes FAPab mnReceiptAmountForeignOpenab I/Oab Y Receipt Open Amount in foreign currencyab ^
cAutoCashUploadStatus	EUPS	char	NONE	NONE
Item ab Descriptionab ab I/Oab Req?ab Notes EUPSab cAutoCashUploadStatusab Oab N/R 'Y' means it was matched. 'U' means it was not matched ^
mnReceiptRemOpen	PAAP	MATH_NUMERIC	NONE	NONE
Item ab Descriptionab ab I/Oab Req?ab Notes PAAP mnReceiptRemOpen O N/R The actual receipt open amount fetched from F03B13 ^