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

CloudBlue, an Ingram Micro business, uses cookies to improve the usability of our site. By continuing to use this site and/or logging in you are accepting the use of these cookies. For more information, visit our Privacy Policy.