Data Dictionary
Field | Type | Notes |
Connection Name | Text | The name of the Connection. Typically the name of the Xero Organisation. |
Contact ID | Text | Xero Projects API: projects.contactId |
Credit Note Amount | Number | Xero Projects API: projects.Credit Note Amount.value |
Currency | Text | The ISO 3 letter currency code for the Project amounts, Xero Projects API: projects.currencyCode |
Data current as of | Datetime | When the data was taken from Xero. |
Deadline | Date | Deadline Date, Xero Projects API: projects.deadlineUtc |
Deposit | Number | Value, Xero Projects API: projects.Deposit.value |
Deposit Applied | Number | Xero Projects API: projects.Deposit Applied.value |
Estimate | Number | Xero Projects API: projects.Estimate.value |
Expense Amount Invoiced | Number | Xero Projects API: projects.Expense Amount Invoiced.value |
Expense Amount To Be Invoiced | Number | Xero Projects API: projects.Expense Amount To Be Invoiced.value |
Minutes Logged | Integer | Xero Projects API: projects.minutesLogged |
Minutes To Be Invoiced | Integer | Xero Projects API: projects.minutesToBeInvoiced |
Project Amount Invoiced | Number | Xero Projects API: projects.Project Amount Invoiced.value |
Project ID | Text | Xero Projects API: projects.projectId |
Project Name | Text | Name, Xero Projects API: projects.name |
Status | Text | Xero Projects API: projects.status |
Task Amount Invoiced | Number | Xero Projects API: projects.Task Amount Invoiced.value |
Task Amount To Be Invoiced | Number | Xero Projects API: projects.Task Amount To Be Invoiced.value |
Total Expense Amount | Number | Value, Xero Projects API: projects.Total Expense Amount.value |
Total Invoiced | Number | Xero Projects API: projects.Total Invoiced.value |
Total Task Amount | Number | Xero Projects API: projects.Total Task Amount.value |
Total To Be Invoiced | Number | Xero Projects API: projects.Total To Be Invoiced.value |