API Data Provider - Online Help

Invoices

Retrieve the list of invoices.

Columns

Name Type References
Id [KEY] Integer
Uuid String
Active Boolean
Adjustment Integer
AdjustmentDescription String
AssigneeId Integer
Bank String
BankId Integer
BillFromAddress String
BillFromCity String
BillFromCountryId Integer
BillFromState String
BillFromZip String
BillToAddress String
BillToCity String
BillToCountryId Integer
BillToState String
BillToZip String
CompanyPhone String
CompanyPhone2 String
CompanyVat String
CompanyVat2 String
ContactPerson String
ContactPersonPosition String
ContactPerson2 String
ContactPerson2Position String
CreatedBy Integer
CurrencyCode String
CurrencyId Integer
CustomerId Integer
CustomerLegalName String
CustomerName String
Discount Integer
DiscountBeforeTax Boolean
DueDate Datetime
EstimateId Integer
ExchangeRate Integer
Exported1c Boolean
GroupId Integer
InvoiceDate String
InvoiceEmailedDate String
InvoiceFooterText String
InvoiceNumber Integer
InvoiceNumberPrint String
InvoiceTermsText String
IsDiscountPercent Boolean
IsInvoiceEmailed Boolean
IsReminderSent Boolean
IsTemplate Boolean
Model String
ModelId Integer
Module String
OrgId Integer
OrgPhone String
OrgPhone2 String
OrgVat String
OrgVat2 String
PaidDate String
PaymentOptions String
PaymethodId Integer
PricelistId Integer
RecurringInvoiceId Integer
Ref String
RefId String
Reference String
RemindersSentDate String
ShippingCharge Integer
ShowAddSignString Boolean
StatusId Integer
SubTotal Integer
TaxTotal Integer
Tax1 Integer
Tax1Included Boolean
Tax2 Integer
Tax2Included Boolean
TemplateId Integer
TemplateName String
Total Integer
Type Integer
UpdatedBy Integer
CreatedDate Datetime
UpdatedDate Datetime

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839.0