Invoices
Invoices generated in HaloServiceDesk for billable services and contracts.
Columns
| Name | Type | References | |
| Id [KEY] | Integer | ||
| Use | String | ||
| InvoiceNumber | String | ||
| InvoiceDisplay | String | ||
| Reference | String | ||
| InternalNote | String | ||
| Name | String | ||
| AccountsId | String | ||
| Address1 | String | ||
| Address2 | String | ||
| Address3 | String | ||
| Address4 | String | ||
| Address5 | String | ||
| DeliveryAddress1 | String | ||
| DeliveryAddress2 | String | ||
| DeliveryAddress3 | String | ||
| DeliveryAddress4 | String | ||
| DeliveryAddress5 | String | ||
| ContractRef | String | ||
| Currency | String | ||
| XeroId | String | ||
| XeroTenantId | String | ||
| XeroBrandingThemeId | String | ||
| XeroBrandingThemeName | String | ||
| XeroStatus | String | ||
| XeroLineTax | String | ||
| SnelStartId | String | ||
| QboCompanyId | String | ||
| KashFlowPdf | String | ||
| DbcId | String | ||
| DbcCompanyId | String | ||
| SageBusinessCloudId | String | ||
| ExactId | String | ||
| IntacctSaveLocation | String | ||
| ApprovalEmailAddress | String | ||
| ApprovalNote | String | ||
| SiteName | String | ||
| ClientId | Integer |
Clients.Id | |
| ClientName | String | ||
| TicketId | Integer |
Tickets.Id | |
| ContractId | Integer |
Contracts.Id | |
| SalesOrderId | Integer | ||
| RecurringInvoiceId | Integer | ||
| PdfTemplateId | Integer | ||
| OriginalClientId | Integer |
Clients.Id | |
| CreditLinkedToInvoiceId | Integer |
Invoices.Id | |
| AssignedAgentId | Integer |
Agents.Id | |
| ApprovalAgent | Integer | ||
| ApprovalAgentId | Integer |
Agents.Id | |
| SupplierId | Integer |
Suppliers.Id | |
| OrganisationId | Integer | ||
| CspInvoiceId | Integer | ||
| SageBusinessCloudDetailsId | Integer | ||
| ExactDivision | Integer | ||
| Uid | Integer | ||
| SiteNumber | Integer | ||
| Type | Integer | ||
| InvoiceType | Integer | ||
| Status | Integer | ||
| DateType | Integer | ||
| PaymentStatus | Integer | ||
| PaymentTerms | Integer | ||
| EmailStatus | Integer | ||
| BillingCategory | Integer | ||
| CurrencyCode | Integer | ||
| ApprovalStatus | Integer | ||
| TakePaymentOnDueDate | Integer | ||
| QboId | Integer | ||
| QboTermId | Integer | ||
| KashflowTenantId | Integer | ||
| KashFlowId | Integer | ||
| InvoiceAutoIncreasePeriod | Integer | ||
| DueDateInt | Integer | ||
| DueDateType | Integer | ||
| PercentOld | Integer | ||
| AddContractAssets | Integer | ||
| AddLabour | Integer | ||
| AddProject | Integer | ||
| AddTravel | Integer | ||
| AddMileage | Integer | ||
| AddItemsIssued | Integer | ||
| AddPrepay | Integer | ||
| AddSalesOrder | Integer | ||
| ChangeSeq | Integer | ||
| DecimalPlaces | Integer | ||
| Total | Decimal | ||
| AmountDue | Decimal | ||
| AmountPaid | Decimal | ||
| TaxTotal | Decimal | ||
| CompositeTaxTotal | Decimal | ||
| Revenue | Decimal | ||
| Percent | Decimal | ||
| CurrencyConversionRate | Decimal | ||
| InvoicePercentIncrease | Decimal | ||
| MinimumAmount | Decimal | ||
| InvoiceDate | Datetime | ||
| DueDate | Datetime | ||
| ScheduleDate | Datetime | ||
| DatePosted | Datetime | ||
| DateSent | Datetime | ||
| DatePaid | Datetime | ||
| DateCreated | Datetime | ||
| LastModified | Datetime | ||
| LastSynced | Datetime | ||
| ApprovalDateTime | Datetime | ||
| IsPosted | Boolean | ||
| IsRecurringInvoice | Boolean | ||
| IsInvoiceHidden | Boolean | ||
| IsVoided | Boolean | ||
| IsDownPayment | Boolean | ||
| IsCreditMarkedAsUsed | Boolean | ||
| IsIncludedInAutopay | Boolean | ||
| IsInvoicedSeparately | Boolean | ||
| IsTwilioInvoice | Boolean | ||
| IsMinimumPriceActive | Boolean | ||
| IsScheduleDeleteIgnored | Boolean | ||
| CreatedByAgentName | String | ||
| AssignedAgentName | String | ||
| OriginalClientName | String | ||
| StatusName | String | ||
| CreditLinkedToInvoiceThirdPartyNumber | String | ||
| RecognisedFromInvoiceId | Integer |
Invoices.Id | |
| CreditTotal | Decimal | ||
| CustomerPaidTotal | Decimal | ||
| IsApprovalRequired | Boolean | ||
| Address | String | ||
| ShipAddress | String | ||
| OriginAddress | String | ||
| Lines | String | ||
| MergeData | String | ||
| CustomFields | String |