Entries
Create, update, delete, and query all expense entries owned by the user.
Table Specific Information
Select
The add-in uses the SAP Concur APIs to process filters that refer to ReportID, PaymentTypeID, BatchID_p, IsBillable, AttendeeTypeCode_p, HasAttendees, HasVAT, ExpenseTypeCode, or AttendeeID_p. The add-in processes other filters client-side, within the add-in.For example, in the following query the add-in offloads the processing to the SAP Concur APIs:
SELECT * FROM Entries WHERE ReportID = 'IdReport' AND PaymentTypeID = 'IdPaymentType' AND BatchID_p = 'IdBatch' AND IsBillable = 'true' AND AttendeeTypeCode_p = '123' AND HasAttendees = 'true' AND HasVAT = 'false' AND ExpenseTypeCode = 'code' AND AttendeeID_p = 'IdAttendee'
Insert
To insert an entry the following columns are required: ReportId, ExpenseTypeCode, TransactionDate, PaymentTypeId, TransactionCurrencyCode, and TransactionAmount.
INSERT INTO Entries (ReportId, ExpenseTypeCode, PaymentTypeId, TransactionCurrencyCode, TransactionAmount, TransactionDate) VALUES ('ReportIdValue', 'TAXIX', 'PaymentTypeIdValue', 'USD', 1000, '01-01-2017')
Update
To update an entry the following column is required: Id.
UPDATE Entries SET ReportId = 'ReportIdValue', ExpenseTypeCode = 'TAXIX', PaymentTypeId = 'PaymentTypeIdValue', TransactionCurrencyCode = 'USD', TransactionAmount = 100 WHERE Id = '12334'
Delete
To delete an entry the following column is required: Id.
DELETE FROM Entries WHERE Id = '12345'
Columns
Name | Type | ReadOnly | Description |
ID [KEY] | String | True |
The unique identifier of the resource. |
CompanyCardTransactionID | String | True |
The unique identifier for a company card transaction that is associated with this expense. Concur Expense uses the Credit Card Import job to import company card transactions. Use the GET CommpanyCardTransactions function to get information about these card transactions. This element is null when there is no company card transaction associated with this expense. |
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. |
ElectronicReceiptID | String | True |
The unique identifier for an eReceipt that is associated with this expense. Use the GET eReceipts function to get information about this eReceipt. This element is null when there is no eReceipt associated with this expense. |
EmployeeBankAccountID | String | True |
The unique identifier of an employee bank account that is associated with this expense. Typically, this element is used when Expense Pay reimburses the employee for this expense. Use the GET BankAccounts function to get information about this bank account. |
FormID | String | True |
The ID of the form used by this expense entry. |
IsPaidByExpensePay | Bool | True |
Whether the entry is paid using the Expense Pay service. This element has a value if the report has reached the Processing Payment workflow step, because this is when Concur Expense determines whether it will be paid by Expense Pay. Format: true or false |
JourneyVehicleID | String | False |
The unique identifier for the vehicle used for this journey. This element is used only with Company Car configuration types. Use the GET Vehicles function to learn the Vehicle ID. |
LocationID | String | False |
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. |
PaymentTypeID | String | False |
The ID of the payment type for the entry. For mileage expenses, use the Cash payment type. For expense types with an expense code that uses a transaction amount instead of a distance, this element is required. This element should not be used for expense types with an expense code for Company Car or Personal Car, because these two expense codes always use the Cash payment type. |
ReportID | String | False |
The report ID of the report where the entry will be added. |
ReportOwnerID | String | True |
The login ID of the report owner. |
TripID | String | True |
The unique identifier of a trip in the Itinerary Service that includes a travel booking associated with this expense. Use GET ItineraryDetails to get information about this trip and the travel booking. This element is null when there is no trip associated with the expense. |
VendorListItemID | String | False |
The unique identifier for a vendor list item. |
AllocationType | String | True |
The type of allocations for the expense. Possible values: P - partial allocation, F - full allocation, N - no allocation. |
ApprovedAmount | Decimal | True |
The approved amount of the expense entry, in the report currency. |
Custom10Code | String | True |
For list fields, this is the list item code. |
Custom10Type | String | True |
The custom field type. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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 |
ExchangeRate | Decimal | False |
The currency conversion rate that converts the transaction amount that is in the transaction currency into the posted amount that is in the report currency. This element is typically not provided. If this element is empty for transactions in a currency different than the user's reimbursement currency, Expense will use the company's configured exchange rates to determine the posted amount for the transaction. If the system is not able to determine the exchange rate, a value of 1.0 will be used. |
ExpenseTypeCode | String | False |
The code for the expense type. |
ExpenseTypeName | String | True |
The name of the expense type, localized to the user's language. |
HasAppliedCashAdvance | Bool | True |
Whether the entry has a cash advance applied to it. Use the GET ExpenseEntryAccountingCalculations function to get cash advance application information for this entry. Format: true or false |
HasAttendees | Bool | True |
Indicates whether the expense has attendees. Format: true or false |
HasComments | Bool | True |
Whether the expense has comments. Use the GET ExpenseEntryComments function to get information about this entry's comments. Format: true or false |
HasExceptions | Bool | True |
Whether the expense has exceptions. Use the GET ExpenseEntryExceptions function to get information about this entry's exceptions. Format: true or false |
HasImage | Bool | True |
Indicates whether there is an entry image attached to the entry. Use the GET Entry Images function to get this entry image. Format: true or false |
HasItemizations | Bool | True |
Indicates whether the expense has itemizations. Use the Format: true or false |
HasVAT | Bool | True |
Indicates whether the entry has VAT data. Use the GET ExpenseEntryAccountingCalculations function to get VAT information for this entry. Format: true or false |
IsBillable | Bool | False |
Indicates whether the expense is billable. Format: true or false |
IsImageRequired | Bool | True |
Indicates whether an entry image is required for the entry. Format: true or false |
IsPersonal | Bool | False |
Indicates whether the expense is personal (that is, non-reimbursable). Format: true or false |
IsPersonalCardCharge | Bool | True |
Indicates whether the expense entry was imported from a personal card feed. Concur Expense uses the Yodlee API to import these card transactions. Format: true or false |
JourneyBusinessDistance | Int | False |
The portion of the journey for business use, in the report owner's unit of measure for distances. This element is required in order to post a personal car mileage expense entry, or to post a company car mileage expense when there is no PersonalDistance value. Format: positive integer. When using the Odometer elements, the sum of PersonalDistance and BusinessDistance must equal the difference between OdometerEnd and OdometerStart. |
JourneyEndLocation | String | False |
Indicates where the journey ended. This is also known as the |
JourneyNumberOfPassengers | Int | False |
The number of people in the vehicle during the journey. Positive Integer. Used with Variable-Rate, Personal or Company Car. |
JourneyOdometerEnd | Int | False |
The odometer reading at the end of the journey. Format: positive integer that must be greater than the OdometerStart value. This element is used with Variable-Rate and Company Car configuration types. |
JourneyOdometerStart | Int | False |
The odometer reading at the start of the journey. Format: positive integer. This element is used with Variable-Rate and Company Car configuration types. |
JourneyPersonalDistance | Int | False |
The portion of the journey for personal use. This element is required in order to post a company car mileage expense when there is no BusinessDistance value. Format: positive integer. When using the Odometer elements, the sum of PersonalDistance and BusinessDistance must equal the difference between OdometerEnd and OdometerStart. Used with Company Car configuration types. |
JourneyStartLocation | String | False |
Indicates where the journey started. This is also known as the |
JourneyUnitOfMeasure | String | False |
The unit of measure for distance and odometer values. Possible values: M - miles, K - kilometers |
LastModified | Datetime | True |
The UTC date when the entry 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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 |
PaymentTypeName | String | True |
The name of the payment type, localized to the user's language. |
PostedAmount | Decimal | True |
The amount of the expense entry, in the report currency. |
ReceiptReceived | Bool | True |
Indicates whether this entry has been reviewed by a processor. Format: true or false |
SpendCategoryCode | String | True |
The ID of the spending category that is specified for this expense entry. |
SpendCategoryName | String | True |
The name of the spending category that is specified for this expense entry, localized to the user's language. |
TaxReceiptType | String | False |
The receipt type for this entry. Possible values: T - tax receipt, R - regular receipt, N - no receipt |
TransactionAmount | Decimal | False |
The amount of the expense entry, in the transaction currency paid to the vendor. For expense types with an expense code that uses a transaction amount instead of a distance, this element is required. This element should not be used for expense types with an expense code for Company Car or Personal Car, because these two expense codes use a distance instead of a transaction amount. |
TransactionCurrencyCode | String | False |
The 3-letter ISO 4217 currency code for the expense entry transaction amount. This is the currency in which the vendor was paid. For expense types with an expense code that uses a transaction amount instead of a distance, this element is required. This element should not be used for expense types with an expense code for Company Car or Personal Car, because for these two expense codes the currency is always the Report Currency. |
TransactionDate | Date | False |
The date when the good or service associated with this expense entry was provided. Format: YYYY-MM-DD |
URI | String | True |
The URI to the resource. |
VendorDescription | String | False |
The name of the vendor for the expense entry. Maximum length: 64 characters |
VendorListItemName | String | True |
The name of an item from a vendor list. |
LoginId | String | False |
The login ID of the user who owns the entries. The user must have the Web Services Admin role to use this parameter. |