How related AMOUNT_REMAINING from AP_PAYMENT_SCHEDULES_ALL and applied prepayment?
When we apply prepayment in invoice, how it records in payments?
Example: we have tables AP_PAYMENT_SCHEDULES_ALL, AP_INVOICE_PAYMENTS_ALL. When we make payment, it records in table AP_INVOICE_PAYMENTS_ALL. In table AP_PAYMENT_SCHEDULES_ALL amount in field AMOUNT_REMAINING decreases on amount payment that we make. These actions related through field PAYMENT_NUM.
When we apply prepayment, AMOUNT_REMAINING decreases too. Do we have similar field (or key) like PAYMENT_NUM but for prepayment?
Tagged:
0