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