API Data Provider - Online Help

Sales

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

Columns

Name Type References
Id [KEY] Integer
SaleType String

The allowed values are Quote, SalesOrder, Invoice, QuickSale, CreditMemo.

Date Datetime
CreatedAt Datetime
DueDate Datetime
Closed Boolean
Void Boolean
TaxAmount Double
Subtotal Double
GrandTotal Double
Phone String
AltPhone String
StatusActive Boolean
StatusId Integer
StatusName String
SalespersonId String
CreatedBy String
Class String
CustomerId Integer
CustomerName String
CustomerPhone String
CustomerActive Boolean
CustomerBalance Double
CustomerBillingAddressCity String
CustomerBillingAddressCountry String
CustomerBillingAddressId Integer
CustomerBillingAddressLine1 String
CustomerBillingAddressName String
CustomerBillingAddressState String
CustomerBillingAddressZipcode String
CustomerContact String
CustomerCreatedAt Datetime
CustomerCreditHold Boolean
CustomerEmail String
CustomerStatusUpdateViaText Boolean
CustomerWebsite String
PaymentTerm String
ShippingMethod String
TaxItemId String
TaxItemName String
TaxItemRate String
TaxItemActive Boolean
TaxItemMemo String
TaxItemTaxAgency String
TaxGroupId String
TaxGroupName String
TaxGroupRate String
TaxGroupActive Boolean
TaxGroupMemo String
TaxGroupTaxItems String
SiteId Integer
SiteName String
SiteActive Boolean
SiteAddressCity String
SiteAddressCountry String
SiteAddressId Integer
SiteAddressLine1 String
SiteAddressState String
SiteAddressZipcode String
BillingAddressCity String
BillingAddressCountry String
BillingAddressId Integer
BillingAddressLine1 String
BillingAddressName String
BillingAddressState String
BillingAddressZipcode String
ShippingAddressCity String
ShippingAddressCountry String
ShippingAddressId Integer
ShippingAddressLine1 String
ShippingAddressName String
ShippingAddressState String
ShippingAddressZipcode String
QuickSalePaymentDetail String
Lines String

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