JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ProjectEmployeeExpense

Return a list of: ProjectEmployeeExpense

Columns

Name Type Description
ExtensionsExtensionAggregate String
AuditTrailCode String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
Comment String
CreatedBy String
CreatedDate Datetime
CurrencyKeyISOCode String
Date Datetime
ExchangeDate Datetime
ExchangeRate Decimal
GeneralLedgerPostingDate Datetime
OriginalDocumentId String
PostedBy String
PostedDate Datetime
ReferenceDocumentNumber String
ReportSuffix String
TotalAccruedRevenueCurrency String
TotalAccruedRevenue Decimal
TotalCostCurrency String
TotalCost Decimal
TotalQuantity Decimal
TransactionState String
TransactionType String
UserDefined1 String
UserDefined2 String
UserId String
AddressId String
Amount1099Currency String
Amount1099 Decimal
ChargeAmountCurrency String
ChargeAmount Decimal
DistributionsAggregate String
DocumentAmountCurrency String
DocumentAmount Decimal
DoesPostToPayablesManagement Bool
EmployeeId String
EndDate Datetime
ExtendedCostCurrency String
ExtendedCost Decimal
FreightAmountCurrency String
FreightAmount Decimal
FreightTaxAmountCurrency String
FreightTaxAmount Decimal
FreightTaxBasis String
FreightTaxScheduleId String
IsTaxInvoiceReceived Bool
IsTaxInvoiceRequired Bool
Id [KEY] String
LinesAggregate String
MiscellaneousAmountCurrency String
MiscellaneousAmount Decimal
MiscellaneousTaxAmountCurrency String
MiscellaneousTaxAmount Decimal
MiscellaneousTaxBasis String
MiscellaneousTaxScheduleId String
PaymentCashAmountCurrency String
PaymentCashAmount Decimal
PaymentCashBankAccountId String
PaymentCashDate Datetime
PaymentCashNumber String
PaymentCashDocumentNumber String
PaymentCheckAmountCurrency String
PaymentCheckAmount Decimal
PaymentCheckBankAccountId String
PaymentCheckCheckNumber String
PaymentCheckDate Datetime
PaymentCheckNumber String
PaymentPaymentCardAmountCurrency String
PaymentPaymentCardAmount Decimal
PaymentPaymentCardDate Datetime
PaymentPaymentCardNumber String
PaymentPaymentCardReceiptNumber String
PaymentPaymentCardTypeId String
PaymentTermsId String
PersonalDataKeeperEmployeeId String
ReimbursableAmountCurrency String
ReimbursableAmount Decimal
ReimbursableTaxCurrency String
ReimbursableTax Decimal
ShippingMethodId String
StartDate Datetime
TaxAmountCurrency String
TaxAmount Decimal
TaxDate Datetime
TaxScheduleId String
TradeDiscountAmountCurrency String
TradeDiscountAmount Decimal
Unapplied1099AmountCurrency String
Unapplied1099Amount Decimal

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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462