accountData.descriptionstring
allowDuplicateNames.codeinteger
allowDuplicateNames.descriptionstring
allowMultipleSplits.codeinteger
allowMultipleSplits.descriptionstring
allowSignedSplits.codeinteger
allowSignedSplits.descriptionstring
analysisT0Data.codeinteger
analysisT0Data.descriptionstring
analysisT1Data.codeinteger
analysisT1Data.descriptionstring
analysisT2Data.codeinteger
analysisT2Data.descriptionstring
analysisT3Data.codeinteger
analysisT3Data.descriptionstring
analysisT4Data.codeinteger
analysisT4Data.descriptionstring
analysisT5Data.codeinteger
analysisT5Data.descriptionstring
analysisT6Data.codeinteger
analysisT6Data.descriptionstring
analysisT7Data.codeinteger
analysisT7Data.descriptionstring
analysisT8Data.codeinteger
analysisT8Data.descriptionstring
analysisT9Data.codeinteger
analysisT9Data.descriptionstring
assetData.descriptionstring
baseCurrencyAmountBalancing.codeinteger
baseCurrencyAmountBalancing.descriptionstring
baseCurrencyAmtDecPlaces.codeinteger
baseCurrencyAmtDecPlaces.descriptionstring
baseCurrencyBankingCurrency.codeinteger
baseCurrencyBankingCurrency.descriptionstring
baseCurrencyCollectionAccountstring
baseCurrencyCurrencyGender.codeinteger
baseCurrencyCurrencyGender.descriptionstring
baseCurrencyCurrencyUnitNamestring
baseCurrencyDateTimeLastUpdatedstring
baseCurrencyDecimalsAllowed.codeinteger
baseCurrencyDecimalsAllowed.descriptionstring
baseCurrencyDescriptionstring
baseCurrencyFirstDecimalNamestring
baseCurrencyGainAccountRealizedstring
baseCurrencyGainAccountUnrealizedstring
baseCurrencyISOCurrencyCodestring
baseCurrencyLookupCodestring
baseCurrencyNetLossAccountRealizedstring
baseCurrencyNetLossAccountUnrealizedstring
baseCurrencyPaymentAccountstring
baseCurrencyPostRule.codeinteger
baseCurrencyPostRule.descriptionstring
baseCurrencySecondDecimalNamestring
baseCurrencyShortHeadingstring
baseCurrencySplitDecimalNaming.codeinteger
baseCurrencySplitDecimalNaming.descriptionstring
baseCurrencyStatus.codeinteger
baseCurrencyStatus.descriptionstring
baseCurrencyThirdDecimalNamestring
baseCurrencyUpdateCountinteger
baseCurrencyUseDailyConversionRates.codeinteger
baseCurrencyUseDailyConversionRates.descriptionstring
baseCurrencyUserIdLastUpdatedstring
businessRegistrationCodestring
businessRegistrationNumberstring
businessStructureIdinteger
businessUnitDescriptionstring
businessUnitLocked.codeinteger
businessUnitLocked.descriptionstring
customerData.descriptionstring
dataAccessGroupCodestring
dataArchived.descriptionstring
dateFormat.descriptionstring
dateTimeLastUpdatedstring
expectedRevenueLedger.codestring
expectedRevenueLedger.descriptionstring
fifthCurrAmntBalTolerancenumber
financialsOnly.codeinteger
financialsOnly.descriptionstring
financialsReportsInquiries.codeinteger
financialsReportsInquiries.descriptionstring
formBackgroundColour.codeinteger
formBackgroundColour.descriptionstring
fourthCurrAmntBalTolerancenumber
fundingCurrency.codeinteger
fundingCurrency.descriptionstring
itemData.descriptionstring
journalTypeDataSecurity.codeinteger
journalTypeDataSecurity.descriptionstring
locationData.descriptionstring
maximumNumberOfPeriodsinteger
monthFormat.descriptionstring
nonCurrencyValueNamestring
nonCurrencyValuePostRule.codeinteger
nonCurrencyValuePostRule.descriptionstring
orderFulfilmentDecPlacesinteger
otherCurrencyAmntBalancing.codeinteger
otherCurrencyAmntBalancing.descriptionstring
otherCurrencyPostRule.codeinteger
otherCurrencyPostRule.descriptionstring
pivotCurrency.codeinteger
pivotCurrency.descriptionstring
postDiffToLargestCarrier.codeinteger
postDiffToLargestCarrier.descriptionstring
primaryBudgetLedger.codestring
primaryBudgetLedger.descriptionstring
purchaseCommitmentLedger.codestring
purchaseCommitmentLedger.descriptionstring
quarterlyReturnMonth.codeinteger
quarterlyReturnMonth.descriptionstring
sourceBusinessUnitCodestring
sourceValue1Currencystring
sourceValue3Currencystring
supplierData.descriptionstring
targetSourceMemoValueinteger
targetSourceValue1integer
targetSourceValue2integer
targetSourceValue3integer
targetValue1Currencystring
targetValue3Currencystring
taxReturnTemplateIdinteger
the113CharacterFillerstring
the4thCurrValueBalAccountCrstring
the4thCurrValueBalAccountDrstring
the4thCurrencyAmountBalancing.codeinteger
the4thCurrencyAmountBalancing.descriptionstring
the4thCurrencyCalculateFrom.codeinteger
the4thCurrencyCalculateFrom.descriptionstring
the4thCurrencyPostingRule.codeinteger
the4thCurrencyPostingRule.descriptionstring
the4thCurrencyValueNamestring
the5thCurrValueBalAccountCrstring
the5thCurrValueBalAccountDrstring
the5thCurrencyAmountBalancing.codeinteger
the5thCurrencyAmountBalancing.descriptionstring
the5thCurrencyCalculateFrom.codeinteger
the5thCurrencyCalculateFrom.descriptionstring
the5thCurrencyPostingRule.codeinteger
the5thCurrencyPostingRule.descriptionstring
the5thCurrencyValueNamestring
transactionType.codeinteger
transactionType.descriptionstring
vATReturnPeriod.codeinteger
vATReturnPeriod.descriptionstring
val1DebitNetBalancingACstring
val2DebitNetBalancingACstring
val3DebitNetBalancingACstring
value1CreditBalancingACstring
value1RoundingThresholdnumber
value2CreditBalancingACstring
value3CreditBalancingACstring
value3CurAmountBalancing.codeinteger
value3CurAmountBalancing.descriptionstring
value3CurAmtDecimalPlaces.codeinteger
value3CurAmtDecimalPlaces.descriptionstring
value3CurrencyPostRule.codeinteger
value3CurrencyPostRule.descriptionstring
value3CurrencyType.codeinteger
value3CurrencyType.descriptionstring
value3RoundingThresholdnumber
value4CurAmtDecimalPlaces.codeinteger
value4CurAmtDecimalPlaces.descriptionstring
value5CurAmtDecimalPlaces.codeinteger
value5CurAmtDecimalPlaces.descriptionstring
warehouseData.codeinteger
warehouseData.descriptionstring
writeOnWriteOffBalancing.codeinteger
writeOnWriteOffBalancing.descriptionstring
writeOnWriteOffTolerancenumber
zoneData.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