ODBC Driver for Zoho Books

Build 24.0.9060

PaymentsReceivedReport

Generated schema file.

Columns

Name Type References SupportedOperators Description
Accountid String Account id.
Accountname String Account name.
Amount Integer Amount.
AppliedDate Date Applied Date.
AppliedInvoiceAmount String Applied Invoice Amount.
AppliedInvoiceBcyAmount String Applied Invoice BcyAmount.
AppliedInvoices String Applied Invoices.
BcyBankCharge Integer BcyBankCharge.
BcytotalExcludingTdsDeduction Integer Bcytotal ExcludingTdsDeduction.
ContactBillingAttention String Contact Billing Attention.
ContactBillingCity String Contact Billing City.
ContactBillingCountry String Contact Billing Country.
ContactBillingFax String Contact Billing Fax.
ContactBillingState String Contact Billing State.
ContactBillingStreet1 String Contact Billing Street1.
ContactBillingStreet2 String Contact Billing Street2.
ContactBillingZipcode String Contact Billing Zipcode.
ContactCompanyName String Contact Company Name.
ContactCreatedBy String Contact Created By.
ContactCreatedTime Datetime Contact Created Time.
ContactcreditLimit Integer Contact Credit Limit.
ContactcustomerSubType String Contact Customer SubType.
ContactDepartment String Contact Department.
ContactDesignation String Contact Designation.
ContactEmail String Contact Email.
ContactFacebook String Contact Facebook.
ContactFirstName String Contact First Name.
ContactLastModifiedTime Datetime Contact Last ModifiedTime.
ContactLastName String Contact Last Name.
ContactMobilePhone String Contact Mobile Phone.
ContactNotes String Contact Notes.
ContactOutstandingReceivableAmount Integer Contact Outstanding ReceivableAmount.
ContactOutstandingReceivableAmountBcy Integer Contact Outstanding ReceivableAmountBcy.
ContactPaymentTerms String Contact Payment Terms.
ContactPhone String Contact Phone.
ContactShippingAttention String Contact Shipping Attention.
ContactShippingCity String Contact Shipping City.
ContactShippingCountry String Contact Shipping Country.
ContactShippingFax String Contact Shipping Fax.
ContactShippingState String Contact Shipping State.
ContactShippingStreet1 String Contact Shipping Street1.
ContactShippingStreet2 String Contact Shipping Street2.
ContactShippingZipcode String Contact Shipping Zipcode.
ContactSkype String Contact Skype.
ContactStatus String Contact Status.
ContactTwitter String Contact Twitter.
ContactUnusedCreditsReceivableAmount Integer Contact Unused Credits Receivable Amount.
ContactUnusedCreditsReceivableAmountBcy Integer Contact Unused Credits Receivable Amount Bcy.
ContactWebsite String Contact Website.
CreatedBy String CreatedBy.
CreatedTime Datetime CreatedTime.
CurrencyCode String CurrencyCode.
CustomFields String CustomFields.
CustomerName String CustomerName.
Description String Description.
Documents String Documents.
FcyBankCharge Integer Fcy Bank Charge.
FcytotalExcludingTdsDeduction Integer Fcy total Excluding TdsDeduction.
GatewayTransactionId String GatewayTransactionId.
HasAttachment Boolean Has Attachment.
InvoiceNumber String Invoice Number.
InvoiceNumbers String Invoice Numbers.
LastFourDigits String Last Four Digits.
LastModifiedTime Datetime Last Modified Time.
PaymentId String Payment Id.
ProductDescription String Product Description.
RefundedAmount Integer Refunded Amount.
Retainerinvoiceid String Retainer invoiceid.
TaxAccountId String Tax Account Id.
TaxAccountName String Tax Account Name.
TaxAmountWithheld Integer Tax Amount Withheld.
Type String Type.
UnusedAmount Integer UnusedAmount.
CustomerId String IN, NOT IN Customer Id.
Date Date =, >,< Date.
PaymentMode String IN, NOT IN Payment Mode.

The allowed values are Bank Remittance, Bank Transfer, Cash, Check, Credit Card.

PaymentNumber String =, !=, LIKE, CONTAINS, NOT LIKE, IS NULL, IS NOT NULL Payment Number.
AccountIdFilter String IN, NOT IN AccountIdFilter.
BcyUnusedAmount Integer =, !=,<,<=, >, >= Bcy Unused Amount.
BcyAmount Integer =, !=,<,<=, >, >= Bcy Amount.
BcyRefundedAmount Integer =, !=,<, >,<=, >= Bcy Refunded Amount.
ReferenceNumber String =, !=, LIKE, NOT LIKE, CONTAINS Reference Number.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PaymentType String Transaction.

The allowed values are Retainers, Invoices, InvoicePayment, Advance.

PaymentDate String Filter transaction by any transaction date.

The allowed values are Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear, CustomDate.

ToDate Date To Date.
FromDate Date From Date.

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