CustomerReceivablesSummary
Return a list of: CustomerReceivablesSummary
Columns
| Name | Type | Description |
| ExtensionsExtensionAggregate | String | |
| AgingBalanceAmountCurrency | String | |
| AgingBalanceAmount | Decimal | |
| AgingLastAgedDate | Datetime | |
| AgingPeriod1AmountCurrency | String | |
| AgingPeriod1Amount | Decimal | |
| AgingPeriod2AmountCurrency | String | |
| AgingPeriod2Amount | Decimal | |
| AgingPeriod3AmountCurrency | String | |
| AgingPeriod3Amount | Decimal | |
| AgingPeriod4AmountCurrency | String | |
| AgingPeriod4Amount | Decimal | |
| AgingPeriod5AmountCurrency | String | |
| AgingPeriod5Amount | Decimal | |
| AgingPeriod6AmountCurrency | String | |
| AgingPeriod6Amount | Decimal | |
| AgingPeriod7AmountCurrency | String | |
| AgingPeriod7Amount | Decimal | |
| Id [KEY] | String | |
| LastPaymentAmountCurrency | String | |
| LastPaymentAmount | Decimal | |
| LastPaymentDate | Datetime | |
| LastStatementAmountCurrency | String | |
| LastStatementAmount | Decimal | |
| LastStatementDate | Datetime | |
| LastTransactionAmountCurrency | String | |
| LastTransactionAmount | Decimal | |
| LastTransactionDate | Datetime | |
| LastYearAverageDaysToPay | Int | |
| LastYearHighBalanceCurrency | String | |
| LastYearHighBalance | Decimal | |
| LastYearNumberOfInvoices | Int | |
| LastYearTermsDiscountsTakenCurrency | String | |
| LastYearTermsDiscountsTaken | Decimal | |
| LastYearTotalCashReceivedCurrency | String | |
| LastYearTotalCashReceived | Decimal | |
| LastYearTotalCostCurrency | String | |
| LastYearTotalCost | Decimal | |
| LastYearTotalFinanceChargeCurrency | String | |
| LastYearTotalFinanceCharge | Decimal | |
| LastYearTotalReturnsCurrency | String | |
| LastYearTotalReturns | Decimal | |
| LastYearTotalSalesCurrency | String | |
| LastYearTotalSales | Decimal | |
| LastYearTotalWaivedFinanceChargeCurrency | String | |
| LastYearTotalWaivedFinanceCharge | Decimal | |
| LastYearTotalWriteoffAmountCurrency | String | |
| LastYearTotalWriteoffAmount | Decimal | |
| LifeToDateAverageDaysToPay | Int | |
| LifeToDateHighBalanceCurrency | String | |
| LifeToDateHighBalance | Decimal | |
| LifeToDateNumberOfInvoices | Int | |
| LifeToDateTermsDiscountsTakenCurrency | String | |
| LifeToDateTermsDiscountsTaken | Decimal | |
| LifeToDateTotalCashReceivedCurrency | String | |
| LifeToDateTotalCashReceived | Decimal | |
| LifeToDateTotalCostCurrency | String | |
| LifeToDateTotalCost | Decimal | |
| LifeToDateTotalFinanceChargeCurrency | String | |
| LifeToDateTotalFinanceCharge | Decimal | |
| LifeToDateTotalReturnsCurrency | String | |
| LifeToDateTotalReturns | Decimal | |
| LifeToDateTotalSalesCurrency | String | |
| LifeToDateTotalSales | Decimal | |
| LifeToDateTotalWaivedFinanceChargeCurrency | String | |
| LifeToDateTotalWaivedFinanceCharge | Decimal | |
| LifeToDateTotalWriteoffAmountCurrency | String | |
| LifeToDateTotalWriteoffAmount | Decimal | |
| OnOrderAmountCurrency | String | |
| OnOrderAmount | Decimal | |
| YearToDateAverageDaysToPay | Int | |
| YearToDateHighBalanceCurrency | String | |
| YearToDateHighBalance | Decimal | |
| YearToDateNumberOfInvoices | Int | |
| YearToDateTermsDiscountsTakenCurrency | String | |
| YearToDateTermsDiscountsTaken | Decimal | |
| YearToDateTotalCashReceivedCurrency | String | |
| YearToDateTotalCashReceived | Decimal | |
| YearToDateTotalCostCurrency | String | |
| YearToDateTotalCost | Decimal | |
| YearToDateTotalFinanceChargeCurrency | String | |
| YearToDateTotalFinanceCharge | Decimal | |
| YearToDateTotalReturnsCurrency | String | |
| YearToDateTotalReturns | Decimal | |
| YearToDateTotalSalesCurrency | String | |
| YearToDateTotalSales | Decimal | |
| YearToDateTotalWaivedFinanceChargeCurrency | String | |
| YearToDateTotalWaivedFinanceCharge | Decimal | |
| YearToDateTotalWriteoffAmountCurrency | String | |
| YearToDateTotalWriteoffAmount | Decimal |
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 |
| PagingColumn | String |