JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

SalesDocumentFreightTaxes

The DynamicsGP table SalesDocumentFreightTaxes.

Columns

Name Type Description
FreightTaxesKeyTaxDetailId [KEY] String The FreightTaxesKeyTaxDetailId column for the table SalesDocumentFreightTaxes.
FreightTaxesKeySequenceNumber [KEY] Int32 The FreightTaxesKeySequenceNumber column for the table SalesDocumentFreightTaxes.
FreightTaxesKeySalesDocumentId [KEY] String The FreightTaxesKeySalesDocumentId column for the table SalesDocumentFreightTaxes.
ActualShipDate Datetime The ActualShipDate column for the table SalesDocumentFreightTaxes.
AuditTrailCode String The AuditTrailCode column for the table SalesDocumentFreightTaxes.
BackorderDate Datetime The BackorderDate column for the table SalesDocumentFreightTaxes.
BatchKeyCreatedDateTime Datetime The BatchKeyCreatedDateTime column for the table SalesDocumentFreightTaxes.
BatchId String The BatchId column for the table SalesDocumentFreightTaxes.
BatchKeySource String The BatchKeySource column for the table SalesDocumentFreightTaxes.
BillToAddressKeyCustomerId String The BillToAddressKeyCustomerId column for the table SalesDocumentFreightTaxes.
BillToAddressId String The BillToAddressId column for the table SalesDocumentFreightTaxes.
Comment String The Comment column for the table SalesDocumentFreightTaxes.
CommentId String The CommentId column for the table SalesDocumentFreightTaxes.
CommissionAmountCurrency String The CommissionAmountCurrency column for the table SalesDocumentFreightTaxes.
CommissionAmount Decimal The CommissionAmount column for the table SalesDocumentFreightTaxes.
CommissionBasedOn String The CommissionBasedOn column for the table SalesDocumentFreightTaxes.
CommissionSaleAmountCurrency String The CommissionSaleAmountCurrency column for the table SalesDocumentFreightTaxes.
CommissionSaleAmount Decimal The CommissionSaleAmount column for the table SalesDocumentFreightTaxes.
CommissionsSalesCommissionAggregate String The CommissionsSalesCommissionAggregate column for the table SalesDocumentFreightTaxes.
CreatedBy String The CreatedBy column for the table SalesDocumentFreightTaxes.
CreatedDate Datetime The CreatedDate column for the table SalesDocumentFreightTaxes.
CurrencyKeyISOCode String The CurrencyKeyISOCode column for the table SalesDocumentFreightTaxes.
CustomerId String The CustomerId column for the table SalesDocumentFreightTaxes.
CustomerName String The CustomerName column for the table SalesDocumentFreightTaxes.
CustomerPONumber String The CustomerPONumber column for the table SalesDocumentFreightTaxes.
Date Datetime The Date column for the table SalesDocumentFreightTaxes.
DiscountAmountCurrency String The DiscountAmountCurrency column for the table SalesDocumentFreightTaxes.
DiscountAmount Decimal The DiscountAmount column for the table SalesDocumentFreightTaxes.
DocumentTypeId String The DocumentTypeId column for the table SalesDocumentFreightTaxes.
DocumentTypeKeyType String The DocumentTypeKeyType column for the table SalesDocumentFreightTaxes.
ExchangeDate Datetime The ExchangeDate column for the table SalesDocumentFreightTaxes.
ExchangeRate Decimal The ExchangeRate column for the table SalesDocumentFreightTaxes.
FreightAmountCurrency String The FreightAmountCurrency column for the table SalesDocumentFreightTaxes.
FreightAmount Decimal The FreightAmount column for the table SalesDocumentFreightTaxes.
FreightTaxAmountCurrency String The FreightTaxAmountCurrency column for the table SalesDocumentFreightTaxes.
FreightTaxAmount Decimal The FreightTaxAmount column for the table SalesDocumentFreightTaxes.
FreightTaxBasis String The FreightTaxBasis column for the table SalesDocumentFreightTaxes.
FreightTaxScheduleId String The FreightTaxScheduleId column for the table SalesDocumentFreightTaxes.
FreightTaxesGLAccountId String The FreightTaxesGLAccountId column for the table SalesDocumentFreightTaxes.
FreightTaxesGLAccountKeyIsEncrypted Boolean The FreightTaxesGLAccountKeyIsEncrypted column for the table SalesDocumentFreightTaxes.
FreightTaxesIsTaxableTax Boolean The FreightTaxesIsTaxableTax column for the table SalesDocumentFreightTaxes.
FreightTaxesTotalTaxPotentialAmountCurrency String The FreightTaxesTotalTaxPotentialAmountCurrency column for the table SalesDocumentFreightTaxes.
FreightTaxesTotalTaxPotentialAmount Decimal The FreightTaxesTotalTaxPotentialAmount column for the table SalesDocumentFreightTaxes.
FreightTaxesIsBackoutTax Boolean The FreightTaxesIsBackoutTax column for the table SalesDocumentFreightTaxes.
FreightTaxesTaxAmountCurrency String The FreightTaxesTaxAmountCurrency column for the table SalesDocumentFreightTaxes.
FreightTaxesTaxAmount Decimal The FreightTaxesTaxAmount column for the table SalesDocumentFreightTaxes.
FreightTaxesTaxableAmountCurrency String The FreightTaxesTaxableAmountCurrency column for the table SalesDocumentFreightTaxes.
FreightTaxesTaxableAmount Decimal The FreightTaxesTaxableAmount column for the table SalesDocumentFreightTaxes.
FreightTaxesTotalAmountCurrency String The FreightTaxesTotalAmountCurrency column for the table SalesDocumentFreightTaxes.
FreightTaxesTotalAmount Decimal The FreightTaxesTotalAmount column for the table SalesDocumentFreightTaxes.
FreightTaxesExtensionsExtensionAggregate String The FreightTaxesExtensionsExtensionAggregate column for the table SalesDocumentFreightTaxes.
FrontOfficeIntegrationId String The FrontOfficeIntegrationId column for the table SalesDocumentFreightTaxes.
FulfillDate Datetime The FulfillDate column for the table SalesDocumentFreightTaxes.
IntegrationId String The IntegrationId column for the table SalesDocumentFreightTaxes.
IntegrationSource Int32 The IntegrationSource column for the table SalesDocumentFreightTaxes.
InvoiceDate Datetime The InvoiceDate column for the table SalesDocumentFreightTaxes.
IsIntrastatDocument Boolean The IsIntrastatDocument column for the table SalesDocumentFreightTaxes.
IsVoided Boolean The IsVoided column for the table SalesDocumentFreightTaxes.
Id String The Id column for the table SalesDocumentFreightTaxes.
LastModifiedDate Datetime The LastModifiedDate column for the table SalesDocumentFreightTaxes.
LineTotalAmountCurrency String The LineTotalAmountCurrency column for the table SalesDocumentFreightTaxes.
LineTotalAmount Decimal The LineTotalAmount column for the table SalesDocumentFreightTaxes.
MasterNumber Int32 The MasterNumber column for the table SalesDocumentFreightTaxes.
MiscellaneousAmountCurrency String The MiscellaneousAmountCurrency column for the table SalesDocumentFreightTaxes.
MiscellaneousAmount Decimal The MiscellaneousAmount column for the table SalesDocumentFreightTaxes.
MiscellaneousTaxAmountCurrency String The MiscellaneousTaxAmountCurrency column for the table SalesDocumentFreightTaxes.
MiscellaneousTaxAmount Decimal The MiscellaneousTaxAmount column for the table SalesDocumentFreightTaxes.
MiscellaneousTaxBasis String The MiscellaneousTaxBasis column for the table SalesDocumentFreightTaxes.
MiscellaneousTaxScheduleId String The MiscellaneousTaxScheduleId column for the table SalesDocumentFreightTaxes.
MiscellaneousTaxesSalesDocumentTaxAggregate String The MiscellaneousTaxesSalesDocumentTaxAggregate column for the table SalesDocumentFreightTaxes.
ModifiedDate Datetime The ModifiedDate column for the table SalesDocumentFreightTaxes.
Note String The Note column for the table SalesDocumentFreightTaxes.
OriginalSalesDocumentId String The OriginalSalesDocumentId column for the table SalesDocumentFreightTaxes.
OriginalSalesDocumentType String The OriginalSalesDocumentType column for the table SalesDocumentFreightTaxes.
PaymentTermsId String The PaymentTermsId column for the table SalesDocumentFreightTaxes.
PriceLevelId String The PriceLevelId column for the table SalesDocumentFreightTaxes.
ProcessHoldsSalesProcessHoldAggregate String The ProcessHoldsSalesProcessHoldAggregate column for the table SalesDocumentFreightTaxes.
QuoteDate Datetime The QuoteDate column for the table SalesDocumentFreightTaxes.
Reference String The Reference column for the table SalesDocumentFreightTaxes.
RequestedShipDate Datetime The RequestedShipDate column for the table SalesDocumentFreightTaxes.
ReturnDate Datetime The ReturnDate column for the table SalesDocumentFreightTaxes.
SalesTerritoryId String The SalesTerritoryId column for the table SalesDocumentFreightTaxes.
SalespersonId String The SalespersonId column for the table SalesDocumentFreightTaxes.
ShipCompleteOnly Boolean The ShipCompleteOnly column for the table SalesDocumentFreightTaxes.
ShipToAddressExtensionsExtensionAggregate String The ShipToAddressExtensionsExtensionAggregate column for the table SalesDocumentFreightTaxes.
ShipToAddressCity String The ShipToAddressCity column for the table SalesDocumentFreightTaxes.
ShipToAddressLine1 String The ShipToAddressLine1 column for the table SalesDocumentFreightTaxes.
ShipToAddressLine2 String The ShipToAddressLine2 column for the table SalesDocumentFreightTaxes.
ShipToAddressLine3 String The ShipToAddressLine3 column for the table SalesDocumentFreightTaxes.
ShipToAddressPostalCode String The ShipToAddressPostalCode column for the table SalesDocumentFreightTaxes.
ShipToAddressState String The ShipToAddressState column for the table SalesDocumentFreightTaxes.
ShipToAddressCountryRegion String The ShipToAddressCountryRegion column for the table SalesDocumentFreightTaxes.
ShipToAddressFaxCountryCode String The ShipToAddressFaxCountryCode column for the table SalesDocumentFreightTaxes.
ShipToAddressFaxExtension String The ShipToAddressFaxExtension column for the table SalesDocumentFreightTaxes.
ShipToAddressFax String The ShipToAddressFax column for the table SalesDocumentFreightTaxes.
ShipToAddressPhone1CountryCode String The ShipToAddressPhone1CountryCode column for the table SalesDocumentFreightTaxes.
ShipToAddressPhone1Extension String The ShipToAddressPhone1Extension column for the table SalesDocumentFreightTaxes.
ShipToAddressPhone1 String The ShipToAddressPhone1 column for the table SalesDocumentFreightTaxes.
ShipToAddressPhone2CountryCode String The ShipToAddressPhone2CountryCode column for the table SalesDocumentFreightTaxes.
ShipToAddressPhone2Extension String The ShipToAddressPhone2Extension column for the table SalesDocumentFreightTaxes.
ShipToAddressPhone2 String The ShipToAddressPhone2 column for the table SalesDocumentFreightTaxes.
ShipToAddressPhone3CountryCode String The ShipToAddressPhone3CountryCode column for the table SalesDocumentFreightTaxes.
ShipToAddressPhone3Extension String The ShipToAddressPhone3Extension column for the table SalesDocumentFreightTaxes.
ShipToAddressPhone3 String The ShipToAddressPhone3 column for the table SalesDocumentFreightTaxes.
ShipToAddressCountryRegionCodeId String The ShipToAddressCountryRegionCodeId column for the table SalesDocumentFreightTaxes.
ShipToAddressContactPerson String The ShipToAddressContactPerson column for the table SalesDocumentFreightTaxes.
ShipToAddressName String The ShipToAddressName column for the table SalesDocumentFreightTaxes.
ShipToAddressKeyCustomerId String The ShipToAddressKeyCustomerId column for the table SalesDocumentFreightTaxes.
ShipToAddressId String The ShipToAddressId column for the table SalesDocumentFreightTaxes.
ShippingMethodId String The ShippingMethodId column for the table SalesDocumentFreightTaxes.
TaxAmountCurrency String The TaxAmountCurrency column for the table SalesDocumentFreightTaxes.
TaxAmount Decimal The TaxAmount column for the table SalesDocumentFreightTaxes.
TaxExemptNumber1 String The TaxExemptNumber1 column for the table SalesDocumentFreightTaxes.
TaxExemptNumber2 String The TaxExemptNumber2 column for the table SalesDocumentFreightTaxes.
TaxRegistrationNumber String The TaxRegistrationNumber column for the table SalesDocumentFreightTaxes.
TaxScheduleId String The TaxScheduleId column for the table SalesDocumentFreightTaxes.
TaxesSalesDocumentTaxAggregate String The TaxesSalesDocumentTaxAggregate column for the table SalesDocumentFreightTaxes.
TotalAmountCurrency String The TotalAmountCurrency column for the table SalesDocumentFreightTaxes.
TotalAmount Decimal The TotalAmount column for the table SalesDocumentFreightTaxes.
TrackingNumbersSalesTrackingNumberAggregate String The TrackingNumbersSalesTrackingNumberAggregate column for the table SalesDocumentFreightTaxes.
TradeDiscountItem String The TradeDiscountItem column for the table SalesDocumentFreightTaxes.
TransactionState String The TransactionState column for the table SalesDocumentFreightTaxes.
Type String The Type column for the table SalesDocumentFreightTaxes.
UPSZone String The UPSZone column for the table SalesDocumentFreightTaxes.
UserDefinedDate01 Datetime The UserDefinedDate01 column for the table SalesDocumentFreightTaxes.
UserDefinedDate02 Datetime The UserDefinedDate02 column for the table SalesDocumentFreightTaxes.
UserDefinedList01 String The UserDefinedList01 column for the table SalesDocumentFreightTaxes.
UserDefinedList02 String The UserDefinedList02 column for the table SalesDocumentFreightTaxes.
UserDefinedList03 String The UserDefinedList03 column for the table SalesDocumentFreightTaxes.
UserDefinedText01 String The UserDefinedText01 column for the table SalesDocumentFreightTaxes.
UserDefinedText02 String The UserDefinedText02 column for the table SalesDocumentFreightTaxes.
UserDefinedText03 String The UserDefinedText03 column for the table SalesDocumentFreightTaxes.
UserDefinedText04 String The UserDefinedText04 column for the table SalesDocumentFreightTaxes.
UserDefinedText05 String The UserDefinedText05 column for the table SalesDocumentFreightTaxes.
WarehouseId String The WarehouseId column for the table SalesDocumentFreightTaxes.
ExtensionsExtensionAggregate String The ExtensionsExtensionAggregate column for the table SalesDocumentFreightTaxes.

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