ExpenseReports
List of all expense reports.
Columns
| Name | Type | References | |
| Id [KEY] | Long | ||
| ReportName | String | ||
| ReportNumber | String | ||
| ProjectId | String | ||
| ProjectName | String | ||
| Description | String | ||
| Status | String | ||
| SubStatus | String | ||
| StartDate | Date | ||
| EndDate | Date | ||
| AccountingAppName | String | ||
| AccountingReferenceId | String | ||
| AccountingSyncTime | String | ||
| AmountPolicyViolationCount | Integer | ||
| AmountToBeReimbursed | Double | ||
| ApprovedDate | String | ||
| ApproverEmail | String | ||
| ApproverEmployeeNo | String | ||
| ApproverId | String | ||
| ApproverName | String | ||
| ApproverPhotoUrl | String | ||
| ApproverZuid | String | ||
| AuditStatus | String | ||
| CanPushToAccountingApp | Boolean | ||
| ClaimTypeId | String | ||
| ClaimTypeName | String | ||
| CommentsCount | Integer | ||
| CreatedById | String | ||
| CreatedByName | String | ||
| CreatedByZuid | String | ||
| CreatedDate | Date | ||
| CreatedTime | Datetime | ||
| CreatorEmployeeNo | String | ||
| CreatorPhotoUrl | String | ||
| CurrencyCode | String | ||
| CurrencyId | String | ||
| CustomFields | String | ||
| CustomPolicyViolationCount | Integer | ||
| CustomerId | String | ||
| CustomerName | String | ||
| DepartmentId | String | ||
| DepartmentName | String | ||
| DescriptionPolicyViolationCount | Integer | ||
| DueDate | String | ||
| DueDays | String | ||
| EmployeeNumber | String | ||
| ExpenseCount | Integer | ||
| IsAchReimbursement | Boolean | ||
| IsArchived | Boolean | ||
| IsInternationalTrip | String | ||
| IsSharedReport | Boolean | ||
| LastModifiedDate | Date | ||
| LastModifiedTime | Datetime | ||
| LastSubmittedDate | String | ||
| NonReimbursableTotal | Double | ||
| PolicyDisplayName | String | ||
| PolicyId | String | ||
| PolicyName | String | ||
| PolicyViolated | Boolean | ||
| RcyCurrencyCode | String | ||
| RcyCurrencyId | String | ||
| RcyCurrencySymbol | String | ||
| RcyExchangeRate | Double | ||
| RcyNonReimbursableTotal | Double | ||
| RcyPricePrecision | Integer | ||
| RcyReimbursableTotal | Double | ||
| RcyTotal | Double | ||
| ReceiptPolicyViolationCount | Integer | ||
| ReimbursableTotal | Double | ||
| ReimbursementDate | String | ||
| SubmittedBy | String | ||
| SubmittedDate | String | ||
| SubmittedToEmail | String | ||
| SubmittedToEmployeeNo | String | ||
| SubmittedToId | String | ||
| SubmittedToName | String | ||
| SubmittedToZuid | String | ||
| SubmitterEmail | String | ||
| SubmitterEmployeeNo | String | ||
| SubmitterName | String | ||
| SubmitterPhotoUrl | String | ||
| SubmitterZuid | String | ||
| Total | Double | ||
| TotalPolicyViolationCount | Integer | ||
| TripBudgetAmount | Double | ||
| TripBudgetAmountCurrencyCode | String | ||
| TripBudgetAmountCurrencyId | String | ||
| TripDeparture | String | ||
| TripDestinationCity | String | ||
| TripDestinationCountry | String | ||
| TripEndDate | String | ||
| TripId | String | ||
| TripName | String | ||
| TripNumber | String | ||
| TripStartDate | String | ||
| TripStatus | String | ||
| UncategorizedExpenseCount | Integer | ||
| UserCustomFields | String | ||
| UserEmail | String | ||
| UserId | String | ||
| UserName | String | ||
| UserPhotoUrl | String | ||
| ZcrmPotentialId | String | ||
| ZcrmPotentialName | String |