ReportDetailsExpenseEntry
Lists all expense entries
Columns
| Name | Type | References | Description |
| ReportID | String | The unique identifier for the report, which appears in the Concur Expense UI. Maximum 32 character varchar. | |
| ReportEntryID [KEY] | String | The ID of the report entry. Maximum 13 characters. | |
| ExpenseTypeID | String | The expense type ID for the expense entry. Expense Type IDs are returned in the ExpKey element by the Get Expense Group Configuration endpoint. | |
| ExpenseTypeName | String | The expense type name. Maximum 64 characters. | |
| SpendCategory | String | The spend category specified for this expense type. Varies by client, used in reporting. | |
| PaymentTypeCode | String | The code for the payment type. Maximum 4 characters. | |
| PaymentTypeName | String | The name for the payment type. Maximum 80 characters. | |
| TransactionDate | Date | The date of the expense entry. Maximum 10 characters. Format: YYYY-MM-DD | |
| TransactionCurrencyName | String | The name of the transaction currency. Example: US, Dollar | |
| ExchangeRate | String | The exchange rate that applies to the entry. Maximum 23 characters. | |
| TransactionAmount | String | The amount of the expense entry in the original transaction currency. Maximum 23 characters. | |
| PostedAmount | String | The amount of the expense entry in the user's reimbursement currency. The user's reimbursement currency is returned in the CrnCode element for the report. Maximum 23 characters. | |
| ApprovedAmount | String | The approved amount of the expense entry in the user's reimbursement currency.The user's reimbursement currency is returned in the CrnCode element for the report. Maximum 23 characters. | |
| BusinessPurpose | String | The text from the Business Purpose field of the entry. Maximum 64 characters. | |
| VendorDescription | String | The vendor name of the expense entry, which can be entered manually by the user or imported from the card transaction Merchant Name field. Maximum 64 characters. | |
| LocationName | String | The location for the expense entry, usually the city name. | |
| LocationSubdivision | String | The location's State, Province, or Country Subdivision. Maximum 6 characters. | |
| LocationCountry | String | The location's Country. Maximum 2 characters. | |
| OrgUnit1 | String | The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field. | |
| OrgUnit2 | String | The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field. | |
| OrgUnit3 | String | The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field. | |
| OrgUnit4 | String | The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field. | |
| OrgUnit5 | String | The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field. | |
| OrgUnit6 | String | The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field. | |
| Custom1Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom1Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom1Code | String | Custom list fields will include the list item code in this element. | |
| Custom2Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom2Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom2Code | String | Custom list fields will include the list item code in this element. | |
| Custom3Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom3Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom3Code | String | Custom list fields will include the list item code in this element. | |
| Custom4Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom4Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom4Code | String | Custom list fields will include the list item code in this element. | |
| Custom5Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom5Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom5Code | String | Custom list fields will include the list item code in this element. | |
| Custom6Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom6Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom6Code | String | Custom list fields will include the list item code in this element. | |
| Custom7Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom7Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom7Code | String | Custom list fields will include the list item code in this element. | |
| Custom8Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom8Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom8Code | String | Custom list fields will include the list item code in this element. | |
| Custom9Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom9Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom9Code | String | Custom list fields will include the list item code in this element. | |
| Custom10Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom10Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom10Code | String | Custom list fields will include the list item code in this element. | |
| Custom11Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom11Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom11Code | String | Custom list fields will include the list item code in this element. | |
| Custom12Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom12Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom12Code | String | Custom list fields will include the list item code in this element. | |
| Custom13Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom13Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom13Code | String | Custom list fields will include the list item code in this element. | |
| Custom14Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom14Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom14Code | String | Custom list fields will include the list item code in this element. | |
| Custom15Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom15Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom15Code | String | Custom list fields will include the list item code in this element. | |
| Custom16Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom16Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom16Code | String | Custom list fields will include the list item code in this element. | |
| Custom17Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom17Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom17Code | String | Custom list fields will include the list item code in this element. | |
| Custom18Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom18Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom18Code | String | Custom list fields will include the list item code in this element. | |
| Custom19Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom19Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom19Code | String | Custom list fields will include the list item code in this element. | |
| Custom20Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom20Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom20Code | String | Custom list fields will include the list item code in this element. | |
| Custom21Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom21Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom21Code | String | Custom list fields will include the list item code in this element. | |
| Custom22Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom22Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom22Code | String | Custom list fields will include the list item code in this element. | |
| Custom23Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom23Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom23Code | String | Custom list fields will include the list item code in this element. | |
| Custom24Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom24Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom24Code | String | Custom list fields will include the list item code in this element. | |
| Custom25Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom25Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom25Code | String | Custom list fields will include the list item code in this element. | |
| Custom26Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom26Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom26Code | String | Custom list fields will include the list item code in this element. | |
| Custom27Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom27Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom27Code | String | Custom list fields will include the list item code in this element. | |
| Custom28Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom28Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom28Code | String | Custom list fields will include the list item code in this element. | |
| Custom29Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom29Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom29Code | String | Custom list fields will include the list item code in this element. | |
| Custom30Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom30Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom30Code | String | Custom list fields will include the list item code in this element. | |
| Custom31Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom31Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom31Code | String | Custom list fields will include the list item code in this element. | |
| Custom32Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom32Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom32Code | String | Custom list fields will include the list item code in this element. | |
| Custom33Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom33Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom33Code | String | Custom list fields will include the list item code in this element. | |
| Custom34Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom34Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom34Code | String | Custom list fields will include the list item code in this element. | |
| Custom35Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom35Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom35Code | String | Custom list fields will include the list item code in this element. | |
| Custom36Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom36Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom36Code | String | Custom list fields will include the list item code in this element. | |
| Custom37Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom37Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom37Code | String | Custom list fields will include the list item code in this element. | |
| Custom38Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom38Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom38Code | String | Custom list fields will include the list item code in this element. | |
| Custom39Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom39Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom39Code | String | Custom list fields will include the list item code in this element. | |
| Custom40Type | String | The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom40Value | String | The value in the custom field. Maximum 48 characters. | |
| Custom40Code | String | Custom list fields will include the list item code in this element. | |
| FormID | String | The ID for the expense entry form. | |
| EntryImageID | String | The unique identifier for the image associated with the entry. | |
| HasVat | String | Whether the entry contains VAT data. Maximum 1 character. Format: Y/N | |
| HasComments | String | Whether the expense entry has comments. Maximum 1 character. Format: Y/N | |
| CommentCount | String | The number of comments associated with the expense entry. | |
| IsItemized | String | Whether the expense entry is itemized. Maximum 1 character. Format: Y/N | |
| HasExceptions | String | Whether the expense entry has exceptions. Maximum 1 character. Format: Y/N | |
| IsPersonal | String | Whether the expense entry is marked as personal. Maximum 1 character. Format: Y/N | |
| HasAttendees | String | Whether the expense entry has attendees. Maximum 1 character. Format: Y/N | |
| HasAllocation | String | Defines the amount of allocations for the expense. Maximum 1 character. Possible values are: P, for partial allocation, F, for full allocation, or N, for no allocation. | |
| IsCreditCardCharge | String | Whether the expense came from a credit card feed. Maximum 1 character. Format: Y/N | |
| IsPersonalCardCharge | String | Whether the expense came from a personal card feed. Maximum 1 character. Format: Y/N | |
| ReceiptRequired | String | Whether the original receipt is required for the entry. Maximum 1 character. Format: Y/N | |
| ImageRequired | String | Whether a receipt image is required for the entry. Maximum 1 character. Format: Y/N | |
| EReceiptID | String | The ID for the attached e-receipt, if available. | |
| LastModifiedDate | Datetime | The date the expense entry was last changed. Maximum 19 characters. Format: YYYY-MM-DDThh:mm:ss | |
| ReportEntryVendorName | String | Vendor name the employee selected from the Vendor list field. Maximum 64 characters. | |
| ReportEntryReceiptReceived | String | If Y, then this entry has been marked as reviewed by a processor. Maximum 1 character. Format: Y/N | |
| ReportEntryReceiptType | String | Maximum 1 character. One of these: T = tax receipt, R= regular receipt, N = no receipt | |
| CardTransactionAccountNumber | String | Credit card number used for this expense. This value is encrypted in the response. Maximum 255 characters. | |
| CardTransactionCardDescription | String | The name on the credit card used for this expense. Maximum 255 characters. | |
| CardTransactionCardTypeCode | String | Type of credit card. | |
| CardTransactionTransactionReferenceNumber | String | Reference number from the credit card vendor. Maximum 64 characters. | |
| CardTransactionTransactionCCTType | String | Transaction type supplied by card vendor. Maximum 3 characters. One of these: ANF = Annual Fees, CAV = Cash Advance, CCF = Cash and Check Fees, CHG = Other Bank Charges and Fees, FNC = Finance Charges, LAF = Late Fees, NSF = Insufficient Funds Check Fees, PAY = Payment, RPE = Credit Card Transaction | |
| CardTransactionTransactionID | String | Calculated value assigned to this card entry during the import process. Maximum 32 characters. | |
| CardTransactionTransactionAmount | String | Amount of the charge in the spend currency. Maximum 23 characters. | |
| CardTransactionTaxAmount | String | Amount of tax on the transaction amount (if provided by card vendor). Maximum 23 characters. | |
| CardTransactionTransactionAlphaCode | String | Currency code for the spend currency. Maximum 3 characters. Format: ISO 4217 3 digit alpha code | |
| CardTransactionPostedAmount | String | Amount of the charge in the billing currency of the card. Maximum 23 characters. | |
| CardTransactionPostedAlphaCode | String | Currency code for the card billing currency. Maximum 3 characters. Format: ISO 4217 3 digit alpha code | |
| CardTransactionTransactionDate | Date | Date the charge was made at the merchant. Maximum 10 characters. | |
| CardTransactionPostedDate | Date | Date the charge was posted to the credit card account. Maximum 10 characters. | |
| CardTransactionDescription | String | Description of the charge from the merchant. Maximum 42 characters. | |
| CardTransactionMasterCardCode | String | Merchant code sent from the credit card vendor. Maximum 5 characters. | |
| CardTransactionTransactionMerchantName | String | Name of the merchant. Maximum 50 characters. | |
| CardTransactionMerchantCity | String | Merchant city. Maximum 40 characters. | |
| CardTransactionMerchantState | String | Merchant State/Province. Maximum 32 characters. | |
| CardTransactionMerchantCountryCode | String | Merchant country location code. Format: 2 digit alpha code | |
| CardTransactionMerchantReferenceNumber | String | Merchant reference number passed from the merchant to the card. Maximum 15 characters. | |
| CardTransactionExchangeRateFromBillingToEmployeeCurrency | String | Currency exchange rate used between the credit card billing currency and the employee's reimbursement currency. Maximum 23 characters. | |
| CardTransactionBillingAmount | String | Amount due to the company card from the employee or company (depending on who is responsible for the bill) for this detail row. Maximum 23 characters. | |
| CardTransactionAccountNumberLastSegment | String | The last 4 digits of the Card Account. | |
| ExpensePay | String | Whether the entry was paid using the Expense Pay service. This element has a value if the report has reached the Processing Payment workflow step. Format: Yes/No |