API Data Provider - Online Help

Invoices

Returns the list of all invoices.

Columns

Name Type References
OrganizationId Long

Organizations.OrganizationId

InvoiceId [KEY] Long
InvoiceNumber String
ReferenceNumber String
Status String

The allowed values are sent, draft, overdue, paid, void, unpaid, partially_paid, viewed.

CustomerId String
CustomerName String
Date Date
Documents String
DueDate Date
DueDays String
Email String
ExchangeRate Double
HasAttachment Boolean
IsEmailed Boolean
IsViewedByClient Boolean
LastModifiedTime Datetime
LastPaymentDate String
LastReminderSentDate String
PaymentExpectedDate String
Phone String
AchPaymentInitiated Boolean
Adjustment Double
Balance Double
Total Double
ClientViewedTime String
ColorCode String
CompanyName String
Country String
CreatedBy String
CurrencyCode String
CurrencyId String
CurrencySymbol String
CurrentSubStatus String
CurrentSubStatusId String
CustomFields String
RemindersSent Integer
SalespersonId String
SalespersonName String
ScheduleTime String
ShippingAddressAddress String
ShippingAddressAttention String
ShippingAddressCity String
ShippingAddressCountry String
ShippingAddressFax String
ShippingAddressPhone String
ShippingAddressState String
ShippingAddressStreet2 String
ShippingAddressZipcode String
BillingAddressAddress String
BillingAddressAttention String
BillingAddressCity String
BillingAddressCountry String
BillingAddressFax String
BillingAddressPhone String
BillingAddressState String
BillingAddressStreet2 String
BillingAddressZipcode String
ShippingCharge Double
TaxSource String
TemplateId String
TemplateType String
TransactionType String
CreatedTime Datetime
UpdatedTime Datetime
WriteOffAmount Double
ZcrmPotentialId String
ZcrmPotentialName String

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