Data Dictionary
Field | Type | Notes |
Account Code | Text | Account Code |
Attention To | Text | Attention To |
Attention To | Text | Attention To |
Connection Name | Text | The name of the Connection. Typically the name of the Xero Organisation. |
Contact ID | Text | Contact ID |
Contact Name | Text | Name |
Currency Code | Text | Currency Code |
Currency Rate | Number | Currency Rate |
Data current as of | Datetime | When the Data was taken from Xero. |
Delivery Address | Text | Delivery Address |
Delivery Date | Text | Delivery Date |
Description | Text | Description |
Has Attachments | Boolean | Has Attachments |
Is Discounted | Boolean | Is Discounted |
Last Updated | Text | Updated Date UTC |
Line Amount | Number | Line Amount |
Line Amount Type | Text | Line Amount Types |
Line Item ID | Text | Line Item ID |
Purchase Order Date | Text | Date |
Purchase Order ID | Text | Purchase Order ID |
Purchase Order Number | Text | Purchase Order Number |
Purchase Order Status | Text | Status |
Quantity | Number | Quantity |
Reference | Text | Reference |
Sub Total | Number | Sub Total |
Tax Amount | Number | Tax Amount |
Tax Type | Text | The Tax Type associated with the Tax Amount. E.g. One of (in the UK) {'ECZROUTPUTSERVICES', 'EXEMPTINPUT', 'EXEMPTOUTPUT', 'INPUT2', 'NONE', 'OUTPUT2', 'ZERORATEDOUTPUT'} |
Telephone | Text | Telephone |
Total | Number | Total |
Total Tax | Number | Total Tax |
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]' |
Type | Text | Type |
Unit Amount | Number | Unit Amount |