JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

SalesDocumentMiscellaneousTaxes

The DynamicsGP table SalesDocumentMiscellaneousTaxes.

Columns

Name Type Description
MiscellaneousTaxesKeyTaxDetailId [KEY] String The MiscellaneousTaxesKeyTaxDetailId column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxesKeySequenceNumber [KEY] Int32 The MiscellaneousTaxesKeySequenceNumber column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxesKeySalesDocumentId [KEY] String The MiscellaneousTaxesKeySalesDocumentId column for the table SalesDocumentMiscellaneousTaxes.
ActualShipDate Datetime The ActualShipDate column for the table SalesDocumentMiscellaneousTaxes.
AuditTrailCode String The AuditTrailCode column for the table SalesDocumentMiscellaneousTaxes.
BackorderDate Datetime The BackorderDate column for the table SalesDocumentMiscellaneousTaxes.
BatchKeyCreatedDateTime Datetime The BatchKeyCreatedDateTime column for the table SalesDocumentMiscellaneousTaxes.
BatchId String The BatchId column for the table SalesDocumentMiscellaneousTaxes.
BatchKeySource String The BatchKeySource column for the table SalesDocumentMiscellaneousTaxes.
BillToAddressKeyCustomerId String The BillToAddressKeyCustomerId column for the table SalesDocumentMiscellaneousTaxes.
BillToAddressId String The BillToAddressId column for the table SalesDocumentMiscellaneousTaxes.
Comment String The Comment column for the table SalesDocumentMiscellaneousTaxes.
CommentId String The CommentId column for the table SalesDocumentMiscellaneousTaxes.
CommissionAmountCurrency String The CommissionAmountCurrency column for the table SalesDocumentMiscellaneousTaxes.
CommissionAmount Decimal The CommissionAmount column for the table SalesDocumentMiscellaneousTaxes.
CommissionBasedOn String The CommissionBasedOn column for the table SalesDocumentMiscellaneousTaxes.
CommissionSaleAmountCurrency String The CommissionSaleAmountCurrency column for the table SalesDocumentMiscellaneousTaxes.
CommissionSaleAmount Decimal The CommissionSaleAmount column for the table SalesDocumentMiscellaneousTaxes.
CommissionsSalesCommissionAggregate String The CommissionsSalesCommissionAggregate column for the table SalesDocumentMiscellaneousTaxes.
CreatedBy String The CreatedBy column for the table SalesDocumentMiscellaneousTaxes.
CreatedDate Datetime The CreatedDate column for the table SalesDocumentMiscellaneousTaxes.
CurrencyKeyISOCode String The CurrencyKeyISOCode column for the table SalesDocumentMiscellaneousTaxes.
CustomerId String The CustomerId column for the table SalesDocumentMiscellaneousTaxes.
CustomerName String The CustomerName column for the table SalesDocumentMiscellaneousTaxes.
CustomerPONumber String The CustomerPONumber column for the table SalesDocumentMiscellaneousTaxes.
Date Datetime The Date column for the table SalesDocumentMiscellaneousTaxes.
DiscountAmountCurrency String The DiscountAmountCurrency column for the table SalesDocumentMiscellaneousTaxes.
DiscountAmount Decimal The DiscountAmount column for the table SalesDocumentMiscellaneousTaxes.
DocumentTypeId String The DocumentTypeId column for the table SalesDocumentMiscellaneousTaxes.
DocumentTypeKeyType String The DocumentTypeKeyType column for the table SalesDocumentMiscellaneousTaxes.
ExchangeDate Datetime The ExchangeDate column for the table SalesDocumentMiscellaneousTaxes.
ExchangeRate Decimal The ExchangeRate column for the table SalesDocumentMiscellaneousTaxes.
FreightAmountCurrency String The FreightAmountCurrency column for the table SalesDocumentMiscellaneousTaxes.
FreightAmount Decimal The FreightAmount column for the table SalesDocumentMiscellaneousTaxes.
FreightTaxAmountCurrency String The FreightTaxAmountCurrency column for the table SalesDocumentMiscellaneousTaxes.
FreightTaxAmount Decimal The FreightTaxAmount column for the table SalesDocumentMiscellaneousTaxes.
FreightTaxBasis String The FreightTaxBasis column for the table SalesDocumentMiscellaneousTaxes.
FreightTaxScheduleId String The FreightTaxScheduleId column for the table SalesDocumentMiscellaneousTaxes.
FreightTaxesSalesDocumentTaxAggregate String The FreightTaxesSalesDocumentTaxAggregate column for the table SalesDocumentMiscellaneousTaxes.
FrontOfficeIntegrationId String The FrontOfficeIntegrationId column for the table SalesDocumentMiscellaneousTaxes.
FulfillDate Datetime The FulfillDate column for the table SalesDocumentMiscellaneousTaxes.
IntegrationId String The IntegrationId column for the table SalesDocumentMiscellaneousTaxes.
IntegrationSource Int32 The IntegrationSource column for the table SalesDocumentMiscellaneousTaxes.
InvoiceDate Datetime The InvoiceDate column for the table SalesDocumentMiscellaneousTaxes.
IsIntrastatDocument Boolean The IsIntrastatDocument column for the table SalesDocumentMiscellaneousTaxes.
IsVoided Boolean The IsVoided column for the table SalesDocumentMiscellaneousTaxes.
Id String The Id column for the table SalesDocumentMiscellaneousTaxes.
LastModifiedDate Datetime The LastModifiedDate column for the table SalesDocumentMiscellaneousTaxes.
LineTotalAmountCurrency String The LineTotalAmountCurrency column for the table SalesDocumentMiscellaneousTaxes.
LineTotalAmount Decimal The LineTotalAmount column for the table SalesDocumentMiscellaneousTaxes.
MasterNumber Int32 The MasterNumber column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousAmountCurrency String The MiscellaneousAmountCurrency column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousAmount Decimal The MiscellaneousAmount column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxAmountCurrency String The MiscellaneousTaxAmountCurrency column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxAmount Decimal The MiscellaneousTaxAmount column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxBasis String The MiscellaneousTaxBasis column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxScheduleId String The MiscellaneousTaxScheduleId column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxesGLAccountId String The MiscellaneousTaxesGLAccountId column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxesGLAccountKeyIsEncrypted Boolean The MiscellaneousTaxesGLAccountKeyIsEncrypted column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxesIsTaxableTax Boolean The MiscellaneousTaxesIsTaxableTax column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxesTotalTaxPotentialAmountCurrency String The MiscellaneousTaxesTotalTaxPotentialAmountCurrency column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxesTotalTaxPotentialAmount Decimal The MiscellaneousTaxesTotalTaxPotentialAmount column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxesIsBackoutTax Boolean The MiscellaneousTaxesIsBackoutTax column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxesTaxAmountCurrency String The MiscellaneousTaxesTaxAmountCurrency column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxesTaxAmount Decimal The MiscellaneousTaxesTaxAmount column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxesTaxableAmountCurrency String The MiscellaneousTaxesTaxableAmountCurrency column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxesTaxableAmount Decimal The MiscellaneousTaxesTaxableAmount column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxesTotalAmountCurrency String The MiscellaneousTaxesTotalAmountCurrency column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxesTotalAmount Decimal The MiscellaneousTaxesTotalAmount column for the table SalesDocumentMiscellaneousTaxes.
MiscellaneousTaxesExtensionsExtensionAggregate String The MiscellaneousTaxesExtensionsExtensionAggregate column for the table SalesDocumentMiscellaneousTaxes.
ModifiedDate Datetime The ModifiedDate column for the table SalesDocumentMiscellaneousTaxes.
Note String The Note column for the table SalesDocumentMiscellaneousTaxes.
OriginalSalesDocumentId String The OriginalSalesDocumentId column for the table SalesDocumentMiscellaneousTaxes.
OriginalSalesDocumentType String The OriginalSalesDocumentType column for the table SalesDocumentMiscellaneousTaxes.
PaymentTermsId String The PaymentTermsId column for the table SalesDocumentMiscellaneousTaxes.
PriceLevelId String The PriceLevelId column for the table SalesDocumentMiscellaneousTaxes.
ProcessHoldsSalesProcessHoldAggregate String The ProcessHoldsSalesProcessHoldAggregate column for the table SalesDocumentMiscellaneousTaxes.
QuoteDate Datetime The QuoteDate column for the table SalesDocumentMiscellaneousTaxes.
Reference String The Reference column for the table SalesDocumentMiscellaneousTaxes.
RequestedShipDate Datetime The RequestedShipDate column for the table SalesDocumentMiscellaneousTaxes.
ReturnDate Datetime The ReturnDate column for the table SalesDocumentMiscellaneousTaxes.
SalesTerritoryId String The SalesTerritoryId column for the table SalesDocumentMiscellaneousTaxes.
SalespersonId String The SalespersonId column for the table SalesDocumentMiscellaneousTaxes.
ShipCompleteOnly Boolean The ShipCompleteOnly column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressExtensionsExtensionAggregate String The ShipToAddressExtensionsExtensionAggregate column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressCity String The ShipToAddressCity column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressLine1 String The ShipToAddressLine1 column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressLine2 String The ShipToAddressLine2 column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressLine3 String The ShipToAddressLine3 column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressPostalCode String The ShipToAddressPostalCode column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressState String The ShipToAddressState column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressCountryRegion String The ShipToAddressCountryRegion column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressFaxCountryCode String The ShipToAddressFaxCountryCode column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressFaxExtension String The ShipToAddressFaxExtension column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressFax String The ShipToAddressFax column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressPhone1CountryCode String The ShipToAddressPhone1CountryCode column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressPhone1Extension String The ShipToAddressPhone1Extension column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressPhone1 String The ShipToAddressPhone1 column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressPhone2CountryCode String The ShipToAddressPhone2CountryCode column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressPhone2Extension String The ShipToAddressPhone2Extension column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressPhone2 String The ShipToAddressPhone2 column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressPhone3CountryCode String The ShipToAddressPhone3CountryCode column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressPhone3Extension String The ShipToAddressPhone3Extension column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressPhone3 String The ShipToAddressPhone3 column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressCountryRegionCodeId String The ShipToAddressCountryRegionCodeId column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressContactPerson String The ShipToAddressContactPerson column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressName String The ShipToAddressName column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressKeyCustomerId String The ShipToAddressKeyCustomerId column for the table SalesDocumentMiscellaneousTaxes.
ShipToAddressId String The ShipToAddressId column for the table SalesDocumentMiscellaneousTaxes.
ShippingMethodId String The ShippingMethodId column for the table SalesDocumentMiscellaneousTaxes.
TaxAmountCurrency String The TaxAmountCurrency column for the table SalesDocumentMiscellaneousTaxes.
TaxAmount Decimal The TaxAmount column for the table SalesDocumentMiscellaneousTaxes.
TaxExemptNumber1 String The TaxExemptNumber1 column for the table SalesDocumentMiscellaneousTaxes.
TaxExemptNumber2 String The TaxExemptNumber2 column for the table SalesDocumentMiscellaneousTaxes.
TaxRegistrationNumber String The TaxRegistrationNumber column for the table SalesDocumentMiscellaneousTaxes.
TaxScheduleId String The TaxScheduleId column for the table SalesDocumentMiscellaneousTaxes.
TaxesSalesDocumentTaxAggregate String The TaxesSalesDocumentTaxAggregate column for the table SalesDocumentMiscellaneousTaxes.
TotalAmountCurrency String The TotalAmountCurrency column for the table SalesDocumentMiscellaneousTaxes.
TotalAmount Decimal The TotalAmount column for the table SalesDocumentMiscellaneousTaxes.
TrackingNumbersSalesTrackingNumberAggregate String The TrackingNumbersSalesTrackingNumberAggregate column for the table SalesDocumentMiscellaneousTaxes.
TradeDiscountItem String The TradeDiscountItem column for the table SalesDocumentMiscellaneousTaxes.
TransactionState String The TransactionState column for the table SalesDocumentMiscellaneousTaxes.
Type String The Type column for the table SalesDocumentMiscellaneousTaxes.
UPSZone String The UPSZone column for the table SalesDocumentMiscellaneousTaxes.
UserDefinedDate01 Datetime The UserDefinedDate01 column for the table SalesDocumentMiscellaneousTaxes.
UserDefinedDate02 Datetime The UserDefinedDate02 column for the table SalesDocumentMiscellaneousTaxes.
UserDefinedList01 String The UserDefinedList01 column for the table SalesDocumentMiscellaneousTaxes.
UserDefinedList02 String The UserDefinedList02 column for the table SalesDocumentMiscellaneousTaxes.
UserDefinedList03 String The UserDefinedList03 column for the table SalesDocumentMiscellaneousTaxes.
UserDefinedText01 String The UserDefinedText01 column for the table SalesDocumentMiscellaneousTaxes.
UserDefinedText02 String The UserDefinedText02 column for the table SalesDocumentMiscellaneousTaxes.
UserDefinedText03 String The UserDefinedText03 column for the table SalesDocumentMiscellaneousTaxes.
UserDefinedText04 String The UserDefinedText04 column for the table SalesDocumentMiscellaneousTaxes.
UserDefinedText05 String The UserDefinedText05 column for the table SalesDocumentMiscellaneousTaxes.
WarehouseId String The WarehouseId column for the table SalesDocumentMiscellaneousTaxes.
ExtensionsExtensionAggregate String The ExtensionsExtensionAggregate column for the table SalesDocumentMiscellaneousTaxes.

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