JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

PurchaseInvoice

Return a list of: PurchaseInvoice

Columns

Name Type ReadOnly Description
ExtensionsExtensionAggregate String False

Amount1099Currency String False

Amount1099 Decimal False

AuditTrailCode String False

BatchKeyCreatedDateTime Datetime False

BatchId String False

BatchKeySource String False

CreatedBy String False

CreatedDate Datetime False

CurrencyKeyISOCode String False

Date Datetime False

DistributionsAggregate String False

ExchangeDate Datetime False

ExchangeRate Decimal False

FreightAmountCurrency String False

FreightAmount Decimal False

FreightTaxAmountCurrency String False

FreightTaxAmount Decimal False

FreightTaxBasis String False

FreightTaxScheduleId String False

FreightTaxesAggregate String False

GeneralLedgerPostingDate Datetime False

Id [KEY] String False

LinesAggregate String False

MiscellaneousAmountCurrency String False

MiscellaneousAmount Decimal False

MiscellaneousTaxAmountCurrency String False

MiscellaneousTaxAmount Decimal False

MiscellaneousTaxBasis String False

MiscellaneousTaxScheduleId String False

MiscellaneousTaxesAggregate String False

ModifiedDate Datetime False

PaymentTermsId String False

PostedBy String False

PostedDate Datetime False

Reference String False

RemitToAddressId String False

SubtotalCurrency String False

Subtotal Decimal False

TaxAmountCurrency String False

TaxAmount Decimal False

TaxScheduleId String False

TaxesAggregate String False

TermsDiscountItem String False

TermsDiscountAvailableAmountCurrency String False

TermsDiscountAvailableAmount Decimal False

TermsDiscountDate Datetime False

TermsDueDate Datetime False

TradeDiscountAmountCurrency String False

TradeDiscountAmount Decimal False

TransactionState String False

VendorDocumentNumber String False

VendorId String False

VendorName String False

VoucherNumber 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462