JDBC Driver for Microsoft Dynamics GP

Build 24.0.9062

SalesInvoice

Return a list of: SalesInvoice

Columns

Name Type ReadOnly Description
ExtensionsExtensionAggregate String False

ActualShipDate Datetime False

AuditTrailCode String False

BackorderDate Datetime False

BatchKeyCreatedDateTime Datetime False

BatchId String False

BatchKeySource String False

BillToAddressKeyCustomerId String False

BillToAddressId String False

Comment String False

CommentId String False

CommissionAmountCurrency String False

CommissionAmount Decimal False

CommissionBasedOn String False

CommissionSaleAmountCurrency String False

CommissionSaleAmount Decimal False

CommissionsAggregate String False

CreatedBy String False

CreatedDate Datetime False

CurrencyKeyISOCode String False

CustomerId String False

CustomerName String False

CustomerPONumber String False

Date Datetime False

DiscountAmountCurrency String False

DiscountAmount Decimal False

DocumentTypeId String False

DocumentTypeKeyType String False

ExchangeDate Datetime False

ExchangeRate Decimal False

FreightAmountCurrency String False

FreightAmount Decimal False

FreightTaxAmountCurrency String False

FreightTaxAmount Decimal False

FreightTaxBasis String False

FreightTaxScheduleId String False

FreightTaxesAggregate String False

FrontOfficeIntegrationId String False

FulfillDate Datetime False

IntegrationId String False

IntegrationSource Int False

InvoiceDate Datetime False

IsIntrastatDocument Bool False

IsVoided Bool False

Id [KEY] String False

LastModifiedDate Datetime False

LineTotalAmountCurrency String False

LineTotalAmount Decimal False

MasterNumber Int False

MiscellaneousAmountCurrency String False

MiscellaneousAmount Decimal False

MiscellaneousTaxAmountCurrency String False

MiscellaneousTaxAmount Decimal False

MiscellaneousTaxBasis String False

MiscellaneousTaxScheduleId String False

MiscellaneousTaxesAggregate String False

ModifiedDate Datetime False

Note String False

OriginalSalesDocumentId String False

OriginalSalesDocumentType String False

PaymentTermsId String False

PriceLevelId String False

ProcessHoldsAggregate String False

QuoteDate Datetime False

Reference String False

RequestedShipDate Datetime False

ReturnDate Datetime False

SalesTerritoryId String False

SalespersonId String False

ShipCompleteOnly Bool False

ShipToAddressExtensionsExtensionAggregate String False

ShipToAddressCity String False

ShipToAddressLine1 String False

ShipToAddressLine2 String False

ShipToAddressLine3 String False

ShipToAddressPostalCode String False

ShipToAddressState String False

ShipToAddressCountryRegion String False

ShipToAddressFaxCountryCode String False

ShipToAddressFaxExtension String False

ShipToAddressFax String False

ShipToAddressPhone1CountryCode String False

ShipToAddressPhone1Extension String False

ShipToAddressPhone1 String False

ShipToAddressPhone2CountryCode String False

ShipToAddressPhone2Extension String False

ShipToAddressPhone2 String False

ShipToAddressPhone3CountryCode String False

ShipToAddressPhone3Extension String False

ShipToAddressPhone3 String False

ShipToAddressCountryRegionCodeId String False

ShipToAddressContactPerson String False

ShipToAddressName String False

ShipToAddressKeyCustomerId String False

ShipToAddressId String False

ShippingMethodId String False

TaxAmountCurrency String False

TaxAmount Decimal False

TaxExemptNumber1 String False

TaxExemptNumber2 String False

TaxRegistrationNumber String False

TaxScheduleId String False

TaxesAggregate String False

TotalAmountCurrency String False

TotalAmount Decimal False

TrackingNumbersAggregate String False

TradeDiscountItem String False

TransactionState String False

Type String False

UPSZone String False

UserDefinedDate01 Datetime False

UserDefinedDate02 Datetime False

UserDefinedList01 String False

UserDefinedList02 String False

UserDefinedList03 String False

UserDefinedText01 String False

UserDefinedText02 String False

UserDefinedText03 String False

UserDefinedText04 String False

UserDefinedText05 String False

WarehouseId String False

DepositAmountCurrency String False

DepositAmount Decimal False

DistributionsAggregate String False

GeneralLedgerPostingDate Datetime False

IsDirectDebit Bool False

LinesAggregate String False

PaymentAmountCurrency String False

PaymentAmount Decimal False

PaymentsAggregate String False

PostedBy String False

PostedDate Datetime False

TermsDiscountItem String False

TermsDiscountAvailableAmountCurrency String False

TermsDiscountAvailableAmount Decimal False

TermsDiscountDate Datetime False

TermsDueDate Datetime False

TermsDiscountTakenAmountCurrency String False

TermsDiscountTakenAmount Decimal False

WorkflowPriority String False

WorkflowsAggregate String False

Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062