Scheduled Extract Report - Invoices

Overview

When Invoices is selected in Requested Data, the report will return the invoice data outlined in the below table.

Field Name	Data Type	Information
Invoice_IID	Integer (Unsigned)	The primary key for an Invoice entity
CustomerName	String	The name of the customer to which this invoice is assigned
Customer_BID	Integer (Unsigned)	The Customer ID of the customer to which this invoice is assigned
InvoiceNumber	String	The invoice number assigned to this invoice
Status	String	The status of the invoice
PurchaseOrderNumber	String	The purchase order number, if any, assigned to this invoice
DateIssued	Date	The issue date of the invoice
DateDue	Date	The date the invoice is due
Currency	String	The currency assigned to the Invoice Items in the invoice
Subtotal	Decimal	The subtotal assigned to the invoice
Tax	Decimal	The tax amount assigned to the invoice
Total	Decimal	The total assigned to the invoice
AmountPaid	Decimal	The total amount paid to the invoice
AmountCredited	Decimal	The total amount credited to the invoice
AmountDue	Decimal	The total amount remaining for the invoice
SendMethod	String	The method by which this invoice will be sent (Email, Email/PDF, Post)
BillingGroup_BCID	Integer	The Billing Group ID allocated to the invoice -1 = no Billing Group assigned so use the primary contact info on the customer 0 = no Billing Group available, most likely because one has not been assigned and there is no primary contact info filled out for the customer
BillingEntity-Company ManagementCompany_CM_CID	Integer (Unsigned)	The foreign key of the billing entity (a CompanyManagementCompany entity) to which this invoice belongs