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 |