JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

PurchaseReceiptDistributions

Return a list of: PurchaseReceiptDistributions

Columns

Name Type Description
ExtensionsExtensionAggregate String
ActualShipDate Datetime
AuditTrailCode String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
CreatedBy String
CreatedDate Datetime
CurrencyKeyISOCode String
Date Datetime
DistributionsExtensionsExtensionAggregate String
DistributionsAuditTrailCode String
DistributionsCreditAmountCurrency String
DistributionsCreditAmount Decimal
DistributionsDebitAmountCurrency String
DistributionsDebitAmount Decimal
DistributionsDistributionTypeId Int
DistributionsGLAccountId String
DistributionsGLAccountKeyIsEncrypted Bool
DistributionsKeyPurchaseTransactionId [KEY] String
DistributionsKeySequenceNumber [KEY] Int
DistributionsReference String
ExchangeDate Datetime
ExchangeRate Decimal
GeneralLedgerPostingDate Datetime
Id String
LinesAggregate String
ModifiedDate Datetime
PostedBy String
PostedDate Datetime
Reference String
RemitToAddressId String
SubtotalCurrency String
Subtotal Decimal
TotalLandedCostAmountCurrency String
TotalLandedCostAmount Decimal
TransactionState String
UserDefinedAggregate 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