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