Data Dictionary
Field | Type | Notes |
Account Name | Text | The Account Name. e.g. Sales |
Batch Payment Account Code | Text | Batch Payment Account Code |
Batch Payment Account Name | Text | Batch Payment Account Name |
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 | ISO 3 letter Currency Code for the Account. |
Data current as of | Datetime | When the Data was taken from Xero. |
Has Account | Boolean | Has Account |
Reporting Currency | Text | The 3 letter ISO currency code for the Reporting Currency. |
Reporting Currency Rate | Number | The FX Rate used to calculate the Reporting Currency Amounts. Rates are taken as the closing rates as reporting by the ECB on the invoice date. |
Source | Text | One of {'ACTUAL', 'INVOICE'}. INVOICE payments are forecast payments for invoices that have not been paid, are DRAFT or are FORECAST |
Updated | Text | Updated Date UTC |