JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

SalesDocumentProcessHolds

The DynamicsGP table SalesDocumentProcessHolds.

Columns

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

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