Field

Type

Notes

Comment

Text

API: Product Price.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.

Customer GUID

Text

Unique ID for a Customer, API: Customer.Guid

Customer Name

Text

API: Customer.CustomerName

Customer Price

Number

API: Product Price.CustomerPrice

Data current as of

Datetime

Gives the date and time that this record was taken from Unleashed.

Default Sell Price

Number

API: Product Price.DefaultSellPrice

Discount Value

Number

API: Product Price.DiscountValue

Group Name

Text

API: Product Group.GroupName

Minimum Quantity

Number

API: Product Price.MinimumQuantity

Price Type

Text

API: Product Price.PriceType

Product Description

Text

Product GUID

Text

The Unique ID of a Product

Product Price GUID

Text

API: Product Price.Guid

Updated

Datetime

API: Derived from Product Price.LastModifiedOn

Valid From

Datetime

API: Derived from Product Price.ValidFrom

Valid To

Datetime

API: Derived from Product Price.ValidTo