accountAmountReportnumber
accountBankPaymentAccountstring
accountDebitOrCredit.codeinteger
accountDebitOrCredit.descriptionstring
accountDecimalPlacesinteger
accountDiscountMemonumber
accountDiscountOthernumber
accountDiscountReportnumber
accountInUseTotalOthernumber
accountPaid.descriptionstring
accountPaymentDocFormatstring
accountPaymentMethod.codeinteger
accountPaymentMethod.descriptionstring
accountProcessedPayment.codeinteger
accountProcessedPayment.descriptionstring
accountProcessed.codeinteger
accountProcessed.descriptionstring
accountTaxTotalOthernumber
accountTotalAmountOthernumber
amountCrBalTotalReportingnumber
amountDrBalTotalReportingnumber
bank4thCurrencyCodestring
bank5thCurrencyCodestring
bankAcceptedTotal4thnumber
bankAcceptedTotal5thnumber
bankAcceptedTotalMemonumber
bankAcceptedTotalOthernumber
bankAcceptedTotalReportingnumber
bankDebitAcceptedTotalnumber
bankDebitAcceptedTotal4thnumber
bankDebitAcceptedTotal5thnumber
bankDebitAcceptedTotalMemonumber
bankDebitAcceptedTotalRptnumber
bankDebitNumberAcceptedinteger
bankDebitNumberRejectedinteger
bankDebitRejectedTotalnumber
bankDebitRejectedTotal4thnumber
bankDebitRejectedTotal5thnumber
bankDebitRejectedTotalMemonumber
bankDebitRejectedTotalRptnumber
bankDrAcceptedTotalOthernumber
bankDrRejectedTotalOthernumber
bankRejectedTotal4thnumber
bankRejectedTotal5thnumber
bankRejectedTotalMemonumber
bankRejectedTotalOthernumber
bankRejectedTotalReportingnumber
bankStoredDecimalPlacesinteger
cashAccountingPeriodstring
cashJournalLineNumberinteger
cashTransactionDatestring
creditBalanceAmountnumber
creditBalanceAmount4thnumber
creditBalanceAmount5thnumber
creditBalanceAmountMemonumber
creditBalanceAmountOthernumber
dateTimeLastUpdatedstring
debitBalanceAmount4thnumber
debitBalanceAmount5thnumber
debitBalanceAmountMemonumber
debitBalanceAmountOthernumber
debitBalanceTotal4thnumber
debitBalanceTotal5thnumber
debitBalanceTotalMemonumber
debitBalanceTotalOthernumber
debitBalanceTotalReportingnumber
debitSettledTotal4thnumber
debitSettledTotal5thnumber
debitSettledTotalMemonumber
debitSettledTotalOthernumber
debitSettledTotalReportingnumber
detailTransactionsProcessed.codeinteger
detailTransactionsProcessed.descriptionstring
detailType.descriptionstring
difference4thCurrencynumber
differenceBaseCurrencynumber
differenceOtherCurrencynumber
differenceReportCurrencynumber
discountInputAccountstring
discountInputAmountnumber
discountInputAmount4thnumber
discountInputAmount5thnumber
discountInputAmountMemonumber
discountInputAmountOthernumber
discountInputAmountReportnumber
discountInputEnterIndictrsinteger
discountOutputAccountstring
discountOutputAmountnumber
discountOutputAmount4thnumber
discountOutputAmount5thnumber
discountOutputAmountMemonumber
discountOutputAmountOthernumber
discountOutputAmountReportnumber
discountOutputAnalysis1string
discountOutputAnalysis10string
discountOutputAnalysis2string
discountOutputAnalysis3string
discountOutputAnalysis4string
discountOutputAnalysis5string
discountOutputAnalysis6string
discountOutputAnalysis7string
discountOutputAnalysis8string
discountOutputAnalysis9string
discountOutputEnterIndictrsinteger
discountTotalReportingnumber
exchangeAccountCodestring
exchangeAmountOthernumber
exchangeAmountReportnumber
exchangeAnalysisKeystring
exchangeDifferenceType.codeinteger
exchangeDifferenceType.descriptionstring
inUseTotalReportingnumber
interimNumOfDebitBalancesinteger
ledgerAccountingPeriodstring
ledgerJournalLineNumberinteger
ledgerJournalNumberinteger
ledgerTransactionDatestring
numberOfCreditBalancesinteger
numberOfDebitsSettledinteger
numberOfZeroBalancesinteger
otherAmountRun.codeinteger
otherAmountRun.descriptionstring
ownBankDetailsSubCodestring
payTwoRecords.codeinteger
payTwoRecords.descriptionstring
paymentAmount4thCurrencynumber
paymentAmountReportnumber
paymentMethod.codeinteger
paymentMethod.descriptionstring
paymentReceiptStampinteger
paymentTransactionsProcessed.codeinteger
paymentTransactionsProcessed.descriptionstring
pivotTo4thConversion.codestring
pivotTo4thConversion.descriptionstring
pivotTo5thConversion.codestring
pivotTo5thConversion.descriptionstring
pivotToBaseConversion.codestring
pivotToBaseConversion.descriptionstring
pivotToReportConversion.codestring
pivotToReportConversion.descriptionstring
pivotToTxnConversion.codestring
pivotToTxnConversion.descriptionstring
recordType.descriptionstring
relGainAcnt4thJnlLineinteger
relGainAcnt4thJnlNuminteger
relGainAcntBaseJnlLineinteger
relGainAcntBaseJnlNuminteger
relGainAcntOtherJnlLineinteger
relGainAcntOtherJnlNuminteger
relGainAcntRptJnlLineinteger
relGainAcntRptJnlNuminteger
relSuppAcnt4thJnlLineinteger
relSuppAcnt4thJnlNuminteger
relSuppAcntBaseJnlLineinteger
relSuppAcntBaseJnlNuminteger
relSuppAcntOtherJnlLineinteger
relSuppAcntOtherJnlNuminteger
relSuppAcntRptJnlLineinteger
relSuppAcntRptJnlNuminteger
stored4thOperator.codestring
stored4thOperator.descriptionstring
stored5thOperator.codestring
stored5thOperator.descriptionstring
storedBaseOperator.codestring
storedBaseOperator.descriptionstring
storedDecimalPlacesinteger
storedReportingOperator.codestring
storedReportingOperator.descriptionstring
storedTransactionOperator.codestring
storedTransactionOperator.descriptionstring
supplierAccountCodestring
supplierAccountingPeriodstring
supplierJournalLineNumberinteger
supplierJournalNumberinteger
supplierTransactionDatestring
totalNumberOfDebitBalancesinteger
trueRated.descriptionstring
selectstring
Allows a comma-separated list of columns to select. If no columns are specified, all columns will be selected by default.
e.g. LedgerBalances.accountCode, LedgerBalances.accountingPeriod, LedgerBalances.baseAmount_amount