OdataLink

Xero Accounting Endpoint: InvoicesExpanded: Difference between revisions

← Older edit
No edit summary
No edit summary
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
== Overview ==
== Overview ==


The Xero '''InvoicesExpanded''' [[Endpoints|endpoint]] provides the list of invoices (both sales and purchases) recorded within Xero.
The Xero '''InvoicesExpanded''' [[Xero Accounting Endpoints|endpoint]] provides the list of invoices (both sales and purchases) recorded within Xero.


This endpoints provides access to all fields and details. It is also optimised for larger data files.
This endpoints provides access to all fields and details. It is also optimised for larger data files.


In most situations, it is recommended to use this endpoint instead of the [[Xero  Accounting Endpoint: Invoices|Invoices]] endpoint.
In most situations, it is recommended to use this endpoint instead of the [[Xero  Accounting Endpoint: Invoices|Invoices]] endpoint.
Note that an alternate endpoint named [[Xero Accounting Endpoint: InvoicesExpandedTable|InvoicesExpandedTable]] is available which provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.




Line 11: Line 13:


The following fields are available for the InvoicesExpanded endpoint.
The following fields are available for the InvoicesExpanded endpoint.
;DataFile
:A [[Field Type: Record|record field]] that identifies the [[Field: DataFiles|source data file]] for this record.


;InvoiceID
;InvoiceID
Line 85: Line 90:


;Subtotal
;Subtotal
:A [[Field Type: Decimal|decimal value]] that provides the tax exclusive amount of the transaction.
:A [[Field Type: Decimal|decimal field]] that provides the tax exclusive amount of the transaction.


;TotalTax
;TotalTax
:A [[Field Type: Decimal|decimal value]] that provides the tax amount of the transaction.
:A [[Field Type: Decimal|decimal field]] that provides the tax amount of the transaction.


;Total
;Total
:A [[Field Type: Decimal|decimal value]] that provides the total amount of the transaction.
:A [[Field Type: Decimal|decimal field]] that provides the total amount of the transaction.


;AmountDue
;AmountDue
:A [[Field Type: Decimal|decimal value]] that provides the total amount due.
:A [[Field Type: Decimal|decimal field]] that provides the total amount due.


;AmountPaid
;AmountPaid
:A [[Field Type: Decimal|decimal value]] that provides the total amount paid.
:A [[Field Type: Decimal|decimal field]] that provides the total amount paid.


;AmountCredited
;AmountCredited
:A [[Field Type: Decimal|decimal value]] that provides the total amount credited.
:A [[Field Type: Decimal|decimal field]] that provides the total amount credited.


;CurrencyCode
;CurrencyCode
Line 106: Line 111:


;CurrencyRate
;CurrencyRate
:A [[Field Type: Decimal|decimal value]] that provides the exchange rate applied to the transaction.
:A [[Field Type: Decimal|decimal field]] that provides the exchange rate applied to the transaction.


;HasAttachments
;HasAttachments
Line 115: Line 120:


;CISDeduction
;CISDeduction
:A [[Field Type: Decimal|decimal value]] that provides the CIS deduction amount (UK only).
:A [[Field Type: Decimal|decimal field]] that provides the CIS deduction amount (UK only).


;RepeatingInvoiceID
;RepeatingInvoiceID
Line 143: Line 148:


;Quantity
;Quantity
:A [[Field Type: Decimal|decimal value]] that provides the quantity of the line.
:A [[Field Type: Decimal|decimal field]] that provides the quantity of the line.


;UnitAmount
;UnitAmount
:A [[Field Type: Decimal|decimal value]] that provides the unit amount of the line.
:A [[Field Type: Decimal|decimal field]] that provides the unit amount of the line.


;LineAmount
;LineAmount
:A [[Field Type: Decimal|decimal value]] that provides the amount of the line.
:A [[Field Type: Decimal|decimal field]] that provides the amount of the line.


;TaxAmount
;TaxAmount
:A [[Field Type: Decimal|decimal value]] that provides the tax amount of the line.
:A [[Field Type: Decimal|decimal field]] that provides the tax amount of the line.


;DiscountRate
;DiscountRate
:A [[Field Type: Decimal|decimal value]] that provides the discount rate applied to the line.
:A [[Field Type: Decimal|decimal field]] that provides the discount rate applied to the line.
 
;AccountID
:A [[Field Type: GUID|guid field]] that provides the [[Xero Accounting Endpoint: Accounts|account id]] of the line.


;AccountCode
;AccountCode
:A [[Field Type: Text|text field]] that provides the [[Xero Accounting Endpoint: Accounts|account code]] of the line.
:A [[Field Type: Text|text field]] that provides the [[Xero Accounting Endpoint: Accounts|account code]] of the line.
;Item
:A [[Field Type: Record|record field]] that provides the [[Xero Accounting Endpoint: Items|item]] of the line.


;ItemCode
;ItemCode
:A [[Field Type: Text|text field]] that provides the [[Xero Accounting Endpoint: Items|item code]] of the line.
:A [[Field Type: Text|text field]] that provides the [[Xero Accounting Endpoint: Items|item code]] of the line.
:''This field is provided for backwards compatibility purposes only.''


;TaxType
;TaxType
Line 187: Line 199:


;Amount
;Amount
:A [[Field Type: Decimal|decimal value]] that provides the amount associated with the payment.
:A [[Field Type: Decimal|decimal field]] that provides the amount associated with the payment.


;CurrencyRate
;CurrencyRate
:A [[Field Type: Decimal|decimal value]] that provides the exchange rate applicable.
:A [[Field Type: Decimal|decimal field]] that provides the exchange rate applicable.


;Reference
;Reference
Line 208: Line 220:


;AppliedAmount
;AppliedAmount
:A [[Field Type: Decimal|decimal value]] that provides the amount applied to the invoice.
:A [[Field Type: Decimal|decimal field]] that provides the amount applied to the invoice.


;Date
;Date
Line 214: Line 226:


;Total
;Total
:A [[Field Type: Decimal|decimal value]] that provides the total amount of the credit note.
:A [[Field Type: Decimal|decimal field]] that provides the total amount of the credit note.




Line 226: Line 238:


;AppliedAmount
;AppliedAmount
:A [[Field Type: Decimal|decimal value]] that provides the amount applied to the invoice.
:A [[Field Type: Decimal|decimal field]] that provides the amount applied to the invoice.


;Date
;Date
Line 232: Line 244:


;Total
;Total
:A [[Field Type: Decimal|decimal value]] that provides the total amount of the prepayment.
:A [[Field Type: Decimal|decimal field]] that provides the total amount of the prepayment.




Line 244: Line 256:


;AppliedAmount
;AppliedAmount
:A [[Field Type: Decimal|decimal value]] that provides the amount applied to the invoice.
:A [[Field Type: Decimal|decimal field]] that provides the amount applied to the invoice.


;Date
;Date
Line 250: Line 262:


;Total
;Total
:A [[Field Type: Decimal|decimal value]] that provides the total amount of the overpayment.
:A [[Field Type: Decimal|decimal field]] that provides the total amount of the overpayment.




Line 282: Line 294:
:[[Xero Accounting Endpoint: Prepayments|Prepayments]]
:[[Xero Accounting Endpoint: Prepayments|Prepayments]]
:[[Xero Accounting Endpoint: PrepaymentsExpanded|PrepaymentsExpanded]]
:[[Xero Accounting Endpoint: PrepaymentsExpanded|PrepaymentsExpanded]]
:[[Xero Projects Endpoint: Projects|Projects]]
:[[Xero Accounting Endpoint: PurchaseOrders|PurchaseOrders]]
:[[Xero Accounting Endpoint: PurchaseOrders|PurchaseOrders]]
:[[Xero Accounting Endpoint: Quotes|Quotes]]
:[[Xero Accounting Endpoint: Quotes|Quotes]]
Line 287: Line 300:
:[[Xero Accounting Endpoint: TaxRates|TaxRates]]
:[[Xero Accounting Endpoint: TaxRates|TaxRates]]
:[[Xero Accounting Endpoint: TrackingCategories|TrackingCategories]]
:[[Xero Accounting Endpoint: TrackingCategories|TrackingCategories]]
== Related Topics ==
:[[Xero Accounting Models]]
:[[Xero Accounting Endpoints]]
Retrieved from "https://help.odatalink.com/index.php?title=Xero_Accounting_Endpoint:_InvoicesExpanded"