JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ReturnMaterialAuthorizationLines

Return a list of: ReturnMaterialAuthorizationLines

Columns

Name Type Description
ExtensionsExtensionAggregate String
BillToAddressId String
BillToCustomerId String
CurrencyKeyISOCode String
CustomerId String
CustomerName String
CustomerPONumber String
EntryDateTime Datetime
EstimatedArrivalDateTime Datetime
ExchangeDate Datetime
ExchangeRate Decimal
FrontOfficeIntegrationId String
Id String
Note String
OfficeId String
RateTypeId String
ShipToAddressId String
TransactionState String
UserDefined01 String
UserDefined02 String
UserDefined03 String
UserDefined04 String
UserDefined05 String
AuditsAggregate String
BillOfLading String
ClosedDateTime Datetime
CommitDateTime Datetime
CreatedBy String
IsFromServiceCall Bool
IsReceived Bool
LinesExtensionsExtensionAggregate String
LinesBillOfLading String
LinesClosedDateTime Datetime
LinesCommitDateTime Datetime
LinesCreatedBy String
LinesCustomerName String
LinesCustomerPONumber String
LinesDistributionsAggregate String
LinesEntryDateTime Datetime
LinesEquipmentLineSequenceNumber Int
LinesEstimatedArrivalDateTime Datetime
LinesFrontOfficeIntegrationId String
LinesIsClosed Bool
LinesIsCustomerOwned Bool
LinesIsFactorySealed Bool
LinesIsFromServiceCall Bool
LinesIsReadyToClose Bool
LinesIsReceived Bool
LinesIsTravelerPrinted Bool
LinesItemDescription String
LinesItemId String
LinesKeyLineSequenceNumber [KEY] Int
LinesKeyServiceDocumentId [KEY] String
LinesLotsAggregate String
LinesNote String
LinesOfficeId String
LinesOriginatingDocumentId String
LinesPromiseDateTime Datetime
LinesQuantity Decimal
LinesReasonCodeDescription String
LinesReasonCodeId String
LinesReference String
LinesRepairCostCurrency String
LinesRepairCost Decimal
LinesRepairDocumentId String
LinesRepairFlatRatePriceCurrency String
LinesRepairFlatRatePrice Decimal
LinesRepairInvoiceItemId String
LinesRepairNotToExceedPriceCurrency String
LinesRepairNotToExceedPrice Decimal
LinesRepairPriceCurrency String
LinesRepairPrice Decimal
LinesReplacementItemId String
LinesReplacementPriceLevelId String
LinesReplacementQuantity Decimal
LinesReplacementUnitCostCurrency String
LinesReplacementUnitCost Decimal
LinesReplacementUnitPriceCurrency String
LinesReplacementUnitPrice Decimal
LinesReplacementUofM String
LinesReplacementWarehouseId String
LinesReturnDateTime Datetime
LinesReturnStatus String
LinesReturnStatusCodeId String
LinesReturnToAddressExtensionsExtensionAggregate String
LinesReturnToAddressCity String
LinesReturnToAddressLine1 String
LinesReturnToAddressLine2 String
LinesReturnToAddressLine3 String
LinesReturnToAddressPostalCode String
LinesReturnToAddressState String
LinesReturnToAddressCountryRegion String
LinesReturnToAddressName String
LinesReturnTypeId String
LinesReturnWarehouseId String
LinesReturnedItemDescription String
LinesReturnedItemId String
LinesReturnedPriceLevelId String
LinesReturnedQuantity Decimal
LinesReturnedTotalAmountCurrency String
LinesReturnedTotalAmount Decimal
LinesReturnedTotalCostCurrency String
LinesReturnedTotalCost Decimal
LinesReturnedUnitCostCurrency String
LinesReturnedUnitCost Decimal
LinesReturnedUnitPriceCurrency String
LinesReturnedUnitPrice Decimal
LinesReturnedUofM String
LinesReturnedWarehouseId String
LinesSalesInvoiceComponentSequenceNumber Int
LinesSalesInvoiceLineKeyLineSequenceNumber Int
LinesSalesInvoiceLineKeySalesDocumentId String
LinesSalesOrderLineKeyLineSequenceNumber Int
LinesSalesOrderLineKeySalesDocumentId String
LinesSalesReturnLineKeyLineSequenceNumber Int
LinesSalesReturnLineKeySalesDocumentId String
LinesSerialsAggregate String
LinesServiceLineKeyLineSequenceNumber Int
LinesServiceLineKeyServiceDocumentId String
LinesShipToAddressExtensionsExtensionAggregate String
LinesShipToAddressCity String
LinesShipToAddressLine1 String
LinesShipToAddressLine2 String
LinesShipToAddressLine3 String
LinesShipToAddressPostalCode String
LinesShipToAddressState String
LinesShipToAddressCountryRegion String
LinesShipToAddressContactPerson String
LinesShipToAddressId String
LinesShippingMethodId String
LinesTotalAmountCurrency String
LinesTotalAmount Decimal
LinesTotalCostCurrency String
LinesTotalCost Decimal
LinesTransferDocumentLineKeyLineSequenceNumber Int
LinesTransferDocumentLineKeyServiceDocumentId String
LinesTransferStatus String
LinesUnitCostCurrency String
LinesUnitCost Decimal
LinesUnitPriceCurrency String
LinesUnitPrice Decimal
LinesUofM String
LinesUserDefined01 String
LinesUserDefined02 String
LinesUserDefined03 String
LinesUserDefined04 String
LinesUserDefined05 String
OriginatingDocumentId String
OriginatingDocumentType String
ReasonCodeDescription String
ReasonCodeId String
ReturnDateTime Datetime
ReturnStatus String
ReturnStatusCodeId String
ReturnToAddressExtensionsExtensionAggregate String
ReturnToAddressCity String
ReturnToAddressLine1 String
ReturnToAddressLine2 String
ReturnToAddressLine3 String
ReturnToAddressPostalCode String
ReturnToAddressState String
ReturnToAddressCountryRegion String
ReturnToAddressName String
ReturnTypeId String
ReturnWarehouseId String
ShipToAddressExtensionsExtensionAggregate String
ShipToAddressCity String
ShipToAddressLine1 String
ShipToAddressLine2 String
ShipToAddressLine3 String
ShipToAddressPostalCode String
ShipToAddressState String
ShipToAddressCountryRegion String
ShipToAddressContactPerson String
ShippingMethodId String
Type 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