JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

InventoryVarianceLines

Return a list of: InventoryVarianceLines

Columns

Name Type Description
ExtensionsExtensionAggregate String
AuditTrailCode String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
CreatedDate Datetime
Date Datetime
GLPostingDate Datetime
Id String
ModifiedDate Datetime
TransactionState String
LinesExtensionsExtensionAggregate String
LinesItemId String
LinesKeyInventoryId [KEY] String
LinesKeySequenceNumber [KEY] Decimal
LinesQuantity Decimal
LinesUnitCostCurrency String
LinesUnitCost Decimal
LinesBinsAggregate String
LinesInventoryGLAccountId String
LinesInventoryGLAccountIsEncrypted Bool
LinesInventoryOffsetGLAccountId String
LinesInventoryOffsetGLAccountIsEncrypted Bool
LinesLotsAggregate String
LinesSerialsAggregate String
LinesUofM String
LinesWarehouseId 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