ExpenseReportsExpense
ExpenseReportsExpense
Columns
| Name | Type | Description |
| ExpenseReportsExpenseReportId [KEY] | Long | ExpenseReportsExpenseReportId of ExpenseReportsExpense |
| AgencyName | String | AgencyName of ExpenseReportsExpense |
| AssignmentId | Long | AssignmentId of ExpenseReportsExpense |
| AuditAdjustmentReason | String | AuditAdjustmentReason of ExpenseReportsExpense |
| AuditAdjustmentReasonCode | String | AuditAdjustmentReasonCode of ExpenseReportsExpense |
| AwtGroupId | Long | AwtGroupId of ExpenseReportsExpense |
| BilledAmount | Decimal | BilledAmount of ExpenseReportsExpense |
| BilledCurrencyCode | String | BilledCurrencyCode of ExpenseReportsExpense |
| CardId | Long | CardId of ExpenseReportsExpense |
| CheckoutDate | Date | CheckoutDate of ExpenseReportsExpense |
| CreatedBy | String | CreatedBy of ExpenseReportsExpense |
| CreationDate | Datetime | CreationDate of ExpenseReportsExpense |
| CreditCardTrxnId | Long | CreditCardTrxnId of ExpenseReportsExpense |
| DailyAmount | Decimal | DailyAmount of ExpenseReportsExpense |
| DailyDistance | Decimal | DailyDistance of ExpenseReportsExpense |
| DailyLimit | String | DailyLimit of ExpenseReportsExpense |
| DepartureLocationId | Long | DepartureLocationId of ExpenseReportsExpense |
| Description | String | Description of ExpenseReportsExpense |
| DestinationFrom | String | DestinationFrom of ExpenseReportsExpense |
| DestinationTo | String | DestinationTo of ExpenseReportsExpense |
| DistanceUnitCode | String | DistanceUnitCode of ExpenseReportsExpense |
| EndDate | String | EndDate of ExpenseReportsExpense |
| EndDateTimestamp | Datetime | EndDateTimestamp of ExpenseReportsExpense |
| EndOdometer | Decimal | EndOdometer of ExpenseReportsExpense |
| ExchangeRate | Decimal | ExchangeRate of ExpenseReportsExpense |
| ExpenseCategoryCode | String | ExpenseCategoryCode of ExpenseReportsExpense |
| ExpenseCreationMethodCode | String | ExpenseCreationMethodCode of ExpenseReportsExpense |
| ExpenseId [KEY] | Long | ExpenseId of ExpenseReportsExpense |
| ExpenseReference | Int | ExpenseReference of ExpenseReportsExpense |
| ExpenseReportId | Long | ExpenseReportId of ExpenseReportsExpense |
| ExpenseSource | String | ExpenseSource of ExpenseReportsExpense |
| ExpenseTemplateId | Long | ExpenseTemplateId of ExpenseReportsExpense |
| ExpenseTypeCategoryCode | String | ExpenseTypeCategoryCode of ExpenseReportsExpense |
| ExpenseTypeId | Long | ExpenseTypeId of ExpenseReportsExpense |
| FlightClassLimit | String | FlightClassLimit of ExpenseReportsExpense |
| FlightDuration | Decimal | FlightDuration of ExpenseReportsExpense |
| FlightNumber | String | FlightNumber of ExpenseReportsExpense |
| FuelType | String | FuelType of ExpenseReportsExpense |
| ImageReceiptRequiredFlag | Bool | ImageReceiptRequiredFlag of ExpenseReportsExpense |
| ItemizationParentExpenseId | Long | ItemizationParentExpenseId of ExpenseReportsExpense |
| ItemizationReceiptBusinessTotalAmount | Decimal | ItemizationReceiptBusinessTotalAmount of ExpenseReportsExpense |
| ItemizationReceiptPersonalTotalAmount | Decimal | ItemizationReceiptPersonalTotalAmount of ExpenseReportsExpense |
| ItineraryReservationId | Long | ItineraryReservationId of ExpenseReportsExpense |
| Justification | String | Justification of ExpenseReportsExpense |
| JustificationRequiredFlag | Bool | JustificationRequiredFlag of ExpenseReportsExpense |
| LastUpdateDate | Datetime | LastUpdateDate of ExpenseReportsExpense |
| LastUpdateLogin | String | LastUpdateLogin of ExpenseReportsExpense |
| LastUpdatedBy | String | LastUpdatedBy of ExpenseReportsExpense |
| LicensePlateNumber | String | LicensePlateNumber of ExpenseReportsExpense |
| Location | String | Location of ExpenseReportsExpense |
| LocationId | Long | LocationId of ExpenseReportsExpense |
| LongTermTripFlag | Bool | LongTermTripFlag of ExpenseReportsExpense |
| LongTermTripStartDate | Date | LongTermTripStartDate of ExpenseReportsExpense |
| MerchantDocumentNumber | String | MerchantDocumentNumber of ExpenseReportsExpense |
| MerchantName | String | MerchantName of ExpenseReportsExpense |
| MerchantReference | String | MerchantReference of ExpenseReportsExpense |
| MerchantTaxRegNumber | String | MerchantTaxRegNumber of ExpenseReportsExpense |
| MerchantTaxpayerId | String | MerchantTaxpayerId of ExpenseReportsExpense |
| MileagePolicyId | Long | MileagePolicyId of ExpenseReportsExpense |
| NumberOfAttendees | Decimal | NumberOfAttendees of ExpenseReportsExpense |
| NumberOfDays | Int | NumberOfDays of ExpenseReportsExpense |
| NumberPeople | Int | NumberPeople of ExpenseReportsExpense |
| OrgId | Long | OrgId of ExpenseReportsExpense |
| PassengerAmount | Decimal | PassengerAmount of ExpenseReportsExpense |
| PassengerName | String | PassengerName of ExpenseReportsExpense |
| PassengerRateType | String | PassengerRateType of ExpenseReportsExpense |
| PaymentDueFromCode | String | PaymentDueFromCode of ExpenseReportsExpense |
| PersonId | Long | PersonId of ExpenseReportsExpense |
| PersonalReceiptAmount | Decimal | PersonalReceiptAmount of ExpenseReportsExpense |
| PolicyShortpayFlag | Bool | PolicyShortpayFlag of ExpenseReportsExpense |
| PolicyViolatedFlag | Bool | PolicyViolatedFlag of ExpenseReportsExpense |
| PolicyWarningFlag | Bool | PolicyWarningFlag of ExpenseReportsExpense |
| PolicyWarningReasonCode | String | PolicyWarningReasonCode of ExpenseReportsExpense |
| PreparerId | Long | PreparerId of ExpenseReportsExpense |
| RatePerPassenger | Decimal | RatePerPassenger of ExpenseReportsExpense |
| ReceiptAmount | Decimal | ReceiptAmount of ExpenseReportsExpense |
| ReceiptCurrencyCode | String | ReceiptCurrencyCode of ExpenseReportsExpense |
| ReceiptDate | Date | ReceiptDate of ExpenseReportsExpense |
| ReceiptMissingDecRequiredFlag | Bool | ReceiptMissingDecRequiredFlag of ExpenseReportsExpense |
| ReceiptMissingFlag | Bool | ReceiptMissingFlag of ExpenseReportsExpense |
| ReceiptRequiredFlag | Bool | ReceiptRequiredFlag of ExpenseReportsExpense |
| ReceiptVerifiedFlag | Bool | ReceiptVerifiedFlag of ExpenseReportsExpense |
| ReimbursableAmount | Decimal | ReimbursableAmount of ExpenseReportsExpense |
| ReimbursementCurrencyCode | String | ReimbursementCurrencyCode of ExpenseReportsExpense |
| SequenceNumber | Decimal | SequenceNumber of ExpenseReportsExpense |
| StartDate | Date | StartDate of ExpenseReportsExpense |
| StartDateTimestamp | Datetime | StartDateTimestamp of ExpenseReportsExpense |
| StartOdometer | Decimal | StartOdometer of ExpenseReportsExpense |
| TaxClassificationCode | String | TaxClassificationCode of ExpenseReportsExpense |
| TicketClassCode | String | TicketClassCode of ExpenseReportsExpense |
| TicketNumber | String | TicketNumber of ExpenseReportsExpense |
| TravelMethodCode | String | TravelMethodCode of ExpenseReportsExpense |
| TravelType | String | TravelType of ExpenseReportsExpense |
| TripDistance | Decimal | TripDistance of ExpenseReportsExpense |
| UOMDays | Decimal | UOMDays of ExpenseReportsExpense |
| ValidationErrorFlag | Bool | ValidationErrorFlag of ExpenseReportsExpense |
| ValidationErrorMessages | String | ValidationErrorMessages of ExpenseReportsExpense |
| ValidationWarningMessages | String | ValidationWarningMessages of ExpenseReportsExpense |
| VehicleCategoryCode | String | VehicleCategoryCode of ExpenseReportsExpense |
| VehicleType | String | VehicleType of ExpenseReportsExpense |
| ZoneCode | String | ZoneCode of ExpenseReportsExpense |
| ZoneTypeCode | String | ZoneTypeCode of ExpenseReportsExpense |
| BusinessUnit | String | BusinessUnit of ExpenseReportsExpense |
| PersonName | String | PersonName of ExpenseReportsExpense |
| ExpenseTemplate | String | ExpenseTemplate of ExpenseReportsExpense |
| ExpenseType | String | ExpenseType of ExpenseReportsExpense |
| ReceiptCurrency | String | ReceiptCurrency of ExpenseReportsExpense |
| ReimbursementCurrency | String | ReimbursementCurrency of ExpenseReportsExpense |
| DistanceUnit | String | DistanceUnit of ExpenseReportsExpense |
| TicketClass | String | TicketClass of ExpenseReportsExpense |
| ExpenseSourceName | String | ExpenseSourceName of ExpenseReportsExpense |
| ReferenceNumber | String | ReferenceNumber of ExpenseReportsExpense |
| Request | Long | Request of ExpenseReportsExpense |
| AttachmentExists | String | AttachmentExists of ExpenseReportsExpense |
| ExpenseReportStatus | String | ExpenseReportStatus of ExpenseReportsExpense |
| AuthTrxnNumber | String | AuthTrxnNumber of ExpenseReportsExpense |
| TravelTypeName | String | TravelTypeName of ExpenseReportsExpense |
| VehicleCategory | String | VehicleCategory of ExpenseReportsExpense |
| VehicleTypeName | String | VehicleTypeName of ExpenseReportsExpense |
| FuelTypeName | String | FuelTypeName of ExpenseReportsExpense |
| TaxClassification | String | TaxClassification of ExpenseReportsExpense |
| CountryCode | String | CountryCode of ExpenseReportsExpense |
| AutoSubmitDate | Datetime | AutoSubmitDate of ExpenseReportsExpense |
| ReceiptTime | Datetime | ReceiptTime of ExpenseReportsExpense |
| TipAmount | Decimal | TipAmount of ExpenseReportsExpense |
| VisitedFlag | Bool | VisitedFlag of ExpenseReportsExpense |
| ValidationStatus | String | ValidationStatus of ExpenseReportsExpense |
| PrepaidFlag | Bool | PrepaidFlag of ExpenseReportsExpense |
| Finder | String | Finder of ExpenseReportsExpense |
| SysEffectiveDate | String | SysEffectiveDate of ExpenseReportsExpense |