JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

PayablesDocument

Return a list of: PayablesDocument

Columns

Name Type Description
ExtensionsExtensionAggregate String
AddressId String
Amount1099Currency String
Amount1099 Decimal
AuditTrailCode String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
ChargeAmountCurrency String
ChargeAmount Decimal
CurrencyKeyISOCode String
Date Datetime
Description String
DistributionsAggregate String
DocumentAmountCurrency String
DocumentAmount Decimal
ExchangeDate Datetime
ExchangeRate Decimal
FreightAmountCurrency String
FreightAmount Decimal
FreightTaxScheduleId String
GeneralLedgerPostingDate Datetime
HasIntercompanyDistributions Bool
IsIntercompanyTransaction Bool
IsVoided Bool
Id [KEY] String
MiscellaneousAmountCurrency String
MiscellaneousAmount Decimal
MiscellaneousTaxScheduleId String
ModifiedBy String
ModifiedDate Datetime
PONumber String
PostedBy String
PostedDate Datetime
PurchaseTaxScheduleId String
PurchasesAmountCurrency String
PurchasesAmount Decimal
RemitToAddressId String
ShippingMethodId String
TaxAmountCurrency String
TaxAmount Decimal
TaxDate Datetime
TaxScheduleId String
TaxesAggregate String
TradeDiscountAmountCurrency String
TradeDiscountAmount Decimal
TransactionState String
Type String
VendorDocumentNumber String
VendorId String
VendorName String

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