Data Dictionary
Field | Type | Notes |
Batch Numbers | Text | API: Purchase Order Lines.BatchNumbers |
Comment | Text | API: Purchase 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. |
Cost Total (BC) | Number | API: Purchase Order Lines.BCCostTotal |
Created | Datetime | Derived from datetime with timezone conversion of Created |
Created By | Text | API: Purchase Order.CreatedBy |
Currency | Text | The ISO Currency Code, API: Currency.CurrencyCode |
Currency Rate | Number | API: Purchase Order.ExchangeRate |
Custom Order Status | Text | API: Purchase Order.CustomOrderStatus |
Data current as of | Datetime | Gives the date and time that this record was taken from Unleashed. |
Delivery Address City | Text | API: Purchase Order.DeliveryCity |
Delivery Address Country | Text | API: Purchase Order.DeliveryCountry |
Delivery Address Name | Text | API: Purchase Order.DeliveryName |
Delivery Address Post Code | Text | API: Purchase Order.DeliveryPostCode |
Delivery Address Region | Text | API: Purchase Order.DeliveryRegion |
Delivery Address Suburb | Text | API: Purchase Order.DeliverySuburb |
Delivery Date | Datetime | Derived from datetime with timezone conversion of Delivery Date |
Delivery Street Address | Text | API: Purchase Order.DeliveryStreetAddress |
Delivery Street Address 2 | Text | API: Purchase Order.DeliveryStreetAddress2 |
Discount Rate | Number | API: Purchase Order.DiscountRate |
Discounted Unit Price | Number | The Unit Price in the transaction currency after the Line Discount Rate has been appled., API: Purchase Order Lines.DiscountedUnitPrice |
Gross Amount | Number | Derived from adding Purchase Order Lines.LineTotal and Purchase Order Lines.LineTax |
Landed Cost (BC) | Number | Cost Total (BC) + Sub Total (BC), API: Purchase Order Lines.BCLandedCost |
Landed Unit Price (BC) | Number | Derived from dividing Landed Cost (BC) and Order Quantity |
Line Comment | Text | API: Purchase Order Lines.Comments |
Line Discount Rate | Number | API: Purchase Order Lines.DiscountRate |
Line Number | Integer | API: Purchase Order Lines.LineNumber |
Line Tax Rate | Number | Tax Rate, API: Purchase Order Lines.LineTaxRate |
Net Amount | Number | Net amount in the transaction currency. Order Quantity * Discounted Unit Price, API: Purchase Order Lines.LineTotal |
Order Date | Date | Derived from date conversion of Order Date |
Order Number | Text | API: Purchase Order.OrderNumber |
Order Quantity | Number | API: Purchase Order Lines.OrderQuantity |
Order Status | Text | API: Purchase Order.OrderStatus |
Pending Batch Numbers | Text | API: Purchase Order Lines.PendingBatchNumbers |
Pending Serial Numbers | Text | API: Purchase Order Lines.PendingSerialNumbers |
Printed | Text | API: Purchase Order.Printed |
Product Description | Text | Derived from cleaning Product Description |
Product GUID | Text | The Unique ID of a Product, API: Product.Guid |
Purchase Order GUID | Text | The Unique ID of a Purchase Order, API: Purchase Order.Guid |
Purchase Order Line GUID | Text | API: Purchase Order Lines.Guid |
Purchase Order Line Updated | Datetime | Updated, Derived from datetime with timezone conversion of Purchase Order Line Updated |
Purchase Order Line Updated By | Text | Updated By, API: Purchase Order Lines.LastModifiedBy |
Purchase Unit Order Quantity | Number | API: Purchase Order Lines.PurchaseUnitOrderQuantity |
Purchase Unit Receipt Quantity | Number | API: Purchase Order Lines.PurchaseUnitReceiptQuantity |
Receipt Quantity | Number | API: Purchase Order Lines.ReceiptQuantity |
Received Date | Datetime | Derived from datetime with timezone conversion of Received Date |
Serial Numbers | Text | API: Purchase Order Lines.SerialNumbers |
Sub Total (BC) | Number | Unit Price (BC) * Order Quantity, API: Purchase Order Lines.BCSubTotal |
Supplier GUID | Text | The Unique ID of a Supplier, API: Supplier.Guid |
Supplier Invoice Date | Date | Derived from date conversion of Supplier Invoice Date |
Supplier Name | Text | Supplier.Name, API: Supplier.SupplierName |
Supplier Reference | Text | Supplier Reference erence, API: Purchase Order.SupplierRef |
Tax Amount | Number | Tax amount in the transaction currency, API: Purchase Order Lines.LineTax |
Tax Code | Text | The Tax Code, e.g. V.A.T., API: Tax.TaxCode |
Total Volume | Number | API: Purchase Order.TotalVolume |
Total Weight | Number | API: Purchase Order.TotalWeight |
Unit Price | Number | The Unit Price in the transaction currency before the Line Discount Rate has been appled., API: Purchase Order Lines.UnitPrice |
Unit Price (BC) | Number | API: Purchase Order Lines.BCUnitPrice |
Unit of Measure Name | Text | Unit Of Measure Name |
Updated | Datetime | Derived from datetime with timezone conversion of Updated |
Updated By | Text | API: Purchase Order.LastModifiedBy |
Volume | Number | API: Purchase Order Lines.Volume |
Warehouse GUID | Text | The Unique ID of the Warehouse, API: Warehouse.Guid |
Warehouse Name | Text | API: Warehouse.WarehouseName |
Weight | Number | API: Purchase Order Lines.Weight |