API Data Provider - Online Help

Expenses

Retrieves a list of expense objects based on a given criteria.

Columns

Name Type References
Id [KEY] Integer
ExpenseType String

The allowed values are Check, CashExpense, CreditCardCharge, CreditCardRefund.

Date Datetime
RefNr String
CheckNr String
IsVoid Boolean
IsCleared Boolean
Memo String
GrandTotal Double
CreatedBy String
AccountId Integer
AccountName String
AccountAccountNr String
AccountAccountType String
AccountActive Boolean
AccountBankAccountDetailsBankAccountNumber String
AccountBankAccountDetailsBankName String
CustomerId Integer
CustomerAccountNr String
CustomerActive Boolean
CustomerAltPhone String
CustomerBalance Double
CustomerBillingAddressCity String
CustomerBillingAddressCountry String
CustomerBillingAddressId Integer
CustomerBillingAddressLine1 String
CustomerBillingAddressLine2 String
CustomerBillingAddressName String
CustomerBillingAddressState String
CustomerBillingAddressZipcode String
CustomerClassId Integer
CustomerClassName String
CustomerContact String
CustomerCreatedAt Datetime
CustomerCreditHold Boolean
CustomerCreditLimit Double
CustomerEmails String
CustomerFax String
CustomerMemo String
CustomerName String
CustomerPhone String
CustomerResaleNr String
CustomerShippingAddressCity String
CustomerShippingAddressCountry String
CustomerShippingAddressId Integer
CustomerShippingAddressLine1 String
CustomerShippingAddressName String
CustomerShippingAddressState String
CustomerShippingAddressZipcode String
CustomerStatusUpdateViaText Boolean
CustomerTaxTypeAbbr String
CustomerTaxTypeActive Boolean
CustomerTaxTypeId Integer
CustomerTaxTypeName String
CustomerTaxTypeTaxable Boolean
CustomerWebsite String
VendorId Integer
VendorName String
VendorActive Boolean
VendorBalance Integer
VendorBillingAddressId Integer
VendorBillingAddressLine1 String
VendorBillingAddressLine2 String
VendorBillingAddressZipcode String
VendorContact String
SiteId Integer
SiteName String
SitePhone String
SiteActive Boolean
SiteAddressCity String
SiteAddressCountry String
SiteAddressId Integer
SiteAddressLine1 String
SiteAddressState String
SiteAddressZipcode String
Lines String

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839.0