Invoice

This topic contains a quick reference to substitution codes for invoice.

Table 1. Invoice substitution codes
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