OM_PMT_VCH_APLD

(SQL Table)
 Index Back

Amount of voucher applied

This record tracks the portion of a voucher that has been applied to invoices by OM_BILL. It is possible for a receipt to cross invoices. In this case, it may be necessary for OM_BILL to apply a portion of a voucher to one invoice, and save the remainder to be applied to future invoice(s) created in a future OM_BILL run. CDR_RECEIPT_PMT only records whether an entire voucer payment has been used or not (CDR_RECEIPT_PMT.PROCESS_FLG), thus the need for the child table. OM_BILL will only insert rows in this table when necessary. Not all voucher payments will have a row in this table.

  • Parent record: CDR_RECEIPT_PMT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
    2 RECEIPT_NBR Character(15) VARCHAR2(15) NOT NULL Receipt Number
    3 RECEIPT_NBR_SEQ Number(3,0) SMALLINT NOT NULL Receipt Number Sequence
    4 AMOUNT_APPLIED Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Applied