JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

SalesOrderPayments

Return a list of: SalesOrderPayments

Columns

Name Type Description
ExtensionsExtensionAggregate String
ActualShipDate Datetime
AuditTrailCode String
BackorderDate Datetime
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
BillToAddressKeyCustomerId String
BillToAddressId String
Comment String
CommentId String
CommissionAmountCurrency String
CommissionAmount Decimal
CommissionBasedOn String
CommissionSaleAmountCurrency String
CommissionSaleAmount Decimal
CommissionsAggregate String
CreatedBy String
CreatedDate Datetime
CurrencyKeyISOCode String
CustomerId String
CustomerName String
CustomerPONumber String
Date Datetime
DiscountAmountCurrency String
DiscountAmount Decimal
DocumentTypeId String
DocumentTypeKeyType String
ExchangeDate Datetime
ExchangeRate Decimal
FreightAmountCurrency String
FreightAmount Decimal
FreightTaxAmountCurrency String
FreightTaxAmount Decimal
FreightTaxBasis String
FreightTaxScheduleId String
FreightTaxesAggregate String
FrontOfficeIntegrationId String
FulfillDate Datetime
IntegrationId String
IntegrationSource Int
InvoiceDate Datetime
IsIntrastatDocument Bool
IsVoided Bool
Id String
LastModifiedDate Datetime
LineTotalAmountCurrency String
LineTotalAmount Decimal
MasterNumber Int
MiscellaneousAmountCurrency String
MiscellaneousAmount Decimal
MiscellaneousTaxAmountCurrency String
MiscellaneousTaxAmount Decimal
MiscellaneousTaxBasis String
MiscellaneousTaxScheduleId String
MiscellaneousTaxesAggregate String
ModifiedDate Datetime
Note String
OriginalSalesDocumentId String
OriginalSalesDocumentType String
PaymentTermsId String
PriceLevelId String
ProcessHoldsAggregate String
QuoteDate Datetime
Reference String
RequestedShipDate Datetime
ReturnDate Datetime
SalesTerritoryId String
SalespersonId String
ShipCompleteOnly Bool
ShipToAddressExtensionsExtensionAggregate String
ShipToAddressCity String
ShipToAddressLine1 String
ShipToAddressLine2 String
ShipToAddressLine3 String
ShipToAddressPostalCode String
ShipToAddressState String
ShipToAddressCountryRegion String
ShipToAddressFaxCountryCode String
ShipToAddressFaxExtension String
ShipToAddressFax String
ShipToAddressPhone1CountryCode String
ShipToAddressPhone1Extension String
ShipToAddressPhone1 String
ShipToAddressPhone2CountryCode String
ShipToAddressPhone2Extension String
ShipToAddressPhone2 String
ShipToAddressPhone3CountryCode String
ShipToAddressPhone3Extension String
ShipToAddressPhone3 String
ShipToAddressCountryRegionCodeId String
ShipToAddressContactPerson String
ShipToAddressName String
ShipToAddressKeyCustomerId String
ShipToAddressId String
ShippingMethodId String
TaxAmountCurrency String
TaxAmount Decimal
TaxExemptNumber1 String
TaxExemptNumber2 String
TaxRegistrationNumber String
TaxScheduleId String
TaxesAggregate String
TotalAmountCurrency String
TotalAmount Decimal
TrackingNumbersAggregate String
TradeDiscountItem String
TransactionState String
Type String
UPSZone String
UserDefinedDate01 Datetime
UserDefinedDate02 Datetime
UserDefinedList01 String
UserDefinedList02 String
UserDefinedList03 String
UserDefinedText01 String
UserDefinedText02 String
UserDefinedText03 String
UserDefinedText04 String
UserDefinedText05 String
WarehouseId String
DaysToIncrement Int
DepositAmountCurrency String
DepositAmount Decimal
DocumentFrequency String
IsRepeating Bool
LinesAggregate String
PaymentAmountCurrency String
PaymentAmount Decimal
PaymentsExtensionsExtensionAggregate String
PaymentsAuditTrailCode String
PaymentsAuthorizationCode String
PaymentsBankAccountId String
PaymentsCheckNumber String
PaymentsCurrencyKeyISOCode String
PaymentsDate Datetime
PaymentsDeleteOnUpdate Bool
PaymentsExpirationDate Datetime
PaymentsKeySalesDocumentId [KEY] String
PaymentsKeySequenceNumber [KEY] Int
PaymentsNumber String
PaymentsPaymentAmountCurrency String
PaymentsPaymentAmount Decimal
PaymentsPaymentCardNumber String
PaymentsPaymentCardTypeId String
PaymentsType String
ShippingProcessStatus String
TimesToRepeat Int
WorkflowPriority String
WorkflowsAggregate 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