Itemized credit
This topic contains a quick reference to substitution codes for itemized credit.
Field | Substitution code |
---|---|
Account Balance at Invoice Creation Date | accountBalanceEnteredDate |
Account Balance at Invoice Creation Time | totalPayableExAutoPayments |
Account Name | accountName |
Account Number Hint | hint |
Account Term | acTerms |
Account amount payable | accountAmountPayable |
Account balance | accountBalance |
Account balance at last invoice | balanceAtLastInvoice |
Account balance including pending payments | accountBalanceIncludingPending |
Account contact name | accountContactName |
Account custom field | accountCustomField |
Account is not in default disposition | accountNotInDefaultDisposition |
Account number | ucn |
Account type | accountType |
Activity since last invoice | activitySinceLastInvoice |
Activity since previous balance | totalBeforeInvoice |
Activity since the last invoice up til now | activitySinceLastInvoiceUntilNow |
Adjustments since last invoice | adjustmentsSinceLastInvoice |
Aged (1st period) at Invoice Creation Date | agedBalanceEnteredDateOne |
Aged (2nd period) at Invoice Creation Date | agedBalanceEnteredDateTwo |
Aged (3rd+ period) at Invoice Creation Date | agedBalanceEnteredDateThree |
Aged (Current) at Invoice Creation Date | agedBalanceEnteredDateCurrent |
Aged Balance (1st period) | agedBalanceOne |
Aged Balance (2nd period) | agedBalanceTwo |
Aged Balance (3rd period) | agedBalanceThree |
Aged Balance (3rd+ period) | agedBalanceThreePlus |
Aged Balance (4th+ period) | agedBalanceFourPlus |
Aged Balance (Current) | agedBalanceCurrent |
Allocated/Paid | allocated |
Alternate Account Number | alternateAccountNumber |
Australia Post Bill Pay Payment Total Amount | australiaPostBillPayPaymentTotal |
Australia Post Bill Pay Surcharge | australiaPostBillPaySurcharge |
Australia Post BillPay Code | australiaPostBillPayCode |
Australia post address | australiaPostAddress |
Balance before invoice | balanceBeforeInvoice |
Bank Account Name | bankAccountName |
Billing Address | longAddress |
Billing Address Country | billCountry |
Billing Address Postcode | billPostcode |
Billing Address State | billState |
Billing Address Suburb | billSuburb |
Billing address (1st line only) | billAddress |
Branch Number | branchNumber |
Company ABN | abn |
Company BPay Biller Code | bpayCode |
Company Name | companyName |
Company Payment Address | companyPaymentAddress |
Contact name (Mr Example Man) | contactName |
Credits since last invoice | creditsSinceLastInvoice |
Credits since previous balance | creditsSincePrevious |
Currency Code | currencyCode |
Currency Name | currencyName |
Currency Symbol | currencySymbol |
Customer First Name | contactGiven |
Customer Last Name | contactFamily |
Customer email address | customerEmailAddress |
Customer home phone number | customerHomePhone |
Customer mobile phone number | customerMobilePhone |
Customer work phone number | customerWorkPhone |
Date only | todaysDateOnly |
Debits since last invoice | debitsSinceLastInvoice |
Debits since previous balance | debitsSincePrevious |
Display Statement | displayedStatement |
Disposition text | dispositionText |
Due date | dueDate |
Expiry date | expiryDate |
Formatted Total Payable | formattedTotalPayable |
GST value | gst |
Has auto debit? | hasAutoDebit |
Has pending payment? | hasPendingPayment |
Invoice Date | invoiceDate |
Invoice Number | invoiceNumber |
Invoice amount payable | invoiceAmountPayable |
Invoice end date | invoicingEnd |
Invoice is overdue | invoiceOverdue |
Invoice is paid | invoicePaid |
Invoice start date | invoicingStart |
Invoice total balance | totalBalance |
Invoice total balance excluding GST | totalBalanceExGst |
Invoice total inc payment surcharge | invoiceAmountPlusInvoiceSurcharge |
Invoice unpaid balance | unpaidBalance |
Invoiced Amount - 2 periods ago | invoicedAmount2PeriodsAgo |
Invoiced Amount - 3 periods ago | invoicedAmount3PeriodsAgo |
Invoiced Amount - previous period | invoicedAmountPreviousPeriod |
Invoicing end date - 2 periods ago | endDate2PeriodAgo |
Invoicing end date - 3 periods ago | endDate3PeriodAgo |
Invoicing end date - previous period | endDatePreviousPeriod |
Invoicing start date - 2 periods ago | startDate2PeriodAgo |
Invoicing start date - 3 periods ago | startDate3PeriodAgo |
Invoicing start date - previous period | startDatePreviousPeriod |
Issue date | issueDate |
Message number | messageNumber |
Name and Billing address (1st line only) | nameAndBillAddress |
New charges | newCharges |
Operators Account Name | operatorName |
Operators Email Address | operatorEmail |
Operators First Name | operatorFirstName |
Operators Last Name | operatorLastName |
Overdue balance | overdueBalance |
Page Count | pageCount |
Page Number | pageNumber |
Payment Instructions | paymentInstructions |
Payment processing surcharge | surchargeOnInvoiceAmount |
Payment type | paymentType |
Payment type's stationery text | paymentTypeText |
Payments since last invoice | paymentsSinceLastInvoice |
Pending payment date | pendingPaymentDate |
Pending payment number | paymentNumber |
Pending payment value | pendingPaymentValue |
Post bill pay account number (with check digit) | postBillPayAccountNumber |
Previous balance | previousBalance |
Scheduled payments value | scheduledPayments |
Sequence number | sequenceNumber |
Time only | todaysTimeOnly |
Today's date | todaysDate |
Total bonds at invoice date | totalBondsAtInvoiceDate |
Total bonds at time of printing | totalBonds |
Total discount | totalDiscount |
Total paid bonds at invoice date | totalPaidBondsAtInvoiceDate |
Total paid bonds at time of printing | totalPaidBonds |
Total payable | totalPayable |
Total pending payment value | totalPendingPaymentsValue |
Total unpaid bonds at invoice date | totalUnpaidBondsAtInvoiceDate |
Total unpaid bonds at time of printing | totalUnpaidBonds |