JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

PaymentTerms

Return a list of: PaymentTerms

Columns

Name Type Description
ExtensionsExtensionAggregate String
CreatedDate Datetime
DaysDiscountAvailable Int
DaysUntilDue Int
DiscountCalculationItem String
DiscountDateBasedOn String
DueDateBasedOn String
IsDiscountCalculatedOnFreight Bool
IsDiscountCalculatedOnMiscellaneous Bool
IsDiscountCalculatedOnSalePurchase Bool
IsDiscountCalculatedOnTax Bool
IsDiscountCalculatedOnTradeDiscount Bool
Id [KEY] String
ModifiedBy String
ModifiedDate Datetime
UseGracePeriods Bool
UseValueAddedTax Bool

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