Skip to main content

Quotes

Written by Nick Maxwell

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

Derived from cleaning 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

Derived from adding Sales Quote Lines.LineTotal and Sales Quote Lines.LineTax

Gross Amount (BC)

Number

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

Derived from datetime with timezone conversion of Line Updated

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

Derived from cleaning Product Description

Product GUID

Text

The Unique ID of a Product, API: Product.Guid

Quote Date

Datetime

Derived from datetime with timezone conversion of Quote Date

Quote Expiry Date

Date

Derived from date conversion of Quote Expiry Date

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

Sales Quote Line GUID

Text

API: Sales Quote Lines.Guid

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

Derived from datetime with timezone conversion of Updated

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

Did this answer your question?