Data Dictionary
Field | Type | Notes |
Connection Name | Text | The name of the Connection. Typically the name of the Xero Organisation. |
Contact ID | Text | The unique identifier for the Contact. This is guaranteed to be unique within a Xero Organisation. |
Contact Name | Text | The name of the Contact (Supplier or Customer). |
Currency Code | Text | Currency Code |
Data current as of | Datetime | When the Data was taken from Xero. |
Description | Text | Description |
Discount Amount | Number | Discount Amount |
Expiry Date | Text | Expiry Date |
Gross Amount | Text | Gross Amount |
Is New Business | Boolean | Calculated as True if the Contact has not purchased anything previously. |
Last Updated | Text | Updated Date UTC |
Net Amount | Text | Net Amount |
Product Code | Text | Item Code |
Quantity | Number | Quantity |
Quote Date | Text | Date |
Quote ID | Text | Quote ID |
Quote Number | Text | Quote Number |
Quote Status | Text | Status |
Summary | Text | Summary |
Tax Amount | Number | Tax Amount |
Tax Type | Text | Tax Type |
Title | Text | Title |
Tracking Category 0 | Text | |
Tracking Category 1 | Text | |
Tracking Option 0 | Text | Tracking Options are concatenated with the Tracking Category e.g. '[Tracking Category 0] - [Tracking Option 0]' |
Tracking Option 1 | Text | Tracking Options are concatenated with the Tracking Category e.g. '[Tracking Category 1] - [Tracking Option 1]' |
Unit Amount | Number | Unit Amount |