Excel Add-In for Vault CRM

Build 25.0.9434

Expenses

Contains records of event- or user-related expenses submitted for reimbursement, including type, amount, justification, and approval workflow data.

Columns

Name Type ReadOnly Description
ID [KEY] String True

Unique identifier for the expense record, assigned automatically by the system.

Expense Type String True

Specifies the type of expense, such as travel, meals, lodging, or other business-related categories, based on predefined object types.

Global ID String True

System-generated global identifier used for cross-vault or system-wide uniqueness.

Link String False

URL or internal system reference linking to the detailed view of the expense record.

Expense Name String True

User-defined title or label that describes the expense entry in plain language.

Status String False

Indicates the current lifecycle state of the expense, such as Draft, Submitted, Approved, or Rejected.

Created By String True

Username or user ID of the person who initially created the expense entry in the system.

Created Date Datetime True

Timestamp indicating when the expense record was first created.

Last Modified By String True

Username or user ID of the person who last updated the expense entry.

Last Modified Date Datetime True

Timestamp of the most recent update to the expense record.

Amount Decimal False

Monetary value of the expense entered by the user, typically in the local currency.

Amount Corp Decimal True

Converted amount of the expense into the corporate default currency for consistent reporting.

Local Currency String False

Currency code (such as USD, EUR, GBP) used when the expense was incurred.

Call String False

Reference to the associated call activity record, if this expense was logged during a field interaction.

Concur Report ID String False

Identifier linking this expense to a corresponding report in the SAP Concur system.

Concur Report String False

Human-readable title or label of the Concur expense report associated with this record.

Concur Response Receipt Timestamp Datetime False

Timestamp marking when the system received a response from Concur regarding this expense entry.

Concur Response Timestamp Datetime False

Timestamp indicating when Concur processed and responded to the submitted expense data.

Concur Status String False

Current integration status with Concur, showing whether the expense is pending, accepted, rejected, or errored.

Concur System ID String False

System identifier used internally by Concur to uniquely reference this expense entry.

Concur System Receipt ID String False

Unique identifier for the receipt object as stored in the Concur system.

Description String False

User-provided explanation or justification for the expense, detailing its business purpose.

Expense Type2 String False

Alternate or system-level categorization of the expense type, potentially used for integration or reporting.

Mobile ID String False

Identifier used to track the expense if it was entered or submitted via a mobile device.

Override Lock Bool False

Indicates whether standard data locking rules are bypassed, allowing edits to a normally locked record.

Transaction Date Date False

Date on which the expense was incurred, typically reflecting the date shown on the receipt.

Owner String False

User ID of the person who owns or is primarily responsible for the expense entry.

Legacy CRM Id String False

Identifier from a legacy Customer Relationship Management (CRM) system used for mapping or data migration purposes.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434