JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ReceivablesDocumentDistributions

The DynamicsGP table ReceivablesDocumentDistributions.

Columns

Name Type Description
DistributionsKeySequenceNumber [KEY] Int32 The DistributionsKeySequenceNumber column for the table ReceivablesDocumentDistributions.
DistributionsKeyReceivablesDocumentId [KEY] String The DistributionsKeyReceivablesDocumentId column for the table ReceivablesDocumentDistributions.
AddressKeyCustomerId String The AddressKeyCustomerId column for the table ReceivablesDocumentDistributions.
AddressId String The AddressId column for the table ReceivablesDocumentDistributions.
AuditTrailCode String The AuditTrailCode column for the table ReceivablesDocumentDistributions.
BatchKeyCreatedDateTime Datetime The BatchKeyCreatedDateTime column for the table ReceivablesDocumentDistributions.
BatchId String The BatchId column for the table ReceivablesDocumentDistributions.
BatchKeySource String The BatchKeySource column for the table ReceivablesDocumentDistributions.
CorporateAccountId String The CorporateAccountId column for the table ReceivablesDocumentDistributions.
CostAmountCurrency String The CostAmountCurrency column for the table ReceivablesDocumentDistributions.
CostAmount Decimal The CostAmount column for the table ReceivablesDocumentDistributions.
CurrencyKeyISOCode String The CurrencyKeyISOCode column for the table ReceivablesDocumentDistributions.
CurrentDocumentAmountCurrency String The CurrentDocumentAmountCurrency column for the table ReceivablesDocumentDistributions.
CurrentDocumentAmount Decimal The CurrentDocumentAmount column for the table ReceivablesDocumentDistributions.
CustomerId String The CustomerId column for the table ReceivablesDocumentDistributions.
CustomerName String The CustomerName column for the table ReceivablesDocumentDistributions.
CustomerPONumber String The CustomerPONumber column for the table ReceivablesDocumentDistributions.
Date Datetime The Date column for the table ReceivablesDocumentDistributions.
Description String The Description column for the table ReceivablesDocumentDistributions.
DistributionsIsPosted Boolean The DistributionsIsPosted column for the table ReceivablesDocumentDistributions.
DistributionsDistributionTypeId Int32 The DistributionsDistributionTypeId column for the table ReceivablesDocumentDistributions.
DistributionsGLAccountId String The DistributionsGLAccountId column for the table ReceivablesDocumentDistributions.
DistributionsGLAccountKeyIsEncrypted Boolean The DistributionsGLAccountKeyIsEncrypted column for the table ReceivablesDocumentDistributions.
DistributionsReference String The DistributionsReference column for the table ReceivablesDocumentDistributions.
DistributionsExtensionsExtensionAggregate String The DistributionsExtensionsExtensionAggregate column for the table ReceivablesDocumentDistributions.
DocumentAmountCurrency String The DocumentAmountCurrency column for the table ReceivablesDocumentDistributions.
DocumentAmount Decimal The DocumentAmount column for the table ReceivablesDocumentDistributions.
ExchangeDate Datetime The ExchangeDate column for the table ReceivablesDocumentDistributions.
ExchangeRate Decimal The ExchangeRate column for the table ReceivablesDocumentDistributions.
FreightAmountCurrency String The FreightAmountCurrency column for the table ReceivablesDocumentDistributions.
FreightAmount Decimal The FreightAmount column for the table ReceivablesDocumentDistributions.
FreightTaxScheduleId String The FreightTaxScheduleId column for the table ReceivablesDocumentDistributions.
GeneralLedgerPostingDate Datetime The GeneralLedgerPostingDate column for the table ReceivablesDocumentDistributions.
InvoicePaidOffDate Datetime The InvoicePaidOffDate column for the table ReceivablesDocumentDistributions.
IsDeleted Boolean The IsDeleted column for the table ReceivablesDocumentDistributions.
IsDirectDebitDocument Boolean The IsDirectDebitDocument column for the table ReceivablesDocumentDistributions.
IsElectronic Boolean The IsElectronic column for the table ReceivablesDocumentDistributions.
IsIntrastatDocument Boolean The IsIntrastatDocument column for the table ReceivablesDocumentDistributions.
IsVoided Boolean The IsVoided column for the table ReceivablesDocumentDistributions.
Id String The Id column for the table ReceivablesDocumentDistributions.
MiscellaneousAmountCurrency String The MiscellaneousAmountCurrency column for the table ReceivablesDocumentDistributions.
MiscellaneousAmount Decimal The MiscellaneousAmount column for the table ReceivablesDocumentDistributions.
MiscellaneousTaxScheduleId String The MiscellaneousTaxScheduleId column for the table ReceivablesDocumentDistributions.
ModifiedBy String The ModifiedBy column for the table ReceivablesDocumentDistributions.
ModifiedDate Datetime The ModifiedDate column for the table ReceivablesDocumentDistributions.
PostedBy String The PostedBy column for the table ReceivablesDocumentDistributions.
PostedDate Datetime The PostedDate column for the table ReceivablesDocumentDistributions.
SalesAmountCurrency String The SalesAmountCurrency column for the table ReceivablesDocumentDistributions.
SalesAmount Decimal The SalesAmount column for the table ReceivablesDocumentDistributions.
SalesTaxScheduleId String The SalesTaxScheduleId column for the table ReceivablesDocumentDistributions.
SalesTerritoryId String The SalesTerritoryId column for the table ReceivablesDocumentDistributions.
SalespersonId String The SalespersonId column for the table ReceivablesDocumentDistributions.
ShippingMethodId String The ShippingMethodId column for the table ReceivablesDocumentDistributions.
TaxAmountCurrency String The TaxAmountCurrency column for the table ReceivablesDocumentDistributions.
TaxAmount Decimal The TaxAmount column for the table ReceivablesDocumentDistributions.
TaxScheduleId String The TaxScheduleId column for the table ReceivablesDocumentDistributions.
TaxesReceivablesTaxAggregate String The TaxesReceivablesTaxAggregate column for the table ReceivablesDocumentDistributions.
TradeDiscountAmountCurrency String The TradeDiscountAmountCurrency column for the table ReceivablesDocumentDistributions.
TradeDiscountAmount Decimal The TradeDiscountAmount column for the table ReceivablesDocumentDistributions.
TransactionState String The TransactionState column for the table ReceivablesDocumentDistributions.
Type String The Type column for the table ReceivablesDocumentDistributions.
VoidDate Datetime The VoidDate column for the table ReceivablesDocumentDistributions.
ExtensionsExtensionAggregate String The ExtensionsExtensionAggregate column for the table ReceivablesDocumentDistributions.

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