Important: You must enable the respective additional data set to generate this report type.
This report provides detailed information about invoices created in a chosen period.
Field Description
The table below describes fields available in this report data set.
| Field name | Type | Description | Example |
|---|---|---|---|
|
INVOICE_ID |
numeric |
The ID of the invoice. |
000021 |
|
INVOICE_NUMBER |
numeric |
The invoice number assigned using an enumerator or the sequence prefix configured by a reseller. |
1 |
|
INVOICE_STATUS |
text |
The status of the invoice. |
|
|
INVOICE_CREATED_DATE |
timestamp |
The date when the invoice was created. |
2018-11-28 |
|
INVOICE_DUE_DATE |
timestamp |
The date when the invoice must be paid. |
2018-12-28 |
|
INVOICE_CLOSE_DATE |
timestamp |
The date when the invoice was closed. |
2018-12-16 |
|
INVOICE_NET_TOTAL |
numeric |
The pretax total of the invoice. |
1.00 |
|
INVOICE_TAX_TOTAL |
numeric |
The sum of inclusive and exclusive tax amounts on both the detail level and the invoice level. |
0.00 |
|
INVOICE_TAX_RATE |
numeric |
The effective detail tax rate (calculated backwards from Detail Tax Total and Detail Total). It does not take Order- or Document-level taxes into account. It does not work for non-linear taxes (for example, the progressive scale). |
1.00 |
|
INVOICE_TOTAL |
numeric |
The total invoice amount after discounts are applied and taxes are deducted. |
1.00 |
|
INVOICE_CORRECTION |
numeric |
The sum of the extended price for invoice. |
100.0 |
|
INVOICE_CURRENCY_CODE |
text |
The three-letter currency code of an invoice. |
USD |
|
INVOICE_PAYMENTS |
JSON |
The array with associated payment IDs. |
{"001", "002", "003"} |
|
INVOICE_DESCRIPTION |
text |
The description of the invoice. |
Description |
|
CUSTOMER_ACCOUNT_ID |
numeric |
The customer account ID. |
100002 |
|
RESELLER_ACCOUNT_ID |
numeric |
The reseller account ID. |
100001 |