JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

GLTransactionLines

Return a list of: GLTransactionLines

Columns

Name Type Description
ExtensionsExtensionAggregate String
AuditTrailCode String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
CurrencyKeyISOCode String
ExchangeDate Datetime
ExchangeRate Decimal
IntercompanyId Int
IntercompanyOriginalJournalId Int
IsVoided Bool
KeyDate Datetime
KeyJournalId Int
LedgerType String
LinesExtensionsExtensionAggregate String
LinesDescription String
LinesExchangeDate Datetime
LinesExchangeRate Decimal
LinesGLAccountId String
LinesGLAccountKeyIsEncrypted Bool
LinesIntercompanyId Int
LinesKeySequenceNumber [KEY] Int
LinesKeyTransactionKeyDate [KEY] Datetime
LinesKeyTransactionKeyJournalId [KEY] Int
LinesOriginatingDocumentControlId String
LinesOriginatingDocumentDescription String
LinesOriginatingDocumentId String
LinesOriginatingDocumentMasterId String
LinesOriginatingDocumentMasterName String
LinesOriginatingDocumentSequenceNumber Int
LinesOriginatingDocumentType Int
LinesTaxAmountCurrency String
LinesTaxAmount Decimal
LinesTaxDetailId String
LinesTaxGLAccountId String
LinesTaxGLAccountKeyIsEncrypted Bool
ModifiedBy String
ModifiedDate Datetime
OriginatingDocumentAuditTrailCode String
OriginatingDocumentPostedDate Datetime
OriginatingDocumentSeries String
PostedBy String
Reference String
SourceDocumentId String
TransactionState 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