JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

SalesDocumentTrackingNumbers

The DynamicsGP table SalesDocumentTrackingNumbers.

Columns

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

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