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 |