ReportDetails
Retrieves the full set of information for the report.
Columns
| Name | Type | References | Description |
| ReportID [KEY] | String | The unique identifier for the report, which appears in the Concur Expense UI. Maximum 32 character varchar. | |
| UserLoginID | String | The user ID of the report owner. Maximum 128 characters. | |
| EmployeeName | String | The name of the employee who created the report. Maximum 66 characters. | |
| ReportKey | String | The unencrypted unique identifier for the report, that appears on the report header. The element appears only if the OAuth consumer has the Web Services Admin role in SAP Concur. Maximum 48 characters. | |
| ReportName | String | The name of the report. Maximum 40 characters. | |
| Purpose | String | The information from the Business Purpose field. | |
| ReportDate | Datetime | The date from the report header. Format: YYYY-MM-DDThh:mm:ss | |
| CreationDate | Datetime | The date the report was created. Format: YYYY-MM-DDThh:mm:ss | |
| SubmitDate | Date | The date the report was submitted. Maximum 10 characters. | |
| PaidDate | Datetime | The date the report was extracted for payment. Format: YYYY-MM-DDThh:mm:ss | |
| CurrencyCode | String | The 3-letter ISO 4217 currency code for the expense report currency. The expense report currency is defined as the report creator's default reimbursement currency. | |
| ReportTotal | Decimal | The total amount of the report. Maximum 23 characters. | |
| PersonalExpenses | Decimal | The total amount of expenses marked as personal. Maximum 23 characters. | |
| AmountDueEmployee | Decimal | The total amount due to the employee for the report. Maximum 23 characters. | |
| AmountDueCompanyCard | Decimal | The total amount due to the company card for the report. Maximum 23 characters. | |
| TotalClaimedAmount | Decimal | The total amount of all non-personal expenses in the report. Maximum 23 characters. | |
| TotalApprovedAmount | Decimal | The total amount of approved expenses in the report. Maximum 23 characters. | |
| ApprovalStatusCode | String | The approval status code for the report. | |
| ApprovalStatusName | String | The approval status name for the report. | |
| PaymentStatusCode | String | The unique identifier for the payment status of the report. | |
| PaymentStatusName | String | The payment status of the report. | |
| 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. | |
| LedgerName | String | The name of the expense report ledger. Maximum 20 characters. | |
| PolicyID | String | The unique identifier of the policy that applies to this report. Maximum 64 characters. | |
| EverSentBack | String | Whether the report has ever been sent back to the employee. Format: Y/N | |
| HasException | String | Whether the report has exceptions. Format: Y/N | |
| WorkflowActionURL | String | The URL to post a workflow action to the report using the Post Report Workflow Action function. | |
| Country | String | The report country. Maximum 2 characters. Format: The ISO 3166-1 alpha-2 country code. Example: United States is US. | |
| CountrySubdivision | String | The report country subdivision. Format: ISO 3166-2:2007 country subdivision. | |
| ProcessingPaymentDate | Date | The date that the report completed all approvals and was ready to be extracted for payment. Format: YYYY-MM-DD | |
| ReceiptsReceived | String | If Y, then this report has its receipt receipt confirmed by the Expense Processor. Format: Y/N | |
| ReportOwnerEmployeeCustom21 | String | The report owner's group ID. Maximum 48 characters. | |
| ReportOwnerEmployeeID | String | Employee ID often also serves as the employee's Vendor ID for AP system integrations or Payroll ID for Payroll integrations. Maximum 48 characters. | |
| ReportOwnerEmployeeOrgUnit1 | String | The report owner's organizational unit information. Maximum 48 characters for each field. | |
| ReportOwnerEmployeeOrgUnit2 | String | The report owner's organizational unit information. Maximum 48 characters for each field. | |
| ReportOwnerEmployeeOrgUnit3 | String | The report owner's organizational unit information. Maximum 48 characters for each field. | |
| ReportOwnerEmployeeOrgUnit4 | String | The report owner's organizational unit information. Maximum 48 characters for each field. | |
| ReportOwnerEmployeeOrgUnit5 | String | The report owner's organizational unit information. Maximum 48 characters for each field. | |
| ReportOwnerEmployeeOrgUnit6 | String | The report owner's organizational unit information. Maximum 48 characters for each field. | |
| ReportOwnerFirstName | String | The report owner's first name. Maximum 32 characters. | |
| ReportOwnerLastName | String | The report owner's last name. Maximum 32 characters. | |
| ReportOwnerMiddleInitial | String | The report owner's middle initial. Maximum 1 character. | |
| ReportOwnerReimbursementMethodCode | String | The report owner's reimbursement method code, as defined in the employee's Profile. | |
| EmployeeBankAccountBankNumber | String | The bank identification number entered on the Bank Information page. Maximum 11 characters. | |
| EmployeeBankAccountBankName | String | The bank name entered on the Bank Information page. Maximum 48 characters. | |
| EmployeeBankAccountBranchLocation | String | The branch location entered on the Bank Information page. Maximum 30 characters. | |
| EmployeeBankAccountAccountNumber | String | The bank account number entered on the Bank Information page. Maximum 100 characters. | |
| EmployeeBankAccountAccountName | String | The name on the account entered on the Bank Information page. | |
| EmployeeBankAccountPostalAddressLine1 | String | The postal address line 1 entered on the Bank Information page. Maximum 48 characters. | |
| EmployeeBankAccountPostalAddressLine2 | String | The postal address line 2 entered on the Bank Information page. Maximum 48 characters. | |
| EmployeeBankAccountPostalAddressCity | String | The postal address city entered on the Bank Information page. Maximum 24 characters. | |
| EmployeeBankAccountPostalAddressRegion | String | The postal address region entered on the Bank Information page. Maximum 24 characters. | |
| EmployeeBankAccountPostalAddressCode | String | The postal address code entered on the Bank Information page. Maximum 20 characters. | |
| EmployeeBankAccountPostalAddressCountry | String | The postal address country entered on the Bank Information page. Maximum 2 characters. Format: The ISO 3166-1 alpha-2 country code. Example: United States is US. |