JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

PayablesDocumentTaxes

The DynamicsGP table PayablesDocumentTaxes.

Columns

Name Type Description
TaxesKeyTaxDetailId [KEY] String The TaxesKeyTaxDetailId column for the table PayablesDocumentTaxes.
TaxesKeyPayablesDocumentId [KEY] String The TaxesKeyPayablesDocumentId column for the table PayablesDocumentTaxes.
AddressId String The AddressId column for the table PayablesDocumentTaxes.
Amount1099Currency String The Amount1099Currency column for the table PayablesDocumentTaxes.
Amount1099 Decimal The Amount1099 column for the table PayablesDocumentTaxes.
AuditTrailCode String The AuditTrailCode column for the table PayablesDocumentTaxes.
BatchKeyCreatedDateTime Datetime The BatchKeyCreatedDateTime column for the table PayablesDocumentTaxes.
BatchId String The BatchId column for the table PayablesDocumentTaxes.
BatchKeySource String The BatchKeySource column for the table PayablesDocumentTaxes.
ChargeAmountCurrency String The ChargeAmountCurrency column for the table PayablesDocumentTaxes.
ChargeAmount Decimal The ChargeAmount column for the table PayablesDocumentTaxes.
CurrencyKeyISOCode String The CurrencyKeyISOCode column for the table PayablesDocumentTaxes.
Date Datetime The Date column for the table PayablesDocumentTaxes.
Description String The Description column for the table PayablesDocumentTaxes.
DistributionsPayablesDistributionAggregate String The DistributionsPayablesDistributionAggregate column for the table PayablesDocumentTaxes.
DocumentAmountCurrency String The DocumentAmountCurrency column for the table PayablesDocumentTaxes.
DocumentAmount Decimal The DocumentAmount column for the table PayablesDocumentTaxes.
ExchangeDate Datetime The ExchangeDate column for the table PayablesDocumentTaxes.
ExchangeRate Decimal The ExchangeRate column for the table PayablesDocumentTaxes.
FreightAmountCurrency String The FreightAmountCurrency column for the table PayablesDocumentTaxes.
FreightAmount Decimal The FreightAmount column for the table PayablesDocumentTaxes.
FreightTaxScheduleId String The FreightTaxScheduleId column for the table PayablesDocumentTaxes.
GeneralLedgerPostingDate Datetime The GeneralLedgerPostingDate column for the table PayablesDocumentTaxes.
HasIntercompanyDistributions Boolean The HasIntercompanyDistributions column for the table PayablesDocumentTaxes.
IsIntercompanyTransaction Boolean The IsIntercompanyTransaction column for the table PayablesDocumentTaxes.
IsVoided Boolean The IsVoided column for the table PayablesDocumentTaxes.
Id String The Id column for the table PayablesDocumentTaxes.
MiscellaneousAmountCurrency String The MiscellaneousAmountCurrency column for the table PayablesDocumentTaxes.
MiscellaneousAmount Decimal The MiscellaneousAmount column for the table PayablesDocumentTaxes.
MiscellaneousTaxScheduleId String The MiscellaneousTaxScheduleId column for the table PayablesDocumentTaxes.
ModifiedBy String The ModifiedBy column for the table PayablesDocumentTaxes.
ModifiedDate Datetime The ModifiedDate column for the table PayablesDocumentTaxes.
PONumber String The PONumber column for the table PayablesDocumentTaxes.
PostedBy String The PostedBy column for the table PayablesDocumentTaxes.
PostedDate Datetime The PostedDate column for the table PayablesDocumentTaxes.
PurchaseTaxScheduleId String The PurchaseTaxScheduleId column for the table PayablesDocumentTaxes.
PurchasesAmountCurrency String The PurchasesAmountCurrency column for the table PayablesDocumentTaxes.
PurchasesAmount Decimal The PurchasesAmount column for the table PayablesDocumentTaxes.
RemitToAddressId String The RemitToAddressId column for the table PayablesDocumentTaxes.
ShippingMethodId String The ShippingMethodId column for the table PayablesDocumentTaxes.
TaxAmountCurrency String The TaxAmountCurrency column for the table PayablesDocumentTaxes.
TaxAmount Decimal The TaxAmount column for the table PayablesDocumentTaxes.
TaxDate Datetime The TaxDate column for the table PayablesDocumentTaxes.
TaxScheduleId String The TaxScheduleId column for the table PayablesDocumentTaxes.
TaxesFreightTaxAmountCurrency String The TaxesFreightTaxAmountCurrency column for the table PayablesDocumentTaxes.
TaxesFreightTaxAmount Decimal The TaxesFreightTaxAmount column for the table PayablesDocumentTaxes.
TaxesGLAccountId String The TaxesGLAccountId column for the table PayablesDocumentTaxes.
TaxesGLAccountKeyIsEncrypted Boolean The TaxesGLAccountKeyIsEncrypted column for the table PayablesDocumentTaxes.
TaxesIsPosted Boolean The TaxesIsPosted column for the table PayablesDocumentTaxes.
TaxesMiscellaneousTaxAmountCurrency String The TaxesMiscellaneousTaxAmountCurrency column for the table PayablesDocumentTaxes.
TaxesMiscellaneousTaxAmount Decimal The TaxesMiscellaneousTaxAmount column for the table PayablesDocumentTaxes.
TaxesPurchasesTaxAmountCurrency String The TaxesPurchasesTaxAmountCurrency column for the table PayablesDocumentTaxes.
TaxesPurchasesTaxAmount Decimal The TaxesPurchasesTaxAmount column for the table PayablesDocumentTaxes.
TaxesIsBackoutTax Boolean The TaxesIsBackoutTax column for the table PayablesDocumentTaxes.
TaxesTaxAmountCurrency String The TaxesTaxAmountCurrency column for the table PayablesDocumentTaxes.
TaxesTaxAmount Decimal The TaxesTaxAmount column for the table PayablesDocumentTaxes.
TaxesTaxableAmountCurrency String The TaxesTaxableAmountCurrency column for the table PayablesDocumentTaxes.
TaxesTaxableAmount Decimal The TaxesTaxableAmount column for the table PayablesDocumentTaxes.
TaxesTotalAmountCurrency String The TaxesTotalAmountCurrency column for the table PayablesDocumentTaxes.
TaxesTotalAmount Decimal The TaxesTotalAmount column for the table PayablesDocumentTaxes.
TaxesExtensionsExtensionAggregate String The TaxesExtensionsExtensionAggregate column for the table PayablesDocumentTaxes.
TradeDiscountAmountCurrency String The TradeDiscountAmountCurrency column for the table PayablesDocumentTaxes.
TradeDiscountAmount Decimal The TradeDiscountAmount column for the table PayablesDocumentTaxes.
TransactionState String The TransactionState column for the table PayablesDocumentTaxes.
Type String The Type column for the table PayablesDocumentTaxes.
VendorDocumentNumber String The VendorDocumentNumber column for the table PayablesDocumentTaxes.
VendorId String The VendorId column for the table PayablesDocumentTaxes.
VendorName String The VendorName column for the table PayablesDocumentTaxes.
ExtensionsExtensionAggregate String The ExtensionsExtensionAggregate column for the table PayablesDocumentTaxes.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462