JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ReturnMaterialAuthorizationAudits

Return a list of: ReturnMaterialAuthorizationAudits

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
AuditsExtensionsExtensionAggregate String
AuditsCreatedBy String
AuditsCreatedDateTime Datetime
AuditsDescription String
AuditsFromReturnStatusCodeId String
AuditsKeySequenceNumber [KEY] Int
AuditsKeyServiceLineKeyLineSequenceNumber [KEY] Int
AuditsKeyServiceLineKeyServiceDocumentId [KEY] String
AuditsLineSequenceNumber Decimal
AuditsToReturnStatusCodeId String
BillOfLading String
ClosedDateTime Datetime
CommitDateTime Datetime
CreatedBy String
IsFromServiceCall Bool
IsReceived Bool
LinesAggregate 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