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 |
Comments
0 comments
Please sign in to leave a comment.