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 |