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: Derived from Credit Note.CreatedOn |
Created By | Text | API: Credit Note.CreatedBy |
Credit Date | Date | API: Derived from Credit Note.CreditDate |
Credit Line Comment | Text | API: Credit Lines.Comments |
Credit Line GUID | Text | API: Credit Lines.Guid |
Credit Note GUID | Text | API: Credit Note.Guid |
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 |
Gross Amount | Number | API: Derived from adding Credit Lines.LineTotal and Credit Lines.LineTax |
Invoice Date | Date | API: Derived from Credit Note.SalesInvoiceDate |
Invoice Number | Text | API: Credit Note.InvoiceNumber |
Line Number | Integer | API: Credit Lines.LineNumber |
Line Type | Text | API: Credit Lines.LineType |
Line Updated | Datetime | API: Derived from Credit Lines.LastModifiedOn |
Net Amount | Number | API: Credit Lines.LineTotal |
Order GUID | Text | The Unique ID for a Sales Order, API: Sales Order.Guid |
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: Derived from Credit Note.RequiredDeliveryDate |
Return | Boolean | API: Credit Lines.Return |
Serial Numbers | JSON | API: Array of Credit Lines.SerialNumbers |
Tax Amount | Number | API: Credit Lines.LineTax |
Tax Code | Text | API: Credit Lines.LineTaxCode |
Tax Rate | Number | API: Credit Lines.TaxRate |
Unit Price | Number | API: Credit Lines.UnitPrice |
Updated | Datetime | API: Derived from Credit Lines.LastModifiedOn |
Updated By | Text | API: Credit Note.LastModifiedBy |
Warehouse GUID | Text | The Unique ID of the Warehouse, API: Warehouse.Guid |
Warehouse Name | Text | API: Warehouse.WarehouseName |
Xero Sales Account | Text | API: Credit Lines.XeroSalesAccount |
Xero Tax Code | Text | API: Credit Lines.XeroTaxCode |
