Data Dictionary
Field | Type | Notes |
Batch Numbers | JSON | API: Array of Credit Lines.BatchNumbers |
Comment | Text | API: Credit Note.Comments |
Connection Name | Text | The name of the Connection. Typically the name of the Unleashed Organisation. |
Created | Datetime | API: Credit Note.CreatedOn |
Created By | Text | API: Credit Note.CreatedBy |
Credit Date | Date | API: Credit Note.CreditDate |
Credit Line Comment | Text | Comment, API: Credit Lines.Comments |
Credit Line GUID | Text | API: Credit Lines.Guid |
Credit Line Updated | Datetime | Updated, API: Credit Lines.LastModifiedOn |
Credit Number | Text | API: Credit Note.CreditNumber |
Credit Price | Number | API: Credit Lines.CreditPrice |
Credit Quantity | Number | API: Credit Lines.CreditQuantity |
Credit Status | Text | API: Credit Note.CreditStatus |
Currency | Text | The ISO Currency Code, API: Currency.CurrencyCode |
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. |
Disassemble | Boolean | API: Credit Lines.Disassemble |
Invoice Date | Date | API: Credit Note.SalesInvoiceDate |
Invoice Number | Text | API: Credit Note.InvoiceNumber |
Line Number | Integer | API: Credit Lines.LineNumber |
Line Tax | Number | API: Credit Lines.LineTax |
Line Tax Code | Text | API: Credit Lines.LineTaxCode |
Line Tax Rate | Number | Tax Rate, API: Credit Lines.TaxRate |
Line Total | Number | API: Credit Lines.LineTotal |
Line Type | Text | API: Credit Lines.LineType |
Line Xero Tax Code | Text | Xero Tax Code, API: Credit Lines.XeroTaxCode |
Order Quantity | Number | API: Credit Lines.OrderQuantity |
Pending Batch Numbers | JSON | API: Array of Credit Lines.PendingBatchNumbers |
Pending Serial Numbers | JSON | API: Array of Credit Lines.PendingSerialNumbers |
Product Description | Text | |
Product GUID | Text | The Unique ID of a Product |
Reason | Text | API: Credit Lines.Reason |
Reference | Text | API: Credit Note.Reference |
Reference Number | Text | API: Credit Note.ReferenceNumber |
Required Delivery Date | Date | API: Credit Note.RequiredDeliveryDate |
Return | Boolean | API: Credit Lines.Return |
Sales Order GUID | Text | The Unique ID for a Sales Order, API: Sales Order.Guid |
Serial Numbers | JSON | API: Array of Credit Lines.SerialNumbers |
Sub Total | Number | API: Credit Note.SubTotal |
Tax Code | Text | The Tax Code, e.g. V.A.T., API: Tax.TaxCode |
Tax Rate | Number | API: Credit Note.TaxRate |
Tax Total | Number | API: Credit Note.TaxTotal |
Total | Number | API: Credit Note.Total |
Unit Price | Number | API: Credit Lines.UnitPrice |
Updated | Datetime | API: Credit Note.LastModifiedOn |
Updated By | Text | API: Credit Note.LastModifiedBy |
Warehouse GUID | Text | Warehouse.Guid, API: Warehouse.Guid |
Warehouse Name | Text | Warehouse.Name, API: Warehouse.WarehouseName |
Xero Sales Account | Text | API: Credit Lines.XeroSalesAccount |
Xero Tax Code | Text | API: Credit Note.XeroTaxCode |
