JDBC Driver for SAP Concur

Build 23.0.8839

Entries

Create, update, delete, and query all expense entries owned by the user.

テーブル固有の情報

Select

本製品 はSAP Concur API を使用して、ReportID、PaymentTypeID、BatchID_p、IsBillable、AttendeeTypeCode_p、HasAttendees、HasVAT、ExpenseTypeCode、またはAttendeeID_p を参照するフィルタを処理します。本製品 はクライアント側で本製品 内で他のフィルタを処理します。

例えば、次のクエリでは、本製品 はSAP Concur API に処理をオフロードします。

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

経費エントリを挿入するには、次のカラムが必要です:ReportId、ExpenseTypeCode、TransactionDate、PaymentTypeId、TransactionCurrencyCode、およびTransactionAmount。

INSERT INTO Entries (ReportId, ExpenseTypeCode, PaymentTypeId, TransactionCurrencyCode, TransactionAmount, TransactionDate) VALUES ('ReportIdValue', 'TAXIX', 'PaymentTypeIdValue', 'USD', 1000, '01-01-2017')

Update

経費エントリを更新するには、次のカラムが必要です:Id。

UPDATE Entries SET ReportId = 'ReportIdValue', ExpenseTypeCode = 'TAXIX', PaymentTypeId = 'PaymentTypeIdValue', TransactionCurrencyCode = 'USD', TransactionAmount = 100 WHERE Id = '12334'

Delete

経費エントリを削除するには、次のカラムが必要です:Id。

DELETE FROM Entries WHERE Id = '12345'

Columns

Name Type ReadOnly References 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. Use the GET User Information function to learn details about this user.

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. 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

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. 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

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 Datetime 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.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
AttendeeID_p String

The attendee associated with the entries to be retrieved.

AttendeeTypeCode_p String

The ID of the attendee type for the entries to be retrieved.

LoginId String

The login ID of the user who owns the entries. The user must have the Web Services Admin role to use this parameter.

BatchID_p String

The batch ID for the entries to be retrieved. The batch ID identifies the batch that contains the report payee associated with the entries. Use the GET Payment Batch function to learn the Payment Type ID for the desired Payment Type.

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