Prepaid and Regular Voucher Cross-Reference Record

The PS_VCHR_PPAY_XREF record stores the linkage between prepaid vouchers and regular vouchers which have been applied to one another. This is how information is processed:

1. A row is inserted into PS_VCHR_PPAY_XREF when a new prepaid voucher is entered.

2. This row is updated with the relevant linkage data when a regular voucher is applied to the prepaid voucher.

3. Additional rows are added to PS_VCHR_PPAY_XREF, if and when the prepaid voucher is applied to additional regular vouchers.

4. When application occurs, PS_PYMNT_VCHR_XREF (for the regular voucher) is also updated.

   The existing scheduled payment is updated to reflect the reduced payment that is remitted to the supplier. For each prepaid voucher that is applied, a row is inserted with prepaid_status A (applied). This row keeps PS_PYMNT_VCHR_XREF in balance with the voucher gross; the row is not used to generate a payment.

5. When payments are created, the scheduled payment generates a payment that has already been reduced by the applied prepaid vouchers.

6. When a regular voucher is posted, unposted rows in PS_VCHR_PPAY_XREF generate a set of reversal accounting entries for the prepaid voucher.

7. When a scheduled payment is fully applied (there is nothing left to pay the supplier), the prepaid_status is set to F (fully applied), and the pymnt_selct_status is set to S (settled). No additional row is inserted into PS_PYMNT_VCHR_XREF.