ExpenseReportDetails
Details of an existing expense report.
Columns
| Name | Type | References | |
| ReportId [KEY] | Long | ||
| ReportName | String | ||
| ReportNumber | String | ||
| ReportStatuses | String | ||
| ProjectId | String | ||
| ProjectName | String | ||
| Description | String | ||
| Status | String | ||
| SubStatus | String | ||
| StartDate | Date | ||
| EndDate | Date | ||
| AccountingValidations | String | ||
| AdjustmentAmount | Double | ||
| AdvancePayments | String | ||
| AdvanceTotal | Double | ||
| AdvanceTotalWithCarryforward | Double | ||
| AmountPolicyViolationCount | Integer | ||
| AmountToBeRefunded | Double | ||
| AmountToBeReimbursed | Double | ||
| ApprovalName | String | ||
| ApprovalPath | String | ||
| ApproverDepartmentName | String | ||
| ApproverEmail | String | ||
| ApproverEmployeeNo | String | ||
| ApproverId | String | ||
| ApproverName | String | ||
| ApproverPhotoUrl | String | ||
| ApproverZuid | String | ||
| AuditImpactLevel | String | ||
| AuditInsights | String | ||
| AuditStatus | String | ||
| BalanceAdjustmentAmount | Double | ||
| CanCreateAdvance | Boolean | ||
| CanPushToAccountingApp | Boolean | ||
| CanReimburseViaAch | Boolean | ||
| CanReimburseViaIcici | Boolean | ||
| CanShowPaidThrough | Boolean | ||
| CarryforwardTotal | Integer | ||
| Carryforwards | String | ||
| CategorySummary | String | ||
| ClaimTypeId | String | ||
| ClaimTypeName | String | ||
| ClosedMarketRateWarning | String | ||
| CommentsCount | Integer | ||
| CreatedByEmail | String | ||
| CreatedByEmployeeNo | String | ||
| CreatedById | String | ||
| CreatedByName | String | ||
| CreatedByZuid | String | ||
| CreatedDate | Date | ||
| CreatedTime | Datetime | ||
| CreatorPhotoUrl | String | ||
| CurrenciesSummary | String | ||
| CurrencyCode | String | ||
| CurrencyId | String | ||
| CustomFields | String | ||
| CustomPolicyViolationCount | Integer | ||
| CustomerId | String | ||
| CustomerName | String | ||
| DenormalisedAmountToBeReimbursed | Double | ||
| DenormalisedRcyAmountToBeReimbursed | Double | ||
| DepartmentId | String | ||
| DepartmentName | String | ||
| DescriptionPolicyViolationCount | Integer | ||
| Documents | String | ||
| DueDate | Date | ||
| DueDays | String | ||
| EmployeeNumber | String | ||
| ExpenseCount | Integer | ||
| Expenses | String | ||
| ExpiredExpenseCount | Integer | ||
| FraudDetectionStatus | String | ||
| FraudImpactLevel | String | ||
| FraudInsights | String | ||
| GroupedExpenses | String | ||
| HasDuplicateExpense | Boolean | ||
| IciciPrimaryDepositaccountId | String | ||
| IsAdvancepaymentAllowed | Boolean | ||
| IsArchived | Boolean | ||
| IsClosedMarketRate | Boolean | ||
| IsInternationalTrip | Boolean | ||
| IsSharedReport | Boolean | ||
| LastModifiedTime | Datetime | ||
| LastSubmittedDate | Date | ||
| NextApproverEmail | String | ||
| NextApproverId | String | ||
| NextApproverName | String | ||
| NextApproverZuid | String | ||
| NonReimbursableExpensesCount | Integer | ||
| NonReimbursableTotal | Double | ||
| NoteToApprover | String | ||
| PersonalExcludedNonReimbursableAmount | Double | ||
| PersonalExpenseTotal | Double | ||
| PolicyDisplayName | String | ||
| PolicyId | String | ||
| PolicyName | String | ||
| PolicyViolated | Boolean | ||
| PolicyViolations | String | ||
| PreviousApproverDepartmentName | String | ||
| PreviousApproverEmployeeNo | String | ||
| PreviousApproverId | String | ||
| PreviousApproverName | String | ||
| PreviousApproverZuid | String | ||
| PricePrecision | Integer | ||
| RcyAppliedAdvanceTotal | Double | ||
| RcyCurrencyCode | String | ||
| RcyCurrencyId | String | ||
| RcyCurrencySymbol | String | ||
| RcyExchangeRate | Double | ||
| RcyNonReimbursableTotal | Double | ||
| RcyPersonalExcludedNonReimbursableAmount | Decimal | ||
| RcyPersonalExpenseTotal | Double | ||
| RcyPricePrecision | Integer | ||
| RcyRefundTotal | Double | ||
| RcyReimbursableTotal | Double | ||
| RcyReimbursedTotal | Double | ||
| RcySurchargeTotal | Double | ||
| RcyTotal | Double | ||
| RcyTotalExclusiveSurcharge | Double | ||
| ReceiptPolicyViolationCount | Integer | ||
| RefundsList | String | ||
| ReimbursableExpensesCount | Integer | ||
| ReimbursableTotal | Double | ||
| Reimbursements | String | ||
| RemainingReimbursementTotal | String | ||
| SubmittedBy | Long | ||
| SubmittedDate | Date | ||
| SubmittedToDepartmentName | String | ||
| SubmittedToEmail | String | ||
| SubmittedToEmployeeNo | String | ||
| SubmittedToId | String | ||
| SubmittedToName | String | ||
| SubmittedToPhotoUrl | String | ||
| SubmittedToZuid | String | ||
| SubmitterBankAccountAccountId | String | ||
| SubmitterBankAccountAccountType | String | ||
| SubmitterBankAccountLastFourDigits | String | ||
| SubmitterDepartmentName | String | ||
| SubmitterEmail | String | ||
| SubmitterEmployeeNo | String | ||
| SubmitterHrUrl | String | ||
| SubmitterName | String | ||
| SubmitterPhotoUrl | String | ||
| Tags | String | ||
| TodayDate | Date | ||
| Total | Double | ||
| TotalPolicyViolationCount | Integer | ||
| TravelPolicyFileName | String | ||
| TravelPolicyFileType | String | ||
| TripBudgetId | String | ||
| TripDeparture | String | ||
| TripDestinationCity | String | ||
| TripDestinationCountry | String | ||
| TripEndDate | String | ||
| TripId | String | ||
| TripName | String | ||
| TripNumber | String | ||
| TripStartDate | String | ||
| TripStatus | String | ||
| UncategorizedExpenseCount | Integer | ||
| UserDepartmentName | String | ||
| UserEmail | String | ||
| UserEmployeeNo | String | ||
| UserHrUrl | String | ||
| UserId | String | ||
| UserName | String | ||
| UserPhotoUrl | String | ||
| UserPolicyChangedMessage | String | ||
| WarnApprover | Boolean | ||
| ZcrmAccountId | String | ||
| ZcrmContactId | String | ||
| ZcrmPotentialId | String | ||
| ZcrmPotentialName | String | ||
| ZcrmSyncType | String | ||
| Zuid | String |