JDBC Driver for SAP Concur

Build 23.0.8839

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.

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