Data Dictionary
Field | Type | Notes |
Allocate Product | Boolean | API: Sales Order.AllocateProduct |
Assembly | Text | API: Sales Order Lines.Assembly |
Average Landed Price At Time Of Sale | Number | API: Sales Order Lines.AverageLandedPriceAtTimeOfSale |
Batch Numbers | Text | API: Sales Order Lines.BatchNumbers |
Comment | Text | API: Sales Order.Comments |
Completed Date | Datetime | Derived from datetime with timezone conversion of Completed Date |
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. |
Contact Name | Text | Derived from combining 'contact_stub.FirstName' and 'contact_stub.LastName' |
Created | Datetime | Derived from datetime with timezone conversion of Created |
Created By | Text | API: Sales Order.CreatedBy |
Currency | Text | The ISO Currency Code, API: Currency.CurrencyCode |
Currency Rate | Number | API: Sales Order.ExchangeRate |
Custom Order Status | Text | API: Sales Order.CustomOrderStatus |
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 Order.CustomerRef |
Data current as of | Datetime | Gives the date and time that this record was taken from Unleashed. |
Delivery Address City | Text | API: Sales Order.DeliveryCity |
Delivery Address Country | Text | API: Sales Order.DeliveryCountry |
Delivery Address Instruction | Text | API: Sales Order.DeliveryInstruction |
Delivery Address Name | Text | API: Sales Order.DeliveryName |
Delivery Address Post Code | Text | API: Sales Order.DeliveryPostCode |
Delivery Address Region | Text | API: Sales Order.DeliveryRegion |
Delivery Address Suburb | Text | API: Sales Order.DeliverySuburb |
Delivery Method | Text | API: Sales Order.DeliveryMethod |
Delivery Street Address | Text | API: Sales Order.DeliveryStreetAddress |
Delivery Street Address 2 | Text | API: Sales Order.DeliveryStreetAddress2 |
Discount Rate | Number | API: Sales Order.DiscountRate |
Due Date | Date | Derived from date conversion of Due Date |
Gross Amount | Number | Derived from adding Sales Order Lines.LineTotal and Sales Order Lines.LineTax |
Gross Amount (BC) | Number | Derived from adding Sales Order Lines.BCLineTotal and Sales Order Lines.BCLineTax |
Line Comment | Text | API: Sales Order Lines.Comments |
Line Discount Rate | Number | API: Sales Order Lines.DiscountRate |
Line Number | Integer | API: Sales Order Lines.LineNumber |
Line Type | Text | API: Sales Order Lines.LineType |
Line Updated | Datetime | Derived from datetime with timezone conversion of Line Updated |
Net Amount | Number | API: Sales Order Lines.LineTotal |
Net Amount (BC) | Number | API: Sales Order Lines.BCLineTotal |
Order Date | Date | Derived from date conversion of Order Date |
Order GUID | Text | The Unique ID for a Sales Order, API: Sales Order.Guid |
Order Group | Text | API: Sales Order.SalesOrderGroup |
Order Number | Text | API: Sales Order.OrderNumber |
Order Quantity | Number | API: Sales Order Lines.OrderQuantity |
Order Status | Text | API: Sales Order.OrderStatus |
Payment Due Date | Date | Derived from date conversion of Payment Due Date |
Product Description | Text | Derived from cleaning Product Description |
Product GUID | Text | The Unique ID of a Product, API: Product.Guid |
Received Date | Text | API: Sales Order.ReceivedDate |
Required Date | Datetime | Derived from datetime with timezone conversion of Required Date |
Sales Order Line GUID | Text | API: Sales Order Lines.Guid |
Salesperson | Text | ToDo is this the GUID/email/entire object of Salesperson?, API: Sales Order.Salesperson |
Send Accounting Journal Only | Boolean | API: Sales Order.SendAccountingJournalOnly |
Serial Numbers | Text | API: Sales Order Lines.SerialNumbers |
Source ID | Text | API: Sales Order.SourceId |
Tax Amount | Number | API: Sales Order Lines.LineTax |
Tax Amount (BC) | Number | API: Sales Order Lines.BCLineTax |
Tax Code | Text | API: Sales Order Lines.LineTaxCode |
Tax Rate | Number | API: Sales Order Lines.TaxRate |
Unit Price (BC) | Number | API: Sales Order Lines.BCUnitPrice |
Updated | Datetime | Derived from datetime with timezone conversion of Updated |
Updated By | Text | API: Sales Order.LastModifiedBy |
Volume | Text | API: Sales Order Lines.Volume |
Warehouse GUID | Text | The Unique ID of the Warehouse, API: Warehouse.Guid |
Warehouse Name | Text | API: Warehouse.WarehouseName |
Weight | Text | API: Sales Order Lines.Weight |
Xero Sales Account | Text | API: Sales Order Lines.XeroSalesAccount |
Xero Tax Code | Text | API: Sales Order Lines.XeroTaxCode |