JDBC Driver for SAP Concur

Build 23.0.8839

ReportDetailsExpenseEntryItemizationAttendee

Lists all allocations of an itemization

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 String The unique identifier for the itemization. Maximum 19 characters.
AttendeeID [KEY] String Attendee unique identifier within SAP Concur.
AttendeeType String The type of attendee. Maximum 40 characters.
FirstName String The attendee's first name. Maximum 50 characters.
LastName String The attendee's last name. Maximum 132 characters.
Company String The attendee's company name. Maximum 150 characters.
Title String The attendee's title. Maximum 32 characters.
ExternalID String The unique identifier for the attendee, managed outside SAP Concur. Maximum 48 characters.
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.
HasExceptionsPrevYear String Whether the attendee has exceptions in the previous year, based on yearly total limits for attendees. Maximum 1 character. Format: Y/N
HasExceptionsYTD String Whether the attendee has exceptions in the current year, based on yearly total limits for attendees. Maximum 1 character. Format: Y/N
IsDeleted String Whether the attendee is marked as deleted. Maximum 1 character. Format: Y/N
OwnerName String The name of the employee that owns the attendee record.
TotalAmountPrevYear String The total amount spent on the attendee in the previous calendar year.
TotalAmountYTD String The total amount spent on the attendee in the current calendar year.
VersionNumber String The attendee's version number.
AttendeeTypeCode String The unique identifier for the attendee type.
AttendeeOwnerID String The unique identifier for the person or system that owns the attendee.
CurrencyCode String The 3-letter ISO 4217 currency code for attendee related amounts.

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