Orders
Retrieves a list of all orders.
Columns
| Name | Type | References | |
| Id [KEY] | Integer | ||
| Status | String | ||
| Title | String | ||
| Total | Decimal | ||
| TotalDue | Decimal | ||
| TotalPaid | Decimal | ||
| ContactId | Integer |
Contacts.Id | |
| ContactEmail | String | ||
| ContactFirstName | String | ||
| ContactLastName | String | ||
| ContactJobTitle | String | ||
| ContactCompanyName | String | ||
| IsPaymentAllowed | Boolean | ||
| IsPaypalAllowed | Boolean | ||
| InvoiceNumber | Integer | ||
| OrderDate | Datetime | ||
| OrderType | String | ||
| CreationDate | Datetime | ||
| ModificationDate | Datetime | ||
| LeadAffiliateId | Integer | ||
| Notes | String | ||
| OrderItems | String | ||
| IsPaymentPlanAutoCharge | Boolean | ||
| PaymentPlanCreditCardId | Integer | ||
| PaymentPlanDaysBetweenPayments | Integer | ||
| PaymentPlanDaysBetweenRetries | Integer | ||
| PaymentPlanInitialPaymentAmount | Decimal | ||
| PaymentPlanInitialPaymentDate | Datetime | ||
| PaymentPlanInitialPaymentPercent | Double | ||
| PaymentPlanMaxChargeAttempts | Integer | ||
| PaymentPlanNumberOfPayments | Integer | ||
| PaymentPlanPaymentGatewayMerchantAccountId | Integer | ||
| PaymentPlanPaymentGatewayMerchantAccountName | String | ||
| IsPaymentPlanGatewayDefaultUsed | Boolean | ||
| PaymentPlanPaymentMethodId | Integer | ||
| PaymentPlanPlanStartDate | Date | ||
| IsRecurring | Boolean | ||
| RefundTotal | Decimal | ||
| SalesAffiliateId | Integer | ||
| ShippingInformationCompany | String | ||
| ShippingInformationCity | String | ||
| ShippingInformationCountry | String | ||
| ShippingInformationId | String | ||
| ShippingInformationFirstName | String | ||
| ShippingInformationLastName | String | ||
| ShippingInformationStreet1 | String | ||
| ShippingInformationStreet2 | String | ||
| ShippingInformationState | String | ||
| IsShippingInformationInvoiceToCompany | Boolean | ||
| ShippingInformationMiddleName | String | ||
| ShippingInformationPhone | String | ||
| ShippingInformationZip | String | ||
| SourceType | String | ||
| Terms | String | ||
| ProductId | Integer |