JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ReturnMaterialAuthorization

Return a list of: ReturnMaterialAuthorization

Columns

Name Type ReadOnly Description
ExtensionsExtensionAggregate String False

BillToAddressId String False

BillToCustomerId String False

CurrencyKeyISOCode String False

CustomerId String False

CustomerName String False

CustomerPONumber String False

EntryDateTime Datetime False

EstimatedArrivalDateTime Datetime False

ExchangeDate Datetime False

ExchangeRate Decimal False

FrontOfficeIntegrationId String False

Id [KEY] String False

Note String False

OfficeId String False

RateTypeId String False

ShipToAddressId String False

TransactionState String False

UserDefined01 String False

UserDefined02 String False

UserDefined03 String False

UserDefined04 String False

UserDefined05 String False

AuditsAggregate String False

BillOfLading String False

ClosedDateTime Datetime False

CommitDateTime Datetime False

CreatedBy String False

IsFromServiceCall Bool False

IsReceived Bool False

LinesAggregate String False

OriginatingDocumentId String False

OriginatingDocumentType String False

ReasonCodeDescription String False

ReasonCodeId String False

ReturnDateTime Datetime False

ReturnStatus String False

ReturnStatusCodeId String False

ReturnToAddressExtensionsExtensionAggregate String False

ReturnToAddressCity String False

ReturnToAddressLine1 String False

ReturnToAddressLine2 String False

ReturnToAddressLine3 String False

ReturnToAddressPostalCode String False

ReturnToAddressState String False

ReturnToAddressCountryRegion String False

ReturnToAddressName String False

ReturnTypeId String False

ReturnWarehouseId String False

ShipToAddressExtensionsExtensionAggregate String False

ShipToAddressCity String False

ShipToAddressLine1 String False

ShipToAddressLine2 String False

ShipToAddressLine3 String False

ShipToAddressPostalCode String False

ShipToAddressState String False

ShipToAddressCountryRegion String False

ShipToAddressContactPerson String False

ShippingMethodId String False

Type 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