API Data Provider - Online Help

InvoiceDetails

Returns details of an invoice.

Columns

Name Type References
OrganizationId Long

Organizations.OrganizationId

InvoiceId [KEY] Long

Invoices.InvoiceId

Number String
Status String
InvoiceDate Date
DueDate Date
CustomerId String
CustomerName String
Date Date
Email String
Balance Double
Total Double
CurrencyCode String
CurrencyId String
AchPaymentInitiated Boolean
Adjustment Double
AdjustmentDescription String
AllowPartialPayments Boolean
ApproverId String
AutoRemindersConfigured Boolean
BcyAdjustment Double
BcyDiscountTotal Double
BcyShippingCharge Double
BcySubTotal Double
BcyTaxTotal Double
BcyTotal Double
BillingAddressAddress String
BillingAddressAttention String
BillingAddressCity String
BillingAddressCountry String
BillingAddressFax String
BillingAddressPhone String
BillingAddressState String
BillingAddressStreet String
BillingAddressStreet2 String
BillingAddressZip String
CanEditItems Boolean
CanSendInMail Boolean
CanSendInvoiceSms Boolean
CanSkipPaymentInfo Boolean
ClientViewedTime String
Contactpersons String
Coupons String
CreatedById String
CreatedDate Date
CreatedTime Datetime
Credits String
CreditsApplied Double
CurrencySymbol String
CustomFields String
CustomerCustomFields String
DiscountPercent Double
DiscountTotal Double
Documents String
ExchangeRate Double
InprocessTransactionPresent Boolean
InvoiceItems String
InvoiceNumber String
InvoiceUrl String
IsInclusiveTax Boolean
IsViewedByClient Boolean
LastModifiedById String
Notes String
PageWidth String
PaymentExpectedDate String
PaymentGateways String
PaymentMade Double
PaymentReminderEnabled Boolean
PaymentTerms Integer
PaymentTermsLabel String
Payments String
PricePrecision Integer
PricebookId String
ReferenceId String
ReferenceNumber String
SalespersonId String
SalespersonName String
ShippingAddressAddress String
ShippingAddressAttention String
ShippingAddressCity String
ShippingAddressCountry String
ShippingAddressFax String
ShippingAddressPhone String
ShippingAddressState String
ShippingAddressStreet String
ShippingAddressStreet2 String
ShippingAddressZip String
ShippingCharge Double
StopReminderUntilPaymentExpectedDate Boolean
SubTotal Double
SubmitterId String
Subscriptions String
TaxRounding String
TaxTotal Double
Taxes String
TemplateId String
TemplateName String
TemplateType String
Terms String
TransactionType String
UnbilledChargesId String
UnusedCreditsReceivableAmount Double
UpdatedTime Date
WriteOffAmount Double
ZcrmPotentialId String

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