API Data Provider - Online Help

Orders

Retrieves a list of all orders.

Columns

Name Type References
Id [KEY] Integer
Status String
Title String
Total Double
TotalDue Double
TotalPaid Double
ContactId Integer

Contacts.Id

ContactEmail String
ContactFirstName String
ContactLastName String
ContactJobTitle String
ContactCompanyName String
AllowPayment Boolean
AllowPaypal Boolean
OrderDate Datetime
CreationDate Datetime
ModificationDate Datetime
LeadAffiliateId Integer
Notes String
OrderItems String
PaymentPlanAutoCharge Boolean
PaymentPlanCreditCardId Integer
PaymentPlanDaysBetweenPayments Integer
PaymentPlanInitialPaymentAmount Double
PaymentPlanInitialPaymentDate Date
PaymentPlanNumberOfPayments Integer
PaymentPlanPaymentGatewayMerchantAccountId Integer
PaymentPlanPaymentGatewayUseDefault Boolean
PaymentPlanPlanStartDate Date
Recurring Boolean
RefundTotal Double
SalesAffiliateId Integer
ShippingInformationCompany String
ShippingInformationCountryCode String
ShippingInformationFirstName String
ShippingInformationLastName String
ShippingInformationLine1 String
ShippingInformationLine2 String
ShippingInformationLocality String
ShippingInformationMiddleName String
ShippingInformationPhone String
ShippingInformationRegion String
ShippingInformationZipCode String
ShippingInformationZipFour String
SourceType String
Terms String

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