Payment Load Inconsistency Inquiry Form

INTF0115 - Payment Load Inconsistency Inquiry Form

Purpose	Use this form to view the results of the Payment Load Inconsistency Extract job INTJ0021
Subsystem	Callista Open Finance Interface
Normally Run By	A Fees Specialist
Anticipated Frequency	Whenever Payment Load inconsistencies are identified by INTJ0021
Structure	Blocks	Loaded Payment Inconsistency Extract Inquiry
		Payment Extract Summary Records
	Button	Student Fee Reconciliation Inquiry (INTF0056)

INTF0115 is used to investigate discrepancies between what has been recorded as successfully transferred in the I_payment_load table and the destination I_payment table in CALLISTA that have been identified by the running of INTJ0021.

The Loaded Payments Inconsistency Extract Inquiry block contains:

INTJ0115 Description:
IP Sequence Number From:
Person ID Group ID:

The Payment Extract Summary Records block contains:

This block has 4 columns - Payment Load Table and Payment Table for Customer Number and Payment Load Table and Payment Table for Receipt Number.

Customer Number:

Customer Number	Payment Load Table	Payment Table
Transaction Amount	Yes	Yes
Payment Advice Number	Yes	No
Designated Invoice check box	Yes	Yes
Invoice Number Prefix	Yes	Yes
Invoice Number	Yes	Yes
Invoice Line Number	Yes	Yes
Transfer Status	Yes	No
Ext Transfer Status	Yes	No
Sequence Number	Yes	No
IP Sequence Number	Yes	Yes
IPL Transfer Message	Yes	No

Receipt Number

Receipt Number	Payment Load Table	Payment Table
Payment Type	Yes	Yes
Payment Sort Key	Yes	Yes
Effective Date	Yes	Yes
Currency Code	Yes	Yes
Processed Status	No	Yes
Exchange Rate	Yes	Yes
Logical Delete Date	Yes	Yes
Created On	Yes	Yes
Created Who	Yes	No

Button

Student Fee Reconciliation Inquiry (INTF0056)

Rules/Notes:

The Person ID Groups are sorted by CREATION_DT.

The Student Fee Reconciliation Inquiry Button links to INTF0056.

Last Modified on 30 March, 2004