Data Dictionary
Field | Type | Notes |
Addresses | JSON | API: Array of Customer.Addresses |
Bank Account | Text | API: Customer.BankAccount |
Bank Branch | Text | API: Customer.BankBranch |
Bank Name | Text | API: Customer.BankName |
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 | API: Derived from combining |
Created | Datetime | API: Derived from Customer.CreatedOn |
Created By | Text | API: Customer.CreatedBy |
Currency | Text | The ISO Currency Code, API: Currency.CurrencyCode |
Customer Code | Text | API: Customer.CustomerCode |
Customer GUID | Text | Unique ID for a Customer, API: Customer.Customer.Guid |
Customer Name | Text | API: Customer.Customer.CustomerName |
Customer Type | Text | API: Customer.CustomerType |
DDI Number | Text | API: Customer.DDINumber |
Data current as of | Datetime | Gives the date and time that this record was taken from Unleashed. |
Discount Rate | Number | API: Customer.DiscountRate |
Text | API: Customer.Email | |
Email cc | Text | API: Customer.EmailCC |
Fax Number | Text | API: Customer.FaxNumber |
Mobile Number | Text | API: Customer.MobileNumber |
Notes | Text | API: Customer.Notes |
Obsolete | Boolean | API: Customer.Obsolete |
Payment Term | Text | API: Customer.PaymentTerm |
Phone Number | Text | API: Customer.PhoneNumber |
Print Invoice | Boolean | API: Customer.PrintInvoice |
Print Packing Slip Instead Of Invoice | Boolean | API: Customer.PrintPackingSlipInsteadOfInvoice |
Sales Person | Text | API: Customer.Salesperson |
Sell Price Tier | Text | API: Customer.SellPriceTier |
Sell Price Tier Reference | Text | API: Customer.SellPriceTierReference |
Stop Credit | Boolean | API: Customer.StopCredit |
Tax Code | Text | API: Customer.TaxCode |
Tax Number | Text | Tax Number e.g. VAT or GST Number, API: Customer.GSTVATNumber |
Tax Rate | Text | API: Customer.TaxRate |
Taxable | Boolean | API: Customer.Taxable |
Toll Free Number | Text | API: Customer.TollFreeNumber |
Updated | Datetime | API: Derived from Customer.LastModifiedOn |
Updated By | Text | API: Customer.LastModifiedBy |
Website | Text | API: Customer.Website |
Xero Cost Of Goods Account | Text | API: Customer.XeroCostOfGoodsAccount |
Xero Sales Account | Text | API: Customer.XeroSalesAccount |
