Itemizations
Create, update, delete, and query all expense itemizations owned by the user.
Table Specific Information
Select
The add-in uses the SAP Concur APIs to process filters that refer to Id or to any combination of ReportID, EntryID, ExpenseTypeCode, and LoginId, as in the following queries. The add-in processes other filters client-side within the add-in.
For example, the following queries are processed server side:
SELECT * FROM Itemizations WHERE Id = 'sampleId' SELECT * FROM Itemizations WHERE ReportID = 'sampleReportID' AND EntryId = 'sampleEntryId' AND ExpenseTypeCode = 'code' AND LoginId = 'LoginId'
Insert
To insert an itemization the following columns are required: EntryId, ExpenseTypeCode, TransactionDate, and TransactionAmount.
INSERT INTO Itemizations (EntryId, ExpenseTypeCode, TransactionDate, TransactionAmount, IsBillable, IsPersonal, Custom1Value) VALUES ('EntryId', 'TAXIX', '01-01-2017', 1000, true, true, 'Custom1Value')
Update
To update an itemization, the following column is required: Id.
UPDATE Itemizations SET TransactionDate = '01-02-2017', TransactionAmount = 2000, IsBillable = false, IsPersonal = false, Custom1Value = 'Custom1Value' WHERE Id = '12345'
Delete
To delete an itemization, the following column is required: Id.
DELETE FROM Itemizations WHERE Id = '123456'
Columns
Name | Type | ReadOnly | References | Description |
ID [KEY] | String | True |
The primary key. | |
Custom10ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom11ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom12ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom13ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom14ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom15ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom16ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom17ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom18ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom19ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom1ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom20ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom21ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom22ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom23ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom24ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom25ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom26ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom27ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom28ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom29ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom2ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom30ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom31ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom32ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom33ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom34ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom35ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom36ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom37ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom38ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom39ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom3ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom40ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom4ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom5ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom6ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom7ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom8ListItemID | String | True |
For list fields, this is the list item ID. | |
Custom9ListItemID | String | True |
For list fields, this is the list item ID. | |
EntryID | String | False |
The ID of the expense entry that is the parent for the itemization. | |
LocationID | String | True |
The unique identifier for the location where the expense was incurred. | |
OrgUnit1ListItemID | String | True |
For list fields, this is the list item ID. | |
OrgUnit2ListItemID | String | True |
For list fields, this is the list item ID. | |
OrgUnit3ListItemID | String | True |
For list fields, this is the list item ID. | |
OrgUnit4ListItemID | String | True |
For list fields, this is the list item ID. | |
OrgUnit5ListItemID | String | True |
For list fields, this is the list item ID. | |
OrgUnit6ListItemID | String | True |
For list fields, this is the list item ID. | |
ReportID | String | True |
The ID of the report that is the parent for the itemization. | |
ReportOwnerID | String | True |
The login ID for the report owner. Use the GET User endpoint to learn details about this user. | |
AllocationType | String | True |
The type of allocation for the itemization. Possible values: P - partial allocation, F - full allocation, N - no allocation. | |
ApprovedAmount | Decimal | True |
The approved amount of the expense itemization, in the report currency. | |
Custom10Code | String | True |
For list fields, this is the list item code. | |
Custom10Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom10Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom11Code | String | True |
For list fields, this is the list item code. | |
Custom11Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom11Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom12Code | String | True |
For list fields, this is the list item code. | |
Custom12Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom12Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom13Code | String | True |
For list fields, this is the list item code. | |
Custom13Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom13Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom14Code | String | True |
For list fields, this is the list item code. | |
Custom14Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom14Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom15Code | String | True |
For list fields, this is the list item code. | |
Custom15Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom15Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom16Code | String | True |
For list fields, this is the list item code. | |
Custom16Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom16Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom17Code | String | True |
For list fields, this is the list item code. | |
Custom17Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom17Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom18Code | String | True |
For list fields, this is the list item code. | |
Custom18Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom18Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom19Code | String | True |
For list fields, this is the list item code. | |
Custom19Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom19Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom1Code | String | True |
For list fields, this is the list item code. | |
Custom1Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom1Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom20Code | String | True |
For list fields, this is the list item code. | |
Custom20Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom20Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom21Code | String | True |
For list fields, this is the list item code. | |
Custom21Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom21Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom22Code | String | True |
For list fields, this is the list item code. | |
Custom22Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom22Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom23Code | String | True |
For list fields, this is the list item code. | |
Custom23Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom23Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom24Code | String | True |
For list fields, this is the list item code. | |
Custom24Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom24Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom25Code | String | True |
For list fields, this is the list item code. | |
Custom25Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom25Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom26Code | String | True |
For list fields, this is the list item code. | |
Custom26Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom26Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom27Code | String | True |
For list fields, this is the list item code. | |
Custom27Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom27Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom28Code | String | True |
For list fields, this is the list item code. | |
Custom28Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom28Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom29Code | String | True |
For list fields, this is the list item code. | |
Custom29Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom29Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom2Code | String | True |
For list fields, this is the list item code. | |
Custom2Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom2Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom30Code | String | True |
For list fields, this is the list item code. | |
Custom30Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom30Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom31Code | String | True |
For list fields, this is the list item code. | |
Custom31Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom31Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom32Code | String | True |
For list fields, this is the list item code. | |
Custom32Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom32Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom33Code | String | True |
For list fields, this is the list item code. | |
Custom33Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom33Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom34Code | String | True |
For list fields, this is the list item code. | |
Custom34Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom34Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom35Code | String | True |
For list fields, this is the list item code. | |
Custom35Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom35Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom36Code | String | True |
For list fields, this is the list item code. | |
Custom36Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom36Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom37Code | String | True |
For list fields, this is the list item code. | |
Custom37Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom37Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom38Code | String | True |
For list fields, this is the list item code. | |
Custom38Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom38Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom39Code | String | True |
For list fields, this is the list item code. | |
Custom39Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom39Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom3Code | String | True |
For list fields, this is the list item code. | |
Custom3Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom3Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom40Code | String | True |
For list fields, this is the list item code. | |
Custom40Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom40Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom4Code | String | True |
For list fields, this is the list item code. | |
Custom4Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom4Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom5Code | String | True |
For list fields, this is the list item code. | |
Custom5Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom5Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom6Code | String | True |
For list fields, this is the list item code. | |
Custom6Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom6Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom7Code | String | True |
For list fields, this is the list item code. | |
Custom7Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom7Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom8Code | String | True |
For list fields, this is the list item code. | |
Custom8Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom8Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Custom9Code | String | True |
For list fields, this is the list item code. | |
Custom9Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
Custom9Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
Description | String | False |
The description of the expense. Maximum length: 64 characters | |
ExpenseTypeCode | String | False |
The code for the expense type. Use the GET ExpenseGroupConfigurations endpoint to learn the expense type code for expense types that are active for this report's policy. | |
ExpenseTypeName | String | True |
The name of the expense type, localized to the user's language. | |
HasComments | Bool | True |
Indicates whether the expense has comments. Use the GET ExpenseEntryComments endpoint to get information about this entry's comments. Format: true or false | |
HasExceptions | Bool | True |
Indicates whether the expense has exceptions. Format: true or false | |
IsBillable | Bool | False |
Indicates whether the itemization is billable. Format: true or false | |
IsImageRequired | Bool | True |
Indicates whether a receipt image is required for the entry. Format: true or false | |
IsPersonal | Bool | False |
Indicates whether the itemization is personal (that is, non-reimbursable). Format: true or false | |
LastModified | Datetime | True |
The UTC date when the itemization was last modified. | |
LocationCountry | String | True |
The country where the expense was incurred. Format: 2-letter ISO 3166-1 country code | |
LocationName | String | True |
The location where the expense was incurred, usually the city name. | |
LocationSubdivision | String | True |
The state, province, or other country subdivision where the expense was incurred. Format: ISO 3166-2:2007 country subdivision | |
OrgUnit1Code | String | True |
For list fields, this is the list item code. | |
OrgUnit1Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
OrgUnit1Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
OrgUnit2Code | String | True |
For list fields, this is the list item code. | |
OrgUnit2Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
OrgUnit2Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
OrgUnit3Code | String | True |
For list fields, this is the list item code. | |
OrgUnit3Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
OrgUnit3Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
OrgUnit4Code | String | True |
For list fields, this is the list item code. | |
OrgUnit4Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
OrgUnit4Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
OrgUnit5Code | String | True |
For list fields, this is the list item code. | |
OrgUnit5Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
OrgUnit5Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
OrgUnit6Code | String | True |
For list fields, this is the list item code. | |
OrgUnit6Type | String | True |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
OrgUnit6Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
PostedAmount | Decimal | True |
The amount of the expense itemization, in the report currency. | |
SpendCategoryCode | String | True |
The code for the spending category that is specified for this itemization. | |
SpendCategoryName | String | True |
The name of the spending category that is specified for this itemization, localized to the user's language. | |
TransactionAmount | Decimal | False |
The amount of the expense itemization, in the transaction currency of the parent expense entry. | |
TransactionDate | Datetime | False |
The date when the good or service associated with this itemization was provided. Format: YYYY-MM-DD | |
URI | String | True |
null |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
LoginId | String |
The login ID of the user who owns the itemizations. The user must have the Web Services Admin role to use this parameter. |