ODBC Driver for SAP Concur

Build 23.0.8791

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8791