Estimates
Retrieve the list of estimates.
Columns
Name | Type | References | |
Id [KEY] | Integer | ||
Uuid | String | ||
Type | Integer | ||
Active | Boolean | ||
Adjustment | Integer | ||
AdjustmentDescription | String | ||
AssigneeId | Integer | ||
BillFromAddress | String | ||
BillFromCity | String | ||
BillFromCountryId | Integer | ||
BillFromState | String | ||
BillFromZip | String | ||
BillToAddress | String | ||
BillToCity | String | ||
BillToCountryId | Integer | ||
BillToState | String | ||
BillToZip | String | ||
CompanyPhone | String | ||
CompanyPhone2 | String | ||
CompanyVat | String | ||
CompanyVat2 | String | ||
ContactPerson | String | ||
ContactPersonPosition | String | ||
CreatedBy | Integer | ||
CurrencyCode | String | ||
CurrencyId | Integer | ||
CustomerId | Integer | ||
CustomerLegalName | String | ||
CustomerName | String | ||
Discount | Integer | ||
DiscountBeforeTax | Boolean | ||
EstimateEmailedDate | String | ||
EstimateFooterText | String | ||
EstimateNumber | Integer | ||
EstimateNumberPrint | String | ||
EstimateTermsText | String | ||
ExchangeRate | Integer | ||
ExpireDate | Date | ||
GroupId | Integer | ||
InvoiceDate | Date | ||
IsDiscountPercent | Boolean | ||
Model | String | ||
ModelId | Integer | ||
Module | String | ||
OrgId | Integer | ||
OrgPhone | String | ||
OrgPhone2 | String | ||
OrgVat | String | ||
OrgVat2 | String | ||
PricelistId | Integer | ||
Ref | String | ||
RefId | String | ||
ReferenceNumber | String | ||
ShippingCharge | Integer | ||
StatusId | Integer | ||
SubTotal | Double | ||
TaxTotal | Double | ||
Tax1 | Integer | ||
Tax1Included | Boolean | ||
Tax2 | Integer | ||
Tax2Included | Boolean | ||
TemplateId | Integer | ||
Total | Double | ||
UpdatedBy | Integer | ||
UpdatedDate | Datetime |