Fields in the Invoices Data Set
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 |