Data Dictionary
Field | Type | Notes |
Batch Numbers | Text | API: Invoice Lines.BatchNumbers |
Comment | Text | API: Sales Invoice.Comments |
Connection Name | Text | The name of the Connection. Typically the name of the Unleashed Organisation. |
Created By | Text | API: Sales Invoice.CreatedBy |
Currency | Text | The ISO Currency Code, API: Currency.CurrencyCode |
Currency Rate | Number | API: Sales Invoice.ExchangeRate |
Customer GUID | Text | Unique ID for a Customer, API: Customer.Guid |
Customer Name | Text | API: Customer.CustomerName |
Data current as of | Datetime | Gives the date and time that this record was taken from Unleashed. |
Delivery Address City | Text | |
Delivery Address Country | Text | |
Delivery Address Instruction | Text | |
Delivery Address Name | Text | |
Delivery Address Post Code | Text | |
Delivery Address Region | Text | |
Delivery Address Suburb | Text | |
Delivery Street Address | Text | |
Delivery Street Address 2 | Text | |
Discount Rate | Number | API: Invoice Lines.DiscountRate |
Due Date | Date | API: Derived from Sales Invoice.DueDate |
Gross Amount | Number | API: Derived from adding Invoice Lines.LineTotal and Invoice Lines.LineTax |
Gross Amount (BC) | Number | API: Derived from dividing |
Invoice Date | Date | API: Derived from Sales Invoice.InvoiceDate |
Invoice Number | Text | API: Sales Invoice.InvoiceNumber |
Invoice Quantity | Number | API: Invoice Lines.InvoiceQuantity |
Invoice Status | Text | API: Sales Invoice.InvoiceStatus |
Line Comment | Text | API: Invoice Lines.Comments |
Line Number | Integer | API: Invoice Lines.LineNumber |
Line Type | Text | API: Invoice Lines.LineType |
Line Updated | Datetime | API: Derived from Invoice Lines.LastModifiedOn |
Net Amount | Number | API: Invoice Lines.LineTotal |
Order Number | Text | API: Sales Invoice.OrderNumber |
Order Quantity | Number | API: Invoice Lines.OrderQuantity |
Payment Received | Boolean | API: Sales Invoice.PaymentReceived |
Payment Term | Text | API: Sales Invoice.PaymentTerm |
Postal Address City | Text | |
Postal Address Country | Text | |
Postal Address Instruction | Text | |
Postal Address Name | Text | |
Postal Address Postal Code | Text | |
Postal Address Region | Text | |
Postal Address Suburb | Text | |
Postal Street Address | Text | |
Postal Street Address 2 | Text | |
Product Description | Text | |
Product GUID | Text | The Unique ID of a Product |
Quote Number | Text | API: Sales Invoice.QuoteNumber |
Serial Numbers | Text | API: Invoice Lines.SerialNumbers |
Tax Amount | Number | API: Invoice Lines.LineTax |
Tax Code | Text | API: Invoice Lines.LineTaxCode |
Tax Rate | Number | API: Invoice Lines.TaxRate |
Unit Price | Number | API: Invoice Lines.UnitPrice |
Unit Price (BC) | Number | Unit Price (Base Currency), API: Invoice Lines.BCUnitPrice |
Updated | Datetime | API: Derived from Invoice Lines.LastModifiedOn |