JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

PurchaseReceiptUserDefined

Return a list of: PurchaseReceiptUserDefined

Columns

Name Type Description
ExtensionsExtensionAggregate String
ActualShipDate Datetime
AuditTrailCode String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
CreatedBy String
CreatedDate Datetime
CurrencyKeyISOCode String
Date Datetime
DistributionsAggregate 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
UserDefinedExtensionsExtensionAggregate String
UserDefinedDate01 Datetime
UserDefinedDate02 Datetime
UserDefinedDate03 Datetime
UserDefinedDate04 Datetime
UserDefinedDate05 Datetime
UserDefinedDate06 Datetime
UserDefinedDate07 Datetime
UserDefinedDate08 Datetime
UserDefinedDate09 Datetime
UserDefinedDate10 Datetime
UserDefinedDate11 Datetime
UserDefinedDate12 Datetime
UserDefinedDate13 Datetime
UserDefinedDate14 Datetime
UserDefinedDate15 Datetime
UserDefinedDate16 Datetime
UserDefinedDate17 Datetime
UserDefinedDate18 Datetime
UserDefinedDate19 Datetime
UserDefinedDate20 Datetime
UserDefinedKeyPurchaseTransactionId [KEY] String
UserDefinedList01 String
UserDefinedList02 String
UserDefinedList03 String
UserDefinedList04 String
UserDefinedList05 String
UserDefinedText01 String
UserDefinedText02 String
UserDefinedText03 String
UserDefinedText04 String
UserDefinedText05 String
UserDefinedText06 String
UserDefinedText07 String
UserDefinedText08 String
UserDefinedText09 String
UserDefinedText10 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