JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ProjectEmployeeExpenseLines

Return a list of: ProjectEmployeeExpenseLines

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 String
LinesExtensionsExtensionAggregate String
LinesAccruedRevenueCurrency String
LinesAccruedRevenue Decimal
LinesContraGLAccountId String
LinesContraGLAccountKeyIsEncrypted Bool
LinesCostCategoryId String
LinesCostOfGoodsSoldGLAccountId String
LinesCostOfGoodsSoldGLAccountKeyIsEncrypted Bool
LinesDate Datetime
LinesExtendedCostCurrency String
LinesExtendedCost Decimal
LinesMarkupPercent Decimal
LinesOriginalDocumentSequenceNumber Int
LinesOverheadAmountCurrency String
LinesOverheadAmount Decimal
LinesOverheadGLAccountId String
LinesOverheadGLAccountKeyIsEncrypted Bool
LinesOverheadPercent Decimal
LinesProfitAmountCurrency String
LinesProfitAmount Decimal
LinesProfitType String
LinesProjectContractId String
LinesProjectId String
LinesQuantity Decimal
LinesReferenceDocumentSequenceNumber Int
LinesRoundAmountCurrency String
LinesRoundAmount Decimal
LinesRoundingGLAccountId String
LinesRoundingGLAccountKeyIsEncrypted Bool
LinesTotalCostCurrency String
LinesTotalCost Decimal
LinesTotalOverheadAmountCurrency String
LinesTotalOverheadAmount Decimal
LinesTotalProfitAmountCurrency String
LinesTotalProfitAmount Decimal
LinesUnbilledAccountReceivableGLAccountId String
LinesUnbilledAccountReceivableGLAccountKeyIsEncrypted Bool
LinesUnbilledProjectRevenueGLAccountId String
LinesUnbilledProjectRevenueGLAccountKeyIsEncrypted Bool
LinesUnitCostCurrency String
LinesUnitCost Decimal
LinesUofM String
LinesWorkInProgressGLAccountId String
LinesWorkInProgressGLAccountKeyIsEncrypted Bool
LinesBackoutTaxAmountCurrency String
LinesBackoutTaxAmount Decimal
LinesBillingAmountCurrency String
LinesBillingAmount Decimal
LinesBillingProfitAmountCurrency String
LinesBillingProfitAmount Decimal
LinesBillingProfitPercent Decimal
LinesBillingQuantity Decimal
LinesBillingRateCurrency String
LinesBillingRate Decimal
LinesBillingStatus String
LinesBillingTaxAmountCurrency String
LinesBillingTaxAmount Decimal
LinesBillingType String
LinesDescription String
LinesExpenseType String
LinesKeyProjectEmployeeExpenseId [KEY] String
LinesKeySequenceNumber [KEY] Int
LinesPaymentMethodType String
LinesReimbursableAmountCurrency String
LinesReimbursableAmount Decimal
LinesTaxAmountCurrency String
LinesTaxAmount Decimal
LinesTaxBasis String
LinesTaxScheduleId String
LinesTaxesAggregate 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