InvoiceDetails
Returns details of an invoice.
Columns
| Name | Type | References | |
| OrganizationId | Long |
Organizations.OrganizationId | |
| InvoiceId [KEY] | Long |
Invoices.InvoiceId | |
| InvoiceNumber | String | ||
| InvoiceUrl | String | ||
| Status | String | ||
| CustomerId | String | ||
| CustomerName | String | ||
| Date | Date | ||
| ReferenceNumber | String | ||
| AchPaymentInitiated | Boolean | ||
| AchSupported | Boolean | ||
| Adjustment | Double | ||
| AdjustmentDescription | String | ||
| AllowPartialPayments | Boolean | ||
| ApproverId | String | ||
| ApproversList | String | ||
| AttachmentName | String | ||
| Balance | Double | ||
| Total | Double | ||
| BcyAdjustment | Double | ||
| BcyDiscountTotal | Double | ||
| BcyShippingCharge | Double | ||
| BcySubTotal | Double | ||
| BcyTaxTotal | Double | ||
| BcyTotal | Double | ||
| CanSendInMail | Boolean | ||
| CanSendInvoiceSms | Boolean | ||
| ClientViewedTime | String | ||
| ColorCode | String | ||
| ContactCategory | String | ||
| ContactPersons | String | ||
| ContactPersonsDetails | String | ||
| CreatedById | String | ||
| CreatedDate | Date | ||
| CreatedTime | Datetime | ||
| CreditsApplied | Double | ||
| CurrencyCode | String | ||
| CurrencyId | String | ||
| CurrencySymbol | String | ||
| CurrentSubStatus | String | ||
| CurrentSubStatusId | String | ||
| CustomFields | String | ||
| CustomerCustomFields | String | ||
| CustomerDefaultBillingAddressAddress | String | ||
| CustomerDefaultBillingAddressCity | String | ||
| CustomerDefaultBillingAddressCountry | String | ||
| CustomerDefaultBillingAddressFax | String | ||
| CustomerDefaultBillingAddressPhone | String | ||
| CustomerDefaultBillingAddressState | String | ||
| CustomerDefaultBillingAddressStateCode | String | ||
| CustomerDefaultBillingAddressStreet2 | String | ||
| CustomerDefaultBillingAddressZip | String | ||
| Deliverychallans | String | ||
| Discount | Double | ||
| DiscountAmount | Double | ||
| DiscountAppliedOnAmount | Double | ||
| DiscountPercent | Double | ||
| DiscountTotal | Double | ||
| DiscountType | String | ||
| Documents | String | ||
| DueDate | Date | ||
| EcommOperatorId | String | ||
| EcommOperatorName | String | ||
| String | |||
| EstimateId | String | ||
| ExchangeRate | Double | ||
| IncludesPackageTrackingInfo | Boolean | ||
| InprocessTransactionPresent | Boolean | ||
| LineItems | String | ||
| IsAutobillEnabled | Boolean | ||
| IsBackorder | String | ||
| IsClientReviewSettingsEnabled | Boolean | ||
| IsDiscountBeforeTax | Boolean | ||
| IsEmailed | Boolean | ||
| IsInclusiveTax | Boolean | ||
| IsViewedByClient | Boolean | ||
| LastModifiedById | String | ||
| LastModifiedTime | Datetime | ||
| LastPaymentDate | String | ||
| LastReminderSentDate | String | ||
| MerchantId | String | ||
| MerchantName | String | ||
| NextReminderDateFormatted | String | ||
| Notes | String | ||
| Orientation | String | ||
| PageHeight | String | ||
| PageWidth | String | ||
| PaymentDiscount | Double | ||
| PaymentExpectedDate | String | ||
| PaymentMade | Double | ||
| PaymentOptionsPaymentGateways | String | ||
| PaymentReminderEnabled | Boolean | ||
| PaymentTerms | Integer | ||
| PaymentTermsLabel | String | ||
| PricePrecision | Integer | ||
| ReaderOfflinePaymentInitiated | Boolean | ||
| RecurringInvoiceId | String | ||
| RemindersSent | Integer | ||
| RoundoffValue | Double | ||
| SalesChannel | String | ||
| SalesorderId | String | ||
| SalesorderNumber | String | ||
| Salesorders | String | ||
| SalespersonId | String | ||
| SalespersonName | String | ||
| ScheduleTime | String | ||
| ShippingAddressAddress | String | ||
| ShippingAddressAttention | String | ||
| ShippingAddressCity | String | ||
| ShippingAddressCountry | String | ||
| ShippingAddressFax | String | ||
| ShippingAddressPhone | String | ||
| ShippingAddressState | String | ||
| ShippingAddressStreet | String | ||
| ShippingAddressStreet2 | String | ||
| ShippingAddressZip | String | ||
| BillingAddressAddress | String | ||
| BillingAddressAttention | String | ||
| BillingAddressCity | String | ||
| BillingAddressCountry | String | ||
| BillingAddressFax | String | ||
| BillingAddressPhone | String | ||
| BillingAddressState | String | ||
| BillingAddressStreet | String | ||
| BillingAddressStreet2 | String | ||
| BillingAddressZip | String | ||
| ShippingBills | String | ||
| ShippingCharge | Double | ||
| StopReminderUntilPaymentExpectedDate | Boolean | ||
| SubStatuses | String | ||
| SubTotal | Double | ||
| SubTotalInclusiveOfTax | Double | ||
| SubjectContent | String | ||
| SubmittedBy | String | ||
| SubmittedDate | String | ||
| SubmitterId | String | ||
| TaxAmountWithheld | Double | ||
| TaxRounding | String | ||
| TaxTotal | Double | ||
| Taxes | String | ||
| TemplateId | String | ||
| TemplateName | String | ||
| TemplateType | String | ||
| Terms | String | ||
| TransactionRoundingType | String | ||
| UnusedRetainerPayments | Double | ||
| WriteOffAmount | Double | ||
| ZcrmPotentialId | String | ||
| ZcrmPotentialName | String |