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 | ||
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 |