JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

PurchaseOrderMiscellaneousTaxes

Return a list of: PurchaseOrderMiscellaneousTaxes

Columns

Name Type Description
ExtensionsExtensionAggregate String
BackoutFreightTaxAmountCurrency String
BackoutFreightTaxAmount Decimal
BackoutMiscellaneousTaxAmountCurrency String
BackoutMiscellaneousTaxAmount Decimal
BackoutTaxAmountCurrency String
BackoutTaxAmount Decimal
BillToAddressId String
BuyerId String
CanceledSubtotalCurrency String
CanceledSubtotal Decimal
Comment String
CommentId String
ConfirmWith String
ContractEndDate Datetime
ContractNumber String
CreatedBy String
CreatedDate Datetime
CurrencyKeyISOCode String
CustomerId String
Date Datetime
DoesAllowSalesOrderCommitments Bool
ExchangeDate Datetime
ExchangeRate Decimal
FreightAmountCurrency String
FreightAmount Decimal
FreightTaxAmountCurrency String
FreightTaxAmount Decimal
FreightTaxBasis String
FreightTaxScheduleId String
FreightTaxesAggregate String
IsOnHold Bool
Id String
LastEditDate Datetime
LastPrintedDate Datetime
LinesAggregate String
MiscellaneousAmountCurrency String
MiscellaneousAmount Decimal
MiscellaneousTaxAmountCurrency String
MiscellaneousTaxAmount Decimal
MiscellaneousTaxBasis String
MiscellaneousTaxScheduleId String
MiscellaneousTaxesExtensionsExtensionAggregate String
MiscellaneousTaxesAuditTrailCode String
MiscellaneousTaxesIsBackoutTax Bool
MiscellaneousTaxesKeyPurchaseTransactionId [KEY] String
MiscellaneousTaxesKeySequenceNumber [KEY] Int
MiscellaneousTaxesKeyTaxDetailId [KEY] String
MiscellaneousTaxesTaxAmountCurrency String
MiscellaneousTaxesTaxAmount Decimal
MiscellaneousTaxesTaxableAmountCurrency String
MiscellaneousTaxesTaxableAmount Decimal
MiscellaneousTaxesTotalAmountCurrency String
MiscellaneousTaxesTotalAmount Decimal
MiscellaneousTaxesTotalTaxPotentialAmountCurrency String
MiscellaneousTaxesTotalTaxPotentialAmount Decimal
ModifiedDate Datetime
PaymentTermsId String
PromisedDate Datetime
PromisedShipDate Datetime
PurchaseAddressExtensionsExtensionAggregate String
PurchaseAddressCity String
PurchaseAddressLine1 String
PurchaseAddressLine2 String
PurchaseAddressLine3 String
PurchaseAddressPostalCode String
PurchaseAddressState String
PurchaseAddressCountryRegion String
PurchaseAddressFaxCountryCode String
PurchaseAddressFaxExtension String
PurchaseAddressFax String
PurchaseAddressPhone1CountryCode String
PurchaseAddressPhone1Extension String
PurchaseAddressPhone1 String
PurchaseAddressPhone2CountryCode String
PurchaseAddressPhone2Extension String
PurchaseAddressPhone2 String
PurchaseAddressPhone3CountryCode String
PurchaseAddressPhone3Extension String
PurchaseAddressPhone3 String
PurchaseAddressCountryRegionCodeId String
PurchaseAddressContactPerson String
PurchaseAddressName String
PurchaseAddressId String
RemainingSubtotalCurrency String
RemainingSubtotal Decimal
RequestedDate Datetime
RequisitionDate Datetime
RevisionNumber Int
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
ShipToAddressId String
ShippingMethodId String
Status String
StatusGroup String
SubtotalCurrency String
Subtotal Decimal
TaxAmountCurrency String
TaxAmount Decimal
TaxRegistrationNumber String
TaxScheduleId String
TaxesAggregate String
TermsDiscountItem String
TermsDiscountAvailableAmountCurrency String
TermsDiscountAvailableAmount Decimal
TermsDiscountDate Datetime
TermsDueDate Datetime
TimesPrinted Int
TotalAmountCurrency String
TotalAmount Decimal
TradeDiscountAmountCurrency String
TradeDiscountAmount Decimal
TransactionState String
Type String
VendorId String
VendorName String
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