Invoice
This topic contains a quick reference to substitution codes for invoice.
| 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 |