Data Dictionary
Field | Type | Notes |
Connection Name | Text | The name of the Connection. Typically the name of the Xero Organisation. |
Data current as of | Datetime | When the Data was taken from Xero. |
Description | Text | The sales description of the item. |
Inventory Asset Account Code | Text | Inventory Asset Account Code |
Is Purchased | Boolean | Is Purchased |
Is Sold | Boolean | Is Sold |
Is Tracked As Inventory | Boolean | Is Tracked As Inventory |
Last Updated | Text | Updated Date UTC |
Product Code | Text | Code |
Product ID | Text | Item ID |
Product Name | Text | Name |
Purchase Account | Text | aka COGSAccountCode |
Purchase Description | Text | The purchase description of the item. |
Purchase Tax Type | Text | Tax Type |
Purchase Unit Price | Number | Unit Price |
Quantity On Hand | Number | The quantity of the item on hand. |
Sales Account | Text | Account Code |
Sales Tax Type | Text | Tax Type |
Sales Unit Price | Number | Unit Price |
Total Cost Pool | Number | The value of the item on hand. Calculated using average cost accounting. |