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 |