Days Cash Report

Contents

    Template Merge Fields

    Template Field NameDescription
    DATE
    CASH_TOTAL
    CHEQUE_TOTAL
    CCREDIT_TOTALCredit Card
    BACS_TOTAL
    EFT_TOTALElectronic Fund Transfer
    DDEBIT_TOTALDirect Debit
    DEBIT_TOTAL
    STANDING_ORDER_TOTAL
    PAYMENT_TOTAL
    REFUND_TOTAL
    GRAND_TOTAL

    Payment Item Fields : table name (paymentItems)

    Template Field NameDescription
    PAY_DATE
    PAY_MADEBY_FIRSTNAME
    PAY_MADEBY_INITIAL
    PAY_MADEBY_LASTNAME
    PAY_MADEBY_TITLE
    PAY_NARRATIVE
    PAY_NUMBER
    PAY_TYPE
    PAY_AMOUNT
    PAY_REFERENCE

    Refund Item Fields : table name (refundItems)

    Template Field NameDescription
    REF_DATE
    REF_TO_FIRSTNAME
    REF_TO_INITIAL
    REF_TO_LASTNAME
    REF_TO_TITLE
    REF_NARRATIVE
    REF_NUMBER
    REF_AMOUNT
    REF_AGAINST
    Updated on 4th May 2020