Purpose

To query and maintain records held in Callista's I_PAYMENT_LOAD Interface Table

INTF1000 is used to query and maintain records held in Callista's I_PAYMENT_LOAD Interface Table

Payments for fees made through a Cashiering System or via bank transactions are loaded into the Callista I_PAYMENT_LOAD Interface Table by the External Finance System. The COFI Master Job INTJ0022 then applies this new payment information to existing invoices in Callista according to payment application criteria.

Use this form to query and maintain the information held in the I_PAYMENT_LOAD Interface Table.

The Customer sub-block contains:

• Customer Number:
  Displays the Customer Number for a record. This is available only if the External Finance System has loaded it into the Interface Table. If the Customer Number is not displayed, specify the Payment Advice Number to derive the Customer Number for a record.
• Customer Name:
  Displays the customer name. This is derived from the Customer Number. If the Customer Number is not displayed, specify a Payment Advice Number to derive the customer name for a record.
• Payment Advice Number:
  Displays the alternative Customer Number. Payment Advice Numbers are used by receipting or banking systems as an alternative to the Customer Number to identify customers.You will be prompted to correct the Payment Advice Number if the number you enter has no reference to a Customer Number, or is inconsistent with the Customer Number you have specified.

The Receipt sub-block contains:

• Receipt Number:
  Displays the receipt number issued by the external Cashiering System for the payment.
• Transaction Amount:
  Displays the payment amount that relates to the displayed receipt and, if applicable, the designated invoice.
• Effective Date:
  Displays the date of payment.
• Currency Code:
  Displays the currency in which the payment (transaction amount) was made. For example, Australian Dollars.
• Exchange Rate:
  Displays the exchange rate used to convert the foreign currency payment to local currency.
• Payment Sort Key:
  Displays the code specified for a payment record by the External Finance System. This information is optionally specified by the External Finance System.
• Payment Type:
  Displays the code specified by the External Finance System for the type of payment made. For example, cash. This information is optionally specified by External Finance System.

The Designation sub-block contains:

A payment may be allocated to a specific invoice or invoices for a particular fee. This is usually done at the point of accepting a payment through a Cashiering System.

See Designated Payments in Special Topics for more information.

• Designated Invoice check box:
  This check box displays whether or not the payment has been allocated to a specific invoice or invoices by the External Finance System. To allocate a payment to a particular invoice, enter details of the invoice then select Y to mark the payment as designated.
• Invoice Number Prefix:
  Displays the prefix of the invoice to which the payment is designated. An invoice number prefix must be specified if the Designated Invoice check box is set to Y. Leave this field blank if the payment is not designated.
• Invoice Number:
  Displays the number of the invoice to which the payment is designated. An invoice number must be specified if the Designated Invoice check box is set to Y. Leave this field blank if the payment is not designated.
• Invoice Line Number:
  Displays the line number of the invoice to which the payment is designated. A line number must be specified if the Designated Invoice check box is set to Y. Leave this field blank if the payment is not designated.

The Audit Detail sub-block contains:

• IPL Sequence Number:
  Displays the system generated number that uniquely identifies the record in I_PAYMENT_LOAD.
• Created By:
  Displays the system generated username of the person who inserted the record into I_PAYMENT_LOAD.
• Created On:
  Displays the system generated date and time when the record was inserted into I_PAYMENT_LOAD.
• Deletion Date:
  Displays the system generated date and time the record was deleted from the I_PAYMENT_LOAD Interface Table. Records in this table are logically deleted.
• Update By:
  Displays the system generated username of the person who last updated the record.
• Updated On:
  Displays the system generated date and time when the record was last updated.

The Transfer Detail sub-block contains:

The master job INTJ0022 attempts to transfer payment data in the I_PAYMENT_LOAD Interface Table to the I_PAYMENT Interface Table. Only READY records in I_PAYMENT_LOAD are transferred.

• Transfer Status:
  Displays the status of the record in the process of transfer to Callista's I_PAYMENT Interface Table.
• Transfer Message:
  Displays a message that indicates why a payment record failed to transfer to the I_PAYMENT table. Only displayed for records with a transfer status of ERROR.

Rules and Notes:

Records in I_PAYMENT_LOAD with a transfer status of SUCCESSFUL cannot be updated via INTF1000. A SUCCESSFUL Transfer Status indicates that the data has already been transferred to the I_PAYMENT Interface Table.

Data that can be updated or added in this form:

• Payment Sort Key
• Payment Type
• Designated Invoice
• Invoice Number Prefix
• Invoice Number
• Invoice Line Number

Transfer Statuses:

READY

This is displayed when payment details are ready to be transferred from I_PAYMENT_LOAD to Callista's I_PAYMENT table via the COFI master job INTJ0022.

ERROR

This is displayed when:

• A Customer Number is not available in Callista's I_FIN_CUSTOMER Interface Table that corresponds to the Payment Advice Number of a record; or
• The Invoice Number and Invoice Line Number do not exist for a designated payment in Callista's I_INVOICE_TRANS table; or
• For payment reversals, the original receipt does not exist in I_PAYMENT. A reversal of a payment is required where a cheque is dishonoured or there is a variation to the payment due to a clerical error.

SUCCESSFUL

This is displayed when the details of a record are transferred to Callista's I_PAYMENT Interface Table. In I_PAYMENT the processed status of the record is set to TODO.

Records in I_PAYMENT_LOAD with a transfer status of SUCCESSFUL cannot be updated via INTF1000 since this indicates that the data has already been transferred to I_PAYMENT.