JDBC Driver for Microsoft Dynamics GP

Build 24.0.9062

ReceivablesInvoice

Return a list of: ReceivablesInvoice

Columns

Name Type ReadOnly Description
ExtensionsExtensionAggregate String False

AddressKeyCustomerId String False

AddressId String False

AuditTrailCode String False

BatchKeyCreatedDateTime Datetime False

BatchId String False

BatchKeySource String False

CorporateAccountId String False

CostAmountCurrency String False

CostAmount Decimal False

CurrencyKeyISOCode String False

CurrentDocumentAmountCurrency String False

CurrentDocumentAmount Decimal False

CustomerId String False

CustomerName String False

CustomerPONumber String False

Date Datetime False

Description String False

DistributionsAggregate String False

DocumentAmountCurrency String False

DocumentAmount Decimal False

ExchangeDate Datetime False

ExchangeRate Decimal False

FreightAmountCurrency String False

FreightAmount Decimal False

FreightTaxScheduleId String False

GeneralLedgerPostingDate Datetime False

InvoicePaidOffDate Datetime False

IsDeleted Bool False

IsDirectDebitDocument Bool False

IsElectronic Bool False

IsIntrastatDocument Bool False

IsVoided Bool False

Id [KEY] String False

MiscellaneousAmountCurrency String False

MiscellaneousAmount Decimal False

MiscellaneousTaxScheduleId String False

ModifiedBy String False

ModifiedDate Datetime False

PostedBy String False

PostedDate Datetime False

SalesAmountCurrency String False

SalesAmount Decimal False

SalesTaxScheduleId String False

SalesTerritoryId String False

SalespersonId String False

ShippingMethodId String False

TaxAmountCurrency String False

TaxAmount Decimal False

TaxScheduleId String False

TaxesAggregate String False

TradeDiscountAmountCurrency String False

TradeDiscountAmount Decimal False

TransactionState String False

Type String False

VoidDate Datetime False

GSTDiscountAmountCurrency String False

GSTDiscountAmount Decimal False

PaymentCashAmountCurrency String False

PaymentCashAmount Decimal False

PaymentCashBankAccountId String False

PaymentCashDate Datetime False

PaymentCashNumber String False

PaymentCheckAmountCurrency String False

PaymentCheckAmount Decimal False

PaymentCheckBankAccountId String False

PaymentCheckCheckNumber String False

PaymentCheckDate Datetime False

PaymentCheckNumber String False

PaymentPaymentCardAmountCurrency String False

PaymentPaymentCardAmount Decimal False

PaymentPaymentCardDate Datetime False

PaymentPaymentCardNumber String False

PaymentPaymentCardReceiptNumber String False

PaymentPaymentCardTypeId String False

PaymentPaymentCardBankAccountId String False

PaymentTermsId String False

TermsDiscountItem String False

TermsDiscountAvailableAmountCurrency String False

TermsDiscountAvailableAmount Decimal False

TermsDiscountDate Datetime False

TermsDueDate Datetime False

TermsDiscountAvailableTakenAmountCurrency String False

TermsDiscountAvailableTakenAmount Decimal False

TermsDiscountTakenAmountCurrency String False

TermsDiscountTakenAmount Decimal False

WriteoffAmountCurrency String False

WriteoffAmount Decimal False

CommissionAmountCurrency String False

CommissionAmount Decimal False

CommissionBasedOn String False

CommissionsAggregate String False

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062