billOfMaterialsComponentIdinteger
billOfMaterialsVersionnumber
creditLimitCheckHeld.codeinteger
creditLimitCheckHeld.descriptionstring
creditStatus.descriptionstring
customersRequestedDueDatestring
dateTimeLastUpdatedstring
deliveryAddressCodestring
discount1Percentagenumber
discount2Percentagenumber
dispatchConfirmationStatus.codeinteger
dispatchConfirmationStatus.descriptionstring
dispatchStatus.codeinteger
dispatchStatus.descriptionstring
inProgress.descriptionstring
invoiceStatus.codeinteger
invoiceStatus.descriptionstring
latePaymentPercentagenumber
miscellaneousDescription1string
miscellaneousDescription2string
miscellaneousInput1string
miscellaneousInput2string
miscellaneousReference1string
miscellaneousReference2string
negativeOrPositive.codeinteger
negativeOrPositive.descriptionstring
originalDemandQuantitynumber
overdueInvoiceHeld.codeinteger
overdueInvoiceHeld.descriptionstring
paymentTermsGroupCodestring
pickConfirmationStatus.codeinteger
pickConfirmationStatus.descriptionstring
pickingStatus.codeinteger
pickingStatus.descriptionstring
promotionalPriceBookinteger
reportingUnitOfMeasurestring
reserved.descriptionstring
salesKitParentLineNumberinteger
salesKitParentTransRefstring
salesOrderLineNumberinteger
salesOrderLineRevisioninteger
salesOrderReferencestring
salesReturnItemCodestring
salesReturnLocationIdstring
salesReturnSerialNumberstring
salespersonRole.codeinteger
salespersonRole.descriptionstring
standardTextClassCodestring
standardTextDateTimeLastUpdatedstring
standardTextUpdateCountinteger
standardTextUserIdLastUpdatedstring
startOfActivityDatestring
updateInventory.codeinteger
updateInventory.descriptionstring
wholeOrderLineOverride.codeinteger
wholeOrderLineOverride.descriptionstring
wholeSalesKitOverride.codeinteger
wholeSalesKitOverride.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