Data Dictionary
Field | Type | Notes |
Accepted Date | Text | API: Sales Quotes.AcceptedDate |
Comment | Text | API: Sales Quotes.Comments |
Connection ID | Integer | The Connectorly Connection ID. If you group Connectorly's together, then you will see a Connection ID for each one. Organisations has the corresponding Connection Name for each Connection ID. |
Created By | Text | API: Sales Quotes.CreatedBy |
Currency | Text | The ISO Currency Code, API: Currency.CurrencyCode |
Currency Rate | Number | API: Sales Quotes.ExchangeRate |
Customer GUID | Text | Unique ID for a Customer, API: Customer.Guid |
Customer Name | Text | API: Customer.CustomerName |
Customer Reference | Text | Customer Reference erence, API: Sales Quotes.CustomerRef |
Data current as of | Datetime | Gives the date and time that this record was taken from Unleashed. |
Delivery Address City | Text | API: Sales Quotes.DeliveryCity |
Delivery Address Country | Text | API: Sales Quotes.DeliveryCountry |
Delivery Address Name | Text | API: Sales Quotes.DeliveryName |
Delivery Address Post Code | Text | API: Sales Quotes.DeliveryPostCode |
Delivery Address Region | Text | API: Sales Quotes.DeliveryRegion |
Delivery Address Suburb | Text | API: Sales Quotes.DeliverySuburb |
Delivery Method | Text | API: Sales Quotes.DeliveryMethod |
Delivery Street Address | Text | API: Sales Quotes.DeliveryStreetAddress |
Delivery Street Address 2 | Text | API: Sales Quotes.DeliveryStreetAddress2 |
Discount Rate | Number | API: Sales Quote Lines.DiscountRate |
Gross Amount | Number | API: Derived from adding Sales Quote Lines.LineTotal and Sales Quote Lines.LineTax |
Gross Amount (BC) | Number | API: Derived from adding Sales Quote Lines.BCLineTotal and Sales Quote Lines.BCLineTax |
Line Comment | Text | API: Sales Quote Lines.Comments |
Line Number | Integer | API: Sales Quote Lines.LineNumber |
Line Type | Text | API: Sales Quote Lines.LineType |
Line Updated | Datetime | API: Derived from Sales Quote Lines.LastModifiedOn |
Net Amount | Number | API: Sales Quote Lines.LineTotal |
Net Amount (BC) | Number | API: Sales Quote Lines.BCLineTotal |
Order Group | Text | API: Sales Quotes.SalesOrderGroup |
Order Quantity | Number | API: Sales Quote Lines.OrderQuantity |
Product Description | Text | |
Product GUID | Text | The Unique ID of a Product |
Quote Date | Datetime | API: Derived from Sales Quotes.QuoteDate |
Quote Expiry Date | Date | API: Derived from Sales Quotes.QuoteExpiryDate |
Quote GUID | Text | API: Sales Quotes.Guid |
Quote Number | Text | API: Sales Quotes.QuoteNumber |
Quote Quantity | Number | API: Sales Quote Lines.QuoteQuantity |
Quote Status | Text | API: Sales Quotes.QuoteStatus |
Sales Person | Text | API: Sales Quotes.Salesperson |
Source ID | Text | API: Sales Quotes.SourceId |
Tax Amount | Number | API: Sales Quote Lines.LineTax |
Tax Amount (BC) | Number | API: Sales Quote Lines.BCLineTax |
Tax Code | Text | API: Sales Quote Lines.LineTaxCode |
Tax Rate | Number | API: Sales Quote Lines.TaxRate |
Unit Cost | Number | API: Sales Quote Lines.UnitCost |
Unit Price | Number | API: Sales Quote Lines.UnitPrice |
Unit Price (BC) | Number | API: Sales Quote Lines.BCUnitPrice |
Updated | Datetime | API: Derived from Sales Quote Lines.LastModifiedOn |
Volume | Text | API: Sales Quote Lines.Volume |
Warehouse GUID | Text | The Unique ID of the Warehouse, API: Warehouse.Guid |
Warehouse Name | Text | API: Warehouse.WarehouseName |
Weight | Text | API: Sales Quote Lines.Weight |
Xero Sales Account | Text | API: Sales Quote Lines.XeroSalesAccount |
Xero Tax Code | Text | API: Sales Quote Lines.XeroTaxCode |