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
使用できる値は次のとおりです。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 | |
| Branch | String | Branch associated with the received payment, in JSON format. | ||
| PaymentMethod | String | Payment Method | ||
| TxnPostingDate | Date | Transaction posting date for the payment record, if applicable. |
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
使用できる値は次のとおりです。Retainers, Invoices, InvoicePayment, Advance | |
| PaymentDate | String | Filter transaction by any transaction date.
使用できる値は次のとおりです。Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear, CustomDate | |
| ToDate | Date | To Date | |
| FromDate | Date | From Date |