additionalDateTimeLastUpdatedstring
additionalGeneralDate1string
additionalGeneralDate2string
additionalGeneralDate3string
additionalGeneralDate4string
additionalGeneralDate5string
additionalGeneralDescription1string
additionalGeneralDescription10string
additionalGeneralDescription11string
additionalGeneralDescription12string
additionalGeneralDescription13string
additionalGeneralDescription14string
additionalGeneralDescription15string
additionalGeneralDescription16string
additionalGeneralDescription17string
additionalGeneralDescription18string
additionalGeneralDescription19string
additionalGeneralDescription2string
additionalGeneralDescription20string
additionalGeneralDescription21string
additionalGeneralDescription22string
additionalGeneralDescription23string
additionalGeneralDescription24string
additionalGeneralDescription25string
additionalGeneralDescription3string
additionalGeneralDescription4string
additionalGeneralDescription5string
additionalGeneralDescription6string
additionalGeneralDescription7string
additionalGeneralDescription8string
additionalGeneralDescription9string
additionalUpdateCountinteger
additionalUserIdLastUpdatedstring
agreedStatus.descriptionstring
allocationInProgressstring
allocationMarker.codestring
allocationMarker.descriptionstring
allocationReferenceinteger
allocationStatementsinteger
approvalsExtension.codeinteger
approvalsExtension.descriptionstring
assetIndicator.codestring
assetIndicator.descriptionstring
authorizationInProgress.codeinteger
authorizationInProgress.descriptionstring
authorizationSetRefinteger
base2ReportOperator.codestring
base2ReportOperator.descriptionstring
base2ReportingAmount.amountnumber
base2ReportingAmount.currencyCodestring
base2ReportingAmount.reportingCreditAmountnumber
base2ReportingAmount.reportingDebitAmountnumber
baseAmount.baseCreditAmountnumber
baseAmount.baseDebitAmountnumber
baseAmount.currencyCodestring
baseOperator.descriptionstring
binderStatus.descriptionstring
cleardownSequenceNumberstring
debitCredit.descriptionstring
excludeFromBalancing.codestring
excludeFromBalancing.descriptionstring
journalHoldReferenceinteger
journalReversalType.codeinteger
journalReversalType.descriptionstring
ledgerExtDataOnFile.codestring
ledgerExtDataOnFile.descriptionstring
ledgerExtensionBankCodestring
ledgerExtensionDiscountDate1string
ledgerExtensionDiscountDate2string
ledgerExtensionDiscountPercent1number
ledgerExtensionDiscountPercent2number
ledgerExtensionDocumentDate1string
ledgerExtensionDocumentDate2string
ledgerExtensionDocumentDate3string
ledgerExtensionDocumentDate4string
ledgerExtensionDocumentNumber1integer
ledgerExtensionDocumentNumber1Prefixstring
ledgerExtensionDocumentNumber2integer
ledgerExtensionDocumentNumber2Prefixstring
ledgerExtensionDocumentNumber3integer
ledgerExtensionDocumentNumber3Prefixstring
ledgerExtensionDocumentNumber4integer
ledgerExtensionDocumentNumber4Prefixstring
ledgerExtensionInterestDatestring
ledgerExtensionInterestPercentnumber
ledgerExtensionLatePayPercentnumber
ledgerExtensionLatePaymentDatestring
ledgerExtensionModuleCodestring
ledgerExtensionPaymentReferencestring
ledgerExtensionPaymentSplitTermsCodestring
ledgerExtensionPaymentTermsCodestring
ledgerExtensionSourceReferencestring
ledgerLineStandardTextClassCodestring
ledgerLineStandardTextCodestring
manualPaymentOverride.codeinteger
manualPaymentOverride.descriptionstring
modifiedAfterPostingBystring
modifiedAfterPostingDatestring
paymentAuthorizationSetRefinteger
permanentPostingDatestring
principalRequired.codeinteger
principalRequired.descriptionstring
provisionalPostingStatus.codestring
provisionalPostingStatus.descriptionstring
revaluationLinkReferenceinteger
revaluationTransactionstring
reverseNextPeriod.codestring
reverseNextPeriod.descriptionstring
splitInProgress.codeinteger
splitInProgress.descriptionstring
supplementaryExtension.codeinteger
supplementaryExtension.descriptionstring
the4thCurrencyAmount.amountnumber
the4thCurrencyAmount.currencyCodestring
the4thCurrencyAmount.the4thCurrencyCreditAmountnumber
the4thCurrencyAmount.the4thCurrencyDebitAmountnumber
the4thCurrencyConversionRatenumber
the4thCurrencyDecimalPlaces.codestring
the4thCurrencyDecimalPlaces.descriptionstring
the4thCurrencyOperator.codestring
the4thCurrencyOperator.descriptionstring
the5thCurrencyConversionRatenumber
the5thCurrencyDecimalPlaces.codestring
the5thCurrencyDecimalPlaces.descriptionstring
the5thCurrencyOperator.codestring
the5thCurrencyOperator.descriptionstring
transactionAmount.amountnumber
transactionAmount.currencyCodestring
transactionAmount.transactionCreditAmountnumber
transactionAmount.transactionDebitAmountnumber
transactionAmtDecimalPlaces.codestring
transactionAmtDecimalPlaces.descriptionstring
transactionOperator.codestring
transactionOperator.descriptionstring
transactionReferencestring
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