JDBC Driver for SAP Concur

Build 23.0.8839

ReportDetailsExpenseEntryItemization

Lists all itemizations of an expense entry

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 String The ID of the report entry. Maximum 13 characters.
ItemizationID [KEY] String The unique identifier for the itemization. Maximum 19 characters.
ItemType String The type of itemization. If the expense entry does not have any itemizations, this will be set to Regular. If the expense entry contains itemizations, each one will be set to Child.
ExpenseTypeID String The expense type ID for the itemization.
ExpenseTypeName String The expense type for the itemization. Maximum 64 characters.
TransactionDate Date The date of the transaction. Maximum 10 characters. Format: YYYY-MM-DD
TransactionAmount String The amount for the itemization in the expense currency. Maximum 23 characters.
PostedAmount String The amount for the itemization 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 itemization 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 business purpose field from the report header.
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.
Value String The value in the custom field. Maximum 48 characters.
Code String Custom list fields will include the list item code in this element.
HasComments String Whether the itemization has comments. Maximum 1 character. Format: Y/N
CommentCount String The number of comments associated with the itemization.
IsPersonal String Whether the itemization is personal. Maximum 1 character. Format: Y/N
LastModified Datetime The UTC date when the itemization was last modified. Maximum 19 characters. Format: YYYY-MM-DDThh:mm:ss

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