JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

GLTransaction

Return a list of: GLTransaction

Columns

Name Type ReadOnly Description
ExtensionsExtensionAggregate String False

AuditTrailCode String False

BatchKeyCreatedDateTime Datetime False

BatchId String False

BatchKeySource String False

CurrencyKeyISOCode String False

ExchangeDate Datetime False

ExchangeRate Decimal False

IntercompanyId Int False

IntercompanyOriginalJournalId Int False

IsVoided Bool False

KeyDate [KEY] Datetime False

KeyJournalId [KEY] Int False

LedgerType String False

LinesAggregate String False

ModifiedBy String False

ModifiedDate Datetime False

OriginatingDocumentAuditTrailCode String False

OriginatingDocumentPostedDate Datetime False

OriginatingDocumentSeries String False

PostedBy String False

Reference String False

SourceDocumentId String False

TransactionState 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