Data Dictionary
Field | Type | Notes |
Accepted Date | Text | API: Sales Quotes.AcceptedDate |
Comment | Text | API: Sales Quotes.Comments |
Connection Name | Text | The name of the Connection. Typically the name of the Unleashed Organisation. |
Created By | Text | API: Sales Quotes.CreatedBy |
Currency | Text | The ISO Currency Code, API: Currency.CurrencyCode |
Customer GUID | Text | Unique ID for a Customer, API: Customer.Guid |
Customer Name | Text | API: Customer.CustomerName |
Customer Ref | Text | API: Sales Quotes.CustomerRef |
Data current as of | Datetime | Gives the date and time that this record was taken from Unleashed. |
Delivery City | Text | API: Sales Quotes.DeliveryCity |
Delivery Country | Text | API: Sales Quotes.DeliveryCountry |
Delivery Method | Text | API: Sales Quotes.DeliveryMethod |
Delivery Name | Text | API: Sales Quotes.DeliveryName |
Delivery Post Code | Text | API: Sales Quotes.DeliveryPostCode |
Delivery Region | Text | API: Sales Quotes.DeliveryRegion |
Delivery Street Address | Text | API: Sales Quotes.DeliveryStreetAddress |
Delivery Street Address2 | Text | API: Sales Quotes.DeliveryStreetAddress2 |
Delivery Suburb | Text | API: Sales Quotes.DeliverySuburb |
Discount Rate | Number | API: Sales Quotes.DiscountRate |
Exchange Rate | Number | API: Sales Quotes.ExchangeRate |
Quote Date | Datetime | API: Sales Quotes.QuoteDate |
Quote Expiry Date | Date | API: Sales Quotes.QuoteExpiryDate |
Quote Number | Text | API: Sales Quotes.QuoteNumber |
Quote Status | Text | API: Sales Quotes.QuoteStatus |
Sales Order Group | Text | API: Sales Quotes.SalesOrderGroup |
Sales Quote GUID | Text | API: Sales Quotes.Guid |
Sales Quote Lines | JSON | API: Array of Sales Quotes.SalesQuoteLines |
Salesperson | Text | ToDo is this the GUID/email/entire object of Salesperson?, API: Sales Quotes.Salesperson |
Source ID | Text | API: Sales Quotes.SourceId |
Sub Total | Number | API: Sales Quotes.SubTotal |
Sub Total (BC) | Number | API: Sales Quotes.BCSubTotal |
Tax Code | Text | The Tax Code, e.g. V.A.T., API: Tax.TaxCode |
Tax Rate | Number | API: Sales Quotes.TaxRate |
Tax Total | Number | API: Sales Quotes.TaxTotal |
Tax Total (BC) | Number | API: Sales Quotes.BCTaxTotal |
Total | Number | API: Sales Quotes.Total |
Total (BC) | Number | API: Sales Quotes.BCTotal |
Total Volume | Number | API: Sales Quotes.TotalVolume |
Total Weight | Number | API: Sales Quotes.TotalWeight |
Updated | Datetime | API: Sales Quotes.LastModifiedOn |
Warehouse GUID | Text | Warehouse.Guid, API: Warehouse.Guid |
Warehouse Name | Text | Warehouse.Name, API: Warehouse.WarehouseName |
Xero Tax Code | Text | API: Sales Quotes.XeroTaxCode |
