JDBC Driver for Microsoft Dynamics GP

Build 24.0.9062

PayablesDocumentDistributions

The DynamicsGP table PayablesDocumentDistributions.

Columns

Name Type Description
DistributionsKeySequenceNumber [KEY] Int32 The DistributionsKeySequenceNumber column for the table PayablesDocumentDistributions.
DistributionsKeyPayablesDocumentId [KEY] String The DistributionsKeyPayablesDocumentId column for the table PayablesDocumentDistributions.
AddressId String The AddressId column for the table PayablesDocumentDistributions.
Amount1099Currency String The Amount1099Currency column for the table PayablesDocumentDistributions.
Amount1099 Decimal The Amount1099 column for the table PayablesDocumentDistributions.
AuditTrailCode String The AuditTrailCode column for the table PayablesDocumentDistributions.
BatchKeyCreatedDateTime Datetime The BatchKeyCreatedDateTime column for the table PayablesDocumentDistributions.
BatchId String The BatchId column for the table PayablesDocumentDistributions.
BatchKeySource String The BatchKeySource column for the table PayablesDocumentDistributions.
ChargeAmountCurrency String The ChargeAmountCurrency column for the table PayablesDocumentDistributions.
ChargeAmount Decimal The ChargeAmount column for the table PayablesDocumentDistributions.
CurrencyKeyISOCode String The CurrencyKeyISOCode column for the table PayablesDocumentDistributions.
Date Datetime The Date column for the table PayablesDocumentDistributions.
Description String The Description column for the table PayablesDocumentDistributions.
DistributionsIsPosted Boolean The DistributionsIsPosted column for the table PayablesDocumentDistributions.
DistributionsPostingDate Datetime The DistributionsPostingDate column for the table PayablesDocumentDistributions.
DistributionsDistributionTypeId Int32 The DistributionsDistributionTypeId column for the table PayablesDocumentDistributions.
DistributionsGLAccountId String The DistributionsGLAccountId column for the table PayablesDocumentDistributions.
DistributionsGLAccountKeyIsEncrypted Boolean The DistributionsGLAccountKeyIsEncrypted column for the table PayablesDocumentDistributions.
DistributionsReference String The DistributionsReference column for the table PayablesDocumentDistributions.
DistributionsExtensionsExtensionAggregate String The DistributionsExtensionsExtensionAggregate column for the table PayablesDocumentDistributions.
DocumentAmountCurrency String The DocumentAmountCurrency column for the table PayablesDocumentDistributions.
DocumentAmount Decimal The DocumentAmount column for the table PayablesDocumentDistributions.
ExchangeDate Datetime The ExchangeDate column for the table PayablesDocumentDistributions.
ExchangeRate Decimal The ExchangeRate column for the table PayablesDocumentDistributions.
FreightAmountCurrency String The FreightAmountCurrency column for the table PayablesDocumentDistributions.
FreightAmount Decimal The FreightAmount column for the table PayablesDocumentDistributions.
FreightTaxScheduleId String The FreightTaxScheduleId column for the table PayablesDocumentDistributions.
GeneralLedgerPostingDate Datetime The GeneralLedgerPostingDate column for the table PayablesDocumentDistributions.
HasIntercompanyDistributions Boolean The HasIntercompanyDistributions column for the table PayablesDocumentDistributions.
IsIntercompanyTransaction Boolean The IsIntercompanyTransaction column for the table PayablesDocumentDistributions.
IsVoided Boolean The IsVoided column for the table PayablesDocumentDistributions.
Id String The Id column for the table PayablesDocumentDistributions.
MiscellaneousAmountCurrency String The MiscellaneousAmountCurrency column for the table PayablesDocumentDistributions.
MiscellaneousAmount Decimal The MiscellaneousAmount column for the table PayablesDocumentDistributions.
MiscellaneousTaxScheduleId String The MiscellaneousTaxScheduleId column for the table PayablesDocumentDistributions.
ModifiedBy String The ModifiedBy column for the table PayablesDocumentDistributions.
ModifiedDate Datetime The ModifiedDate column for the table PayablesDocumentDistributions.
PONumber String The PONumber column for the table PayablesDocumentDistributions.
PostedBy String The PostedBy column for the table PayablesDocumentDistributions.
PostedDate Datetime The PostedDate column for the table PayablesDocumentDistributions.
PurchaseTaxScheduleId String The PurchaseTaxScheduleId column for the table PayablesDocumentDistributions.
PurchasesAmountCurrency String The PurchasesAmountCurrency column for the table PayablesDocumentDistributions.
PurchasesAmount Decimal The PurchasesAmount column for the table PayablesDocumentDistributions.
RemitToAddressId String The RemitToAddressId column for the table PayablesDocumentDistributions.
ShippingMethodId String The ShippingMethodId column for the table PayablesDocumentDistributions.
TaxAmountCurrency String The TaxAmountCurrency column for the table PayablesDocumentDistributions.
TaxAmount Decimal The TaxAmount column for the table PayablesDocumentDistributions.
TaxDate Datetime The TaxDate column for the table PayablesDocumentDistributions.
TaxScheduleId String The TaxScheduleId column for the table PayablesDocumentDistributions.
TaxesPayablesTaxAggregate String The TaxesPayablesTaxAggregate column for the table PayablesDocumentDistributions.
TradeDiscountAmountCurrency String The TradeDiscountAmountCurrency column for the table PayablesDocumentDistributions.
TradeDiscountAmount Decimal The TradeDiscountAmount column for the table PayablesDocumentDistributions.
TransactionState String The TransactionState column for the table PayablesDocumentDistributions.
Type String The Type column for the table PayablesDocumentDistributions.
VendorDocumentNumber String The VendorDocumentNumber column for the table PayablesDocumentDistributions.
VendorId String The VendorId column for the table PayablesDocumentDistributions.
VendorName String The VendorName column for the table PayablesDocumentDistributions.
ExtensionsExtensionAggregate String The ExtensionsExtensionAggregate column for the table PayablesDocumentDistributions.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062