JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462