Days Cash Report

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

Related Articles